Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
hs
/
jsgkj
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: a3bd977e53
Haarat Tagit
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
huaian
/
gkjc
/
5.3.gkjcdata.sql

5.3.gkjcdata.sql 7.4 KB
Historia Raaka

123456789101112131415161718192021222324252627282930313233343536373839404142434445 
  1. delete from GK_BASIC_JSJY_DWXX_XZGLBMXX;
    2. 

  2. delete from GK_BASIC_JSJY_DWXX_XZGLRYXX;
    3. 

  3. delete from GK_BASIC_JSJY_GK_GK;
    4. 

  4. delete from GK_BASIC_JSJY_GK_GQ;
    5. 

  5. delete from GK_BASIC_JSJY_GK_ZYQ;
    6. 

  6. delete from GK_BASIC_JSJY_GK_MD;
    7. 

  7. delete from GK_BASIC_JSJY_GK_AX;
    8. 

  8. --行政管理部门和人员
    9. 

  9. insert into GK_BASIC_JSJY_DWXX_XZGLBMXX (id, gkglbmqc, bmlx, rybz, lxr, lxdh, cz, yb, bz, create_user, create_date_time, update_user, record_status, update_date_time, szd, pid, sortno)
    10. 

  10. values ('402881f05122619f01512274949b0009', '淮安市交通运输局', '401', null, null, null, null, null, null, '1', to_timestamp('20-11-2015 09:14:04.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), '1', 1, to_timestamp('20-11-2015 09:14:04.315000', 'dd-mm-yyyy hh24:mi:ss.ff'), '90023', '00', 4);
    11. 

  11. 

  12. --港口
    13. 

  13. insert into GK_BASIC_JSJY_GK_GK (ID, SZD, AQGK, SYHG, WHCG, WHPZ, ZDWXY, PTHWCG, PTHWPZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, GKMC, GKDM, SSGKGLBM, GKSZHQ, GKSZGW, HLMC, HGMC, GKMHWZ, GHSFPF, GHPFWH, SFHB, BHBGKMC, BZ, DTSJ, ZYID, AQID, ZRAXCD, SFTB, TBZT, ORDERID, XZQH)
    14. 

  14. values ('C92E3C8D6AF845C6B41117A280C64CCF', '90023', null, null, null, null, null, null, null, '16-11月-15 10.25.39.000000 上午', '16-11月-15 10.25.39.000000 上午', 1, null, null, '淮安港', '321105', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'Y', 'N', 21, '320800');
    15. 

  15. 

  16. --港区
    17. 

  17. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    18. 

  18. values ('FD44FB26B7064448A023CF51ED9B2F5F', '淮安港区', '1206', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '25-11月-15 04.14.28.00000000 下午', '25-11月-15 04.14.28.00000000 下午', 1, 'aq', 'aq', '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110508', null, null, null, null, null, null, null, '12000000004', 'Y', 'N', null, null);
    19. 

  19. 

  20. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    21. 

  21. values ('E4CAAFEFEBAC41AC98D0C1B55A35B41B', '淮阴港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110502', null, null, null, null, '12000000002', null, null, '12000000002', 'Y', 'N', null, 101);
    22. 

  22. 

  23. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    24. 

  24. values ('7857596F3DFC4EF38A51F3580BA076F0', '洪泽港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110505', null, null, null, null, '12000000005', null, null, '12000000005', 'Y', 'N', null, 104);
    25. 

  25. 

  26. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    27. 

  27. values ('02C1D35E1AEF4F76BD70BA136F9DA929', '市区港区', '1206', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110501', null, null, null, null, '12000000003', null, null, '12000000003', 'Y', 'N', null, 100);
    28. 

  28. 

  29. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    30. 

  30. values ('DD918147083446A8B889ECA6AF6FE325', '楚州港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110503', null, null, null, null, null, null, null, null, 'Y', 'N', null, 102);
    31. 

  31. 

  32. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    33. 

  33. values ('78BEF3ED8DAD42349BDC9AE22BB4ECAC', '涟水港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110504', null, null, null, null, '12000000001', null, null, '12000000001', 'Y', 'N', null, 103);
    34. 

  34. 

  35. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    36. 

  36. values ('BA9D8B8DFEA848D08FCF2C16143299E9', '盱眙港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110506', null, null, null, null, '12000000006', null, null, '12000000006', 'Y', 'N', null, 105);
    37. 

  37. 

  38. insert into GK_BASIC_JSJY_GK_GQ (ID, GQMC, GQSZSYLX, GQMJ, LYMJ, SYFW, SYMJ, GQGHMJ, GHLYMJ, FGYSCYDGHMJ, GHSYMJ, GQZRAXCD, GYMTAXCD, GQGKAXCD, GKSSYSYAXCD, GQDMBDZDZ, BZ, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, SZGK, SSGKGLBM, GQDM, GQNHHDDM, DLWZWD, DLWZJD, DTSJ, YJPTID, GQMS, ZYID, AQID, SFTB, TBZT, GIS_STATUS, ORDERID)
    39. 

  39. values ('E1E64938EC634BA98BE547E90DE416EB', '金湖港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.28.00000000 上午', '16-11月-15 10.50.28.00000000 上午', 1, null, null, '90023', 'C92E3C8D6AF845C6B41117A280C64CCF', null, '32110507', null, null, null, null, '12000000007', null, null, '12000000007', 'Y', 'N', null, 106);
    40. 

  40. 

  41. --作业区
    42. 

  42. 

  43. --锚地表
    44. 

  44. 

  45. --岸线
    46.