CREATE TABLE work_items ( run_id TEXT NOT NULL, kind TEXT NOT NULL, section TEXT NOT NULL, item TEXT NOT NULL, body TEXT NOT NULL, created_at TEXT NOT NULL, PRIMARY KEY(run_id,kind,item) ); CREATE INDEX ix_work_items_date ON work_items(created_at);