summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorOwen Jacobson <owen@grimoire.ca>2025-07-24 22:32:27 -0400
committerOwen Jacobson <owen@grimoire.ca>2025-07-24 22:32:27 -0400
commitb63380b251d04dd92f06aa5bbc22a72ca3e4bf8e (patch)
tree3956ec457131ce049fd91f2f53309bc0620fffe2 /migrations
parent2e42057694851b82574e0a406ded429fb95a07fa (diff)
wip: 83B78D40-D7CB-4419-9FE7-E7D858909443
Diffstat (limited to 'migrations')
-rw-r--r--migrations/20250724_subscription.sql17
-rw-r--r--migrations/20250725023155_push_notification.sql15
2 files changed, 15 insertions, 17 deletions
diff --git a/migrations/20250724_subscription.sql b/migrations/20250724_subscription.sql
deleted file mode 100644
index 368557a..0000000
--- a/migrations/20250724_subscription.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-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,
- expiration_time text,
-);
-
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
+);