Update for Adding Version Control

Here is an example showing how to update the main server application and the database. This example assumes that the server was installed as described here i.e. from HeliumManagement_20220110.exe, created with gam_create_MySQL_20201126.sql and gam_inserts_MySQL_20201126.sql.

1. Download the latest version of the Helium Management Software from the HZB cloud. The 10th of January 2022, the latest version of the binary is called HeliumManagement_20210420.exe. Stop the server and copy this file in place of the previous version.

2. Download the latest version of the MySQL installer. The 10th of January 2022, the latest version is gam_create_MySQL_20210818.sql. This file contains the following release notes after the date of the installation:

• //21.05.2021, KK: added table GAM_VERSION
• //21.05.2021, KK: added IMG_FILENAME in table GAM_IMAGE
• //18.08.2021, KK: added MEA_VALUE6 in table GAM_MEASUREMENT

3. Update the database

• Open the Command Prompt
• Enter the command C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe -u root -p followed by the root password
• Access the database with USE helium;
• Create the table GAM_VERSION as shown in the gam_create_MySQL_20210818.sql file:

CREATE TABLE GAM_VERSION(  
  VER_ID	MEDIUMINT not null AUTO_INCREMENT,  
  VER_MAJOR	MEDIUMINT not null,  
  VER_MINOR	MEDIUMINT not null,  
  VER_DATE	DATETIME not nulll,  
  VER_COMMENT	VARCHAR(1000),  
  CONSTRAINT VER_ID_PK PRIMARY KEY (VER_ID));

• Add the field IMG_FILENAME in the table GAM_IMAGE:

ALTER TABLE GAM_IMAGE ADD ( IMG_FILENAME VARCHAR(200) NOT NULL );

• Add the field MEA_VALUE6 in the table GAM_MEASUREMENT:

ALTER TABLE GAM_MEASUREMENT ADD ( MEA_VALUE6 DECIMAL(12,3) );

4. Add a first version in the database

The first version is called 1.1 and inserted into the GAM_VERSION table with:

INSERT INTO GAM_VERSION (VER_ID, VER_MAJOR, VER_MINOR, VER_DATE, VER_COMMENT) VALUES (2, 1, 1, SYSDATE(), '18.08.2021, KK, necessary changes for levelmeter resistance readout: added field MEA_VALUE6 in table GAM_MEASUREMENT');

5. Restart the server and check from Help / About that its version is 2.9.14.0. You should now have a VersionControl menu from which you can check that the GAM database is in version 1.1.