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

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

SELECT COUNT(*) = 2
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'ItemMaster'
   AND column_name IN ('source_system', 'source_updated_at');

SELECT COUNT(*) = 2
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'CustMaster'
   AND column_name IN ('source_system', 'source_updated_at');

SELECT COUNT(*) = 2
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'SuppMaster'
   AND column_name IN ('source_system', 'source_updated_at');

SELECT COUNT(*) = 2
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'LocationMaster'
   AND column_name IN ('source_system', 'source_updated_at');

SELECT COUNT(*) = 2
  FROM information_schema.columns
 WHERE table_schema = DATABASE()
   AND table_name = 'EmployeeMaster'
   AND column_name IN ('source_system', 'source_updated_at');

SELECT COUNT(*) = 5
  FROM mdp_entity
 WHERE entity_code IN (
   'S5_INVENTORY_TXN', 'S5_INVENTORY_OPENING_BALANCE',
   'S7_FINISHED_ONHAND', 'S7_FINISHED_OPENING_BALANCE',
   'MDM_EMPLOYEE_HEADCOUNT')
   AND inbound_enabled = 1;