数据库语句如下
CREATE TABLE `video_category` (
`id` CHAR ( 19 ) NOT NULL COMMENT '类别ID',
`title` VARCHAR ( 10 ) NOT NULL COMMENT '类别名称',
`parent_id` CHAR ( 19 ) NOT NULL DEFAULT '0' COMMENT '父ID',
`sort` INT ( 10 ) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序字段',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY ( `id` ),
KEY `idx_parent_id` ( `parent_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMMENT = '科目分类';