summaryrefslogtreecommitdiffstats
path: root/schema
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2016-03-15 18:01:15 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2016-03-15 18:01:15 +0100
commit0108c64541d2cd9684ce0b75acfc541bf479ae71 (patch)
treed526fb730477cff56a938ba23396624abb6e9bfc /schema
parentff36b231535e7dae67878779341b7e52137b8102 (diff)
downloadaur-0108c64541d2cd9684ce0b75acfc541bf479ae71.tar.gz
aur-0108c64541d2cd9684ce0b75acfc541bf479ae71.tar.xz
Resize the LastLoginIPAddress column
Make sure that all valid IPv6 addresses fit into the LastLoginIPAddress field. Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
-rw-r--r--schema/aur-schema.sql2
1 files changed, 1 insertions, 1 deletions
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,