/* drops my_products table if exists (and if needed) */
/* DROP TABLE IF EXISTS my_products; */

/* create the my_products table */
CREATE TABLE my_products(
    product_id INT NOT NULL AUTO_INCREMENT,
    product_name VARCHAR(30) NOT NULL,
    product_cat VARCHAR(30) NOT NULL,
    product_desc VARCHAR(50) NOT NULL,
    unit_price DECIMAL(6,2) NOT NULL,
    product_inventory INT NOT NULL,
    product_img VARCHAR(100),
    PRIMARY KEY(product_id)
);