oficina / home Public

Download this file

1	CREATE TABLE directory_operator_state (
2	singleton INTEGER PRIMARY KEY CHECK(singleton=1),
3	origin TEXT NOT NULL,
4	installation TEXT NOT NULL,
5	registry TEXT NOT NULL,
6	device TEXT NOT NULL,
7	sequence INTEGER NOT NULL CHECK(typeof(sequence)='integer' AND sequence>0),
8	head TEXT NOT NULL CHECK(length(head)=43),
9	completed_at INTEGER NOT NULL CHECK(typeof(completed_at)='integer' AND completed_at>0)
10	);
11	CREATE TABLE directory_operator_results (
12	operation_id TEXT PRIMARY KEY CHECK(length(operation_id)=43),
13	action TEXT NOT NULL,
14	sequence INTEGER NOT NULL UNIQUE CHECK(typeof(sequence)='integer' AND sequence>0),
15	authorization_head TEXT NOT NULL CHECK(length(authorization_head)=43),
16	request_mac BLOB NOT NULL CHECK(typeof(request_mac)='blob' AND length(request_mac)=32),
17	sealed_result BLOB NOT NULL CHECK(typeof(sealed_result)='blob' AND length(sealed_result) BETWEEN 29 AND 49180),
18	completed_at INTEGER NOT NULL CHECK(typeof(completed_at)='integer' AND completed_at>0)
19	);
20