-- fix the draft_teams that have incomplete team names

UPDATE players SET draft_team = 'Pittsburgh Steelers' WHERE draft_team = 'Pittsburgh';
UPDATE players SET draft_team = 'Miami Dolphins'      WHERE draft_team = 'Miami';
UPDATE players SET draft_team = 'Washington Redskins' WHERE draft_team = 'Washington';
UPDATE players SET draft_team = 'Green Bay Packers'   WHERE draft_team = 'Green Bay';
UPDATE players SET draft_team = 'Tampa Bay Buccaneers' WHERE draft_team = 'Tampa Bay';
UPDATE players SET draft_team = 'San Diego Chargers'  WHERE draft_team = 'San Diego';
UPDATE players SET draft_team = 'Houston Texans'      WHERE draft_team = 'Houston';
UPDATE players SET draft_team = 'Atlanta Falcons' WHERE draft_team = 'Atlanta';
UPDATE players SET draft_team = 'Carolina Panthers' WHERE draft_team = 'Carolina';
UPDATE players SET draft_team = 'Denver Broncos' WHERE draft_team = 'Denver';
UPDATE players SET draft_team = 'St. Louis Rams' WHERE draft_team = 'St. Louis';
UPDATE players SET draft_team = 'Kansas City Chiefs' WHERE draft_team = 'Kansas City';
UPDATE players SET draft_team = 'Seattle Seahawks' WHERE draft_team = 'Seattle';
UPDATE players SET draft_team = 'Oakland Raiders' WHERE draft_team = 'Oakland';
UPDATE players SET draft_team = 'New Orleans Saints' WHERE draft_team = 'New Orleans';
UPDATE players SET draft_team = 'Arizona Cardinals' WHERE draft_team = 'Arizona';
UPDATE players SET draft_team = 'Buffalo Bills' WHERE draft_team = 'Buffalo';
UPDATE players SET draft_team = 'Philadelphia Eagles' WHERE draft_team = 'Philadelphia';
UPDATE players SET draft_team = 'Detroit Lions' WHERE draft_team = 'Detroit';
UPDATE players SET draft_team = 'Baltimore Ravens' WHERE draft_team = 'Baltimore';
UPDATE players SET draft_team = 'Indianapolis Colts' WHERE draft_team = 'Indianapolis';
UPDATE players SET draft_team = 'New England Patriots' WHERE draft_team = 'New England';
UPDATE players SET draft_team = 'Dallas Cowboys' WHERE draft_team = 'Dallas';
UPDATE players SET draft_team = 'San Francisco 49ers' WHERE draft_team = 'San Francisco';
UPDATE players SET draft_team = 'Cleveland Browns' WHERE draft_team = 'Cleveland';
UPDATE players SET draft_team = 'Minnesota Vikings' WHERE draft_team = 'Minnesota';
UPDATE players SET draft_team = 'Chicago Bears' WHERE draft_team = 'Chicago';
UPDATE players SET draft_team = 'Jacksonville Jaguars' WHERE draft_team = 'Jacksonville';
UPDATE players SET draft_team = 'Cincinnati Bengals' WHERE draft_team = 'Cincinnati';
UPDATE players SET draft_team = 'Tennessee Titans' WHERE draft_team = 'Tennessee';