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