X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fdelete_close_follow_ups_when_order_is_deleted_closed.sql;h=f2963f5f3d70c3958b66f83c06c51c1804a5a137;hb=a9d9ca02abd3a0ff1e43f23888142266174bec55;hp=f22e682168744dfa261b514ce7f5ca7610a3219d;hpb=d41acd2d498242ad691ea870fd06690a2fbfb253;p=kivitendo-erp.git

diff --git a/sql/Pg-upgrade2/delete_close_follow_ups_when_order_is_deleted_closed.sql b/sql/Pg-upgrade2/delete_close_follow_ups_when_order_is_deleted_closed.sql
index f22e68216..f2963f5f3 100644
--- a/sql/Pg-upgrade2/delete_close_follow_ups_when_order_is_deleted_closed.sql
+++ b/sql/Pg-upgrade2/delete_close_follow_ups_when_order_is_deleted_closed.sql
@@ -1,9 +1,8 @@
 -- @tag: delete_close_follow_ups_when_order_is_deleted_closed
--- @description: Wiedervorlagen lößchen/schließen, wenn dazugehörige Belege gelöscht/geschlossen werden
--- @depends: release_3_0_0
+-- @description: Wiedervorlagen löschen/schließen, wenn dazugehörige Belege gelöscht/geschlossen werden
+-- @depends: delete_close_follow_ups_when_order_is_deleted_closed_fkey_deletion
 
-ALTER TABLE follow_up_links DROP CONSTRAINT follow_up_links_follow_up_id_fkey;
-ALTER TABLE follow_up_links ADD FOREIGN KEY (follow_up_id) REFERENCES follow_ups (id) ON DELETE CASCADE;
+ALTER TABLE follow_up_links ADD CONSTRAINT follow_up_links_follow_up_id_fkey FOREIGN KEY (follow_up_id) REFERENCES follow_ups (id) ON DELETE CASCADE;
 
 CREATE OR REPLACE FUNCTION follow_up_delete_notes_trigger()
 RETURNS TRIGGER AS $$