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

SELECT COUNT(*) = 1
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'ado_smart_ops_kpi_atomic_day'
  AND COLUMN_NAME = 'is_deleted'
  AND DATA_TYPE = 'tinyint'
  AND IS_NULLABLE = 'NO'
  AND COALESCE(COLUMN_DEFAULT, '') = '0';