-- 014 (L30): prehab programado ligado a la fecha de cirugía
CREATE TABLE IF NOT EXISTS prehab_planes (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT UNSIGNED NOT NULL,
  episodio_id BIGINT UNSIGNED NULL,
  articulacion ENUM('cadera','rodilla','hombro','columna','tobillo') NOT NULL,
  fecha_cirugia DATE NOT NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY uq_plan (user_id, fecha_cirugia)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS prehab_hitos (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  plan_id BIGINT UNSIGNED NOT NULL,
  offset_dias SMALLINT NOT NULL,
  titulo VARCHAR(200) NOT NULL,
  contenido VARCHAR(1200) NOT NULL,
  completado_at DATETIME NULL,
  KEY idx_ph (plan_id, offset_dias)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;