1 -- @tag: delete_translations_on_delivery_term_delete
2 -- @description: Übersetzungen löschen, wenn Lieferbedingung gelöscht wird
3 -- @depends: delivery_terms
5 CREATE OR REPLACE FUNCTION generic_translations_delete_on_delivery_terms_delete_trigger()
8 DELETE FROM generic_translations
9 WHERE translation_id = OLD.id AND translation_type LIKE 'SL::DB::DeliveryTerm/description_long';
14 DROP TRIGGER IF EXISTS after_delete_delivery_term_trigger ON delivery_terms;
16 CREATE TRIGGER after_delete_delivery_term_trigger
17 AFTER DELETE ON delivery_terms
18 FOR EACH ROW EXECUTE PROCEDURE generic_translations_delete_on_delivery_terms_delete_trigger();
20 -- delete orphaned translations
21 DELETE FROM generic_translations
22 WHERE translation_type LIKE 'SL::DB::DeliveryTerm/description_long'
23 AND translation_id NOT IN (SELECT id FROM delivery_terms);