diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 01:31:17 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 01:31:17 +0100 |
| commit | be239f62f77bd8e029cfdf1afd881748837e8375 (patch) | |
| tree | 5552c2150592bf6072bf2d15acfd38aacc8eb99b /public/install.php | |
| parent | e2d4f1a7214591a47a46272a7a62e320eea029ce (diff) | |
SQL : UNIQUE KEY pour category.name et feed.url
Suite de https://github.com/marienfressinaud/FreshRSS/issues/262
Diffstat (limited to 'public/install.php')
| -rw-r--r-- | public/install.php | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/public/install.php b/public/install.php index b244bfa80..ad8e9a3c3 100644 --- a/public/install.php +++ b/public/install.php @@ -15,12 +15,12 @@ define ('SQL_REQ_CAT', 'CREATE TABLE IF NOT EXISTS `%scategory` ( `name` varchar(255) NOT NULL, `color` char(7) NOT NULL, PRIMARY KEY (`id`), - INDEX (`name`) -- v0.7 + UNIQUE KEY (`name`) -- v0.7 );'); define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( `id` SMALLINT NOT NULL AUTO_INCREMENT, -- v0.7 - `url` varchar(511) NOT NULL, + `url` varchar(511) CHARACTER SET latin1 NOT NULL, `category` SMALLINT DEFAULT 0, -- v0.7 `name` varchar(255) NOT NULL, `website` varchar(255) NOT NULL, @@ -35,6 +35,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( `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, + UNIQUE KEY (`url`), -- v0.7 INDEX (`name`), -- v0.7 INDEX (`priority`), -- v0.7 INDEX (`keep_history`) -- v0.7 @@ -46,7 +47,7 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `title` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `content` text NOT NULL, - `link` varchar(1023) NOT NULL, + `link` varchar(1023) CHARACTER SET latin1 NOT NULL, `date` int(11) NOT NULL, `is_read` boolean NOT NULL DEFAULT 0, `is_favorite` boolean NOT NULL DEFAULT 0, |