apps/diffinery/migrations/0012_repo_activity.sql at a5e35b1b9462c965a777c04b03556ee322fa0ba9 · codician/diffinery · Diffinery

1 -- When each repository last had pull request, review, push, run or release activity
2 -- (agentic/today.ts). The Today view visits the recently active repositories first;
3 -- repos.pushed_at alone misses work done through the API and MCP.
4 CREATE TABLE repo_activity (
5   repo_id TEXT PRIMARY KEY,
6   at TEXT NOT NULL
7 );
8 CREATE INDEX repo_activity_at ON repo_activity(at);
1	-- When each repository last had pull request, review, push, run or release activity
2	-- (agentic/today.ts). The Today view visits the recently active repositories first;
3	-- repos.pushed_at alone misses work done through the API and MCP.
4	CREATE TABLE repo_activity (
5	repo_id TEXT PRIMARY KEY,
6	at TEXT NOT NULL
7	);
8	CREATE INDEX repo_activity_at ON repo_activity(at);