From 0108c64541d2cd9684ce0b75acfc541bf479ae71 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Tue, 15 Mar 2016 18:01:15 +0100 Subject: Resize the LastLoginIPAddress column Make sure that all valid IPv6 addresses fit into the LastLoginIPAddress field. Signed-off-by: Lukas Fleischer --- schema/aur-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'schema/aur-schema.sql') diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index aa5ed9da..0804ac35 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -35,7 +35,7 @@ CREATE TABLE Users ( IRCNick VARCHAR(32) NOT NULL DEFAULT '', PGPKey VARCHAR(40) NULL DEFAULT NULL, LastLogin BIGINT UNSIGNED NOT NULL DEFAULT 0, - LastLoginIPAddress VARCHAR(40) NULL DEFAULT NULL, + LastLoginIPAddress VARCHAR(45) NULL DEFAULT NULL, InactivityTS BIGINT UNSIGNED NOT NULL DEFAULT 0, RegistrationTS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, CommentNotify TINYINT(1) NOT NULL DEFAULT 1, -- cgit v1.2.3-24-g4f1b