summaryrefslogtreecommitdiffstats
path: root/upgrading/4.5.0.txt
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2017-01-25 08:37:48 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2017-01-25 18:42:34 +0100
commit70db022aa8287c57a2ee03328ae893ba8b83b192 (patch)
tree9576426d39b9f6b2240cdf936b79bae29df1300b /upgrading/4.5.0.txt
parentf8916d7e9bda129a57143d769f7eb1f596614c80 (diff)
downloadaur-70db022aa8287c57a2ee03328ae893ba8b83b192.tar.gz
aur-70db022aa8287c57a2ee03328ae893ba8b83b192.tar.xz
Store banned IP addresses as plain text
Inspired by commit 32c8d0c (Store last login address as plain text, 2016-03-13). Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading/4.5.0.txt')
-rw-r--r--upgrading/4.5.0.txt7
1 files changed, 7 insertions, 0 deletions
diff --git a/upgrading/4.5.0.txt b/upgrading/4.5.0.txt
index 5cf0888c..fb0a2993 100644
--- a/upgrading/4.5.0.txt
+++ b/upgrading/4.5.0.txt
@@ -11,3 +11,10 @@ ALTER TABLE Users
ADD COLUMN LastSSHLogin BIGINT UNSIGNED NOT NULL DEFAULT 0,
ADD COLUMN LastSSHLoginIPAddress VARCHAR(45) NULL DEFAULT NULL;
---
+
+3. Convert the IPAddress column of the Bans table to VARCHAR(45). If the table
+ contains any active bans, convert them accordingly:
+
+----
+ALTER TABLE Bans MODIFY IPAddress VARCHAR(45) NULL DEFAULT NULL;
+----