Introduction
This feature allows for the automatic application of SQL hotfixes to the IPOS application database for the specific version of the application database. The process is designed to ensure that each hotfix is applied only once and that the results of each application are properly recorded.

Note: This feature will only be available from version 1.2407.2.0 onwards.

Steps for Usage:
Creating the Version Directory
-> Create a new folder with the exact name of the version you want to apply the hotfixes to. For example, if the version is 1.2407.2.0, the folder must be named 1.2407.2.0

Adding SQL Files
-> Inside the folder created in the previous step, add the SQL files you want to execute.
-> IMPORTANT: Only files with the .sql extension will be executed. Any other file types (e.g., .txt, .csv) will be ignored.

Order of Execution
-> SQL files will be executed in alphabetical order. Make sure to name the files in a way that reflects the desired order of execution (e.g., 001_InitialSetup.sql, 002_AddIndexes.sql, etc.).

Execution Results
-> The results of each executed script will be recorded at the headquarters in the UpdateCommands table (to see which scripts were executed) and the UpdateCommandStores table (to see which stores the scripts were executed on). These records will include information about the store, the cash register, the execution time, and whether the execution was successful or not.