-- 仅本机验收票：依据实际已确认预占/占用恢复缺失的块表示，不生成业务完成事实。
-- 旧预占、占用原始记录保留，恢复前快照见 warehouse-block-resource-before.tsv。
START TRANSACTION;
INSERT INTO wh_location_block
 (id,tenant_id,warehouse_id,source_service,business_id,inbound_code,slot_count,
  idempotency_key,block_status,expires_at,last_operation_key,created_by,created_at,version)
SELECT r.business_id,0,r.warehouse_id,r.source_service,r.business_id,r.inbound_code,1,
 CONCAT('LOCAL-TAIL-20261020-RECOVER-',r.id),'OCCUPIED',r.expires_at,
 'LOCAL-TAIL-20261020-RECOVER-CONFIRMED',r.created_by,r.created_at,0
FROM wh_location_reservation r
JOIN wh_location_occupancy o ON o.reservation_id=r.id AND o.business_id=r.business_id
WHERE r.id=2092814900999888899 AND r.business_id=2092814880129130499
 AND r.tenant_id=0 AND o.tenant_id=0 AND r.reservation_status='CONFIRMED'
 AND o.occupancy_status='OCCUPIED' AND o.allocated_package_count=4
 AND NOT EXISTS (SELECT 1 FROM wh_location_block b WHERE b.id=r.business_id);
INSERT INTO wh_location_block_slot
 (id,tenant_id,block_id,slot_no,location_id,location_code,shared_overflow,resource_status,created_at,version)
SELECT r.id,0,b.id,1,r.location_id,r.location_code,r.shared_overflow,'OCCUPIED',r.created_at,0
FROM wh_location_reservation r JOIN wh_location_block b ON b.id=r.business_id
WHERE r.id=2092814900999888899 AND b.id=2092814880129130499
 AND b.idempotency_key=CONCAT('LOCAL-TAIL-20261020-RECOVER-',r.id)
 AND NOT EXISTS (SELECT 1 FROM wh_location_block_slot s WHERE s.id=r.id);
COMMIT;