#createCustomerTable.sql
#Table structure for table `my_Order` and 'my_OrderItem'
DROP TABLE IF EXISTS 'my_Order'
CREATE TABLE my_Order (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT NOT NULL,
    order_status VARCHAR(2) NOT NULL,
    order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (customer_id) REFERENCES my_Customers(customer_id)
);
DROP TABLE IF EXISTS 'my_OrderItem'
CREATE TABLE my_OrderItem (
    order_item_id INT AUTO_INCREMENT PRIMARY KEY,
    order_id INT NOT NULL,
    order_item_name VARCHAR(50) NOT NULL,
    product_id INT NOT NULL,
    quantity INT NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    order_item_status VARCHAR(2) NOT NULL,
    FOREIGN KEY (order_id) REFERENCES my_Order(order_id),
    FOREIGN KEY (product_id) REFERENCES my_Products(product_id)
);