diff options
author | Dave Lawrence <dlawrence@mozilla.com> | 2013-05-01 21:01:03 +0200 |
---|---|---|
committer | Dave Lawrence <dlawrence@mozilla.com> | 2013-05-01 21:01:03 +0200 |
commit | d149115ac9f1396d8515e447bf6bda0ae4495536 (patch) | |
tree | cab0c20c257f85489341dcd2754ad946d9127833 /Bugzilla | |
parent | 78fbce5bf3e5faed12b8360bc8e21b8a293d5371 (diff) | |
download | bugzilla-d149115ac9f1396d8515e447bf6bda0ae4495536.tar.gz bugzilla-d149115ac9f1396d8515e447bf6bda0ae4495536.tar.xz |
Bug 867177 - Backport bug 745533to bmo/4.2 to add index to audit_log table
r=glob
Diffstat (limited to 'Bugzilla')
-rw-r--r-- | Bugzilla/DB/Schema.pm | 3 | ||||
-rw-r--r-- | Bugzilla/Install/DB.pm | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 89f0e1ecb..10307afc8 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -530,6 +530,9 @@ use constant ABSTRACT_SCHEMA => { added => {TYPE => 'MEDIUMTEXT'}, at_time => {TYPE => 'DATETIME', NOTNULL => 1}, ], + INDEXES => [ + audit_log_class_idx => ['class', 'at_time'], + ], }, # Keywords diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index e492c8db7..c61aab767 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -696,6 +696,9 @@ sub update_table_definitions { # 2013-02-04 dkl@mozilla.com - Bug 824346 _fix_flagclusions_indexes(); + # 2012-04-15 Frank@Frank-Becker.de - Bug 740536 + $dbh->bz_add_index('audit_log', 'audit_log_class_idx', ['class', 'at_time']); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |