migrations/20250123_173501_create_block_relation.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14

<?php

use \Digitigrade\Db\Migrator;

Migrator::getInstance()->register(20250123_173501, function (PDO $db) {
    // actors who block each other. makes sense
    $db->exec(<<<END
    CREATE TABLE block_relation (
        subject bigint not null references actor,
        object bigint not null references actor,
        unique(subject, object)
    );
    END);
});