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

SELECT
  (SELECT COUNT(*) FROM information_schema.COLUMNS
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_plan'
     AND COLUMN_NAME='AutoVerifyResult') AS auto_result_col,
  (SELECT COUNT(*) FROM information_schema.TABLES
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_verify_log') AS verify_log_table;