From 11d25b53fa311e7d86d499b0350e7aa9a1262859 Mon Sep 17 00:00:00 2001
From: Werner Hahn <wh@futureworldsearch.net>
Date: Tue, 26 Sep 2017 12:23:22 +0200
Subject: [PATCH] WebshopApi: trigram indices und Hinweiss darauf in der
 UPGRADE Datei.

---
 doc/UPGRADE                             | 6 ++++++
 sql/Pg-upgrade2/trigram_indices.sql     | 1 -
 templates/webpages/shop_order/show.html | 2 +-
 3 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/doc/UPGRADE b/doc/UPGRADE
index 4d8054dd3..806016b4d 100644
--- a/doc/UPGRADE
+++ b/doc/UPGRADE
@@ -22,6 +22,12 @@ Upgrade auf v3.5.1
     CREATE EXTENSION IF NOT EXISTS pg_trgm;
     \q
 
+    Wenn die Extension installiert ist können in den beiden Dateien
+    - sql/Pg-upgrade2/trigram_indices_webshop.sql
+    - sql/Pg-upgrade2/trigram_indices.sql
+    das ignore auf 0 gesetzt werden und beide Dateien werden dann beim Anmelden eingespielt.
+    Die Trigramindices sind ein Performancegewinn bei größeren Datenbanken
+
 Upgrade auf v3.5.0
 ===========================
 
diff --git a/sql/Pg-upgrade2/trigram_indices.sql b/sql/Pg-upgrade2/trigram_indices.sql
index 87af0e852..c8b58e5e9 100644
--- a/sql/Pg-upgrade2/trigram_indices.sql
+++ b/sql/Pg-upgrade2/trigram_indices.sql
@@ -4,7 +4,6 @@
 -- @encoding: utf-8
 -- @ignore: 1
 
--- CREATE EXTENSION IF NOT EXISTS pg_trgm;
 
 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/templates/webpages/shop_order/show.html b/templates/webpages/shop_order/show.html
index 561bba8b5..112ffbdef 100644
--- a/templates/webpages/shop_order/show.html
+++ b/templates/webpages/shop_order/show.html
@@ -185,7 +185,7 @@
       </tr>
       <tr class="listrow">
       [% FOREACH pos = IMPORT.shop_order_items %]
-        <td>[% loop.index+1                                      %]</td>
+        <td>[% loop.index+1                                    %]</td>
         <td>[% HTML.escape(pos.partnumber)                     %]</td>
         <td>[% HTML.escape(pos.description)                    %]</td>
         <td>[% pos.quantity_as_number                          %]</td>
-- 
2.20.1