updatesql.txt 338 B

123456789101112
  1. use G01_0350;
  2. DROP TABLE product_tbl;
  3. CREATE TABLE IF NOT EXISTS product_tbl(
  4. id INT UNSIGNED AUTO_INCREMENT,
  5. product_idx INT NOT NULL,
  6. product_name VARCHAR(30) NOT NULL,
  7. 17700_name VARCHAR(30) NOT NULL,
  8. 17720_name VARCHAR(30) NOT NULL,
  9. stat BOOL NOT NULL,
  10. PRIMARY KEY ( id )
  11. )ENGINE=InnoDB DEFAULT CHARSET=utf8;
  12. exit