From 78bf2502cbf1e26980abf6c0ffb7f0c74b917a3b Mon Sep 17 00:00:00 2001
From: Fuwn <contact@fuwn.net>
Date: Sat, 28 Mar 2026 06:20:36 +0000
Subject: fix(notifications): support per-device push subscriptions

---
 supabase/schema.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'supabase/schema.sql')

diff --git a/supabase/schema.sql b/supabase/schema.sql
index 7648b7e4..9dc0934a 100644
--- a/supabase/schema.sql
+++ b/supabase/schema.sql
@@ -489,11 +489,11 @@ ALTER TABLE ONLY "public"."user_notifications"
 
 
 --
--- Name: user_notifications user_notifications_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
+-- Name: user_notifications user_notifications_user_id_fingerprint_key; Type: CONSTRAINT; Schema: public; Owner: postgres
 --
 
 ALTER TABLE ONLY "public"."user_notifications"
-    ADD CONSTRAINT "user_notifications_user_id_key" UNIQUE ("user_id");
+    ADD CONSTRAINT "user_notifications_user_id_fingerprint_key" UNIQUE ("user_id", "fingerprint");
 
 
 --
@@ -1481,4 +1481,3 @@ ALTER DEFAULT PRIVILEGES FOR ROLE "postgres" IN SCHEMA "public" GRANT SELECT,INS
 --
 
 -- \unrestrict ayCRchpk9QYAkH0FR7MzsPfEkgyq5Y02kQfarpa01RE4AwEybP0seWKhOVsHiST
-
-- 
cgit v1.2.3

