diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-03-17 02:32:08 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-03-17 02:32:08 +0000 |
| commit | 0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff (patch) | |
| tree | 786aba6dbacd46459208c1ab76cb704981cd9873 /phpBB/install | |
| parent | a387828494bcb6ea448c4c0bfeea1dca5495360f (diff) | |
| download | forums-0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff.tar forums-0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff.tar.gz forums-0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff.tar.bz2 forums-0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff.tar.xz forums-0f840a80c2d82a0b8ae8ae3a5cca1c07af5bd4ff.zip | |
#4052
- utf8_general_ci picked over utf8_unicode_ci for performance reasons
git-svn-id: file:///svn/phpbb/trunk@7202 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/database_update.php | 6 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 2 |
2 files changed, 7 insertions, 1 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index acf2dc64ae..cfecb3d729 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -740,6 +740,12 @@ if (version_compare($current_version, '3.0.b4', '<=')) if (version_compare($current_version, '3.0.b6', '<=')) { + // sorting thang + if ($map_dbms === 'mysql_41') + { + sql_column_change($dbms, TOPICS_TABLE, 'topic_title', 'varchar(100) DEFAULT \'\' NOT NULL COLLATE utf8_general_ci'); + } + if ($config['fulltext_native_common_thres'] == 20) { set_config('fulltext_native_common_thres', '5'); diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index a2785867be..4f56e3c998 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -884,7 +884,7 @@ CREATE TABLE phpbb_topics ( topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - topic_title varchar(100) DEFAULT '' NOT NULL, + topic_title varchar(100) DEFAULT '' NOT NULL COLLATE utf8_general_ci, topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL, topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL, |