summaryrefslogtreecommitdiff
path: root/migrations/20250724_subscription.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20250724_subscription.sql')
-rw-r--r--migrations/20250724_subscription.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/migrations/20250724_subscription.sql b/migrations/20250724_subscription.sql
new file mode 100644
index 0000000..368557a
--- /dev/null
+++ b/migrations/20250724_subscription.sql
@@ -0,0 +1,17 @@
+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,
+);
+