server/sql/sql.sql

INSERT INTO `frame_dict` (`DICT_NAME`, `DICT_VALUE`, `DICT_TEXT`, `DICT_ORDER`) VALUES ('TextFormart', 'text', '文本', 1);
INSERT INTO `frame_dict` (`DICT_NAME`, `DICT_VALUE`, `DICT_TEXT`, `DICT_ORDER`) VALUES ('TextFormart', 'date', '日期', 2);
INSERT INTO `frame_dict` (`DICT_NAME`, `DICT_VALUE`, `DICT_TEXT`, `DICT_ORDER`) VALUES ('TextFormart', 'number', '数字', 3);
CREATE TABLE `cf_material_text_attr` (
                                         `attr_id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
                                         `material_def_id` int DEFAULT NULL COMMENT '定义ID',
                                         `attr_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文字标题',
                                         `attr_requrid` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '是否必填',
                                         `attr_formart` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文字格式',
                                         PRIMARY KEY (`attr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `std_apply_detail_text` (
                                         `detail_id` int NOT NULL COMMENT '申请ID',
                                         `text_id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                         `attr_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文字标题',
                                         `attr_text` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文字内容',
                                         `attr_id` int DEFAULT NULL,
                                         PRIMARY KEY (`text_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='考生材料申请表';

INSERT INTO `frame_dict` (`DICT_NAME`, `DICT_VALUE`, `DICT_TEXT`, `DICT_ORDER`) VALUES ('DeptType', 'SecondLevel', '二级学院', 5);

ALTER TABLE `cf_aspect`
    ADD COLUMN `dept_id` int NULL COMMENT '二级学院ID' AFTER `school_id`;


--2023.7.11
CREATE TABLE `cf_subject` (
                              `SUBJECT_ID` int NOT NULL AUTO_INCREMENT COMMENT '科目编号（内部编号）',
                              `school_id` int DEFAULT NULL COMMENT '关联编号',
                              `batch_id` int DEFAULT NULL COMMENT '批次ID',
                              `SUBJECT_NAME` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '科目名称',
                              `SUBJECT_CODE` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '科目编号',
                              `exam_start_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '考试开始时间',
                              `exam_end_time` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '考试结束时间',
                              `aspect_id` int DEFAULT NULL COMMENT '科目的管理单位',
                              PRIMARY KEY (`SUBJECT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='配置表-科目信息配置表';

CREATE TABLE `ly_room` (
                           `room_id` int NOT NULL AUTO_INCREMENT COMMENT '考场ID',
                           `school_id` int DEFAULT NULL COMMENT '学校ID',
                           `batch_id` int DEFAULT NULL COMMENT '批次ID',
                           `room_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '考场编号',
                           `room_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '教室编号',
                           `room_addr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '考试地点',
                           `room_capacity` int DEFAULT NULL COMMENT '考场容量',
                           `layout_num` int DEFAULT NULL COMMENT '已编排',
                           `mix_max` int DEFAULT NULL COMMENT '最大混编数',
                           PRIMARY KEY (`room_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `frame_res` (`RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC`)
VALUES (20801, '考试科目', NULL, '/ly/room/page', 20000, 1, 'Page', '', 'Active', 20801, NULL);
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 20901, '考场配置', NULL, '/ly/room/page', 20000, 1, 'Page', '', 'Active', 20901, NULL );
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 30601, '考试编排', NULL, '/ly/layout/page', 30000, 1, 'Page', '', 'Active', 30601, NULL );



ALTER TABLE `cf_batch`
    ADD COLUMN `dept_id` int NULL COMMENT '二级学院ID' AFTER `school_id`;

---2023.8.16 dhshu
ALTER TABLE `cf_aspect`
    ADD COLUMN `is_practice` int NULL COMMENT '理论或实践。0，1' AFTER `initial_pass_cnt`;
ALTER TABLE `cf_batch`
    ADD COLUMN `intial_show_start` datetime NULL DEFAULT NULL COMMENT '初审结果开始时间' AFTER `intial_review_end`,
ADD COLUMN `intial_show_end` datetime NULL DEFAULT NULL COMMENT '初审结果结束时间' AFTER `intial_show_start`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`batch_id`) USING BTREE;
-----2023.8.17 dhshu
ALTER TABLE `std_upload`
    MODIFY COLUMN `file_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'jpg,mp4,pdf,png' AFTER `detail_id`;
ALTER TABLE `cf_subject`
    ADD COLUMN `subject_type` varchar(255) NULL COMMENT '科目类型' AFTER `batch_id`;
ALTER TABLE `ly_room`
DROP COLUMN `mix_max`,
ADD COLUMN `is_provence` varchar(255) NULL COMMENT '省内考场' AFTER `layout_num`;

CREATE TABLE `ly_group` (
                            `group_id` int NOT NULL AUTO_INCREMENT COMMENT '分组ID',
                            `group_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                            `school_id` int DEFAULT NULL COMMENT '学校ID',
                            `batch_id` int DEFAULT NULL COMMENT '批次ID',
                            `is_practice` int DEFAULT NULL COMMENT '理论或实践。0，1',
                            `total` int DEFAULT NULL COMMENT '准考人数',
                            `provence` int DEFAULT NULL COMMENT '省内',
                            `status` int DEFAULT NULL COMMENT '编排状态',
                            PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='编排分组设置';

ALTER TABLE `std_reg`
    ADD COLUMN `is_provence` int NULL COMMENT '是否省内' AFTER `cert_id`;
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 20503, '初审账号类型增加', NULL, '', 20500, 1, 'Fun', '', 'Active', 20502, NULL );
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 20504, '初审账号类型修改', NULL, '', 20500, 1, 'Fun', '', 'Active', 20502, NULL );
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 20505, '初审账号类型删除', NULL, '', 20500, 1, 'Fun', '', 'Active', 20502, NULL );

ALTER TABLE `ly_room`
    ADD COLUMN `group_id` int NULL COMMENT 'group_id' AFTER `batch_id`;
ALTER TABLE `cf_subject`
    ADD COLUMN `group_id` int NULL COMMENT 'group_id' AFTER `batch_id`;

-- 2023.9.4
UPDATE `frame_res` SET `RES_NAME` = '考试编排查询', `RES_ALIAS` = NULL, `RES_URL` = '/ly/layout/page', `RES_PID` = 30000, `RES_LEVEL` = 1, `RES_TYPE` = 'Page', `RES_CSS` = '', `RES_STATUS` = 'Active', `RES_ORDER` = 30601, `RES_DESC` = NULL WHERE `RES_ID` = 30601;
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 30701, '考试分组编排', NULL, '/ly/group/page', 30000, 1, 'Page', '', 'Active', 30701, NULL );
ALTER TABLE `cf_aspect`
    ADD COLUMN `order` int NULL COMMENT '编排排序' AFTER `batch_id`;
ALTER TABLE  `ly_group`
    ADD COLUMN `aspect_order` varchar(255) NULL COMMENT '是否按专业排序' AFTER `batch_id`;
ALTER TABLE `ly_group`
    ADD COLUMN `ly_order` int NULL COMMENT '编排顺序' AFTER `batch_id`;
ALTER TABLE `ly_group`
    ADD COLUMN `provence_flag` varchar(255) NULL COMMENT '是否省内外考场' AFTER `batch_id`;
ALTER TABLE `cf_subject`
DROP COLUMN `aspect_id`;
CREATE TABLE `ly_subject` (
                              `SUBJECT_ID` int NOT NULL COMMENT '科目ID',
                              `enrol_id` int NOT NULL COMMENT '报考ID',
                              UNIQUE KEY `uni` (`SUBJECT_ID`,`enrol_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='报考科目表';


--20239.21
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 20405, '专业导入', NULL, '', 20400, 1, 'Fun', '', 'Active', 20405, NULL );
ALTER TABLE `cf_aspect`
    CHANGE COLUMN `order` `ly_order` int NULL DEFAULT NULL COMMENT '编排排序' AFTER `batch_id`;
CREATE TABLE `cf_subject_aspect` (
                                     `SUBJECT_ID` int NOT NULL COMMENT '科目ID',
                                     `aspect_id` int DEFAULT NULL COMMENT '方向ID',
                                     PRIMARY KEY (`SUBJECT_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='配置表-科目方向配置表';
INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 50900, '资格审核复查', '资格审核复查', '/review/recheck/page', 50000, 2, 'Page', '', 'Active', 50900, NULL );
CREATE TABLE `cf_initial_re_optr_detail` (
                                             `main_id` int DEFAULT NULL COMMENT '关联主记录ID',
                                             `optr_id` int DEFAULT NULL COMMENT '账号ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='资格复审老师账号明细';
ALTER TABLE `std_apply_main`
    ADD COLUMN `initial_review_re_optr` int NULL DEFAULT NULL COMMENT '资格复审老师ID' AFTER `initial_review_optr`;
ALTER TABLE `cf_initial_optr`
    ADD COLUMN `re_optr_cnt` tinyint NULL DEFAULT NULL COMMENT '账号数量' AFTER `optr_cnt`;

--20231213
ALTER TABLE `std_apply_main`
    ADD COLUMN `real_initial_review_optr` int NULL DEFAULT NULL COMMENT '实际初审评审老师ID' AFTER `re_check_time`;
ALTER TABLE `std_apply_detail`
    ADD COLUMN `real_initial_review_optr` int NULL DEFAULT NULL COMMENT '实际初审评审老师ID' AFTER `back_status`;

ALTER TABLE `frame_optr`
    ADD COLUMN `modify_time` datetime NULL COMMENT '修改时间' AFTER `CREATE_TIME`;
INSERT INTO `frame_res` (`RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC`) VALUES (998, '登陆修改用户名', '登陆修改用户名', NULL, 1030, 3, 'Fun', NULL, 'Active', 1, NULL);

ALTER TABLE `cf_batch`
    ADD COLUMN `show_upload_start` datetime NULL COMMENT '上传显示时间' AFTER `score_check_public_end`,
ADD COLUMN `show_upload_end` datetime NULL COMMENT '上传显示时间' AFTER `show_upload_start`;

INSERT INTO `frame_res` ( `RES_ID`, `RES_NAME`, `RES_ALIAS`, `RES_URL`, `RES_PID`, `RES_LEVEL`, `RES_TYPE`, `RES_CSS`, `RES_STATUS`, `RES_ORDER`, `RES_DESC` )
VALUES
    ( 2019, '发送失败消息', NULL, '/weixin/log/page', 2010, 3, 'Page', 'icon-docs text-dodgerblue', 'Active', 2019, NULL );



INSERT INTO `mr2022`.`frame_report` (`REPORT_ID`, `REPORT_NAME`, `REPORT_ALIAS`, `RES_ID`, `REPORT_SQL`, `REPORT_PARAM`, `REPORT_PARAM_FLAG`, `REPORT_SUFFIX`, `INDEX_FLAG`, `REPORT_TYPE`, `WITH_THREAD`) VALUES (3, 'MsgFailExport', '消息失败考生名单', NULL, 'select l.*,r.std_name,r.cert_id,r.std_mobile from wx_template_log l left join std_reg r on r.weixin_id=l.OPEN_ID where l.result_status!=0', null, NULL, NULL, 'Active', NULL, NULL);


INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 1, 'std_name', 15, '考生姓名', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 2, 'cert_id', 15, '身份证', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 3, 'std_mobile', 15, '联系电话', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 4, 'log_time', 15, '记录时间', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 5, 'result_status', 15, '发送状态', 'java.lang.String', 'Active', NULL);INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 6, 'result_msg', 15, '错误信息', 'java.lang.String', 'Active', NULL);INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('MsgFailExport', 7, 'template_msg', 15, '信息', 'java.lang.String', 'Active', NULL);


INSERT INTO `mr2022`.`frame_report` (`REPORT_ID`, `REPORT_NAME`, `REPORT_ALIAS`, `RES_ID`, `REPORT_SQL`, `REPORT_PARAM`, `REPORT_PARAM_FLAG`, `REPORT_SUFFIX`, `INDEX_FLAG`, `REPORT_TYPE`, `WITH_THREAD`) VALUES (4, 'exportNoPassed', '不予准考考生名单', NULL, 'SELECT
	m.std_id,
	s.std_name,
	m.review_level,
	e.exam_id,
	s.std_edu,
	s.std_mobile,
	e.enr_doct_name,
	x.major_name,
	f.aspect_name,
	ro.optr_name real_optr_name
FROM
	std_apply_main m
	LEFT JOIN frame_optr ro ON ro.optr_id = m.real_initial_review_optr
	INNER JOIN cf_aspect f ON f.aspect_id = m.aspect_id
	AND f.school_id = m.school_id
	AND f.batch_id = m.batch_id
	INNER JOIN cf_aspect_optr o ON o.aspect_id = f.aspect_id
	AND o.school_id = f.school_id
	AND o.batch_id = f.batch_id
	INNER JOIN cf_major x ON x.major_id = f.major_id
	AND f.school_id = f.school_id
	AND x.batch_id = f.batch_id
	LEFT JOIN std_reg s ON s.school_id = m.school_id
	AND s.std_id = m.std_id
	LEFT JOIN std_enrol e ON e.school_id = m.school_id
	AND e.std_id = m.std_id
	AND e.STATUS = \'Active\'
WHERE
	m.review_level > f.pass_cnt
	AND m.school_id =?
	AND m.batch_id =?
ORDER BY
	m.review_level', 'school_id\r\nbatch_id', NULL, NULL, 'Active', NULL, NULL);
INSERT INTO `mr2022`.`frame_report` (`REPORT_ID`, `REPORT_NAME`, `REPORT_ALIAS`, `RES_ID`, `REPORT_SQL`, `REPORT_PARAM`, `REPORT_PARAM_FLAG`, `REPORT_SUFFIX`, `INDEX_FLAG`, `REPORT_TYPE`, `WITH_THREAD`) VALUES (5, 'exportPassed', '准考考生名单', NULL, 'SELECT
	m.std_id,
	s.std_name,
	m.review_level,
	e.exam_id,
	s.std_edu,
	s.std_mobile,
	e.enr_doct_name,
	x.major_name,
	f.aspect_name,
	ro.optr_name real_optr_name
FROM
	std_apply_main m
	LEFT JOIN frame_optr ro ON ro.optr_id = m.real_initial_review_optr
	INNER JOIN cf_aspect f ON f.aspect_id = m.aspect_id
	AND f.school_id = m.school_id
	AND f.batch_id = m.batch_id
	INNER JOIN cf_aspect_optr o ON o.aspect_id = f.aspect_id
	AND o.school_id = f.school_id
	AND o.batch_id = f.batch_id
	INNER JOIN cf_major x ON x.major_id = f.major_id
	AND f.school_id = f.school_id
	AND x.batch_id = f.batch_id
	LEFT JOIN std_reg s ON s.school_id = m.school_id
	AND s.std_id = m.std_id
	LEFT JOIN std_enrol e ON e.school_id = m.school_id
	AND e.std_id = m.std_id
	AND e.STATUS = \'Active\'
WHERE
	 m.review_level<=f.pass_cnt
	AND m.school_id =?
	AND m.batch_id =?
ORDER BY
	m.review_level', 'school_id\r\nbatch_id', NULL, NULL, 'Active', NULL, NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 7, 'aspect_name', 20, '专业方向名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 3, 'dict_text', 50, '考生类型', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 5, 'enr_doct_name', 20, '导师名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 2, 'exam_id', 10, '报名号', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 6, 'major_name', 20, '专业名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 8, 'optr_name', 20, '初审老师', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 4, 'std_mobile', 15, '联系电话', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportPassed', 1, 'std_name', 15, '考生姓名', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 7, 'aspect_name', 20, '专业方向名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 3, 'dict_text', 50, '考生类型', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 5, 'enr_doct_name', 20, '导师名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 2, 'exam_id', 10, '报名号', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 6, 'major_name', 20, '专业名称', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 8, 'optr_name', 20, '初审老师', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 4, 'std_mobile', 15, '联系电话', 'java.lang.String', 'Active', NULL);
INSERT INTO `mr2022`.`frame_report_detail` (`REPORT_NAME`, `FIELD_ORDER`, `FIELD_NAME`, `FIELD_LENGTH`, `FIELD_TEXT`, `FIELD_DATE_TYPE`, `FIELD_STATUS`, `DICT_NAME`) VALUES ('exportNoPassed', 1, 'std_name', 15, '考生姓名', 'java.lang.String', 'Active', NULL);