AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.593.sql

-- 首页指标新鲜度 SLA。月度口径按 code 写 45，实时写 1，其余首页指标写 7。
SET @has_freshness_sla := (
  SELECT COUNT(*) FROM information_schema.COLUMNS
  WHERE TABLE_SCHEMA=DATABASE()
    AND TABLE_NAME='ado_smart_ops_kpi_master'
    AND COLUMN_NAME='FreshnessSlaDays'
);
SET @ddl := IF(
  @has_freshness_sla=0,
  'ALTER TABLE ado_smart_ops_kpi_master ADD COLUMN FreshnessSlaDays int NULL COMMENT ''首页数据新鲜度SLA（自然日）'' AFTER StatFrequency',
  'SELECT 1'
);
PREPARE stmt FROM @ddl;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

UPDATE ado_smart_ops_kpi_master
SET FreshnessSlaDays=45, UpdatedAt=NOW()
WHERE MetricCode IN
  ('S5_L1_003','S5_L1_004','S6_L1_003','S7_L1_003','S9_L1_001');

UPDATE ado_smart_ops_kpi_master
SET FreshnessSlaDays=1, UpdatedAt=NOW()
WHERE IsHomePage=1 AND IsEnabled=1
  AND StatFrequency='实时'
  AND FreshnessSlaDays IS NULL;

UPDATE ado_smart_ops_kpi_master
SET FreshnessSlaDays=7, UpdatedAt=NOW()
WHERE IsHomePage=1 AND IsEnabled=1
  AND FreshnessSlaDays IS NULL;