1 files changed, 16 insertions, 0 deletions
diff --git a/migrations/20241214_181011_create_instance_auth.php b/migrations/20241214_181011_create_instance_auth.php
new file mode 100644
index 0000000..342a65d
--- /dev/null
+++ b/migrations/20241214_181011_create_instance_auth.php
@@ -0,0 +1,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);
+});