OXYGENHUB
◆ main oxygenhub / crates / hub / migrations / 0096_finished_column.sql
358 B · SQL · last changed Finished work moves to Done 10 days ago source blame history raw
1000b40a Andy McCall ↶ 1
-- A board's column for finished work (#325): a card whose issue closes, or
2
-- whose proposal lands or closes, moves there. One per board at most; a
3
-- board's column named Done takes it to begin with.
4
ALTER TABLE project_columns ADD COLUMN takes_finished INTEGER NOT NULL DEFAULT 0;
5
UPDATE project_columns SET takes_finished = 1 WHERE lower(name) = 'done';