-- Rollback script for Advanced Analytics Migration 001
-- This script safely removes all advanced analytics tables
-- Run this if you need to rollback the migration

-- Drop tables in reverse dependency order
DROP TABLE IF EXISTS auto_clips CASCADE;
DROP TABLE IF EXISTS fatigue_index CASCADE;
DROP TABLE IF EXISTS lineup_metrics CASCADE;
DROP TABLE IF EXISTS decision_analysis CASCADE;
DROP TABLE IF EXISTS transition_effort CASCADE;
DROP TABLE IF EXISTS defensive_reactions CASCADE;
DROP TABLE IF EXISTS spacing_metrics CASCADE;
DROP TABLE IF EXISTS possessions CASCADE;

-- Note: This does NOT affect any existing tables or data
-- All original functionality remains intact