git.squeep.com Git - squeep-indie-auther/blob - src/db/sqlite/sql/schema/init.sql

   1 --
   2 BEGIN;
   3         CREATE TABLE _meta_schema_version (
   4                 major INTEGER NOT NULL CHECK (typeof(major) = 'integer'),
   5                 minor INTEGER NOT NULL CHECK (typeof(minor) = 'integer'),
   6                 patch INTEGER NOT NULL CHECK (typeof(patch) = 'integer'),
   7                 applied INTEGER NOT NULL DEFAULT (strftime('%s', 'now')) CHECK (typeof(applied) = 'integer'),
   8                 PRIMARY KEY (major DESC, minor DESC, patch DESC)
   9         ) WITHOUT ROWID;
  10         INSERT INTO _meta_schema_version (major, minor, patch) VALUES (0, 0, 0);
  11 COMMIT;