drop_indices.py

#!/usr/bin/env python3
from connection import get_connection

conn = get_connection()
cursor = conn.cursor()

# Quitar índices
cursor.execute('ALTER TABLE `creacion` DROP INDEX `idx_uid`')
cursor.execute('ALTER TABLE `creacion` DROP INDEX `idx_correo`')
conn.commit()

# Verificar
cursor.execute('SHOW INDEXES FROM `creacion`')
indices = cursor.fetchall()

print("✅ Índices eliminados\n")
print("Índices finales:")
for idx in indices:
    print(f"  {idx[4]}: {idx[2]}")

cursor.close()
conn.close()