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/develop/create_schema_files.php | |
| 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/develop/create_schema_files.php')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 52e1af0e3a..487bd792d0 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -379,9 +379,16 @@ foreach ($supported_dbms as $dbms) } $line .= 'NOT NULL'; - if (isset($column_data[2]) && $column_data[2] == 'auto_increment') + if (isset($column_data[2])) { - $line .= ' auto_increment'; + if ($column_data[2] == 'auto_increment') + { + $line .= ' auto_increment'; + } + else if ($dbms === 'mysql_41' && $column_data[2] == 'true_sort') + { + $line .= ' COLLATE utf8_general_ci'; + } } $line .= ",\n"; @@ -1744,7 +1751,7 @@ function get_schema_struct() 'topic_attachment' => array('BOOL', 0), 'topic_approved' => array('BOOL', 1), 'topic_reported' => array('BOOL', 0), - 'topic_title' => array('XSTEXT_UNI', ''), + 'topic_title' => array('XSTEXT_UNI', '', 'true_sort'), 'topic_poster' => array('UINT', 0), 'topic_time' => array('TIMESTAMP', 0), 'topic_time_limit' => array('TIMESTAMP', 0), |