-- Rollback DIEU-28 v2.0 candidate package; reverse-FK order and strictly scoped. BEGIN; WITH pub AS ( SELECT id FROM tac_publication WHERE doc_code = 'DIEU-28' AND version = 'v2.0' ), scoped_lu AS ( SELECT id FROM tac_logical_unit WHERE doc_code = 'DIEU-28' AND canonical_address LIKE 'D38-DIEU28-%' ), scoped_uv AS ( SELECT uv.id FROM tac_unit_version uv JOIN scoped_lu lu ON lu.id = uv.logical_unit_id ) DELETE FROM tac_publication_member pm USING pub, scoped_lu lu, scoped_uv uv WHERE pm.publication_id = pub.id AND pm.logical_unit_id = lu.id AND pm.unit_version_id = uv.id;

WITH scoped_lu AS ( SELECT id FROM tac_logical_unit WHERE doc_code = 'DIEU-28' AND canonical_address LIKE 'D38-DIEU28-%' ) DELETE FROM tac_unit_version uv USING scoped_lu lu WHERE uv.logical_unit_id = lu.id;

DELETE FROM tac_logical_unit WHERE doc_code = 'DIEU-28' AND canonical_address LIKE 'D38-DIEU28-%';

DELETE FROM tac_publication WHERE doc_code = 'DIEU-28' AND version = 'v2.0';

-- COMMIT; -- ROLLBACK;