Home Esplora Aiuto
Registrati Accedi
hs
/
jsgkj
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): ccf18e7b6e
Rami (Branch) Tag
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
yanchengneihe
/
gkjy
/
5.4.4.gkjydata.sql

5.4.4.gkjydata.sql 6.1 KB
Cronologia Originale

12345678910111213141516171819202122232425 
  1. delete from GK_BASIC_JSJY_JYR_DC;
    2. 

  2. delete from GK_BASIC_JSJY_JYR_MT;
    3. 

  3. --堆场
    4. 

  4. 

  5. --码头
    6. 

  6. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    7. 

  7. values ('D14B564F17364CAB857AAD55DED3FAB6', '90027', '新兴油库码头', null, null, null, null, null, null, null, null, '1C7C481A4ABA48BC80F265E79CB670F1', '5A7C2E23248249BE955A68A3734563BF', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, 'D14B564F17364CAB857AAD55DED3FAB6', '16000000007', null, 'N', 'N', null, null, null);
    8. 

  8. 

  9. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    10. 

  10. values ('2BC259780A7E4F63B5C1ADB7B1FDC4A2', '90027', '双昌硫酸码头', null, null, null, null, null, null, null, null, '408BA2479B7344EE9D8196FC2BA2CF3A', '4EE456BE904B404ABDAAAC571727E1F7', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, '2BC259780A7E4F63B5C1ADB7B1FDC4A2', '16000000005', null, 'N', 'N', null, null, null);
    11. 

  11. 

  12. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    13. 

  13. values ('128D6A14CC374D529B1A42812E51B1B4', '90027', '安和焦化自备码头', null, null, null, null, null, null, null, null, '26993F9861B04B78BC6678F2A88CFE3E', 'C5053708E1074B35BC09B559A7EE3FB0', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, '128D6A14CC374D529B1A42812E51B1B4', '16000000004', null, 'N', 'N', null, null, null);
    14. 

  14. 

  15. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    16. 

  16. values ('20F550FA39FF472EB27B4E6AEA0C24DD', '90027', '特墉油库码头', null, null, null, null, null, null, null, null, 'ABA5E64850F34E4296AD3E78C2D45170', '909A1A26EC634F76B41CEC45F30F5488', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, '20F550FA39FF472EB27B4E6AEA0C24DD', '16000000006', null, 'N', 'N', null, null, null);
    17. 

  17. 

  18. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    19. 

  19. values ('2D5B25C95927457890CDB73971E60DC4', '90027', '吉华公司码头', null, null, null, null, null, null, null, null, '14D5B1AA8EB14A7794FF3258CC6DC337', '689EFE7E08284F39896876624262EE0F', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, '2D5B25C95927457890CDB73971E60DC4', '16000000003', null, 'N', 'N', null, null, null);
    20. 

  20. 

  21. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    22. 

  22. values ('D57A1523E0E94ABE885C6F0AB51B6C07', '90027', '盐化工公司码头', null, null, null, null, null, null, null, null, 'DC56003B63624EACB583C26A3EDD586E', '689EFE7E08284F39896876624262EE0F', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, 'D57A1523E0E94ABE885C6F0AB51B6C07', '16000000002', null, 'N', 'N', null, null, null);
    23. 

  23. 

  24. insert into GK_BASIC_JSJY_JYR_MT (ID, SZD, MTMC, NHWTGNL, SJHWTTL, SJLKTTL, NLKTGNL, NJZXTGNL, MTSJQYSS, GISID, MTYT, SSJYR, SZGQ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, MTCD, FWLX, SFDWKF, SFWHP, MTQYSJCLSS, MTDM, MTXSDM, BWGS, MTQYDBG, MTSFWARS, SZGK, SSGKGLBM, SZZYQ, SZAX, JCRQ, ZYID, AQID, DTSJ, SFTB, TBZT, GIS_STATUS, YMTID, XKZID)
    25. 

  25. values ('08A1C07D270C4F7889810CEB51664CE5', '90027', '宝聚公司码头', null, null, null, null, null, null, null, null, '940EE2891775455686CEE29983453B1D', '689EFE7E08284F39896876624262EE0F', '26-11月-15 10.05.19.681000 上午', '26-11月-15 10.05.19.681000 上午', 1, 'aq', 'aq', null, null, null, null, null, null, null, null, null, null, '2A13C4A53FEC4159BBA7800370FD09A6', null, null, null, null, '08A1C07D270C4F7889810CEB51664CE5', '16000000001', null, 'N', 'N', null, null, null);
    26.