/*
 * Copyright 2020-2030 码匠君<herodotus@aliyun.com>
 *
 * Dante Cloud licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *    http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Dante Cloud 采用 APACHE LICENSE 2.0 开源协议，您在使用过程中，需要注意以下几点：
 *
 * 1. 请不要删除和修改根目录下的LICENSE文件。
 * 2. 请不要删除和修改 Dante Cloud 源码头部的版权声明。
 * 3. 请保留源码和相关描述文件的项目出处，作者声明等。
 * 4. 分发源码时候，请注明软件出处 <https://gitee.com/dromara/dante-cloud>
 * 5. 在修改包名，模块名称，项目代码等时，请注明软件出处 <https://gitee.com/dromara/dante-cloud>
 * 6. 若您的项目无法满足以上几点，可申请商业授权
 */

-- ----------------------------
-- Table data for oauth2_application
-- ----------------------------
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', '2023-04-21 10:27:01.104', '2023-05-16 14:21:37.476', NULL, 0, 'system', '客户端常规测试', 0, b'1', 0, 'refresh_token,client_credentials,urn:ietf:params:oauth:grant-type:device_code,authorization_code,urn:ietf:params:oauth:grant-type:jwt-bearer', 'client_secret_post,private_key_jwt,client_secret_jwt,none,client_secret_basic', '2023-05-16 15:10:24.311607', NULL, NULL, 'http://127.0.0.1:8090/login/oauth2/code/messaging-client-oidc,http://127.0.0.1:8090/authorized', '21600000000000', NULL, '300000000000', '35026971d1fa406aaa150299d4f7bb39', '07e2d86f2b0641c4bb03e512a3eb0eac', '300000000000', 0, NULL, '86400000000000', b'1', b'0', b'1', 0, b'0', NULL, NULL, '客户端常规测试', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('7a5e1219-9f80-4142-897b-e3bda6135525', '2023-05-02 18:08:03.681', '2023-05-16 14:21:59.97', NULL, 0, 'system', 'Device认证模式测试客户端', 0, b'1', 0, 'refresh_token,urn:ietf:params:oauth:grant-type:device_code', 'none,client_secret_basic', '2023-05-16 15:10:24.311607', NULL, NULL, 'http://127.0.0.1:8070/authorize', '21600000000000', NULL, '300000000000', 'dcbbd793ee274e75822762728dcee91b', 'fccedb74fae1423d95f875c2b4b5d403', '300000000000', 0, NULL, '86400000000000', b'1', b'0', b'1', 0, b'0', NULL, NULL, '客户端Device测试', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('422baa83-505c-436f-87b5-2a599e6d2d28', '2022-04-02 16:26:26.26', '2023-05-16 14:22:26.293', NULL, 0, 'system', NULL, 0, b'1', 0, 'refresh_token,password,client_credentials,authorization_code,social_credentials', 'client_secret_post,client_secret_basic', '2023-05-16 15:10:24.311607', NULL, NULL, 'http://192.168.101.10:8847/dante-cloud-upms/open/authorized', '7200000000000', NULL, '300000000000', '67601992f3574c75809a3d79888bf16e', '3e62c1f9678a4dba81b31ad9f6ab8940', '300000000000', 0, NULL, '864000000000000', b'1', b'1', b'1', 1, b'0', NULL, 'Herodotus Cloud UI（PKCE）', '业务中台管理系统（PKCE）', 0, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('0571008d-6b9c-4694-9b51-aaef76d84526', '2023-07-11 21:10:43.131', '2023-09-05 21:55:55.883', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,authorization_code', 'client_secret_post,client_secret_jwt,client_secret_basic', '2023-07-11 21:10:43.139532', NULL, NULL, 'http://192.168.101.10:9090/oauth_callback', '86400000000000', NULL, '300000000000', 'e6684625e90848a5af0374c0006e1397', '95cb51b7ef7b4cf58d249b5dfd032a73', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'Minio Console', 'Minio 客户端', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('642187a3-6754-40d5-903e-a21909e2e810', '2023-07-13 11:55:34.646', '2024-02-28 18:05:33.153', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:55:34.647041', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '709776483077453b85b2af4f7949ed83', 'a0307033c5544392922d3d87dac26528', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'BPMN', '工作流程中心服务', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('034dd945-b531-4704-b6e7-dbc0e246353c', '2023-07-13 11:32:05.791', '2024-02-28 18:05:49.655', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:32:05.80196', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '8e0d16357b1a421aaae0292a3eb8bfaa', '8eb1a32c7c1c49ff8b45e84906d9b6d6', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'UPMS', '中台用户中心服务', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('9cbc6782-5025-48e2-819f-adc9c7c36d45', '2023-07-13 11:51:12.106', '2024-02-28 18:05:59.972', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:51:12.108696', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '25953fda237841689743a94871915661', 'a667ed5606f44e159db062239ed5a838', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'UAA', '中台认证中心服务', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('b5710185-4b80-4b18-a545-459a36938408', '2023-07-13 11:52:29.475', '2024-02-28 18:06:13.786', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:52:29.476824', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '5e8a9dc4ade843b9953cdf3b108a0765', 'b2985ee0306145109078c3eec7d65926', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'MSG', '中台消息中心服务', 1, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('32a2c5c2-9453-443e-bae6-c316aa6ab897', '2023-07-13 11:54:00.111', '2024-02-28 18:06:28.152', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:54:00.112398', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '7299d999f2d3478497f382450f9a35ba', '02895262878f45e8a16a15f68336f431', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'OSS', '对象存储中心服务', 1, NULL, '');
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('5bce5730-dc51-4f3f-9c9d-9178796b7551', '2024-02-28 18:04:45.21', '2024-02-28 18:06:42.937', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2024-02-28 18:04:45.236249', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', 'bc500674e11c4f6ebdf84a5fdd8c8f59', 'ea429cd930ad44aa964e22646f6bd82c', '300000000000', 0, NULL, '864000000000000', b'1', b'0', b'1', 1, b'0', NULL, 'MANAGE', '设施管理中心服务', 0, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('49f739ba-bde5-45f6-a7ff-d69285b753a2', '2024-05-20 15:00:11.69', '2024-05-20 15:00:11.69', 'system', 0, 'system', NULL, 0, b'0', 0, 'client_credentials', 'client_secret_post,client_secret_basic', '2024-05-20 15:00:11.718855', NULL, NULL, NULL, '7200000000000', NULL, '300000000000', '9f677942fde944959f677942fde94495', 'b28ac4f08dff31a6b28ac4f08dff31a6', '300000000000', 0, NULL, '86400000000000', b'1', b'0', b'1', 1, b'0', NULL, 'Client Dynamic Registration', '客户端动态注册测试', 0, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', '2022-03-18 18:51:00.191', '2025-02-06 13:54:23.763', NULL, 0, 'system', NULL, 1, b'1', 0, 'refresh_token,password,client_credentials,webauthn_credentials,authorization_code,social_credentials', 'client_secret_post,client_secret_basic', '2023-05-16 15:10:24.311607', '2027-03-01 00:00:00', NULL, 'http://192.168.101.10:3000/authorization-code', '7200000000000', 0, '300000000000', '14a9cf797931430896ad13a6b1855611', 'a05fe1fc50ed42a4990c6c6fc4bec398', '300000000000', 0, NULL, '86400000000000', b'1', b'0', b'1', 1, b'0', NULL, 'Herodotus Cloud UI', '业务中台管理系统', 0, NULL, NULL);
INSERT INTO `oauth2_application` (`application_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `access_token_validity`, `signing_algorithm`, `authorization_code_validity`, `client_id`, `client_secret`, `device_code_validity`, `signature_algorithm`, `jwk_set_url`, `refresh_token_validity`, `require_authorization_consent`, `require_proof_key`, `reuse_refresh_tokens`, `access_token_format`, `bound_access_token`, `subject_dn`, `abbreviation`, `application_name`, `application_type`, `homepage`, `logo`) VALUES ('1d7ce838-21ab-4ff5-b25f-1f236a22c035', '2026-03-10 21:40:38.529', '2026-03-10 21:40:55.492', 'system', 0, 'system', NULL, 0, b'1', 0, 'refresh_token,client_credentials,authorization_code', 'client_secret_post,client_secret_basic', '2026-03-10 21:40:38.533851', NULL, NULL, 'http://192.168.101.10:8847/dante-cloud-moniter/login/oauth2/code/dante-cloud', '7200000000000', NULL, '300000000000', '0ca42420efae46da91e51ee5cd8f27ad', '2a6280e17b6e43fb8e9c681f21630f19', '300000000000', 0, NULL, '86400000000000', b'0', b'0', b'1', 1, b'0', NULL, 'MONITOR', '运行监控中心服务', 1, NULL, NULL);

-- ----------------------------
-- Table data for oauth2_registered_client
-- ----------------------------
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('7a5e1219-9f80-4142-897b-e3bda6135525', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refresh_token,urn:ietf:params:oauth:grant-type:device_code', 'none,client_secret_basic', '2023-05-02 18:08:03.771453', NULL, '', 'http://127.0.0.1:8070/authorize', 'dcbbd793ee274e75822762728dcee91b', '7a5e1219-9f80-4142-897b-e3bda6135525', '{bcrypt}$2a$10$KURcfB6eUuzcaP6LNgDHS.yVw8.7yQUn7N/hnIXlTPhdOztltrs9K', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', 'message.read,message.write', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",21600.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"self-contained"},"settings.token.refresh-token-time-to-live":["java.time.Duration",86400.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('034dd945-b531-4704-b6e7-dbc0e246353c', '2023-07-13 11:49:46.748', '2024-02-28 18:05:49.722', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:49:46.754253', NULL, '', '', '8e0d16357b1a421aaae0292a3eb8bfaa', '034dd945-b531-4704-b6e7-dbc0e246353c', '{bcrypt}$2a$10$FjQuhvK3QHh6feWUjcu/Oe0Kkh46wF.7kknH4UVJWEAhobylO4RRa', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('b5710185-4b80-4b18-a545-459a36938408', '2023-07-13 11:52:29.55', '2024-02-28 18:06:13.865', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:52:29.550804', NULL, '', '', '5e8a9dc4ade843b9953cdf3b108a0765', 'b5710185-4b80-4b18-a545-459a36938408', '{bcrypt}$2a$10$Z8A5eNI1TxOEBMO.c/yGa.ghOf7KnzfyhiTHFDGnNlgr32QEWfXVO', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('32a2c5c2-9453-443e-bae6-c316aa6ab897', '2023-07-13 11:54:00.213', '2024-02-28 18:06:28.238', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:54:00.213611', NULL, '', '', '7299d999f2d3478497f382450f9a35ba', '32a2c5c2-9453-443e-bae6-c316aa6ab897', '{bcrypt}$2a$10$ulkhY7GBZe3Qss/5/L70B.fUcAOEE32n3fF1i76eAoD.uLj0PtcSS', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('422baa83-505c-436f-87b5-2a599e6d2d28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refresh_token,password,client_credentials,authorization_code,social_credentials', 'client_secret_post,client_secret_basic', '2022-04-02 16:26:26.776', NULL, '', 'http://192.168.101.10:8847/dante-cloud-upms/open/authorized', '67601992f3574c75809a3d79888bf16e', '422baa83-505c-436f-87b5-2a599e6d2d28', '{bcrypt}$2a$10$2T9TCcT.Sin/.UAPrQuG4e97gFgrvILXlByFoMBPCjtaFE36/b8jK', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":true,"settings.client.require-authorization-consent":true}', 'read-user-by-page,openid,profile', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'refresh_token,client_credentials,urn:ietf:params:oauth:grant-type:device_code,authorization_code,urn:ietf:params:oauth:grant-type:jwt-bearer', 'client_secret_post,private_key_jwt,client_secret_jwt,none,client_secret_basic', '2023-04-21 10:27:01.175063', NULL, '', 'http://127.0.0.1:8090/authorized,http://127.0.0.1:8090/login/oauth2/code/messaging-client-oidc', '35026971d1fa406aaa150299d4f7bb39', 'c2273230-21e4-49ed-ab8a-db2d357a897e', '{bcrypt}$2a$10$DhTXhrHUMP1cm1H.eHlLRuiq4osx00oHVlJE9O79RQLayk68UpzKe', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', 'openid,profile,message.read,message.write', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",21600.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"self-contained"},"settings.token.refresh-token-time-to-live":["java.time.Duration",86400.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('0571008d-6b9c-4694-9b51-aaef76d84526', '2023-07-11 21:12:49.105', '2023-09-05 21:55:55.973', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,authorization_code', 'client_secret_post,client_secret_jwt,client_secret_basic', '2023-07-11 21:12:49.10658', NULL, '', 'http://192.168.101.10:9090/oauth_callback', 'e6684625e90848a5af0374c0006e1397', '0571008d-6b9c-4694-9b51-aaef76d84526', '{bcrypt}$2a$10$4hRJtF0TW2qiKFYIIS2t2OO4nGxgROHvP2uis2E6il4muGCgUxthS', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', 'openid,profile,email', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",86400.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('5bce5730-dc51-4f3f-9c9d-9178796b7551', '2024-02-28 18:04:45.333', '2024-02-28 18:06:43.004', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2024-02-28 18:04:45.333159', NULL, '', '', 'bc500674e11c4f6ebdf84a5fdd8c8f59', '5bce5730-dc51-4f3f-9c9d-9178796b7551', '{bcrypt}$2a$10$tmq395cRzcdpQnrkc9vsBO.VftMDkY82mp7SryNo4y0f7Fxuz25QG', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('642187a3-6754-40d5-903e-a21909e2e810', '2023-07-13 11:55:34.718', '2024-02-28 18:05:33.239', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:55:34.718575', NULL, '', '', '709776483077453b85b2af4f7949ed83', '642187a3-6754-40d5-903e-a21909e2e810', '{bcrypt}$2a$10$8tLFaCiNKiP6UufN6OV2S.5WN9IJV82sC0r0PSZ39oKEfZN.uzXTC', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('9cbc6782-5025-48e2-819f-adc9c7c36d45', '2023-07-13 11:51:12.177', '2024-02-28 18:06:00.047', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,password', 'client_secret_post,client_secret_basic', '2023-07-13 11:51:12.177993', NULL, '', '', '25953fda237841689743a94871915661', '9cbc6782-5025-48e2-819f-adc9c7c36d45', '{bcrypt}$2a$10$5gbtv4SAK.qAc7rMHGA8aeZBNZobavDo0IA1jUjAovKw7KEq09B9K', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', '', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",864000.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('49f739ba-bde5-45f6-a7ff-d69285b753a2', '2024-05-20 15:00:11.819', '2024-05-20 15:00:11.819', 'system', 0, 'system', NULL, 0, b'0', 0, 'client_credentials', 'client_secret_post,client_secret_basic', '2024-05-20 15:00:11.820369', NULL, '', '', '9f677942fde944959f677942fde94495', '49f739ba-bde5-45f6-a7ff-d69285b753a2', '{bcrypt}$2a$10$WYzAQbLsTSsDxEEkhXsboOR3KXTrZg44N2WVN9snlmboXgN/1y4ry', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', 'client.create,client.read', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",86400.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', NULL, '2025-02-06 13:54:23.892', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,password,client_credentials,webauthn_credentials,authorization_code,social_credentials', 'client_secret_post,client_secret_basic', '2022-03-18 18:51:00.373', '2027-03-01 00:00:00', '', 'http://192.168.101.10:3000/authorization-code', '14a9cf797931430896ad13a6b1855611', 'dfe3e7bc-22e9-443f-a874-947494e20174', '{bcrypt}$2a$10$SZwzt0B.KhuID0CXszWwOe3BBcyChToaX.gUCUAe7AShRfUwbeQCW', '{"@class":"java.util.Collections$UnmodifiableMap","settings.client.token-endpoint-authentication-signing-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.client.require-proof-key":false,"settings.client.require-authorization-consent":true}', 'read-user-by-page,openid,client.create,profile,client.read', '{"@class":"java.util.Collections$UnmodifiableMap","settings.token.reuse-refresh-tokens":true,"settings.token.x509-certificate-bound-access-tokens":false,"settings.token.id-token-signature-algorithm":["org.springframework.security.oauth2.jose.jws.SignatureAlgorithm","RS256"],"settings.token.access-token-time-to-live":["java.time.Duration",7200.000000000],"settings.token.access-token-format":{"@class":"org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat","value":"reference"},"settings.token.refresh-token-time-to-live":["java.time.Duration",86400.000000000],"settings.token.authorization-code-time-to-live":["java.time.Duration",300.000000000],"settings.token.device-code-time-to-live":["java.time.Duration",300.000000000]}');
INSERT INTO `oauth2_registered_client` (`id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `authorization_grant_types`, `client_authentication_methods`, `client_id_issued_at`, `client_secret_expires_at`, `post_logout_redirect_uris`, `redirect_uris`, `client_id`, `client_name`, `client_secret`, `client_settings`, `scopes`, `token_settings`) VALUES ('1d7ce838-21ab-4ff5-b25f-1f236a22c035', '2026-03-10 21:40:38.925', '2026-03-10 21:40:55.59', NULL, 0, 'system', NULL, 0, b'0', 0, 'refresh_token,client_credentials,authorization_code', 'client_secret_post,client_secret_basic', '2026-03-10 21:40:38.925922', NULL, '', 'http://192.168.101.10:8847/dante-cloud-moniter/login/oauth2/code/dante-cloud', '0ca42420efae46da91e51ee5cd8f27ad', '1d7ce838-21ab-4ff5-b25f-1f236a22c035', '{bcrypt}$2a$10$gS7GB1pdA9CafbShN6zIROf57PdHa/q6Sb6AGlcmFjgKlUsDhMsUa', '{`@class`:`java.util.Collections$UnmodifiableMap`,`settings.client.require-proof-key`:false,`settings.client.require-authorization-consent`:false}', 'openid,profile,email', '{`@class`:`java.util.Collections$UnmodifiableMap`,`settings.token.reuse-refresh-tokens`:true,`settings.token.x509-certificate-bound-access-tokens`:false,`settings.token.id-token-signature-algorithm`:[`org.springframework.security.oauth2.jose.jws.SignatureAlgorithm`,`RS256`],`settings.token.access-token-time-to-live`:[`java.time.Duration`,`PT2H`],`settings.token.access-token-format`:{`@class`:`org.springframework.security.oauth2.server.authorization.settings.OAuth2TokenFormat`,`value`:`reference`},`settings.token.refresh-token-time-to-live`:[`java.time.Duration`,`PT24H`],`settings.token.authorization-code-time-to-live`:[`java.time.Duration`,`PT5M`],`settings.token.device-code-time-to-live`:[`java.time.Duration`,`PT5M`]}');

-- ----------------------------
-- Table data for oauth2_scope
-- ----------------------------
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('725e5456-25fa-4d47-a8fc-eaff5770200e', NULL, '2022-11-26 16:46:04.778', 0, NULL, '2022-11-26 16:46:04', '客户端创建', b'1', 0, 0, 'client.create', 'OIDC Client Registration');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('3b959f84-67ca-434c-907f-db1ab5456ffe', NULL, '2022-11-26 22:10:11.867', 0, NULL, '2022-11-26 22:10:11.867', '客户端信息读取', b'1', 0, 0, 'client.read', 'OIDC Client Read');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('a9c5c99a-dd59-4d77-b36d-740979f33719', 'system', '2023-05-03 18:19:45.367', 5, 'system', '2023-05-03 18:19:45.367', '写入测试消息', b'1', 0, 0, 'message.write', '写入测试消息');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('bfc6105d9f0285e9550ef7aade04a2d3', NULL, '2022-04-01 22:07:23', 3, 'system', '2023-05-03 18:19:59.861', '获取用户信息', b'1', 0, 0, 'read-user-by-page', '获取用户信息');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('c2061315-e25e-4a85-9473-e8dc45955b66', 'system', '2023-05-03 18:19:14.501', 4, 'system', '2023-05-03 18:23:38.998', '读取测试消息', b'1', 0, 0, 'message.read', '读取测试消息');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('a3de4b6f-aaf6-406f-90dc-60240b1aa557', 'system', '2023-09-05 20:38:15.319', 3, 'system', '2023-09-05 20:38:15.319', '用户电子邮件', b'1', 0, 0, 'email', 'OIDC Email');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('1a0e1628-6d32-41c2-ae47-758ab0ad8d21', 'system', '2023-09-05 20:38:53.717', 4, 'system', '2023-09-05 20:38:53.717', '用户地址', b'1', 0, 0, 'address', 'OIDC Address');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('63dcc6d1-462e-4e7a-b9c1-70d15a747e63', 'system', '2023-05-03 18:17:55.213', 2, 'system', '2023-09-05 20:39:29.087', '用户信息', b'1', 0, 0, 'profile', 'OIDC Profile');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('3882ddc5-0023-4ee4-ae8e-b7de83ee1dfa', 'system', '2023-09-05 20:40:07.326', 5, 'system', '2023-09-05 20:40:07.326', '用户电话号码', b'1', 0, 0, 'phone', 'OIDC phone');
INSERT INTO `oauth2_scope` (`scope_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scope_code`, `scope_name`) VALUES ('bd344a2e-47d6-4b45-b77f-50ca8623f09f', NULL, '2022-03-24 11:58:19.517', 1, 'system', '2023-09-05 20:40:28.241', 'Open ID', b'1', 0, 0, 'openid', 'OIDC OpenId');

-- ----------------------------
-- Table data for oauth2_application_scope
-- ----------------------------
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', 'bfc6105d9f0285e9550ef7aade04a2d3');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', 'bd344a2e-47d6-4b45-b77f-50ca8623f09f');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('422baa83-505c-436f-87b5-2a599e6d2d28', 'bfc6105d9f0285e9550ef7aade04a2d3');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('422baa83-505c-436f-87b5-2a599e6d2d28', 'bd344a2e-47d6-4b45-b77f-50ca8623f09f');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', '725e5456-25fa-4d47-a8fc-eaff5770200e');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', 'bd344a2e-47d6-4b45-b77f-50ca8623f09f');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('7a5e1219-9f80-4142-897b-e3bda6135525', 'a9c5c99a-dd59-4d77-b36d-740979f33719');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('7a5e1219-9f80-4142-897b-e3bda6135525', 'c2061315-e25e-4a85-9473-e8dc45955b66');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', 'c2061315-e25e-4a85-9473-e8dc45955b66');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', 'a9c5c99a-dd59-4d77-b36d-740979f33719');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('c2273230-21e4-49ed-ab8a-db2d357a897e', '63dcc6d1-462e-4e7a-b9c1-70d15a747e63');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', '3b959f84-67ca-434c-907f-db1ab5456ffe');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('dfe3e7bc-22e9-443f-a874-947494e20174', '63dcc6d1-462e-4e7a-b9c1-70d15a747e63');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('422baa83-505c-436f-87b5-2a599e6d2d28', '63dcc6d1-462e-4e7a-b9c1-70d15a747e63');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('0571008d-6b9c-4694-9b51-aaef76d84526', 'bd344a2e-47d6-4b45-b77f-50ca8623f09f');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('0571008d-6b9c-4694-9b51-aaef76d84526', 'a3de4b6f-aaf6-406f-90dc-60240b1aa557');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('0571008d-6b9c-4694-9b51-aaef76d84526', '63dcc6d1-462e-4e7a-b9c1-70d15a747e63');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('49f739ba-bde5-45f6-a7ff-d69285b753a2', '725e5456-25fa-4d47-a8fc-eaff5770200e');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('49f739ba-bde5-45f6-a7ff-d69285b753a2', '3b959f84-67ca-434c-907f-db1ab5456ffe');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('1d7ce838-21ab-4ff5-b25f-1f236a22c035', 'bd344a2e-47d6-4b45-b77f-50ca8623f09f');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('1d7ce838-21ab-4ff5-b25f-1f236a22c035', 'a3de4b6f-aaf6-406f-90dc-60240b1aa557');
INSERT INTO `oauth2_application_scope` (`application_id`, `scope_id`) VALUES ('1d7ce838-21ab-4ff5-b25f-1f236a22c035', '63dcc6d1-462e-4e7a-b9c1-70d15a747e63');
-- ----------------------------
-- Table data for oauth2_permission
-- ----------------------------
INSERT INTO `oauth2_permission` (`permission_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `permission_code`, `permission_name`) VALUES ('3', '2023-03-13 16:48:55.806', 0, '2023-03-13 16:55:10.462', NULL, b'0', 0, 0, 'security:manage', '用户安全管理');

-- ----------------------------
-- Table data for oauth2_scope_permission
-- ----------------------------
INSERT INTO `oauth2_scope_permission` (`scope_id`, `permission_id`) VALUES ('bfc6105d9f0285e9550ef7aade04a2d3', '3');

-- ----------------------------
-- Table data for sys_user
-- ----------------------------
INSERT INTO `sys_user` (`user_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `avatar`, `email`, `nick_name`, `password`, `phone_number`, `user_name`, `account_expire_at`, `credentials_expire_at`) VALUES ('1', '2019-07-23 07:19:50', 1, '2019-07-23 07:19:52', '平台管理员', b'1', NULL, 0, NULL, NULL, 'Hades', '{bcrypt}$2a$10$q4t3wbkoCVAtCMwVsVFjveLF7O6QScD2/vmqgGbdPuZRw0U1.blhq', NULL, 'system', NULL, NULL);
INSERT INTO `sys_user` (`user_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `avatar`, `email`, `nick_name`, `password`, `phone_number`, `user_name`, `account_expire_at`, `credentials_expire_at`) VALUES ('33e781c5-31e0-4ea4-8b02-1236bde96436', '2022-06-24 15:55:15.586', 0, '2022-06-24 15:55:15.586', NULL, b'0', 0, 0, NULL, NULL, 'test', '{bcrypt}$2a$10$q4t3wbkoCVAtCMwVsVFjveLF7O6QScD2/vmqgGbdPuZRw0U1.blhq', NULL, 'test', NULL, NULL);

-- ----------------------------
-- Table data for sys_role
-- ----------------------------
INSERT INTO `sys_role` (`role_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `role_code`, `role_name`) VALUES ('1', NULL, '2019-07-23 07:22:27', 1, NULL, '2019-09-11 12:04:52', '中台管理员角色', b'1', 0, 0, 'ROLE_ADMINISTRATOR', '平台管理员角色');
INSERT INTO `sys_role` (`role_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `role_code`, `role_name`) VALUES ('7e43d37d-d045-445f-a1de-cb1259f7709c', NULL, '2022-07-18 20:27:46.536', 0, NULL, '2022-07-18 20:27:46.536', '人力资源管理角色', b'1', 0, 0, 'ROLE_HUMAN_RESOURCES', '人力资源管理');
INSERT INTO `sys_role` (`role_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `role_code`, `role_name`) VALUES ('faccc981-7cd4-4333-9ef9-93752eb186bd', NULL, '2023-02-27 21:54:33.723', 0, NULL, '2023-02-27 21:54:33', '一般用户角色', b'1', 0, 0, 'ROLE_NORMAL', '普通用户角色');
INSERT INTO `sys_role` (`role_id`, `create_by`, `create_time`, `ranking`, `update_by`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `role_code`, `role_name`) VALUES ('21ef1626-9189-4842-8f54-953545a6cc7a', 'system', '2023-09-05 20:21:09.67', 4, 'system', '2023-09-05 20:21:09.67', '使用 Herodotus Cloud OpenId 登录 Minio 控制台使用角色', b'1', 0, 0, 'consoleAdmin', 'Minio 控制台管理员角色');


-- ----------------------------
-- Table data for sys_permission
-- ----------------------------
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('1', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '所有角色用户都需要用到的权限', 1, b'1', 0, 'general', '通用基础权限');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('2', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '平台认证管理相关全部权限，当前为全部权限可结合实际调整细化', 2, b'1', 0, 'authentication:manage', '平台认证管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('3', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '用户安全管理相关全部权限，当前为全部权限可结合实际调整细化', 3, b'1', 0, 'security:manage', '用户安全管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('4', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '人力资源管理相关全部权限，当前为全部权限可结合实际调整细化', 4, b'1', 0, 'hr:manage', '人力资源管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('5', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '工作流等管理相关全部权限，当前为全部权限可结合实际调整细化', 5, b'1', 0, 'workflow:manage', '工作流程管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('6', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '运维配置管理相关全部权限，当前为全部权限可结合实际调整细化', 6, b'1', 0, 'cmdb:manage', '运维配置应用');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('7', '2023-03-08 00:03:35.765', '2023-03-08 00:03:35.765', NULL, 0, NULL, '外部接入应用相关全部权限，当前为全部权限可结合实际调整细化', 7, b'1', 0, 'external:manage', '外部接入应用');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('8', '2023-05-28 21:13:35', '2023-05-28 21:13:49', 'system', 0, 'system', '对象存储管理相关全部权限，当前为全部权限可结合实际调整细化', 8, b'1', 0, 'oss:manage', '对象存储管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('9', '2023-05-28 21:13:35', '2023-05-28 21:13:49', 'system', 0, 'system', '物联网管理相关全部权限，当前为全部权限可结合实际调整细化', 9, b'1', 0, 'iot:manage', '万物互联管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('10', '2023-05-28 21:13:35', '2023-05-28 21:13:49', 'system', 0, 'system', '系统信息管理相关全部权限，当前为全部权限可结合实际调整细化', 10, b'1', 0, 'mgt:manage', '系统信息管理');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('9db4e709-3cab-4e0a-a41a-ee593a228baf', '2023-05-03 18:21:50.296', '2023-05-03 18:21:50.296', 'system', 0, 'system', '客户端测试消息权限', 12, b'1', 0, 'client:demo:message', '客户端测试消息权限');
INSERT INTO `sys_permission` (`permission_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `permission_code`, `permission_name`) VALUES ('11', '2025-01-21 22:22:34', '2025-01-21 22:22:38', 'system', 0, 'system', 'Nacos 管理 API 相关全部权限，当前为全部权限可结合实际调整细化', 11, b'1', 0, 'mgt:nacos:manage', 'Nacos 管理 API');

-- ----------------------------
-- Table data for sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES ('1', '1');
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES ('33e781c5-31e0-4ea4-8b02-1236bde96436', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES ('1', '21ef1626-9189-4842-8f54-953545a6cc7a');

-- ----------------------------
-- Table data for sys_role_permission
-- ----------------------------
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '1');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '2');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '3');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '4');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '5');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '6');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '7');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '8');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '9');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '10');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('1', '11');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('7e43d37d-d045-445f-a1de-cb1259f7709c', '1');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('7e43d37d-d045-445f-a1de-cb1259f7709c', '4');
INSERT INTO `sys_role_permission` (`role_id`, `permission_id`) VALUES ('faccc981-7cd4-4333-9ef9-93752eb186bd', '1');

-- ----------------------------
-- Table data for sys_default_role
-- ----------------------------
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('1', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '机构人员', b'1', 0, 0, 'INSTITUTION', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('2', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '手机验证码', b'1', 0, 0, 'SMS', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('3', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '微信小程序', b'1', 0, 0, 'WXAPP', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('4', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'QQ', b'1', 0, 0, 'QQ', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('5', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '微博', b'1', 0, 0, 'WEIBO', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('6', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '百度', b'1', 0, 0, 'BAIDU', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('7', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '微信开放平台', b'1', 0, 0, 'WECHAT_OPEN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('8', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '微信公众号', b'1', 0, 0, 'WECHAT_MP', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('9', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '企业微信二维码', b'1', 0, 0, 'WECHAT_ENTERPRISE', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('10', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '企业微信网页', b'1', 0, 0, 'WECHAT_ENTERPRISE_WEB', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('11', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '钉钉', b'1', 0, 0, 'DINGTALK', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('12', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '钉钉账号', b'1', 0, 0, 'DINGTALK_ACCOUNT', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('13', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '阿里云', b'1', 0, 0, 'ALIYUN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('14', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '淘宝', b'1', 0, 0, 'TAOBAO', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('15', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '支付宝', b'1', 0, 0, 'ALIPAY', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('16', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Teambition', b'1', 0, 0, 'TEAMBITION', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('17', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '华为', b'1', 0, 0, 'HUAWEI_V3', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('18', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '飞书', b'1', 0, 0, 'FEISHU', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('19', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '京东', b'1', 0, 0, 'JD', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('20', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '抖音', b'1', 0, 0, 'DOUYIN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('21', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '今日头条', b'1', 0, 0, 'TOUTIAO', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('22', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '小米', b'1', 0, 0, 'MI', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('23', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '人人', b'1', 0, 0, 'RENREN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('24', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '美团', b'1', 0, 0, 'MEITUAN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('25', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '饿了么', b'1', 0, 0, 'ELEME', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('26', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '酷家乐', b'1', 0, 0, 'KUJIALE', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('27', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '喜马拉雅', b'1', 0, 0, 'XMLY', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('28', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '码云', b'1', 0, 0, 'GITEE', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('29', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '开源中国', b'1', 0, 0, 'OSCHINA', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('30', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'CSDN', b'1', 0, 0, 'CSDN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('31', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Github', b'1', 0, 0, 'GITHUB', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('32', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Gitlab', b'1', 0, 0, 'GITLAB', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('33', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Stackoverflow', b'1', 0, 0, 'STACK_OVERFLOW', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('34', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Coding', b'1', 0, 0, 'CODING', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('35', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '谷歌', b'1', 0, 0, 'GOOGLE', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('36', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '微软', b'1', 0, 0, 'MICROSOFT', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('37', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '脸书', b'1', 0, 0, 'FACEBOOK', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('38', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '领英', b'1', 0, 0, 'LINKEDIN', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('39', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '推特', b'1', 0, 0, 'TWITTER', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('40', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', '亚马逊', b'1', 0, 0, 'AMAZON', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('41', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Slack', b'1', 0, 0, 'SLACK', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('42', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Line', b'1', 0, 0, 'LINE', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('43', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Okta', b'1', 0, 0, 'OKTA', '1');
INSERT INTO `sys_default_role` (`default_id`, `create_time`, `ranking`, `update_time`, `description`, `is_reserved`, `reversion`, `status`, `scene`, `role_id`) VALUES ('44', '2021-10-12 09:45:33', 1, '2021-10-12 09:45:38', 'Pinterest', b'1', 0, 0, 'PINTEREST', '1');

-- ----------------------------
-- Table data for sys_element
-- ----------------------------
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '2022-07-16 21:43:14.156', '2022-07-16 21:43:14', NULL, 0, NULL, NULL, 3, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-lock-pattern', b'0', 'APP', NULL, b'1', NULL, '/security', '/security/user', '用户安全管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('41ec5b56-32d7-4029-8218-9c9bac6faa16', '2022-07-16 22:49:43.981', '2022-07-16 22:49:43', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/pages/authorize/application/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-apps', b'0', 'APP', 'OAuth2Application', b'1', '2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '/authorize/application', NULL, '应用管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('4ec4ed5e-d815-4318-937a-12d567957237', '2022-07-16 21:59:25.943', '2022-07-16 21:59:25', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/pages/security/user/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-badge-account-horizontal', b'0', 'APP', 'SysUser', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/user', NULL, '用户管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('19e8d4f4-66ef-4407-b090-dad1220ea2c3', '2022-07-16 22:45:57.764', '2022-07-16 22:45:57', NULL, 0, NULL, NULL, 4, b'1', 0, 'WEB', 'views/pages/hr/ownership/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-account-switch', b'0', 'APP', 'SysOwnership', b'1', '5fc067b0-8acc-48be-8334-d773cc649e88', '/hr/ownership', NULL, '人员归属');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('2de6fcfe-12e6-4e6a-b772-b8dd728a7da0', '2022-07-16 22:06:02.03', '2022-07-16 22:06:02', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/user/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-badge-account-alert', b'0', 'APP', 'SysUserAuthorize', b'1', '4ec4ed5e-d815-4318-937a-12d567957237', '/security/user/authorize', NULL, '用户角色');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('10eae473-87c5-4012-8078-8cd3c8d68c33', '2022-07-16 22:43:51.89', '2022-07-16 22:43:51.89', NULL, 0, NULL, NULL, 3, b'1', 0, 'WEB', 'views/pages/hr/employee/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-card-account-details-star', b'0', 'APP', 'SysEmployee', b'1', '5fc067b0-8acc-48be-8334-d773cc649e88', '/hr/employee', NULL, '人员管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('118b6d69-1c5c-433c-8316-b65a9e263e45', '2022-07-16 22:30:40.258', '2022-07-16 22:30:40.258', NULL, 0, NULL, NULL, 6, b'1', 0, 'WEB', 'views/pages/security/element/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-clipboard-text', b'0', 'APP', 'SysElement', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/element', NULL, '菜单管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('b14afb51-60a7-476d-bf45-57603d79f0db', '2022-07-16 22:57:21.513', '2022-07-16 22:57:21', NULL, 0, NULL, NULL, 4, b'1', 0, 'WEB', 'views/pages/authorize/compliance/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-receipt-text-check', b'0', 'APP', 'OAuth2Compliance', b'1', '2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '/authorize/compliance', NULL, '日志审计');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('b2e3f395-a861-46b8-a00b-96102eaa3f7c', '2022-07-16 22:53:22.541', '2022-07-16 22:53:22', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/pages/authorize/scope/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-group', b'0', 'APP', 'OAuth2Scope', b'1', '2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '/authorize/scope', NULL, '范围管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('e96985c2-94a5-4e11-a3ab-a71a3b4d7027', '2022-07-16 22:51:04.542', '2022-07-16 22:51:04', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/authorize/application/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-application-edit', b'0', 'APP', 'OAuth2ApplicationContent', b'1', '41ec5b56-32d7-4029-8218-9c9bac6faa16', '/authorize/application/content', NULL, '应用详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('111b4ed4-d0a6-4837-9e25-c081092970f6', '2022-07-16 22:37:29.561', '2022-07-16 22:37:29', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/pages/hr/organization/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-bank-outline', b'0', 'APP', 'SysOrganization', b'1', '5fc067b0-8acc-48be-8334-d773cc649e88', '/hr/organization', NULL, '单位管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('98860f95-794b-4882-8e74-6c729e1ad95b', '2022-07-16 22:56:24.016', '2022-07-16 22:56:24', NULL, 0, NULL, NULL, 3, b'1', 0, 'WEB', 'views/pages/authorize/token/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-sitemap', b'0', 'APP', 'OAuth2Token', b'1', '2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '/authorize/token', NULL, '凭证管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('24fd94d8-6956-4ad7-ac8f-3bc6daf609a7', '2022-07-16 22:54:31.827', '2022-07-16 22:54:31', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/authorize/scope/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-vector-link', b'0', 'APP', 'OAuth2ScopeContent', b'1', 'b2e3f395-a861-46b8-a00b-96102eaa3f7c', '/authorize/scope/content', NULL, '范围详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('53b2fc4f-8681-47f3-8739-409265add9fc', '2022-07-16 22:42:31.936', '2022-07-16 22:42:31', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/hr/department/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-home-edit', b'0', 'APP', 'SysDepartmentContent', b'1', '364f8273-e51a-486d-b53e-8e6b9f648c2c', '/hr/department/content', NULL, '部门详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('ddc98314-5b84-4471-9dd1-733103321504', '2022-07-16 22:44:37.69', '2022-07-16 22:44:37', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/hr/employee/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-card-account-details', b'0', 'APP', 'SysEmployeeContent', b'1', '10eae473-87c5-4012-8078-8cd3c8d68c33', '/hr/employee/content', NULL, '人员详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('66a8b97c-9aa7-423d-a106-d19e209bdc7b', '2022-07-16 22:38:38.018', '2022-07-16 22:38:38', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/hr/organization/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-bank-check', b'0', 'APP', 'SysOrganizationContent', b'1', '111b4ed4-d0a6-4837-9e25-c081092970f6', '/hr/organization/content', NULL, '单位详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('147bec55-b50a-472b-b109-7912f0d9773a', '2022-07-16 22:02:28.563', '2022-07-16 22:02:28', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/user/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-clipboard-account', b'0', 'APP', 'SysUserContent', b'1', '4ec4ed5e-d815-4318-937a-12d567957237', '/security/user/content', NULL, '用户详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('19a3864e-ebd3-474f-be02-9dc2c27c6614', '2022-07-16 22:27:41.408', '2022-07-16 22:27:41', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/default-role/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-lock-open-check', b'0', 'APP', 'SysDefaultRoleAuthorize', b'1', '23b4367a-dd41-484b-9078-e07caf9d8ec0', '/security/default-role/authorize', NULL, '角色配置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('2458dd66-9af9-4bae-babc-e4b988e4b4dd', '2022-07-16 22:31:57.556', '2022-07-16 22:31:57', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/element/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-clipboard-text-multiple', b'0', 'APP', 'SysElementContent', b'1', '118b6d69-1c5c-433c-8316-b65a9e263e45', '/security/element/content', NULL, '菜单详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('9b26ec0d-4111-4a55-9a99-64e6a2dc5afe', '2022-07-16 22:23:59.842', '2022-07-16 22:23:59', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/role/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-shield-key', b'0', 'APP', 'SysRoleAuthorize', b'1', '6ebecd40-6fca-413d-adb4-a2e416d0c8ee', '/security/role/authorize', NULL, '角色权限');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('e9831f7d-89ee-44dc-bf19-7e00e51b9879', '2022-07-16 22:22:48.381', '2022-07-16 22:22:48', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/role/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-shield-edit', b'0', 'APP', 'SysRoleContent', b'1', '6ebecd40-6fca-413d-adb4-a2e416d0c8ee', '/security/role/content', NULL, '角色详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('5cbdef3d-4ad6-4867-b1ea-401c3fc1d587', '2022-07-16 22:32:45.894', '2022-07-16 22:32:45', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/element/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-sort-variant-lock', b'0', 'APP', 'SysElementAuthorize', b'1', '118b6d69-1c5c-433c-8316-b65a9e263e45', '/security/element/authorize', NULL, '菜单权限');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '2022-07-16 22:48:29.733', '2022-07-16 22:48:29', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-security', b'0', 'APP', NULL, b'1', NULL, '/authorize', '/authorize/application', '平台认证管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('c21db958-7eab-4dbc-8061-966294684219', '2022-07-16 22:58:47.236', '2022-07-16 22:58:47.236', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-view-dashboard', b'0', 'APP', NULL, b'1', NULL, '/dashboard', '/dashboard/console', 'Dashboard');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('5fc067b0-8acc-48be-8334-d773cc649e88', '2022-07-16 22:36:31.755', '2022-07-16 22:36:31.755', NULL, 0, NULL, NULL, 4, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-account-tie', b'0', 'APP', NULL, b'1', NULL, '/hr', '/hr/organization', '人力资源管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('f4224093-4542-4c8b-85d1-3c25f28471df', '2022-07-16 22:55:21.043', '2022-07-16 22:55:21', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/authorize/scope/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-vector-intersection', b'0', 'APP', 'OAuth2ScopeAuthorize', b'1', 'b2e3f395-a861-46b8-a00b-96102eaa3f7c', '/authorize/scope/authorize', NULL, '范围权限');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('ee2a4314-531e-47ef-866b-8e04433bc934', '2022-07-16 22:46:59.014', '2022-07-16 22:46:59', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/hr/ownership/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-account-multiple-check-outline', b'0', 'APP', 'SysOwnershipContent', b'1', '19e8d4f4-66ef-4407-b090-dad1220ea2c3', '/hr/ownership/content', NULL, '归属详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('6de8f002-8e59-42a8-b201-3dba46aa6641', '2022-07-16 22:33:50.326', '2022-07-16 22:33:50', NULL, 0, NULL, NULL, 4, b'1', 0, 'WEB', 'views/pages/security/attribute/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-layers-triple', b'0', 'APP', 'SysAttribute', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/attribute', NULL, '元数据管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('32b43adf-1db4-4ac9-b996-15cfee008489', '2022-07-16 22:34:37.542', '2022-07-16 22:34:37', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/attribute/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-layers', b'0', 'APP', 'SysAttributeContent', b'1', '6de8f002-8e59-42a8-b201-3dba46aa6641', '/security/attribute/content', NULL, '权限配置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('d319b130-9be4-46f4-bf56-97f14fb05260', '2022-07-19 16:19:19.649', '2022-07-19 16:19:19.649', NULL, 0, NULL, NULL, 5, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-transit-connection-variant', b'0', 'APP', NULL, b'1', NULL, '/workflow', '/workflow/deployment', '工作流程管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('364f8273-e51a-486d-b53e-8e6b9f648c2c', '2022-07-17 15:18:48.564', '2022-07-17 15:18:48', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/pages/hr/department/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-home', b'0', 'APP', 'SysDepartment', b'1', '5fc067b0-8acc-48be-8334-d773cc649e88', '/hr/department', NULL, '部门管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('6ebecd40-6fca-413d-adb4-a2e416d0c8ee', '2022-07-16 22:07:42.186', '2022-07-16 22:07:42', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/pages/security/role/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-shield-account', b'0', 'APP', 'SysRole', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/role', NULL, '角色管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('b3e3cc74-a8cc-471a-b6be-6802d5b82a6a', '2022-07-19 16:21:00.126', '2022-07-19 16:21:00', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/pages/workflow/deployment/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-cloud-braces', b'0', 'APP', 'WorkflowDeployment', b'1', 'd319b130-9be4-46f4-bf56-97f14fb05260', '/workflow/deployment', NULL, '流程部署管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('4dcb04f5-bb64-470c-b6ff-52dd6f19bba0', '2023-01-07 22:11:18.672', '2023-01-07 22:11:18', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/pages/workflow/process-definition/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-xml', b'0', 'APP', 'WorkflowProcessDefinition', b'1', 'd319b130-9be4-46f4-bf56-97f14fb05260', '/workflow/process-definition', NULL, '流程定义管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('3b83534e-016f-4e22-9553-5d8b96f29146', '2023-01-08 15:02:04.837', '2023-01-08 15:02:04', NULL, 0, NULL, NULL, 3, b'1', 0, 'WEB', 'views/pages/workflow/process-instance/Index.vue', b'0', 'MENU', b'0', b'1', 'mdi-motion-play', b'0', 'APP', 'WorkflowProcessInstance', b'1', 'd319b130-9be4-46f4-bf56-97f14fb05260', '/workflow/process-instance', NULL, '流程实例管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('9f064902-162a-408f-bd3e-866b03c9dae1', '2022-07-16 22:59:57.497', '2022-07-16 22:59:57', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/dashboard/console/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-sign-text', b'0', 'APP', 'DashboardConsole', b'0', 'c21db958-7eab-4dbc-8061-966294684219', '/dashboard/console', NULL, '主控台');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('0f9aa3b0-c164-4a61-ae31-5fd73274ce53', '2023-01-22 13:26:49.837', '2023-01-22 13:26:49', NULL, 0, NULL, NULL, 2, b'1', 0, 'WEB', 'views/dashboard/workbench/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-desktop-classic', b'0', 'APP', 'DashboardWorkbench', b'1', 'c21db958-7eab-4dbc-8061-966294684219', '/dashboard/workbench', NULL, '我的工作台');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('312d287f-ee2e-486f-b2e6-88328edb2c75', '2023-01-19 21:53:08.863', '2023-01-19 21:53:08', NULL, 0, NULL, NULL, 5, b'1', 0, 'WEB', 'views/pages/workflow/dynamic-form/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-monitor-dashboard', b'0', 'APP', 'WorkflowDynamicForm', b'1', 'd319b130-9be4-46f4-bf56-97f14fb05260', '/workflow/dynamic-form', NULL, '动态表单管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('740a286c-2c53-45a7-9a0f-c9d6a5b5f389', '2023-02-15 20:46:09.353', '2023-02-15 20:46:09', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/workflow/process/WorkflowProcessStart.vue', b'1', 'MENU', b'0', b'0', 'mdi-flag-plus', b'0', 'APP', 'WorkflowProcessStart', b'1', '0f9aa3b0-c164-4a61-ae31-5fd73274ce53', '/dashboard/workbench/process-start', NULL, '审批流程');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('2ca9ed44-ed47-4346-a310-d32375d0d5bf', '2023-02-27 17:22:39.682', '2023-02-27 17:22:39', NULL, 0, NULL, NULL, 1, b'1', 0, 'WEB', 'views/pages/workflow/process/WorkflowProcessApprove.vue', b'1', 'MENU', b'0', b'0', 'mdi-check-decagram', b'0', 'APP', 'WorkflowProcessApprove', b'1', '0f9aa3b0-c164-4a61-ae31-5fd73274ce53', '/dashboard/workbench/process-approve', NULL, '任务流程');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('0f7f0236-da8a-4a7f-8e87-db0275f42836', '2022-07-16 22:29:06.482', '2022-07-16 22:29:06', NULL, 0, NULL, NULL, 3, b'1', 0, 'WEB', 'views/pages/security/permission/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-shield-link-variant', b'0', 'APP', 'SysPermission', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/permission', NULL, '权限管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('cb426c81-7019-4249-a910-ced0d44ace97', '2023-03-12 15:49:12.236', '2023-03-12 15:49:12.236', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/permission/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-clipboard-check-multiple', b'0', 'APP', 'SysPermissionContent', b'1', '0f7f0236-da8a-4a7f-8e87-db0275f42836', '/security/permission/content', NULL, '权限详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('0cf71777-908e-4e88-b7c6-36b75404396e', '2023-03-12 16:02:52.003', '2023-03-12 16:02:52.003', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/attribute/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-layers-edit', b'0', 'APP', 'SysAttributeAuthorize', b'1', '6de8f002-8e59-42a8-b201-3dba46aa6641', '/security/attribute/authorize', NULL, '元数据配置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('6b8d0925-66d7-4f5d-b3f4-fb9bb4bac670', '2023-03-31 14:26:35.349', '2023-03-31 14:26:35', NULL, 0, NULL, NULL, 0, b'1', 0, 'WEB', 'views/pages/security/tenant/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-database-edit', b'0', 'APP', 'SysTenantDataSourceContent', b'1', 'df94af5a-4f6f-4bda-a663-dcaaa9731b66', '/security/tenant/content', NULL, '数据源详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('23b4367a-dd41-484b-9078-e07caf9d8ec0', '2022-07-16 22:26:37.924', '2022-07-16 22:26:37', NULL, 0, NULL, NULL, 5, b'1', 0, 'WEB', 'views/pages/security/default-role/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-lock-open-alert', b'0', 'APP', 'SysDefaultRole', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/default-role', NULL, '默认角色');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('7934fb1f-c817-46bb-bd1c-6c849af7f292', '2023-05-28 21:33:50.411', '2023-05-28 21:37:15.403', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/pages/oss/bucket/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-bucket', b'0', 'APP', 'OssBucket', b'1', 'f2ed95c1-7856-40db-9e5b-a7b014ffcb63', '/oss/bucket', NULL, '存储桶管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('8ed3e85b-235c-4222-8d28-0c91ea177ac8', '2023-05-28 21:36:49.851', '2023-05-28 21:37:26.726', 'system', 0, 'system', NULL, 0, b'1', 0, 'WEB', 'views/pages/oss/bucket/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-bucket-outline', b'0', 'APP', 'OssBucketContent', b'1', '7934fb1f-c817-46bb-bd1c-6c849af7f292', '/oss/bucket/content', NULL, '存储桶详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('5b4ab829-1087-4ead-9368-83b388386c5c', '2023-05-31 23:07:27.146', '2023-05-31 23:07:47.669', 'system', 0, 'system', NULL, 2, b'1', 0, 'WEB', 'views/pages/oss/object/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-file-cabinet', b'0', 'APP', 'OssObject', b'1', 'f2ed95c1-7856-40db-9e5b-a7b014ffcb63', '/oss/object', NULL, '存储对象管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('be8c12e4-4de5-406e-bc9d-5a7dac2c0a10', '2023-06-06 12:28:56.979', '2023-06-06 12:29:07.842', 'system', 0, 'system', NULL, 2, b'1', 0, 'WEB', 'views/pages/oss/bucket/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-cog-outline', b'0', 'APP', 'OssBucketAuthorize', b'1', '7934fb1f-c817-46bb-bd1c-6c849af7f292', '/oss/bucket/authorize', NULL, '存储桶设置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('269d5202-faea-401a-80be-c10fb71b1c44', '2023-06-12 22:12:44.386', '2023-06-12 22:13:20.132', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/pages/oss/object/Authorize.vue', b'1', 'MENU', b'0', b'0', 'mdi-file-cog', b'0', 'APP', 'OssObjectAuthorize', b'1', '5b4ab829-1087-4ead-9368-83b388386c5c', '/oss/object/authorize', NULL, '对象详情设置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('055ceade-50ee-4f26-a816-f99ca408960b', '2023-07-04 23:33:40.791', '2023-07-04 23:34:57.979', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/pages/oss/object/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-folder-open', b'0', 'APP', 'OssObjectContent', b'1', '5b4ab829-1087-4ead-9368-83b388386c5c', '/oss/object/content', NULL, '文件夹详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('30ef4653-3c72-4e38-b69b-f5fc8e5aaa73', '2024-08-24 17:26:41.71', '2024-08-24 17:27:56.709', 'system', 0, 'system', NULL, 0, b'1', 0, 'WEB', 'views/pages/security/dictionary/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-playlist-edit', b'0', 'APP', 'SysDictionaryContent', b'1', 'ed1aafe3-9e56-4d40-8398-e9a1cb6ed2a6', '/security/dictionary/content', NULL, '字典详情');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('ed1aafe3-9e56-4d40-8398-e9a1cb6ed2a6', '2024-08-24 17:24:29.32', '2024-08-24 17:29:41.274', 'system', 0, 'system', NULL, 7, b'1', 0, 'WEB', 'views/pages/security/dictionary/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-playlist-check', b'0', 'APP', 'SysDictionary', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/dictionary', NULL, '数据字典');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('df94af5a-4f6f-4bda-a663-dcaaa9731b66', '2023-03-31 14:24:55.765', '2024-09-06 15:59:37.759', NULL, 0, 'system', NULL, 8, b'1', 0, 'WEB', 'views/pages/security/tenant/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-database-plus', b'0', 'APP', 'SysTenantDataSource', b'1', 'e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '/security/tenant', NULL, '多租户数据源');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('f2ed95c1-7856-40db-9e5b-a7b014ffcb63', '2023-05-28 21:32:26.818', '2025-01-18 22:21:11.994', 'system', 0, 'system', NULL, 8, b'1', 0, 'WEB', 'views/layouts/Index.vue', b'0', 'MENU', b'1', b'0', 'mdi-cloud-upload', b'0', 'APP', NULL, b'1', NULL, '/oss', '/oss/bucket', '对象存储管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('c2f9d2a0-04d4-4afa-a54a-f602449e74bd', '2025-11-23 22:10:08.92', '2025-11-23 22:13:32.724', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/layouts/Personal.vue', b'0', 'MENU', b'1', b'0', 'mdi-bell-badge', b'0', 'PERSONAL', NULL, b'1', NULL, '/message', '/message/information', '消息中心');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('548d3452-fa99-4ad4-8607-13dff96a32ee', '2025-11-23 23:12:54.466', '2025-11-23 23:15:08.196', 'system', 0, 'system', NULL, 2, b'1', 0, 'WEB', 'views/layouts/Personal.vue', b'0', 'MENU', b'1', b'0', 'mdi-account-cog', b'0', 'PERSONAL', NULL, b'1', NULL, '/foundation', '/foundation/account', '基础设置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('8d5bbd69-f73b-4288-8577-c7a6a47c2ab6', '2025-11-23 23:16:20.508', '2025-11-24 15:32:47.271', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/personal/message/information/Index.vue', b'0', 'MENU', b'1', b'1', 'mdi-bell', b'0', 'PERSONAL', 'MessageInformation', b'1', 'c2f9d2a0-04d4-4afa-a54a-f602449e74bd', '/message/information', NULL, '我的消息');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('e6b9d450-043f-4f62-b85a-2b5007c808b6', '2025-11-23 23:10:16.013', '2025-11-24 15:32:57.538', 'system', 0, 'system', NULL, 0, b'1', 0, 'WEB', 'views/personal/message/information/Content.vue', b'1', 'MENU', b'0', b'0', 'mdi-bank-check', b'0', 'PERSONAL', 'MessageInformationContent', b'1', '8d5bbd69-f73b-4288-8577-c7a6a47c2ab6', '/message/information/content', NULL, '私信记录');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('68584367-af66-4a23-aba2-b656e2c947a6', '2025-11-23 23:03:28.016', '2025-11-24 15:35:25.384', 'system', 0, 'system', NULL, 1, b'1', 0, 'WEB', 'views/personal/foundation/account/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-card-account-details', b'0', 'PERSONAL', 'FoundationAccount', b'1', '548d3452-fa99-4ad4-8607-13dff96a32ee', '/foundation/account', NULL, '账号管理');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('8026d76e-8b75-430d-919e-e41cf63fa72f', '2025-11-24 15:36:47.215', '2025-11-24 15:37:03.081', 'system', 0, 'system', NULL, 2, b'1', 0, 'WEB', 'views/personal/foundation/profile/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-account', b'0', 'PERSONAL', 'FoundationProfile', b'1', '548d3452-fa99-4ad4-8607-13dff96a32ee', '/foundation/profile', NULL, '个人资料');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('9d7356c7-14a8-40fe-ad87-700b8b962a97', '2025-11-24 15:38:01.949', '2025-11-24 15:38:31.523', 'system', 0, 'system', NULL, 2, b'1', 0, 'WEB', 'views/personal/message/setting/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-bell-cog', b'0', 'PERSONAL', 'MessageSetting', b'1', 'c2f9d2a0-04d4-4afa-a54a-f602449e74bd', '/message/setting', NULL, '通知设置');
INSERT INTO `sys_element` (`element_id`, `create_time`, `update_time`, `create_by`, `reversion`, `update_by`, `description`, `ranking`, `is_reserved`, `status`, `application_type`, `component`, `detail_content`, `element_category`, `have_child`, `hide_all_child`, `icon`, `ignore_auth`, `menu_scenario`, `name`, `not_keep_alive`, `parent_id`, `path`, `redirect`, `title`) VALUES ('26553c53-f11a-4c27-a415-350e0a383881', '2026-05-25 08:23:09.196', '2026-05-25 08:23:09.196', 'system', 0, 'system', NULL, 6, b'1', 0, 'WEB', 'views/pages/authorize/persistent/Index.vue', b'0', 'MENU', b'0', b'0', 'mdi-cookie-check', b'0', 'APP', 'OAuth2Persistent', b'1', '2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '/authorize/persistent', NULL, '记住审计');

-- ----------------------------
-- Table data for sys_element_role
-- ----------------------------
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e6ee0720-adc1-4ccf-99c5-2974b3c5dd22', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2f2a5b9a-b7ac-438d-bcb0-f69b75bd009c', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('41ec5b56-32d7-4029-8218-9c9bac6faa16', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2de6fcfe-12e6-4e6a-b772-b8dd728a7da0', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e96985c2-94a5-4e11-a3ab-a71a3b4d7027', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('147bec55-b50a-472b-b109-7912f0d9773a', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('b2e3f395-a861-46b8-a00b-96102eaa3f7c', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('6de8f002-8e59-42a8-b201-3dba46aa6641', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e9831f7d-89ee-44dc-bf19-7e00e51b9879', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9b26ec0d-4111-4a55-9a99-64e6a2dc5afe', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('19a3864e-ebd3-474f-be02-9dc2c27c6614', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2458dd66-9af9-4bae-babc-e4b988e4b4dd', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('5cbdef3d-4ad6-4867-b1ea-401c3fc1d587', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('32b43adf-1db4-4ac9-b996-15cfee008489', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('24fd94d8-6956-4ad7-ac8f-3bc6daf609a7', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('f4224093-4542-4c8b-85d1-3c25f28471df', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('98860f95-794b-4882-8e74-6c729e1ad95b', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('b14afb51-60a7-476d-bf45-57603d79f0db', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('0f7f0236-da8a-4a7f-8e87-db0275f42836', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('23b4367a-dd41-484b-9078-e07caf9d8ec0', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('118b6d69-1c5c-433c-8316-b65a9e263e45', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('4ec4ed5e-d815-4318-937a-12d567957237', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('6ebecd40-6fca-413d-adb4-a2e416d0c8ee', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('5fc067b0-8acc-48be-8334-d773cc649e88', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('5fc067b0-8acc-48be-8334-d773cc649e88', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('364f8273-e51a-486d-b53e-8e6b9f648c2c', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('364f8273-e51a-486d-b53e-8e6b9f648c2c', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('53b2fc4f-8681-47f3-8739-409265add9fc', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('53b2fc4f-8681-47f3-8739-409265add9fc', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('10eae473-87c5-4012-8078-8cd3c8d68c33', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('10eae473-87c5-4012-8078-8cd3c8d68c33', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('ddc98314-5b84-4471-9dd1-733103321504', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('ddc98314-5b84-4471-9dd1-733103321504', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('111b4ed4-d0a6-4837-9e25-c081092970f6', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('111b4ed4-d0a6-4837-9e25-c081092970f6', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('66a8b97c-9aa7-423d-a106-d19e209bdc7b', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('66a8b97c-9aa7-423d-a106-d19e209bdc7b', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('19e8d4f4-66ef-4407-b090-dad1220ea2c3', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('19e8d4f4-66ef-4407-b090-dad1220ea2c3', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('ee2a4314-531e-47ef-866b-8e04433bc934', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('ee2a4314-531e-47ef-866b-8e04433bc934', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('d319b130-9be4-46f4-bf56-97f14fb05260', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('b3e3cc74-a8cc-471a-b6be-6802d5b82a6a', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('4dcb04f5-bb64-470c-b6ff-52dd6f19bba0', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('3b83534e-016f-4e22-9553-5d8b96f29146', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('312d287f-ee2e-486f-b2e6-88328edb2c75', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('312d287f-ee2e-486f-b2e6-88328edb2c75', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('0f9aa3b0-c164-4a61-ae31-5fd73274ce53', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('0f9aa3b0-c164-4a61-ae31-5fd73274ce53', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2ca9ed44-ed47-4346-a310-d32375d0d5bf', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2ca9ed44-ed47-4346-a310-d32375d0d5bf', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('2ca9ed44-ed47-4346-a310-d32375d0d5bf', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('740a286c-2c53-45a7-9a0f-c9d6a5b5f389', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('740a286c-2c53-45a7-9a0f-c9d6a5b5f389', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('740a286c-2c53-45a7-9a0f-c9d6a5b5f389', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('cb426c81-7019-4249-a910-ced0d44ace97', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('0cf71777-908e-4e88-b7c6-36b75404396e', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('df94af5a-4f6f-4bda-a663-dcaaa9731b66', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('6b8d0925-66d7-4f5d-b3f4-fb9bb4bac670', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('f2ed95c1-7856-40db-9e5b-a7b014ffcb63', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('7934fb1f-c817-46bb-bd1c-6c849af7f292', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8ed3e85b-235c-4222-8d28-0c91ea177ac8', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('5b4ab829-1087-4ead-9368-83b388386c5c', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('be8c12e4-4de5-406e-bc9d-5a7dac2c0a10', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('269d5202-faea-401a-80be-c10fb71b1c44', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('055ceade-50ee-4f26-a816-f99ca408960b', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('ed1aafe3-9e56-4d40-8398-e9a1cb6ed2a6', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('30ef4653-3c72-4e38-b69b-f5fc8e5aaa73', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c2f9d2a0-04d4-4afa-a54a-f602449e74bd', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c2f9d2a0-04d4-4afa-a54a-f602449e74bd', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('548d3452-fa99-4ad4-8607-13dff96a32ee', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('548d3452-fa99-4ad4-8607-13dff96a32ee', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8d5bbd69-f73b-4288-8577-c7a6a47c2ab6', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8d5bbd69-f73b-4288-8577-c7a6a47c2ab6', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e6b9d450-043f-4f62-b85a-2b5007c808b6', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e6b9d450-043f-4f62-b85a-2b5007c808b6', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('68584367-af66-4a23-aba2-b656e2c947a6', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('68584367-af66-4a23-aba2-b656e2c947a6', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8026d76e-8b75-430d-919e-e41cf63fa72f', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8026d76e-8b75-430d-919e-e41cf63fa72f', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9d7356c7-14a8-40fe-ad87-700b8b962a97', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9d7356c7-14a8-40fe-ad87-700b8b962a97', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c21db958-7eab-4dbc-8061-966294684219', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c21db958-7eab-4dbc-8061-966294684219', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c21db958-7eab-4dbc-8061-966294684219', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9f064902-162a-408f-bd3e-866b03c9dae1', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9f064902-162a-408f-bd3e-866b03c9dae1', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9f064902-162a-408f-bd3e-866b03c9dae1', 'faccc981-7cd4-4333-9ef9-93752eb186bd');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('26553c53-f11a-4c27-a415-350e0a383881', '1');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('c2f9d2a0-04d4-4afa-a54a-f602449e74bd', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('548d3452-fa99-4ad4-8607-13dff96a32ee', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8d5bbd69-f73b-4288-8577-c7a6a47c2ab6', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('e6b9d450-043f-4f62-b85a-2b5007c808b6', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('68584367-af66-4a23-aba2-b656e2c947a6', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('8026d76e-8b75-430d-919e-e41cf63fa72f', '7e43d37d-d045-445f-a1de-cb1259f7709c');
INSERT INTO `sys_element_role` (`element_id`, `role_id`) VALUES ('9d7356c7-14a8-40fe-ad87-700b8b962a97', '7e43d37d-d045-445f-a1de-cb1259f7709c');

-- ----------------------------
-- Table data for oauth2_authorization_resource
-- ----------------------------

INSERT INTO `oauth2_authorization_resource` (`id`, `client_id`, `client_name`, `redirect_uris`, `logo`)
SELECT C.id                                                                    AS id,
       C.client_id,
       C.client_name,
       C.redirect_uris,
       (SELECT A.logo FROM oauth2_application A WHERE A.application_id = C.id) AS logo
FROM oauth2_registered_client C;

-- ----------------------------
-- Table data for sys_interface_authority
-- ----------------------------
INSERT INTO `sys_attribute_permission` (attribute_id, permission_id)
SELECT st.attribute_id,
       st.permission_id
FROM (SELECT '1' AS permission_id,
             sa.attribute_id
      FROM `sys_attribute` sa
      WHERE sa.url = '/security/element/tree'
         OR sa.url = '/security/element/resources'
         OR sa.url = '/security/element/{id}'
         OR sa.url = '/security/dictionary/items/{category}'
         OR sa.url = '/oauth2/sign-out'
         OR sa.url LIKE '%message%'
      UNION
      SELECT '2' AS permission_id,
             sa.attribute_id
      FROM `sys_attribute` sa
      WHERE sa.url LIKE '%authorize%' UNION
      SELECT
          '3' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%security%'
        AND sa.url != '/security/element/tree' AND sa.url != '/security/element/resources' AND sa.url != '/security/element/{id}' AND sa.url != '/security/dictionary/items/{category}'
      UNION
      SELECT
          '4' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%hr%'
      UNION
      SELECT
          '5' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%camunda-extended%'
      UNION
      SELECT
          '8' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%oss%'
      UNION
      SELECT
          '10' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%manage%'
      UNION
      SELECT
          '11' AS permission_id, sa.attribute_id
      FROM
          `sys_attribute` sa
      WHERE
          sa.url LIKE '%openapi/nacos%'
     ) AS st;