cZ3L255q

1CREATE TABLE admin (key TEXT PRIMARY KEY NOT NULL, value INTEGER NOT NULL);
2CREATE TABLE policies (	id		INTEGER	NOT NULL PRIMARY KEY, 	bundle_id	TEXT	NOT NULL, 	uuid		TEXT	NOT NULL, 	display		TEXT	NOT NULL, 	UNIQUE (bundle_id, uuid));
3CREATE TABLE active_policy (	client		TEXT	NOT NULL, 	client_type	INTEGER	NOT NULL, 	policy_id	INTEGER NOT NULL, 	PRIMARY KEY (client, client_type), 	FOREIGN KEY (policy_id) REFERENCES policies(id) ON DELETE CASCADE ON UPDATE CASCADE);
4CREATE TABLE access_overrides (	service		TEXT	NOT NULL PRIMARY KEY);
5CREATE TABLE IF NOT EXISTS "access" (    service        TEXT        NOT NULL,     client         TEXT        NOT NULL,     client_type    INTEGER     NOT NULL,     allowed        INTEGER     NOT NULL,     prompt_count   INTEGER     NOT NULL,     csreq          BLOB,     policy_id      INTEGER,     indirect_object_identifier_type    INTEGER,     indirect_object_identifier         TEXT DEFAULT 'UNUSED',     indirect_object_code_identity      BLOB,     flags          INTEGER,     last_modified  INTEGER     NOT NULL DEFAULT (CAST(strftime('%s','now') AS INTEGER)),     PRIMARY KEY (service, client, client_type, indirect_object_identifier),    FOREIGN KEY (policy_id) REFERENCES policies(id) ON DELETE CASCADE ON UPDATE CASCADE);
6CREATE TABLE expired (    service        TEXT        NOT NULL,     client         TEXT        NOT NULL,     client_type    INTEGER     NOT NULL,     csreq          BLOB,     last_modified  INTEGER     NOT NULL ,     expired_at     INTEGER     NOT NULL DEFAULT (CAST(strftime('%s','now') AS INTEGER)),     PRIMARY KEY (service, client, client_type));
7CREATE INDEX active_policy_id ON active_policy(policy_id);