Files
multica/server/migrations/035_project_priority.up.sql
Bohan Jiang 245beed829 feat(projects): add priority attribute to projects (#565)
Add priority field (urgent/high/medium/low/none) to projects, matching
the existing issue priority system. Includes database migration, API
support for create/update/list filtering, and UI for the create dialog,
project list table, and project detail page.
2026-04-09 16:31:05 +08:00

3 lines
138 B
SQL

ALTER TABLE project ADD COLUMN priority TEXT NOT NULL DEFAULT 'none'
CHECK (priority IN ('urgent', 'high', 'medium', 'low', 'none'));