[LINET] Anpassung DB-Upgrades auf vorhandene LINET-Struktur

diff --git a/sql/Pg-upgrade2/project_mtime_trigger.sql b/sql/Pg-upgrade2/project_mtime_trigger.sql
index 7b90764fb5921894da76290ea4813162aec2f9ff..4f343bd6d4bf091d21b9b77562c7e15f6c1e6275 100644 (file)
--- 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
 
 -- @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 f110c8dd76a77d0cbb55ece79e624383a1af0e73..ae3129e4b390c1b4112911d2e8ad29b31391fbca 100644 (file)
--- 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 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;
 
 REINDEX INDEX customer_pkey;
 

-DROP    INDEX employee_id_key;
+-- Bei LINET nicht existent:
+-- DROP    INDEX employee_id_key;

 REINDEX INDEX employee_pkey;
 
 REINDEX INDEX employee_pkey;
 

-DROP    INDEX vendor_id_key;
+-- Bei LINET nicht existent:
+-- DROP    INDEX vendor_id_key;

 REINDEX INDEX vendor_pkey;
 
 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;
 
 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;
 
 REINDEX INDEX ap_pkey;
 

-DROP    INDEX invoice_id_key;
+-- Bei LINET nicht existent:
+-- DROP    INDEX invoice_id_key;

 REINDEX INDEX invoice_pkey;
 
 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;
 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 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;
 REINDEX INDEX gl_pkey;
 
 DROP    INDEX department_id_key;