ty_jybm.sql 966 B

12345678910111213141516171819202122232425
  1. -- ty_jybm
  2. ALTER TABLE db_utf8:ty_jybm ADD lxr varchar(50);
  3. ALTER TABLE db_utf8:ty_jybm ADD jyrq date;
  4. ALTER TABLE db_utf8:ty_jybm ADD jysj varchar(10);
  5. ALTER TABLE db_utf8:ty_jybm ADD jyfx varchar(20);
  6. ALTER TABLE db_utf8:ty_jybm ADD jyfs varchar(20);
  7. ALTER TABLE db_utf8:ty_jybm ADD yxsl DECIMAL(9,3);
  8. ALTER TABLE db_utf8:ty_jybm ADD hkshjg int;
  9. ALTER TABLE db_utf8:ty_jybm ADD hkshsj date;
  10. ALTER TABLE db_utf8:ty_jybm ADD hkshyj text;
  11. ALTER TABLE db_utf8:ty_jybm ADD hkshr varchar(50);
  12. ALTER TABLE db_utf8:ty_jybm ADD jyshjg varchar(50);
  13. ALTER TABLE db_utf8:ty_jybm ADD jyshsj date;
  14. ALTER TABLE db_utf8:ty_jybm ADD jyshyj text;
  15. ALTER TABLE db_utf8:ty_jybm ADD jyshr varchar(50);
  16. ALTER TABLE db_utf8:ty_jybm ADD jyfsmc varchar(50);
  17. ALTER TABLE db_utf8:ty_jybm ADD jyfxmc varchar(50);
  18. ALTER TABLE db_utf8:ty_jybm ADD varchar(50);
  19. ALTER TABLE db_utf8:ty_jybm ADD lspzmc VARCHAR(100) ;
  20. ALTER TABLE db_utf8:ty_jybm ADD wtbh VARCHAR(100) ;