diff options
author | myk%mozilla.org <> | 2005-04-20 06:43:37 +0200 |
---|---|---|
committer | myk%mozilla.org <> | 2005-04-20 06:43:37 +0200 |
commit | 3e681ef2457ac8205f95b48e42922b17153180e2 (patch) | |
tree | e280afdb6da6091d9a1e08fe2967dcbea83ab169 /checksetup.pl | |
parent | 6f4fba5980af8a0670aa402eb046fc58a06cb1b8 (diff) | |
download | bugzilla-3e681ef2457ac8205f95b48e42922b17153180e2.tar.gz bugzilla-3e681ef2457ac8205f95b48e42922b17153180e2.tar.xz |
Fix for bug 238800: speeds up editflagtypes.cgi list of flags to tolerable level by adding index on flags.type_id; r=justdave; a=justdave
Diffstat (limited to 'checksetup.pl')
-rwxr-xr-x | checksetup.pl | 6 |
1 files changed, 6 insertions, 0 deletions
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 |