Acasă Explorează Ajutor
Înregistrare Autentificare
hs
/
jsgkj
2
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Arbore: 43f01032b4
Ramuri Etichete
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
nantongneihe
/
gkjc
/
5.3.gkjcdata.sql

5.3.gkjcdata.sql 8.6 KB
Istoric Crud

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  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. --行政管理部门和人员
    10. 

  10. 

  11. --港口
    12. 

  12. 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)
    13. 

  13. values ('0224947E09A044BCB4BF4611B00497EC', '90025', null, null, null, null, null, null, null, '16-11月-15 10.25.39.000000 上午', '16-11月-15 10.25.39.000000 上午', 1, null, null, '南通内河港', '321114', null, null, null, null, null, null, null, null, null, null, null, null, '0224947E09A044BCB4BF4611B00497EC', null, null, 'Y', 'Z', 16, '320600');
    14. 

  14. --港区
    15. 

  15. 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)
    16. 

  16. values ('4458EF671C40426BA1BED2706BDD2F4D', '主城区港区', '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', '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111410', null, null, null, null, null, null, '4458EF671C40426BA1BED2706BDD2F4D', '14100000001', 'N', 'Y', null, null);
    17. 

  17. 

  18. 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)
    19. 

  19. values ('10A13CBA2E2745B5B6F4B467A5120EB8', '港闸港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111401', null, null, null, null, null, null, '10A13CBA2E2745B5B6F4B467A5120EB8', '17000000003', 'N', 'Y', null, 15);
    20. 

  20. 

  21. 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)
    22. 

  22. values ('D2C93312D16340FCBFC3F09ECDC48B1A', '崇川港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111402', null, null, null, null, null, null, 'D2C93312D16340FCBFC3F09ECDC48B1A', '17000000004', 'N', 'Y', null, 18);
    23. 

  23. 

  24. 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)
    25. 

  25. values ('77BCFF0266D3420DA0952816CE64C8CD', '通州港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111407', null, null, null, null, '14100000002', null, '77BCFF0266D3420DA0952816CE64C8CD', '14100000002', 'N', 'Y', null, 25);
    26. 

  26. 

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

  28. values ('C5FC966632FB4B3993F5CC8A85ABCC13', '海门港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111408', null, null, null, null, '14100000005', null, 'C5FC966632FB4B3993F5CC8A85ABCC13', '14100000005', 'N', 'Y', null, 26);
    29. 

  29. 

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

  31. values ('C5822DAD2E964A5C9E217A40548A963B', '开发区港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111403', null, null, null, null, null, null, 'C5822DAD2E964A5C9E217A40548A963B', '17000000020', 'N', 'Y', null, 19);
    32. 

  32. 

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

  34. values ('B3CDA2DE6E0E48FCB897CF580A328F1F', '如东港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111406', null, null, null, null, '14100000004', null, 'B3CDA2DE6E0E48FCB897CF580A328F1F', '14100000004', 'N', 'Y', null, 23);
    35. 

  35. 

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

  37. values ('DBECD8C7A19C458CB3E8A18A92FB431C', '启东港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111409', null, null, null, null, '14100000007', null, 'DBECD8C7A19C458CB3E8A18A92FB431C', '14100000007', 'N', 'Y', null, 27);
    38. 

  38. 

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

  40. values ('021B2CE6C247407AB7D0F35224E345EF', '如皋内河港区', '1201', null, null, null, null, null, null, null, null, null, null, null, null, null, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111405', null, null, null, null, null, null, '021B2CE6C247407AB7D0F35224E345EF', '14100000006', 'N', 'Y', null, 21);
    41. 

  41. 

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

  43. values ('6E036D235B2E4DD3B5E5DB61CB56FD1A', '海安港区', '1201', null, null, 1, null, 1, 1, 1, 1, 1, 1, 1, 1, 1, null, '16-11月-15 10.50.31.00000000 上午', '16-11月-15 10.50.31.00000000 上午', 1, null, null, '90025', '0224947E09A044BCB4BF4611B00497EC', null, '32111404', null, null, null, null, '14100000003', null, '6E036D235B2E4DD3B5E5DB61CB56FD1A', '14100000003', 'N', 'Y', null, 20);
    44. 

  44. 

  45. --作业区
    46. 

  46. 

  47. 

  48. --锚地表
    49. 

  49. 

  50. --岸线
    51.