diff options
| author | Fuwn <[email protected]> | 2026-03-28 06:20:36 +0000 |
|---|---|---|
| committer | Fuwn <[email protected]> | 2026-03-28 06:20:36 +0000 |
| commit | 78bf2502cbf1e26980abf6c0ffb7f0c74b917a3b (patch) | |
| tree | 9f4a84c90fa7fcfa945f1c9e0e637ba80b9cca79 /supabase/notifications.sql | |
| parent | fix(cache): preserve hydrated client state (diff) | |
| download | due.moe-78bf2502cbf1e26980abf6c0ffb7f0c74b917a3b.tar.xz due.moe-78bf2502cbf1e26980abf6c0ffb7f0c74b917a3b.zip | |
fix(notifications): support per-device push subscriptions
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); |