CREATE TABLE `think_course` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一性标识',
`gradeId` int(10) unsigned DEFAULT '0' COMMENT '年级',
`teacherId` int(10) unsigned DEFAULT '0' COMMENT '老师',
`profId` int(10) unsigned DEFAULT '0' COMMENT '专业',
`section` varchar(30) NOT NULL COMMENT '结次',
`section_date` varchar(30) NOT NULL COMMENT '授课日期',
`title` varchar(500) NOT NULL COMMENT '授课内容',
`note` varchar(1000) DEFAULT NULL COMMENT '授课要求',
`sort` smallint(5) unsigned DEFAULT '125' COMMENT '显示顺序',
`create_user` int(10) unsigned DEFAULT '0' COMMENT '添加人',
`create_time` int(10) unsigned DEFAULT '0' COMMENT '添加时间',
`update_user` int(10) unsigned DEFAULT '0' COMMENT '更新人',
`update_time` int(10) unsigned DEFAULT '0' COMMENT '更新时间',
`mark` tinyint(1) unsigned DEFAULT '1' COMMENT '有效标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='课程列表'


ALTER TABLE `tiyu_bigchun_com`.`think_clss`
    MODIFY COLUMN `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '特色班' AFTER `professional`
ALTER TABLE `tiyu_bigchun_com`.`think_clss`
    MODIFY COLUMN `features` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '特色班' AFTER `professional`
ALTER TABLE `tiyu_bigchun_com`.`think_clss`
    MODIFY COLUMN `features` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '特色班' AFTER `professional`

#ALTER TABLE `think_sport_record`
    ADD COLUMN `bmi`  varchar(30) NULL DEFAULT NULL COMMENT 'BMI指数' AFTER `rating`;

#ALTER TABLE `think_course`
    ADD COLUMN `classId`  int(10) NULL DEFAULT 0 COMMENT '班级' AFTER `gradeId`;

#ALTER TABLE `think_course`
    MODIFY COLUMN `section`  varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节次' AFTER `profId`;

ALTER TABLE `tiyu_bigchun_com`.`think_task`
    MODIFY COLUMN `class` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '所属班级' AFTER `superior`;

ALTER TABLE `tiyu_bigchun_com`.`think_task`
    MODIFY COLUMN `class` text NULL COMMENT '所属班级' AFTER `superior`;

ALTER TABLE `think_sport_record`
    ADD COLUMN `tiyu_class_string`  varchar(50) NULL DEFAULT NULL AFTER `tiyu_class`;

ALTER TABLE `think_sport_record`
    MODIFY COLUMN `score`  double(255,2) NULL DEFAULT NULL COMMENT '运动成绩' AFTER `hasTest`;

ALTER TABLE `think_match`
    MODIFY COLUMN `match_times`  varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '时长' AFTER `departmentsId`;