-- ============================================================
-- Web access blocked (tp-vue only)
-- scripts/Version20261013180000_web_access_blocked_up.sql
--
-- Equivalente a: migrations/Version20261013180000.php
-- Columna nueva; no reutiliza maincompany.blocked (legacy NvCarga).
-- ============================================================

SET NAMES utf8mb4;

SET @db_name := DATABASE();

SET @column_exists := (
  SELECT COUNT(*)
  FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA = @db_name
    AND TABLE_NAME = 'maincompany'
    AND COLUMN_NAME = 'web_access_blocked'
);

SET @sql := IF(
  @column_exists = 0,
  'ALTER TABLE `maincompany` ADD `web_access_blocked` TINYINT(1) NOT NULL DEFAULT 0',
  'SELECT ''Column web_access_blocked already exists'' AS info'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

UPDATE `maincompany`
SET `web_access_blocked` = 1
WHERE id IN (427, 497);