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

-- 1.0.563.verify.sql — 每条 SELECT 必须返回真值。宽表与 FQC 表可能尚未建出，只在表存在时断言。

SELECT COUNT(*) = 1
  FROM information_schema.tables
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_std_inv_trans_unmapped';

SELECT
  (SELECT COUNT(*) FROM information_schema.tables
    WHERE table_schema = DATABASE() AND table_name = 'dwd_order_schedule_trans') = 0
  OR
  (SELECT COUNT(*) FROM information_schema.columns
    WHERE table_schema = DATABASE() AND table_name = 'dwd_order_schedule_trans' AND column_name = 'doc_type') >= 1;

SELECT
  (SELECT COUNT(*) FROM information_schema.tables
    WHERE table_schema = DATABASE() AND table_name = 'mdp_std_fqc_task') = 0
  OR
  (SELECT COUNT(*) FROM information_schema.statistics
    WHERE table_schema = DATABASE() AND table_name = 'mdp_std_fqc_task'
      AND index_name = 'uk_mdp_std_fqc_task' AND column_name = 'source_system') >= 1;

SELECT
  (SELECT COUNT(*) FROM information_schema.tables
    WHERE table_schema = DATABASE() AND table_name = 'mdp_inbound_grant') = 0
  OR
  (SELECT COUNT(*) FROM information_schema.columns
    WHERE table_schema = DATABASE() AND table_name = 'mdp_inbound_grant' AND column_name = 'min_contract_version') >= 1;