7c751617e5
The "Frist verpasst" cascade covered DE PatG/ZPO, EPA Art.122 and DPMA
Wiedereinsetzung paths but had no UPC option, even though UPC R.320 RoP
grants re-establishment of rights with the same shape (2 months from
removal of the obstacle, 12-month outer limit).
Migration 063 adds:
- trigger_event id 207 "Wegfall des Hindernisses (UPC R.320)" tied to
the existing wiedereinsetzung concept, so the concept card picks
up a UPC pill alongside DE / EPA / DPMA.
- event_categories leaf frist-verpasst.upc at sort_order 50 so UPC
reads first under "Frist verpasst" (national + EPA siblings stay
at 100/200/300/400).
- event_category_concepts junction linking the new leaf to the
wiedereinsetzung concept; NULL proceeding_type_code mirrors the
sibling pattern (cross-cutting trigger pills bypass the forum
filter by design — per-leaf narrowing is part of the IA-reframe
issue #16).
Migration applied to live Supabase; matview refreshed; tracker bumped
to v63 so the boot-time runner skips re-applying.
Refs m/paliad#14 section C.
15 lines
610 B
SQL
15 lines
610 B
SQL
-- 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';
|