-- @tag: trigram_indices
-- @description: Trigram Indizes für häufig durchsuchte Spalten
--- @depends: release_3_4_1
--- @encoding: utf-8
--- @may_fail: 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);