summaryrefslogtreecommitdiff
path: root/migrations/20250819.php
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20250819.php')
-rw-r--r--migrations/20250819.php4
1 files changed, 4 insertions, 0 deletions
diff --git a/migrations/20250819.php b/migrations/20250819.php
index cfd0f65..061b59c 100644
--- a/migrations/20250819.php
+++ b/migrations/20250819.php
@@ -37,9 +37,13 @@ Database::getInstance()->query(<<<SQL
"access_token" varchar(255) not null,
"refresh_token" varchar(255) not null,
+ "expires_at" timestamptz(3) not null,
+
"user_id" varchar(255) not null,
"device_id" varchar(255),
+ "created_at" timestamptz(3) not null,
+
foreign key (user_id, device_id) references devices(user_id, id)
);
SQL);