Skip to content

g1t/services/projects/migrations/0009_activity.sql

6 lines344 bytesCodeBlame
1-- When a project's repository was last pushed to, and how active it is
2-- lately, so a workspace's projects sort by either (src/activity.ts).
3-- Null and 0 until something happens.
4ALTER TABLE projects ADD COLUMN pushed_at TEXT;
5ALTER TABLE projects ADD COLUMN active_at TEXT;
6ALTER TABLE projects ADD COLUMN activity REAL NOT NULL DEFAULT 0;