mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-16 22:59:04 +02:00
Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
7 lines
439 B
SQL
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;
|