Nicholai
d4914c1a46
Add @user, @channel, @here, and @Compass agent mentions to the conversations module. TipTap Mention extension with suggestion popup, message_mentions junction table for efficient querying, push notifications for mentioned users respecting notifyLevel preferences, and edit support with mention re-extraction. Also fix crypto.randomUUID fallback for non-secure contexts. Co-authored-by: Nicholai <nicholaivogelfilms@gmail.com>
9 lines
272 B
SQL
9 lines
272 B
SQL
CREATE TABLE `message_mentions` (
|
|
`id` text PRIMARY KEY NOT NULL,
|
|
`message_id` text NOT NULL,
|
|
`mention_type` text NOT NULL,
|
|
`target_id` text,
|
|
`created_at` text NOT NULL,
|
|
FOREIGN KEY (`message_id`) REFERENCES `messages`(`id`) ON UPDATE no action ON DELETE cascade
|
|
);
|