git.squeep.com Git - websub-hub/blob - src/db/sqlite/sql/schema/init.sql

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