-- Migration 006: Add customer app authentication (login/register/password reset)
-- Run this once on your existing database via phpMyAdmin or the mysql CLI.

ALTER TABLE customers
    ADD COLUMN email VARCHAR(150) NULL AFTER phone,
    ADD COLUMN password_hash VARCHAR(255) NULL AFTER email,
    ADD COLUMN reset_token VARCHAR(64) NULL AFTER password_hash,
    ADD COLUMN reset_token_expires DATETIME NULL AFTER reset_token;