diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-27 22:50:00 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-27 22:50:00 +0100 |
| commit | 4355d8447f8e9073f4d96a35b280bad5ba793e32 (patch) | |
| tree | 8547c01168bb90dafd9d2e619b7b9c65ead44d88 /public/install.php | |
| parent | 91bf307d49b5494e0257bd9bb064c9369d3df6a5 (diff) | |
SQL : Passe e.id en bigint plutôt que char(6)
Contribue à https://github.com/marienfressinaud/FreshRSS/issues/202
e.id est généré à l'insertion par microtime(true).
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 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;'); |