diff options
author | Meik Sievertsen <acydburn@phpbb.com> | 2006-05-16 17:46:47 +0000 |
---|---|---|
committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-05-16 17:46:47 +0000 |
commit | d52e31a4891a96d97157a36c266a0e81e198aa6a (patch) | |
tree | 5833437a8fdac57a54552fa3c6c57134ec37d982 /phpBB/install/schemas/mysql_schema.sql | |
parent | 501aa7bde794a5ae8d90130dfdcb595984f34cf9 (diff) | |
download | forums-d52e31a4891a96d97157a36c266a0e81e198aa6a.tar forums-d52e31a4891a96d97157a36c266a0e81e198aa6a.tar.gz forums-d52e31a4891a96d97157a36c266a0e81e198aa6a.tar.bz2 forums-d52e31a4891a96d97157a36c266a0e81e198aa6a.tar.xz forums-d52e31a4891a96d97157a36c266a0e81e198aa6a.zip |
some changes before i forget...
git-svn-id: file:///svn/phpbb/trunk@5916 89ea8834-ac86-4346-8a33-228a782c2dd0
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), |