-- awooop_conversation_event_hot_path_indexes_2026-07-01_down.sql
-- Roll back the 2026-07-01 P0 hot-path indexes.
--
-- idx_conv_event_recent is intentionally not dropped here because it belongs
-- to the original Phase 7 base schema. This migration only re-ensures it when
-- runtime schema drift is detected.
--
-- CONCURRENTLY must run outside a transaction block.

DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_fingerprints_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_signoz_alerts_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_sentry_issue_ids_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_alert_ids_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_approval_ids_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_incident_ids_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_source_refs_event_ids_gin;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_project_run_id_text_recent;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_project_provider_event_recent;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_project_provider_lower_recent;
DROP INDEX CONCURRENTLY IF EXISTS idx_awooop_conv_event_project_provider_recent;
