CREATE TABLE my_Product
(
    product_id INT NOT NULL AUTO_INCREMENT,
    product_name VARCHAR(40) NOT NULL,
    product_category VARCHAR(3) NOT NULL,
    product_price DECIMAL(6,2) NOT NULL,
    product_quantity INT NOT NULL,
    product_img_file VARCHAR(30) NOT NULL,
    PRIMARY KEY(product_id)
);

DELETE FROM my_Product;
LOAD DATA LOCAL INFILE 'Products.csv'
INTO TABLE my_Product
FIELDS TERMINATED BY ',';

CREATE TABLE my_Order
(
    order_id INT NOT NULL AUTO_INCREMENT,
    customer_id INT NOT NULL,
    order_status VARCHAR(2) NOT NULL,
    date_time DATETIME NOT NULL,
    PRIMARY KEY(order_id)
);

CREATE TABLE my_OrderItem
(
    order_item_id INT NOT NULL AUTO_INCREMENT,
    order_item_name VARCHAR(40) NOT NULL,
    order_item_status VARCHAR(2) NOT NULL,
    order_id INT NOT NULL,
    product_id INT NOT NULL,
    quantity INT NOT NULL,
    price DECIMAL(6,2) NOT NULL,
    PRIMARY KEY(order_item_id)
);
