From c3eec96e40bf8126fe07e977f58dde8762e2c38f Mon Sep 17 00:00:00 2001
From: Kenpachi Developer <Kenpachi.Developer@gmx.de>
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

