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

-- 1.0.536.verify.sql — 每条 SELECT 必须返回真值

SELECT COUNT(*) = 6
  FROM information_schema.tables
 WHERE table_schema = DATABASE()
   AND table_name IN (
     'mdp_inbound_grant', 'mdp_inbound_request', 'mdp_inbound_envelope',
     'mdp_inbound_snapshot', 'mdp_inbound_conflict', 'mdp_field_map');

SELECT COUNT(*) = 2
  FROM information_schema.statistics
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_inbound_grant'
   AND index_name = 'uk_inbound_grant'
   AND (
        (seq_in_index = 1 AND column_name = 'access_key')
     OR (seq_in_index = 2 AND column_name = 'entity_code'));

SELECT COUNT(*) = 4
  FROM information_schema.statistics
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_inbound_request'
   AND index_name = 'uk_inbound_idem'
   AND column_name IN ('tenant_id', 'access_key', 'entity_code', 'idempotency_key');

SELECT COUNT(*) = 5
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'mdp_entity'
   AND column_name IN (
     'inbound_enabled', 'inbound_max_rows', 'stale_guard_enabled',
     'silence_alert_hours', 'silence_calendar');