update depedencies, changes to support updated authentication-module

[squeep-indie-auther] / src / db / postgres / sql / schema / 1.2.0 / apply.sql

diff --git a/src/db/postgres/sql/schema/1.2.0/apply.sql b/src/db/postgres/sql/schema/1.2.0/apply.sql
new file mode 100644 (file)
index 0000000..f926126
--- /dev/null
+++ b/src/db/postgres/sql/schema/1.2.0/apply.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+       ALTER TABLE authentication ADD COLUMN otp_key TEXT;
+
+       -- Update schema version
+       INSERT INTO _meta_schema_version (major, minor, patch) VALUES (1, 2, 0);
+
+COMMIT;