commit 6ae48aa8c258c0b3d53966e6abb2d9756e65f56d
parent 88643fd9d57c0378a0431c2862c8d5f52426bf69
Author: Daniel GarcĂa <dani-garcia@users.noreply.github.com>
Date: Mon, 1 Nov 2021 14:33:47 +0100
Merge pull request #2080 from jjlin/fix-postgres-migration
Fix PostgreSQL migration
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/migrations/postgresql/2021-10-24-164321_add_2fa_incomplete/up.sql b/migrations/postgresql/2021-10-24-164321_add_2fa_incomplete/up.sql
@@ -2,7 +2,7 @@ CREATE TABLE twofactor_incomplete (
user_uuid VARCHAR(40) NOT NULL REFERENCES users(uuid),
device_uuid VARCHAR(40) NOT NULL,
device_name TEXT NOT NULL,
- login_time DATETIME NOT NULL,
+ login_time TIMESTAMP NOT NULL,
ip_address TEXT NOT NULL,
PRIMARY KEY (user_uuid, device_uuid)