From d2d26bf69c63821d0fa73f8b8b6dd78370f5d2d7 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Tue, 19 Nov 2013 22:19:36 +0100 Subject: SQL : UNIQUE(e.id_feed, e.guid) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Préparation de GUID en prévision de https://github.com/marienfressinaud/FreshRSS/issues/202 --- public/install.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'public/install.php') diff --git a/public/install.php b/public/install.php index 287e14614..4471f2e95 100644 --- a/public/install.php +++ b/public/install.php @@ -43,7 +43,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `id` char(6) NOT NULL, - `guid` varchar(511) NOT NULL, + `guid` varchar(760) CHARACTER SET latin1 NOT NULL, `title` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `content` text NOT NULL, @@ -55,6 +55,7 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `tags` varchar(1023) NOT NULL, PRIMARY KEY (`id`), 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 INDEX (`date`) -- v0.7 //TODO: remove after https://github.com/marienfressinaud/FreshRSS/issues/202 -- cgit v1.2.3