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

SELECT
  (SELECT COUNT(*) FROM information_schema.TABLES
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_action') AS action_table,
  (SELECT COUNT(*) FROM information_schema.TABLES
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_action_log') AS log_table,
  (SELECT COUNT(*) FROM information_schema.STATISTICS
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_action'
     AND INDEX_NAME='uk_improve_action_seq') AS uk_seq,
  (SELECT COUNT(*) FROM information_schema.STATISTICS
   WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_smart_ops_improvement_action_notice'
     AND INDEX_NAME='uk_improve_action_notice') AS uk_notice;