· 6 years ago · Dec 20, 2019, 02:36 PM
1DROP TABLE IF EXISTS customerorders;
2CREATE TABLE IF NOT EXISTS customerorders (
3 OrderLineID int AUTO_INCREMENT,
4 OrderID varchar(255) NOT NULL,
5 CustomerID int,
6 StockItemID int NOT NULL,
7 Description varchar(255),
8 Quantity int NOT NULL,
9 UnitPrice decimal(18,2),
10 PRIMARY KEY (OrderLineID)
11);