liumengyu
25 lines
1.3 KiB
SQL
25 lines
1.3 KiB
SQL
-- 调课申请增加与学员队任务表、课表、课程表的关联字段
|
||
ALTER TABLE "实施_调课申请" ADD "学员队任务编号" VARCHAR(50);
|
||
ALTER TABLE "实施_调课申请" ADD "课编号" VARCHAR(50);
|
||
ALTER TABLE "实施_调课申请" ADD "课程表编号" VARCHAR(50);
|
||
ALTER TABLE "实施_调课申请" ADD "教研室代号" VARCHAR(50);
|
||
ALTER TABLE "实施_调课申请" ADD "原教室编号" VARCHAR(50);
|
||
ALTER TABLE "实施_调课申请" ADD "新教室编号" VARCHAR(50);
|
||
|
||
-- 教研室角色（达梦需开启 IDENTITY_INSERT）
|
||
SET IDENTITY_INSERT SYS_ROLE ON;
|
||
INSERT INTO SYS_ROLE (ROLE_ID, ROLE_NAME, ROLE_KEY, ROLE_SORT, DATA_SCOPE, MENU_CHECK_STRICTLY, DEPT_CHECK_STRICTLY, STATUS, DEL_FLAG, CREATE_BY, CREATE_TIME, REMARK)
|
||
SELECT 103, '教研室', 'RESEARCH_OFFICE', 11, '3', 1, 1, '0', '0', 'admin', SYSDATE, '教研室：查看并一审本室调课申请'
|
||
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM SYS_ROLE WHERE ROLE_KEY = 'RESEARCH_OFFICE');
|
||
SET IDENTITY_INSERT SYS_ROLE OFF;
|
||
|
||
INSERT INTO SYS_ROLE_MENU (ROLE_ID, MENU_ID)
|
||
SELECT r.ROLE_ID, m.MENU_ID
|
||
FROM SYS_ROLE r
|
||
CROSS JOIN SYS_ROLE_MENU m
|
||
WHERE r.ROLE_KEY = 'RESEARCH_OFFICE'
|
||
AND m.ROLE_ID = (SELECT ROLE_ID FROM SYS_ROLE WHERE ROLE_KEY = 'TEACHER')
|
||
AND NOT EXISTS (
|
||
SELECT 1 FROM SYS_ROLE_MENU x WHERE x.ROLE_ID = r.ROLE_ID AND x.MENU_ID = m.MENU_ID
|
||
);
|