X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.2.0%2Fapply.sql;fp=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.2.0%2Fapply.sql;h=f926126e486253bde5125fd0bcf8bd16a0c3367a;hp=0000000000000000000000000000000000000000;hb=fba42a499fe1af051b0982c1f3e8b3873c9ed2fb;hpb=e8dccf76ec2776f07eddd1ce2f1c4fc150a6f790

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
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;