-- V11: 设备关联家庭/房间（家庭切换后按家庭过滤设备）
ALTER TABLE device ADD COLUMN home_id BIGINT NULL COMMENT '所属家庭ID(home.id)';
ALTER TABLE device ADD COLUMN room_id BIGINT NULL COMMENT '所属房间ID(room.id)';

-- 存量设备归入最早的默认家庭
UPDATE device
SET home_id = (SELECT id FROM home ORDER BY id ASC LIMIT 1)
WHERE home_id IS NULL;

-- 修正归属：设备应归到"设备主人自己的家庭"，而不是系统预置家庭
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;