1CREATE TABLE IF NOT EXISTS issue_events (
2 event_id TEXT PRIMARY KEY,
3 issue_id TEXT NOT NULL,
4 hlc_ms INTEGER NOT NULL,
5 hlc_seq INTEGER NOT NULL,
6 kind TEXT NOT NULL,
7 payload TEXT NOT NULL,
8 author TEXT NOT NULL DEFAULT '',
9 created INTEGER NOT NULL
10);
11CREATE INDEX IF NOT EXISTS idx_ie_issue ON issue_events(issue_id);
12CREATE INDEX IF NOT EXISTS idx_ie_hlc ON issue_events(hlc_ms, hlc_seq);
13
14CREATE TABLE IF NOT EXISTS wiki_pages (
15 title TEXT PRIMARY KEY,
16 content TEXT NOT NULL DEFAULT '',
17 author TEXT NOT NULL DEFAULT '',
18 updated INTEGER NOT NULL DEFAULT 0
19);