-- createProductTable.sql
USE u18;
DROP TABLE IF EXISTS my_Product;
CREATE TABLE my_Product
(
  product_id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(40) NOT NULL,
  cat_code VARCHAR(3) NOT NULL,
  price DECIMAL(6,2) NOT NULL,
  quantity INT NOT NULL,
  image_file VARCHAR(60) NOT NULL,
  PRIMARY KEY (product_id)
);