Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
hs
/
jsgkj
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: ccf18e7b6e
Haarat Tagit
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
nantongneihe
/
gkjy
/
5.4.4.gkjydata.sql

5.4.4.gkjydata.sql 9.8 KB
Historia Raaka

12345678910111213141516171819202122232425262728293031323334353637 
  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, YDCID, XKZID, DCZRLTEU)
    5. 

  5. values ('BD9AF13E99734BA6BF574068CD3C3D97', '90025', '77BCFF0266D3420DA0952816CE64C8CD', '346F411FD418486BAC1593AE9D126CA3', 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', '0224947E09A044BCB4BF4611B00497EC', null, '14000000161', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    8. 

  8. values ('ED9612CA2C2447C7837BF773AD350030', '90025', 'B3CDA2DE6E0E48FCB897CF580A328F1F', '7DDB6FA8AAFC45A789500899DEFFE55B', null, '琦衡码头', 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', '0224947E09A044BCB4BF4611B00497EC', null, '14000000001', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    11. 

  11. values ('73277A666F154AAE956792C85824534B', '90025', 'B3CDA2DE6E0E48FCB897CF580A328F1F', '7E9489A885044E7A8C58BE5B5AEE29CC', 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', '0224947E09A044BCB4BF4611B00497EC', null, '14000000121', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    14. 

  14. values ('955EA95A81ED44E6923BF756838C1747', '90025', 'B3CDA2DE6E0E48FCB897CF580A328F1F', '7E9489A885044E7A8C58BE5B5AEE29CC', 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', '0224947E09A044BCB4BF4611B00497EC', null, '14000000141', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    17. 

  17. values ('23A5688473A34A22BB57D69B14B45084', '90025', 'B3CDA2DE6E0E48FCB897CF580A328F1F', 'EE9649E46E2A44CC833D0D67F25FA791', 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', '0224947E09A044BCB4BF4611B00497EC', null, '14000000041', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    20. 

  20. values ('4CBCC8CD5A3C4319A22E9D95A702FD9D', '90025', 'B3CDA2DE6E0E48FCB897CF580A328F1F', 'E2956ED846E14C0480ED6CCEF2D2492B', null, '煤炭堆场', null, 200, 2000, null, null, null, null, null, null, null, '202', '煤炭', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000021', 'N', 'N', null, null, null, 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, YDCID, XKZID, DCZRLTEU)
    23. 

  23. values ('9D4F49F452704E2FACC70C87AF319032', '90025', '4458EF671C40426BA1BED2706BDD2F4D', 'DF3F8D3591AF481C8B2054A26ACF515C', null, '化轻三号桥危险品仓库', null, 36000, null, null, null, 5500, null, null, null, null, '201', null, '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000181', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    24. 

  24. 

  25. 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, YDCID, XKZID, DCZRLTEU)
    26. 

  26. values ('66E5DF2EE02C4673A2CAEB6B8CD364F1', '90025', '4458EF671C40426BA1BED2706BDD2F4D', 'D24CE387C4E7421186EBBB183E61C4BA', null, '材料堆场', null, 4356, 3800, 0, 0, 0, 0, null, null, null, '202', '其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000081', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    27. 

  27. 

  28. 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, YDCID, XKZID, DCZRLTEU)
    29. 

  29. values ('D388594806AA4ED3A461FA669D36F1E7', '90025', '77BCFF0266D3420DA0952816CE64C8CD', '208C19712F69410BA23BE13DF925182C', null, '紫鑫堆场', null, 8000, 12000, null, null, null, null, null, null, null, '202', '煤炭、其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000063', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    30. 

  30. 

  31. 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, YDCID, XKZID, DCZRLTEU)
    32. 

  32. values ('12A42FACBD02491B88FBA499263051AC', '90025', '4458EF671C40426BA1BED2706BDD2F4D', '8C99CDB5DF024C499601D40810FAE016', null, '场堆1', null, 8200, null, null, null, 3000, null, null, null, null, '201', '其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000101', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    33. 

  33. 

  34. 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, YDCID, XKZID, DCZRLTEU)
    35. 

  35. values ('71EAD4B04E03456CB53F43BE17F3450E', '90025', '4458EF671C40426BA1BED2706BDD2F4D', '8C99CDB5DF024C499601D40810FAE016', null, '场堆1', null, 8200, null, null, null, 3000, null, null, null, null, '201', '其他', '27-11月-15 04.07.21 下午', '27-11月-15 04.07.21 下午', 1, 'aq', 'aq', '0224947E09A044BCB4BF4611B00497EC', null, '14000000102', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    36. 

  36. 

  37. --码头
    38.