diff options
author | Dylan William Hardison <dylan@hardison.net> | 2018-06-20 22:42:07 +0200 |
---|---|---|
committer | dklawren <dklawren@users.noreply.github.com> | 2018-06-20 22:42:07 +0200 |
commit | fca89e2f4c4a0660d0ce8947f2de375ec20f124b (patch) | |
tree | 92da925de3200e5de6f68ca71137a11f389e0733 /Bugzilla/Install | |
parent | 0bb8ea6781ed6262e1a254755d697ab80428754e (diff) | |
download | bugzilla-fca89e2f4c4a0660d0ce8947f2de375ec20f124b.tar.gz bugzilla-fca89e2f4c4a0660d0ce8947f2de375ec20f124b.tar.xz |
Bug 1469920 - Update schema: add fulltext index to profiles.realname
Diffstat (limited to 'Bugzilla/Install')
-rw-r--r-- | Bugzilla/Install/DB.pm | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 1729a134b..d81bcfbdc 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -767,6 +767,13 @@ sub update_table_definitions { $dbh->bz_add_column('components', 'triage_owner_id', {TYPE => 'INT3'}); + $dbh->bz_add_column('profiles', 'nickname', + {TYPE => 'varchar(255)', NOTNULL => 1, DEFAULT => "''"}); + $dbh->bz_add_index('profiles', 'profiles_nickname_idx', [qw(nickname)]); + + $dbh->bz_add_index('profiles', 'profiles_realname_ft_idx', + {TYPE => 'FULLTEXT', FIELDS => ['realname']}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |