summaryrefslogtreecommitdiffstats
path: root/db/old_migrations/patch-2fa.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/old_migrations/patch-2fa.sql')
-rw-r--r--db/old_migrations/patch-2fa.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db/old_migrations/patch-2fa.sql b/db/old_migrations/patch-2fa.sql
new file mode 100644
index 0000000..35069d8
--- /dev/null
+++ b/db/old_migrations/patch-2fa.sql
@@ -0,0 +1,10 @@
+-- You should not modify if this have pushed to Github, unless it does serious wrong with the db.
+BEGIN TRANSACTION;
+
+ALTER TABLE user
+ ADD twofa_secret VARCHAR(64);
+
+ALTER TABLE user
+ ADD twofa_status BOOLEAN default 0 NOT NULL;
+
+COMMIT;