/* Set up teams */

INSERT INTO teams
  ( abrv_name, team_name, conference, division )

VALUES
  ( 'ARI', 'Arizona Cardinals',     'NFC', 'West'  ),
  ( 'ATL', 'Atlanta Falcons',       'NFC', 'South' ),
  ( 'BAL', 'Baltimore Ravens',      'AFC', 'North' ),
  ( 'BUF', 'Buffalo Bills',         'AFC', 'East'  ),
  ( 'CAR', 'Carolina Panthers',     'NFC', 'South' ),
  ( 'CHI', 'Chicago Bears',         'NFC', 'North' ),
  ( 'CIN', 'Cincinnati Bengals',    'AFC', 'North' ),
  ( 'CLE', 'Cleveland Browns',      'AFC', 'North' ),
  ( 'DAL', 'Dallas Cowboys',        'NFC', 'East'  ),
  ( 'DEN', 'Denver Broncos',        'AFC', 'West'  ),
  ( 'DET', 'Detroit Lions',         'NFC', 'North' ),
  ( 'GB ', 'Green Bay Packers',     'NFC', 'North' ),
  ( 'HOU', 'Houston Texans',        'AFC', 'South' ),
  ( 'IND', 'Indianapolis Colts',    'AFC', 'South' ),
  ( 'JAC', 'Jacksonville Jaguars',  'AFC', 'South' ),
  ( 'KC ', 'Kansas City Chiefs',    'AFC', 'West'  ),
  ( 'MIA', 'Miami Dolphins',        'AFC', 'East'  ),
  ( 'MIN', 'Minnesota Vikings',     'NFC', 'North' ),
  ( 'NE ', 'New England Patriots',  'AFC', 'East'  ),
  ( 'NO ', 'New Orleans Saints',    'NFC', 'South' ),
  ( 'NYG', 'New York Giants',       'NFC', 'East'  ),
  ( 'NYJ', 'New York Jets',         'AFC', 'East'  ),
  ( 'OAK', 'Oakland Raiders',       'AFC', 'West'  ),
  ( 'PHI', 'Philadelphia Eagles',   'NFC', 'East'  ),
  ( 'PIT', 'Pittsburgh Steelers',   'AFC', 'North' ),
  ( 'SD ', 'San Diego Chargers',    'AFC', 'West'  ),
  ( 'SF ', 'San Francisco 49ers',   'NFC', 'West'  ),
  ( 'SEA', 'Seattle Seahawks',      'NFC', 'West'  ),
  ( 'STL', 'St. Louis Rams',        'NFC', 'West'  ),
  ( 'TB ', 'Tampa Bay Buccaneers',  'NFC', 'South' ),
  ( 'TEN', 'Tennessee Titans',      'AFC', 'South' ),
  ( 'WAS', 'Washington Redskins',   'NFC', 'East'  )
;


UPDATE teams SET
  helmet_image_url     = 'teams/ARI_helmet.gif',
  background_image_url = 'teams/ARI_background.jpg'
WHERE abrv_name='ARI';

UPDATE teams SET
  helmet_image_url     = 'teams/ATL_helmet.gif',
  background_image_url = 'teams/ATL_background.jpg'
WHERE abrv_name='ATL';

UPDATE teams SET
  helmet_image_url     = 'teams/CAR_helmet.gif',
  background_image_url = 'teams/CAR_background.jpg'
WHERE abrv_name='CAR';

UPDATE teams SET
  helmet_image_url     = 'teams/CHI_helmet.gif',
  background_image_url = 'teams/CHI_background.jpg'
WHERE abrv_name='CHI';

UPDATE teams SET
  helmet_image_url     = 'teams/DAL_helmet.gif',
  background_image_url = 'teams/DAL_background.jpg'
WHERE abrv_name='DAL';

UPDATE teams SET
  helmet_image_url     = 'teams/DET_helmet.gif',
  background_image_url = 'teams/DET_background.jpg'
WHERE abrv_name='DET';

UPDATE teams SET
  helmet_image_url     = 'teams/GB_helmet.gif',
  background_image_url = 'teams/GB_background.jpg'
WHERE abrv_name='GB';

UPDATE teams SET
  helmet_image_url     = 'teams/MIN_helmet.gif',
  background_image_url = 'teams/MIN_background.jpg'
WHERE abrv_name='MIN';

UPDATE teams SET
  helmet_image_url     = 'teams/NO_helmet.gif',
  background_image_url = 'teams/NO_background.jpg'
WHERE abrv_name='NO';

UPDATE teams SET
  helmet_image_url     = 'teams/NYG_helmet.gif',
  background_image_url = 'teams/NYG_background.jpg'
WHERE abrv_name='NYG';

UPDATE teams SET
  helmet_image_url     = 'teams/PHI_helmet.gif',
  background_image_url = 'teams/PHI_background.jpg'
WHERE abrv_name='PHI';

UPDATE teams SET
  helmet_image_url     = 'teams/SF_helmet.gif',
  background_image_url = 'teams/SF_background.jpg'
WHERE abrv_name='SF';

UPDATE teams SET
  helmet_image_url     = 'teams/SEA_helmet.gif',
  background_image_url = 'teams/SEA_background.jpg'
WHERE abrv_name='SEA';

UPDATE teams SET
  helmet_image_url     = 'teams/STL_helmet.gif',
  background_image_url = 'teams/STL_background.jpg'
WHERE abrv_name='STL';

UPDATE teams SET
  helmet_image_url     = 'teams/TB_helmet.gif',
  background_image_url = 'teams/TB_background.jpg'
WHERE abrv_name='TB';

UPDATE teams SET
  helmet_image_url     = 'teams/WAS_helmet.gif',
  background_image_url = 'teams/WAS_background.jpg'
WHERE abrv_name='WAS';

UPDATE teams SET
  helmet_image_url     = 'teams/BAL_helmet.gif',
  background_image_url = 'teams/BAL_background.jpg'
WHERE abrv_name='BAL';

UPDATE teams SET
  helmet_image_url     = 'teams/BUF_helmet.gif',
  background_image_url = 'teams/BUF_background.jpg'
WHERE abrv_name='BUF';

UPDATE teams SET
  helmet_image_url     = 'teams/CIN_helmet.gif',
  background_image_url = 'teams/CIN_background.jpg'
WHERE abrv_name='CIN';

UPDATE teams SET
  helmet_image_url     = 'teams/CLE_helmet.gif',
  background_image_url = 'teams/CLE_background.jpg'
WHERE abrv_name='CLE';

UPDATE teams SET
  helmet_image_url     = 'teams/DEN_helmet.gif',
  background_image_url = 'teams/DEN_background.jpg'
WHERE abrv_name='DEN';

UPDATE teams SET
  helmet_image_url     = 'teams/HOU_helmet.gif',
  background_image_url = 'teams/HOU_background.jpg'
WHERE abrv_name='HOU';

UPDATE teams SET
  helmet_image_url     = 'teams/IND_helmet.gif',
  background_image_url = 'teams/IND_background.jpg'
WHERE abrv_name='IND';

UPDATE teams SET
  helmet_image_url     = 'teams/JAC_helmet.gif',
  background_image_url = 'teams/JAC_background.jpg'
WHERE abrv_name='JAC';

UPDATE teams SET
  helmet_image_url     = 'teams/KC_helmet.gif',
  background_image_url = 'teams/KC_background.jpg'
WHERE abrv_name='KC';

UPDATE teams SET
  helmet_image_url     = 'teams/MIA_helmet.gif',
  background_image_url = 'teams/MIA_background.jpg'
WHERE abrv_name='MIA';

UPDATE teams SET
  helmet_image_url     = 'teams/NE_helmet.gif',
  background_image_url = 'teams/NE_background.jpg'
WHERE abrv_name='NE';

UPDATE teams SET
  helmet_image_url     = 'teams/NYJ_helmet.gif',
  background_image_url = 'teams/NYJ_background.jpg'
WHERE abrv_name='NYJ';

UPDATE teams SET
  helmet_image_url     = 'teams/OAK_helmet.gif',
  background_image_url = 'teams/OAK_background.jpg'
WHERE abrv_name='OAK';

UPDATE teams SET
  helmet_image_url     = 'teams/PIT_helmet.gif',
  background_image_url = 'teams/PIT_background.jpg'
WHERE abrv_name='PIT';

UPDATE teams SET
  helmet_image_url     = 'teams/SD_helmet.gif',
  background_image_url = 'teams/SD_background.jpg'
WHERE abrv_name='SD';

UPDATE teams SET
  helmet_image_url     = 'teams/TEN_helmet.gif',
  background_image_url = 'teams/TEN_background.jpg'
WHERE abrv_name='TEN';