CREATE TABLE my_OrderItems
(
    order_item_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    order_item_name VARCHAR(255) 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
);