diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 18 |
1 files changed, 9 insertions, 9 deletions
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), |