Files
multica/server/migrations/155_chat_session_pinned.up.sql
Multica Eve 6a72f248a1 fix: unblock release migrations (#5162)
Co-authored-by: Eve <eve@multica-ai.local>
Co-authored-by: multica-agent <github@multica.ai>
2026-07-09 17:59:19 +08:00

7 lines
439 B
SQL

-- Per-conversation pin for the Chat list: a user can pin a chat so it stays
-- at the top of their conversation list, above the activity-sorted rest.
-- `pinned_at` doubles as the sort key within the pinned group (most-recently
-- pinned first) and as the boolean flag (NULL = not pinned). Sessions are
-- already per-creator, so no extra user dimension is needed.
ALTER TABLE chat_session ADD COLUMN IF NOT EXISTS pinned_at TIMESTAMPTZ;