From fe417916f8ada1147d79cd62cec183a640300d1d Mon Sep 17 00:00:00 2001
From: Kit La Touche <kit@transneptune.net>
Date: Thu, 24 Jul 2025 14:47:04 -0400
Subject: Shovel a pile of database-esque code together

---
 migrations/20250724_subscription.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 migrations/20250724_subscription.sql

(limited to 'migrations/20250724_subscription.sql')

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

