-- 003: reclamación de fichas y campos de directorio
CREATE TABLE IF NOT EXISTS claim_requests (
  id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT UNSIGNED NOT NULL,
  entity_type VARCHAR(30) NOT NULL,
  entity_id BIGINT UNSIGNED NOT NULL,
  mensaje TEXT NULL,
  adjunto VARCHAR(255) NULL,
  estado ENUM('pendiente','aprobada','rechazada') NOT NULL DEFAULT 'pendiente',
  resuelto_por BIGINT UNSIGNED NULL,
  resuelto_at DATETIME NULL,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY uq_claim (user_id, entity_type, entity_id),
  KEY idx_estado (estado)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- titularidad de ficha reclamada
ALTER TABLE cirujanos ADD COLUMN IF NOT EXISTS owner_user_id BIGINT UNSIGNED NULL;
ALTER TABLE centros ADD COLUMN IF NOT EXISTS owner_user_id BIGINT UNSIGNED NULL;
ALTER TABLE fabricantes ADD COLUMN IF NOT EXISTS owner_user_id BIGINT UNSIGNED NULL;
ALTER TABLE productos ADD COLUMN IF NOT EXISTS owner_user_id BIGINT UNSIGNED NULL;
ALTER TABLE cirujanos ADD COLUMN IF NOT EXISTS subespecialidad VARCHAR(80) NULL;