Supabase Performance Cleanup

-- ============================================
-- DUPLICATE INDEX CLEANUP
-- Run in Supabase SQL Editor
-- ============================================

-- 1. Drop duplicate index on idioms table
DROP INDEX IF EXISTS public.idx_idioms_is_approved;
-- Keeping: idx_idioms_approved

-- 2. Drop duplicate index on class_enrollment table
DROP INDEX IF EXISTS public.idx_enrollment_student_email;
-- Keeping: idx_class_enrollment_student

-- 3. Drop duplicate index on currency_packs table
DROP INDEX IF EXISTS public.idx_currency_packs_stripe_price_id;
-- Keeping: idx_currency_packs_stripe

-- 4. Drop duplicate index on grammar_access table
DROP INDEX IF EXISTS public.idx_grammar_access_user_email;
-- Keeping: idx_grammar_access_user

-- 5. Drop duplicate index on teacher_assignments table
DROP INDEX IF EXISTS public.idx_assignments_class;
DROP INDEX IF EXISTS public.idx_assignments_teacher_email;
-- Keeping: idx_assignment_class_id, idx_assignment_teacher_email

-- 6. Drop duplicate indexes on user_progress table
DROP INDEX IF EXISTS public.idx_user_progress_user;
DROP INDEX IF EXISTS public.idx_user_progress_idiom_id;
-- Keeping: idx_user_progress_created_by, idx_user_progress_idiom

-- Verify cleanup
SELECT 
    schemaname,
    tablename,
    indexname
FROM pg_indexes
WHERE schemaname = 'public'
ORDER BY tablename, indexname;