summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorKit La Touche <kit@transneptune.net>2025-07-24 14:47:04 -0400
committerKit La Touche <kit@transneptune.net>2025-07-24 14:47:04 -0400
commitfe417916f8ada1147d79cd62cec183a640300d1d (patch)
tree8082a305bb63fe4e310089f148f70ddf69af548e /migrations
parente239605b5128bdaf1a9ccf24223b6c698844de5e (diff)
Shovel a pile of database-esque code together
Diffstat (limited to 'migrations')
-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,
+);
+