# 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.

Release	Summary of Change	Products	Tables Impacted
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

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.rmhpos.com/releases/database-schema-changes-list.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.