diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index a181532783..928c22c0aa 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -458,15 +458,16 @@ CREATE TABLE phpbb_forums ( forum_parents clob, forum_name varchar2(150), forum_desc clob, + forum_desc_bitfield number(11) DEFAULT '0' NOT NULL, + forum_desc_uid varchar2(5) DEFAULT '', forum_link varchar2(200) DEFAULT '', forum_password varchar2(32) DEFAULT '', forum_style number(4), forum_image varchar2(50) DEFAULT '', forum_rules clob DEFAULT '', forum_rules_link varchar2(200) DEFAULT '', - forum_rules_flags number(4) DEFAULT '0' NOT NULL, - forum_rules_bbcode_bitfield number(11) DEFAULT '0' NOT NULL, - forum_rules_bbcode_uid varchar2(5) DEFAULT '', + forum_rules_bitfield number(11) DEFAULT '0' 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, forum_status number(4) DEFAULT '0' NOT NULL, @@ -556,6 +557,9 @@ CREATE TABLE phpbb_groups ( group_id number(8) NOT NULL, group_type number(4) DEFAULT '1' NOT NULL, group_name varchar2(40) DEFAULT '', + group_desc clob, + group_desc_bitfield number(11) DEFAULT '0' NOT NULL, + group_desc_uid varchar2(5) DEFAULT '', group_display number(1) DEFAULT '0' NOT NULL, group_avatar varchar2(100) DEFAULT '', group_avatar_type number(4) DEFAULT '0' NOT NULL, @@ -567,7 +571,6 @@ CREATE TABLE phpbb_groups ( group_receive_pm number(1) DEFAULT '0' NOT NULL, group_message_limit number(8) DEFAULT '0' NOT NULL, group_chgpass number(6) DEFAULT '0' NOT NULL, - group_description varchar2(255) DEFAULT '', group_legend number(1) DEFAULT '1' NOT NULL, CONSTRAINT pk_phpbb_groups PRIMARY KEY (group_id) ) @@ -1215,7 +1218,7 @@ CREATE TABLE phpbb_sessions ( session_time number(11) DEFAULT '0' NOT NULL, session_ip varchar2(40) DEFAULT '0', session_browser varchar2(150) DEFAULT '', - session_page varchar2(100) DEFAULT '', + session_page varchar2(200) DEFAULT '', session_viewonline number(1) DEFAULT '1' NOT NULL, session_admin number(1) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_sessions PRIMARY KEY (session_id) @@ -1662,7 +1665,7 @@ CREATE TABLE phpbb_users ( user_lastvisit number(11) DEFAULT '0' NOT NULL, user_lastmark number(11) DEFAULT '0' NOT NULL, user_lastpost_time number(11) DEFAULT '0' NOT NULL, - user_lastpage varchar2(100) DEFAULT '', + user_lastpage varchar2(200) DEFAULT '', user_last_confirm_key varchar2(10) DEFAULT '', user_warnings number(4) DEFAULT '0' NOT NULL, user_last_warning number(11) DEFAULT '0' NOT NULL, |