wip: 83B78D40-D7CB-4419-9FE7-E7D858909443

1 files changed, 15 insertions, 0 deletions

diff --git a/migrations/20250725023155_push_notification.sql b/migrations/20250725023155_push_notification.sql
new file mode 100644
index 0000000..374e152
--- /dev/null
+++ b/migrations/20250725023155_push_notification.sql
@@ -0,0 +1,15 @@
+create table subscription (
+    id text
+        not null
+        primary key,
+    user text
+        not null
+        references user (id),
+    endpoint text
+        unique
+        not null,
+    key_p256dh text
+        not null,
+    key_auth text
+        not null
+);