diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 57fc56048e..6ffd59cd45 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -486,7 +486,7 @@ CREATE TABLE phpbb_forums ( forum_last_poster_id number(8) DEFAULT '0' NOT NULL, forum_last_post_time number(11) DEFAULT '0' NOT NULL, forum_last_poster_name varchar2(255), - forum_flags number(4) DEFAULT '0' NOT NULL, + forum_flags number(4) DEFAULT '32' NOT NULL, display_on_index number(1) DEFAULT '1' NOT NULL, enable_indexing number(1) DEFAULT '1' NOT NULL, enable_icons number(1) DEFAULT '1' NOT NULL, @@ -1522,8 +1522,20 @@ CREATE TABLE phpbb_styles_imageset ( folder_locked varchar2(200) DEFAULT '', folder_locked_posted varchar2(200) DEFAULT '', folder_locked_new varchar2(200) DEFAULT '', - folder_locked_new_posted varchar2(200) DEFAULT '', - folder_sticky varchar2(200) DEFAULT '', + folder_locked_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_announce_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_global_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_new varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_posted varchar2(200) DEFAULT '' NOT NULL, + folder_locked_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_sticky varchar2(200) DEFAULT '' NOT NULL, folder_sticky_posted varchar2(200) DEFAULT '', folder_sticky_new varchar2(200) DEFAULT '', folder_sticky_new_posted varchar2(200) DEFAULT '', |