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

-- 1.0.570.verify.sql
SELECT COUNT(*) = 1
  FROM information_schema.tables
 WHERE table_schema = DATABASE()
   AND table_name = 'ado_kpi_baseline_snapshot';

SELECT COUNT(*) = 8
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'ado_kpi_baseline_snapshot'
   AND column_name IN (
     'snapshot_code','tenant_id','factory_id','module_code',
     'metric_code','lvl','biz_date','metric_value');

SELECT COUNT(*) = 1
  FROM information_schema.statistics
 WHERE table_schema = DATABASE()
   AND table_name = 'ado_kpi_baseline_snapshot'
   AND index_name = 'uk_kpi_baseline_snapshot'
   AND column_name = 'factory_id';