aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2007-05-25 19:01:04 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2007-05-25 19:01:04 +0000
commitffb1366af8ca6ac3f4c05966bd3d367bc0357dfb (patch)
tree3b8f1eefed1da069321bc46ad41d19934b534940 /phpBB/install/schemas
parentcd7efa78a4968ff2bd6de276a81e6ea593950a50 (diff)
downloadforums-ffb1366af8ca6ac3f4c05966bd3d367bc0357dfb.tar
forums-ffb1366af8ca6ac3f4c05966bd3d367bc0357dfb.tar.gz
forums-ffb1366af8ca6ac3f4c05966bd3d367bc0357dfb.tar.bz2
forums-ffb1366af8ca6ac3f4c05966bd3d367bc0357dfb.tar.xz
forums-ffb1366af8ca6ac3f4c05966bd3d367bc0357dfb.zip
wrong position. ;)
git-svn-id: file:///svn/phpbb/trunk@7683 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 0838947c76..44b292b7e7 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 COLLATE utf8_unicode_ci,
+ forum_last_post_subject varchar(100) DEFAULT '' NOT NULL,
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,
@@ -436,7 +436,7 @@ CREATE TABLE phpbb_posts (
enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
post_username varchar(255) DEFAULT '' NOT NULL,
- post_subject varchar(100) DEFAULT '' NOT NULL,
+ post_subject varchar(100) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
post_text mediumtext NOT NULL,
post_checksum varchar(32) DEFAULT '' NOT NULL,
post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,