oficina / home Public

Download this file

1	CREATE TABLE home_identity_links (
2	issuer TEXT NOT NULL,
3	subject TEXT NOT NULL,
4	person_id INTEGER NOT NULL,
5	PRIMARY KEY (issuer, subject),
6	UNIQUE (issuer, person_id)
7	);
8	CREATE TABLE home_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 home_link_flows_expiry ON home_link_flows(expires_at);
15	CREATE TABLE home_link_clock (
16	id INTEGER PRIMARY KEY CHECK (id = 1),
17	high_water INTEGER NOT NULL
18	);
19	INSERT INTO home_link_clock (id, high_water) VALUES (1, 0);
20