From f57e316cc05dac0e232bfa51c3598fd9e337d50d Mon Sep 17 00:00:00 2001 From: Byron Jones Date: Fri, 16 Aug 2013 13:28:28 +0800 Subject: Bug 905925: add attachment.ispatch index --- Bugzilla/DB/Schema.pm | 1 + Bugzilla/Install/DB.pm | 3 +++ 2 files changed, 4 insertions(+) (limited to 'Bugzilla') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 10307afc8..2040d0c0a 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -470,6 +470,7 @@ use constant ABSTRACT_SCHEMA => { attachments_creation_ts_idx => ['creation_ts'], attachments_modification_time_idx => ['modification_time'], attachments_submitter_id_idx => ['submitter_id', 'bug_id'], + attachments_ispatch_idx => ['ispatch'], ], }, attach_data => { diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index c61aab767..db3b8e3a3 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -699,6 +699,9 @@ sub update_table_definitions { # 2012-04-15 Frank@Frank-Becker.de - Bug 740536 $dbh->bz_add_index('audit_log', 'audit_log_class_idx', ['class', 'at_time']); + # 2013-08-16 glob@mozilla.com - Bug 905925 + $dbh->bz_add_index('attachments', 'attachments_ispatch_idx', ['ispatch']); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b