465 lines
33 KiB
Plaintext
465 lines
33 KiB
Plaintext
-- --------------------------------------- 2020-03-21 zhangpf begin -----------------
|
|
-- 培训计划
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_TRAIN_PLAN`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`TRAINCATEGORY` VARCHAR(36) DEFAULT NULL COMMENT '培训类型',
|
|
`TRAINSCOPE` VARCHAR(36) DEFAULT NULL COMMENT '内部/外部(培训范围)',
|
|
`THEME` VARCHAR(540) DEFAULT NULL COMMENT '培训主题',
|
|
`LECTURER` VARCHAR(270) DEFAULT NULL COMMENT '培训讲师',
|
|
`TRAINTIME` VARCHAR(270) DEFAULT NULL COMMENT '培训时间',
|
|
`REMARK` VARCHAR(540) DEFAULT NULL COMMENT '备注说明',
|
|
`STATUS` VARCHAR(36) DEFAULT NULL COMMENT '状态(未提交,审核中,已退回,待实施,已实施)',
|
|
`PROCESSSTATUS` VARCHAR(18) DEFAULT NULL COMMENT '流程状态',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='培训计划';
|
|
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_TRAIN_PLAN_USER`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`TRAINPLANID` BIGINT DEFAULT NULL COMMENT '培训计划ID',
|
|
`USERID` VARCHAR(36) DEFAULT NULL COMMENT '培训计划培训参与人员编码',
|
|
`USERNAME` VARCHAR(60) DEFAULT NULL COMMENT '培训计划培训参与人员名称',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='培训计划参与人员';
|
|
CREATE INDEX IDX_CORE_TRAIN_PLAN_USER_TRAINPLANID ON T_CORE_TRAIN_PLAN_USER(TRAINPLANID);
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_TRAIN_PLAN', '1', '1');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
|
|
VALUES ('T_CORE_TRAIN_PLAN_USER', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('20200306001', 'T_CORE_TRAIN_PLAN_USER', 'T_CORE_TRAIN_PLAN', 'TRAINPLANID');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
|
|
VALUES (F_GET_SEQ_CORE(), '培训计划', '培训计划', 'train-plan', '/secure/core/module/train/train-plans/page/choose-list', '');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE, EXT)
|
|
VALUES ('9323', '培训计划', 'T_CORE_TRAIN_PLAN', 'audit_def', '1', NULL);
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreTrainCategory', '培训类型', 'biz', NULL, '100', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '安全培训', 'coreTrainCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'safetyTraining');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '理论培训', 'coreTrainCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'theoreticalTraining');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreTrainScope', '内部/外部', 'sys', NULL, '101', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '内部', 'coreTrainScope', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'internal');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '外部', 'coreTrainScope', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'external');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('98', '培训考核', NULL, NULL, '98', '培训考核', '017.svg', '');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9801', '培训计划管理', '/secure/core/module/train/train-plans/page/edit-list', '98', '9801', '培训计划编制列表', '005.svg', '');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9802', '培训计划审核', '/secure/core/module/train/train-plans/page/audit-list?currentStatusCode=approve', '98', '9802', '培训计划编制列表', '022.svg', '');
|
|
|
|
-- 培训实施
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_TRAIN`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`TRAINPLANID` BIGINT DEFAULT NULL COMMENT '培训计划ID',
|
|
`TRAINMETHOD` VARCHAR(36) DEFAULT NULL COMMENT '培训方式',
|
|
`LOCATION` VARCHAR(270) DEFAULT NULL COMMENT '培训地点',
|
|
`TRAINTIME` VARCHAR(270) DEFAULT NULL COMMENT '培训时间',
|
|
`TRAININGMATERIAL` VARCHAR(270) DEFAULT NULL COMMENT '培训教材',
|
|
`ASSESSMENTMETHOD` VARCHAR(36) DEFAULT NULL COMMENT '考核方式',
|
|
`EXAMID` BIGINT DEFAULT NULL COMMENT '试卷ID',
|
|
`EVALUATION` VARCHAR(540) DEFAULT NULL COMMENT '考核效果评价',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '启用标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '启用人ID',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '启用人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='培训实施';
|
|
CREATE INDEX IDX_CORE_TRAIN_TRAINPLANID ON T_CORE_TRAIN(TRAINPLANID);
|
|
CREATE INDEX IDX_CORE_TRAIN_EXAMID ON T_CORE_TRAIN(EXAMID);
|
|
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_TRAIN_USER`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`TRAINID` BIGINT DEFAULT NULL COMMENT '培训实施ID',
|
|
`USERID` VARCHAR(36) DEFAULT NULL COMMENT '培训参与人员编码',
|
|
`USERNAME` VARCHAR(60) DEFAULT NULL COMMENT '培训参与人员名称',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '启用标志/签到标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '启用人ID/签到人ID',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '启用人名称/签到人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间/签到时间',
|
|
`SCORE` VARCHAR(60) DEFAULT NULL COMMENT '考核成绩',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='培训实施参与人员';
|
|
CREATE INDEX IDX_CORE_TRAIN_USER_TRAINID ON T_CORE_TRAIN_USER(TRAINID);
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_TRAIN', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
|
|
VALUES ('T_CORE_TRAIN_USER', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('20200306002', 'T_CORE_TRAIN_USER', 'T_CORE_TRAIN', 'TRAINID');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreTrainMethod', '培训方式', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), 'PPT课件', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'ppt');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '实操', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'operation');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '其他', 'coreTrainMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'other');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreAssessmentMethod', '考核方式', 'sys', NULL, '101', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '在线考试', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'testOnline');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '笔试', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'writtenExamination');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '实操', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'operation');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '其他', 'coreAssessmentMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'other');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9803', '培训实施', '/secure/core/module/train/trains/page/edit-list', '98', '9803', '培训实施编制列表', '046.svg', '');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9804', '培训实施签到', '/secure/core/module/train/trains/page/search-list', '98', '9804', '培训实施查询列表', '008.svg', '');
|
|
|
|
-- 试卷模板
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_EXAM_TMPL`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`TMPLNAME` VARCHAR(270) DEFAULT NULL COMMENT '试卷模板名称',
|
|
`SINGLECHOICEQTY` INT DEFAULT NULL COMMENT '单选题个数',
|
|
`SINGLECHOICESCORE` INT DEFAULT NULL COMMENT '单选题分值(/个)',
|
|
`MULTIPLECHOICEQTY` INT DEFAULT NULL COMMENT '多选题个数',
|
|
`MULTIPLECHOICESCORE` INT DEFAULT NULL COMMENT '多选题分值(/个)',
|
|
`JUDGEMENTQTY` INT DEFAULT NULL COMMENT '判断题个数',
|
|
`JUDGEMENTSCORE` INT DEFAULT NULL COMMENT '判断题分值(/个)',
|
|
`SHORTANSWERQTY` INT DEFAULT NULL COMMENT '简答题个数',
|
|
`SHORTANSWERSCORE` INT DEFAULT NULL COMMENT '简答题分值(/个)',
|
|
`TOTALSCORE` INT DEFAULT NULL COMMENT '试卷总分',
|
|
`CITATIONQTY` INT DEFAULT NULL COMMENT '引用次数',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '启用标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '启用人ID',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '启用人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='试卷模板';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_EXAM_TMPL', '0', '0');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
|
|
VALUES (F_GET_SEQ_CORE(), '试卷模板', '试卷模板', 'exam-tmpl', '/secure/core/module/train/exam-tmpls/page/choose-list', '');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9805', '试卷模板', '/secure/core/module/train/exam-tmpls/page/edit-list', '98', '9805', '试卷模板编制列表', '029.svg', '');
|
|
|
|
-- 题目
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_QUESTION`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`QUESTIONCATEGORY` VARCHAR(36) DEFAULT NULL COMMENT '题目类别',
|
|
`QUESTIONTYPE` VARCHAR(36) DEFAULT NULL COMMENT '题目类型',
|
|
`QUESTIONCONTENT` VARCHAR(540) DEFAULT NULL COMMENT '题目内容',
|
|
`ANSWER` VARCHAR(1080) DEFAULT NULL COMMENT '答案',
|
|
`JUDGEMENTANSWER` VARCHAR(36) DEFAULT NULL COMMENT '判断题答案',
|
|
`QUESTIONTYPEORDERNO` INT(4) DEFAULT NULL COMMENT '题目类型排序号',
|
|
`LASTUPDATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '维护人编码',
|
|
`LASTUPDATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '维护人名称',
|
|
`LASTUPDATEDTIME` DATETIME DEFAULT NULL COMMENT '维护时间',
|
|
`LASTSUSPENDEDFLAG` VARCHAR(1) NULL COMMENT '注销标志(逻辑删除标志)(0-正常,1-停用) 默认为0',
|
|
`LASTSUSPENDEDBYID` VARCHAR(36) NULL COMMENT '注销人ID',
|
|
`LASTSUSPENDEDBYNAME` VARCHAR(60) NULL COMMENT '注销人名称',
|
|
`LASTSUSPENDEDTIME` DATETIME NULL COMMENT '注销时间',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '启用标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '启用人ID',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '启用人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='题目';
|
|
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_QUESTION_OPT`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`QUESTIONID` BIGINT DEFAULT NULL COMMENT '题目ID',
|
|
`OPTCODE` VARCHAR(30) DEFAULT NULL COMMENT '序号',
|
|
`OPTCONTENT` VARCHAR(540) DEFAULT NULL COMMENT '选项内容',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='题目选项';
|
|
|
|
CREATE INDEX IDX_CORE_QUESTION_OPT_QUESTIONID ON T_CORE_QUESTION_OPT(QUESTIONID);
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_QUESTION', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
|
|
VALUES ('T_CORE_QUESTION_OPT', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('20200306003', 'T_CORE_QUESTION_OPT', 'T_CORE_QUESTION', 'QUESTIONID');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreQuestionCategory', '题目类别', 'biz', NULL, '100', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '安全培训', 'coreQuestionCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'safetyTraining');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '理论培训', 'coreQuestionCategory', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'theoreticalTraining');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreQuestionType', '题目类型', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '单选题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'singleChoice');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '多选题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'multipleChoice');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '判断题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'judgement');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '简答题', 'coreQuestionType', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'shortAnswer');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9806', '题库管理', '/secure/core/module/train/questions/page/edit-list', '98', '9806', '题目编制列表', '066.svg', '');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreJudgementOption', '判断题选项', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '对', 'coreJudgementOption', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'correct');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '错', 'coreJudgementOption', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'incorrect');
|
|
|
|
-- 试卷
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_EXAM`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`EXAMNAME` VARCHAR(270) DEFAULT NULL COMMENT '试卷名称',
|
|
`QUESTIONMETHOD` VARCHAR(36) DEFAULT NULL COMMENT '组卷方式',
|
|
`EXAMTMPLID` BIGINT DEFAULT NULL COMMENT '试卷模板ID',
|
|
`EXAMBEGINTIME` DATETIME DEFAULT NULL COMMENT '考试开始时间',
|
|
`EXAMENDTIME` DATETIME DEFAULT NULL COMMENT '考试结束时间',
|
|
`EXAMDURATION` INT DEFAULT NULL COMMENT '考试时长',
|
|
`EXAMCATEGORY` VARCHAR(36) DEFAULT NULL COMMENT '试卷类别',
|
|
`SINGLECHOICEQTY` INT DEFAULT NULL COMMENT '单选题个数',
|
|
`MULTIPLECHOICEQTY` INT DEFAULT NULL COMMENT '多选题个数',
|
|
`JUDGEMENTQTY` INT DEFAULT NULL COMMENT '判断题个数',
|
|
`SHORTANSWERQTY` INT DEFAULT NULL COMMENT '简答题个数',
|
|
`TMPLSINGLECHOICEQTY` INT DEFAULT NULL COMMENT '模板单选题个数',
|
|
`TMPLMULTIPLECHOICEQTY` INT DEFAULT NULL COMMENT '模板多选题个数',
|
|
`TMPLJUDGEMENTQTY` INT DEFAULT NULL COMMENT '模板判断题个数',
|
|
`TMPLSHORTANSWERQTY` INT DEFAULT NULL COMMENT '模板简答题个数',
|
|
`LASTUPDATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '维护人编码',
|
|
`LASTUPDATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '维护人名称',
|
|
`LASTUPDATEDTIME` DATETIME DEFAULT NULL COMMENT '维护时间',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '启用标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '启用人ID',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '启用人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='试卷';
|
|
CREATE INDEX IDX_CORE_EXAM_EXAMTMPLID ON T_CORE_EXAM(EXAMTMPLID);
|
|
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_EXAM_QUESTION`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`QUESTIONID` BIGINT DEFAULT NULL COMMENT '题目ID',
|
|
`EXAMID` BIGINT DEFAULT NULL COMMENT '试卷ID',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='试卷题目';
|
|
CREATE INDEX IDX_CORE_EXAM_QUESTION_QUESTIONID ON T_CORE_EXAM_QUESTION(QUESTIONID);
|
|
CREATE INDEX IDX_CORE_EXAM_QUESTION_EXAMID ON T_CORE_EXAM_QUESTION(EXAMID);
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_EXAM', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT )
|
|
VALUES ('T_CORE_EXAM_QUESTION', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('20200306004', 'T_CORE_EXAM_QUESTION', 'T_CORE_EXAM', 'EXAMID');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME)
|
|
VALUES ('coreQuestionMethod', '组卷方式', 'sys', NULL, '100', NULL, NULL, NULL, NULL);
|
|
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '系统随机', 'coreQuestionMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'random');
|
|
INSERT INTO T_CORE_CODE(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES (F_GET_SEQ_CORE(), '人工组卷', 'coreQuestionMethod', NULL, NULL, NULL, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'manual');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG(ID, NAME, TITLE, CATEGORY, URL, WIDTH)
|
|
VALUES (F_GET_SEQ_CORE(), '试卷', '试卷', 'exam', '/secure/core/module/train/exams/page/choose-list', '');
|
|
|
|
INSERT INTO t_core_menu (`ID`, `MENUNAME`, `HREF`, `PARENTID`, `ORDERNO`, `MENUINITNAME`, `ICON`, `TODOICON`)
|
|
VALUES ('9807', '试卷管理', '/secure/core/module/train/exams/page/edit-list', '98', '9807', '试卷编制列表', '055.svg', '');
|
|
|
|
-- 考卷
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_EXAM_PAPER`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`EXAMID` BIGINT DEFAULT NULL COMMENT '试卷ID',
|
|
`TRAINID` BIGINT DEFAULT NULL COMMENT '培训实施ID',
|
|
`ACTBEGINTIME` DATETIME DEFAULT NULL COMMENT '开始时间',
|
|
`ACTENDTIME` DATETIME DEFAULT NULL COMMENT '结束时间',
|
|
`SCORE` BIGINT DEFAULT NULL COMMENT '考试成绩',
|
|
`USERID` VARCHAR(36) DEFAULT NULL COMMENT '考卷用户Id',
|
|
`USERNAME` VARCHAR(60) DEFAULT NULL COMMENT '考卷用户名称',
|
|
`STATUS` VARCHAR(18) DEFAULT NULL COMMENT '考试状态(draft-未考/done-已考)',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
`ACTIVATEDFLAG` VARCHAR(1) NULL COMMENT '阅卷完成标志',
|
|
`ACTIVATEDBYID` VARCHAR(36) NULL COMMENT '阅卷人编码',
|
|
`ACTIVATEDBYNAME` VARCHAR(60) NULL COMMENT '阅卷人名称',
|
|
`ACTIVATEDTIME` DATETIME NULL COMMENT '启用时间/签到时间',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='考卷';
|
|
|
|
CREATE TABLE IF NOT EXISTS `T_CORE_EXAM_PAPER_ANSWER`(
|
|
`ID` BIGINT NOT NULL COMMENT '主键',
|
|
`EXAMID` BIGINT DEFAULT NULL COMMENT '试卷ID',
|
|
`EXAMPAPERID` BIGINT DEFAULT NULL COMMENT '考卷ID',
|
|
`EXAMQUESTIONID` BIGINT DEFAULT NULL COMMENT '试卷题目ID',
|
|
`QUESTIONID` BIGINT DEFAULT NULL COMMENT '题目ID',
|
|
`ANSWER` VARCHAR(1080) DEFAULT NULL COMMENT '答案',
|
|
`JUDGEMENTANSWER` VARCHAR(1080) DEFAULT NULL COMMENT '判断题答案',
|
|
`SCORE` BIGINT DEFAULT NULL COMMENT '得分',
|
|
`ORDERNO` INT DEFAULT NULL COMMENT '排序号',
|
|
`CREATEDBYID` VARCHAR(36) DEFAULT NULL COMMENT '制单人编码',
|
|
`CREATEDBYNAME` VARCHAR(60) DEFAULT NULL COMMENT '制单人名称',
|
|
`CREATEDTIME` DATETIME DEFAULT NULL COMMENT '制单时间',
|
|
`CREATEDBYORGID` VARCHAR(36) DEFAULT NULL COMMENT '制单人单位编码',
|
|
`CREATEDBYORGNAME` VARCHAR(270) DEFAULT NULL COMMENT '制单人单位名称',
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='考卷答案';
|
|
CREATE INDEX IDX_CORE_EXAM_PAPER_ANSWER_EXAMPAPERID ON T_CORE_EXAM_PAPER_ANSWER (EXAMPAPERID);
|
|
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('9808', '我的考试', '/secure/core/module/train/exam-papers/page/edit-list', '98', '9808', '009.svg', '我的考试');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('9809', '考试阅卷', '/secure/core/module/train/exam-papers/page/review-list', '98', '9809', '041.svg', '考试阅卷');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_EXAM_PAPER', '0', '0');
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_CORE_EXAM_PAPER_ANSWER', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('20200306005','T_CORE_EXAM_PAPER_ANSWER', 'T_CORE_EXAM_PAPER', 'EXAMPAPERID');
|
|
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_PAPER$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_PAPER$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-paper-review-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_TMPL$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_EXAM_TMPL$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-exam-tmpl-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_QUESTION$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_QUESTION$ACTIVE$1', '{\r\n \"readonly\": true\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN$ACTIVE$0', '{\r\n \"readonly\": false\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN$ACTIVE$1', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-train-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n },\r\n \"form\": {\r\n \"core-train-detail-base-info-form\": {\r\n \"evaluation\": {\r\n \"readonly\": false\r\n }\r\n }\r\n },\r\n \"grid\": {\r\n \"core-train-detail-user-list-grid\": {\r\n \"score\": {\r\n \"readonly\": false\r\n }\r\n }\r\n }\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN_PLAN$BPMN$approve', '{\r\n \"readonly\": true,\r\n \"button\": {\r\n \"core-train-plan-detail-btn-pass\": {\r\n \"hidden\": false\r\n },\r\n \"core-train-plan-detail-btn-reject\": {\r\n \"hidden\": false\r\n },\r\n \"core-train-plan-detail-btn-back\": {\r\n \"hidden\": false\r\n }\r\n }\r\n}');
|
|
INSERT INTO t_core_page_view_config VALUES ('T_CORE_TRAIN_PLAN$BPMN$draft', '{\r\n \"readonly\": false,\r\n \"button\": {\r\n \"core-train-plan-detail-btn-pass\": {\r\n \"hidden\": true\r\n },\r\n \"core-train-plan-detail-btn-reject\": {\r\n \"hidden\": true\r\n }\r\n }\r\n}');
|
|
COMMIT;
|
|
-- --------------------------------------- 2020-03-21 zhangpf end -----------------
|
|
-- --------------------------------------- 2020-04-22 zhangpf begin -----------------
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false,"button":{"core-train-plan-detail-btn-pass":{"hidden": true},"core-train-plan-detail-btn-reject": {"hidden": true}}}'
|
|
WHERE ID = 'T_CORE_TRAIN_PLAN$BPMN$draft';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true,"button":{"core-train-plan-detail-btn-pass":{"hidden": false},"core-train-plan-detail-btn-reject":{"hidden": false},"core-train-plan-detail-btn-back": {"hidden": false}}}'
|
|
WHERE ID = 'T_CORE_TRAIN_PLAN$BPMN$approve';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false}'
|
|
WHERE ID = 'T_CORE_TRAIN$ACTIVE$0';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true,"button": {"core-train-detail-btn-back": {"hidden": false}},"form": {"core-train-detail-base-info-form":
|
|
{"evaluation": {"readonly": false}}},"grid": {"core-train-detail-user-list-grid": {"score": {"readonly": false}}}}'
|
|
WHERE ID = 'T_CORE_TRAIN$ACTIVE$1';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false}'
|
|
WHERE ID = 'T_CORE_QUESTION$ACTIVE$0';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true}'
|
|
WHERE ID = 'T_CORE_QUESTION$ACTIVE$1';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false}'
|
|
WHERE ID = 'T_CORE_EXAM_TMPL$ACTIVE$0';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true,"button": {"core-exam-tmpl-detail-btn-back": {"hidden": false}}}'
|
|
WHERE ID = 'T_CORE_EXAM_TMPL$ACTIVE$1';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false}'
|
|
WHERE ID = 'T_CORE_EXAM_PAPER$ACTIVE$0';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true,"button": {"core-exam-paper-review-detail-btn-back": {"hidden": false}}}'
|
|
WHERE ID = 'T_CORE_EXAM_PAPER$ACTIVE$1';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": false}'
|
|
WHERE ID = 'T_CORE_EXAM$ACTIVE$0';
|
|
|
|
UPDATE T_CORE_PAGE_VIEW_CONFIG
|
|
SET CONFIG = '{"readonly": true,"button": {"core-exam-detail-btn-back": {"hidden": false}}}'
|
|
WHERE ID = 'T_CORE_EXAM$ACTIVE$1';
|
|
COMMIT;
|
|
-- --------------------------------------- 2020-04-22 zhangpf end ----------------- |