Updated sql scripts with correct foreign id for the rooms.