diff options
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 55 |
1 files changed, 29 insertions, 26 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index e4e28db8a7..f6a1038d2d 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -779,6 +779,7 @@ CREATE TABLE phpbb_posts ( post_attachment number(1) DEFAULT '0' NOT NULL, bbcode_bitfield raw(255) DEFAULT '' NOT NULL, bbcode_uid varchar2(5) DEFAULT '' NOT NULL, + post_postcount number(1) DEFAULT '1' NOT NULL, post_edit_time number(11) DEFAULT '0' NOT NULL, post_edit_reason varchar2(3000) DEFAULT '' NOT NULL, post_edit_user number(8) DEFAULT '0' NOT NULL, @@ -798,6 +799,8 @@ CREATE INDEX phpbb_posts_poster_id ON phpbb_posts (poster_id) / CREATE INDEX phpbb_posts_post_approved ON phpbb_posts (post_approved) / +CREATE INDEX phpbb_posts_post_postcount ON phpbb_posts (post_postcount) +/ CREATE INDEX phpbb_posts_post_time ON phpbb_posts (post_time) / @@ -1433,41 +1436,41 @@ CREATE TABLE phpbb_styles_imageset ( sub_forum_new varchar2(200) DEFAULT '' NOT NULL, folder varchar2(200) DEFAULT '' NOT NULL, folder_moved varchar2(200) DEFAULT '' NOT NULL, - folder_posted varchar2(200) DEFAULT '' NOT NULL, + folder_post varchar2(200) DEFAULT '' NOT NULL, folder_new varchar2(200) DEFAULT '' NOT NULL, - folder_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_new_post varchar2(200) DEFAULT '' NOT NULL, folder_hot varchar2(200) DEFAULT '' NOT NULL, - folder_hot_posted varchar2(200) DEFAULT '' NOT NULL, + folder_hot_post varchar2(200) DEFAULT '' NOT NULL, folder_hot_new varchar2(200) DEFAULT '' NOT NULL, - folder_hot_new_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked varchar2(200) DEFAULT '' NOT NULL, - folder_locked_posted varchar2(200) DEFAULT '' NOT NULL, - folder_locked_new varchar2(200) DEFAULT '' NOT NULL, - 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_hot_new_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock varchar2(200) DEFAULT '' NOT NULL, + folder_lock_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_new varchar2(200) DEFAULT '' NOT NULL, + folder_lock_new_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_announce varchar2(200) DEFAULT '' NOT NULL, + folder_lock_announce_new varchar2(200) DEFAULT '' NOT NULL, + folder_lock_announce_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_announce_new_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_global varchar2(200) DEFAULT '' NOT NULL, + folder_lock_global_new varchar2(200) DEFAULT '' NOT NULL, + folder_lock_global_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_global_new_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_sticky varchar2(200) DEFAULT '' NOT NULL, + folder_lock_sticky_new varchar2(200) DEFAULT '' NOT NULL, + folder_lock_sticky_post varchar2(200) DEFAULT '' NOT NULL, + folder_lock_sticky_new_post varchar2(200) DEFAULT '' NOT NULL, folder_sticky varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_posted varchar2(200) DEFAULT '' NOT NULL, + folder_sticky_post varchar2(200) DEFAULT '' NOT NULL, folder_sticky_new varchar2(200) DEFAULT '' NOT NULL, - folder_sticky_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_sticky_new_post varchar2(200) DEFAULT '' NOT NULL, folder_announce varchar2(200) DEFAULT '' NOT NULL, - folder_announce_posted varchar2(200) DEFAULT '' NOT NULL, + folder_announce_post varchar2(200) DEFAULT '' NOT NULL, folder_announce_new varchar2(200) DEFAULT '' NOT NULL, - folder_announce_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_announce_new_post varchar2(200) DEFAULT '' NOT NULL, folder_global varchar2(200) DEFAULT '' NOT NULL, - folder_global_posted varchar2(200) DEFAULT '' NOT NULL, + folder_global_post varchar2(200) DEFAULT '' NOT NULL, folder_global_new varchar2(200) DEFAULT '' NOT NULL, - folder_global_new_posted varchar2(200) DEFAULT '' NOT NULL, + folder_global_new_post varchar2(200) DEFAULT '' NOT NULL, poll_left varchar2(200) DEFAULT '' NOT NULL, poll_center varchar2(200) DEFAULT '' NOT NULL, poll_right varchar2(200) DEFAULT '' NOT NULL, |