migrations/20241214_181011_create_instance_auth.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(20241214_181011, function (PDO $db) {
    // instance auth information
    // and fix a mistake from last time
    $db->exec(<<<END
    CREATE TABLE instance_auth (
        instance_id bigint not null unique references instance,
        outbound_token text,
        inbound_token text
    );
    ALTER TABLE instance_endpoints ADD CONSTRAINT instance_id_unq UNIQUE(instance_id);
    END);
});