From 34ea9b39f4faf945dbe187c5e057cb4455f6db3c Mon Sep 17 00:00:00 2001
From: "G. Richardson" <information@kivitendo-premium.de>
Date: Mon, 2 Nov 2015 14:12:35 +0100
Subject: [PATCH] =?utf8?q?Alte=20DB-Indizes=20entfernt/aufger=C3=A4umt?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

werden seit Einführung von Primary Keys in den entsprechenden Tabellen
nicht mehr benötigt.
---
 sql/Pg-upgrade2/remove_index.sql | 45 ++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 sql/Pg-upgrade2/remove_index.sql

diff --git a/sql/Pg-upgrade2/remove_index.sql b/sql/Pg-upgrade2/remove_index.sql
new file mode 100644
index 000000000..f110c8dd7
--- /dev/null
+++ b/sql/Pg-upgrade2/remove_index.sql
@@ -0,0 +1,45 @@
+-- @tag: remove_index
+-- @description: Nicht mehr benötigte Indizes löschen (es gibt nun einen Primary Key)
+-- @depends: release_3_3_0
+
+DROP    INDEX orderitems_id_key;
+REINDEX INDEX orderitems_pkey;
+
+DROP    INDEX chart_id_key;
+REINDEX INDEX chart_pkey;
+
+DROP    INDEX customer_id_key;
+REINDEX INDEX customer_pkey;
+
+DROP    INDEX employee_id_key;
+REINDEX INDEX employee_pkey;
+
+DROP    INDEX vendor_id_key;
+REINDEX INDEX vendor_pkey;
+
+DROP    INDEX ar_id_key;
+REINDEX INDEX ar_pkey;
+
+DROP    INDEX units_name_idx;
+REINDEX INDEX units_pkey;
+
+DROP    INDEX ap_id_key;
+REINDEX INDEX ap_pkey;
+
+DROP    INDEX invoice_id_key;
+REINDEX INDEX invoice_pkey;
+
+DROP    INDEX oe_id_key;
+REINDEX INDEX oe_pkey;
+
+DROP    INDEX parts_id_key;
+REINDEX INDEX parts_pkey;
+
+DROP    INDEX project_id_key;
+REINDEX INDEX project_pkey;
+
+DROP    INDEX gl_id_key;
+REINDEX INDEX gl_pkey;
+
+DROP    INDEX department_id_key;
+REINDEX INDEX department_pkey;
-- 
2.20.1