hz/fe-manage
1
0
Fork 0
mirror of https://codeup.aliyun.com/67762337eccfc218f6110e0e/vue/fe-manage.git synced 2025-12-06 09:26:44 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
fe-manage/test
yuping 00c50a9e3c --fix 路径图整体修改
2023-02-16 13:08:35 +08:00

3105 lines
214 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE `boe_test`.`activity` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `id` bigint NOT NULL COMMENT '活动ID' FIRST;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`activity` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动名称' AFTER `id`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_notice` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动公告' AFTER `activity_name`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_explain` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动说明' AFTER `activity_notice`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_start_time` datetime NULL DEFAULT NULL COMMENT '活动开始时间' AFTER `activity_explain`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_end_time` datetime NULL DEFAULT NULL COMMENT '活动结束时间' AFTER `activity_start_time`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_duration` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动时长-分钟' AFTER `activity_end_time`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `activity_address` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '活动地址' AFTER `activity_duration`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `before_sign_in` int NULL DEFAULT NULL COMMENT '活动开始前多少分钟开始签到' AFTER `activity_address`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `after_sign_in` int NULL DEFAULT NULL COMMENT '活动开始后多少分钟结束签到' AFTER `before_sign_in`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `sign_out_time` timestamp NULL DEFAULT NULL COMMENT '签退开始时间' AFTER `after_sign_in`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `standard_settings` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标准设置 0-仅签到 1-签到和签退' AFTER `sign_out_time`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `standard_settings`;
ALTER TABLE `boe_test`.`activity` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.activity CHANGE activity_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`activity` DROP COLUMN `activity_flag`;
ALTER TABLE `boe_test`.`activity` DROP COLUMN `activity_tag`;
ALTER TABLE `boe_test`.`activity` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`activity` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`activity` ADD INDEX `ix_activity_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`admin_view` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`admin_view` DROP INDEX `admin_view_offcourse_id_IDX`;
ALTER TABLE `boe_test`.`admin_view` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`admin_view` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`admin_view` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`admin_view` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`admin_view` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`admin_view` MODIFY COLUMN `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `offcourse_id`;
ALTER TABLE `boe_test`.`admin_view` MODIFY COLUMN `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '1项目2在线课' AFTER `status`;
ALTER TABLE `boe_test`.`admin_view` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `type`;
ALTER TABLE `boe_test`.`admin_view` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`admin_view` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.admin_view CHANGE view_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`appraise` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `id` bigint NOT NULL COMMENT '评估ID' FIRST;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`appraise` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `appraise_name` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估的名称' AFTER `id`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `research_id` bigint NULL DEFAULT NULL COMMENT '评估类型ID' AFTER `appraise_name`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `research_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估类型的名称' AFTER `research_id`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `appraise_start_time` timestamp NULL DEFAULT NULL COMMENT '评估开始时间' AFTER `research_name`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `appraise_end_Time` timestamp NULL DEFAULT NULL COMMENT '评估结束时间' AFTER `appraise_start_time`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `appraise_explain` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估说明' AFTER `appraise_end_Time`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `appraise_explain`;
ALTER TABLE `boe_test`.`appraise` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.appraise CHANGE appraise_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`appraise` DROP COLUMN `appraise_flag`;
ALTER TABLE `boe_test`.`appraise` DROP COLUMN `appraise_tag`;
ALTER TABLE `boe_test`.`appraise` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`appraise` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `id` bigint NOT NULL COMMENT '评估ID' FIRST;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `assessment_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估名称' AFTER `id`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `assessment_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估的类型 1-单选 2-多选 3-评分 4-问答' AFTER `assessment_name`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `release_status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '1-待发布 2-已发布 3-已结束' AFTER `assessment_type`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `assessment_public_id` bigint NULL DEFAULT NULL COMMENT '公共Id-串联评估信息表的作用' AFTER `release_time`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `assessment_mark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估备注' AFTER `assessment_public_id`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `assessment_mark`;
ALTER TABLE `boe_test`.`assessment` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment CHANGE assessment_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `assessment_flag`;
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `assessment_tag`;
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`assessment` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`assessment` ADD INDEX `ix_assessment_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`assessment_multiple_choice` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `id` bigint NOT NULL COMMENT '多选选项ID' FIRST;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `multiple_option_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '多选选项名称' AFTER `id`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `multiple_stem_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '多选题干的名称' AFTER `multiple_option_name`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `multiple_option_picture_address` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '多选题选项照片名称' AFTER `multiple_stem_name`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `assessment_id` bigint NULL DEFAULT NULL COMMENT '评估主信息ID' AFTER `multiple_option_picture_address`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `question_type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `order_number` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '展示序号' AFTER `question_type`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `option_order_num` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项顺序' AFTER `order_number`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `option_order_num`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment_multiple_choice CHANGE multiple_option_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment_multiple_choice` DROP COLUMN `multiple_flag`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment_multiple_choice` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment_qa` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `id` bigint NOT NULL COMMENT '评估问答题Id' FIRST;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment_qa` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `assessment_qa_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估问答题标题' AFTER `id`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `assessment_qa_describe` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估问答题描述' AFTER `assessment_qa_title`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `question_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型' AFTER `assessment_qa_describe`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `order_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '展示序号' AFTER `question_type`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `assessment_id` bigint NULL DEFAULT NULL COMMENT '评估主信息ID' AFTER `order_number`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`assessment_qa` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment_qa CHANGE assessment_qa_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment_qa` DROP COLUMN `qa_flag`;
ALTER TABLE `boe_test`.`assessment_qa` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment_qa` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment_sc` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `id` bigint NOT NULL COMMENT '评估评分题Id' FIRST;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment_sc` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `assessment_sc_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估评分题标题' AFTER `id`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `question_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型' AFTER `assessment_sc_title`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `order_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '展示序号' AFTER `question_type`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `weight_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '整体评估' COMMENT '权重类型' AFTER `assessment_min_score`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `weight_scale` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权重比例' AFTER `weight_type`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `assessment_id` bigint NULL DEFAULT NULL COMMENT '评估主信息ID' AFTER `weight_scale`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`assessment_sc` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment_sc CHANGE assessment_sc_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment_sc` DROP COLUMN `sc_flag`;
ALTER TABLE `boe_test`.`assessment_sc` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment_sc` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment_single_choice` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `id` bigint NOT NULL COMMENT '单选选项ID' FIRST;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment_single_choice` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `single_option_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单选选项名称' AFTER `id`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `single_stem_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单选题干的名称' AFTER `single_option_name`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `single_option_picture_address` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单选题选项照片名称' AFTER `single_stem_name`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `assessment_id` bigint NULL DEFAULT NULL COMMENT '评估主信息ID' AFTER `single_option_picture_address`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `question_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `order_number` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '展示序号' AFTER `question_type`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `option_order_num` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项顺序' AFTER `order_number`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `option_order_num`;
ALTER TABLE `boe_test`.`assessment_single_choice` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment_single_choice CHANGE single_option_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment_single_choice` DROP COLUMN `single_flag`;
ALTER TABLE `boe_test`.`assessment_single_choice` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment_single_choice` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`assessment_submit` DROP INDEX `assessment_submit_assessment_id_IDX`;
ALTER TABLE `boe_test`.`assessment_submit` DROP INDEX `assessment_submit_target_id_IDX`;
ALTER TABLE `boe_test`.`assessment_submit` DROP INDEX `assessment_submit_chapter_or_stage_id_IDX`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '提交Id' FIRST;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `student_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `stu_id`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`assessment_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `assessment_id` bigint NULL DEFAULT NULL COMMENT '评估ID' AFTER `id`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `assessment_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评估名称' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `stu_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `assessment_name`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '评估结果' AFTER `student_name`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `target_id` bigint NULL DEFAULT NULL COMMENT '项目、路径、开课Id' AFTER `result`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `chapter_or_stage_id` bigint NULL DEFAULT NULL COMMENT '关卡或者阶段Id' AFTER `target_id`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '1-路径图 2-项目 3-开课 4-直播' AFTER `chapter_or_stage_id`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `begin_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间' AFTER `task_id`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `begin_time`;
ALTER TABLE `boe_test`.`assessment_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.assessment_submit CHANGE assessment_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`assessment_submit` DROP COLUMN `stu_name`;
ALTER TABLE `boe_test`.`assessment_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`assessment_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`assessment_submit` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`assessment_submit` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`assessment_submit` ADD INDEX `ix_assessment_ass`(`assessment_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`assessment_submit` ADD INDEX `ix_assessment_cha`(`chapter_or_stage_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`assessment_submit` ADD INDEX `ix_assessment_stu`(`stu_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`assessment_submit` ADD INDEX `ix_assessment_tar`(`target_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`boe_course` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_create_aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `id`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_create_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `sys_create_aid`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_update_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `deleted`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `audit_aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `sys_version`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `audit_info` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `audit_aid`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `company_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `comments`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `cover_img` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `company_id`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `enable_remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `device`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `for_scene` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `favorites`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `for_users` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `for_scene`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `fulltext_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `for_users`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `keywords` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `is_top`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `kid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `keywords`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL AFTER `kid`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `open_object` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `open_course`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `org_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `order_study`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `overview` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL AFTER `org_id`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `pass_formula` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `overview`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `res_owner1` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `published`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `res_owner2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `res_owner1`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `res_owner3` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `res_owner2`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `score_formula` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `score`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `summary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `studys`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_type1` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `summary`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_type2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `sys_type1`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `sys_type3` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `sys_type2`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `tags` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `sys_type3`;
ALTER TABLE `boe_test`.`boe_course` MODIFY COLUMN `value` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `type`;
CREATE TABLE `boe_test`.`boe_exam_alone` (
`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`sys_create_aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`sys_create_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`sys_create_time` datetime NULL DEFAULT NULL,
`aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`end_time` datetime NULL DEFAULT NULL,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`passline` int NULL DEFAULT NULL,
`score` float NULL DEFAULT NULL,
`start_time` datetime NULL DEFAULT NULL,
`status` int NULL DEFAULT NULL,
`task_time` datetime NULL DEFAULT NULL,
`test_duration` int NULL DEFAULT NULL,
`test_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`test_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`times` int NULL DEFAULT NULL,
`ucode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = COMPACT;
CREATE TABLE `boe_test`.`boe_exam_alone_answer` (
`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`sys_create_aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`sys_create_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`sys_create_time` datetime NULL DEFAULT NULL,
`aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`answer_json` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`arrange` int NULL DEFAULT NULL,
`client_info` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`client_ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`end_time` datetime NULL DEFAULT NULL,
`last_time` datetime NULL DEFAULT NULL,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`paper_json` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`passline` int NULL DEFAULT NULL,
`real_score` float NULL DEFAULT NULL,
`score` float NULL DEFAULT NULL,
`start_time` datetime NULL DEFAULT NULL,
`status` int NULL DEFAULT NULL,
`task_time` datetime NULL DEFAULT NULL,
`test_duration` int NULL DEFAULT NULL,
`test_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`test_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`total_score` float NULL DEFAULT NULL,
`ucode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`use_second` int NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = COMPACT;
CREATE TABLE `boe_test`.`boe_study_course` (
`id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`add_time` datetime NULL DEFAULT NULL,
`aid` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`aname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`course_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`course_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`course_type` int NOT NULL,
`finish_time` datetime NULL DEFAULT NULL,
`last_score` float NULL DEFAULT NULL,
`last_time` datetime NULL DEFAULT NULL,
`progress` float NULL DEFAULT NULL,
`remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`source` int NULL DEFAULT NULL,
`start_time` datetime NULL DEFAULT NULL,
`status` int NULL DEFAULT NULL,
`status_time` datetime NULL DEFAULT NULL,
`total_duration` int NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = COMPACT;
ALTER TABLE `boe_test`.`case_relation` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`case_relation` DROP INDEX `third_case_id_idx`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `id` bigint NOT NULL COMMENT '案例课Id' FIRST;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `third_case_id`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`case_relation` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`case_relation` MODIFY COLUMN `third_case_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '三方的案例Id' AFTER `id`;
ALTER TABLE `boe_test`.case_relation CHANGE case_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`case_relation` ADD INDEX `ix_cate_relation_thi`(`third_case_id` ASC) USING BTREE;
CREATE TABLE `boe_test`.`certificate` (
`id` int NOT NULL AUTO_INCREMENT,
`pid` bigint NULL DEFAULT NULL COMMENT 'pid',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
`type` int NULL DEFAULT NULL COMMENT '1项目 2面授课 3路径',
`finish_type` int NULL DEFAULT NULL COMMENT '完成类型',
`finish_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '完成条件值',
`status` int NULL DEFAULT 0,
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '说明',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_certificate_cre`(`create_time` DESC) USING BTREE,
INDEX `ix_certificate_pid`(`pid` DESC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '证书表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `boe_test`.`collection` (
`id` bigint NOT NULL AUTO_INCREMENT,
`user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
`user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户姓名',
`user_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户事业',
`user_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户组织名称',
`user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
`target_id` bigint NULL DEFAULT NULL COMMENT '目标id',
`type` int NULL DEFAULT NULL COMMENT '类型 1 讨论 2 发帖 3 评论',
`status` int NULL DEFAULT 0,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_praise_cre`(`create_time` DESC) USING BTREE,
INDEX `ix_praise_tar`(`target_id` DESC) USING BTREE,
INDEX `ix_praise_use`(`user_id` DESC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户点赞表' ROW_FORMAT = DYNAMIC;
ALTER TABLE `boe_test`.`comment` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `student_id` bigint NULL DEFAULT NULL COMMENT '用户id' AFTER `content`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `student_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `student_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户事业' AFTER `student_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `student_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户组织名称' AFTER `student_job_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `student_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `student_org_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `target_student_id` bigint NULL DEFAULT NULL COMMENT '目标用户id' AFTER `target_id`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `target_student_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '目标用户' AFTER `target_student_id`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `target_student_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '目标用户' AFTER `target_student_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `target_student_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '目标用户' AFTER `target_student_job_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `target_student_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `target_student_org_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`comment` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`comment` MODIFY COLUMN `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容' AFTER `id`;
ALTER TABLE `boe_test`.`comment` MODIFY COLUMN `img` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片' AFTER `type`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `user_id`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `user_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `user_job_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `user_org_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `user_avatar`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `target_user_id`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `target_user_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `target_job_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `target_org_name`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `target_user_avatar`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `ctime`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `mtime`;
ALTER TABLE `boe_test`.`comment` DROP COLUMN `delete`;
ALTER TABLE `boe_test`.`comment` ADD INDEX `ix_comment_com`(`comment_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`comment` ADD INDEX `ix_comment_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`comment` ADD INDEX `ix_comment_pid`(`pid` DESC) USING BTREE;
ALTER TABLE `boe_test`.`comment` ADD INDEX `ix_comment_stu`(`student_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`comment` ADD INDEX `ix_comment_tar`(`target_id` DESC) USING BTREE;
CREATE TABLE `boe_test`.`dict` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
`pid` bigint NULL DEFAULT 0 COMMENT '上级id',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编号',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
`value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '值',
`img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图片-支持多张',
`type` int NULL DEFAULT 0 COMMENT '类型 1 类型 2 字典详情',
`level` int NULL DEFAULT 0 COMMENT '层级',
`status` int NULL DEFAULT 0 COMMENT '状态 0 启用 1停用',
`sort` int NULL DEFAULT 0 COMMENT '排序',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_dict_code`(`code` ASC) USING BTREE,
INDEX `ix_dict_cre`(`create_time` DESC) USING BTREE,
INDEX `ix_dict_pid`(`pid` DESC) USING BTREE,
INDEX `ix_dict_sor`(`sort` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典表' ROW_FORMAT = DYNAMIC;
ALTER TABLE `boe_test`.`discuss` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `id` bigint NOT NULL COMMENT '讨论ID' FIRST;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`discuss` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `discuss_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '讨论名称公告' AFTER `project_id`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `discuss_explain` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '讨论说明' AFTER `discuss_name`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `discuss_settings` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '讨论设置' AFTER `discuss_explain`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `praise_num` bigint NULL DEFAULT 0 COMMENT '点赞数' AFTER `discuss_settings`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `collection_num` bigint NULL DEFAULT 0 COMMENT '收藏数' AFTER `praise_num`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `collection_num`;
ALTER TABLE `boe_test`.`discuss` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.discuss CHANGE discuss_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`discuss` DROP COLUMN `discuss_flag`;
ALTER TABLE `boe_test`.`discuss` DROP COLUMN `discuss_tag`;
ALTER TABLE `boe_test`.`discuss` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`discuss` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`discuss` ADD INDEX `ix_discuss_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`discuss` ADD INDEX `ix_discuss_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`discuss_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '讨论发表帖子的信息主键Id' FIRST;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `student_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `student_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`discuss_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_id` bigint NULL DEFAULT NULL COMMENT '讨论的话题Id' AFTER `student_name`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_submit_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票任务名称' AFTER `discuss_id`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_submit_content` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '讨论的话题的内容' AFTER `discuss_submit_title`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_submit_picture_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发表帖子上传的图片地址' AFTER `discuss_submit_content`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_review_count` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '帖子评论的数量' AFTER `discuss_submit_picture_address`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_like_count` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发表的帖子点赞的数量' AFTER `discuss_review_count`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `discuss_collection_count` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发表的帖子收藏的数量' AFTER `discuss_like_count`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `discuss_collection_count`;
ALTER TABLE `boe_test`.`discuss_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.discuss_submit CHANGE discuss_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`discuss_submit` DROP COLUMN `stu_id`;
ALTER TABLE `boe_test`.`discuss_submit` DROP COLUMN `stu_name`;
ALTER TABLE `boe_test`.`discuss_submit` DROP COLUMN `discuss_flag`;
ALTER TABLE `boe_test`.`discuss_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`discuss_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`discuss_submit` ADD INDEX `ix_discuss_submit_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`discuss_submit` ADD INDEX `ix_discuss_submit_stu`(`student_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`download_center` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`download_center` ADD COLUMN `user_id` bigint NULL DEFAULT NULL COMMENT '用户id' AFTER `pid`;
ALTER TABLE `boe_test`.`download_center` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`download_center` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`download_center` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路径' AFTER `size`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名' AFTER `url`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `t_type` int NULL DEFAULT NULL COMMENT '任务类型' AFTER `status`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `t_type`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`download_center` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`download_center` DROP COLUMN `delete`;
ALTER TABLE `boe_test`.`download_center` ADD INDEX `ix_downlaod_center_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`download_center` ADD INDEX `ix_downlaod_center_pid`(`pid` DESC) USING BTREE;
ALTER TABLE `boe_test`.`evaluation` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `id` bigint NOT NULL COMMENT '测评ID' FIRST;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`evaluation` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评的名称' AFTER `id`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_type_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评类型ID' AFTER `evaluation_name`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_type_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评类型名称' AFTER `evaluation_type_id`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_picture_address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评图片地址' AFTER `evaluation_type_name`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_explain` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评说明' AFTER `evaluation_picture_address`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_start_time` timestamp NULL DEFAULT NULL COMMENT '测评提交开始时间' AFTER `evaluation_explain`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `evaluation_end_time` timestamp NULL DEFAULT NULL COMMENT '测评提交结束时间' AFTER `evaluation_start_time`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评类型 0-内部测试 1-外部测试' AFTER `evaluation_end_time`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `type`;
ALTER TABLE `boe_test`.`evaluation` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.evaluation CHANGE evaluation_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`evaluation` DROP COLUMN `evaluation_flag`;
ALTER TABLE `boe_test`.`evaluation` DROP COLUMN `evaluation_tag`;
ALTER TABLE `boe_test`.`evaluation` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`evaluation` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`evaluation` ADD INDEX `ix_evaluation_cre`(`create_time` DESC) USING BTREE;
CREATE TABLE `boe_test`.`evaluation_task_for_student` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`student_id` bigint NULL DEFAULT NULL COMMENT '学员Id',
`student_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名',
`quiz_task_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '推送完成后的测评学习任务的Id',
`target_id` bigint NULL DEFAULT NULL COMMENT '项目、路径图',
`chapter_id` bigint NULL DEFAULT NULL COMMENT '阶段或关卡Id',
`business_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '业务类型 learningpath 或者 project',
`quiz_kid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评的Id-三方',
`quiz_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '测评任务学习地址',
`evaluation_id` bigint NULL DEFAULT NULL COMMENT '测评任务Id',
`quiz_task_status` int NULL DEFAULT NULL COMMENT '测评学习状态 未开始-0 进行中-1 已完成-2',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_evaluation_task_for_student_qui`(`quiz_kid` DESC) USING BTREE,
INDEX `ix_evaluation_task_for_student_stu`(`student_id` DESC) USING BTREE,
INDEX `ix_evaluation_task_for_student_tar`(`target_id` DESC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '推送学员测评任务后关联关系的存储' ROW_FORMAT = DYNAMIC;
ALTER TABLE `boe_test`.`examination` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `id` bigint NOT NULL COMMENT '考试ID' FIRST;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `stage_id` bigint NULL DEFAULT NULL COMMENT '关卡或阶段id' AFTER `exam_type`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `task_id` bigint NULL DEFAULT NULL COMMENT '任务id' AFTER `stage_id`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `pid` bigint NULL DEFAULT NULL COMMENT '项目或者路径图id' AFTER `task_id`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `type` int NULL DEFAULT NULL COMMENT '类型' AFTER `pid`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`examination` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试的名称' AFTER `id`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_paper_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试类型ID' AFTER `examination_name`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_test_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '试卷Id' AFTER `examination_paper_id`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_test_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试类型名称' AFTER `examination_test_id`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_start_time` timestamp NULL DEFAULT NULL COMMENT '考试开始时间' AFTER `examination_test_name`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_end_time` timestamp NULL DEFAULT NULL COMMENT '考试结束时间' AFTER `examination_start_time`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_explain` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试说明' AFTER `examination_end_time`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `examination_duration` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试时长' AFTER `examination_explain`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `show_answers` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否显示答案 1-允许查看 2-不允许查看' AFTER `examination_limit`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `show_analysis` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '显示解析 1-允许查看 2-不允许查看' AFTER `show_answers`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `scoring_model` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评分模型 1-最高一次 2-最后一次' AFTER `show_analysis`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `pass_line` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试限制-允许重复考试多少次 -1为无限制' AFTER `scoring_model`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `question_arrangement` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '试题排序 1-试题乱序 2-选项轮序 3-全部乱序' AFTER `pass_line`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `source` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外部考试的来源' AFTER `question_arrangement`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `type`;
ALTER TABLE `boe_test`.`examination` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.examination CHANGE examination_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`examination` DROP COLUMN `examination_flag`;
ALTER TABLE `boe_test`.`examination` DROP COLUMN `examination_tag`;
ALTER TABLE `boe_test`.`examination` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`examination` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`examination` ADD INDEX `ix_examination_exa`(`examination_test_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`examination` ADD INDEX `ix_examination_pid`(`pid` ASC) USING BTREE;
ALTER TABLE `boe_test`.`examination` ADD INDEX `ix_examination_tas`(`task_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`examination_task_for_student` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`examination_task_for_student` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`examination_task_for_student` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`examination_task_for_student` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `student_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `student_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `examination_task_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '推送完成后的考试任务的Id' AFTER `student_name`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `target_id` bigint NULL DEFAULT NULL COMMENT '项目、路径图、开课的Id' AFTER `examination_task_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `chapter_id` bigint NULL DEFAULT NULL COMMENT '阶段或关卡Id' AFTER `target_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '1-项目 2-路径图 3-课程' AFTER `chapter_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `test_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '考试的Id' AFTER `type`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `examination_id` bigint NULL DEFAULT NULL COMMENT '考试任务Id' AFTER `test_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `examination_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`examination_task_for_student` MODIFY COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`examination_task_for_student` ADD INDEX `ix_examination_task_for_student_exa`(`examination_task_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`examination_task_for_student` ADD INDEX `ix_examination_task_for_student_stu`(`student_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `id` bigint NOT NULL COMMENT '外部考试任务Id' FIRST;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`external_exam` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`external_exam` MODIFY COLUMN `external_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外部考试名称' AFTER `id`;
ALTER TABLE `boe_test`.`external_exam` MODIFY COLUMN `source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据来源' AFTER `external_name`;
ALTER TABLE `boe_test`.`external_exam` MODIFY COLUMN `external_explain` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外部考试说明' AFTER `source`;
ALTER TABLE `boe_test`.`external_exam` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `external_explain`;
ALTER TABLE `boe_test`.`external_exam` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.external_exam CHANGE external_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`external_exam` DROP COLUMN `external_flag`;
ALTER TABLE `boe_test`.`external_exam` DROP COLUMN `create_user_id`;
ALTER TABLE `boe_test`.`external_exam` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`external_exam` DROP COLUMN `update_user_id`;
ALTER TABLE `boe_test`.`external_exam` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`external_exam_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`external_exam_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`external_exam_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`external_exam_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`external_exam_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `student_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `student_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `target_id` bigint NULL DEFAULT NULL COMMENT '项目或路径图Id' AFTER `student_name`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `chapter_id` bigint NULL DEFAULT NULL COMMENT '阶段或关卡Id' AFTER `target_id`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `external_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外部考试名称' AFTER `external_id`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `student_no`;
ALTER TABLE `boe_test`.`external_exam_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`external_exam_submit` DROP COLUMN `create_user_id`;
ALTER TABLE `boe_test`.`external_exam_submit` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`external_exam_submit` DROP COLUMN `update_user_id`;
ALTER TABLE `boe_test`.`external_exam_submit` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`external_link` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `id` bigint NOT NULL COMMENT '外链ID' FIRST;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`external_link` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`external_link` MODIFY COLUMN `link_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外链名称' AFTER `id`;
ALTER TABLE `boe_test`.`external_link` MODIFY COLUMN `link_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '外链地址' AFTER `link_name`;
ALTER TABLE `boe_test`.`external_link` MODIFY COLUMN `link_description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外链描述' AFTER `link_address`;
ALTER TABLE `boe_test`.`external_link` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `link_description`;
ALTER TABLE `boe_test`.`external_link` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.external_link CHANGE link_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`external_link` DROP COLUMN `link_flag`;
ALTER TABLE `boe_test`.`external_link` DROP COLUMN `link_tag`;
ALTER TABLE `boe_test`.`external_link` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`external_link` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`live_broadcast` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `id` bigint NOT NULL COMMENT '直播ID' FIRST;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`live_broadcast` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播名称' AFTER `id`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_explain` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播说明' AFTER `live_name`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_start_time` timestamp NULL DEFAULT NULL COMMENT '直播开始时间' AFTER `live_explain`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_end_Time` timestamp NULL DEFAULT NULL COMMENT '直播结束时间' AFTER `live_start_time`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_duration` bigint NULL DEFAULT NULL COMMENT '直播时长' AFTER `live_end_Time`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_teacher_id` bigint NULL DEFAULT NULL COMMENT '教师ID' AFTER `live_duration`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_teacher_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教师名称' AFTER `live_teacher_id`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_cover` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播封面' AFTER `live_teacher_name`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_link` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播链接' AFTER `live_cover`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_playback` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'false' COMMENT '直播设置 true-已设置 false-未设置' AFTER `live_link`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_playback_link` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播封面' AFTER `live_playback`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `before_sign_in` int NULL DEFAULT NULL COMMENT '直播开始前多少分钟开始签到' AFTER `live_playback_link`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `after_sign_in` int NULL DEFAULT NULL COMMENT '直播开始后多少分钟结束签到' AFTER `before_sign_in`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `standard_settings` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标准设置 0-仅签到 1-签到和签退' AFTER `after_sign_in`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `other_settings` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '其他设置 1-学员请假后记为任务完成' AFTER `standard_settings`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `assessment` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '是否评价 0-未评价 1-已评价' AFTER `other_settings`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `is_evaluate` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '是否需要评价 0-不需要 1-需要评价，' AFTER `assessment`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `live_notice` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '直播公告' AFTER `assessment_id`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `live_notice`;
ALTER TABLE `boe_test`.`live_broadcast` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.live_broadcast CHANGE live_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`live_broadcast` DROP COLUMN `live_flag`;
ALTER TABLE `boe_test`.`live_broadcast` DROP COLUMN `live_tag`;
ALTER TABLE `boe_test`.`live_broadcast` DROP COLUMN `sign_out_time`;
ALTER TABLE `boe_test`.`live_broadcast` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`live_broadcast` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`live_broadcast` ADD INDEX `ix_live_broadcast_cre`(`create_time` DESC) USING BTREE;
CREATE TABLE `boe_test`.`modify_record` (
`id` bigint NOT NULL AUTO_INCREMENT,
`pid` bigint NULL DEFAULT NULL COMMENT '姓名',
`column` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字段',
`column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字段名称',
`before_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改前',
`after_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改后',
`type` int NULL DEFAULT NULL COMMENT '1项目 2路径 3面授课',
`status` int NULL DEFAULT 0,
`source_id` bigint NULL DEFAULT NULL COMMENT '来源Id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_modify_record_cre`(`create_time` DESC) USING BTREE,
INDEX `ix_modify_record_pid`(`pid` DESC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '统一字段修改记录表' ROW_FORMAT = DYNAMIC;
ALTER TABLE `boe_test`.`multiple_submit_option` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `id` bigint NOT NULL COMMENT '多选题答案选项主键Id' FIRST;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`multiple_submit_option` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`multiple_submit_option` MODIFY COLUMN `answer_option_id` bigint NULL DEFAULT NULL COMMENT '多选选择的选项的Id' AFTER `id`;
ALTER TABLE `boe_test`.`multiple_submit_option` MODIFY COLUMN `answer_option_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '多选选择的选项的名称' AFTER `answer_option_id`;
ALTER TABLE `boe_test`.`multiple_submit_option` MODIFY COLUMN `multiple_submit_id` bigint NULL DEFAULT NULL COMMENT '提交Id' AFTER `answer_option_name`;
ALTER TABLE `boe_test`.`multiple_submit_option` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `multiple_submit_id`;
ALTER TABLE `boe_test`.`multiple_submit_option` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.multiple_submit_option CHANGE multiple_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`multiple_submit_option` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`multiple_submit_option` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`multiple_submit_option` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`multiple_submit_option` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`multiple_submit_stem` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `id` bigint NOT NULL COMMENT '评估多选提交Id' FIRST;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`multiple_submit_stem` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`multiple_submit_stem` MODIFY COLUMN `assessment_submit_id` bigint NULL DEFAULT NULL COMMENT '提交Id' AFTER `id`;
ALTER TABLE `boe_test`.`multiple_submit_stem` MODIFY COLUMN `stem_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干名称' AFTER `assessment_submit_id`;
ALTER TABLE `boe_test`.`multiple_submit_stem` MODIFY COLUMN `question_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型 1-单选 2-多选 3-问答 4-评分' AFTER `stem_name`;
ALTER TABLE `boe_test`.`multiple_submit_stem` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `question_type`;
ALTER TABLE `boe_test`.`multiple_submit_stem` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.multiple_submit_stem CHANGE multiple_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`multiple_submit_stem` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`multiple_submit_stem` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`multiple_submit_stem` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`multiple_submit_stem` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`offcourse` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`offcourse` DROP INDEX `IX_OFF_CATE_ID`;
ALTER TABLE `boe_test`.`offcourse` DROP INDEX `IX_OFF_TECHER_ID`;
ALTER TABLE `boe_test`.`offcourse` ADD COLUMN `id` bigint NOT NULL FIRST;
ALTER TABLE `boe_test`.`offcourse` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`offcourse` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`offcourse` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名称' AFTER `id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `teacher_id` bigint NULL DEFAULT NULL COMMENT '教师ID' AFTER `name`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `teacher` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教师名称' AFTER `teacher_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `pic_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面图地址' AFTER `teacher`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `intro` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程简介' AFTER `pic_url`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `target_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '目标人群' AFTER `intro`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `source_belong_id` bigint NULL DEFAULT NULL COMMENT '资源归属主键' AFTER `target_user`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `source_belong_full_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '资源归属名称' AFTER `source_belong_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `attach` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '附件列表,多个附件以逗号间隔' AFTER `source_belong_full_name`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `meaning` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程价值' AFTER `attach`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `outline` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程大纲' AFTER `meaning`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `category_id` bigint NULL DEFAULT NULL COMMENT '分类ID,来源字典' AFTER `outline`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `scene_id` int NULL DEFAULT NULL COMMENT '场景ID,来源字典' AFTER `category_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `tips` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '内容标签,多个以逗号间隔' AFTER `scene_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `audit_status` int NOT NULL DEFAULT 0 COMMENT '审核状态:0-未提交;1-提交待审核;2-审核通过;-1审核未通过' AFTER `tips`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `publish_status` int NOT NULL DEFAULT 0 COMMENT '发布状态:0-未发布;1-已发布' AFTER `audit_status`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `project_id` bigint NULL DEFAULT NULL COMMENT '所属项目ID' AFTER `publish_time`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `project_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称' AFTER `project_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分' AFTER `project_name`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `status` int NOT NULL DEFAULT 1 COMMENT '状态 1启用 0停用' AFTER `score`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `scene_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景内容' AFTER `process_time`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `sys_type_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类的id-新' AFTER `scene_content`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `offcourse_number` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '课程编号' AFTER `sys_type_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `offcourse_number`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`offcourse` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.offcourse CHANGE offcourse_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`offcourse` ADD INDEX `ix_course_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse` ADD INDEX `ix_course_sou`(`source_belong_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_plan` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`offcourse_plan` DROP INDEX `IX_OFF_COURSE_ID`;
ALTER TABLE `boe_test`.`offcourse_plan` DROP INDEX `offcourse_plan_evaluate_id_IDX`;
ALTER TABLE `boe_test`.`offcourse_plan` ADD COLUMN `id` bigint NOT NULL FIRST;
ALTER TABLE `boe_test`.`offcourse_plan` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `offcourse_id` bigint NULL DEFAULT NULL COMMENT '面授课ID' AFTER `id`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `offcourse_id`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '开课名称' AFTER `description`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '开课地点' AFTER `name`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `teacher_id` bigint NULL DEFAULT NULL COMMENT '教师ID' AFTER `end_time`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `teacher` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '教师名称' AFTER `teacher_id`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `apply_flag` tinyint NULL DEFAULT NULL COMMENT '是否允许报名:1是0否' AFTER `teacher`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `sign_flag` tinyint NULL DEFAULT NULL COMMENT '是否允许未报名的签到:1是0否' AFTER `apply_flag`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `eval_flag` tinyint NULL DEFAULT NULL COMMENT '是否需要评估:1是0否' AFTER `sign_flag`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `complete_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '完成规则:1-报名即完成;2-签到即完成;3-请假算完成' AFTER `eval_flag`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `attach` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '附件列表,多个附件以逗号间隔' AFTER `complete_type`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `score` decimal(10, 2) NULL DEFAULT NULL COMMENT '评分' AFTER `attach`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `project_member` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `after_start`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `duration`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`offcourse_plan` MODIFY COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.offcourse_plan CHANGE offcourse_plan_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`offcourse_plan` ADD INDEX `ix_course_plan_eva`(`evaluate_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_plan` ADD INDEX `ix_course_plan_hom`(`home_work_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_plan` ADD INDEX `ix_course_plan_off`(`offcourse_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_plan` ADD INDEX `ix_course_plan_tes`(`test_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_plan` ADD INDEX `ix_course_plan_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_study_record` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`offcourse_study_record` DROP INDEX `offcourse_study_record_offcourse_id_IDX`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员名称' AFTER `student_id`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `sign_status` tinyint NULL DEFAULT NULL COMMENT '签到状态:0未签到;1已签到;2请假' AFTER `name`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `assessment_status` tinyint NULL DEFAULT NULL COMMENT '评估状态:0为评估;1已评估' AFTER `sign_in_time`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `assessment_submit_id` bigint NULL DEFAULT NULL COMMENT '评估提交Id' AFTER `assessment_status`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `examination_status` tinyint NULL DEFAULT NULL COMMENT '考试状态 0-未考试 1-已考试' AFTER `assessment_submit_id`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `examination_id` bigint NULL DEFAULT NULL COMMENT '配置的考试任务的Id' AFTER `examination_status`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `work_status` tinyint NULL DEFAULT NULL COMMENT '作业状态 0-未提交 1-已提交' AFTER `examination_id`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `work_submit_id` bigint NULL DEFAULT NULL COMMENT '作业提交的Id' AFTER `work_status`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `study_duration`;
ALTER TABLE `boe_test`.`offcourse_study_record` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`offcourse_study_record` DROP COLUMN `is_del`;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD UNIQUE INDEX `ux_offcourse_study_record`(`offcourse_plan_id` DESC, `student_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD INDEX `ix_offcourse_study_record_stu`(`student_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`offcourse_study_record` ADD INDEX `ux_offcourse_study_record_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`online_classes` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`online_classes` DROP INDEX `online_classes_third_party_id_IDX`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `id` bigint NOT NULL COMMENT '在线课Id' FIRST;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `third_party_id`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`online_classes` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`online_classes` MODIFY COLUMN `third_party_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '三方的案例Id' AFTER `id`;
ALTER TABLE `boe_test`.online_classes CHANGE online_classes_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`online_classes` ADD INDEX `ix_online_classes_thi`(`third_party_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`points_record` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`points_record` ADD COLUMN `user_id` bigint NULL DEFAULT NULL COMMENT '用户id' AFTER `id`;
ALTER TABLE `boe_test`.`points_record` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`points_record` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`points_record` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`points_record` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`points_record` MODIFY COLUMN `type_extra` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预留参数，记录类型的附属信息' AFTER `points_count`;
ALTER TABLE `boe_test`.`points_record` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `team_id`;
ALTER TABLE `boe_test`.`points_record` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`points_record` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`points_record` ADD INDEX `ix_points_record_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`points_record` ADD INDEX `ix_points_record_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`points_record` ADD INDEX `ix_points_record_use`(`user_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`points_rule` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`points_rule` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`points_rule` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`points_rule` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`points_rule` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`points_rule` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`points_rule` MODIFY COLUMN `rule` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '规则内容 json格式 取出来解析成具体对象' AFTER `project_id`;
ALTER TABLE `boe_test`.`points_rule` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `rule`;
ALTER TABLE `boe_test`.`points_rule` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`points_rule` ADD INDEX `ix_points_rule_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`points_rule` ADD INDEX `ix_points_rule_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`praise` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`praise` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`praise` MODIFY COLUMN `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户姓名' AFTER `user_id`;
ALTER TABLE `boe_test`.`praise` MODIFY COLUMN `user_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户事业' AFTER `user_name`;
ALTER TABLE `boe_test`.`praise` MODIFY COLUMN `user_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户组织名称' AFTER `user_job_name`;
ALTER TABLE `boe_test`.`praise` MODIFY COLUMN `user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像' AFTER `user_org_name`;
ALTER TABLE `boe_test`.`praise` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '类型 1 讨论 2 发帖 3 评论' AFTER `target_id`;
ALTER TABLE `boe_test`.`praise` DROP COLUMN `ctime`;
ALTER TABLE `boe_test`.`praise` DROP COLUMN `mtime`;
ALTER TABLE `boe_test`.`praise` DROP COLUMN `delete`;
ALTER TABLE `boe_test`.`praise` ADD INDEX `ix_praise_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`praise` ADD INDEX `ix_praise_tar`(`target_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`praise` ADD INDEX `ix_praise_use`(`user_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_group` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_group` DROP INDEX `PRO_GROUP_P_ID`;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_group` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_group` MODIFY COLUMN `group_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '小组名称' AFTER `project_id`;
ALTER TABLE `boe_test`.`project_group` MODIFY COLUMN `leader_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '组长名称' AFTER `leader_id`;
ALTER TABLE `boe_test`.`project_group` MODIFY COLUMN `group_member_count` int NULL DEFAULT NULL COMMENT '小组组员数量' AFTER `source`;
ALTER TABLE `boe_test`.`project_group` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_group CHANGE project_group_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_group` ADD INDEX `ix_project_group_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_group` ADD INDEX `ix_project_group_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_info` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_info` DROP INDEX `IX_PRO_PARENT_ID`;
ALTER TABLE `boe_test`.`project_info` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_info` ADD COLUMN `unlock_mode` int NULL DEFAULT 1 COMMENT '学习模式 1 自由模式 2 逐个解锁 3 完成必修' AFTER `source_belong_full_name`;
ALTER TABLE `boe_test`.`project_info` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_info` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_info` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '项目名称' AFTER `id`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `category` int NULL DEFAULT NULL COMMENT '分类' AFTER `name`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `pic_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面图地址' AFTER `category`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `parent_id` bigint NULL DEFAULT NULL COMMENT '父级项目ID' AFTER `type`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `manager_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目经理ID,多个以逗号间隔' AFTER `end_time`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `manager` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目经理名称,多个以逗号间隔' AFTER `manager_id`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `source_belong_id` bigint NULL DEFAULT NULL COMMENT '资源归属ID' AFTER `manager`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目说明' AFTER `source_belong_id`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `notice_flag` tinyint NULL DEFAULT NULL COMMENT '公告是否开启 1是0否' AFTER `remark`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目公告' AFTER `notice_flag`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `level` int NULL DEFAULT NULL COMMENT '项目级别' AFTER `notice`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `system_id` int NULL DEFAULT NULL COMMENT '培训体系' AFTER `level`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `boe_flag` tinyint NULL DEFAULT NULL COMMENT '是否BOE同步 1是0否' AFTER `system_id`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `course_sync_flag` tinyint NULL DEFAULT NULL COMMENT '课程是否同步 1是0否' AFTER `boe_flag`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `status` int NULL DEFAULT 0 COMMENT '状态 0草稿 1已发布 -1已结束' AFTER `course_sync_flag`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `attach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '附件列表,多个附件以逗号间隔' AFTER `status`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `template_id` bigint NULL DEFAULT NULL COMMENT '模板ID' AFTER `attach`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `source_belong_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目所属资源名称' AFTER `publish_time`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `source_belong_full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '资源归属全路径' AFTER `process_time`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `unlock_mode`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_info` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_info CHANGE project_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_info` DROP COLUMN `unlock_mode2`;
ALTER TABLE `boe_test`.`project_info` ADD INDEX `ix_project_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_info` ADD INDEX `ix_project_par`(`parent_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_info` ADD INDEX `ix_project_sou`(`source_belong_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_notice` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_notice` ADD COLUMN `id` bigint NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_notice` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`project_notice` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_notice` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_notice` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_notice` MODIFY COLUMN `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `project_id`;
ALTER TABLE `boe_test`.`project_notice` MODIFY COLUMN `notice` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `title`;
ALTER TABLE `boe_test`.`project_notice` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `notice`;
ALTER TABLE `boe_test`.`project_notice` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_notice` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.project_notice CHANGE notice_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_notice` ADD INDEX `ix_project_notice_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_score_record` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_score_record` DROP INDEX `PRO_SCORE_R_ID`;
ALTER TABLE `boe_test`.`project_score_record` DROP INDEX `PRO_SCORE_S_ID`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_score_record` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `stage_id` bigint NULL DEFAULT NULL COMMENT 'ID' AFTER `student_id`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `task_id` bigint NULL DEFAULT NULL COMMENT '关卡ID' AFTER `stage_id`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '学员名称' AFTER `task_id`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `score` int NULL DEFAULT NULL COMMENT '获得积分' AFTER `name`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '积分来源' AFTER `score`;
ALTER TABLE `boe_test`.`project_score_record` MODIFY COLUMN `source` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '来源描述' AFTER `type`;
ALTER TABLE `boe_test`.project_score_record CHANGE project_score_record_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_score_record` ADD INDEX `ix_project_score_record_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_score_record` ADD INDEX `ix_project_score_record_pro`(`project_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`project_score_record` ADD INDEX `ix_project_score_record_stu`(`student_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`project_stage` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_stage` DROP INDEX `IX_STAGE_PRO_ID`;
ALTER TABLE `boe_test`.`project_stage` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_stage` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_stage` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_stage` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '阶段名称' AFTER `project_id`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '阶段说明' AFTER `name`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `sort`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_stage` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_stage CHANGE stage_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_stage` ADD INDEX `ix_project_stage_pro`(`project_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`project_study_record` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_study_record` DROP INDEX `PRO_STUDY_R_ID`;
ALTER TABLE `boe_test`.`project_study_record` DROP INDEX `PRO_STUDY_S_ID`;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_study_record` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_study_record` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员名称' AFTER `task_id`;
ALTER TABLE `boe_test`.`project_study_record` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 0进行中 1已完成' AFTER `name`;
ALTER TABLE `boe_test`.`project_study_record` MODIFY COLUMN `current_ratio` int NULL DEFAULT NULL COMMENT '当前完成进度百分比分子位' AFTER `status`;
ALTER TABLE `boe_test`.`project_study_record` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `score`;
ALTER TABLE `boe_test`.`project_study_record` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_study_record CHANGE project_study_record_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_study_record` ADD INDEX `ix_project_study_record_pro`(`project_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`project_study_record` ADD INDEX `ix_project_study_record_stu`(`student_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`project_study_record` ADD INDEX `ix_project_study_record_tas`(`task_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_task` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_task` DROP INDEX `IX_PRO_TASK_ID`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `exam_type` int NULL DEFAULT NULL COMMENT '考试任务的类别 1-系统考试 2-外部考试' AFTER `type`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_task` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称' AFTER `stage_id`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `name`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '任务类别,对应课程组件类别' AFTER `sort`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `flag` tinyint(1) NULL DEFAULT NULL COMMENT '选修类别 0选修 1必修' AFTER `course_id`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `duration` int NULL DEFAULT NULL COMMENT '时长 单位分中' AFTER `flag`;
ALTER TABLE `boe_test`.`project_task` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_task CHANGE project_task_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_task` ADD INDEX `ix_project_task_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_task` ADD INDEX `ix_project_task_pro`(`project_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_task` ADD INDEX `ix_project_task_typ`(`type` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_template` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_template` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_template` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_template` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_template` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '模板名称' AFTER `id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `category` int NULL DEFAULT NULL COMMENT '分类' AFTER `name`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `pic_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '封面图地址' AFTER `category`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `manager_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目经理ID,多个以逗号间隔' AFTER `end_time`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `manager` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目经理名称,多个以逗号间隔' AFTER `manager_id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `source_belong_id` bigint NULL DEFAULT NULL COMMENT '资源归属ID' AFTER `manager`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目说明' AFTER `source_belong_id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `notice_flag` tinyint NULL DEFAULT NULL COMMENT '公告是否开启 1是0否' AFTER `remark`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `notice` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目公告' AFTER `notice_flag`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `level` int NULL DEFAULT NULL COMMENT '项目级别' AFTER `notice`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `system_id` int NULL DEFAULT NULL COMMENT '培训体系' AFTER `level`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `boe_flag` tinyint NULL DEFAULT NULL COMMENT '是否BOE同步 1是0否' AFTER `system_id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `course_sync_flag` tinyint NULL DEFAULT NULL COMMENT '课程是否同步 1是0否' AFTER `boe_flag`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 0未发布 1已发布' AFTER `course_sync_flag`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `from_project_id` bigint NULL DEFAULT NULL COMMENT '来源项目ID' AFTER `publish_time`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `attach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL AFTER `from_project_id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `source_belong_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '项目所属资源名称' AFTER `attach_switch`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `source_belong_full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '资源归属全路径' AFTER `source_belong_name`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `source_belong_full_name`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_template` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_template CHANGE project_template_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_template` ADD INDEX `ix_project_template_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_template_stage` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_template_stage` DROP INDEX `IX_TEM_STAGE_PRO_ID`;
ALTER TABLE `boe_test`.`project_template_stage` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_template_stage` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`project_template_stage` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_template_stage` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_template_stage` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '阶段名称' AFTER `project_template_id`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '阶段说明' AFTER `name`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `remark`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `sort`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_template_stage` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.project_template_stage CHANGE template_stage_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_template_stage` ADD INDEX `ix_project_template_stage_pro`(`project_template_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`project_template_task` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`project_template_task` DROP INDEX `IX_TEM_PRO_TASK_ID`;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`project_template_task` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称' AFTER `template_stage_id`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `name`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '任务类别,对应课程组件类别' AFTER `sort`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `flag` tinyint(1) NULL DEFAULT NULL COMMENT '选修类别 0选修 1必修' AFTER `course_id`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `duration` int NULL DEFAULT NULL COMMENT '时长 单位分中' AFTER `flag`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `duration`;
ALTER TABLE `boe_test`.`project_template_task` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.project_template_task CHANGE template_task_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`project_template_task` ADD INDEX `ix_project_template_task_pro`(`project_template_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`qa_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '问答题提交答案Id' FIRST;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`qa_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `qa_submit_stem_id` bigint NULL DEFAULT NULL COMMENT '问答题题干Id' AFTER `id`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `qa_submit_stem_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问答题标题' AFTER `qa_submit_stem_id`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `qa_submit_stem_answer` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问答题答案' AFTER `qa_submit_stem_title`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `question_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型 1-单选 2-多选 3-问答 4-评分' AFTER `qa_submit_stem_answer`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `assessment_submit_id` bigint NULL DEFAULT NULL COMMENT '提交Id' AFTER `question_type`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `assessment_submit_id`;
ALTER TABLE `boe_test`.`qa_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.qa_submit CHANGE qa_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`qa_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`qa_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`qa_submit` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`qa_submit` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`qa_submit` ADD INDEX `ix_qa_submit_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`research` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`research` ADD COLUMN `id` bigint NOT NULL COMMENT '调研ID' FIRST;
ALTER TABLE `boe_test`.`research` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`research` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`research` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`research` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`research` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研名称' AFTER `id`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_type` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研的类型 1-单选 2-多选 3-评分' AFTER `research_name`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_qa_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问答题标题' AFTER `research_type`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_qa_describe` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问答题描述' AFTER `research_qa_title`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_sc_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评分题标题' AFTER `research_qa_describe`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `release_status` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '1-待发布\r\n2-已发布\r\n3-已结束' AFTER `research_score`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `release_time` timestamp NULL DEFAULT NULL COMMENT '发布时间' AFTER `release_status`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `weight_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '整体评估' COMMENT '权重类型' AFTER `release_time`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `weight_scale` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权重比例' AFTER `weight_type`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `stem_id` bigint NULL DEFAULT NULL COMMENT '调研备注' AFTER `weight_scale`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `research_mark` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研备注' AFTER `stem_id`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `research_mark`;
ALTER TABLE `boe_test`.`research` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.research CHANGE research_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`research` DROP COLUMN `research_flag`;
ALTER TABLE `boe_test`.`research` DROP COLUMN `research_tag`;
ALTER TABLE `boe_test`.`research` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`research` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`research_option` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `id` bigint NOT NULL COMMENT '题干ID' FIRST;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`research_option` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`research_option` MODIFY COLUMN `stem` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干' AFTER `stem_id`;
ALTER TABLE `boe_test`.`research_option` MODIFY COLUMN `option_name` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项的名称' AFTER `stem`;
ALTER TABLE `boe_test`.`research_option` MODIFY COLUMN `option_picture_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `option_name`;
ALTER TABLE `boe_test`.`research_option` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `option_picture_address`;
ALTER TABLE `boe_test`.`research_option` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.research_option CHANGE option_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`research_option` DROP COLUMN `option_flag`;
ALTER TABLE `boe_test`.`research_option` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`research_option` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`router_chapter` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`router_chapter` DROP INDEX `ROUTER_CHAPTER_ID`;
ALTER TABLE `boe_test`.`router_chapter` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`router_chapter` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_chapter` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_chapter` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关卡名称' AFTER `router_id`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关卡说明' AFTER `name`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `remark`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `status` int NULL DEFAULT NULL COMMENT '状态 0 草稿 1 发布 -1 删除' AFTER `sort`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`router_chapter` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.router_chapter CHANGE chapter_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_chapter` ADD INDEX `ix_router_chapter_rou`(`router_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`router_chapter` ADD INDEX `ix_router_chapter_sor`(`sort` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_chapter_draft` DROP INDEX `CHAPTER_DRAFT_ID`;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD COLUMN `id` bigint NOT NULL COMMENT '草稿id' FIRST;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `chapter_id` bigint NULL DEFAULT NULL COMMENT '关卡id' AFTER `id`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `router_id` bigint NULL DEFAULT NULL COMMENT '路径图ID' AFTER `chapter_id`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关卡名称' AFTER `router_id`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '关卡说明' AFTER `name`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `remark`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `status` int NULL DEFAULT 0 COMMENT '状态 0 草稿 1 发布 -1 删除' AFTER `sort`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_chapter_draft` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.router_chapter_draft CHANGE chapter_draft_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_chapter_draft` ADD INDEX `ix_router_chapter_draft_cha`(`chapter_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD INDEX `ix_router_chapter_draft_rou`(`router_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_chapter_draft` ADD INDEX `ix_router_chapter_draft_sor`(`sort` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_info` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`router_info` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`router_info` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_info` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_info` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '路径图名称' AFTER `id`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `pic_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背景图地址' AFTER `name`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '路径图说明' AFTER `pic_url`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 0草稿 1已发布 -1已停用' AFTER `remark`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `attach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL AFTER `publish_time`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `organization_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织名称' AFTER `attach_switch`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `preview_setting` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预览设置' AFTER `unlock_mode`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `study_setting` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学习设置' AFTER `preview_setting`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `study_setting`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`router_info` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.router_info CHANGE router_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_info` ADD INDEX `ix_router_info_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_study_record` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`router_study_record` DROP INDEX `ROUTER_STUDY_R_ID`;
ALTER TABLE `boe_test`.`router_study_record` DROP INDEX `ROUTER_STUDY_S_ID`;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_study_record` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_study_record` MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员名称' AFTER `task_id`;
ALTER TABLE `boe_test`.`router_study_record` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 0进行中 1已完成' AFTER `name`;
ALTER TABLE `boe_test`.`router_study_record` MODIFY COLUMN `current_ratio` int NULL DEFAULT NULL COMMENT '当前完成进度百分比分子位' AFTER `status`;
ALTER TABLE `boe_test`.`router_study_record` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `score`;
ALTER TABLE `boe_test`.`router_study_record` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.router_study_record CHANGE router_study_record_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_study_record` ADD INDEX `ix_router_study_record_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_study_record` ADD INDEX `ix_router_study_record_rou`(`router_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`router_study_record` ADD INDEX `ix_router_study_record_stu`(`student_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`router_study_record` ADD INDEX `ix_router_study_record_tas`(`task_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`router_task` DROP INDEX `ROUTER_TASK_ID`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `id` bigint UNSIGNED NOT NULL FIRST;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `exam_type` int NULL DEFAULT NULL COMMENT '考试任务的类别 1-系统考试 2-外部考试' AFTER `type`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_task` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称' AFTER `chapter_id`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `name`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '任务类别,对应课程组件类别' AFTER `sort`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `flag` tinyint(1) NULL DEFAULT NULL COMMENT '选修类别 0选修 1必修' AFTER `course_id`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `duration` int NULL DEFAULT NULL COMMENT '时长 单位分中' AFTER `flag`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 -1 删除 0 草稿 1发布' AFTER `duration`;
ALTER TABLE `boe_test`.`router_task` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.router_task CHANGE router_task_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_task` ADD INDEX `ix_router_task_cou`(`course_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task` ADD INDEX `ix_router_task_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task` ADD INDEX `ix_router_task_rou`(`router_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task` ADD INDEX `ix_router_task_sor`(`sort` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task_draft` DROP INDEX `ROUTER_TASK_DRAFT_ID`;
ALTER TABLE `boe_test`.`router_task_draft` DROP INDEX `ROUTER_TASK_ID`;
ALTER TABLE `boe_test`.`router_task_draft` DROP INDEX `course_id`;
ALTER TABLE `boe_test`.`router_task_draft` DROP INDEX `type`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `id` bigint NOT NULL COMMENT '关卡任务草稿id' FIRST;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `exam_type` int NULL DEFAULT NULL COMMENT '考试任务的类别 1-系统考试 2-外部考试' AFTER `type`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`router_task_draft` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `sort` int NULL DEFAULT NULL COMMENT '顺序字段,用于排序' AFTER `name`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '任务类别,对应课程组件类别' AFTER `sort`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `flag` tinyint(1) NULL DEFAULT NULL COMMENT '选修类别 0选修 1必修' AFTER `course_id`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `duration` int NULL DEFAULT NULL COMMENT '时长 单位分中' AFTER `flag`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `status` tinyint NULL DEFAULT NULL COMMENT '状态 -1 删除 0 草稿 1发布' AFTER `duration`;
ALTER TABLE `boe_test`.`router_task_draft` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.router_task_draft CHANGE router_task_draft_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`router_task_draft` ADD INDEX `ix_router_task_draft_cou`(`course_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task_draft` ADD INDEX `ix_router_task_draft_rot`(`router_task_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task_draft` ADD INDEX `ix_router_task_draft_rou`(`router_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`router_task_draft` ADD INDEX `ix_router_task_draft_sort`(`sort` DESC) USING BTREE;
ALTER TABLE `boe_test`.`sc_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '评分题答案提交Id' FIRST;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`sc_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `sc_submit_stem_id` bigint NULL DEFAULT NULL COMMENT '评分题题干Id' AFTER `id`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `sc_submit_stem_title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '评分题题干名称' AFTER `sc_submit_stem_id`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `question_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型 1-单选 2-多选 3-问答 4-评分' AFTER `sc_submit_score`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `assessment_submit_id` bigint NULL DEFAULT NULL COMMENT '提交Id' AFTER `question_type`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `assessment_submit_id`;
ALTER TABLE `boe_test`.`sc_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.sc_submit CHANGE sc_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`sc_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`sc_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`sc_submit` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`sc_submit` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`score_rule` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `reserve3`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`score_rule` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`score_rule` ADD INDEX `ix_score_rule_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`score_rule` ADD INDEX `ix_score_rule_pro`(`project_Id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`score_rule_item` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `type`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`score_rule_item` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`scores_log` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`scores_log` DROP INDEX `rule_id_index`;
ALTER TABLE `boe_test`.`scores_log` DROP INDEX `user_id_index`;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `id` int UNSIGNED NOT NULL COMMENT '积分记录表id' FIRST;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`scores_log` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`scores_log` MODIFY COLUMN `type_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型' AFTER `get_score`;
ALTER TABLE `boe_test`.`scores_log` MODIFY COLUMN `source_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '来源' AFTER `type_value`;
ALTER TABLE `boe_test`.`scores_log` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `source_value`;
ALTER TABLE `boe_test`.`scores_log` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.scores_log CHANGE scores_log_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`scores_log` ADD INDEX `ix_scores_log_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`scores_log` ADD INDEX `ix_scores_log_rul`(`rule_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`scores_log` ADD INDEX `ix_scores_log_use`(`user_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`scores_rule` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `id` int UNSIGNED NOT NULL COMMENT '主键id' FIRST;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `rule_status`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`scores_rule` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`scores_rule` MODIFY COLUMN `rule_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '规则名称 前{?}名学完在线课程获得{?}积分' AFTER `id`;
ALTER TABLE `boe_test`.`scores_rule` MODIFY COLUMN `rule_param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '规则参数 3,5' AFTER `rule_name`;
ALTER TABLE `boe_test`.scores_rule CHANGE scores_rule_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`single_submit_stem` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `id` bigint NOT NULL COMMENT '评估单选提交Id' FIRST;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`single_submit_stem` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `answer_option_id` bigint NULL DEFAULT NULL COMMENT '单选选择的选项的Id' AFTER `id`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `answer_option_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '单选选择的选项的名称' AFTER `answer_option_id`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `assessment_submit_id` bigint NULL DEFAULT NULL COMMENT '提交Id' AFTER `answer_option_name`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `stem_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干名称' AFTER `assessment_submit_id`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `question_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问题类型 1-单选 2-多选 3-问答 4-评分' AFTER `stem_name`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `question_type`;
ALTER TABLE `boe_test`.`single_submit_stem` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.single_submit_stem CHANGE single_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`single_submit_stem` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`single_submit_stem` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`single_submit_stem` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`single_submit_stem` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`statement` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '帖子标题' AFTER `discuss_id`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '帖子内容' AFTER `title`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名' AFTER `user_id`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `user_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户工作' AFTER `user_name`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `user_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户组织' AFTER `user_job_name`;
ALTER TABLE `boe_test`.`statement` MODIFY COLUMN `user_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像' AFTER `user_org_name`;
ALTER TABLE `boe_test`.`statement` DROP COLUMN `ctime`;
ALTER TABLE `boe_test`.`statement` DROP COLUMN `mtime`;
ALTER TABLE `boe_test`.`statement` DROP COLUMN `is_delete`;
ALTER TABLE `boe_test`.`statement` ADD INDEX `ix_statement_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`statement` ADD INDEX `ix_statement_dis`(`discuss_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`statement` ADD INDEX `ix_statement_use`(`user_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`student` DROP INDEX `peat`;
ALTER TABLE `boe_test`.`student` DROP INDEX `student_pid_IDX`;
ALTER TABLE `boe_test`.`student` ADD COLUMN `external_exam_score` double NULL DEFAULT 0 COMMENT '外部考试的成绩' AFTER `points`;
ALTER TABLE `boe_test`.`student` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `pid` bigint NULL DEFAULT NULL COMMENT '聚合字段 项目id -- 路径图id --课程id' AFTER `id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员id' AFTER `pid`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员手机' AFTER `student_name`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_band_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员bandCode' AFTER `student_mobile`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_band_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员band_desc' AFTER `student_band_code`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_kid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员kid' AFTER `student_band_desc`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_user_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员编号' AFTER `student_kid`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_depart_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员部门名称' AFTER `student_depart_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_org_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员组织名称' AFTER `student_depart_name`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员邮箱' AFTER `student_org_name`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员头像' AFTER `student_email`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `student_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员岗位' AFTER `student_avatar`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小组名称' AFTER `group_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '1项目 3面授课 2路径' AFTER `source`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `completion_status` int NULL DEFAULT 0 COMMENT '结业状态' AFTER `status`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `synchronization` int NULL DEFAULT NULL COMMENT '是否同步过待办任务，0-否，1-是' AFTER `completion_status`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `last_learned_id` bigint NULL DEFAULT NULL COMMENT '最后学习的Id' AFTER `synchronization`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `points` bigint NULL DEFAULT NULL COMMENT '学员总积分' AFTER `last_learned_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `source_id` bigint NULL DEFAULT NULL COMMENT '来源id' AFTER `external_exam_score`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `source_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`student` MODIFY COLUMN `last_learned` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '最后学习的名称' AFTER `deleted`;
ALTER TABLE `boe_test`.`student` DROP COLUMN `delete`;
ALTER TABLE `boe_test`.`student` DROP COLUMN `cert_id`;
ALTER TABLE `boe_test`.`student` DROP COLUMN `cert_name`;
ALTER TABLE `boe_test`.`student` DROP COLUMN `cert_url`;
ALTER TABLE `boe_test`.`student` ADD UNIQUE INDEX `ux_student_pro`(`pid` DESC, `student_id` DESC, `type` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student` ADD INDEX `ix_student_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student` ADD INDEX `ix_student_typ`(`type` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student` ADD INDEX `ix_student_pid`(`pid` DESC) USING BTREE;
CREATE TABLE `boe_test`.`student_cert` (
`id` int NOT NULL AUTO_INCREMENT,
`pid` bigint NULL DEFAULT NULL COMMENT '学员表id',
`cert_id` bigint NULL DEFAULT NULL COMMENT '证书id',
`cert_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证书名称',
`cert_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '证书图',
`status` int NULL DEFAULT 0,
`student_id` bigint NULL DEFAULT NULL COMMENT '学员id',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`create_id` bigint NULL DEFAULT NULL COMMENT '创建人',
`create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`update_id` bigint NULL DEFAULT NULL COMMENT '更新人',
`update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人',
`deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `ux_student_cert_pid`(`pid` ASC, `cert_id` ASC) USING BTREE COMMENT '不可重复获取证书',
INDEX `ux_student_cert_cer`(`cert_id` ASC) USING BTREE,
INDEX `ux_student_cert_stu`(`student_id` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '学员证书表' ROW_FORMAT = DYNAMIC;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `task_id` bigint NULL DEFAULT NULL COMMENT '任务的Id' AFTER `type`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `student_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `student_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `student_id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `vote_id` bigint NULL DEFAULT NULL COMMENT '投票任务的ID' AFTER `student_name`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `vote_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票任务名称' AFTER `vote_id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `begin_time` timestamp NOT NULL COMMENT '投票开始时间' AFTER `vote_name`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `target_id` bigint NULL DEFAULT NULL COMMENT '项目、路径Id' AFTER `result`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `chapter_or_stage_id` bigint NULL DEFAULT NULL COMMENT '关卡或者阶段Id' AFTER `target_id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `type` int NULL DEFAULT NULL COMMENT '1-路径图 2-项目' AFTER `chapter_or_stage_id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `task_id`;
ALTER TABLE `boe_test`.`student_commit_vote` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`student_commit_vote` DROP COLUMN `create_user_id`;
ALTER TABLE `boe_test`.`student_commit_vote` DROP COLUMN `create_user_name`;
ALTER TABLE `boe_test`.`student_commit_vote` DROP COLUMN `update_user_id`;
ALTER TABLE `boe_test`.`student_commit_vote` DROP COLUMN `update_user_name`;
ALTER TABLE `boe_test`.`student_commit_vote` ADD INDEX `ix_student_commit_vote_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student_commit_vote` ADD INDEX `ix_student_commit_vote_stu`(`student_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`student_commit_vote` ADD INDEX `ix_student_commit_vote_vot`(`vote_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`student_group` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`student_group` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`student_group` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`student_group` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`student_group` MODIFY COLUMN `pid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '来源id' AFTER `id`;
ALTER TABLE `boe_test`.`student_group` MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '小组名称' AFTER `pid`;
ALTER TABLE `boe_test`.`student_group` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `status`;
ALTER TABLE `boe_test`.`student_group` MODIFY COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`student_group` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.`student_group` DROP COLUMN `delete`;
ALTER TABLE `boe_test`.`student_group` ADD INDEX `ix_student_group_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`student_group` ADD INDEX `ix_student_group_pid`(`pid` ASC) USING BTREE;
ALTER TABLE `boe_test`.`survey` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `id` bigint NOT NULL COMMENT '调研ID' FIRST;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`survey` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `survey_name` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研的名称' AFTER `id`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `research_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研类型的名称' AFTER `research_id`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `survey_start_time` timestamp NULL DEFAULT NULL COMMENT '调研开始时间' AFTER `research_name`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `survey_end_Time` timestamp NULL DEFAULT NULL COMMENT '调研结束时间' AFTER `survey_start_time`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `survey_explain` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调研说明' AFTER `survey_end_Time`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `survey_explain`;
ALTER TABLE `boe_test`.`survey` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.survey CHANGE survey_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`survey` DROP COLUMN `survey_flag`;
ALTER TABLE `boe_test`.`survey` DROP COLUMN `survey_tag`;
ALTER TABLE `boe_test`.`survey` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`survey` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`vote` DROP INDEX `vote_vote_stem_id_IDX`;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `id` bigint NOT NULL COMMENT '投票ID' FIRST;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`vote` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `vote_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票名称' AFTER `id`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `vote_explain` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票说明' AFTER `vote_name`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `vote_start_time` timestamp NULL DEFAULT NULL COMMENT '投票开始时间' AFTER `vote_explain`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `vote_end_time` timestamp NULL DEFAULT NULL COMMENT '投票结束时间' AFTER `vote_start_time`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `base_vote` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '基础票数' AFTER `vote_end_time`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `votes_total` bigint NULL DEFAULT NULL COMMENT '总票数' AFTER `base_vote`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `number_of_involved` bigint NULL DEFAULT NULL COMMENT '投票参与数' AFTER `votes_total`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `number_of_browse` bigint NULL DEFAULT NULL COMMENT '浏览数' AFTER `number_of_involved`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `number_of_browse`;
ALTER TABLE `boe_test`.`vote` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.vote CHANGE vote_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`vote` DROP COLUMN `ballot_id`;
ALTER TABLE `boe_test`.`vote` DROP COLUMN `vote_flag`;
ALTER TABLE `boe_test`.`vote` DROP COLUMN `vote_tag`;
ALTER TABLE `boe_test`.`vote` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`vote` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote_option_stem` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`vote_option_stem` DROP INDEX `stem_index`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `id` bigint NOT NULL COMMENT '题干ID' FIRST;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `vote_id` bigint NULL DEFAULT NULL COMMENT '投票id' AFTER `vote_stem_id`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `vote_stem_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干' AFTER `vote_id`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`vote_option_stem` MODIFY COLUMN `option_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项的名称' AFTER `vote_stem_name`;
ALTER TABLE `boe_test`.`vote_option_stem` MODIFY COLUMN `option_picture_address` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项图片地址' AFTER `option_name`;
ALTER TABLE `boe_test`.`vote_option_stem` MODIFY COLUMN `option_order_num` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '选项排序序号\r\n' AFTER `option_picture_address`;
ALTER TABLE `boe_test`.`vote_option_stem` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `option_order_num`;
ALTER TABLE `boe_test`.`vote_option_stem` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.vote_option_stem CHANGE option_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`vote_option_stem` DROP COLUMN `stem`;
ALTER TABLE `boe_test`.`vote_option_stem` DROP COLUMN `option_flag`;
ALTER TABLE `boe_test`.`vote_option_stem` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`vote_option_stem` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote_option_stem` ADD INDEX `ix_vote_option_stem_vsi`(`vote_stem_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`vote_stem` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `id` bigint NOT NULL COMMENT '题干ID' FIRST;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `vote_id` bigint NULL DEFAULT NULL COMMENT '题干所属的标识' AFTER `id`;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`vote_stem` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`vote_stem` MODIFY COLUMN `vote_stem_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干名称' AFTER `vote_id`;
ALTER TABLE `boe_test`.`vote_stem` MODIFY COLUMN `order_number` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '题干排序-前端根据此题干在第几个展示传相应的字符串' AFTER `vote_stem_name`;
ALTER TABLE `boe_test`.`vote_stem` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `order_number`;
ALTER TABLE `boe_test`.`vote_stem` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.vote_stem CHANGE vote_stem_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`vote_stem` DROP COLUMN `ballot_id`;
ALTER TABLE `boe_test`.`vote_stem` DROP COLUMN `vote_stem_flag`;
ALTER TABLE `boe_test`.`vote_stem` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`vote_stem` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '问答题提交答案Id' FIRST;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`vote_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `stu_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `stu_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `stu_id`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `vote_id` bigint NULL DEFAULT NULL COMMENT '投票任务的ID' AFTER `stu_name`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `vote_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票任务名称' AFTER `vote_id`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `ballot_id` bigint NULL DEFAULT NULL COMMENT '创建投票-投票Id' AFTER `vote_name`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `ballot_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '问答题答案' AFTER `ballot_id`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `ballot_name`;
ALTER TABLE `boe_test`.`vote_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.vote_submit CHANGE vote_submit_it id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`vote_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`vote_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote_submit` ADD INDEX `ix_vote_submit_stu`(`stu_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`vote_submit` ADD INDEX `ix_vote_submit_vot`(`vote_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`vote_submit_option` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `id` bigint NOT NULL COMMENT '投票选项的主键Id' FIRST;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`vote_submit_option` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `vote_stem_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '题干名称' AFTER `id`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `vote_stem_id` bigint NULL DEFAULT NULL COMMENT '题干Id' AFTER `vote_stem_name`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `option_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票任务名称' AFTER `vote_stem_id`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `option_address` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '投票的选项图片的地址' AFTER `option_name`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `option_address`;
ALTER TABLE `boe_test`.`vote_submit_option` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.vote_submit_option CHANGE vote_submit_option_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`vote_submit_option` DROP COLUMN `ballot_id`;
ALTER TABLE `boe_test`.`vote_submit_option` DROP COLUMN `option_id`;
ALTER TABLE `boe_test`.`vote_submit_option` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`vote_submit_option` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`vote_submit_option` ADD INDEX `ix_vote_submit_option_vot`(`vote_stem_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`work_detail` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `id` bigint NOT NULL COMMENT '作业ID' FIRST;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`work_detail` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `work_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作业的名称' AFTER `id`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `work_enclosure_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '作业附件地址' AFTER `work_name`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `submit_start_time` timestamp NULL DEFAULT NULL COMMENT '作业提交开始时间' AFTER `work_enclosure_address`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `submit_end_time` timestamp NULL DEFAULT NULL COMMENT '作业提交结束时间' AFTER `submit_start_time`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `work_requirement` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作业要求' AFTER `submit_end_time`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `work_requirement`;
ALTER TABLE `boe_test`.`work_detail` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.work_detail CHANGE work_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`work_detail` DROP COLUMN `work_flag`;
ALTER TABLE `boe_test`.`work_detail` DROP COLUMN `work_tag`;
ALTER TABLE `boe_test`.`work_detail` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`work_detail` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`work_submit` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `id` bigint NOT NULL COMMENT '直播信息提交ID' FIRST;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `create_id` bigint NULL DEFAULT NULL COMMENT '创建人' AFTER `create_time`;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `create_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人' AFTER `create_id`;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `update_id` bigint NULL DEFAULT NULL COMMENT '更新人' AFTER `update_time`;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `update_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人' AFTER `update_id`;
ALTER TABLE `boe_test`.`work_submit` ADD COLUMN `deleted` tinyint NOT NULL DEFAULT 0 COMMENT '活动逻辑删除标识 0 默认 1 删除' AFTER `update_name`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `stu_id` bigint NULL DEFAULT NULL COMMENT '学员Id' AFTER `id`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `stu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员姓名' AFTER `stu_id`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `work_id` bigint NULL DEFAULT NULL COMMENT '作业的Id' AFTER `stu_name`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `work_score` int NULL DEFAULT NULL COMMENT '作业成绩-通过后期作业管理导入' AFTER `work_id`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `work_upload_address` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作业上传的地址' AFTER `work_score`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `work_submit_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '作业提交的内容' AFTER `work_upload_address`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `create_user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人姓名' AFTER `work_submit_content`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `update_user_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人姓名' AFTER `create_user_name`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `stu_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '学员no' AFTER `update_user_name`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `stu_no`;
ALTER TABLE `boe_test`.`work_submit` MODIFY COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间' AFTER `create_name`;
ALTER TABLE `boe_test`.work_submit CHANGE work_submit_id id bigint auto_increment NOT NULL COMMENT 'id';
ALTER TABLE `boe_test`.`work_submit` DROP COLUMN `create_user`;
ALTER TABLE `boe_test`.`work_submit` DROP COLUMN `update_user`;
ALTER TABLE `boe_test`.`work_submit` ADD INDEX `ix_work_submit_cre`(`create_time` DESC) USING BTREE;
ALTER TABLE `boe_test`.`work_submit` ADD INDEX `ix_work_submit_stu`(`stu_id` DESC) USING BTREE;
ALTER TABLE `boe_test`.`work_submit` ADD INDEX `ix_work_submit_wor`(`work_id` ASC) USING BTREE;
ALTER TABLE `boe_test`.`xxl_job_group` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_group` MODIFY COLUMN `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器AppName' AFTER `id`;
ALTER TABLE `boe_test`.`xxl_job_group` MODIFY COLUMN `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器名称' AFTER `app_name`;
ALTER TABLE `boe_test`.`xxl_job_group` MODIFY COLUMN `address_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行器地址列表，多地址逗号分隔' AFTER `address_type`;
ALTER TABLE `boe_test`.`xxl_job_info` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL AFTER `job_group`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `author` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作者' AFTER `update_time`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报警邮件' AFTER `author`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `schedule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NONE' COMMENT '调度类型' AFTER `alarm_email`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `schedule_conf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型' AFTER `schedule_type`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `misfire_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略' AFTER `schedule_conf`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器路由策略' AFTER `misfire_strategy`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler' AFTER `executor_route_strategy`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数' AFTER `executor_handler`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '阻塞处理策略' AFTER `executor_param`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE类型' AFTER `executor_fail_retry_count`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码' AFTER `glue_type`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE备注' AFTER `glue_source`;
ALTER TABLE `boe_test`.`xxl_job_info` MODIFY COLUMN `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '子任务ID，多个逗号分隔' AFTER `glue_updatetime`;
ALTER TABLE `boe_test`.`xxl_job_lock` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_lock` MODIFY COLUMN `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '锁名称' FIRST;
ALTER TABLE `boe_test`.`xxl_job_log` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器地址，本次执行的地址' AFTER `job_id`;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler' AFTER `executor_address`;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数' AFTER `executor_handler`;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2' AFTER `executor_param`;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '调度-日志' AFTER `trigger_code`;
ALTER TABLE `boe_test`.`xxl_job_log` MODIFY COLUMN `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行-日志' AFTER `handle_code`;
ALTER TABLE `boe_test`.`xxl_job_log_report` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_logglue` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_logglue` MODIFY COLUMN `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE类型' AFTER `job_id`;
ALTER TABLE `boe_test`.`xxl_job_logglue` MODIFY COLUMN `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码' AFTER `glue_type`;
ALTER TABLE `boe_test`.`xxl_job_logglue` MODIFY COLUMN `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE备注' AFTER `glue_source`;
ALTER TABLE `boe_test`.`xxl_job_registry` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_registry` MODIFY COLUMN `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL AFTER `id`;
ALTER TABLE `boe_test`.`xxl_job_registry` MODIFY COLUMN `registry_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL AFTER `registry_group`;
ALTER TABLE `boe_test`.`xxl_job_registry` MODIFY COLUMN `registry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL AFTER `registry_key`;
ALTER TABLE `boe_test`.`xxl_job_user` CHARACTER SET = utf8mb4, COLLATE = utf8mb4_0900_ai_ci;
ALTER TABLE `boe_test`.`xxl_job_user` MODIFY COLUMN `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号' AFTER `id`;
ALTER TABLE `boe_test`.`xxl_job_user` MODIFY COLUMN `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码' AFTER `username`;
ALTER TABLE `boe_test`.`xxl_job_user` MODIFY COLUMN `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割' AFTER `role`;
DROP TABLE IF EXISTS `boe_test`.`activity_submit`;
DROP TABLE IF EXISTS `boe_test`.`audience_info`;
DROP TABLE IF EXISTS `boe_test`.`auth_cancel_members`;
DROP TABLE IF EXISTS `boe_test`.`auth_members`;
DROP TABLE IF EXISTS `boe_test`.`ballot`;
DROP TABLE IF EXISTS `boe_test`.`dict_info`;
DROP TABLE IF EXISTS `boe_test`.`dict_set`;
DROP TABLE IF EXISTS `boe_test`.`discuss_submit_reply`;
DROP TABLE IF EXISTS `boe_test`.`discuss_submit_review`;
DROP TABLE IF EXISTS `boe_test`.`live_submit`;
DROP TABLE IF EXISTS `boe_test`.`member_audience_ref`;
DROP TABLE IF EXISTS `boe_test`.`member_info`;
DROP TABLE IF EXISTS `boe_test`.`offcourse_plan_bak`;
DROP TABLE IF EXISTS `boe_test`.`offcourse_plan_copy_copy1`;
DROP TABLE IF EXISTS `boe_test`.`offcourse_student`;
DROP TABLE IF EXISTS `boe_test`.`org_info`;
DROP TABLE IF EXISTS `boe_test`.`project_student`;
DROP TABLE IF EXISTS `boe_test`.`router_audience`;
DROP TABLE IF EXISTS `boe_test`.`router_org`;
DROP TABLE IF EXISTS `boe_test`.`router_student`;
DROP TABLE IF EXISTS `boe_test`.`student_org`;
DROP TABLE IF EXISTS `boe_test`.`student_org_audi_ref`;
DROP TABLE IF EXISTS `boe_test`.`student_task_record`;
DROP TABLE IF EXISTS `boe_test`.`wuyx`;
SET FOREIGN_KEY_CHECKS=1;
Reference in New Issue View Git Blame Copy Permalink