X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/6dbfb1669f2c3391b4323f0b606439f0c6148b47..1f0d7da266e23a443c47aaa2dbab844e6be50ee4:/sql/Pg-upgrade2/trigram_indices.sql diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql index 87af0e852..e83855b5f 100644 --- a/sql/Pg-upgrade2/trigram_indices.sql +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -1,10 +1,8 @@ -- @tag: trigram_indices -- @description: Trigram Indizes für häufig durchsuchte Spalten -- @depends: release_3_5_0 shops --- @encoding: utf-8 -- @ignore: 1 --- CREATE EXTENSION IF NOT EXISTS pg_trgm; CREATE INDEX customer_customernumber_gin_trgm_idx ON customer USING gin (customernumber gin_trgm_ops); CREATE INDEX customer_name_gin_trgm_idx ON customer USING gin (name gin_trgm_ops);