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

SELECT
  (SELECT COUNT(*) FROM information_schema.COLUMNS
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_plan'
     AND COLUMN_NAME='ProblemSeverity') AS problem_severity_col,
  (SELECT COUNT(*) FROM information_schema.COLUMNS
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_plan'
     AND COLUMN_NAME='IsCrossDept') AS is_cross_dept_col;