modify_ins_dm.sql

公务员管理系统

Rem  /********************************************************************
Rem  * $Header:CRE_dm.Sql                                               *
Rem  *      PROGRAM (P) 2004 by Tianjin Vst Software Corporation         *
Rem  * 描  述: 修改代码表                            		 *
Rem  * 程序员: 鲁晓东                                                      *
Rem  * 日  期: 2004年05月11日                                            *
Rem  * 项  目: 北京市劳动公务                                            *
Rem  *                                                                   *
Rem  ********************************************************************/

Rem /*30*/
update dm_mx set mc='门头沟区潭柘寺镇' where dmm='0002' and dm='109376';

commit
/


Rem /*7*/
delete from dm_mx where dmm='1004' and dm not in(select dm from dm_mx where dmm='1004' and dm like '%00%');
commit
/
update dw_xx set sshy=substr(sshy,1,1)||'00';
commit
/

---添加一个新的代码类行和相应的代码
Rem /*14*/
update dm_mx set mc='其他用人单位' where dmm='1001' and dm='03';
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1008','税务登记证号变更单位类型');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1008','001','分支机构'); 
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1008','002','事业单位'); 
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1008','003','其他'); 
commit
/

rem   /*28*/
INSERT INTO DM_MX(DMM,DM,MC) VALUES('5005','001','硕士及以上');
update dm_mx set mc='大学' where dmm='5005' and dm='01';
update dm_mx set mc='大专' where dmm='5005' and dm='02';
update dm_mx set mc='高中及以下' where dmm='5005' and dm='03';
commit
/

rem  /*9*/
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1010','货币类型');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1010','01','人民币');   
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1010','02','美元');   
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1010','03','欧元');   
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1010','04','港币');   
commit
/

rem /*12*/
delete dm_mx where dmm='1005';
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','01','机关');   
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','02','事业单位');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','03','社会团体');   
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','04','企业');      
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','05','其他');   
commit
/

rem /*14*/
update dw_xx set swdjh='';
commit
/

rem/*book*/
delete from qx_tree_inf where iid not in(select iid from qx_tree_inf where iid like '%B05%');
delete from qx_group_list where iid not in(select iid from qx_group_list where iid like '%B05%');
delete from qx_information where id not in(select id from qx_information where id like '%B05%');