Home Esplora Aiuto
Registrati Accedi
hs
/
jsgkj
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): ccf18e7b6e
Rami (Branch) Tag
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
wuxi
/
gkjy
/
5.4.3.gkjydata.sql

5.4.3.gkjydata.sql 4.8 KB
Cronologia Originale

1234567891011121314151617181920 
  1. delete from GK_BASIC_JSJY_JYR_CK;
    2. 

  2. 

  3. --仓库
    4. 

  4. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    5. 

  5. values ('9CEC65FDCBCF4F5A81DC15906C153359', '90016', 'E6347993F8F14F54982214701AA7F833', null, '6DA9367F8CB84EDAB42E004E744F59BB', '无', '202', null, null, null, null, null, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000201', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    6. 

  6. 

  7. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    8. 

  8. values ('E7FE2A419D07469AA7C789A5E3D08FA7', '90016', 'E6347993F8F14F54982214701AA7F833', null, 'C50F8CC207104AC8A1F708BB194EA542', '硫酸罐', '201', null, null, 2, 2500, null, null, null, null, null, null, '31', '119', 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000003', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    9. 

  9. 

  10. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    11. 

  11. values ('B358381215084421B40A3D9E0FD98AAE', '90016', 'B422D46C221345C5A86A36E99B05D56A', null, '3DC1BAC155A94BDF82A41772C9C631FB', '红兴化工', '201', null, null, 1, 660, 500, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000181', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    12. 

  12. 

  13. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    14. 

  14. values ('83CC2C60F9884FCB9D70AF2B10807D67', '90016', 'E6347993F8F14F54982214701AA7F833', null, '12EBD2CACC984DAA806476A25A78739F', '1#仓库', '201', null, null, 1, 500, null, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000001', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    15. 

  15. 

  16. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    17. 

  17. values ('94A1819F15B145DA9F2D44C8254B881F', '90016', 'E6347993F8F14F54982214701AA7F833', null, '19E3424F7F414A268AA4F369AAAB958F', '硝酸储槽', '201', null, null, 1, 1200, null, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000022', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    18. 

  18. 

  19. insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
    20. 

  20. values ('CCEB70AE952244BF9C87889D57E8BB76', '90016', 'E6347993F8F14F54982214701AA7F833', null, '62C3BA35824040EC838294DDED4C0607', '油罐库区', '201', null, null, 18, null, null, null, null, 13000, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '5000000006', 'N', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);
    21.