diff options
| author |  Marien Fressinaud <dev@marienfressinaud.fr>
| 2013-11-28 01:25:33 +0100 |
|---|---|---|
| committer | Marien Fressinaud <dev@marienfressinaud.fr>
| 2013-11-28 01:25:33 +0100 |
| commit | b0b756230313d20f53bc38fd3be5d6403e8013d7 (patch) | |
| tree | 951bcacc7ef0957230d86f6d1cf01da49849e807 /public/install.php | |
| parent | 7f6eb66405b4c4429fb7c22082a958646c6ef05c (diff) | |
Corrige bug requêtes SQL (install.php)
Les noms des tables étaient mal protégées
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 252403196..c61910fee 100644 --- a/public/install.php +++ b/public/install.php @@ -36,7 +36,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( `cache_nbEntries` int NOT NULL DEFAULT 0, -- v0.7 `cache_nbUnreads` int NOT NULL DEFAULT 0, -- v0.7 PRIMARY KEY (`id`), - FOREIGN KEY (`category`) REFERENCES %scategory(id) ON DELETE SET NULL ON UPDATE CASCADE, + FOREIGN KEY (`category`) REFERENCES `%scategory`(`id`) ON DELETE SET NULL ON UPDATE CASCADE, UNIQUE KEY (`url`), -- v0.7 INDEX (`name`), -- v0.7 INDEX (`priority`), -- v0.7 @@ -56,7 +56,7 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `id_feed` SMALLINT NOT NULL, -- v0.7 `tags` varchar(1023) NOT NULL, PRIMARY KEY (`id`), - FOREIGN KEY (`id_feed`) REFERENCES %sfeed(id) ON DELETE CASCADE ON UPDATE CASCADE, + FOREIGN KEY (`id_feed`) REFERENCES `%sfeed`(`id`) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE KEY (`id_feed`,`guid`), -- v0.7 INDEX (`is_favorite`), -- v0.7 INDEX (`is_read`), -- v0.7 |