From 94c5f41f6d663114bfac9390fc9eb72605a9e8ce Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Mon, 11 Nov 2013 22:27:11 +0100 Subject: MySQL : protection longueurs catégories MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- public/install.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'public') diff --git a/public/install.php b/public/install.php index dd9846fe5..7dde53e20 100644 --- a/public/install.php +++ b/public/install.php @@ -13,7 +13,7 @@ define ('SQL_REQ_CREATE_DB', 'CREATE DATABASE %s DEFAULT CHARACTER SET utf8 COLL define ('SQL_REQ_CAT', 'CREATE TABLE IF NOT EXISTS `%scategory` ( `id` char(6) NOT NULL, `name` varchar(255) NOT NULL, - `color` varchar(7) NOT NULL, + `color` char(7) NOT NULL, PRIMARY KEY (`id`), INDEX (`name`) );'); @@ -26,7 +26,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( `website` varchar(255) NOT NULL, `description` varchar(1023) NOT NULL, `lastUpdate` int(11) NOT NULL, - `priority` tinyint NOT NULL DEFAULT \'10\', + `priority` tinyint(2) NOT NULL DEFAULT \'10\', `pathEntries` varchar(511) DEFAULT NULL, `httpAuth` varchar(511) DEFAULT NULL, `error` boolean NOT NULL DEFAULT \'0\', -- cgit v1.2.3