From 4a73f6aa87301ae6df3b0360043cc23301e1f68f Mon Sep 17 00:00:00 2001 From: Frank Becker Date: Fri, 8 Jun 2012 10:05:52 -0400 Subject: Bug 745533 - database add index audit_log_class_at_time_idx for audit_log r=dkl, a=LpSolit --- Bugzilla/DB/Schema.pm | 3 +++ Bugzilla/Install/DB.pm | 3 +++ 2 files changed, 6 insertions(+) (limited to 'Bugzilla') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 11d88c8fc..06d4a632d 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -506,6 +506,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 372b010e8..ef2b41e7d 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -670,6 +670,9 @@ sub update_table_definitions { $dbh->bz_alter_column('products', 'defaultmilestone', {TYPE => 'varchar(64)', NOTNULL => 1, DEFAULT => "'---'"}); + # 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 # ################################################################ -- cgit v1.2.3-24-g4f1b