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)
10 INSERT INTO _meta_schema_version (major
, minor
, patch
) VALUES (0, 0, 0);