From 3c69a99f86cb4c935becf708a9696920387d9172 Mon Sep 17 00:00:00 2001
From: Werner Hahn <wh@futureworldsearch.net>
Date: Tue, 26 Sep 2017 13:30:12 +0200
Subject: [PATCH] =?utf8?q?WebshopApi:=20Trigramindices=20f=C3=BCr=20Kunden?=
 =?utf8?q?strasse?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 sql/Pg-upgrade2/trigram_indices_webshop.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/Pg-upgrade2/trigram_indices_webshop.sql

diff --git a/sql/Pg-upgrade2/trigram_indices_webshop.sql b/sql/Pg-upgrade2/trigram_indices_webshop.sql
new file mode 100644
index 000000000..e008927d4
--- /dev/null
+++ b/sql/Pg-upgrade2/trigram_indices_webshop.sql
@@ -0,0 +1,7 @@
+-- @tag: trigram_indices_webshop
+-- @description: Trigram Indizes für Fuzzysearch bei der Kundensuche im Shopmodul
+-- @depends: release_3_5_0 shops
+-- @encoding: utf-8
+-- @ignore: 1
+
+CREATE INDEX customer_street_gin_trgm_idx            ON customer        USING gin (street                  gin_trgm_ops);
-- 
2.20.1