summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/DB/Schema.pm3
-rw-r--r--Bugzilla/Install/DB.pm3
2 files changed, 6 insertions, 0 deletions
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 #
################################################################