CREATE TABLE IF NOT EXISTS my_orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    order_status VARCHAR(10),
    order_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT fk_cust_id FOREIGN KEY (customer_id) REFERENCES my_customers(customer_id)
);

CREATE TABLE IF NOT EXISTS my_order_items (
    order_item_id INT AUTO_INCREMENT PRIMARY KEY,
    order_item_name VARCHAR(100) NOT NULL,
    order_item_status VARCHAR(10), 
    order_id INT NOT NULL,
    product_id INT NOT NULL,
    quantity INT NOT NULL DEFAULT 1,
    price DECIMAL(10, 2) NOT NULL,
    CONSTRAINT fk_order_id FOREIGN KEY (order_id) REFERENCES my_orders(order_id),
    CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES my_products(product_id)
);