CREATE TABLE IF NOT EXISTS reviewed (issue_date TEXT PRIMARY KEY, content TEXT NOT NULL); CREATE TABLE IF NOT EXISTS editions (issue_date TEXT PRIMARY KEY, content TEXT NOT NULL, checkpoints TEXT NOT NULL, state TEXT NOT NULL CHECK (state IN ('ready','published')), published_at TEXT); CREATE TABLE IF NOT EXISTS sources (id TEXT PRIMARY KEY, success_at TEXT NOT NULL); CREATE TABLE IF NOT EXISTS runs (id TEXT PRIMARY KEY, stage TEXT NOT NULL, issue_date TEXT NOT NULL, started_at TEXT NOT NULL, finished_at TEXT, outcome TEXT NOT NULL, details TEXT NOT NULL DEFAULT ''); CREATE INDEX IF NOT EXISTS ix_runs_started ON runs(started_at); CREATE TABLE IF NOT EXISTS source_runs (run_id TEXT NOT NULL, source_id TEXT NOT NULL, outcome TEXT NOT NULL, checked_at TEXT NOT NULL, discovered INTEGER NOT NULL DEFAULT 0, details TEXT NOT NULL DEFAULT '', PRIMARY KEY(run_id,source_id)); CREATE TABLE IF NOT EXISTS stories (id TEXT NOT NULL, issue_date TEXT NOT NULL, section TEXT NOT NULL, url TEXT NOT NULL, story TEXT NOT NULL, PRIMARY KEY(issue_date,id)); CREATE INDEX IF NOT EXISTS ix_stories_date ON stories(issue_date);