AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.591.verify.sql

-- 有 S5_L1_004 值的每个租户/工厂，字典行和启用的布局行都要在。
-- 表还不存在时放行（首次建库）。
SELECT
  (SELECT COUNT(*) FROM information_schema.TABLES
    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'ado_s9_kpi_value_l1_day') = 0
  OR (
    SELECT COUNT(*) FROM (
      SELECT DISTINCT v.tenant_id, v.factory_id
      FROM ado_s9_kpi_value_l1_day v
      WHERE v.metric_code = 'S5_L1_004' AND v.is_deleted = 0
        AND (
          NOT EXISTS (
            SELECT 1 FROM ado_smart_ops_kpi_master k
            WHERE k.TenantId = v.tenant_id AND k.MetricCode = 'S5_L1_004'
          )
          OR NOT EXISTS (
            SELECT 1 FROM ado_smart_ops_layout_item l
            WHERE l.TenantId = v.tenant_id
              AND l.FactoryId = v.factory_id
              AND l.MetricLevel = 1
              AND l.IsEnabled = 1
              AND l.MetricCode COLLATE utf8mb4_general_ci = 'S5_L1_004'
          )
        )
    ) missing
  ) = 0;