SQL scripts for 1.2.4679

As part of the installation procedures for the web application, the system will execute a number of SQL scripts that create or update database table structures, stored procedures and set mandatory data in certain tables.

However, at times these SQL scripts do not execute correctly during the installation which creates random errors in the application. This can be resolved by manually executing the scripts directly from Microsoft SQL Studio.

It is important to note that the scripts are specific to the version of the web application being used. Running the scripts against a database with a different version of the web application installed can in itself create further issues.

In the attached zip file there are four SQL script files, numbered one through four. It is important that all the scripts files are run and that they are run in the correct order.