1CREATE TABLE maintainer ( 2 id INTEGER PRIMARY KEY, 3 namespace TEXT NOT NULL, 4 approver 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 INTEGER NOT NULL DEFAULT 0, 16 PRIMARY KEY (page, rev) 17); 18 19CREATE TABLE page ( 20 page TEXT PRIMARY KEY, 21 approver TEXT NULL, 22 hidden INTEGER 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 (approver, page, hidden); 35