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

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

SELECT
  (SELECT COUNT(*) FROM information_schema.TABLES
    WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='ado_source_domain_tenant_map') = 0
  OR (
    (SELECT COUNT(*) FROM ado_source_domain_tenant_map WHERE IFNULL(system_code,'')='') = 0
    AND
    (SELECT COUNT(*) FROM ado_source_domain_tenant_map
      WHERE system_code='T8' AND domain='pbxfxp' AND tenant_id=797403760988229 AND status=1) = 1
  );