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

-- 1.0.572.verify.sql
SELECT COUNT(*) = 2
  FROM information_schema.tables
 WHERE table_schema = DATABASE()
   AND table_name IN ('mdp_employee_position_map','mdp_source_capability');

SELECT COUNT(*) = 1
  FROM information_schema.statistics
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_employee_position_map'
   AND index_name = 'uk_emp_pos_map'
   AND column_name = 'src_position_raw';

SELECT COUNT(*) = 8
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name IN ('ado_s9_kpi_value_l1_day','ado_s9_kpi_value_l2_day','ado_s9_kpi_value_l3_day','ado_s9_kpi_value_l4_day')
   AND column_name IN ('result_status','result_reason');

SELECT COUNT(*) = 0
  FROM ado_s9_kpi_value_l1_day
 WHERE result_status IS NULL;

SELECT COUNT(*) = 0
  FROM ado_s9_kpi_value_l2_day
 WHERE result_status IS NULL;

SELECT COUNT(*) = 0
  FROM ado_s9_kpi_value_l3_day
 WHERE result_status IS NULL;

SELECT COUNT(*) = 0
  FROM ado_s9_kpi_value_l4_day
 WHERE result_status IS NULL;

SELECT COUNT(*) = 2
  FROM mdp_source_capability
 WHERE semantic_code = 'FG_RECEIPT_TIME' AND supported = 0
   AND source_system IN ('T8','DOPDEMORQ_SQLSERVER');

SELECT COUNT(*) = 1
  FROM mdp_source_capability
 WHERE source_system = 'DOPDEMORQ_SQLSERVER' AND semantic_code = 'DOC_QTY_CLOSE' AND supported = 0;

SELECT COUNT(*) = 0
  FROM mdp_source_capability
 WHERE source_system = 'T8' AND semantic_code = 'INV_LOCATION';

SELECT COUNT(*) = 0
  FROM mdp_source_capability
 WHERE semantic_code = 'INV_BAL_AMOUNT' AND supported = 0;