From 22d778fcfffe08317e951d24bbaad94441ed4ab0 Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
Date: Fri, 28 Jul 2006 02:56:02 +0000
Subject: - Fix Oracle - Make MySQL schema a little different than the
 others... - Fix MCP_TOPIC

git-svn-id: file:///svn/phpbb/trunk@6212 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index f001d8b194..018f4ba22b 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -216,7 +216,7 @@ CREATE TABLE phpbb_forums (
 	forum_parents mediumtext DEFAULT '' NOT NULL,
 	forum_name text DEFAULT '' NOT NULL,
 	forum_desc text DEFAULT '' NOT NULL,
-	forum_desc_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	forum_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	forum_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	forum_desc_uid varchar(5) DEFAULT '' NOT NULL,
 	forum_link varchar(255) DEFAULT '' NOT NULL,
@@ -225,7 +225,7 @@ CREATE TABLE phpbb_forums (
 	forum_image varchar(255) DEFAULT '' NOT NULL,
 	forum_rules text DEFAULT '' NOT NULL,
 	forum_rules_link varchar(255) DEFAULT '' NOT NULL,
-	forum_rules_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	forum_rules_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	forum_rules_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	forum_rules_uid varchar(5) DEFAULT '' NOT NULL,
 	forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
@@ -288,7 +288,7 @@ CREATE TABLE phpbb_groups (
 	group_type tinyint(4) DEFAULT '1' NOT NULL,
 	group_name varchar(255) DEFAULT '' NOT NULL,
 	group_desc text DEFAULT '' NOT NULL,
-	group_desc_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	group_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	group_desc_options int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	group_desc_uid varchar(5) DEFAULT '' NOT NULL,
 	group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -430,7 +430,7 @@ CREATE TABLE phpbb_posts (
 	post_checksum varchar(32) DEFAULT '' NOT NULL,
 	post_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL,
 	post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	bbcode_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	bbcode_uid varchar(5) DEFAULT '' NOT NULL,
 	post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	post_edit_reason text DEFAULT '' NOT NULL,
@@ -465,7 +465,7 @@ CREATE TABLE phpbb_privmsgs (
 	message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 	message_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL,
 	message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	bbcode_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	bbcode_uid varchar(5) DEFAULT '' NOT NULL,
 	message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 	message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
@@ -992,7 +992,7 @@ CREATE TABLE phpbb_users (
 	user_avatar_height tinyint(4) DEFAULT '0' NOT NULL,
 	user_sig mediumtext DEFAULT '' NOT NULL,
 	user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL,
-	user_sig_bbcode_bitfield varbinary(255) DEFAULT '\0' NOT NULL,
+	user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 	user_from varchar(100) DEFAULT '' NOT NULL,
 	user_icq varchar(15) DEFAULT '' NOT NULL,
 	user_aim varchar(255) DEFAULT '' NOT NULL,
-- 
cgit v1.2.1

