diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index aafe403405..d143128ed7 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -889,25 +889,25 @@ CREATE TABLE phpbb_privmsgs ( msg_id number(8) NOT NULL, root_level number(8) DEFAULT '0' NOT NULL, author_id number(8) DEFAULT '0' NOT NULL, - icon_id number(4) DEFAULT '1' NOT NULL, - author_ip varchar2(40) DEFAULT '', + icon_id number(4) DEFAULT '0' NOT NULL, + author_ip varchar2(40) DEFAULT '' NOT NULL, message_time number(11) DEFAULT '0' NOT NULL, enable_bbcode number(1) DEFAULT '1' NOT NULL, enable_smilies number(1) DEFAULT '1' NOT NULL, enable_magic_url number(1) DEFAULT '1' NOT NULL, enable_sig number(1) DEFAULT '1' NOT NULL, - message_subject varchar2(1000), - message_text clob, - message_edit_reason varchar2(1000), - message_edit_user number(8) DEFAULT '0' NOT NULL, - message_encoding varchar2(20) DEFAULT 'iso-8859-1', + message_subject varchar2(1000) NOT NULL, + message_text clob NOT NULL, + message_edit_reason varchar2(1000) NULL, + message_edit_user number(8) DEFAULT '0' NULL, + message_encoding varchar2(20) DEFAULT 'iso-8859-1' NOT NULL, message_attachment number(1) DEFAULT '0' NOT NULL, bbcode_bitfield number(11) DEFAULT '0' NOT NULL, - bbcode_uid varchar2(5) DEFAULT '', - message_edit_time number(11) DEFAULT '0' NOT NULL, - message_edit_count number(5) DEFAULT '0' NOT NULL, - to_address clob, - bcc_address clob, + bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + message_edit_time number(11) DEFAULT '0' NULL, + message_edit_count number(5) DEFAULT '0' NULL, + to_address clob NOT NULL, + bcc_address clob NOT NULL, CONSTRAINT pk_phpbb_privmsgs PRIMARY KEY (msg_id) ) / |