Skip to content
Snippets Groups Projects

Add missing migrations

+ 23
0
@@ -846,6 +846,29 @@ databaseChangeLog:
referencedColumnNames: id
referencedTableName: lab
validate: true
- changeSet:
id: update-jitsi-direction-modes
author: Ruben Backx
changes:
- sql:
comment: Set all existing online labs to JITSI online mode
sql: insert into lab_online_modes (lab_id, online_modes) select id, 0 from lab where communication_method = 'JITSI_MEET';
- changeSet:
id: update-jitsi-direction-request-modes-1
author: Ruben Backx
changes:
- sql:
comment: (MariaDB) Set all existing online requests to JITSI online mode
dbms: mariadb
sql: update lab_request as lr inner join lab as l inner join request as r on r.session_id = l.id and r.id = lr.id set lr.online_mode = 0 where l.communication_method = 'JITSI_MEET';
- changeSet:
id: update-jitsi-direction-request-modes-2
author: Ruben Backx
changes:
- sql:
comment: (PGSQL) Set all existing online requests to JITSI online mode
dbms: postgresql
sql: update lab_request as lr set online_mode = 0 from lab as l, request as r where r.session_id = l.id and r.id = lr.id and l.communication_method = 'JITSI_MEET';
- changeSet:
id: 1665319404891-M1
author: Henry Page
Loading