1 files changed, 12 insertions, 0 deletions
diff --git a/migrations/20251009021241_push_subscriptions.sql b/migrations/20251009021241_push_subscriptions.sql
new file mode 100644
index 0000000..b42d122
--- /dev/null
+++ b/migrations/20251009021241_push_subscriptions.sql
@@ -0,0 +1,12 @@
+create table push_subscription (
+    endpoint text
+        primary key
+        not null,
+    token text
+        not null
+        references token (id),
+    p256dh text
+        not null,
+    auth text
+        not null
+);