migrations/20241219_181401_create_follow_relation.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<?php

use \Digitigrade\Db\Migrator;

Migrator::getInstance()->register(20241219_181401, function (PDO $db) {
    $db->beginTransaction();
    $db->exec(<<<END
    CREATE TYPE follow_relation_status AS ENUM (
        'pending', 'active'
    );
    CREATE TABLE follow_relation (
        subject bigint not null references actor,
        object bigint not null references actor,
        status follow_relation_status not null,
        unique(subject, object)
    );
    END);
    $db->commit();
});