pulls/pr_01m47d15m3e54sn21z27rpy5n9

public

pr_01m47d15m3e54sn21z27rpy5n9/services/work/migrations/0012_exchanges.sql

10 lines652 bytesCode Blame

1	-- Agents asking each other: a question or a handoff from the agent on one
2	-- pull request to the agent on another, and the answer, which goes back.
3	ALTER TABLE agent_messages ADD COLUMN kind TEXT NOT NULL DEFAULT 'message';
4	ALTER TABLE agent_messages ADD COLUMN repo_id TEXT;
5	ALTER TABLE agent_messages ADD COLUMN from_number INTEGER;
6	ALTER TABLE agent_messages ADD COLUMN to_number INTEGER;
7	ALTER TABLE agent_messages ADD COLUMN answer TEXT;
8	ALTER TABLE agent_messages ADD COLUMN answered_at TEXT;
9	ALTER TABLE agent_messages ADD COLUMN declined INTEGER NOT NULL DEFAULT 0;
10	CREATE INDEX agent_messages_by_repo ON agent_messages (repo_id, created_at);