X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fsqlite%2Fsql%2Fschema%2Finit.sql;fp=src%2Fdb%2Fsqlite%2Fsql%2Fschema%2Finit.sql;h=8e2a475f8d17d43946e060e08cdf6da95964aa21;hp=0000000000000000000000000000000000000000;hb=b0103b0d496262c438b40bc20304081dbfe41e73;hpb=8ed81748bce7cea7904cac7225b20a60cafdfc16

diff --git a/src/db/sqlite/sql/schema/init.sql b/src/db/sqlite/sql/schema/init.sql
new file mode 100644
index 0000000..8e2a475
--- /dev/null
+++ b/src/db/sqlite/sql/schema/init.sql
@@ -0,0 +1,11 @@
+--
+BEGIN;
+	CREATE TABLE _meta_schema_version (
+		major INTEGER NOT NULL CHECK (typeof(major) = 'integer'),
+		minor INTEGER NOT NULL CHECK (typeof(minor) = 'integer'),
+		patch INTEGER NOT NULL CHECK (typeof(patch) = 'integer'),
+		applied INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) CHECK (typeof(applied) = 'integer'),
+		PRIMARY KEY (major DESC, minor DESC, patch DESC)
+	) WITHOUT ROWID;
+	INSERT INTO _meta_schema_version (major, minor, patch) VALUES (0, 0, 0);
+COMMIT;