#!/usr/bin/env python3
"""Migración v5 — agrega columna email a usuarios."""
import sqlite3, sys

DB = sys.argv[1] if len(sys.argv) > 1 else "/home/embalado/bascunan.db"

MIGRATIONS = [
    "ALTER TABLE usuarios ADD COLUMN email TEXT",
]

conn = sqlite3.connect(DB)
for sql in MIGRATIONS:
    try:
        conn.execute(sql)
        print(f"  + {sql}")
    except sqlite3.OperationalError as e:
        print(f"  ~ ya existe ({e})")
conn.commit()
conn.close()
print("Migración v5 completa.")