cache webfinger lookups

1 files changed, 13 insertions, 0 deletions

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);
+});