diff options
| author | Frank Becker <Frank@Frank-Becker.de> | 2012-06-08 16:05:52 +0200 |
|---|---|---|
| committer | Dave Lawrence <dlawrence@mozilla.com> | 2012-06-08 16:05:52 +0200 |
| commit | 4a73f6aa87301ae6df3b0360043cc23301e1f68f (patch) | |
| tree | f1e7d729adc429b81a89a74c71f636ff241b2d8a | |
| parent | e0bd7772190fa654c7c65e1df98b60fa96c4d15d (diff) | |
| download | bugzilla-4a73f6aa87301ae6df3b0360043cc23301e1f68f.tar.gz bugzilla-4a73f6aa87301ae6df3b0360043cc23301e1f68f.tar.xz | |
Bug 745533 - database add index audit_log_class_at_time_idx for audit_log
r=dkl, a=LpSolit
| -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 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 # ################################################################ |