AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.537.sql

-- ============================================================================
-- 1.0.537 · API_INBOUND WP-B：入站实体标注 op=delete 未开放；校正 biz_key_expr（号段避让远端已占用的 1.0.528）
--
-- 现网 S1/S3 转换 SQL 不读 raw_data.is_deleted（任务书 §10 陷阱 11）。
-- 未写 inbound_delete=supported 的实体，接收管线拒绝 op=delete。
-- AutoVersionUpdate 按 ; 拆句、无事务。
-- ============================================================================

UPDATE mdp_entity
   SET remark = TRIM(CONCAT(IFNULL(remark, ''), ' inbound_delete=unsupported')),
       update_time = NOW()
 WHERE entity_code IN ('S1_SALES_ORDER_ENTRY', 'MDM_ITEM')
   AND IFNULL(remark, '') NOT LIKE '%inbound_delete=%';

UPDATE mdp_entity
   SET biz_key_expr = 'bill_no,entry_seq',
       update_time = NOW()
 WHERE entity_code = 'S1_SALES_ORDER_ENTRY'
   AND (biz_key_expr IS NULL OR biz_key_expr LIKE 'CONCAT%' OR TRIM(biz_key_expr) = '');

UPDATE mdp_entity
   SET biz_key_expr = 'Domain,ItemNum',
       update_time = NOW()
 WHERE entity_code = 'MDM_ITEM'
   AND (biz_key_expr IS NULL OR biz_key_expr LIKE 'CONCAT%' OR TRIM(biz_key_expr) = '');