flagon-io/g1t

public

Where people and agents ship software together. The open-source git platform for the whole job: issues, agents, checks and deploys to the edge.

1	-- Pending coordination updates are independent of transcript pagination.
2	CREATE TABLE session_updates (
3	id TEXT NOT NULL,
4	session_id TEXT NOT NULL REFERENCES sessions(id) ON DELETE CASCADE,
5	kind TEXT NOT NULL,
6	data TEXT NOT NULL,
7	at TEXT NOT NULL,
8	acknowledged_at TEXT,
9	PRIMARY KEY (session_id, id)
10	);
11	CREATE INDEX session_updates_pending ON session_updates(session_id, acknowledged_at, at, id);