X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftrigram_indices.sql;h=d240d80a74e406b66ea715c266d684fbac99092c;hb=30b4a78c4100ebdcd6e6917fbcbf1d12f4f7b4d6;hp=4e78a47028014f481841d21bc29a6d20e3af887c;hpb=f40363c5162d350c51c79d157fc16bdf5571399f;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql index 4e78a4702..d240d80a7 100644 --- a/sql/Pg-upgrade2/trigram_indices.sql +++ b/sql/Pg-upgrade2/trigram_indices.sql @@ -1,9 +1,6 @@ -- @tag: trigram_indices -- @description: Trigram Indizes für häufig durchsuchte Spalten --- @depends: release_3_4_1 --- @encoding: utf-8 - -CREATE EXTENSION IF NOT EXISTS pg_trgm; +-- @depends: release_3_5_0 trigram_extension 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);