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

-- 1.0.573.verify.sql
SELECT COUNT(*) = 4
  FROM information_schema.COLUMNS
 WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_std_t8_kc_tz_list'
   AND COLUMN_NAME IN ('hw','ckcode','pcnoid','kcsl');

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

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

SELECT COUNT(*) = 4
  FROM information_schema.TABLES
 WHERE TABLE_SCHEMA=DATABASE()
   AND TABLE_NAME IN ('mdp_stg_inv_trans_inbound','mdp_stg_wo_line','mdp_stg_wo_bom','mdp_stg_inv_bal_monthly');

SELECT COUNT(*) = 0
  FROM mdp_entity
 WHERE entity_code IN ('S7_FQC_TASK_SQLSERVER','S7_FQC_RESULT_SQLSERVER','S7_FQC_RESULT_DETAIL_SQLSERVER')
   AND status=0;

SELECT COUNT(*) = 1
  FROM mdp_entity
 WHERE entity_code='S6_EMP_WORK_ORD_TRANS_SQLSERVER' AND status=1;

SELECT COUNT(*) = 0
  FROM mdp_std_inv_trans
 WHERE source_system='DOPDEMORQ_SQLSERVER' AND src_trans_type_raw='iss-so' AND biz_doc_type='SALES_SHIP';

SELECT COUNT(*) = 0
  FROM mdp_stg_t8_kc_tz_list
 WHERE IFNULL(source_system,'') NOT IN ('T8','T8_V5_SQLSERVER');