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 approved TEXT NULL, 12 version INTEGER NULL, 13 current BOOLEAN NOT NULL DEFAULT 0, 14 PRIMARY KEY (page, rev) 15); 16 17CREATE TABLE page ( 18 page TEXT PRIMARY KEY, 19 maintainer TEXT NULL, 20 hidden BOOLEAN NOT NULL DEFAULT 0 21); 22 23CREATE TABLE config ( 24 key TEXT PRIMARY KEY, 25 value TEXT NULL 26); 27 28CREATE INDEX idx_revision_current 29 ON revision (current, page, rev, ready_for_approval, approved, version); 30 31CREATE INDEX idx_page_maintainer 32 ON page (maintainer, page, hidden);