-- ============================================================
-- NÉBULA OS · Fase 4 — Portal del cliente (token por empresa)
-- Ejecutar UNA vez (repetir sin riesgo).
-- ============================================================
USE nebula_os;

SET @existe := (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = 'nebula_os' AND TABLE_NAME = 'empresas' AND COLUMN_NAME = 'portal_token');
SET @sql := IF(@existe = 0,
  'ALTER TABLE empresas ADD COLUMN portal_token VARCHAR(64) NULL UNIQUE',
  'SELECT 1');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;