From b63380b251d04dd92f06aa5bbc22a72ca3e4bf8e Mon Sep 17 00:00:00 2001
From: Owen Jacobson <owen@grimoire.ca>
Date: Thu, 24 Jul 2025 22:32:27 -0400
Subject: wip: 83B78D40-D7CB-4419-9FE7-E7D858909443

---
 migrations/20250725023155_push_notification.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 migrations/20250725023155_push_notification.sql

(limited to 'migrations/20250725023155_push_notification.sql')

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
+);
-- 
cgit v1.2.3

