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 | |
| parent | 5af7c472ed406693d19daf6899ad5ea615840740 (diff) | |
MySQL : protection longueurs catégories
| -rwxr-xr-x | app/models/Category.php | 4 | ||||
| -rw-r--r-- | public/install.php | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/app/models/Category.php b/app/models/Category.php index 7659e68f6..419284130 100755 --- a/app/models/Category.php +++ b/app/models/Category.php @@ -95,8 +95,8 @@ class CategoryDAO extends Model_pdo { $values = array ( $valuesTmp['id'], - $valuesTmp['name'], - $valuesTmp['color'], + substr($valuesTmp['name'], 0, 255), + substr($valuesTmp['color'], 0, 7), ); if ($stm && $stm->execute ($values)) { 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\', |