<#if versionDate?date("yyyyMMdd") lte "20141126"?date("yyyyMMdd") > -- 1.8.1 版本脚本（已整改） -- and by yuanxd gis map alter table T_YJPT_JYRXX_BW add smid VARCHAR2(32 BYTE); comment on column T_YJPT_JYRXX_BW.smid is '地图ID'; <#if szdName == "镇江" || szdName == "省级"> -- 镇江泊位 update t_yjpt_jyrxx_bw set smid='795' where id=21; update t_yjpt_jyrxx_bw set smid='794' where id=22; update t_yjpt_jyrxx_bw set smid='158' where id=23; update t_yjpt_jyrxx_bw set smid='796' where id=24; update t_yjpt_jyrxx_bw set smid='797' where id=25; update t_yjpt_jyrxx_bw set smid='798' where id=26; update t_yjpt_jyrxx_bw set smid='362' where id=27; update t_yjpt_jyrxx_bw set smid='358' where id=28; update t_yjpt_jyrxx_bw set smid='359' where id=32; update t_yjpt_jyrxx_bw set smid='154' where id=33; update t_yjpt_jyrxx_bw set smid='151' where id=39; update t_yjpt_jyrxx_bw set smid='792' where id=40; update t_yjpt_jyrxx_bw set smid='799' where id=41; update t_yjpt_jyrxx_bw set smid='330' where id=42; update t_yjpt_jyrxx_bw set smid='328' where id=43; update t_yjpt_jyrxx_bw set smid='329' where id=44; update t_yjpt_jyrxx_bw set smid='791' where id=45; update t_yjpt_jyrxx_bw set smid='159' where id=46; update t_yjpt_jyrxx_bw set smid='793' where id=47; update t_yjpt_jyrxx_bw set smid='150' where id=48; update t_yjpt_jyrxx_bw set smid='365' where id=66; <#if szdName == "南京" || szdName == "省级"> -- 南京泊位 update t_yjpt_jyrxx_bw set smid='113' where id=3000000003; update t_yjpt_jyrxx_bw set smid='114' where id=3000000001; update t_yjpt_jyrxx_bw set smid='187' where id=3000000002; update t_yjpt_jyrxx_bw set smid='108' where id=3000000004; update t_yjpt_jyrxx_bw set smid='109' where id=3000000005; update t_yjpt_jyrxx_bw set smid='110' where id=3000000006; update t_yjpt_jyrxx_bw set smid='1922' where id=3000000007; <#if szdName == "南通" || szdName == "省级"> -- 南通泊位 -- 南通港口集团有限公司江海港务分公司 update t_yjpt_jyrxx_bw set smid='632' where id=7000000035; update t_yjpt_jyrxx_bw set smid='631' where id=7000000038; update t_yjpt_jyrxx_bw set smid='633' where id=7000000036; update t_yjpt_jyrxx_bw set smid='643' where id=7000000037; -- 南通港口集团有限公司狼山港务分公司 update t_yjpt_jyrxx_bw set smid='647' where id=7000000037; -- 南通港口集团有限公司集装箱分公司 update t_yjpt_jyrxx_bw set smid='652' where id=7000000007; update t_yjpt_jyrxx_bw set smid='828' where id=7000000008; update t_yjpt_jyrxx_bw set smid='651' where id=7000000009; -- 南通东方石油化工港储有限公司 update t_yjpt_jyrxx_bw set smid='788' where id=7000000021; update t_yjpt_jyrxx_bw set smid='628' where id=7000000022; -- 中国石油化工股份有限公司江苏南通石油分公司 TODO update t_yjpt_jyrxx_bw set smid='630' where id=7000000023; -- 中国华粮物流集团南通粮油接运有限责任公司 update t_yjpt_jyrxx_bw set smid='785' where id=7000000016; update t_yjpt_jyrxx_bw set smid='784' where id=7000000015; -- 南通江山农药化工股份有限公司 update t_yjpt_jyrxx_bw set smid='664' where id=7000000018; -- 南通诚晖石油化工有限公司 update t_yjpt_jyrxx_bw set smid='626' where id=7000000029; -- 南通阳鸿石化储运有限公司 update t_yjpt_jyrxx_bw set smid='789' where id=7000000006; --szd px by liangzan update T_YJPT_GGDM t set t.px=320601 where t.id=90015; update T_YJPT_GGDM t set t.px=320701 where t.id=90026; update T_YJPT_GGDM t set t.px=320901 where t.id=90019; update T_YJPT_GGDM t set t.px=321101 where t.id=90024; ALTER TABLE T_YJPT_ZCYH MODIFY XMMC VARCHAR2(100); <#if versionDate?date("yyyyMMdd") lte "20141128"?date("yyyyMMdd") > -- 1.8.3 版本脚本 <#if szdName == "镇江内河" || szdName == "省级"> --14.12.2 -- 镇江内河所在地 INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1, BYZD2) VALUES ('9002401', '90024', 'SZD', '321003', '321110', 'SZD.ZHENJIANGNEIHELOCAL', '1', '镇江内河本部', '0', 'ZJNH_0', '90024'); INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1, BYZD2) VALUES ('9002402', '90024', 'SZD', '321003', '321120', 'SZD.DANYANG', '1', '丹阳市', '0', 'DYS', '9002402'); INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1, BYZD2) VALUES ('9002403', '90024', 'SZD', '321003', '321130', 'SZD.DANTU', '1', '丹徒区', '0', 'DTQ', '9002403'); INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1, BYZD2) VALUES ('9002404', '90024', 'SZD', '321003', '321140', 'SZD.JURONG', '1', '句容市', '0', 'JRS', '9002404'); INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1, BYZD2) VALUES ('9002405', '90024', 'SZD', '321003', '321150', 'SZD.JINGKOU', '1', '京口区', '0', 'JKQ', '9002405'); -- 镇江内河港区 INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('13000000001', '9002402', '丹阳港区', '2201'); INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('13000000002', '9002404', '句容港区', '2201'); INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('13000000003', '9002403', '城郊港区', '2201'); INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('13000000004', '9002405', '京口港区', '2201'); <#if versionDate?date("yyyyMMdd") lt "20141205"?date("yyyyMMdd") > -- 1.8.4 版本脚本 UPDATE T_YJPT_GGDM SET CODE='bf'，MC='yjwl.type.bf' WHERE ID =1010005 ; <#if versionDate?date("yyyyMMdd") lt "20141210"?date("yyyyMMdd") > -- 1.8.6 版本脚本 --2014.12.02 by liangzan -- Add/modify columns alter table T_YJPT_WXHWGKZYSBD add hzwxx number; alter table T_YJPT_WXHWGKZYSBD add dxdj number; alter table T_YJPT_WXHWGKZYSBD add wrlb number; alter table T_YJPT_WXHWGKZYSBD add mao varchar2(10); -- Add comments to the columns comment on column T_YJPT_WXHWGKZYSBD.hzwxx is '火灾危险性'; comment on column T_YJPT_WXHWGKZYSBD.dxdj is '毒性等级'; comment on column T_YJPT_WXHWGKZYSBD.wrlb is '污染类别'; comment on column T_YJPT_WXHWGKZYSBD.mao is '内贸外贸'; -- Add/modify columns alter table T_YJPT_WXHWPMB add hzwxx NUMBER; alter table T_YJPT_WXHWPMB add dxdj NUMBER; alter table T_YJPT_WXHWPMB add wrlb NUMBER; -- Add comments to the columns comment on column T_YJPT_WXHWPMB.hzwxx is '火灾危险性'; comment on column T_YJPT_WXHWPMB.dxdj is '毒性等级'; comment on column T_YJPT_WXHWPMB.wrlb is '污染类别'; --2014.12.03 by liangzan insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20000, null, 'DXDJ', 'DXDJ', 1, 'DXDJ1', null, null, null, null, 1, null, null, null, null, null, '一般有毒', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20001, null, 'DXDJ', 'DXDJ', 2, 'DXDJ2', null, null, null, null, 1, null, null, null, null, null, '高毒', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20002, null, 'WRLB', 'WRLB', 1, 'WRLB1', null, null, null, null, 1, null, null, null, null, null, 'Z', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20003, null, 'WRLB', 'WRLB', 2, 'WRLB2', null, null, null, null, 1, null, null, null, null, null, 'Y', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20004, null, 'WRLB', 'WRLB', 3, 'WRLB3', null, null, null, null, 1, null, null, null, null, null, 'Y/17', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20005, null, 'WRLB', 'WRLB', 4, 'WRLB4', null, null, null, null, 1, null, null, null, null, null, 'Z/17', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20006, null, 'WRLB', 'WRLB', 5, 'WRLB5', null, null, null, null, 1, null, null, null, null, null, 'Z/18', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20007, null, 'WRLB', 'WRLB', 6, 'WRLB6', null, null, null, null, 1, null, null, null, null, null, 'X', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20008, null, 'WRLB', 'WRLB', 7, 'WRLB7', null, null, null, null, 1, null, null, null, null, null, 'OS', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20009, null, 'HZWXX', 'HZWXX', 1, 'HZWXX1', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20010, null, 'HZWXX', 'HZWXX', 2, 'HZWXX2', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20011, null, 'HZWXX', 'HZWXX', 3, 'HZWXX3', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20012, null, 'HZWXX', 'HZWXX', 4, 'HZWXX4', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (20013, null, 'HZWXX', 'HZWXX', 5, 'HZWXX5', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null); --所在地(2014.12.18) DELETE FROM T_YJPT_GGDM WHERE GROUPCODE = 'SZD'; Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (900,null,'SZD','320000',32000000,'SZD.JIANGSU',1,'江苏省','0','JS','900','JS000000','江苏省交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90014,900,'SZD','320100',32010000,'SZD.NANJING',1,'南京','0','NJ','90014','JS010000','南京市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90016,900,'SZD','320200',32020000,'SZD.WUXI',1,'无锡','0','WX','90016','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001601,90016,'SZD','320201',32020100,'SZD.WUXILOCAL',1,'无锡本部','0','WX_0','90016','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001604,90016,'SZD','320205',32020500,'SZD.XISHAN',1,'锡山市','0','XSS','9001604','JS020500','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001603,90016,'SZD','320206',32020600,'SZD.HUISHAN',1,'惠山区','0','HSQ','9001603','JS020600','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001605,90016,'SZD','320211',32021100,'SZD.WUXIXINQU',1,'无锡新区','0','WXXQ','9001605','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001602,90016,'SZD','320281',32028100,'SZD.JIANGYIN',1,'江阴市','0','JYS','9001602','JS028100','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001606,90016,'SZD','320282',32028200,'SZD.YIXING',1,'宜兴市','0','YXS','9001606','JS028200','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90020,900,'SZD','320300',32030000,'SZD.XUZHOU',1,'徐州','0','XZ','90020','JS030000','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002008,90020,'SZD','320301',32030100,'SZD.XUZHOULOCAL',1,'徐州本部','0','XZ_0','90020','JS030000','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002007,90020,'SZD','320305',32030500,'SZD.JIAWANGQU',1,'贾汪区','0','JWQ','9002007','JS030500','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002001,90020,'SZD','320312',32031200,'SZD.TONGSHANXIAN',1,'铜山县','0','TSX','9002001','JS031200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002002,90020,'SZD','320321',32032100,'SZD.FENGXIAN',1,'丰县','0','FX','9002002','JS032100','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002003,90020,'SZD','320322',32032200,'SZD.PEIXIAN',1,'沛县','0','PX','9002003','JS032200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002006,90020,'SZD','320324',32032400,'SZD.SUINING',1,'睢宁','0','SN','9002006','JS032400','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002005,90020,'SZD','320381',32038100,'SZD.XINYI',1,'新沂','0','XY','9002005','JS038100','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002004,90020,'SZD','320382',32038200,'SZD.PIZHOU',1,'邳州','0','PZ','9002004','JS038200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90021,900,'SZD','320400',32040000,'SZD.CHANGZHOU',1,'常州','0','CZ','90021','JS040000','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002101,90021,'SZD','320401',32040100,'SZD.CHANGZHOULOCAL',1,'常州本部','0','CZ_0','90021','JS040000','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002102,90021,'SZD','320412',32041200,'SZD.WUJIN',1,'武进','0','WJ','9002102','JS041200','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002104,90021,'SZD','320481',32048100,'SZD.LIYANG',1,'溧阳','0','LY','9002104','JS048100','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002103,90021,'SZD','320482',32048200,'SZD.JINTAN',1,'金坛','0','JT','9002103','JS048200','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90012,900,'SZD','320500',32050000,'SZD.SUZHOU',1,'苏州','0','SZ','90012','JS050000','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001204,90012,'SZD','320501',32050100,'SZD.SUZHOULOCAL',1,'苏州本部','0','SZ_0','90012','JS050000','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001203,90012,'SZD','320581',32058100,'SZD.CHANGSHU',1,'常熟','0','CS','9001203','JS058100','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001201,90012,'SZD','320582',32058200,'SZD.ZHANGJIAGANG',1,'张家港','0','ZJG','9001201','JS058200','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001202,90012,'SZD','320585',32058500,'SZD.TAICANG',1,'太仓','0','TC','9001202','JS058500','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90015,900,'SZD','320600',32060000,'SZD.NANTONG',1,'南通','0','NT','90015','JS060000','南通市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90025,900,'SZD','320600',32060099,'SZD.NANTONGNEIHE',1,'南通内河','0','NTNH','90025','JS060099','南通市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90013,900,'SZD','320700',32070000,'SZD.LIANYUNGANG',1,'连云港','0','LYG','90013','JS070000','连云港市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90026,900,'SZD','320700',32070099,'SZD.LIANYUNGANGNEIHE',1,'连云港内河','0','LYGNH','90026','JS070099','连云港市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90023,900,'SZD','320800',32080000,'SZD.HUAIAN',1,'淮安','0','HA','90023','JS080000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002307,90023,'SZD','320801',32080100,'SZD.HUAIANLOCAL',1,'淮安本部','0','HA_0','90023','JS080000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002303,90023,'SZD','320803',32080300,'SZD.HUAIANQU',1,'淮安区','0','HAQ','9002303','JS080300','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002302,90023,'SZD','320804',32080400,'SZD.HUAIYIN',1,'淮阴县','0','HYX','9002302','JS080400','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002301,90023,'SZD','320826',32082600,'SZD.LIANSHUI',1,'涟水县','0','LSX','9002301','JS082600','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002304,90023,'SZD','320829',32082900,'SZD.HONGZE',1,'洪泽县','0','HZX','9002304','JS082900','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002305,90023,'SZD','320830',32083000,'SZD.XUYU',1,'盱眙县','0','XYX','9002305','JS083000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002306,90023,'SZD','320831',32083100,'SZD.JINHU',1,'金湖县','0','JHX','9002306','JS083100','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90019,900,'SZD','320900',32090000,'SZD.YANCHENG',1,'盐城','0','YC','90019','JS090000','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90027,900,'SZD','320900',32090099,'SZD.YANCHENGNEIHE',1,'盐城内河','0','YCNH','90027','JS090099','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001901,90019,'SZD','320901',32090100,'SZD.YANCHENGLOCAL',1,'盐城本部','0','YC_0','90019','JS090000','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001905,90019,'SZD','320921',32092100,'SZD.XIANGSHUI',1,'响水县','0','XSX','9001905','JS092100','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001904,90019,'SZD','320922',32092200,'SZD.BINHAI',1,'滨海县','0','BHX','9001904','JS092200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001903,90019,'SZD','320924',32092400,'SZD.SHEYANG',1,'射阳县','0','SYX','9001903','JS092400','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001902,90019,'SZD','320982',32098200,'SZD.DAFENG',1,'大丰市','0','DFS','9001902','JS098200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90017,900,'SZD','321000',32100000,'SZD.YANGZHOU',1,'扬州','0','YZ','90017','JS100000','扬州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90011,900,'SZD','321100',32110000,'SZD.ZHENJIANG',1,'镇江','0','ZJ','90011','JS110000','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90024,900,'SZD','321100',32110099,'SZD.ZHENJIANGNEIHE',1,'镇江内河','0','ZJNH','90024','JS110099','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002401,90024,'SZD','321100',32110099,'SZD.ZHENJIANGNEIHELOCAL',1,'镇江内河本部','0','ZJNH_0','90024','JS110099','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002405,90024,'SZD','321102',32110200,'SZD.JINGKOU',1,'京口区','0','JKQ','9002405','JS110200','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002403,90024,'SZD','321112',32111200,'SZD.DANTU',1,'丹徒区','0','DTQ','9002403','JS111200','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002402,90024,'SZD','321181',32118100,'SZD.DANYANG',1,'丹阳市','0','DYS','9002402','JS118100','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002404,90024,'SZD','321183',32118300,'SZD.JURONG',1,'句容市','0','JRS','9002404','JS118300','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90018,900,'SZD','321200',32120000,'SZD.TAIZHOU',1,'泰州','0','TZ','90018','JS120000','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90022,900,'SZD','321300',32130000,'SZD.XUQIAN',1,'宿迁','0','SQ','90022','JS130000','宿迁市交通运输局港口处'); <#if versionDate?date("yyyyMMdd") lt "20141225"?date("yyyyMMdd") > -- 1.9.0 版本脚本 --2015年休假(2014.12.17) Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150101','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150102','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150104','Y'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150215','Y'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150218','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150219','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150220','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150223','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150224','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150228','Y'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150406','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150501','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20150622','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151001','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151002','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151005','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151006','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151007','N'); Insert into T_YJPT_WORKING_CALENDAR (WORKING_DATE,IS_WORKING) values ('20151010','Y'); --所在地(2014.12.18) DELETE FROM T_YJPT_GGDM WHERE GROUPCODE = 'SZD'; Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (900,null,'SZD','320000',32000000,'SZD.JIANGSU',1,'江苏省','0','JS','900','JS000000','江苏省交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90014,900,'SZD','320100',32010000,'SZD.NANJING',1,'南京','0','NJ','90014','JS010000','南京市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90016,900,'SZD','320200',32020000,'SZD.WUXI',1,'无锡','0','WX','90016','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001601,90016,'SZD','320201',32020100,'SZD.WUXILOCAL',1,'无锡本部','0','WX_0','90016','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001604,90016,'SZD','320205',32020500,'SZD.XISHAN',1,'锡山市','0','XSS','9001604','JS020500','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001603,90016,'SZD','320206',32020600,'SZD.HUISHAN',1,'惠山区','0','HSQ','9001603','JS020600','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001605,90016,'SZD','320211',32021100,'SZD.WUXIXINQU',1,'无锡新区','0','WXXQ','9001605','JS020000','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001602,90016,'SZD','320281',32028100,'SZD.JIANGYIN',1,'江阴市','0','JYS','9001602','JS028100','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001606,90016,'SZD','320282',32028200,'SZD.YIXING',1,'宜兴市','0','YXS','9001606','JS028200','无锡市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90020,900,'SZD','320300',32030000,'SZD.XUZHOU',1,'徐州','0','XZ','90020','JS030000','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002008,90020,'SZD','320301',32030100,'SZD.XUZHOULOCAL',1,'徐州本部','0','XZ_0','90020','JS030000','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002007,90020,'SZD','320305',32030500,'SZD.JIAWANGQU',1,'贾汪区','0','JWQ','9002007','JS030500','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002001,90020,'SZD','320312',32031200,'SZD.TONGSHANXIAN',1,'铜山县','0','TSX','9002001','JS031200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002002,90020,'SZD','320321',32032100,'SZD.FENGXIAN',1,'丰县','0','FX','9002002','JS032100','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002003,90020,'SZD','320322',32032200,'SZD.PEIXIAN',1,'沛县','0','PX','9002003','JS032200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002006,90020,'SZD','320324',32032400,'SZD.SUINING',1,'睢宁','0','SN','9002006','JS032400','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002005,90020,'SZD','320381',32038100,'SZD.XINYI',1,'新沂','0','XY','9002005','JS038100','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002004,90020,'SZD','320382',32038200,'SZD.PIZHOU',1,'邳州','0','PZ','9002004','JS038200','徐州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90021,900,'SZD','320400',32040000,'SZD.CHANGZHOU',1,'常州','0','CZ','90021','JS040000','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002101,90021,'SZD','320401',32040100,'SZD.CHANGZHOULOCAL',1,'常州本部','0','CZ_0','90021','JS040000','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002102,90021,'SZD','320412',32041200,'SZD.WUJIN',1,'武进','0','WJ','9002102','JS041200','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002104,90021,'SZD','320481',32048100,'SZD.LIYANG',1,'溧阳','0','LY','9002104','JS048100','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002103,90021,'SZD','320482',32048200,'SZD.JINTAN',1,'金坛','0','JT','9002103','JS048200','常州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90012,900,'SZD','320500',32050000,'SZD.SUZHOU',1,'苏州','0','SZ','90012','JS050000','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001204,90012,'SZD','320501',32050100,'SZD.SUZHOULOCAL',1,'苏州本部','0','SZ_0','90012','JS050000','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001203,90012,'SZD','320581',32058100,'SZD.CHANGSHU',1,'常熟','0','CS','9001203','JS058100','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001201,90012,'SZD','320582',32058200,'SZD.ZHANGJIAGANG',1,'张家港','0','ZJG','9001201','JS058200','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001202,90012,'SZD','320585',32058500,'SZD.TAICANG',1,'太仓','0','TC','9001202','JS058500','苏州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90015,900,'SZD','320600',32060000,'SZD.NANTONG',1,'南通','0','NT','90015','JS060000','南通市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90025,900,'SZD','320600',32060099,'SZD.NANTONGNEIHE',1,'南通内河','0','NTNH','90025','JS060099','南通市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90013,900,'SZD','320700',32070000,'SZD.LIANYUNGANG',1,'连云港','0','LYG','90013','JS070000','连云港市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90026,900,'SZD','320700',32070099,'SZD.LIANYUNGANGNEIHE',1,'连云港内河','0','LYGNH','90026','JS070099','连云港市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90023,900,'SZD','320800',32080000,'SZD.HUAIAN',1,'淮安','0','HA','90023','JS080000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002307,90023,'SZD','320801',32080100,'SZD.HUAIANLOCAL',1,'淮安本部','0','HA_0','90023','JS080000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002303,90023,'SZD','320803',32080300,'SZD.HUAIANQU',1,'淮安区','0','HAQ','9002303','JS080300','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002302,90023,'SZD','320804',32080400,'SZD.HUAIYIN',1,'淮阴县','0','HYX','9002302','JS080400','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002301,90023,'SZD','320826',32082600,'SZD.LIANSHUI',1,'涟水县','0','LSX','9002301','JS082600','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002304,90023,'SZD','320829',32082900,'SZD.HONGZE',1,'洪泽县','0','HZX','9002304','JS082900','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002305,90023,'SZD','320830',32083000,'SZD.XUYU',1,'盱眙县','0','XYX','9002305','JS083000','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002306,90023,'SZD','320831',32083100,'SZD.JINHU',1,'金湖县','0','JHX','9002306','JS083100','淮安市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90019,900,'SZD','320900',32090000,'SZD.YANCHENG',1,'盐城','0','YC','90019','JS090000','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90027,900,'SZD','320900',32090099,'SZD.YANCHENGNEIHE',1,'盐城内河','0','YCNH','90027','JS090099','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001901,90019,'SZD','320901',32090100,'SZD.YANCHENGLOCAL',1,'盐城本部','0','YC_0','90019','JS090000','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001905,90019,'SZD','320921',32092100,'SZD.XIANGSHUI',1,'响水县','0','XSX','9001905','JS092100','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001904,90019,'SZD','320922',32092200,'SZD.BINHAI',1,'滨海县','0','BHX','9001904','JS092200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001903,90019,'SZD','320924',32092400,'SZD.SHEYANG',1,'射阳县','0','SYX','9001903','JS092400','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001902,90019,'SZD','320982',32098200,'SZD.DAFENG',1,'大丰市','0','DFS','9001902','JS098200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90017,900,'SZD','321000',32100000,'SZD.YANGZHOU',1,'扬州','0','YZ','90017','JS100000','扬州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90011,900,'SZD','321100',32110000,'SZD.ZHENJIANG',1,'镇江','0','ZJ','90011','JS110000','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90024,900,'SZD','321100',32110099,'SZD.ZHENJIANGNEIHE',1,'镇江内河','0','ZJNH','90024','JS110099','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002401,90024,'SZD','321100',32110099,'SZD.ZHENJIANGNEIHELOCAL',1,'镇江内河本部','0','ZJNH_0','90024','JS110099','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002405,90024,'SZD','321102',32110200,'SZD.JINGKOU',1,'京口区','0','JKQ','9002405','JS110200','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002403,90024,'SZD','321112',32111200,'SZD.DANTU',1,'丹徒区','0','DTQ','9002403','JS111200','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002402,90024,'SZD','321181',32118100,'SZD.DANYANG',1,'丹阳市','0','DYS','9002402','JS118100','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002404,90024,'SZD','321183',32118300,'SZD.JURONG',1,'句容市','0','JRS','9002404','JS118300','镇江市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90018,900,'SZD','321200',32120000,'SZD.TAIZHOU',1,'泰州','0','TZ','90018','JS120000','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (90022,900,'SZD','321300',32130000,'SZD.XUQIAN',1,'宿迁','0','SQ','90022','JS130000','宿迁市交通运输局港口处'); --行政区划(2014.12.18) DELETE FROM T_YJPT_GGDM WHERE GROUPCODE='XZQH'; Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320000,null,'XZQH','320000',320000,'江苏省',1,'江苏省','0','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320100,320000,'XZQH','320100',320100,'南京市',1,'南京市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320102,320100,'XZQH','320102',320102,'玄武区',1,'玄武区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320104,320100,'XZQH','320104',320104,'秦淮区',1,'秦淮区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320105,320100,'XZQH','320105',320105,'建邺区',1,'建邺区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320106,320100,'XZQH','320106',320106,'鼓楼区',1,'鼓楼区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320111,320100,'XZQH','320111',320111,'浦口区',1,'浦口区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320113,320100,'XZQH','320113',320113,'栖霞区',1,'栖霞区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320114,320100,'XZQH','320114',320114,'雨花台区',1,'雨花台区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320115,320100,'XZQH','320115',320115,'江宁区',1,'江宁区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320116,320100,'XZQH','320116',320116,'六合区',1,'六合区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320117,320100,'XZQH','320117',320117,'溧水区',1,'溧水区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320118,320100,'XZQH','320118',320118,'高淳区',1,'高淳区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320200,320000,'XZQH','320200',320200,'无锡市',1,'无锡市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320202,320200,'XZQH','320202',320202,'崇安区',1,'崇安区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320203,320200,'XZQH','320203',320203,'南长区',1,'南长区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320204,320200,'XZQH','320204',320204,'北塘区',1,'北塘区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320205,320200,'XZQH','320205',320205,'锡山区',1,'锡山区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320206,320200,'XZQH','320206',320206,'惠山区',1,'惠山区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320211,320200,'XZQH','320211',320211,'滨湖区',1,'滨湖区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320281,320200,'XZQH','320281',320281,'江阴市',1,'江阴市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320282,320200,'XZQH','320282',320282,'宜兴市',1,'宜兴市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320300,320000,'XZQH','320300',320300,'徐州市',1,'徐州市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320302,320300,'XZQH','320302',320302,'鼓楼区',1,'鼓楼区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320303,320300,'XZQH','320303',320303,'云龙区',1,'云龙区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320305,320300,'XZQH','320305',320305,'贾汪区',1,'贾汪区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320311,320300,'XZQH','320311',320311,'泉山区',1,'泉山区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320312,320300,'XZQH','320312',320312,'铜山区',1,'铜山区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320321,320300,'XZQH','320321',320321,'丰县',1,'丰县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320322,320300,'XZQH','320322',320322,'沛县',1,'沛县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320324,320300,'XZQH','320324',320324,'睢宁县',1,'睢宁县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320381,320300,'XZQH','320381',320381,'新沂市',1,'新沂市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320382,320300,'XZQH','320382',320382,'邳州市',1,'邳州市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320400,320000,'XZQH','320400',320400,'常州市',1,'常州市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320404,320400,'XZQH','320404',320404,'钟楼区',1,'钟楼区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320405,320400,'XZQH','320405',320405,'戚墅堰区',1,'戚墅堰区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320411,320400,'XZQH','320411',320411,'新北区',1,'新北区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320412,320400,'XZQH','320412',320412,'武进区',1,'武进区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320481,320400,'XZQH','320481',320481,'溧阳市',1,'溧阳市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320482,320400,'XZQH','320482',320482,'金坛市',1,'金坛市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320500,320000,'XZQH','320500',320500,'苏州市',1,'苏州市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320505,320500,'XZQH','320505',320505,'虎丘区',1,'虎丘区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320506,320500,'XZQH','320506',320506,'吴中区',1,'吴中区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320507,320500,'XZQH','320507',320507,'相城区',1,'相城区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320508,320500,'XZQH','320508',320508,'姑苏区',1,'姑苏区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320509,320500,'XZQH','320509',320509,'吴江区',1,'吴江区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320581,320500,'XZQH','320581',320581,'常熟市',1,'常熟市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320582,320500,'XZQH','320582',320582,'张家港市',1,'张家港市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320583,320500,'XZQH','320583',320583,'昆山市',1,'昆山市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320585,320500,'XZQH','320585',320585,'太仓市',1,'太仓市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320600,320000,'XZQH','320600',320600,'南通市',1,'南通市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320602,320600,'XZQH','320602',320602,'崇川区',1,'崇川区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320611,320600,'XZQH','320611',320611,'港闸区',1,'港闸区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320612,320600,'XZQH','320612',320612,'通州区',1,'通州区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320621,320600,'XZQH','320621',320621,'海安县',1,'海安县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320623,320600,'XZQH','320623',320623,'如东县',1,'如东县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320681,320600,'XZQH','320681',320681,'启东市',1,'启东市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320682,320600,'XZQH','320682',320682,'如皋市',1,'如皋市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320684,320600,'XZQH','320684',320684,'海门市',1,'海门市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320700,320000,'XZQH','320700',320700,'连云港市',1,'连云港市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320703,320700,'XZQH','320703',320703,'连云区',1,'连云区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320705,320700,'XZQH','320705',320705,'新浦区',1,'新浦区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320706,320700,'XZQH','320706',320706,'海州区',1,'海州区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320721,320700,'XZQH','320721',320721,'赣榆县',1,'赣榆县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320722,320700,'XZQH','320722',320722,'东海县',1,'东海县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320723,320700,'XZQH','320723',320723,'灌云县',1,'灌云县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320724,320700,'XZQH','320724',320724,'灌南县',1,'灌南县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320800,320000,'XZQH','320800',320800,'淮安市',1,'淮安市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320802,320800,'XZQH','320802',320802,'清河区',1,'清河区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320803,320800,'XZQH','320803',320803,'淮安区',1,'淮安区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320804,320800,'XZQH','320804',320804,'淮阴区',1,'淮阴区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320811,320800,'XZQH','320811',320811,'清浦区',1,'清浦区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320826,320800,'XZQH','320826',320826,'涟水县',1,'涟水县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320829,320800,'XZQH','320829',320829,'洪泽县',1,'洪泽县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320830,320800,'XZQH','320830',320830,'盱眙县',1,'盱眙县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320831,320800,'XZQH','320831',320831,'金湖县',1,'金湖县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320900,320000,'XZQH','320900',320900,'盐城市',1,'盐城市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320902,320900,'XZQH','320902',320902,'亭湖区',1,'亭湖区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320903,320900,'XZQH','320903',320903,'盐都区',1,'盐都区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320921,320900,'XZQH','320921',320921,'响水县',1,'响水县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320922,320900,'XZQH','320922',320922,'滨海县',1,'滨海县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320923,320900,'XZQH','320923',320923,'阜宁县',1,'阜宁县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320924,320900,'XZQH','320924',320924,'射阳县',1,'射阳县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320925,320900,'XZQH','320925',320925,'建湖县',1,'建湖县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320981,320900,'XZQH','320981',320981,'东台市',1,'东台市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320982,320900,'XZQH','320982',320982,'大丰市',1,'大丰市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321000,320000,'XZQH','321000',321000,'扬州市',1,'扬州市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321002,321000,'XZQH','321002',321002,'广陵区',1,'广陵区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321003,321000,'XZQH','321003',321003,'邗江区',1,'邗江区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321012,321000,'XZQH','321012',321012,'江都区',1,'江都区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321023,321000,'XZQH','321023',321023,'宝应县',1,'宝应县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321081,321000,'XZQH','321081',321081,'仪征市',1,'仪征市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321084,321000,'XZQH','321084',321084,'高邮市',1,'高邮市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321100,320000,'XZQH','321100',321100,'镇江市',1,'镇江市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321102,321100,'XZQH','321102',321102,'京口区',1,'京口区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321111,321100,'XZQH','321111',321111,'润州区',1,'润州区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321112,321100,'XZQH','321112',321112,'丹徒区',1,'丹徒区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321181,321100,'XZQH','321181',321181,'丹阳市',1,'丹阳市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321182,321100,'XZQH','321182',321182,'扬中市',1,'扬中市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321183,321100,'XZQH','321183',321183,'句容市',1,'句容市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321200,320000,'XZQH','321200',321200,'泰州市',1,'泰州市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321202,321200,'XZQH','321202',321202,'海陵区',1,'海陵区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321203,321200,'XZQH','321203',321203,'高港区',1,'高港区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321204,321200,'XZQH','321204',321204,'姜堰区',1,'姜堰区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321281,321200,'XZQH','321281',321281,'兴化市',1,'兴化市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321282,321200,'XZQH','321282',321282,'靖江市',1,'靖江市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321283,321200,'XZQH','321283',321283,'泰兴市',1,'泰兴市','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321300,320000,'XZQH','321300',321300,'宿迁市',1,'宿迁市','0','1'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321302,321300,'XZQH','321302',321302,'宿城区',1,'宿城区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321311,321300,'XZQH','321311',321311,'宿豫区',1,'宿豫区','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321322,321300,'XZQH','321322',321322,'沭阳县',1,'沭阳县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321323,321300,'XZQH','321323',321323,'泗阳县',1,'泗阳县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (321324,321300,'XZQH','321324',321324,'泗洪县',1,'泗洪县','0','2'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1) values (320401320402,320400,'XZQH','320402',320402,'天宁区',1,'天宁区','0','2'); --经营人增加行政区划字段2014.12.18 ALTER TABLE T_YJPT_JYRJCXX ADD ("XZQH" NUMBER); COMMENT ON COLUMN T_YJPT_JYRJCXX."XZQH" IS '行政区划'; --增加菜单2014.12.23 INSERT INTO "T_YJPT_BUTTON" (ID, MENU_ID, NAME, CODE, ORDER_NO, RECORD_STATUS, RECORD_CODE) VALUES ('50002755', '26', 'btn.count', 'statistics1', '7', '1', '0'); INSERT INTO T_YJPT_ROLE_BUTTON(BUTTON,ROLE) SELECT 50002755,ROLE FROM T_YJPT_ROLE_BUTTON WHERE BUTTON=50002751; --危货作业新增字段2014.12.25 ALTER TABLE T_YJPT_WXHWGKZYSBD ADD ("HWZL" NUMBER); COMMENT ON COLUMN T_YJPT_WXHWGKZYSBD."HWZL" IS '货物种类'; alter table T_YJPT_WXHWGKZYSBD add JZXSL varchar2(15); comment on column T_YJPT_WXHWGKZYSBD.JZXSL is '集装箱数量'; alter table T_YJPT_WXHWGKZYSBD add HWXS varchar2(100); comment on column T_YJPT_WXHWGKZYSBD.HWXS is '货物形式'; --增加公共代码2014.12.25 insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30001, null, 'HWZL', 'HWZL', 1, 'HWZL1', null, null, null, null, 1, null, null, null, null, null, '油类', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30002, null, 'HWZL', 'HWZL', 2, 'HWZL2', null, null, null, null, 1, null, null, null, null, null, '液体散货', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30003, null, 'HWZL', 'HWZL', 3, 'HWZL3', null, null, null, null, 1, null, null, null, null, null, '固体散货', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30004, null, 'HWZL', 'HWZL', 4, 'HWZL4', null, null, null, null, 1, null, null, null, null, null, '件杂货', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30005, null, 'HWZL', 'HWZL', 5, 'HWZL5', null, null, null, null, 1, null, null, null, null, null, '化学品', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30006, null, 'HWZL', 'HWZL', 6, 'HWZL6', null, null, null, null, 1, null, null, null, null, null, '液化气', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (30007, null, 'HWZL', 'HWZL', 7, 'HWZL7', null, null, null, null, 1, null, null, null, null, null, '其他', null, null, '0', null, null, null, null, null); <#if versionDate?date("yyyyMMdd") lt "20141230"?date("yyyyMMdd") > -- 1.9.1 版本脚本 --刷数据20141226 --人员基本信息 update t_yjpt_jyrdryxx ry set ry.ssjyr= (select zy.jyr from t_yjpt_gkwxhwzyfzblhhz zy where ry.fzzy_id =zy.id ), ry.ssgq= (select zy.ssgq from t_yjpt_gkwxhwzyfzblhhz zy where ry.fzzy_id =zy.id ) where ry.fzzy_id is not null; --管理制度 update t_yjpt_glzd zd set zd.qymc= (select zy.jyr from t_yjpt_gkwxhwzyfzblhhz zy where zd.zyfz_id =zy.id ), zd.szgq= (select zy.ssgq from t_yjpt_gkwxhwzyfzblhhz zy where zd.zyfz_id =zy.id ) where zd.zyfz_id is not null; --应急预案 update t_yjpt_yjya ya set ya.qymc= (select zy.jyr from t_yjpt_gkwxhwzyfzblhhz zy where ya.zyfz_id =zy.id ), ya.gq= (select zy.ssgq from t_yjpt_gkwxhwzyfzblhhz zy where ya.zyfz_id =zy.id ),byzd1='1' where ya.zyfz_id>0; -- 增加泰州所在地 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001801,90018,'SZD','321201',32120100,'SZD.TAIZHOULOCAL',1,'泰州本部','0','TZ_0','90018','JS120100','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001804,90018,'SZD','321204',32120400,'SZD.JIANGYAN',1,'姜堰区','0','JY','9001804','JS120400','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001805,90018,'SZD','321281',32128100,'SZD.XINGHUA',1,'兴化市','0','XH','9001805','JS128100','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001806,90018,'SZD','321282',32128200,'SZD.JINGJIANG',1,'靖江市','0','JJ','9001806','JS128200','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001808,90018,'SZD','321282',32128200,'SZD.JINGJIANGGYY',1,'江阴—靖江工业园区','0','JJGYY','9001808','JS128200','泰州市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9001803,90018,'SZD','321203',32120300,'SZD.GAOGANG',1,'高港区','0','GG','9001803','JS120300','泰州市交通运输局港口处'); -- 盐城内河所在地 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002701,90027,'SZD','320901',32090100,'SZD.YANCHENGLOCAL',1,'盐城内河本部','0','YC_0','90019','JS090100','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002702,90027,'SZD','320922',32092200,'SZD.BINHAI',1,'滨海县','0','BHX','9002702','JS092200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002703,90027,'SZD','320923',32092300,'SZD.FUNING',1,'阜宁县','0','FNX','9002703','JS092300','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002704,90027,'SZD','320902',32090200,'SZD.TINGHU',1,'亭湖县','0','THQ','9002704','JS090200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002705,90027,'SZD','320924',32092400,'SZD.SHEYANG',1,'射阳县','0','SYX','9002705','JS092400','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002706,90027,'SZD','320981',32098100,'SZD.DONGTAI',1,'东台市','0','TTS','9002706','JS098100','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002707,90027,'SZD','320982',32098200,'SZD.DAFENG',1,'大丰市','0','DFS','9002707','JS098200','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002708,90027,'SZD','320903',32090300,'SZD.XIANGSHUI',1,'响水县','0','YDX','9002708','JS090300','盐城市交通运输局港口处'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE,BYZD1,BYZD2,BYZD4,BYZD5) values (9002709,90027,'SZD','320925',32092500,'SZD.JIANHU',1,'建湖县','0','JHX','9002709','JS092500','盐城市交通运输局港口处');