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.

g1t/services/work/migrations/0011_agent_messages.sql

12 lines426 bytesCode Blame

1	-- Messages people send an agent while it works on a pull request. The
2	-- sandbox takes the undelivered ones at each step of the agent's run.
3	CREATE TABLE agent_messages (
4	id TEXT PRIMARY KEY,
5	pull_id TEXT NOT NULL,
6	author_id TEXT NOT NULL,
7	author_name TEXT NOT NULL,
8	body TEXT NOT NULL,
9	created_at TEXT NOT NULL,
10	delivered_at TEXT
11	);
12	CREATE INDEX agent_messages_by_pull ON agent_messages (pull_id, created_at);