From 3e681ef2457ac8205f95b48e42922b17153180e2 Mon Sep 17 00:00:00 2001
From: "myk%mozilla.org" <>
Date: Wed, 20 Apr 2005 04:43:37 +0000
Subject: 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

---
 checksetup.pl | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'checksetup.pl')

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
-- 
cgit v1.2.3-24-g4f1b