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';