aboutsummaryrefslogtreecommitdiff
path: root/supabase/notifications.sql
blob: 81905a2974b310447fbc8136292dc67591071508 (plain) (blame)
1
2
3
4
5
6
7
8
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);