diff options
Diffstat (limited to 'db/old_migrations/patch-add-other-auth.sql')
-rw-r--r-- | db/old_migrations/patch-add-other-auth.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/db/old_migrations/patch-add-other-auth.sql b/db/old_migrations/patch-add-other-auth.sql new file mode 100644 index 0000000..b83f1ee --- /dev/null +++ b/db/old_migrations/patch-add-other-auth.sql @@ -0,0 +1,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; |