Ana Sayfa Keşfet Yardım
Üye Ol Giriş Yap
lizhenghang
/
dev
1
0
Çatalla 0
Dosyalar Sorunlar 0 Değişiklik İstekleri 0 Wiki
Dal: master
Dallar Biçim İmleri
dev
/
2020
/
2020-022(OK)
/
2020-022-zzy-001.sql

2020-022-zzy-001.sql 12 KB
Kalıcı Bağlantı Geçmiş Ham

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 
  1. USE DCP;
    2. 

  2. 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,'AUTH.CLIENTS','oauth_client','1','1',now(),'1',now(),100,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.SYSTEM.SETTINGS'),'fa-credit-card','OauthClientDetailsList','0' FROM DUAL);
    3. 

  3. 

  4. INSERT INTO `sys_dict_type`(`DICT_TYPE_NAME`, `DICT_TYPE_CODE`, `DICT_TYPE_DISP_ORDER`, `DICT_TYPE_STATUS`, `DICT_TYPE_DESCRIPTION`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES ('AUTHORIZED_GRANT_TYPES', 'AUTHORIZED_GRANT_TYPES', NULL, 'Y', '', 1, '2020-12-02 17:00:37', 1, '2020-12-02 17:00:37');
    5. 

  5. INSERT INTO `sys_dict_type`(`DICT_TYPE_NAME`, `DICT_TYPE_CODE`, `DICT_TYPE_DISP_ORDER`, `DICT_TYPE_STATUS`, `DICT_TYPE_DESCRIPTION`, `CREATE_USER_ID`, `CREATE_TIME`, `UPDATE_USER_ID`, `UPDATE_TIME`) VALUES ('RESOURCE_IDS', 'RESOURCE_IDS', NULL, 'Y', '', 1, '2020-12-02 16:59:53', 1, '2020-12-02 16:59:53');
    6. 

  6. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='AUTHORIZED_GRANT_TYPES'),'authorization_code','authorization_code','10','Y','','1',now(),'1',now() FROM DUAL);
    7. 

  7. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='AUTHORIZED_GRANT_TYPES'),'password','password','20','Y','','1',now(),'1',now() FROM DUAL);
    8. 

  8. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='AUTHORIZED_GRANT_TYPES'),'refresh_token','refresh_token','30','Y','','1',now(),'1',now() FROM DUAL);
    9. 

  9. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='AUTHORIZED_GRANT_TYPES'),'implicit','implicit','40','Y','','1',now(),'1',now() FROM DUAL);
    10. 

  10. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='AUTHORIZED_GRANT_TYPES'),'client_credentials','client_credentials','50','Y','','1',now(),'1',now() FROM DUAL);
    11. 

  11. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'api-gateway','api-gateway','10','Y','','1',now(),'1',now() FROM DUAL);
    12. 

  12. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'auth-service','auth-service','20','Y','','1',now(),'1',now() FROM DUAL);
    13. 

  13. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'sys-service','sys-service','30','Y','','1',now(),'1',now() FROM DUAL);
    14. 

  14. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'file-service','file-service','1','Y','','1',now(),'1',now() FROM DUAL);
    15. 

  15. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-usercenter-service','itim-usercenter-service','1','Y','','1',now(),'1',now() FROM DUAL);
    16. 

  16. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'ums-service','ums-service','1','Y','','1',now(),'1',now() FROM DUAL);
    17. 

  17. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-meeting-service','itim-meeting-service','1','Y','','1',now(),'1',now() FROM DUAL);
    18. 

  18. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-project-service','itim-project-service','1','Y','','1',now(),'1',now() FROM DUAL);
    19. 

  19. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-personnel-service','itim-personnel-service','1','Y','','1',now(),'1',now() FROM DUAL);
    20. 

  20. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-operation-service','itim-operation-service','1','Y','','1',now(),'1',now() FROM DUAL);
    21. 

  21. 

  22. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-work-service','itim-work-service','1','Y','','1',now(),'1',now() FROM DUAL);
    23. 

  23. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-approve-service','itim-approve-service','1','Y','','1',now(),'1',now() FROM DUAL);
    24. 

  24. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-systodo-service','itim-systodo-service','1','Y','','1',now(),'1',now() FROM DUAL);
    25. 

  25. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-outsource-service','itim-outsource-service','1','Y','','1',now(),'1',now() FROM DUAL);
    26. 

  26. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'log-service','log-service','1','Y','','1',now(),'1',now() FROM DUAL);
    27. 

  27. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'cms-service','cms-service','1','Y','','1',now(),'1',now() FROM DUAL);
    28. 

  28. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-customer-service','itim-customer-service','1','Y','','1',now(),'1',now() FROM DUAL);
    29. 

  29. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'search-service','search-service','1','Y','','1',now(),'1',now() FROM DUAL);
    30. 

  30. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-resourceshare-service','itim-resourceshare-service','1','Y','','1',now(),'1',now() FROM DUAL);
    31. 

  31. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'itim-fileextend-service','itim-fileextend-service','1','Y','','1',now(),'1',now() FROM DUAL);
    32. 

  32. INSERT INTO sys_dict ( DICT_TYPE_ID, DICT_NAME, DICT_VALUE, DICT_DISP_ORDER, DICT_STATUS, DICT_DESCRIPTION, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME) (SELECT (SELECT max(dict_type_id) FROM sys_dict_type WHERE dict_type_code='RESOURCE_IDS'),'msg-service','msg-service','1','Y','','1',now(),'1',now() FROM DUAL);
    33. 

  33. 

  34. 

  35. DROP TABLE IF EXISTS `oauth_client_details`;
    36. 

  36. CREATE TABLE `oauth_client_details`  (
    37. 

  37.   `client_id` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    38. 

  38.   `resource_ids` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    39. 

  39.   `client_secret` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    40. 

  40.   `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    41. 

  41.   `authorized_grant_types` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    42. 

  42.   `web_server_redirect_uri` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    43. 

  43.   `authorities` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    44. 

  44.   `access_token_validity` int(11) DEFAULT NULL,
    45. 

  45.   `refresh_token_validity` int(11) DEFAULT NULL,
    46. 

  46.   `additional_information` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    47. 

  47.   `autoapprove` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    48. 

  48.   PRIMARY KEY (`client_id`) USING BTREE
    49. 

  49. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    50. 

  50. 

  51. INSERT INTO `oauth_client_details` VALUES ('client_1', 'file-service,api-gateway,auth-service,sys-service,ums-service,itim-usercenter-service,itim-meeting-service,itim-project-service,itim-personnel-service,itim-operation-service,itim-work-service,itim-approve-service,itim-systodo-service,itim-outsource-service,log-service,cms-service,itim-customer-service,search-service,itim-resourceshare-service,itim-fileextend-service,msg-service', '1xapp', 'server', 'password,refresh_token', NULL, 'oauth2', 86400, 86401, NULL, NULL);
    52. 

  52. INSERT INTO `oauth_client_details` VALUES ('client_2', 'file-service,api-gateway,auth-service,sys-service,ums-service,itim-usercenter-service,itim-meeting-service,itim-project-service,itim-personnel-service,itim-operation-service,itim-work-service,itim-approve-service,itim-systodo-service,itim-outsource-service,log-service,cms-service,itim-customer-service,search-service,itim-resourceshare-service,itim-fileextend-service,msg-service', '1xapp', 'server', 'password,refresh_token', NULL, 'oauth2', 86400, 86401, NULL, NULL);
    53. 

  53. INSERT INTO `oauth_client_details` VALUES ('client_app', 'file-service,api-gateway,auth-service,sys-service,ums-service,itim-usercenter-service,itim-meeting-service,itim-project-service,itim-personnel-service,itim-operation-service,itim-work-service,itim-approve-service,itim-systodo-service,itim-outsource-service,log-service,cms-service,itim-customer-service,search-service,itim-resourceshare-service,itim-fileextend-service,msg-service', '1xapp', 'server', 'password,refresh_token', NULL, 'oauth2', 86400, 610000, NULL, NULL);
    54. 

  54. 

  55. SET FOREIGN_KEY_CHECKS = 1;
    56. 

  56. 

  57. /*
    58. 

  58. 已执行161,159
    59. 

  59.  */
    60.