G01_0347/sql/updatesql.txt

use G01_0347;
DROP TABLE product_tbl;
CREATE TABLE IF NOT EXISTS product_tbl(
   id INT UNSIGNED AUTO_INCREMENT,
   product_idx INT NOT NULL,
   product_name VARCHAR(30) NOT NULL,
   17700_name VARCHAR(30) NOT NULL,
   17720_name VARCHAR(30) NOT NULL,
   stat BOOL NOT NULL,
   PRIMARY KEY ( id )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
exit