migrations/20250124_190913_create_user_setting.php


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

<?php

use \Digitigrade\Db\Migrator;

Migrator::getInstance()->register(20250124_190913, function (PDO $db) {
    // user settings table
    $db->exec(<<<END
    CREATE TABLE user_setting (
        user_id bigint not null references user_account,
        name text not null,
        value text not null,
        unique(user_id, name)
    );
    END);
});