From d52e31a4891a96d97157a36c266a0e81e198aa6a Mon Sep 17 00:00:00 2001 From: Meik Sievertsen 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