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/DB | |
| 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/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 19275206d..67ee9071c 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -924,6 +924,8 @@ use constant ABSTRACT_SCHEMA => { cryptpassword => {TYPE => 'varchar(128)'}, realname => {TYPE => 'varchar(255)', NOTNULL => 1, DEFAULT => "''"}, + nickname => {TYPE => 'varchar(255)', NOTNULL => 1, + DEFAULT => "''"}, disabledtext => {TYPE => 'MEDIUMTEXT', NOTNULL => 1, DEFAULT => "''"}, disable_mail => {TYPE => 'BOOLEAN', NOTNULL => 1, @@ -943,7 +945,10 @@ use constant ABSTRACT_SCHEMA => { profiles_login_name_idx => {FIELDS => ['login_name'], TYPE => 'UNIQUE'}, profiles_extern_id_idx => {FIELDS => ['extern_id'], - TYPE => 'UNIQUE'} + TYPE => 'UNIQUE'}, + profiles_nickname_idx => ['nickname'], + profiles_realname_ft_idx => {FIELDS => ['realname'], + TYPE => 'FULLTEXT'}, ], }, |