Trigramm-Erweiterung installieren & Trigramm-Indizes anlegen

diff --git a/sql/Pg-upgrade2/trigram_extension.sql b/sql/Pg-upgrade2/trigram_extension.sql
new file mode 100644 (file)
index 0000000..3097740
--- /dev/null
+++ b/sql/Pg-upgrade2/trigram_extension.sql
@@ -0,0 +1,7 @@
+-- @tag: trigram_extension
+-- @description: Trigram-Index-Erweiterung installieren
+-- @depends: release_3_5_0
+-- @ignore: 0
+-- @superuser_privileges: 1
+
+CREATE EXTENSION IF NOT EXISTS pg_trgm;

diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql
index e83855b5f5682338731de11e475dbe2c946ceac9..d240d80a74e406b66ea715c266d684fbac99092c 100644 (file)
--- a/sql/Pg-upgrade2/trigram_indices.sql
+++ b/sql/Pg-upgrade2/trigram_indices.sql
@@ -1,8 +1,6 @@
 -- @tag: trigram_indices
 -- @description: Trigram Indizes für häufig durchsuchte Spalten
 -- @tag: trigram_indices
 -- @description: Trigram Indizes für häufig durchsuchte Spalten

--- @depends: release_3_5_0 shops
--- @ignore: 1
-
+-- @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);
 
 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);

diff --git a/sql/Pg-upgrade2/trigram_indices_webshop.sql b/sql/Pg-upgrade2/trigram_indices_webshop.sql
index 24270d852a71ea42b15ddd404438ad4132ab5ef5..399e8dfd6ee380c01e6d5c5271fe186311dbff93 100644 (file)
--- a/sql/Pg-upgrade2/trigram_indices_webshop.sql
+++ b/sql/Pg-upgrade2/trigram_indices_webshop.sql
@@ -1,6 +1,5 @@
 -- @tag: trigram_indices_webshop
 -- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul
 -- @tag: trigram_indices_webshop
 -- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul

--- @depends: release_3_5_0 shops
--- @ignore: 1
+-- @depends: release_3_5_0 trigram_extension

 
 CREATE INDEX customer_street_gin_trgm_idx            ON customer        USING gin (street                  gin_trgm_ops);
 
 CREATE INDEX customer_street_gin_trgm_idx            ON customer        USING gin (street                  gin_trgm_ops);