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