Home Explore Help
Register Sign In
hs
/
jsgkj
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: b107be593b
Branches Tags
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
huaian
/
gkjy
/
5.4.2.gkjydata.sql

5.4.2.gkjydata.sql 20 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 
  1.  delete from GK_BASIC_JSJY_JYR_CG;
    2. 

  2. 

  3. --储罐
    4. 

  4. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    5. 

  5. values ('739D53B1B90D4F1798F05A66C017F465', 'F6FA9685E57641A8BACDE0B3CA87836E', null, '101、102、103、104、105、106', null, null, null, null, null, null, null, null, null, null, 1, ' 柴油罐', '101、102、103、104、105、106', null, null, null, 0.8, '901', null, null, null, null, null, null, null, null, null, null, null, '202', null, '中国石油运河油库', null, '05-1月 -15 11.14.35.000000 上午', null, null, null, null, null, null, -1, null, null, null, 'aq', 1, '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000021', 'Y', 'N', null, null, null, null, null, null, null, null);
    6. 

  6. 

  7. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    8. 

  8. values ('632EC51ABAAD479AA7690107CD071A9A', '7A4B745F30AC4483B14164D8E483A2BD', null, 'CHY-chgq', null, null, null, '3501', '13475319-8', '盱安监备（重）字【2014】002号', '甲苯罐区', null, null, null, 1, '甲苯罐', '1、2、3、4', '501', null, null, 0.2, '902', null, null, null, null, null, null, null, null, null, null, null, '202', null, '江苏淮河化工有限公司', null, '21-11月-14 02.19.40.000000 下午', null, null, null, null, null, null, -1, null, null, null, 'aq', 1, '90023', 'BA9D8B8DFEA848D08FCF2C16143299E9', 1, 0.2, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000001', 'Y', 'N', null, null, null, null, null, null, null, null);
    9. 

  9. 

  10. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    11. 

  11. values ('A3DD23398B734C85B8B448EF9FFCC5A5', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD01', '3401', null, null, '3501', null, null, '成品油油罐区', null, null, 11250, 1, '钢资内浮顶油罐', 'TD01', '501', null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, '23-4月 -14 12.00.00.000000 上午', null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 12.00.00.000000 上午', 0, null, 0, null, 0, null, -1, '柴油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000083', 'Y', 'N', null, null, null, null, null, null, null, null);
    12. 

  12. 

  13. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    14. 

  14. values ('C4CEE91D08C5490B82952CD767EF19DF', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD02', null, null, null, '3501', null, null, '成品油油罐区', '淮安市淮阴区袁集乡干庄村', null, null, 1, '钢质内浮顶油罐', 'TD02', '501', null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 12.00.00.000000 上午', null, null, null, null, null, null, -1, null, null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000084', 'Y', 'N', null, null, null, null, null, null, null, null);
    15. 

  15. 

  16. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    17. 

  17. values ('A8D829B593D04FCEA707C149EBB25C5E', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD03', null, null, '油罐、管线、管道泵', '3501', null, null, '成品油油罐区', null, null, null, 1, '钢质内浮顶油罐', 'TD03', '501', null, null, 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.38.38.000000 上午', null, null, null, null, null, null, -1, '柴油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000085', 'Y', 'N', null, null, null, null, null, null, null, null);
    18. 

  18. 

  19. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    20. 

  20. values ('8F7A66A93CA6496481B0AEDB4B012E08', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD05', '3401', null, null, '3501', null, null, '成品油油罐区', null, null, null, 1, '钢质内浮顶油罐', 'TD05', '501', null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.42.17.000000 上午', null, null, null, null, null, null, -1, '柴油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000087', 'Y', 'N', null, null, null, null, null, null, null, null);
    21. 

  21. 

  22. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    23. 

  23. values ('A8E9C385F3B149738351DC948FC58D97', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD06', '3401', null, null, '3501', null, null, '成品油油罐区', null, null, null, 1, '钢质内浮顶油罐', 'TD06', '501', null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.43.11.000000 上午', null, null, null, null, null, null, -1, '柴油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000088', 'Y', 'N', null, null, null, null, null, null, null, null);
    24. 

  24. 

  25. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    26. 

  26. values ('3B11F84893514D86B0788B079FA4838F', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TG01', '3401', null, null, '3501', null, null, '中石油淮安油库', null, null, null, 1, '钢质内浮顶油罐', 'TG01', null, null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.48.00.000000 上午', null, null, null, null, null, null, -1, '汽油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000090', 'Y', 'N', null, null, null, null, null, null, null, null);
    27. 

  27. 

  28. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    29. 

  29. values ('43DE93DE359A45C88E7E2E85D9DF0360', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TG02', null, null, null, '3501', null, null, null, null, null, null, 1, 'TG02', 'TG02', null, null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.49.00.000000 上午', null, null, null, null, null, null, -1, '汽油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000091', 'Y', 'N', null, null, null, null, null, null, null, null);
    30. 

  30. 

  31. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    32. 

  32. values ('DDF5BB96537B4636B0BB3FB393BCF6FD', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TG03', '3401', null, null, '3501', null, null, null, null, null, null, 1, '钢质内浮顶油罐', 'TG03', null, null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.50.21.000000 上午', null, null, null, null, null, null, -1, '汽油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000092', 'Y', 'N', null, null, null, null, null, null, null, null);
    33. 

  33. 

  34. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    35. 

  35. values ('7D461528E28F4668B2E4B7EEEB66664E', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TG04', '3401', null, null, '3501', null, null, null, null, null, null, 1, '钢质内浮顶油罐', 'TG04', null, null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.51.27.000000 上午', null, null, null, null, null, null, -1, '汽油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000093', 'Y', 'N', null, null, null, null, null, null, null, null);
    36. 

  36. 

  37. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    38. 

  38. values ('3768A9C0F5A5436F9AC0F02DD666E4AF', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TG05', '3401', null, null, '3501', null, null, null, null, null, null, 1, '钢质内浮顶油罐', 'TG05', null, null, '601', 0.3, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.52.06.000000 上午', null, null, null, null, null, null, -1, '汽油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000094', 'Y', 'N', null, null, null, null, null, null, null, null);
    39. 

  39. 

  40. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    41. 

  41. values ('311736E42577499AAD248D324F681024', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TE01', '3401', null, null, '3501', null, null, null, null, null, null, 1, '钢质量内浮顶油罐', 'TE01', null, null, null, 0.2, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.58.38.000000 上午', null, null, null, null, null, null, -1, '乙醇', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000095', 'Y', 'N', null, null, null, null, null, null, null, null);
    42. 

  42. 

  43. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    44. 

  44. values ('60920793DFAC412E8ACE81663A41A8D3', 'CAB13C19726C43139A267FFCC7F271EF', null, '16', null, null, null, null, null, null, null, null, null, null, 1, '储气罐', '16', null, null, null, 1800, '902', null, '3802', null, null, null, null, null, null, null, null, null, '202', null, '海螺水泥', null, '14-6月 -15 08.15.42.000000 上午', null, null, null, null, null, null, -1, null, null, null, 'aq', 1, '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000041', 'Y', 'N', null, null, null, null, null, null, null, null);
    45. 

  45. 

  46. insert into GK_BASIC_JSJY_JYR_CG (ID, SSJYR, WHZYFZBH, QYCCBH, SCJYHDLX, CCHXPPZSL, ZXGYJZYSB, CCCSCQ, GKZDWXYBH, GKZDWXYBABH, CGQMC, JTWZ, CGZB, CGQMJ, CGGS, CGMC, CGXH, YWFHD, GJZXJL, CGCZ, CGRJ, CGXS, CGAZXS, WZZT, CGWX, SJYL, SJGZYL, SJWD, SJGZWD, TCSJ, SJSYNX, JLFS, CLFS, FJDSSSFNJJZS, ZSBH, TBR, LXDH, TBSJ, HYSL, HYSM, BDZZSL, BDZZSM, QTSL, QTSM, MAPID, HXPMC, HXPPZ, HXPSL, UPDATE_USER, RECORD_STATUS, SZD, SZGQ, ZDWXYCGGS, ZDWXYCGRL, AQGD, ZJ, WXYDJ, CREATE_DATE_TIME, UPDATE_DATE_TIME, CREATE_USER, SZGK, SSGKGLBM, AQID, SFTB, TBZT, SFWXPCG, YGRJ, YGRL, YTCRJ, YTHGCGRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    47. 

  47. values ('78C8016D6F864AE3B539FD2C23120421', '952310D0B296438099C5A4F135EAC818', '1021-M1-M2SH', 'TD04', null, null, null, '3501', null, null, '成品油油罐区', null, null, null, 1, '钢质内浮顶油罐', 'TD04', '501', null, '601', 0.5, '901', '3701', '3801', '802', null, null, null, null, null, null, '4001', '4101', '201', null, '淮安油库', null, '26-8月 -15 10.41.10.000000 上午', null, null, null, null, null, null, -1, '柴油', null, null, 'aq', 1, '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, null, null, null, null, '26-11月-15 08.38.03.704000 下午', '26-11月-15 08.38.03.704000 下午', 'aq', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '12000000086', 'Y', 'N', null, null, null, null, null, null, null, null);
    48.