migrations/20241208_165411_create_note_mentions.php


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

<?php

use \Digitigrade\Db\Migrator;

Migrator::getInstance()->register(20241208_165411, function (PDO $db) {
    // forgot this table in create_note :(
    $db->exec(<<<END
    CREATE TABLE note_mention (
        note_id bigint not null references note(id),
        actor_id bigint not null references actor(id),
        unique(note_id, actor_id)
    );
    END);
});