projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Release 3.5.5
[kivitendo-erp.git]
/
sql
/
Pg-upgrade2
/
trigram_indices_webshop.sql
diff --git
a/sql/Pg-upgrade2/trigram_indices_webshop.sql
b/sql/Pg-upgrade2/trigram_indices_webshop.sql
index
e008927
..
399e8df
100644
(file)
--- a/
sql/Pg-upgrade2/trigram_indices_webshop.sql
+++ b/
sql/Pg-upgrade2/trigram_indices_webshop.sql
@@
-1,7
+1,5
@@
-- @tag: trigram_indices_webshop
-- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul
-- @tag: trigram_indices_webshop
-- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul
--- @depends: release_3_5_0 shops
--- @encoding: utf-8
--- @ignore: 1
+-- @depends: release_3_5_0 trigram_extension
CREATE INDEX customer_street_gin_trgm_idx ON customer USING gin (street gin_trgm_ops);
CREATE INDEX customer_street_gin_trgm_idx ON customer USING gin (street gin_trgm_ops);