init_data.sql

公务员管理系统

delete from aj_lckz;
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B02','LR','案件登记','B','B01');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('B08','B03','','PD','判断违法','B','B02');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B04','LR','立案审批','B','B03');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B05','LR','文书制作','B','B04');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B06','LR','结案报告','B','B05');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B07','LR','公务效果','B','B06');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','','BJ','生成案卷','B','B07');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','B07','LR','处理办结','B','B08');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','J02','LR','案件登记','J','J01');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','J03','LR','文书制作','J','J02');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','J04','LR','公务效果','J','J03');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','','BJ','生成案卷','J','J04');
insert into aj_lckz(JUDGE_N_LCID,JUDGE_Y_LCID,NEXT_LCID,LCLX,LCNAME,BLFS,LCID) values('','','','','','','0');
commit;
delete from aj_lcwd;
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('001','N','Y','AJ_DJB','案件登记表','B01,J01','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('002','N','N','AJ_JBXX','举报信息','B01','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('003','N','Y','AJ_LASP','立案审批','B03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('004','N','Y','AJ_XZCL','行政处理决定书','B04,J02','XZCL');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('005','N','Y','AJ_ZLGZ','责令改正通知书','B04,J02','ZLGZ');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('006','N','Y','AJ_XZCF','行政处罚决定书','B04,J02','XZCF');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('007','N','Y','AJ_QZZX','强制执行申请书','B04,J02','QZZX');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('008','N','Y','AJ_JABG','结案报告','B05','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('009','N','Y','AJ_JCXG','公务效果','B06,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('010','N','Y','AJ_SFWF','判断违法','B02','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('011','Y','N','AJ_CBDCBL','初步调查笔录','B01,B02,B03,B04,B05,B06,B08,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('012','Y','N','AJ_ZJ','证据录入','B01,B02,B03,B04,B05,B06,B08,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('013','Y','N','AJ_WPZK','物品暂扣','B01,B02,B03,B04,B05,B06,B08,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('014','Y','N','AJ_TZTZ','听证通知书','B01,B02,B03,B04,B05,B06,B08,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('015','Y','N','AJ_QTWS','其他文书','B01,B02,B03,B04,B05,B06,B08,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('016','Y','N','AJ_CLCP','处理呈批','B01,B02,B03,B04,B05','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('017','Y','N','AJ_DCBL','调查笔录','B03,B04,B05,B06,J01,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('018','Y','N','AJ_SDHZ','送达回证','B04,B05,B06,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('019','Y','N','AJ_DCBG','调查报告','B04,B05,B06,J02,J03','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('020','N','Y','AJ_BJD','办结单','B08','');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('021','N','N','AJ_XZCL','行政处理决定书','B05,J03','XZCL');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('022','N','N','AJ_ZLGZ','责令改正通知书','B05,J03','ZLGZ');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('023','N','N','AJ_XZCF','行政处罚决定书','B05,J03','XZCF');
insert into AJ_LCWD(WDID,JUDGE_MUCH,JUDGE_MAINLC,WDTABLE,WDNAME,LCID,MBID) values('024','N','N','AJ_QZZX','强制执行申请书','B05,J03','QZZX');
commit;
delete from aj_wdmb;
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL','XZCL_HT','行政处理决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ','ZLGZ_HT','责令改正通知书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF','XZCF_FK','行政处罚决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX','QZZX_HT','强制执行申请书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF','XZCF_JG','行政处罚决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF','XZCF_MS','行政处罚决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF','XZCF_ZK','行政处罚决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCLF','XZCF_QT','行政处罚决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_HT','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_TG','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_WL','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_SB','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_GZ','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK','XZCF_FK_QT','罚款','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_HT',' ','合同','aj_xzcf_ht_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_TG',' ','童工','aj_xzcf_sytg_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_WL',' ','擅自试用外来劳动力','aj_xzcf_wlyg_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_SB',' ','社会保险','aj_xzcf_shbx_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_GZ',' ','工资','aj_xzcf_gz_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_FK_QT',' ','其他','aj_xzcf_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_JG',' ','警告','aj_xzcf_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_MS',' ','没收非法财务','aj_xzcf_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_ZK',' ','暂扣或吊销许可证','aj_xzcf_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF_QT',' ','其他行政处罚','aj_xzcf_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ','ZLGZ_SX','责令改正通知书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ','ZLGZ_GZ','责令改正通知书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ','ZLGZ_QT','责令改正通知书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ_HT',' ','合同','aj_zlgz_ht_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ_SX',' ','社会保险','aj_zlgz_shbx_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ_GZ',' ','工资','aj_zlgz_gz_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('ZLGZ_QT',' ','其他','aj_zlgz_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL','XZCL_SX','行政处理决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL','XZCL_GZ','行政处理决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL','XZCL_QT','行政处理决定书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL_HT',' ','合同','aj_xzcl_ht_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL_SX',' ','社会保险','aj_xzcl_shbx_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL_GZ',' ','工资','aj_xzcl_gz_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCL_QT',' ','其他','aj_xzcl_qt_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX','QZZX_SX','强制执行申请书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX','QZZX_GZ','强制执行申请书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX','QZZX_YG','强制执行申请书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX','QZZX_QT','强制执行申请书','');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX_HT',' ','合同','aj_qzzx_ht_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX_SX',' ','社会保险','aj_qzzx_shbx_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX_GZ',' ','工资','aj_qzzx_gz_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX_YG',' ','用工','aj_qzzx_yg_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('QZZX_QT',' ','其他','aj_qzzx_ht_tj.jsp');
insert into aj_wdmb(MBID,ZMBID,MBMC,MBCX) values('XZCF','XZCF_QT','行政处罚决定书','');
commit;
delete from qx_information
/

insert into qx_information(ID,NAME,DESCRIBE) values('B0500001','公务员新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500002','公务员减少','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500003','公务员减少恢复','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500004','公务员审批','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500005','公务员口令修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500006','公务员权限管理','');
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','个体单位信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100002','法人单位信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100003','非法人分支单位信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100004','单位信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100005','单位信息转移','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100006','单位信息减少','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100007','单位信息减少恢复','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100008','个体单位信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100009','法人单位信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100010','非法人分支单位信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100011','个体单位信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100012','法人单位信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100013','非法人分支单位信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200001','年检信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200002','执法检查信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200003','年检信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200004','执法检查信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200005','年检信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200006','执法检查信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200007','年检信息删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0200008','执法检查信息删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0900001','法规信息录入','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0900002','法规信息查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0900003','法规信息修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0900004','法规信息删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0700001','新增企业不良信息','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0700002','上报企业不良信息','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0700003','报送企业不良信息','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500007','公务单位条件查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500008','公务员口令维护','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500009','公务员查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500010','公务员修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500011','公务单位修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500012','公务单位新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500013','公务单位删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0700004','查看企业不良信息','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500018','公务单位恢复','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500019','公务单位奖惩查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500020','公务单位奖惩新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500021','公务单位奖惩修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500022','公务单位奖惩删除','');