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

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