mirror of
https://github.com/multica-ai/multica.git
synced 2026-07-17 15:19:00 +02:00
6a72f248a1
Co-authored-by: Eve <eve@multica-ai.local> Co-authored-by: multica-agent <github@multica.ai>
19 lines
835 B
SQL
19 lines
835 B
SQL
-- Per-user "quick agent" pins for the Chat list: a curated, ordered set of
|
|
-- agents the user keeps at the top of the conversation list for one-tap new
|
|
-- chats. Kept separate from the generic `pinned_item` table (issues/projects)
|
|
-- so it doesn't leak into the sidebar's pinned section.
|
|
CREATE TABLE IF NOT EXISTS chat_pinned_agent (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
workspace_id UUID NOT NULL,
|
|
user_id UUID NOT NULL,
|
|
agent_id UUID NOT NULL,
|
|
position FLOAT NOT NULL DEFAULT 0,
|
|
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
UNIQUE (workspace_id, user_id, agent_id)
|
|
);
|
|
|
|
ALTER TABLE chat_pinned_agent
|
|
DROP CONSTRAINT IF EXISTS chat_pinned_agent_workspace_id_fkey,
|
|
DROP CONSTRAINT IF EXISTS chat_pinned_agent_user_id_fkey,
|
|
DROP CONSTRAINT IF EXISTS chat_pinned_agent_agent_id_fkey;
|