-- 把设备归到设备主人自己的家庭（修正 V11 初始迁移把设备归到预置家庭的错位）
UPDATE device d
JOIN home h ON h.owner_id = d.owner_id AND h.deleted = 0
SET d.home_id = h.id
WHERE d.owner_id > 0;

-- 验证
SELECT d.device_id, d.owner_id, d.home_id, h.owner_id AS home_owner FROM device d LEFT JOIN home h ON h.id = d.home_id LIMIT 15;