pkg/database/sql/000_init.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE TABLE schema_version (
  version INTEGER NOT NULL
) STRICT;

CREATE TABLE states (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  data BLOB NOT NULL,
  lock TEXT
) STRICT;
CREATE UNIQUE INDEX states_name on states(name);