-- ============================================================================ -- AXIS SUBSTRATE DROP / REVERSAL (CLONE ONLY) — restores clone to pre-build state -- Target DB: directus_gov_test_20260602 (NON-PRODUCTION CLONE) -- Removes everything the build created. Existing pipeline (ownership/gap/scanner) -- is untouched because the build never ALTERed any pre-existing table. -- ============================================================================ \set ON_ERROR_STOP on BEGIN; DO $$ DECLARE v_db text; BEGIN SELECT current_database() INTO v_db; IF v_db NOT LIKE 'directus_gov_test_%' THEN RAISE EXCEPTION 'REFUSING: % not a clone', v_db; END IF; END $$;

DROP VIEW IF EXISTS v_axis_topic_parentage_conflict; DROP VIEW IF EXISTS v_axis_issue_payload; DROP VIEW IF EXISTS v_axis_coverage_summary; DROP VIEW IF EXISTS v_axis_missing_assignment; DROP VIEW IF EXISTS v_axis_registry_coverage; DROP VIEW IF EXISTS v_axis_assignment_quality; DROP VIEW IF EXISTS v_axis_coverage_gap; DROP VIEW IF EXISTS v_axis_effective_owner; DROP VIEW IF EXISTS v_axis_required_cell; DROP TABLE IF EXISTS axis_candidate_finding; DROP TABLE IF EXISTS axis_object_ownership; DROP TABLE IF EXISTS axis_assignment; DROP TABLE IF EXISTS coverage_rule; DROP TABLE IF EXISTS axis_value; DROP TABLE IF EXISTS axis_registry;

DO $$ DECLARE n int; BEGIN SELECT count() INTO n FROM information_schema.tables WHERE table_schema='public' AND table_name IN ('axis_registry','axis_value','axis_assignment','coverage_rule','axis_object_ownership','axis_candidate_finding'); IF n<>0 THEN RAISE EXCEPTION 'DROP incomplete: % tables remain', n; END IF; RAISE NOTICE 'DROP OK: all axis substrate removed; clone restored to pre-build state.'; END $$; COMMIT; SELECT count() AS axis_tables_remaining FROM information_schema.tables WHERE table_schema='public' AND table_name IN ('axis_registry','axis_value','axis_assignment','coverage_rule','axis_object_ownership','axis_candidate_finding');