oficina / docs Public

Download this file

1	CREATE TABLE docs_identity_links (
2	issuer TEXT NOT NULL,
3	subject TEXT NOT NULL,
4	person_id INTEGER NOT NULL REFERENCES people(id),
5	PRIMARY KEY (issuer, subject),
6	UNIQUE (issuer, person_id)
7	);
8	CREATE TABLE docs_link_flows (
9	id_hash TEXT PRIMARY KEY NOT NULL,
10	stage TEXT NOT NULL CHECK (stage IN ('init', 'pending')),
11	expires_at INTEGER NOT NULL,
12	payload BLOB NOT NULL
13	);
14	CREATE INDEX docs_link_flows_expiry ON docs_link_flows(expires_at);
15	CREATE TABLE docs_link_clock (
16	id INTEGER PRIMARY KEY CHECK (id = 1),
17	high_water INTEGER NOT NULL
18	);
19	INSERT INTO docs_link_clock (id, high_water) VALUES (1, 0);
20