/* 
create_order_item_table.sql 
Table commands for table my_order_item 
*/

DROP TABLE IF EXISTS my_order_item;
CREATE TABLE my_order_item
(
  order_item_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  order_item_name VARCHAR(20) NOT NULL,
  order_item_status VARCHAR(2) NOT NULL,
  order_id INT NOT NULL,
  pdt_id NOT NULL,
  quantity INT NOT NULL,
  price DECIMAL(6,2) NOT NULL
);