From d52e31a4891a96d97157a36c266a0e81e198aa6a Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Tue, 16 May 2006 17:46:47 +0000
Subject: some changes before i forget...

git-svn-id: file:///svn/phpbb/trunk@5916 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 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 ce43ba56ad..aa1128d93e 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -428,25 +428,25 @@ CREATE TABLE phpbb_privmsgs (
    msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
    root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
    author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
-   icon_id tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
+   icon_id tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
    author_ip varchar(40) DEFAULT '' NOT NULL,
    message_time int(11) DEFAULT '0' NOT NULL,
    enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
    enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
    enable_magic_url tinyint(1) DEFAULT '1' NOT NULL,
    enable_sig tinyint(1) DEFAULT '1' NOT NULL,
-   message_subject text,
-   message_text mediumtext,
-   message_edit_reason text,
-   message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+   message_subject text NOT NULL,
+   message_text mediumtext NOT NULL,
+   message_edit_reason text NULL,
+   message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NULL,
    message_encoding varchar(20) DEFAULT 'iso-8859-1' NOT NULL,
    message_attachment tinyint(1) DEFAULT '0' NOT NULL,
    bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL,
    bbcode_uid varchar(5) DEFAULT '' NOT NULL,
-   message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
-   message_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
-   to_address text,
-   bcc_address text,
+   message_edit_time int(11) UNSIGNED DEFAULT '0' NULL,
+   message_edit_count smallint(5) UNSIGNED DEFAULT '0' NULL,
+   to_address text NOT NULL,
+   bcc_address text NOT NULL,
    PRIMARY KEY  (msg_id),
    KEY author_ip (author_ip),
    KEY message_time (message_time),
-- 
cgit v1.2.1

