diff options
-rw-r--r-- | Bugzilla/DB/Schema.pm | 1 | ||||
-rwxr-xr-x | checksetup.pl | 6 |
2 files changed, 7 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 8dce761d8..e0b49d859 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -371,6 +371,7 @@ use constant ABSTRACT_SCHEMA => { flags_bug_id_idx => [qw(bug_id attach_id)], flags_setter_id_idx => ['setter_id'], flags_requestee_id_idx => ['requestee_id'], + flags_type_id_idx => ['type_id'], ], }, diff --git a/checksetup.pl b/checksetup.pl index 1831bc62d..a28b19a14 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3890,6 +3890,12 @@ if ($dbh->bz_get_field_def('components', 'initialowner')->[2]) { # if NULL 'mediumint NOT NULL'); } +# 2005-03-28 - bug 238800 - index flags.type_id to make editflagtypes.cgi speedy +if (!defined $dbh->bz_get_index_def('flags','type_id')) { + print "Adding index for type_id column in flags table...\n"; + $dbh->do('ALTER TABLE flags ADD INDEX (type_id)'); +} + } # END LEGACY CHECKS # If you had to change the --TABLE-- definition in any way, then add your |