migrations/20241210_181118_create_actor_webfinger.php


1
2
3
4
5
6
7
8
9
10
11
12
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);
});