Database and schema changes reference
This reference list identifies changes to the database and schema from 3.11.15 to present. For older releases refer to the release notes.
3.51.6
Indexes were added to the SupplierList and Alias tables in the store database to improve performance when downloading items to stores using Worksheet 261. The indexes have been added to the Force Install Tables function
Store Manager
SupplierList, Alias
3.51.6
Indexes were added to the WorksheetStoreJob, Worksheet_ItemUpdate, and GlobalCatalog tables to improve performance when downloading items to stores using Worksheet 261. The indexes have been added to the Force Install Tables function
Central Manager
WorksheetStoreJob, Worksheet_ItemUpdate, GlobalCatalog
3.51.6
A script was added to Force Install Tables to remove the HQRecordDeleteLog trigger from several tables
Central Manager
Worksheet_DelGlobalCustomers, Worksheet_GlobalAccountAdjustment, Worksheet_InventoryTransfer, Worksheet_ItemBlockSales, Worksheet_ItemCost, Worksheet_ItemDiscount, Worksheet_ItemPrice, Worksheet_ItemPriceLevel, Worksheet_ItemPriceLimit, Worksheet_ItemQuantity, Worksheet_ItemRestock, Worksheet_ItemTax, Worksheet_ItemUpdate, Worksheet_POLaterDisburse, Worksheet_PuchaseOrder, Worksheet_SalePrices, Worksheet_SQL, Worksheet_SupplierList, Worksheet_SupplierUpdate, WorksheetHeader_MasterPO, WorksheetHeader_PurchaseOrder, WorksheetHistory, WorksheetStore, WorksheetStoreJob, WorksheetUpdateItemPrices
3.51.5
A script was added to Force Install Tables to create a new table called RMH_StoreUserPasswordHistory
Central Manager
RMH_StoreUserPasswordHistory
3.51.5
A script was added to Force Install Tables to increase the number of digits allowed for UnitOfMeasure from 4 to 10
Store Manager/ Central Manager
Item.UnitOfMeasure
3.51.5
A script was added to Force Install Tables to create a new table called RMH_CentralUserPasswordHistory
Central Manager
RMH_CentralUserPasswordHistory
3.51.5
A script was added to Force Install Tables to add new columns to the HQConfiguration table to save password policy settings for Central users
Central Manager
HQConfiguration
3.51.5
A script was added to Force Install Tables to add new columns to the HQUser table to flag a password for reset and to record the last reset date
Central Manager
HQUser
3.51.5
A script was added to Force Install Tables to update the WorksheetStoreJob table to remove the HQRecordDeletedLog trigger
Central Manager
WorksheetStoreJob
3.51.5
A script was added to Force Install Tables to create a new column WorksheetRecordID2 in WorksheetStoreJob table
Central Manager
WorksheetStoreJob
3.51.5
The InventoryTransferLogInserted trigger has been removed from the InventoryTransferLog table The TransactionEntryInserted trigger has been removed from the TransactionEntry table
Central Manager
InventoryTransferLog, TransactionEntry
3.50.17
A script was added to Force Install Tables to create non-cluster indexes in the TransactionEntry and TaxEntry tables
Store Manager
TransactionEntry, TaxEntry
3.50.4
A script was added to delete the column ConfigurationExt.RandomWeightXmlData and copy values to the ConfigurationExt.XmlData column
Store Manager
Configuration
3.11.19
An index was added to the Transaction table in the store database to improve performance in POS when recalling transactions for returns. The index has been added to the Force Install Tables function
Central Manager/ Store Manager
Transaction
3.11.15
Force Install Tables will no longer create the SYNCGUID column in the RMH or third party app tables
Central Manager/ Store Manager
3.11.15
Prepare Database will create the SYNCGUID column in the RMH table, but it will no longer create it in third party app tables
Central Manager/ Store Manager
Last updated