pr_01m47d15m3e54sn21z27rpy5n9/services/work/migrations/0011_agent_messages.sql
Pick any line to see why it is the way it is: the commit, the pull request and issue it came from, and what the agent was thinking.
| Usage, like a hosting provider's: what agents cost, per day, task, repository and pull request | 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); |