1drop table Parts
2drop table Lines
3drop table Customers
4drop table Sales
5
6CREATE TABLE Parts ("PartNumber" VARCHAR(255), "Description" VARCHAR(255), "Price" VARCHAR(255))
7CREATE TABLE Lines ("SalesOrderID" integer, "LineNumber" VARCHAR(255), "PartNumber" VARCHAR(255),"Quantity" VARCHAR(255))
8CREATE TABLE Customers ("CustomerID" integer, "Name" VARCHAR(255), "Street" VARCHAR(255), "City" VARCHAR(255), "State" VARCHAR(255), "PostalCode" VARCHAR(255))
9CREATE TABLE Sales ("SalesOrderID" integer, "OrderDate" datetime, "CustomerID" integer)
10