08. 开发电影分类管理功能

CREATE TABLE `category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '分类名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '电影分类' ROW_FORMAT = Dynamic;

INSERT INTO `category` VALUES (1, '喜剧');
INSERT INTO `category` VALUES (2, '战争');
INSERT INTO `category` VALUES (3, '历史');
INSERT INTO `category` VALUES (4, '科幻');
INSERT INTO `category` VALUES (5, '动作');
INSERT INTO `category` VALUES (6, '恐怖');
INSERT INTO `category` VALUES (7, '爱情');
INSERT INTO `category` VALUES (8, '动画');
INSERT INTO `category` VALUES (9, '剧情');