sql/Pg-upgrade2/remove_redundant_cvar_delete_triggers.sql

   1 -- @tag: remove_redundant_cvar_delete_triggers
   2 -- @description: Entfernt doppelte Trigger zum Löschen von benutzerdefinierten Variablen
   3 -- @depends: custom_variables_delete_via_trigger custom_variables_delete_via_trigger_2 delete_cvars_on_trans_deletion
   4
   5 -- drop triggers
   6 DROP TRIGGER IF EXISTS delete_orderitems_dependencies           ON orderitems;
   7 DROP TRIGGER IF EXISTS delete_delivery_order_items_dependencies ON delivery_order_items;
   8 DROP TRIGGER IF EXISTS delete_invoice_dependencies              ON invoice;
   9 DROP TRIGGER IF EXISTS delete_cv_custom_variables               ON customer;
  10 DROP TRIGGER IF EXISTS delete_cv_custom_variables               ON vendor;
  11 DROP TRIGGER IF EXISTS delete_contact_custom_variables          ON contacts;
  12 DROP TRIGGER IF EXISTS delete_part_custom_variables             ON parts;
  13 DROP TRIGGER IF EXISTS delete_project_custom_variables          ON project;
  14
  15 -- drop functions
  16 DROP FUNCTION IF EXISTS orderitems_before_delete_trigger();
  17 DROP FUNCTION IF EXISTS delivery_order_items_before_delete_trigger();
  18 DROP FUNCTION IF EXISTS invoice_before_delete_trigger();
  19 DROP FUNCTION IF EXISTS delete_cv_custom_variables_trigger();
  20 DROP FUNCTION IF EXISTS delete_contact_custom_variables_trigger();
  21 DROP FUNCTION IF EXISTS delete_part_custom_variables_trigger();
  22 DROP FUNCTION IF EXISTS delete_project_custom_variables_trigger();