diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-08-07 13:22:42 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-08-07 13:22:42 +0000 |
| commit | 19db55e8f3ce948be0a033c41431ffb177941a94 (patch) | |
| tree | 7388e3e33c40c9acb7b60fe5154e148b0761dbb6 /phpBB/install/schemas/oracle_schema.sql | |
| parent | 644c4bd0467ff9b8ed3f1f74fd21d97611f1a450 (diff) | |
| download | forums-19db55e8f3ce948be0a033c41431ffb177941a94.tar forums-19db55e8f3ce948be0a033c41431ffb177941a94.tar.gz forums-19db55e8f3ce948be0a033c41431ffb177941a94.tar.bz2 forums-19db55e8f3ce948be0a033c41431ffb177941a94.tar.xz forums-19db55e8f3ce948be0a033c41431ffb177941a94.zip | |
updated schema files. Also added a new load setting and some missing keys.
git-svn-id: file:///svn/phpbb/trunk@6250 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index ee9e65662f..18e321795d 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -220,6 +220,14 @@ CREATE TABLE phpbb_banlist ( ) / +CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist (ban_end) +/ +CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist (ban_userid, ban_exclude) +/ +CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist (ban_email, ban_exclude) +/ +CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist (ban_ip, ban_exclude) +/ CREATE SEQUENCE phpbb_banlist_seq / @@ -332,6 +340,8 @@ CREATE TABLE phpbb_confirm ( ) / +CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm (confirm_type) +/ /* Table: 'phpbb_disallow' @@ -983,6 +993,8 @@ CREATE TABLE phpbb_privmsgs_rules ( ) / +CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules (user_id) +/ CREATE SEQUENCE phpbb_privmsgs_rules_seq / @@ -1019,6 +1031,8 @@ CREATE TABLE phpbb_privmsgs_to ( CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to (msg_id) / +CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to (author_id) +/ CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to (user_id, folder_id) / @@ -1251,6 +1265,8 @@ CREATE TABLE phpbb_search_wordmatch ( CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch (word_id) / +CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch (post_id) +/ /* Table: 'phpbb_sessions' @@ -1661,6 +1677,8 @@ CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics (forum_id, topic_type) / CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics (topic_last_post_time) / +CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics (forum_id, topic_last_post_time, topic_moved_id) +/ CREATE SEQUENCE phpbb_topics_seq / |