1 -- @tag: delete_translations_on_payment_term_delete
2 -- @description: Übersetzungen löschen, wenn Lieferbedingung gelöscht wird
3 -- @depends: payment_terms_translation2
6 CREATE OR REPLACE FUNCTION generic_translations_delete_on_payment_terms_delete_trigger()
9 DELETE FROM generic_translations
10 WHERE translation_id = OLD.id AND translation_type LIKE 'SL::DB::PaymentTerm/description_long';
15 DROP TRIGGER IF EXISTS after_delete_payment_term_trigger ON payment_terms;
17 CREATE TRIGGER after_delete_payment_term_trigger
18 AFTER DELETE ON payment_terms
19 FOR EACH ROW EXECUTE PROCEDURE generic_translations_delete_on_payment_terms_delete_trigger();
21 -- delete orphaned translations
22 DELETE FROM generic_translations
23 WHERE translation_type LIKE 'SL::DB::PaymentTerm/description_long'
24 AND translation_id NOT IN (SELECT id FROM payment_terms);