ALTER TABLE device ADD COLUMN home_id BIGINT NULL COMMENT 'home.id';
ALTER TABLE device ADD COLUMN room_id BIGINT NULL COMMENT 'room.id';
UPDATE device SET home_id = (SELECT id FROM home ORDER BY id ASC LIMIT 1) WHERE home_id IS NULL;