diff options
| author | Frédéric Buclin <LpSolit@gmail.com> | 2012-02-15 16:26:34 +0100 |
|---|---|---|
| committer | Frédéric Buclin <LpSolit@gmail.com> | 2012-02-15 16:26:34 +0100 |
| commit | 0081744381d7f56b4d41f1cdce4bf2c6e3991967 (patch) | |
| tree | 096bbc3b0f42f558d09f87767145b0dc699220bd /Bugzilla | |
| parent | 82a6ee698f52595ce7ec43fabefd222a1f80892a (diff) | |
| download | bugzilla-0081744381d7f56b4d41f1cdce4bf2c6e3991967.tar.gz bugzilla-0081744381d7f56b4d41f1cdce4bf2c6e3991967.tar.xz | |
Bug 722113: The profile_search table has a wrong index name
r=glob a=LpSolit
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 6 |
2 files changed, 7 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index da0c7d207..874a99ce0 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -909,7 +909,7 @@ use constant ABSTRACT_SCHEMA => { list_order => {TYPE => 'MEDIUMTEXT'}, ], INDEXES => [ - profile_search_user_id => [qw(user_id)], + profile_search_user_id_idx => [qw(user_id)], ], }, diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 44646962b..28c762d28 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -663,6 +663,12 @@ sub update_table_definitions { # 2011-11-28 dkl@mozilla.com - Bug 685611 _fix_notnull_defaults(); + # 2012-02-15 LpSolit@gmail.com - Bug 722113 + if ($dbh->bz_index_info('profile_search', 'profile_search_user_id')) { + $dbh->bz_drop_index('profile_search', 'profile_search_user_id'); + $dbh->bz_add_index('profile_search', 'profile_search_user_id_idx', [qw(user_id)]); + } + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |