X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fcustom_variables_delete_via_trigger.pl;h=72327310e02564e06c675dc3f122636c425a0110;hb=f15f5e4321df31d2279edb480e9c7fc15c3af31c;hp=f73a6808fe2e03d245e2ea2220996c976c43c897;hpb=dbd67e4387f1d33ce1ffdc505fad7fdd0eee7f29;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/custom_variables_delete_via_trigger.pl b/sql/Pg-upgrade2/custom_variables_delete_via_trigger.pl
index f73a6808f..72327310e 100644
--- a/sql/Pg-upgrade2/custom_variables_delete_via_trigger.pl
+++ b/sql/Pg-upgrade2/custom_variables_delete_via_trigger.pl
@@ -10,62 +10,8 @@ use strict;
 use parent qw(SL::DBUpgrade2::Base);
 
 sub run {
-  my ($self) = @_;
-
-  my @queries = (
-    #Delete orphaned entries
-    q|DELETE FROM custom_variables WHERE sub_module = 'orderitems'
-                                   AND NOT EXISTS (SELECT id FROM orderitems WHERE orderitems.id = custom_variables.trans_id)|,
-    q|DELETE FROM custom_variables WHERE sub_module = 'delivery_order_items'
-                                   AND NOT EXISTS (SELECT id FROM delivery_order_items WHERE delivery_order_items.id = custom_variables.trans_id)|,
-    q|DELETE FROM custom_variables WHERE sub_module = 'invoice'
-                                   AND NOT EXISTS (SELECT id FROM invoice WHERE invoice.id = custom_variables.trans_id)|,
-
-    #Create trigger
-    q|CREATE OR REPLACE FUNCTION orderitems_before_delete_trigger() RETURNS trigger AS $$
-        BEGIN
-          DELETE FROM custom_variables WHERE sub_module = 'orderitems' AND trans_id = OLD.id;
-
-          RETURN OLD;
-        END;
-      $$ LANGUAGE plpgsql|,
-
-    q|DROP TRIGGER IF EXISTS delete_orderitems_dependencies ON orderitems|,
-
-    q|CREATE TRIGGER delete_orderitems_dependencies
-      BEFORE DELETE ON orderitems
-      FOR EACH ROW EXECUTE PROCEDURE orderitems_before_delete_trigger()|,
-
-    q|CREATE OR REPLACE FUNCTION delivery_order_items_before_delete_trigger() RETURNS trigger AS $$
-        BEGIN
-          DELETE FROM custom_variables WHERE sub_module = 'delivery_order_items' AND trans_id = OLD.id;
-
-          RETURN OLD;
-        END;
-      $$ LANGUAGE plpgsql|,
-
-    q|DROP TRIGGER IF EXISTS delete_delivery_order_items_dependencies ON delivery_order_items|,
-
-    q|CREATE TRIGGER delete_delivery_order_items_dependencies
-      BEFORE DELETE ON delivery_order_items
-      FOR EACH ROW EXECUTE PROCEDURE delivery_order_items_before_delete_trigger()|,
-
-    q|CREATE OR REPLACE FUNCTION invoice_before_delete_trigger() RETURNS trigger AS $$
-        BEGIN
-          DELETE FROM custom_variables WHERE sub_module = 'invoice' AND trans_id = OLD.id;
-
-          RETURN OLD;
-        END;
-      $$ LANGUAGE plpgsql|,
-
-    q|DROP TRIGGER IF EXISTS delete_invoice_dependencies ON invoice|,
-
-    q|CREATE TRIGGER delete_invoice_dependencies
-      BEFORE DELETE ON invoice
-      FOR EACH ROW EXECUTE PROCEDURE invoice_before_delete_trigger()|
-    );
-
-  $self->db_query($_) for @queries;
+  # This script is intentionally empty, because there is another upgrade script
+  # which provides this functionality.
 
   return 1;
 }