Create Table "Payments Database" ( PRIMARY KEY (PaymentID, StoreID), PaymentID Integer, StoreId Integer, CustomerID Integer, OrderID Integer, PaymentAmount Money, EnteredByID Integer, PaymentDate TimeStamp, PaymentMethod Char(12), PaymentMethodType Integer, TrackingNumber Char(20), CreditCardExpDate Date, Voided Boolean, VoidDate TimeStamp, VoidAmount Money, Reason Char(40), PaymentOnOrder Boolean, Refund Boolean, TakenForStoreId Integer, TakenForOrderID Integer, TakenForCustomerInfo Blob(1), IsCCEncrypted Boolean, CCNumber Char(30), Vcode Char(10), NameOnCard Char(50), TroutD Char(25), ProcessID Integer, ModifiedByComputer Char(25), ModifiedDate TimeStamp, CCCSCustomerGuid Char(50), CCCSTransactionGuid Char(50) ) ; CREATE INDEX CustomerIndex ON "Payments Database" (CustomerID) ; CREATE INDEX OrderIndex ON "Payments Database" (OrderID) ; CREATE INDEX ModifiedDateIndex ON "Payments Database" (ModifiedDate) ; CREATE INDEX PaymentDateIndex ON "Payments Database" (PaymentDate) ;