From 4355d8447f8e9073f4d96a35b280bad5ba793e32 Mon Sep 17 00:00:00 2001 From: Alexandre Alapetite Date: Wed, 27 Nov 2013 22:50:00 +0100 Subject: SQL : Passe e.id en bigint plutôt que char(6) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Contribue à https://github.com/marienfressinaud/FreshRSS/issues/202 e.id est généré à l'insertion par microtime(true). --- public/install.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'public') diff --git a/public/install.php b/public/install.php index 7709bb350..252403196 100644 --- a/public/install.php +++ b/public/install.php @@ -44,7 +44,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'); define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( - `id` char(6) NOT NULL, + `id` bigint NOT NULL, -- v0.7 `guid` varchar(760) CHARACTER SET latin1 NOT NULL, -- Maximum for UNIQUE is 767B `title` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, @@ -60,7 +60,7 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( 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 + INDEX (`date`) -- v0.7 //Consider removing after https://github.com/marienfressinaud/FreshRSS/issues/202 ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'); -- cgit v1.2.3