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

SELECT
  (SELECT COUNT(*) FROM information_schema.TABLES
   WHERE TABLE_SCHEMA=DATABASE()
     AND TABLE_NAME='ado_smart_ops_kpi_master')=0
  OR (
    (SELECT COUNT(*) FROM information_schema.COLUMNS
     WHERE TABLE_SCHEMA=DATABASE()
       AND TABLE_NAME='ado_smart_ops_kpi_master'
       AND COLUMN_NAME='FreshnessSlaDays')=1
    AND
    (SELECT COUNT(*) FROM ado_smart_ops_kpi_master
     WHERE IsHomePage=1 AND IsEnabled=1
       AND (FreshnessSlaDays IS NULL OR FreshnessSlaDays<=0))=0
  );