From 7c920e235989b809f3a546a17f31507d62c00f88 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 20 Jan 2016 09:54:07 +0100 Subject: [PATCH] [LINET] Anpassung DB-Upgrades auf vorhandene LINET-Struktur --- sql/Pg-upgrade2/project_mtime_trigger.sql | 3 ++- sql/Pg-upgrade2/remove_index.sql | 24 +++++++++++++++-------- 2 files changed, 18 insertions(+), 9 deletions(-) diff --git a/sql/Pg-upgrade2/project_mtime_trigger.sql b/sql/Pg-upgrade2/project_mtime_trigger.sql index 7b90764fb..4f343bd6d 100644 --- a/sql/Pg-upgrade2/project_mtime_trigger.sql +++ b/sql/Pg-upgrade2/project_mtime_trigger.sql @@ -3,4 +3,5 @@ -- @depends: release_3_3_0 -- @encoding: utf-8 -CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); +-- Bei LINET bereits existent: +-- CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); diff --git a/sql/Pg-upgrade2/remove_index.sql b/sql/Pg-upgrade2/remove_index.sql index f110c8dd7..ae3129e4b 100644 --- a/sql/Pg-upgrade2/remove_index.sql +++ b/sql/Pg-upgrade2/remove_index.sql @@ -8,28 +8,35 @@ REINDEX INDEX orderitems_pkey; DROP INDEX chart_id_key; REINDEX INDEX chart_pkey; -DROP INDEX customer_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX customer_id_key; REINDEX INDEX customer_pkey; -DROP INDEX employee_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX employee_id_key; REINDEX INDEX employee_pkey; -DROP INDEX vendor_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX vendor_id_key; REINDEX INDEX vendor_pkey; -DROP INDEX ar_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX ar_id_key; REINDEX INDEX ar_pkey; DROP INDEX units_name_idx; REINDEX INDEX units_pkey; -DROP INDEX ap_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX ap_id_key; REINDEX INDEX ap_pkey; -DROP INDEX invoice_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX invoice_id_key; REINDEX INDEX invoice_pkey; -DROP INDEX oe_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX oe_id_key; REINDEX INDEX oe_pkey; DROP INDEX parts_id_key; @@ -38,7 +45,8 @@ REINDEX INDEX parts_pkey; DROP INDEX project_id_key; REINDEX INDEX project_pkey; -DROP INDEX gl_id_key; +-- Bei LINET nicht existent: +-- DROP INDEX gl_id_key; REINDEX INDEX gl_pkey; DROP INDEX department_id_key; -- 2.20.1