vw_small

commit c49ee47de056cad058bcf2dc2b8c19d621bc6a39
parent a2316ca091ebb7f6e4ed06d150d72474ef103839
Author: Jeremy Lin <jeremy.lin@gmail.com>
Date:   Sun, 31 Oct 2021 17:50:00 -0700

Fix PostgreSQL migration

The PostgreSQL migration should have used `TIMESTAMP` rather than `DATETIME`.

Diffstat:
M
migrations/postgresql/2021-10-24-164321_add_2fa_incomplete/up.sql
 | 
2
+-

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)