aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorDavid M <davidmj@users.sourceforge.net>2007-05-25 12:22:04 +0000
committerDavid M <davidmj@users.sourceforge.net>2007-05-25 12:22:04 +0000
commitb4b9f7fee276d147b14f9415a24184e5c95fc8e5 (patch)
tree4c708cbb50a36e7d6e44d5bc0d7cbeaf628ad05d /phpBB/install
parente45c503bde5df9583dde575bec2fe3ff406ac071 (diff)
downloadforums-b4b9f7fee276d147b14f9415a24184e5c95fc8e5.tar
forums-b4b9f7fee276d147b14f9415a24184e5c95fc8e5.tar.gz
forums-b4b9f7fee276d147b14f9415a24184e5c95fc8e5.tar.bz2
forums-b4b9f7fee276d147b14f9415a24184e5c95fc8e5.tar.xz
forums-b4b9f7fee276d147b14f9415a24184e5c95fc8e5.zip
#11637
git-svn-id: file:///svn/phpbb/trunk@7675 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/database_update.php5
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql2
2 files changed, 6 insertions, 1 deletions
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,