From ae37b73d1f15ffe5c4c9a32c5de349cd746ebc48 Mon Sep 17 00:00:00 2001
From: winter
Date: Tue, 10 Dec 2024 18:29:57 +0000
Subject: cache webfinger lookups

---
 migrations/20241210_181118_create_actor_webfinger.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 migrations/20241210_181118_create_actor_webfinger.php

(limited to 'migrations/20241210_181118_create_actor_webfinger.php')

diff --git a/migrations/20241210_181118_create_actor_webfinger.php b/migrations/20241210_181118_create_actor_webfinger.php
new file mode 100644
index 0000000..6b6c497
--- /dev/null
+++ b/migrations/20241210_181118_create_actor_webfinger.php
@@ -0,0 +1,13 @@
+<?php
+
+use \Digitigrade\Db\Migrator;
+
+Migrator::getInstance()->register(20241210_181118, function (PDO $db) {
+    // webfinger lookup cache for actors
+    $db->exec(<<<END
+    CREATE TABLE actor_webfinger (
+        acct text primary key,
+        actor bigint not null references actor
+    );
+    END);
+});
-- 
cgit v1.3