aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_schema.sql
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2006-05-16 17:46:47 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2006-05-16 17:46:47 +0000
commitd52e31a4891a96d97157a36c266a0e81e198aa6a (patch)
tree5833437a8fdac57a54552fa3c6c57134ec37d982 /phpBB/install/schemas/mysql_schema.sql
parent501aa7bde794a5ae8d90130dfdcb595984f34cf9 (diff)
downloadforums-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.sql18
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),