import re

input_file = r'd:\wamp64\www\agents\final_master_schema.sql'
output_file = r'd:\wamp64\www\agents\cleaned_final_master_schema.sql'

with open(input_file, 'r', encoding='latin1') as f:
    content = f.read()

# 1. Remover prefijo de base de datos
content = content.replace('`educa25_docente`.', '')

# 2. Reemplazar Definidores por root@localhost
content = re.sub(r'DEFINER=`.*?`@`.*?`', 'DEFINER=`root`@`localhost` ', content)

# 3. Estandarizar a InnoDB y limpiar formatos incompatibles
content = content.replace('ENGINE=MyISAM', 'ENGINE=InnoDB')
content = content.replace('ROW_FORMAT=FIXED', '')
content = content.replace('ROW_FORMAT=DYNAMIC', '')

with open(output_file, 'w', encoding='latin1') as f:
    f.write(content)

print(f"Esquema maestro limpiado y estandarizado en: {output_file}")