From b4b9f7fee276d147b14f9415a24184e5c95fc8e5 Mon Sep 17 00:00:00 2001 From: David M Date: Fri, 25 May 2007 12:22:04 +0000 Subject: #11637 git-svn-id: file:///svn/phpbb/trunk@7675 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/database_update.php | 5 +++++ phpBB/install/schemas/mysql_41_schema.sql | 2 +- 2 files changed, 6 insertions(+), 1 deletion(-) (limited to 'phpBB/install') diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 6002f3e556..5ba0c9f50f 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -607,6 +607,11 @@ if (version_compare($current_version, '3.0.RC1', '<=')) $db->sql_query($sql); } + if ($map_dbms === 'mysql_41') + { + sql_column_change($map_dbms, POSTS_TABLE, 'post_subject', array('XSTEXT_UNI', '', 'true_sort')); + } + $no_updates = false; } diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index a4eb2519aa..0838947c76 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -243,7 +243,7 @@ CREATE TABLE phpbb_forums ( forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - forum_last_post_subject varchar(100) DEFAULT '' NOT NULL, + forum_last_post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL, forum_last_poster_name varchar(255) DEFAULT '' NOT NULL, forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL, -- cgit v1.2.1