summaryrefslogtreecommitdiffstats
path: root/db/old_migrations/patch-add-other-auth.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/old_migrations/patch-add-other-auth.sql')
-rw-r--r--db/old_migrations/patch-add-other-auth.sql18
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;