drop table Parts
drop table Lines
drop table Customers
drop table Sales

CREATE TABLE Parts ("PartNumber" VARCHAR(255), "Description" VARCHAR(255), "Price" VARCHAR(255))
CREATE TABLE Lines ("SalesOrderID" integer, "LineNumber" VARCHAR(255), "PartNumber" VARCHAR(255),"Quantity" VARCHAR(255))
CREATE TABLE Customers ("CustomerID" integer, "Name" VARCHAR(255), "Street" VARCHAR(255), "City" VARCHAR(255), "State" VARCHAR(255), "PostalCode" VARCHAR(255))
CREATE TABLE Sales ("SalesOrderID" integer, "OrderDate" datetime, "CustomerID" integer)