-- 005 (L12): suscripciones a newsletter con doble opt-in
CREATE TABLE IF NOT EXISTS newsletter_subs (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(160) NOT NULL UNIQUE,
  articulacion ENUM('cadera','rodilla','hombro','columna','tobillo','todas') DEFAULT 'todas',
  token CHAR(32) NOT NULL,
  confirmado_at DATETIME NULL,
  baja_at DATETIME NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE newsletter_subs
 ADD COLUMN IF NOT EXISTS articulacion ENUM('cadera','rodilla','hombro','columna','tobillo','todas') DEFAULT 'todas',
 ADD COLUMN IF NOT EXISTS token CHAR(32) NULL,
 ADD COLUMN IF NOT EXISTS confirmado_at DATETIME NULL,
 ADD COLUMN IF NOT EXISTS baja_at DATETIME NULL;