X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/8dbd8fa1f3261a7d1069bd635489fa1f7948f2c0..ee8cd38f439e1c8136fe7c1cbb31c5852d1cfd49:/sql/Pg-upgrade2/trigram_indices.sql diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql index 4e78a4702..c8b58e5e9 100644 --- a/sql/Pg-upgrade2/trigram_indices.sql +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -1,9 +1,9 @@ -- @tag: trigram_indices -- @description: Trigram Indizes für häufig durchsuchte Spalten --- @depends: release_3_4_1 +-- @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);