Home Esplora Aiuto
Registrati Accedi
lizhenghang
/
dev
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Ramo (Branch): master
Rami (Branch) Tag
dev
/
2020
/
2020-017(OK)
/
2020-017-wzw-003.sql

2020-017-wzw-003.sql 3.2 KB
Permalink Cronologia Originale

1234567891011 
  1. /*161 159已执行  2020年11月24日 14:19:06*/
    2. 

  2. USE DCP;
    3. 

  3. 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.NATIONALREGIONALCOMMITTEES','国家区域委员会','1','1',now(),'1',now(),7,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION'),'fa-dashboard','','0' FROM DUAL);
    4. 

  4. 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.NATIONALREGIONALCOMMITTEES.NATIONALCOMMITTEE','委员会管理','1','1',now(),'1',now(),1,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeBasisEntityList','0' FROM DUAL);
    5. 

  5. 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.NATIONALREGIONALCOMMITTEES.REGIONALCOMMITTEES','委员会展示信息管理','1','1',now(),'1',now(),2,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeShowMessageEntityList','0' FROM DUAL);
    6. 

  6. 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.OPERATE.COMMITEEANDREGION.ACTIVITY','委员会活动管理','1','1',now(),'1',now(),3,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeActivityEntityList','0' FROM DUAL);
    7. 

  7. 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.OPERATE.COMMITEEANDREGION.ACTIVITY.APPROVAL','委员会活动审批','1','1',now(),'1',now(),4,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeActivityEntityApprovalList','0' FROM DUAL);
    8. 

  8. 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.OPERATE.COMMITEEANDREGION.INFOMANAGER','委员会信息发布管理','1','1',now(),'1',now(),6,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.COOPERATION.NATIONALREGIONALCOMMITTEES'),'fa-dashboard','CommitteeInformationReleaseManagementEntityList','0' FROM DUAL);
    9. 

  9. 

  10. 

  11. /*161 159已执行  2020年11月24日 14:19:06*/
    12.