From c3eec96e40bf8126fe07e977f58dde8762e2c38f Mon Sep 17 00:00:00 2001 From: Kenpachi Developer Date: Sat, 23 Nov 2019 00:02:58 +0100 Subject: Fix for https://github.com/HerculesWS/Hercules/issues/2349. ipban_log() only inserts the first 3 octets of an IP and an asterisk for last one, so we can set the columns length to 13. --- sql-files/main.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index c4e5afaf3..63880a0ce 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -617,7 +617,7 @@ CREATE TABLE IF NOT EXISTS `inventory` ( -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( - `list` VARCHAR(255) NOT NULL DEFAULT '', + `list` VARCHAR(13) NOT NULL DEFAULT '', `btime` DATETIME NULL, `rtime` DATETIME NULL, `reason` VARCHAR(255) NOT NULL DEFAULT '', -- cgit v1.2.3-70-g09d2