with open(r'c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\sql\PASTELERIAS-struct.sql', 'r', encoding='utf-8', errors='ignore') as f:
    text = f.read()

import re
for table in ['ge_clientes', 'ge_clientes_destinos']:
    match = re.search(r'CREATE TABLE\s+[`"]?' + table + r'[`"]?\s*\((.*?)\)\s*ENGINE', text, re.DOTALL | re.IGNORECASE)
    if match:
        print(f'=== {table} ===')
        for line in match.group(1).splitlines():
            line = line.strip()
            if line and not line.startswith('KEY') and not line.startswith('PRIMARY') and not line.startswith('CONSTRAINT'):
                print('  ', line)
