Create Table "GL Database" ( ID Integer, StoreID Integer, DateTime TimeStamp, OrderID Integer, CustomerID Integer, RecordID Integer, AccountCode Integer, UserID Integer, Amount Money, Description Char(25), Closed Boolean, ClosedDate TimeStamp, Exported Boolean, ExportedDate TimeStamp, ExportedBatch Integer, EnteredByID Integer, SubaccountCode Integer, Taxable Boolean, Consolidated Boolean, Category Integer, RoyaltyGroupID Integer, ModifiedByComputer Char(25), ModifiedDate TimeStamp, OrderDetailID Integer, ProductID Integer, PRIMARY KEY (ID) ) ; CREATE INDEX AccountCodeIndex ON "GL Database" (AccountCode) ; CREATE INDEX OrderIndex ON "GL Database" (OrderID) ; CREATE INDEX ModifiedDateIndex ON "GL Database" (ModifiedDate) ; CREATE INDEX OrderDetailIDIndex ON "GL Database" (OrderDetailID) ; CREATE INDEX ProductIDIndex ON "GL Database" (ProductID) ;