examcloud-upgrade/upgrade-202001/question.sql

----------------------------------------------------------------后端服务启动前执行-----------------------------------------------------------------------------------------
--题库新增试卷导出模板表
CREATE TABLE `ec_q_export_template` (
	`id` BIGINT (20) NOT NULL AUTO_INCREMENT,
	`create_user` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 `creation_time` datetime NOT NULL,
 `enable` bit (1) NOT NULL,
 `file_key` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 `file_name` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 `file_path` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 `root_org_id` BIGINT (20) NOT NULL,
 `suffix` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 `type` VARCHAR (255) CHARACTER
SET utf8 COLLATE utf8_general_ci NOT NULL,
 PRIMARY KEY (`id`),
 INDEX `IDX_Q_EXPORT_TEMPLATE_01` (`root_org_id`) USING BTREE
) ENGINE = INNODB DEFAULT CHARACTER
SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;


----------------------------------------------------------------后端服务启动后执行------------------------------------------------------------------------------------------