Kezdőlap Felfedezés Súgó
Regisztráció Bejelentkezés
hs
/
jsgkj
2
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Fa: b107be593b
Branch-ok Tag-ek
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
huaian
/
gkjy
/
5.4.4.gkjydata.sql

5.4.4.gkjydata.sql 13 KB
Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 
  1. delete from GK_BASIC_JSJY_JYR_DC;
    2. 

  2. delete from GK_BASIC_JSJY_JYR_MT;
    3. 

  3. --堆场
    4. 

  4. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    5. 

  5. values ('E91C342DB19A4D2D9F74C37FD36BD5A2', '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', 'F6FA9685E57641A8BACDE0B3CA87836E', null, '运河油库码头', null, null, null, null, null, null, null, null, null, null, '202', '油品', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000021', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    6. 

  6. 

  7. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    8. 

  8. values ('CD440FD2FFD54C00B60EAE241263E6DA', '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', 'F6FA9685E57641A8BACDE0B3CA87836E', null, '中国石油化工股份有限公司江苏淮安石油分公司运河油库', null, null, null, null, null, null, null, null, null, null, '202', null, '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000022', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    9. 

  9. 

  10. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    11. 

  11. values ('162D8308DF63451BB6287CCFAFAF8C8B', '90023', '78BEF3ED8DAD42349BDC9AE22BB4ECAC', '92F9C34DB77D4F67A7E387C545A054F5', null, '黄沙石子', null, 33455, 169, null, null, null, null, null, null, null, '202', '其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000081', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    12. 

  12. 

  13. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    14. 

  14. values ('44F2FFE7D3464FFAA8888743786DBA46', '90023', '7857596F3DFC4EF38A51F3580BA076F0', '4AA6B9F6AAD644B387774748F40C9CDD', '35CCED68C0304D38BA45372A5DD826B3', '堆场', null, 3000, 30000, null, null, null, null, null, null, null, '202', '煤炭', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000001', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    15. 

  15. 

  16. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    17. 

  17. values ('C0B8A4C56A364F989019B79B23C65CB8', '90023', '78BEF3ED8DAD42349BDC9AE22BB4ECAC', '8CC5705A02E94AE0A888E20D40C3D618', null, '堆场1', null, 3000, null, null, null, null, null, null, null, null, '202', '粮食', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000101', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    18. 

  18. 

  19. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    20. 

  20. values ('E1FD00E672A7474888B39EC31987F04D', '90023', '02C1D35E1AEF4F76BD70BA136F9DA929', '54D0B7E81A384071840B33CD72BB0585', null, '淮安新港', null, 120000, null, null, null, null, null, null, null, null, '202', '煤炭、集装箱', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000061', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    21. 

  21. 

  22. insert into GK_BASIC_JSJY_JYR_DC (ID, SZD, SZGQ, SSJYR, SSMT, DCMC, SCYDCYT, DCZMJ, DCZRL, JZXMJ, JZXDCDCNL, WXPXDCMJ, WXPXDCDCNL, JD, WD, JTJGISDYIDH, WXPDC, ZWDCYT, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, DCLX, MCMJ, MCRL, KSDCMJ, KSDCRL, LCXDCMJ, LCXDCDCNL, CZXDCMJ, CZXDCDCNL, XXDCMJ, XXDCDCNL, QTDCMJ, QTDCDCNL1, QTDCDCNL2)
    23. 

  23. values ('43C6B7EA5A43444A830A82CD4184C4D1', '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', 'D3F67DB9AC6A4B34A0C04438C4189C6A', null, '一号桥', null, 1606, null, null, null, null, null, null, null, null, '202', '其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000041', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    24. 

  24. 

  25. --码头
    26. 

  26. 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)
    27. 

  27. values ('40B5FCF2D83345419CE637FF274206CC', '90023', '淮安清江石油化工有限责任公司码头', null, null, null, null, null, null, null, null, null, '02C1D35E1AEF4F76BD70BA136F9DA929', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000005', null, 'Y', 'N', null);
    28. 

  28. 

  29. 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)
    30. 

  30. values ('3A6A2821C9B743DC82344C8CE1F90AB9', '90023', '淮安华尔润化工有限公司码头', null, null, null, null, null, null, null, null, null, '02C1D35E1AEF4F76BD70BA136F9DA929', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000002', null, 'Y', 'N', null);
    31. 

  31. 

  32. 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)
    33. 

  33. values ('913C1381DB864697AFB9BD990F5A731E', '90023', '江苏安邦电化有限公司码头', null, null, null, null, null, null, null, null, null, '02C1D35E1AEF4F76BD70BA136F9DA929', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000001', null, 'Y', 'N', null);
    34. 

  34. 

  35. 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)
    36. 

  36. values ('F58A3F5FDB2F44A0914A237AA92A2C82', '90023', '江苏淮河化工有限公司码头', null, null, null, null, null, null, null, null, null, 'BA9D8B8DFEA848D08FCF2C16143299E9', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000004', null, 'Y', 'N', null);
    37. 

  37. 

  38. 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)
    39. 

  39. values ('72AA2C99C9E1439A957A4419F1C28F73', '90023', '江苏油田分公司码头', null, null, null, null, null, null, null, null, null, 'E1E64938EC634BA98BE547E90DE416EB', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000006', null, 'Y', 'N', null);
    40. 

  40. 

  41. 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)
    42. 

  42. values ('35CCED68C0304D38BA45372A5DD826B3', '90023', '洪泽戴梦特化工集团有限公司码头', null, null, null, null, null, null, null, null, null, '7857596F3DFC4EF38A51F3580BA076F0', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000003', null, 'Y', 'N', null);
    43. 

  43. 

  44. 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)
    45. 

  45. values ('B2A880B6924D4BBCACB056A9CD7AF083', '90023', '江苏福斯特化工制造有限公司码头', null, null, null, null, null, null, null, null, null, '7857596F3DFC4EF38A51F3580BA076F0', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000007', null, 'Y', 'N', null);
    46. 

  46. 

  47. 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)
    48. 

  48. values ('13E8DAF1BAF443A286CA68CE18226589', '90023', '运河油库码头', null, null, null, null, null, null, null, null, null, 'FD44FB26B7064448A023CF51ED9B2F5F', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000022', null, 'Y', 'N', null);
    49. 

  49. 

  50. 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)
    51. 

  51. values ('DADBE369FE45499781CBF60573E0C254', '90023', '淮安飞扬钛白粉制造有限责任公司码头', null, null, null, null, null, null, null, null, null, 'FD44FB26B7064448A023CF51ED9B2F5F', '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, 'C92E3C8D6AF845C6B41117A280C64CCF', null, null, null, null, null, '12000000021', null, 'Y', 'N', null);
    52.