migrations/20241231_165056_create_user_account.php


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

<?php

use \Digitigrade\Db\Migrator;

Migrator::getInstance()->register(20241231_165056, function (PDO $db) {
    // local user accounts
    $db->exec(<<<END
    CREATE TABLE user_account (
        id bigserial primary key,
        email text not null unique,
        password_hash text not null,
        actor bigint unique references actor on delete restrict,
        banned boolean not null default false
    );
    END);
});