changed sql queries in the managers to use their new column name instead of name.