-- 002: guías editoriales y cuestionarios PROM
CREATE TABLE IF NOT EXISTS guias (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  slug VARCHAR(160) NOT NULL UNIQUE,
  nombre VARCHAR(200) NOT NULL,
  articulacion ENUM('cadera','rodilla','hombro','columna','tobillo','codo','atm') NULL,
  estado_editorial ENUM('borrador','revision','publicado','archivado') NOT NULL DEFAULT 'borrador',
  es_demo TINYINT(1) NOT NULL DEFAULT 0,
  resumen_corto TEXT NULL,
  contenido_paciente MEDIUMTEXT NULL,
  contenido_pro MEDIUMTEXT NULL,
  faq JSON NULL,
  tiene_pdf TINYINT(1) NOT NULL DEFAULT 0,
  meta_title VARCHAR(70) NULL,
  meta_description VARCHAR(160) NULL,
  revisado_por BIGINT UNSIGNED NULL,
  fecha_revision DATE NULL,
  fuentes JSON NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  deleted_at DATETIME NULL,
  KEY idx_guia (articulacion, estado_editorial, deleted_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS prom_cuestionarios (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  slug VARCHAR(160) NOT NULL UNIQUE,
  titulo VARCHAR(200) NOT NULL,
  articulacion ENUM('cadera','rodilla','hombro','columna','tobillo','codo','atm') NULL,
  items JSON NOT NULL,
  nota TEXT NULL,
  activo TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;