-- Reverse t-paliad-157 / m/paliad#14 section C: removes the UPC leaf under
-- "Frist verpasst" along with its junction row and the cross-cutting
-- trigger_event for UPC R.320 Wiedereinsetzung.

DELETE FROM paliad.event_category_concepts
 WHERE event_category_id = (SELECT id FROM paliad.event_categories  WHERE slug = 'frist-verpasst.upc')
   AND concept_id        = (SELECT id FROM paliad.deadline_concepts WHERE slug = 'wiedereinsetzung');

DELETE FROM paliad.event_categories
 WHERE slug = 'frist-verpasst.upc';

DELETE FROM paliad.trigger_events
 WHERE id = 207
   AND code = 'wegfall_hindernisses_upc';
