examcloud-upgrade/upgrade-归档/upgrade-202007/数据库变更.txt


-------------------- 模块: basic Start --------------------

清理Redis缓存KEY：B_LOGIN_RULE

DROP TABLE IF EXISTS ec_b_login_rule;

CREATE TABLE ec_b_login_rule (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  root_org_id bigint(20) NOT NULL,
  type varchar(50) NOT NULL,
	allow bit(1) NOT NULL,
	creation_time datetime NOT NULL,
  update_time datetime NOT NULL,
  PRIMARY KEY (id),
  KEY IDX_B_LR_001 (root_org_id),
  KEY IDX_B_LR_002 (type)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (-1, 'STUDENT_LOGIN', b'0', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (-1, 'STUDENT_CLIENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (-1, 'GEETEST_LOGIN', b'1', now(), now());

INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (0, 'STUDENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (17196, 'STUDENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (17682, 'STUDENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (17426, 'STUDENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (17351, 'STUDENT_LOGIN', b'1', now(), now());
INSERT INTO ec_b_login_rule(root_org_id, type, allow, creation_time, update_time) VALUES (16923, 'STUDENT_LOGIN', b'1', now(), now());

-- 新加系统通知表
CREATE TABLE `ec_b_sys_notice`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `content` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `end_time` datetime(0) NULL DEFAULT NULL,
  `root_org_id` bigint(20) NULL DEFAULT NULL,
  `start_time` datetime(0) NULL DEFAULT NULL,
  `enable` bit(1) NULL DEFAULT NULL,
  `title` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

#权限组新增报表模块
INSERT INTO ec_b_privilege_group(creation_time,update_time,code,name,type,ext1) VALUES (now(), now(), 'REPORTS_MENUS', '报表菜单', 'ADMIN_MENU',  'menu');


-------------------- 模块: basic End --------------------

#题库试卷模板表增加创建人 创建时间 修改时间 字段

ALTER TABLE `ec_q_export_template` ADD COLUMN `creation_by`  bigint(20) NULL DEFAULT NULL, ADD COLUMN `update_by`  bigint(20) NULL DEFAULT NULL, ADD COLUMN `update_time`  datetime NULL DEFAULT NULL;

#报表服务增加学生日志表

CREATE TABLE `ec_r_operate` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `exam_student_id` bigint(20) DEFAULT NULL,
  `msg_id` varchar(255) NOT NULL,
  `operate` varchar(255) NOT NULL,
  `operate_ip` varchar(255) DEFAULT NULL,
  `operate_time` datetime NOT NULL,
  `operate_user_id` bigint(20) DEFAULT NULL,
  `operate_user_type` varchar(255) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `student_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_OPERATE_03` (`msg_id`),
  KEY `IDX_R_OPERATE_01` (`root_org_id`,`student_id`),
  KEY `IDX_R_OPERATE_02` (`root_org_id`,`student_id`,`operate_time`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

#task服务新增在线人数统计任务、学生日志清理任务

INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(), now(), '0 0 2 * * ?', '学生总数', 1, 'REPORTS', 'studentTotalCountTask', 'studentTotalCountTask', 'studentTotalCountTask', 1);
INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(),now(), '20 * * * * ?', '在线考生', 1, 'REPORTS', 'examStudentOnlineCountTask', 'examStudentOnlineCountTask', 'examStudentOnlineCountTask', 1);
INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(), now(), '30 * * * * ?', '累计在线学生', 1, 'REPORTS', 'studentCumulativeCountTask', 'studentCumulativeCountTask', 'studentCumulativeCountTask', 1);
INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(), now(), '10 * * * * ?', '在线学生', 1, 'REPORTS', 'studentOnlineCountTask', 'studentOnlineCountTask', 'studentOnlineCountTask', 1);
INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(), now(), '10 * * * * ?', '在线用户', 1, 'REPORTS', 'userOnlineCountTask', 'userOnlineCountTask', 'userOnlineCountTask', 1);
INSERT INTO ec_t_schedule_job(creation_time,update_time,cron_expression,description,enable,ext1,job_group,job_name,spring_bean,stateful)
 VALUES (now(), now(), '0 0 3 * * ?', '学生操作日志清理', 1, 'REPORTS', 'studentOperateLogTask', 'studentOperateLogTask', 'studentOperateLogTask', 1);


-------------------- 模块: examwork start --------------------
-- 新增场次表
CREATE TABLE `ec_e_exam_stage`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `enable` bit(1) NOT NULL,
  `end_time` datetime(0) NULL DEFAULT NULL,
  `exam_id` bigint(20) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `special_setting` bit(1) NOT NULL,
  `stage_order` int(11) NOT NULL,
  `start_exam_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `start_time` datetime(0) NULL DEFAULT NULL,
  `submit_duration` int(11) NULL DEFAULT NULL,
  `submit_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_ES_001001`(`exam_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 新增场次设置表
CREATE TABLE `ec_e_exam_stage_setting`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `exam_id` bigint(20) NOT NULL,
  `submit_duration` int(11) NULL DEFAULT NULL,
  `submit_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `IDX_E_ESS_001001`(`exam_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 考生表新加场次id和场次号
ALTER TABLE ec_e_exam_student ADD exam_stage_id BIGINT(20) NULL, ADD exam_stage_order int(11) NULL;


-------------------- 模块: examwork End --------------------


-------------------- 模块: oe start--------------------

-- 新增断点记录临时表
CREATE TABLE `ec_oes_exam_continued_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `continued_time` datetime(0) NULL DEFAULT NULL,
  `exam_record_data_id` bigint(20) NULL DEFAULT NULL,
  `start_time` datetime(0) NULL DEFAULT NULL,
    `used_exam_time` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_O_E_C_R_001`(`exam_record_data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 新增断点记录归档表
CREATE TABLE `ec_oe_exam_continued_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `continued_time` datetime(0) NULL DEFAULT NULL,
  `exam_record_data_id` bigint(20) NULL DEFAULT NULL,
  `start_time` datetime(0) NULL DEFAULT NULL,
    `used_exam_time` bigint(20) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_O_E_C_R_001`(`exam_record_data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 新增考试过程临时表
CREATE TABLE `ec_oes_exam_process_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `exam_record_data_id` bigint(20) NULL DEFAULT NULL,
  `process_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `record_time` datetime(0) NULL DEFAULT NULL,
  `source_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_O_E_P_R_001`(`exam_record_data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 新增考试过程归档表
CREATE TABLE `ec_oe_exam_process_record`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `exam_record_data_id` bigint(20) NULL DEFAULT NULL,
  `process_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `record_time` datetime(0) NULL DEFAULT NULL,
  `source_ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_O_E_P_R_001`(`exam_record_data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- 新增考试记录作答文件表
CREATE TABLE `ec_oe_exam_record_file_answer`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime(0) NOT NULL,
  `update_time` datetime(0) NOT NULL,
  `exam_record_data_id` bigint(20) NULL DEFAULT NULL,
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `file_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `file_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `original_file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `properties` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `suffix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_E_O_E_R_F_A_001`(`exam_record_data_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 0 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;


-- -- 考生表字段调整
ALTER TABLE ec_oe_exam_student ADD exam_stage_id BIGINT(20) NULL, ADD exam_stage_order int(11) NULL;

-- 考试记录临时表字段新增
ALTER TABLE ec_oes_exam_record_data ADD `exam_stage_id` bigint(20) NULL DEFAULT NULL, ADD `exam_stage_order` int(11) NULL DEFAULT NULL, ADD `enter_exam_time` datetime(0) NULL DEFAULT NULL, ADD `continued_time` datetime(0) NULL DEFAULT NULL, ADD `last_active_time` datetime(0) NULL DEFAULT NULL;

-- 考试记录归档表字段新增
ALTER TABLE ec_oe_exam_record_data ADD `exam_stage_id` bigint(20) NULL DEFAULT NULL, ADD `exam_stage_order` int(11) NULL DEFAULT NULL, ADD `reexamine_detail` varchar(200) NULL DEFAULT NULL, ADD `reexamine_type` varchar(20) NULL DEFAULT NULL, ADD `switch_screen_count` int(11) NULL DEFAULT NULL, ADD `enter_exam_time` datetime(0) NULL DEFAULT NULL, ADD `continued_time` datetime(0) NULL DEFAULT NULL, ADD `last_active_time` datetime(0) NULL DEFAULT NULL;



- 补充


-- 考生临时表新加场次id和场次号
ALTER TABLE EC_T_EXAM_STUDENT_TMP ADD exam_stage_id BIGINT(20) NULL, ADD exam_stage_order int(11) NULL;


CREATE TABLE `ec_oe_export_task` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `exam_id` bigint(20) DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `status` varchar(50) NOT NULL,
  `status_msg` varchar(500) DEFAULT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_OE_ET_001` (`root_org_id`),
  KEY `IDX_OE_ET_002` (`exam_id`),
  KEY `IDX_OE_ET_003` (`type`),
  KEY `IDX_OE_ET_004` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_exam_course_data_report` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `avg_difficulty_degree` double DEFAULT NULL,
  `avg_score` double DEFAULT NULL,
  `cdi` double DEFAULT NULL,
  `course_code` varchar(255) NOT NULL,
  `course_id` bigint(20) NOT NULL,
  `course_name` varchar(255) NOT NULL,
  `exam_code` varchar(255) NOT NULL,
  `exam_id` bigint(20) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `full_count` bigint(20) NOT NULL,
  `max_score` double DEFAULT NULL,
  `min_score` double DEFAULT NULL,
  `participant_count` bigint(20) NOT NULL,
  `partition_data` varchar(255) NOT NULL,
  `pass_count` bigint(20) NOT NULL,
  `project_id` bigint(20) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `sign_count` bigint(20) NOT NULL,
  `std` double DEFAULT NULL,
  `total_score` double DEFAULT NULL,
  `zero_count` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_EXAM_COURSE_DATA_REPORT_01` (`project_id`,`root_org_id`,`exam_id`,`course_id`),
  KEY `IDX_R_EXAM_COURSE_DATA_REPORT_02` (`project_id`),
  KEY `IDX_R_EXAM_COURSE_DATA_REPORT_03` (`root_org_id`),
  KEY `IDX_R_EXAM_COURSE_DATA_REPORT_04` (`exam_id`),
  KEY `IDX_R_EXAM_COURSE_DATA_REPORT_05` (`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_user_count` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `online_count` int(11) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_USER_COUNT_01` (`root_org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_student_total_count` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `total_count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_STUDENT_TOTAL_COUNT_01` (`root_org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_student_cumulative_count` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `report_day` varchar(255) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `total_count` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_STUDENT_CUMULATIVE_COUNT_01` (`root_org_id`,`report_day`),
  KEY `IDX_R_STUDENT_CUMULATIVE_COUNT_02` (`report_day`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_student_count` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `online_count` int(11) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_STUDENT_COUNT_01` (`root_org_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_project` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `analyse_type` varchar(255) NOT NULL,
  `course_count` int(11) DEFAULT NULL,
  `data_origin` varchar(255) NOT NULL,
  `enable` bit(1) NOT NULL,
  `exam_ids` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `org_count` int(11) DEFAULT NULL,
  `partition_count` int(11) DEFAULT NULL,
  `partition_details` varchar(255) DEFAULT NULL,
  `pass_score` double DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  `report_status` varchar(255) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `sample_count` int(11) NOT NULL,
  `total_score` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_R_PROJECT_01` (`root_org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_exam_student_count` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `exam_id` bigint(20) NOT NULL,
  `online_count` int(11) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_EXAM_STUDENT_COUNT_01` (`root_org_id`,`exam_id`),
  KEY `IDX_R_EXAM_STUDENT_COUNT_02` (`exam_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_exam_org_report` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `exam_code` varchar(255) NOT NULL,
  `exam_id` bigint(20) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `org_code` varchar(255) NOT NULL,
  `org_id` bigint(20) NOT NULL,
  `org_name` varchar(255) NOT NULL,
  `participant_count` bigint(20) NOT NULL,
  `partition_data` varchar(255) NOT NULL,
  `pass_count` bigint(20) NOT NULL,
  `project_id` bigint(20) NOT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `sign_count` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_EXAM_ORG_REPORT_01` (`project_id`,`root_org_id`,`exam_id`,`org_id`),
  KEY `IDX_R_EXAM_ORG_REPORT_02` (`project_id`),
  KEY `IDX_R_EXAM_ORG_REPORT_03` (`root_org_id`),
  KEY `IDX_R_EXAM_ORG_REPORT_04` (`exam_id`),
  KEY `IDX_R_EXAM_ORG_REPORT_05` (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `ec_r_exam_data` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `creation_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `complete_count` int(11) DEFAULT NULL,
  `end_time` datetime NOT NULL,
  `exam_id` bigint(20) NOT NULL,
  `exam_name` varchar(255) NOT NULL,
  `exam_type` varchar(255) NOT NULL,
  `plan_count` int(11) DEFAULT NULL,
  `root_org_id` bigint(20) NOT NULL,
  `start_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_R_EXAM_DATA_01` (`root_org_id`,`exam_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


-- 离线数据上传的文件地址数据切割脚本（将ec_oe_exam_record_4_marking表中的offline_file_url和offline_file_name字段）切到新表ec_oe_exam_record_file_answer
使用通用的数据处理工具来执行，目录：‪\examcloud-oe-tool\src\main\java\cn\com\qmth\dp\examcloud\oe\modules\cut_exam_offline_data\CutExamOfflineDataService.java





################################## 警告 ##################################
################################## 警告 ##################################
################################## 警告 ##################################
删除考试记录待阅卷表中的离线 文件字段 （!！important!!!!!谨慎操作，一定要待 《离线文件数据切割》切割完成后再执行下面语句）

-- ALTER TABLE ec_oe_exam_record_4_marking DROP column `offline_file_url`, DROP column `offline_file_name`;


-------------------- 模块: oe end--------------------