#createProductTable.sql
#Table structure for my_Product

use u64;
DROP TABLE IF EXISTS my_Product;
CREATE TABLE my_Product
(
    product_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(60) NOT NULL,
    cat_code VARCHAR(3) NOT NULL,
    price DECIMAL(6,2) NOT NULL,
    quantity INT NOT NULL,
    image_file VARCHAR(55) NOT NULL
);