eosrole_data.sql

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

INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'1', NULL, '开发维护岗', NULL); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'2', NULL, '软件科科长', NULL); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'3', NULL, '分管主任', NULL); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'eosadmin', 'admin', '系统管理员', 100); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'Guest', 'sampleUser', '嘉宾', 0); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'rolea', NULL, '角色A', 200); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'roleb', NULL, '角色B', 200); 
INSERT INTO EOSROLE ( ROLEID, GROUPID, ROLENAME, ROLECLASS ) VALUES ( 
'rolec', NULL, '角色C', 200); 
commit;