diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 01:54:12 +0100 |
|---|---|---|
| committer | Alexandre Alapetite <alexandre@alapetite.fr>
| 2013-11-19 01:54:12 +0100 |
| commit | 9de5cacf1742ba30908f12175fa9cf59d9b84e44 (patch) | |
| tree | 2099c9ab1187d47ef91335610166d4b5a225e73b /public/install.php | |
| parent | be239f62f77bd8e029cfdf1afd881748837e8375 (diff) | |
SQL CREATE TABLE DEFAULT CHARACTER SET utf8
Diffstat (limited to 'public/install.php')
| -rw-r--r-- | public/install.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/public/install.php b/public/install.php index ad8e9a3c3..f783c777b 100644 --- a/public/install.php +++ b/public/install.php @@ -16,7 +16,7 @@ define ('SQL_REQ_CAT', 'CREATE TABLE IF NOT EXISTS `%scategory` ( `color` char(7) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY (`name`) -- v0.7 -);'); +) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'); define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( `id` SMALLINT NOT NULL AUTO_INCREMENT, -- v0.7 @@ -39,7 +39,7 @@ define ('SQL_REQ_FEED', 'CREATE TABLE IF NOT EXISTS `%sfeed` ( INDEX (`name`), -- v0.7 INDEX (`priority`), -- v0.7 INDEX (`keep_history`) -- v0.7 -);'); +) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'); define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( `id` char(6) NOT NULL, @@ -58,7 +58,7 @@ define ('SQL_REQ_ENTRY', 'CREATE TABLE IF NOT EXISTS `%sentry` ( INDEX (`is_favorite`), -- v0.7 INDEX (`is_read`), -- v0.7 INDEX (`date`) -- v0.7 //TODO: remove after https://github.com/marienfressinaud/FreshRSS/issues/202 -);'); +) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;'); function writeLine ($f, $line) { |