projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
WebshopApi: Trigramindices für Kundenstrasse
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
trigram_indices_webshop.sql
1
-- @tag: trigram_indices_webshop
2
-- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul
3
-- @depends: release_3_5_0 shops
4
-- @encoding: utf-8
5
-- @ignore: 1
6
7
CREATE INDEX customer_street_gin_trgm_idx ON customer USING gin (street gin_trgm_ops);