1CREATE TABLE maintainer (
2    id INTEGER PRIMARY KEY,
3    namespace TEXT NOT NULL,
4    maintainer TEXT NULL
5);
6
7CREATE TABLE revision (
8    page TEXT NOT NULL,
9    rev INTEGER NOT NULL,
10    ready_for_approval TEXT NULL,
11    ready_for_approval_by TEXT NULL,
12    approved TEXT NULL,
13    approved_by TEXT NULL,
14    version INTEGER NULL,
15    current BOOLEAN NOT NULL DEFAULT 0,
16    PRIMARY KEY (page, rev)
17);
18
19CREATE TABLE page (
20    page TEXT PRIMARY KEY,
21    maintainer TEXT NULL,
22    hidden BOOLEAN NOT NULL DEFAULT 0
23);
24
25CREATE TABLE config (
26    key TEXT PRIMARY KEY,
27    value TEXT NULL
28);
29
30CREATE INDEX idx_revision_current
31    ON revision (current, page, rev, ready_for_approval, approved, version);
32
33CREATE INDEX idx_page_maintainer
34    ON page (maintainer, page, hidden);
35