added missing columns for door record
added missing columns for Light record
added missing column for misc record