6CTBaZsH

1--
2-- Table structure for table `teams`
3--
4
5CREATE TABLE IF NOT EXISTS `teams` (
6  `id` tinyint(1) unsigned NOT NULL,
7  `name` varchar(32) NOT NULL,
8  `abbreviation` char(3) NOT NULL,
9  `conference` char(3) NOT NULL,
10  `division` char(5) NOT NULL
11) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
12
13--
14-- Dumping data for table `teams`
15--
16
17INSERT INTO `teams` (`id`, `name`, `abbreviation`, `conference`, `division`) VALUES
18(1, 'Arizona Cardinals', 'ARI', 'NFC', 'West'),
19(2, 'Atlanta Falcons', 'ATL', 'NFC', 'South'),
20(3, 'Baltimore Ravens', 'BAL', 'AFC', 'North'),
21(4, 'Buffalo Bills', 'BUF', 'AFC', 'East'),
22(5, 'Carolina Panthers', 'CAR', 'NFC', 'South'),
23(6, 'Chicago Bears', 'CHI', 'NFC', 'North'),
24(7, 'Cincinnati Bengals', 'CIN', 'AFC', 'North'),
25(8, 'Cleveland Browns', 'CLE', 'AFC', 'North'),
26(9, 'Dallas Cowboys', 'DAL', 'NFC', 'East'),
27(10, 'Denver Broncos', 'DEN', 'AFC', 'West'),
28(11, 'Detroit Lions', 'DET', 'NFC', 'North'),
29(12, 'Green Bay Packers', 'GB', 'NFC', 'North'),
30(13, 'Houston Texans', 'HOU', 'AFC', 'South'),
31(14, 'Indianapolis Colts', 'IND', 'AFC', 'South'),
32(15, 'Jacksonville Jaguars', 'JAX', 'AFC', 'South'),
33(16, 'Kansas City Chiefs', 'KC', 'AFC', 'West'),
34(17, 'Miami Dolphins', 'MIA', 'AFC', 'East'),
35(18, 'Minnesota Vikings', 'MIN', 'NFC', 'North'),
36(19, 'New England Patriots', 'NE', 'AFC', 'East'),
37(20, 'New Orleans Saints', 'NO', 'NFC', 'South'),
38(21, 'NY Giants', 'NYG', 'NFC', 'East'),
39(22, 'NY Jets', 'NYJ', 'AFC', 'East'),
40(23, 'Oakland Raiders', 'OAK', 'AFC', 'West'),
41(24, 'Philadelphia Eagles', 'PHI', 'NFC', 'East'),
42(25, 'Pittsburgh Steelers', 'PIT', 'AFC', 'North'),
43(26, 'San Diego Chargers', 'SD', 'AFC', 'West'),
44(27, 'San Francisco 49ers', 'SF', 'NFC', 'West'),
45(28, 'Seattle Seahawks', 'SEA', 'NFC', 'West'),
46(29, 'St. Louis Rams', 'STL', 'NFC', 'West'),
47(30, 'Tampa Bay Buccaneers', 'TB', 'NFC', 'South'),
48(31, 'Tennessee Titans', 'TEN', 'AFC', 'South'),
49(32, 'Washington Redskins', 'WAS', 'NFC', 'East');
50
51--
52-- Indexes for dumped tables
53--
54
55--
56-- Indexes for table `teams`
57--
58ALTER TABLE `teams`
59  ADD PRIMARY KEY (`id`);