]> wagnertech.de Git - kivitendo-erp.git/blobdiff - sql/Pg-upgrade2/trigram_indices.sql
Merge branch 'b-3.6.1' of ../kivitendo-erp_20220811
[kivitendo-erp.git] / sql / Pg-upgrade2 / trigram_indices.sql
index 87af0e8524fce15a7b247bd99a321e3b01b098ac..d240d80a74e406b66ea715c266d684fbac99092c 100644 (file)
@@ -1,10 +1,6 @@
 -- @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;
+-- @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);