diff options
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, |