diff options
Diffstat (limited to 'supabase/notifications.sql')
| -rw-r--r-- | supabase/notifications.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/supabase/notifications.sql b/supabase/notifications.sql new file mode 100644 index 00000000..81905a29 --- /dev/null +++ b/supabase/notifications.sql @@ -0,0 +1,9 @@ +ALTER TABLE public.user_notifications + DROP CONSTRAINT IF EXISTS user_notifications_user_id_key; + +ALTER TABLE public.user_notifications + DROP CONSTRAINT IF EXISTS user_notifications_user_id_fingerprint_key; + +ALTER TABLE public.user_notifications + ADD CONSTRAINT user_notifications_user_id_fingerprint_key + UNIQUE (user_id, fingerprint); |