diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-11 22:27:11 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-11 22:27:11 +0100 |
| commit | 94c5f41f6d663114bfac9390fc9eb72605a9e8ce (patch) | |
| tree | fff03c62b248ccdf21a6201a604a204ab911fad0 /public/install.php | |
| parent | 5af7c472ed406693d19daf6899ad5ea615840740 (diff) | |
MySQL : protection longueurs catégories
Diffstat (limited to 'public/install.php')
| -rw-r--r-- | public/install.php | 4 |
1 files changed, 2 insertions, 2 deletions
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\', |