From b08b354b26487b5fdb3bcb08602e33ddbb1ac255 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Tue, 10 Oct 2017 11:22:57 +0200 Subject: [PATCH] Trigramm-Erweiterung installieren & Trigramm-Indizes anlegen --- sql/Pg-upgrade2/trigram_extension.sql | 7 +++++++ sql/Pg-upgrade2/trigram_indices.sql | 4 +--- sql/Pg-upgrade2/trigram_indices_webshop.sql | 3 +-- 3 files changed, 9 insertions(+), 5 deletions(-) create mode 100644 sql/Pg-upgrade2/trigram_extension.sql diff --git a/sql/Pg-upgrade2/trigram_extension.sql b/sql/Pg-upgrade2/trigram_extension.sql new file mode 100644 index 000000000..309774078 --- /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 e83855b5f..d240d80a7 100644 --- 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 --- @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); diff --git a/sql/Pg-upgrade2/trigram_indices_webshop.sql b/sql/Pg-upgrade2/trigram_indices_webshop.sql index 24270d852..399e8dfd6 100644 --- 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 --- @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); -- 2.20.1