diff options
author | Dylan William Hardison <dylan@hardison.net> | 2018-01-31 04:18:06 +0100 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-01-31 04:18:06 +0100 |
commit | ac80568834a7954046d6dcaed98d9460b3d34b09 (patch) | |
tree | 387520e5ea5cce8f69014dd33146100bc1d932d2 /Bugzilla/Install | |
parent | 8740a646cfef5795cb05df8ea19dc38b600bf5eb (diff) | |
download | bugzilla-ac80568834a7954046d6dcaed98d9460b3d34b09.tar.gz bugzilla-ac80568834a7954046d6dcaed98d9460b3d34b09.tar.xz |
Bug 1433833 - Add index to email_rates.message_ts
Diffstat (limited to 'Bugzilla/Install')
-rw-r--r-- | Bugzilla/Install/DB.pm | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 3b1836c26..e6a7a3be0 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -218,6 +218,10 @@ sub update_table_definitions { $dbh->bz_add_column('profiles', 'emailflags', {TYPE => 'MEDIUMTEXT'}); } + if (!$dbh->bz_index_info('email_rates', 'email_rates_message_ts_idx')) { + $dbh->bz_add_index( 'email_rates', 'email_rates_message_ts_idx', ['message_ts'] ); + } + $dbh->bz_add_column('groups', 'isactive', {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'TRUE'}); |