.Upgrade Guide v13.5.2

This guide is valid for the following wallboard release

1. Stop the current release services by executing the following command inside the current-release-deployment-dir/wallboard/ directory. 

   docker-compose down

2. Open docker-compose.yml file in current-release-deployment-dir/wallboard/docker directory and update the queue-service & synchronizer docker images

   gitlab.expertflow.com:9242/wallboards-dashboards/wallboard-microservices/queue-backend:13.3.4.queue
   gitlab.expertflow.com:9242/wallboards-dashboards/synchronizer:13.6.1   

3. Run the following commands on the wallboard database in SQL Server Management Studio.

   delete from queue_stats_historical_ccx
   
   Alter table queue_stats_historical_ccx
   add session_seq_num smallint NOT NULL,profile_id int NOT NULL,node_id smallint NOT NULL,target_id int NOT NULL,target_type smallint NOT NULL,q_index smallint NOT NULL
   
   ALTER TABLE queue_stats_historical_ccx
   ADD CONSTRAINT ccx_unique_rec UNIQUE (session_id,session_seq_num,profile_id,node_id,target_id,target_type,q_index);

4. Execute the following commands inside the current-release-deployment-dir/wallboard/ directory.

   ./install.sh

5. Run the following command to ensure that all the components are up and running.

   docker ps