Create Table "Adjustment Database" ( PRIMARY KEY (AdjustmentID, StoreID), AdjustmentID Integer, StoreId Integer, OrderId Integer, CustomerID Integer, EstimateID Integer, AdjustmentDate TimeStamp, AdjustedBy Integer, Amount Money, Reason Char(50), ReasonCode Char(50), Orderstatus Char(12), ModifiedByComputer Char(25), ModifiedDate TimeStamp, CurrentState Integer ) ; CREATE INDEX CustomerIndex ON "Adjustment Database" (CustomerID) ; CREATE INDEX OrderIDIndex ON "Adjustment Database" (OrderID, StoreID, AdjustmentDate) ; CREATE INDEX ModifiedDateIndex ON "Adjustment Database" (ModifiedDate) ;