diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index adc86f7b26..a3665563e1 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -479,7 +479,7 @@ CREATE TABLE phpbb_forums ( forum_name varchar2(3000) DEFAULT '' , forum_desc clob DEFAULT '' , forum_desc_bitfield varchar2(252) DEFAULT '' , - forum_desc_options number(11) DEFAULT '0' NOT NULL, + forum_desc_options number(11) DEFAULT '7' NOT NULL, forum_desc_uid varchar2(5) DEFAULT '' , forum_link varchar2(255) DEFAULT '' , forum_password varchar2(40) DEFAULT '' , @@ -488,7 +488,7 @@ CREATE TABLE phpbb_forums ( forum_rules clob DEFAULT '' , forum_rules_link varchar2(255) DEFAULT '' , forum_rules_bitfield varchar2(252) DEFAULT '' , - forum_rules_options number(11) DEFAULT '0' NOT NULL, + forum_rules_options number(11) DEFAULT '7' NOT NULL, forum_rules_uid varchar2(5) DEFAULT '' , forum_topics_per_page number(4) DEFAULT '0' NOT NULL, forum_type number(4) DEFAULT '0' NOT NULL, @@ -586,7 +586,7 @@ CREATE TABLE phpbb_groups ( group_name varchar2(252) DEFAULT '' , group_desc clob DEFAULT '' , group_desc_bitfield varchar2(252) DEFAULT '' , - group_desc_options number(11) DEFAULT '0' NOT NULL, + group_desc_options number(11) DEFAULT '7' NOT NULL, group_desc_uid varchar2(5) DEFAULT '' , group_display number(1) DEFAULT '0' NOT NULL, group_avatar varchar2(255) DEFAULT '' , @@ -1788,6 +1788,8 @@ CREATE TABLE phpbb_users ( user_warnings number(4) DEFAULT '0' NOT NULL, user_last_warning number(11) DEFAULT '0' NOT NULL, user_login_attempts number(4) DEFAULT '0' NOT NULL, + user_inactive_reason number(2) DEFAULT '0' NOT NULL, + user_inactive_time number(11) DEFAULT '0' NOT NULL, user_posts number(8) DEFAULT '0' NOT NULL, user_lang varchar2(30) DEFAULT '' , user_timezone number(5, 2) DEFAULT '0' NOT NULL, |