summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormkanat%bugzilla.org <>2006-08-26 08:55:17 +0200
committermkanat%bugzilla.org <>2006-08-26 08:55:17 +0200
commit0f282627568f7f8ed401506f291730f871fc538a (patch)
tree098820e1d0ff5848ddb1f5e6f95ae239fd55627c
parent192725496a22f2cc37124aecd97748fc5844160c (diff)
downloadbugzilla-0f282627568f7f8ed401506f291730f871fc538a.tar.gz
bugzilla-0f282627568f7f8ed401506f291730f871fc538a.tar.xz
Bug 350249: We don't need an index on bugs.short_desc
Patch By Max Kanat-Alexander <mkanat@bugzilla.org> (module owner) a=myk
-rw-r--r--Bugzilla/DB/Schema.pm1
-rw-r--r--Bugzilla/Install/DB.pm6
2 files changed, 1 insertions, 6 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 3967c8282..fb5fb9ce8 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -219,7 +219,6 @@ use constant ABSTRACT_SCHEMA => {
bugs_target_milestone_idx => ['target_milestone'],
bugs_qa_contact_idx => ['qa_contact'],
bugs_votes_idx => ['votes'],
- bugs_short_desc_idx => ['short_desc'],
],
},
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 09aa5c323..f649686e7 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -482,11 +482,7 @@ sub update_table_definitions {
# 2006-08-19 LpSolit@gmail.com - Bug 87795
$dbh->bz_alter_column('tokens', 'userid', {TYPE => 'INT3'});
- my $sd_index = $dbh->bz_index_info('bugs', 'bugs_short_desc_idx');
- if (!$sd_index || ($sd_index->{TYPE} && $sd_index->{TYPE} eq 'FULLTEXT')) {
- $dbh->bz_drop_index('bugs', 'bugs_short_desc_idx');
- $dbh->bz_add_index('bugs', 'bugs_short_desc_idx', [qw(short_desc)]);
- }
+ $dbh->bz_drop_index('bugs', 'bugs_short_desc_idx');
# The profiles table was missing some defaults.
$dbh->bz_alter_column('profiles', 'disabledtext',