5 lines
274 B
SQL
5 lines
274 B
SQL
ALTER TABLE notifications ADD COLUMN IF NOT EXISTS context_id UUID;
|
|
ALTER TABLE notifications ADD COLUMN IF NOT EXISTS context_type VARCHAR(50);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_notifications_context ON notifications(context_type, context_id) WHERE context_type IS NOT NULL;
|