1 files changed, 17 insertions, 0 deletions
diff --git a/migrations/20250829220738_vapid_keys.sql b/migrations/20250829220738_vapid_keys.sql
new file mode 100644
index 0000000..64f4295
--- /dev/null
+++ b/migrations/20250829220738_vapid_keys.sql
@@ -0,0 +1,17 @@
+create table vapid_signing_key (
+    key blob
+        not null
+);
+
+create unique index vapid_signing_key_singleton
+    on vapid_signing_key (0);
+
+create table vapid_key (
+    changed_at text
+        not null,
+    changed_sequence bigint
+        not null
+);
+
+create unique index vapid_key_singleton
+    on vapid_key (0);