dev/2020/2020-018(OK)/2020-018-ljy-003.sql

use dcp;

INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.COOPERATION.APPROVE.SHARE','研究成果审批','1','1',now(),'1',now(),1,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.SHARE'),'fa-dashboard','BaseResearchResultInfoApproveList','0' FROM DUAL);

INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.COOPERATION.RESOURCES_APPROVE_SHARE','调研资源审批','1','1',now(),'1',now(),1,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.SHARE'),'fa-dashboard','BaseResearchResourcesInfoApproveList','0' FROM DUAL);

-- 159,161 已执行