projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
e008927d4e8343ce7899a39ba7dd8e8410d8e745
[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);