易公会测试初始化数据

<pre><code class="language-sql">-- 更新时间 2022/2/22 17:40 -- ---------------------------- -- 插入默认数据 功能和接口对应权限 -- ---------------------------- INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01001', 'EGH-API-FRONT-USER-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01002', 'EGH-API-FRONT-USER-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01003', 'EGH-API-FRONT-USER-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01004', 'EGH-API-FRONT-USER-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01005', 'EGH-API-FRONT-USER-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01006', 'EGH-API-FRONT-USER-01006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01007', 'EGH-API-FRONT-USER-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_USER_01008', 'EGH-API-FRONT-USER-01008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_MENU_01001', 'EGH-API-FRONT-MENU-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_01001', 'EGH-API-FRONT-SYS-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_01002', 'EGH-API-FRONT-SYS-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_01003', 'EGH-API-FRONT-SYS-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_01004', 'EGH-API-FRONT-SYS-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02001', 'EGH-API-FRONT-SYS-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02002', 'EGH-API-FRONT-SYS-02002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02003', 'EGH-API-FRONT-SYS-02003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02004', 'EGH-API-FRONT-SYS-02004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02005', 'EGH-API-FRONT-SYS-02005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_02006', 'EGH-API-FRONT-SYS-02006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_03001', 'EGH-API-FRONT-SYS-03001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04001', 'EGH-API-FRONT-SYS-04001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04002', 'EGH-API-FRONT-SYS-04002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04003', 'EGH-API-FRONT-SYS-04003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04004', 'EGH-API-FRONT-SYS-04004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04005', 'EGH-API-FRONT-SYS-04005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_04006', 'EGH-API-FRONT-SYS-04006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_05001', 'EGH-API-FRONT-SYS-05001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_05002', 'EGH-API-FRONT-SYS-05002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_05003', 'EGH-API-FRONT-SYS-05003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_05004', 'EGH-API-FRONT-SYS-05004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06001', 'EGH-API-FRONT-SYS-06001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06002', 'EGH-API-FRONT-SYS-06002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06003', 'EGH-API-FRONT-SYS-06003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06004', 'EGH-API-FRONT-SYS-06004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06005', 'EGH-API-FRONT-SYS-06005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06006', 'EGH-API-FRONT-SYS-06006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_06007', 'EGH-API-FRONT-SYS-06007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07001', 'EGH-API-FRONT-SYS-07001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07002', 'EGH-API-FRONT-SYS-07002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07003', 'EGH-API-FRONT-SYS-07003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07004', 'EGH-API-FRONT-SYS-07004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_SYS_07005', 'EGH-API-FRONT-SYS-07005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01001', 'EGH-API-FRONT-INFO-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01002', 'EGH-API-FRONT-INFO-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01003', 'EGH-API-FRONT-INFO-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01005', 'EGH-API-FRONT-INFO-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01007', 'EGH-API-FRONT-INFO-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01008', 'EGH-API-FRONT-INFO-01008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01009', 'EGH-API-FRONT-INFO-01009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01010', 'EGH-API-FRONT-INFO-01010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01011', 'EGH-API-FRONT-INFO-01011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01012', 'EGH-API-FRONT-INFO-01012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_01013', 'EGH-API-FRONT-INFO-01013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02001', 'EGH-API-FRONT-INFO-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02002', 'EGH-API-FRONT-INFO-02002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02003', 'EGH-API-FRONT-INFO-02003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02004', 'EGH-API-FRONT-INFO-02004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02005', 'EGH-API-FRONT-INFO-02005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02006', 'EGH-API-FRONT-INFO-02006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_02007', 'EGH-API-FRONT-INFO-02007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03001', 'EGH-API-FRONT-INFO-03001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03003', 'EGH-API-FRONT-INFO-03003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03004', 'EGH-API-FRONT-INFO-03004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03005', 'EGH-API-FRONT-INFO-03005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_03006', 'EGH-API-FRONT-INFO-03006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_04001', 'EGH-API-FRONT-INFO-04001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_04002', 'EGH-API-FRONT-INFO-04002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_INFO_04003', 'EGH-API-FRONT-INFO-04003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01001', 'EGH-API-FRONT-TEAM-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01002', 'EGH-API-FRONT-TEAM-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01003', 'EGH-API-FRONT-TEAM-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01004', 'EGH-API-FRONT-TEAM-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01005', 'EGH-API-FRONT-TEAM-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01006', 'EGH-API-FRONT-TEAM-01006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01007', 'EGH-API-FRONT-TEAM-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01008', 'EGH-API-FRONT-TEAM-01008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01009', 'EGH-API-FRONT-TEAM-01009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01010', 'EGH-API-FRONT-TEAM-01010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01011', 'EGH-API-FRONT-TEAM-01011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01012', 'EGH-API-FRONT-TEAM-01012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01013', 'EGH-API-FRONT-TEAM-01013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_01014', 'EGH-API-FRONT-TEAM-01014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02001', 'EGH-API-FRONT-TEAM-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02002', 'EGH-API-FRONT-TEAM-02002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02003', 'EGH-API-FRONT-TEAM-02003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02004', 'EGH-API-FRONT-TEAM-02004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02005', 'EGH-API-FRONT-TEAM-02005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02006', 'EGH-API-FRONT-TEAM-02006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02007', 'EGH-API-FRONT-TEAM-02007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02008', 'EGH-API-FRONT-TEAM-02008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02009', 'EGH-API-FRONT-TEAM-02009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02010', 'EGH-API-FRONT-TEAM-02010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02011', 'EGH-API-FRONT-TEAM-02011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02012', 'EGH-API-FRONT-TEAM-02012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02013', 'EGH-API-FRONT-TEAM-02013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02014', 'EGH-API-FRONT-TEAM-02014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02015', 'EGH-API-FRONT-TEAM-02015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_02016', 'EGH-API-FRONT-TEAM-02016'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03001', 'EGH-API-FRONT-TEAM-03001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03002', 'EGH-API-FRONT-TEAM-03002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03003', 'EGH-API-FRONT-TEAM-03003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03004', 'EGH-API-FRONT-TEAM-03004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03005', 'EGH-API-FRONT-TEAM-03005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03006', 'EGH-API-FRONT-TEAM-03006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03007', 'EGH-API-FRONT-TEAM-03007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03008', 'EGH-API-FRONT-TEAM-03008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03009', 'EGH-API-FRONT-TEAM-03009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03010', 'EGH-API-FRONT-TEAM-03010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03011', 'EGH-API-FRONT-TEAM-03011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03012', 'EGH-API-FRONT-TEAM-03012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03013', 'EGH-API-FRONT-TEAM-03013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03014', 'EGH-API-FRONT-TEAM-03014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03015', 'EGH-API-FRONT-TEAM-03015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03016', 'EGH-API-FRONT-TEAM-03016'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03017', 'EGH-API-FRONT-TEAM-03017'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03018', 'EGH-API-FRONT-TEAM-03018'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03019', 'EGH-API-FRONT-TEAM-03019'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03020', 'EGH-API-FRONT-TEAM-03020'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_03021', 'EGH-API-FRONT-TEAM-03021'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04001', 'EGH-API-FRONT-TEAM-04001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04002', 'EGH-API-FRONT-TEAM-04002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04003', 'EGH-API-FRONT-TEAM-04003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04004', 'EGH-API-FRONT-TEAM-04004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04005', 'EGH-API-FRONT-TEAM-04005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04006', 'EGH-API-FRONT-TEAM-04006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04007', 'EGH-API-FRONT-TEAM-04007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04008', 'EGH-API-FRONT-TEAM-04008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04009', 'EGH-API-FRONT-TEAM-04009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04010', 'EGH-API-FRONT-TEAM-04010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04011', 'EGH-API-FRONT-TEAM-04011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04012', 'EGH-API-FRONT-TEAM-04012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04013', 'EGH-API-FRONT-TEAM-04013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04014', 'EGH-API-FRONT-TEAM-04014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_04015', 'EGH-API-FRONT-TEAM-04015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05001', 'EGH-API-FRONT-TEAM-05001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05002', 'EGH-API-FRONT-TEAM-05002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05003', 'EGH-API-FRONT-TEAM-05003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05004', 'EGH-API-FRONT-TEAM-05004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05005', 'EGH-API-FRONT-TEAM-05005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_05006', 'EGH-API-FRONT-TEAM-05006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_06001', 'EGH-API-FRONT-TEAM-06001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_06002', 'EGH-API-FRONT-TEAM-06002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_06003', 'EGH-API-FRONT-TEAM-06003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07001', 'EGH-API-FRONT-TEAM-07001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07002', 'EGH-API-FRONT-TEAM-07002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07003', 'EGH-API-FRONT-TEAM-07003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07005', 'EGH-API-FRONT-TEAM-07005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07006', 'EGH-API-FRONT-TEAM-07006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07007', 'EGH-API-FRONT-TEAM-07007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_07008', 'EGH-API-FRONT-TEAM-07008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08001', 'EGH-API-FRONT-TEAM-08001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08002', 'EGH-API-FRONT-TEAM-08002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08003', 'EGH-API-FRONT-TEAM-08003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08004', 'EGH-API-FRONT-TEAM-08004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08005', 'EGH-API-FRONT-TEAM-08005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08006', 'EGH-API-FRONT-TEAM-08006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08007', 'EGH-API-FRONT-TEAM-08007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08008', 'EGH-API-FRONT-TEAM-08008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_08009', 'EGH-API-FRONT-TEAM-08009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09001', 'EGH-API-FRONT-TEAM-09001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09002', 'EGH-API-FRONT-TEAM-09002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09003', 'EGH-API-FRONT-TEAM-09003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09004', 'EGH-API-FRONT-TEAM-09004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09005', 'EGH-API-FRONT-TEAM-09005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_TEAM_09006', 'EGH-API-FRONT-TEAM-09006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01999', 'EGH-API-FRONT-STL-01999'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01997', 'EGH-API-FRONT-STL-01997'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01996', 'EGH-API-FRONT-STL-01996'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01101', 'EGH-API-FRONT-STL-01101'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01102', 'EGH-API-FRONT-STL-01102'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01103', 'EGH-API-FRONT-STL-01103'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01201', 'EGH-API-FRONT-STL-01201'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01202', 'EGH-API-FRONT-STL-01202'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01203', 'EGH-API-FRONT-STL-01203'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01301', 'EGH-API-FRONT-STL-01301'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01302', 'EGH-API-FRONT-STL-01302'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01303', 'EGH-API-FRONT-STL-01303'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01401', 'EGH-API-FRONT-STL-01401'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01402', 'EGH-API-FRONT-STL-01402'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01403', 'EGH-API-FRONT-STL-01403'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01404', 'EGH-API-FRONT-STL-01404'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01004', 'EGH-API-FRONT-STL-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01005', 'EGH-API-FRONT-STL-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01007', 'EGH-API-FRONT-STL-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01015', 'EGH-API-FRONT-STL-01015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01016', 'EGH-API-FRONT-STL-01016'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01017', 'EGH-API-FRONT-STL-01017'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_01018', 'EGH-API-FRONT-STL-01018'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02001', 'EGH-API-FRONT-STL-02001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02002', 'EGH-API-FRONT-STL-02002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02003', 'EGH-API-FRONT-STL-02003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02004', 'EGH-API-FRONT-STL-02004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02005', 'EGH-API-FRONT-STL-02005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02006', 'EGH-API-FRONT-STL-02006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02007', 'EGH-API-FRONT-STL-02007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02008', 'EGH-API-FRONT-STL-02008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02009', 'EGH-API-FRONT-STL-02009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02011', 'EGH-API-FRONT-STL-02011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02012', 'EGH-API-FRONT-STL-02012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_02013', 'EGH-API-FRONT-STL-02013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05001', 'EGH-API-FRONT-STL-05001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05002', 'EGH-API-FRONT-STL-05002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03001', 'EGH-API-FRONT-STL-03001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03002', 'EGH-API-FRONT-STL-03002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03003', 'EGH-API-FRONT-STL-03003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03005', 'EGH-API-FRONT-STL-03005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03006', 'EGH-API-FRONT-STL-03006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03007', 'EGH-API-FRONT-STL-03007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03008', 'EGH-API-FRONT-STL-03008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03009', 'EGH-API-FRONT-STL-03009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03011', 'EGH-API-FRONT-STL-03011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03012', 'EGH-API-FRONT-STL-03012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03013', 'EGH-API-FRONT-STL-03013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03014', 'EGH-API-FRONT-STL-03014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03015', 'EGH-API-FRONT-STL-03015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_03016', 'EGH-API-FRONT-STL-03016'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04001', 'EGH-API-FRONT-STL-04001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04002', 'EGH-API-FRONT-STL-04002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04003', 'EGH-API-FRONT-STL-04003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04004', 'EGH-API-FRONT-STL-04004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04005', 'EGH-API-FRONT-STL-04005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04007', 'EGH-API-FRONT-STL-04007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04008', 'EGH-API-FRONT-STL-04008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04009', 'EGH-API-FRONT-STL-04009'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04010', 'EGH-API-FRONT-STL-04010'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04011', 'EGH-API-FRONT-STL-04011'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04012', 'EGH-API-FRONT-STL-04012'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04013', 'EGH-API-FRONT-STL-04013'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04014', 'EGH-API-FRONT-STL-04014'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04015', 'EGH-API-FRONT-STL-04015'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_04016', 'EGH-API-FRONT-STL-04016'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05100', 'EGH-API-FRONT-STL-05100'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05101', 'EGH-API-FRONT-STL-05101'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05102', 'EGH-API-FRONT-STL-05102'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05103', 'EGH-API-FRONT-STL-05103'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05104', 'EGH-API-FRONT-STL-05104'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05105', 'EGH-API-FRONT-STL-05105'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05106', 'EGH-API-FRONT-STL-05106'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05201', 'EGH-API-FRONT-STL-05201'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_05202', 'EGH-API-FRONT-STL-05202'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06001', 'EGH-API-FRONT-STL-06001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06002', 'EGH-API-FRONT-STL-06002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06003', 'EGH-API-FRONT-STL-06003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06004', 'EGH-API-FRONT-STL-06004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06005', 'EGH-API-FRONT-STL-06005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06006', 'EGH-API-FRONT-STL-06006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06007', 'EGH-API-FRONT-STL-06007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06101', 'EGH-API-FRONT-STL-06101'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06102', 'EGH-API-FRONT-STL-06102'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06103', 'EGH-API-FRONT-STL-06103'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06104', 'EGH-API-FRONT-STL-06104'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06105', 'EGH-API-FRONT-STL-06105'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06106', 'EGH-API-FRONT-STL-06106'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_06107', 'EGH-API-FRONT-STL-06107'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_07001', 'EGH-API-FRONT-STL-07001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_07002', 'EGH-API-FRONT-STL-07002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_STL_07003', 'EGH-API-FRONT-STL-07003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01001', 'EGH-API-FRONT-WD-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01002', 'EGH-API-FRONT-WD-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WD_01003', 'EGH-API-FRONT-WD-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01001', 'EGH-API-FRONT-WAL-01001'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01002', 'EGH-API-FRONT-WAL-01002'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01003', 'EGH-API-FRONT-WAL-01003'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01004', 'EGH-API-FRONT-WAL-01004'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01005', 'EGH-API-FRONT-WAL-01005'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01006', 'EGH-API-FRONT-WAL-01006'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01007', 'EGH-API-FRONT-WAL-01007'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01008', 'EGH-API-FRONT-WAL-01008'); INSERT INTO `api_privilege`(`func_title`, `api_title`) VALUES ('EGH_WAL_01009', 'EGH-API-FRONT-WAL-01009'); -- ---------------------------- -- 插入默认数据 角色默认权限 -- ---------------------------- -- 系统管理员对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_01001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_01002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_01003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_01004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_02006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_03001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_04006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_05001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_05002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_05003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_05004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_06007', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_07001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_07002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_07003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_07004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_SYS_07005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01013', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01008', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01009', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01010', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01011', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01012', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01013', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01014', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02009', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02010', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02011', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02012', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02013', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02014', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02015', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02016', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03010', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03011', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03012', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03015', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03019', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03021', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08008', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01102', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01103', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01202', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01203', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01302', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01303', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01402', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01403', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01015', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01016', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01017', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01018', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02003', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02004', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02005', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02006', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02008', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02011', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02012', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02013', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05002', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03001', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03008', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03009', 'R20210001'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01003', 'R20210001'); -- 超级管理员对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01013','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01006','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01009','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01010','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01011','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01013','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01014','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02009','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02010','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02011','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02013','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02014','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02015','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02016','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03010','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03011','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03015','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03019','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03021','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05006','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07006','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07007','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09006','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01102','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01103','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01202','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01203','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01302','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01303','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01402','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01403','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01015','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01016','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01017','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01018','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02003','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02004','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02006','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02011','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02013','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03008','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03009','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04005','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04007','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04012','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05201','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05202','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01001','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01002','R20210002'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01003','R20210002'); -- 结算主管对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01013','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01010','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01011','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02009','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02010','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02011','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02013','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02014','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02015','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03010','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03011','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03015','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03019','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_05006','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_06003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_07005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08006','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08008','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01999','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01997','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01101','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01102','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01103','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01201','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01202','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01203','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01301','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01302','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01303','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01401','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01402','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01403','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01404','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01015','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01016','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01017','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_01018','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02006','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02008','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02009','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02011','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_02013','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03008','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03009','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03015','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_03016','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04008','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04009','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04010','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04011','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04012','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04013','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04014','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04015','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_04016','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05100','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05101','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05102','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05103','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05104','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05105','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_05106','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06003','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06004','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06005','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06006','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06007','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06101','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06102','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06103','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06104','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06105','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06106','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_06107','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_07001','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_07002','R20210003'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_STL_07003','R20210003'); -- 结算客服对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('','R20210004'); -- 会长对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01007','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01009','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01012','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01014','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02001','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02002','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02003','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02004','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02005','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02006','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02008','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02009','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02010','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02011','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02012','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02013','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02014','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02015','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02016','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03010','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03011','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03012','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03015','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03019','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03021','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09003','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09004','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09005','R20210005'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09006','R20210005'); -- 执行管理对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_01014','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02007','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02012','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_02015','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03001','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03002','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03003','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03004','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03005','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03008','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03009','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03010','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03011','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03012','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03015','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03019','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03021','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09003','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09004','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09005','R20210006'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09006','R20210006'); -- 主管对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_MENU_01001','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01001','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04003','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03006','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03007','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03013','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03014','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03016','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03018','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03020','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04001','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04002','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04003','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04004','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04005','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04006','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04007','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04009','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04011','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04012','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04013','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04014','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04015','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08004','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08005','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08007','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_08009','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09002','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09003','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09004','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09005','R20210007'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_09006','R20210007'); -- 艺人对应功能权限 INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01001','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01002','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01004','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01005','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01006','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_USER_01007','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01002','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01005','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01007','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01008','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01009','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01012','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_01013','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02001','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02002','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02004','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02005','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02006','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_02007','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_03001','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_03003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_03004','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_INFO_04001','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_03017','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_TEAM_04008','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01002','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WD_01003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01001','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01002','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01003','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01004','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01005','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01006','R20210008'); INSERT INTO `role_privilege` (`func_title`, `role_id`) VALUES ('EGH_WAL_01007','R20210008'); -- ---------------------------- -- 插入默认数据 角色信息 -- ---------------------------- INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210001', '系统管理', 'RG1', 100); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210002', '超级管理', 'RG1', 95); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210003', '结算主管', 'RG1', 40); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210004', '结算客服', 'RG1', 30); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210005', '会长', 'RG2', 35); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210006', '执行管理', 'RG2', 25); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210007', '主管', 'RG2', 15); INSERT INTO `role`(`id`, `name`, `role_group`, `rank`) VALUES ('R20210008', '艺人', 'RG2', 5); -- ---------------------------- -- 插入默认数据 部门信息 -- ---------------------------- INSERT INTO `dept_node`(`id`, `name`, `type`, `scope`) VALUES ('DN20216666', '业务部', 1, 5); INSERT INTO `dept_node`(`id`, `name`, `type`, `scope`) VALUES ('DN20218888', '职能部', 2, 60); INSERT INTO `dept_node`(`id`, `name`, `type`, `scope`, `prev_node_id`, `root_node_id`) VALUES ('DN22220001', '结算中心', 2, 65, 'DN20218888', 'DN20218888'); -- ---------------------------- -- 插入默认数据 流程 -- ---------------------------- INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR601CFB13N8VQDM', '新增业务账号', 'INFO_C_BIZACCOUNT_001'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR601D002516KMMU', '修改业务账号', 'INFO_U_BIZACCOUNT_002'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR601D0925NFZRIL', '艺人换厅', 'TEAM_U_CHGROOM_003'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR601D0B81VAITOP', '厅删除', 'TEAM_D_ROOM_004'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR601D0E95IBMH30', '运营组删除', 'TEAM_D_GROUP_005'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR61E69AFFUDWVYL', '绑定公用账号', 'BIND_PUBLIC_BIZ_ACCT'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR61E7CBC2TVBQZK', '移除公用账号', 'REMOVE_PUBLIC_BIZ_ACCT'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR61D8004FOB0X6M', '业务账号冻结流程', 'INFO_FREEZE_BIZACCT'); INSERT INTO `process`(`id`, `name`, `process_num`) VALUES ('PR61E000D4GZQAEW', '业务账号解冻流程', 'INFO_UNFREEZE_BIZACCT'); -- ---------------------------- -- 插入默认数据 流程字段 -- ---------------------------- INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB17SRO9G2', 'PR601CFB13N8VQDM', '账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB17TIWLP9', 'PR601CFB13N8VQDM', '原业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB176DSB1Y', 'PR601CFB13N8VQDM', '原业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB17AMYQ1E', 'PR601CFB13N8VQDM', '新业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB179KKOO6', 'PR601CFB13N8VQDM', '新业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB173JPAOK', 'PR601CFB13N8VQDM', '厅id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601CFB172HJQOW', 'PR601CFB13N8VQDM', '账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E28330HAICVW', 'PR601CFB13N8VQDM', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029ZTULHI', 'PR601D002516KMMU', '账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029WFBX7U', 'PR601D002516KMMU', '原业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029PZPYDF', 'PR601D002516KMMU', '原业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029LPBBDW', 'PR601D002516KMMU', '新业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029KONPI4', 'PR601D002516KMMU', '新业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029FH06UH', 'PR601D002516KMMU', '厅id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0029OJQHTN', 'PR601D002516KMMU', '账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61EEA488TXV583', 'PR601D002516KMMU', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0506AJGB6D', 'PR601D0502IYTK7P', '账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0506AIJOCL', 'PR601D0502IYTK7P', '业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0506IV1YD0', 'PR601D0502IYTK7P', '业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D092806YPVK', 'PR601D0925NFZRIL', '账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928RCHZOA', 'PR601D0925NFZRIL', '业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928NJFG80', 'PR601D0925NFZRIL', '业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928RFAQIE', 'PR601D0925NFZRIL', '当前部门id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928VRXO7B', 'PR601D0925NFZRIL', '当前部门名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928SX8NUF', 'PR601D0925NFZRIL', '当前部门负责人', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928ZESCNK', 'PR601D0925NFZRIL', '更换部门id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928HAFJNM', 'PR601D0925NFZRIL', '更换部门名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0928QVUK5Z', 'PR601D0925NFZRIL', '更换部门负责人', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D09289AMIB0', 'PR601D0925NFZRIL', '账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0B85YEQPGH', 'PR601D0B81VAITOP', '厅名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0B85L4YXLM', 'PR601D0B81VAITOP', '厅id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0B85W09QAZ', 'PR601D0B81VAITOP', '厅房间号', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0E98OBPZIN', 'PR601D0E95IBMH30', '运营组名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF601D0E98YL3HWD', 'PR601D0E95IBMH30', '运营组id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58PBKZIW', 'PR61E69AFFUDWVYL', '用户花名', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58N6N1MO', 'PR61E69AFFUDWVYL', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58U7ECIB', 'PR61E69AFFUDWVYL', '业务账号部门ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7DF1319QTGB', 'PR61E69AFFUDWVYL', '业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58AAV89T', 'PR61E69AFFUDWVYL', '业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7890CSLZRFW', 'PR61E69AFFUDWVYL', '厅ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F58W38HFE', 'PR61E69AFFUDWVYL', '厅房间号', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F97KE3FZO', 'PR61E69AFFUDWVYL', '厅部门名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E77F97K7PT10', 'PR61E69AFFUDWVYL', '厅负责人', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC490QPXLV', 'PR61E7CBC2TVBQZK', '用户花名', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC49ZQSBWW', 'PR61E7CBC2TVBQZK', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC49FNKGHA', 'PR61E7CBC2TVBQZK', '业务账号部门ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC491U7KND', 'PR61E7CBC2TVBQZK', '业务账号id', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC494FVHWJ', 'PR61E7CBC2TVBQZK', '业务账号昵称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC5CGA9TYV', 'PR61E7CBC2TVBQZK', '厅ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC5CQIITH4', 'PR61E7CBC2TVBQZK', '厅房间号', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC5CVEQVDT', 'PR61E7CBC2TVBQZK', '厅部门名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7CC6FOSMVSI', 'PR61E7CBC2TVBQZK', '厅负责人', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0G1C6KO', 'PR61D8004FOB0X6M', '用户ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0CNSR2K', 'PR61D8004FOB0X6M', '用户花名', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F02POU0V', 'PR61D8004FOB0X6M', '业务账号ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0NUWEZL', 'PR61D8004FOB0X6M', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0TCMZWB', 'PR61D8004FOB0X6M', '厅名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0BLYTOG', 'PR61D8004FOB0X6M', '厅ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0UXPVZC', 'PR61D8004FOB0X6M', '冻结原因', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F08XN7YG', 'PR61D8004FOB0X6M', '申请日期', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E002F0ZBHUCX', 'PR61D8004FOB0X6M', '审核日期', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E7C26ENOM2GF', 'PR61E000D4GZQAEW', '冻结流程ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCE4WFRG', 'PR61E000D4GZQAEW', '用户ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCWIED2J', 'PR61E000D4GZQAEW', '用户花名', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCXV79HC', 'PR61E000D4GZQAEW', '业务账号ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCBIJAF7', 'PR61E000D4GZQAEW', '业务账号类型', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCHWLBZD', 'PR61E000D4GZQAEW', '厅名称', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CC9DQVTN', 'PR61E000D4GZQAEW', '厅ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CC3IA6UM', 'PR61E000D4GZQAEW', '解冻原因', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCBYF90A', 'PR61E000D4GZQAEW', '申请日期', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E003CCJTKC1G', 'PR61E000D4GZQAEW', '审核日期', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E905E0HQLPZJ', 'PR61E000D4GZQAEW', '审核人', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61E91249NYVF2K', 'PR61E000D4GZQAEW', '划款记录批次ID', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61F0C1DC8MZHS5', 'PR61E000D4GZQAEW', '冻结金额', 1, 1); INSERT INTO `process_field`(`id`, `process_id`, `name`, `type`, `is_not_null`) VALUES ('PF61F0C5D1WB89RL', 'PR61E000D4GZQAEW', '冻结数量', 1, 1); -- ---------------------------- -- 插入默认数据 流程节点 -- ---------------------------- INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601CFB15RHJAKE', 1, 'PR601CFB13N8VQDM', 'EGH-API-FRONT-INFO-03003', 'PN601CFB15ONWIMH', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601CFB15ONWIMH', 2, 'PR601CFB13N8VQDM', 'EGH-API-FRONT-INFO-03003', '', 'PN601CFB15RHJAKE'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0027IGIJ9W', 1, 'PR601D002516KMMU', 'EGH-API-FRONT-INFO-03004', 'PN601D0027SEWBVC', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0027SEWBVC', 2, 'PR601D002516KMMU', 'EGH-API-FRONT-INFO-03004', '', 'PN601D0027IGIJ9W'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0926I0CDMJ', 1, 'PR601D0925NFZRIL', 'EGH-API-FRONT-TEAM-04014', 'PN601D0926MALNUE', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0926MALNUE', 2, 'PR601D0925NFZRIL', 'EGH-API-FRONT-TEAM-04014', '', 'PN601D0926I0CDMJ'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0B83PE6XOM', 1, 'PR601D0B81VAITOP', 'EGH-API-FRONT-TEAM-03002', 'PN601D0B83LLMTTR', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0B83LLMTTR', 2, 'PR601D0B81VAITOP', 'EGH-API-FRONT-TEAM-03002', '', 'PN601D0B83PE6XOM'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0E96S0N2PW', 1, 'PR601D0E95IBMH30', 'EGH-API-FRONT-TEAM-02002', 'PN601D0E96I8CXUJ', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN601D0E96I8CXUJ', 2, 'PR601D0E95IBMH30', 'EGH-API-FRONT-TEAM-02002', '', 'PN601D0E96S0N2PW'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E77E661KSK28', 1, 'PR61E69AFFUDWVYL', 'EGH-API-FRONT-INFO-03004', 'PN61E77E66GVSXGZ', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E77E66GVSXGZ', 2, 'PR61E69AFFUDWVYL', 'EGH-API-FRONT-INFO-03004', '', 'PN61E77E661KSK28'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E7CC26IRSZBL', 1, 'PR61E7CBC2TVBQZK', 'EGH-API-FRONT-INFO-03004', 'PN61E7CC261UAD0J', ''); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61E7CC261UAD0J', 2, 'PR61E7CBC2TVBQZK', 'EGH-API-FRONT-INFO-03004', '', 'PN61E7CC26IRSZBL'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61D80463SEW90D', 1, 'PR61D8004FOB0X6M', 'EGH-API-FRONT-TEAM-04012', NULL, NULL); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61D80463RGBD7L', 2, 'PR61E000D4GZQAEW', 'EGH-API-FRONT-TEAM-04013', NULL, 'PN61D80463IAEQSZ'); INSERT INTO `process_node`(`id`, `type`, `process_id`, `func_title`, `prev_node_id`, `next_node_id`) VALUES ('PN61D80463IAEQSZ', 1, 'PR61E000D4GZQAEW', 'EGH-API-FRONT-TEAM-04013', 'PN61D80463RGBD7L', NULL); -- ---------------------------- -- -- 用于测试环境测试数据 -- ---------------------------- -- 添加新用户: 15895908751 密码: 123456 INSERT INTO `user`(`id`, `phone_num`, `alias`, `name`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', '15895908751', '林居', '邵宠'); INSERT INTO `user_auth_rel`(`user_id`, `auth_id`, `auth_type`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'ULA6143459E5Z2SPD', 1); INSERT INTO `user_local_auth`(`id`, `password`) VALUES ('ULA6143459E5Z2SPD', '1cad2cc13947bc21c921b05c9e1dcb28ab32ec99'); INSERT INTO `user_auth_rel`(`user_id`, `auth_id`, `auth_type`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'ULA6143459EOOZMU7', 11); -- 添加钱包账户 -- INSERT INTO `wallet_account`(`id`, `number`, `available`, `frozen`, `user_id`) VALUES ('WALACCT001631798686263BC762C097D124D7CB240FB0BA357E1E2', '85132855753432736314008865839536684688745653760311206415', '0','0', 'U001631798686262ABE1FA6978024BA99DEEA73D5508A20F'); -- 添加角色: 系统管理, 艺人 INSERT INTO `user_and_role`(`user_id`, `role_id`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'R20210001'); INSERT INTO `user_and_role`(`user_id`, `role_id`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'R20210008'); -- 部门权限: DN20218888, DN20216666 INSERT INTO `user_privilege`(`user_id`, `role_id`, `dept_id`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'R20210001', 'DN20218888'); INSERT INTO `user_privilege`(`user_id`, `role_id`, `dept_id`) VALUES ('U001631798686262ABE1FA6978024BA99DEEA73D5508A20F', 'R20210001', 'DN20216666'); </code></pre>