eosrolemenu_data.sql

来自「软件维护单管理系统, 软件维护单管理系统」· SQL 代码 · 共 249 行

SQL
249
字号
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_003_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_003_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FBFILE_Manager1'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_System_BNDict'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_ChangePass'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_SetFuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_Menu_Menu'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_Orgjigou'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_BizOrg'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_ManageRole'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_DataAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_Busi_Busi'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_OperatorMain'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_003_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_003_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_003_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolea', 'WF5_003_004'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'roleb', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'roleb', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'roleb', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'roleb', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolec', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolec', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolec', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'rolec', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'softwar_main_query'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', '11'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FBFILE_Manager'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_FuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_EDIT'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_Org'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'FDFRAME_Authority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'software_main'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_003_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_003_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_003_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_System_BNDict'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_ChangePass'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_SetFuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_Menu_Menu'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_Orgjigou'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_BizOrg'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_ManageRole'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_DataAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_Busi_Busi'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_OperatorMain'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'softwar_main_query'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', '11'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_FuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_EDIT'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_Org'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'FDFRAME_Authority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'software_main'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_003_004'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_003_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_003_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_003_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_System_BNDict'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_ChangePass'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_SetFuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_Menu_Menu'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_Orgjigou'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_BizOrg'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_ManageRole'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_DataAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_Busi_Busi'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_OperatorMain'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'softwar_main_query'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', '11'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_FuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_EDIT'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_Org'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'FDFRAME_Authority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'1', 'software_main'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_003_004'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_003_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_003_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_003_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_002_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_002_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_002_001'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_System_BNDict'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_ChangePass'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_SetFuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_Menu_Menu'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_Orgjigou'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_BizOrg'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_ManageRole'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_DataAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_Busi_Busi'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_OperatorMain'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'softwar_main_query'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', '11'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_003'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'WF5_002'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_FuncAuthority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_EDIT'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_Org'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'FDFRAME_Authority'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'2', 'software_main'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'3', 'WF5_003_004'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_003_004'); 
INSERT INTO EOSROLEMENU ( ROLEID, MENUID ) VALUES ( 
'eosadmin', 'WF5_003_003'); 
commit;
 

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?