Files
CRM_ENVR/database/migrations/014_notifications_context.sql
2026-06-26 16:38:18 +02:00

6 lines
221 B
SQL

ALTER TABLE notifications
ADD COLUMN IF NOT EXISTS context_id UUID,
ADD COLUMN IF NOT EXISTS context_type VARCHAR(50);
CREATE INDEX IF NOT EXISTS idx_notifications_context ON notifications(context_type, context_id);