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

SELECT COUNT(*) = 1
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'mdp_entity'
  AND COLUMN_NAME = 'tie_breaker_column';

SELECT COUNT(*) = 1
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'mdp_entity'
  AND COLUMN_NAME = 'transform_source_table';

SELECT COUNT(*) = 1
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'mdp_entity_cursor_audit';