schema_version

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Lock version upgraded
1 1 X 94 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE schema_version(
    Lock CHAR(1) NOT NULL DEFAULT 'X' UNIQUE,  -- Makes sure this table only has one row.
    version INTEGER NOT NULL,
    upgraded BOOL NOT NULL,  -- Whether we reached this version from an upgrade or an initial schema.
    CHECK (Lock='X')
);