8 lines
298 B
SQL
8 lines
298 B
SQL
CREATE INDEX events_summary ON events(task_id, seq) WHERE kind = 'turn.ended' AND json_extract(payload, '$.summary') = 1;
|
|
CREATE TABLE summary_reads (
|
|
login TEXT NOT NULL REFERENCES users(login),
|
|
task_id TEXT NOT NULL REFERENCES tasks(id),
|
|
seq INTEGER NOT NULL,
|
|
PRIMARY KEY (login, task_id)
|
|
);
|