summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
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
+);