insert.sql

公务员管理系统

INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500001', '公务员新增', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500002', '公务员减少', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500003', '公务员减少恢复', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500004', '公务员审批', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500005', '公务员口令修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500006', '公务员权限管理', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0300001', '案件文档添加', 'anjian_tj'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0300002', '案件文档查看', 'anjian_ck'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0300003', '案件文档修改', 'anjian_xg'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0300004', '案件文档删除', 'anjian_sc'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0400001', '案卷查看', 'anjuan_ck'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0400002', '案卷修改', 'anjuan_xg'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0400003', '案卷删除', 'anjuan_sc'); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100001', '个体单位信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100002', '法人单位信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100003', '非法人分支单位信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100004', '单位信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100005', '单位信息转移', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100006', '单位信息减少', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100007', '单位信息减少恢复', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100008', '个体单位信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100009', '法人单位信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100010', '非法人分支单位信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100011', '个体单位信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100012', '法人单位信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0100013', '非法人分支单位信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200001', '年检信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200002', '执法检查信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200003', '年检信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200004', '执法检查信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200005', '年检信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200006', '执法检查信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200007', '年检信息删除', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0200008', '执法检查信息删除', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0900001', '法规信息录入', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0900002', '法规信息查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0900003', '法规信息修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0900004', '法规信息删除', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0700001', '新增企业不良信息', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0700002', '上报企业不良信息', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0700003', '报送企业不良信息', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500007', '公务单位条件查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500008', '公务员口令维护', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500009', '公务员查询', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500010', '公务员修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500011', '公务单位新增/修改', NULL); 
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES ( 
'B0500012', '公务单位查询结果显示', NULL); 
commit;

INSERT INTO QX_USER ( USERID, PASSWORD, DESCRIBE, FLAG, USERCODE, USERNAME, SFZH, XB, MZ, CSRQ, ZW,
RYZT ) VALUES ( 
'1', '7258ADF9B7DC84D3C1FA5745335AFCC3', 'bbb', '01', '1', 'aaa', NULL, NULL, NULL
, NULL, NULL, NULL); 
INSERT INTO QX_USER ( USERID, PASSWORD, DESCRIBE, FLAG, USERCODE, USERNAME, SFZH, XB, MZ, CSRQ, ZW,
RYZT ) VALUES ( 
'2', '7258ADF9B7DC84D3C1FA5745335AFCC3', NULL, '01', '2', 'asdf', NULL, NULL, NULL
, NULL, NULL, NULL); 
INSERT INTO QX_USER ( USERID, PASSWORD, DESCRIBE, FLAG, USERCODE, USERNAME, SFZH, XB, MZ, CSRQ, ZW,
RYZT ) VALUES ( 
'admin', '48A8F061FA4B86E2BEA4F082EC630D0D', 'admin', '01', 'admin', 'asdf', NULL
, NULL, NULL, NULL, NULL, NULL); 
commit;

INSERT INTO QX_GROUP ( ID, NAME, DESCRIBE ) VALUES ( 
'1', '超级用户', '超级用户'); 
INSERT INTO QX_GROUP ( ID, NAME, DESCRIBE ) VALUES ( 
'2', '一般公务员', NULL); 
INSERT INTO QX_GROUP ( ID, NAME, DESCRIBE ) VALUES ( 
'00346', 'aaa', 'aaa'); 
commit;
 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100005'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100006'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100007'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100008'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100009'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100010'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100011'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100012'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100013'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200005'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200006'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200007'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0200008'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0300001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0300002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0300003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0300004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0400001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0400002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0400003');