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

/* create the my_orders table */
CREATE TABLE my_orders(
    order_id INT NOT NULL AUTO_INCREMENT,
    customer_id INT NOT NULL,
    order_status VARCHAR(15) NOT NULL,
    order_date_time DATETIME NOT NULL,
    PRIMARY KEY(order_id),
    FOREIGN KEY(customer_id) REFERENCES my_customers(customer_id)
);