diff options
author | Daniel Weipert <git@mail.dweipert.de> | 2025-08-20 14:58:10 +0200 |
---|---|---|
committer | Daniel Weipert <git@mail.dweipert.de> | 2025-08-20 14:58:10 +0200 |
commit | 6dc0447320272aaae51a98eb6606597019f986d3 (patch) | |
tree | 0acb527801a1d9eac943b5e0b0ccb33e610cd755 /migrations | |
parent | d08f4c83470c25d35d24594bd73e4effdac191a0 (diff) |
login produces devices and tokens
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/20250819.php | 4 |
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); |