db/old_migrations/patch-add-other-auth.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

BEGIN TRANSACTION;

  ALTER TABLE monitor
      ADD auth_method VARCHAR(250);

  ALTER TABLE monitor
      ADD auth_domain TEXT;
  ALTER TABLE monitor

      ADD auth_workstation TEXT;

COMMIT;

BEGIN TRANSACTION;
  UPDATE monitor
        SET auth_method = 'basic'
        WHERE basic_auth_user is not null;
COMMIT;