agent
15 lines
556 B
SQL
15 lines
556 B
SQL
CREATE TABLE IF NOT EXISTS dod_items (
|
|
id TEXT PRIMARY KEY,
|
|
run_id TEXT NOT NULL,
|
|
item_key TEXT NOT NULL,
|
|
kind TEXT NOT NULL DEFAULT 'manual',
|
|
expected TEXT NOT NULL DEFAULT '',
|
|
required INTEGER NOT NULL DEFAULT 1,
|
|
status TEXT NOT NULL DEFAULT 'pending',
|
|
created_at INTEGER NOT NULL,
|
|
FOREIGN KEY (run_id) REFERENCES runs(id) ON DELETE CASCADE
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_dod_items_run ON dod_items(run_id);
|
|
CREATE INDEX IF NOT EXISTS idx_dod_items_status ON dod_items(status);
|