-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 12, 2006 at 07:50 PM
-- Server version: 5.0.16
-- PHP Version: 5.1.1
-- 
-- Database: `pdo_test`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `nfl_teams`
-- 

CREATE TABLE `nfl_teams` (
  `nfl_team` tinyint(4) NOT NULL default '0',
  `abbreviation` char(3) NOT NULL default '',
  `location` varchar(13) NOT NULL default '',
  `name` varchar(10) NOT NULL default '0',
  PRIMARY KEY  (`nfl_team`),
  UNIQUE KEY `NFL_team` (`nfl_team`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `nfl_teams`
-- 

INSERT INTO `nfl_teams` VALUES (-1, '---', '-', '-');
INSERT INTO `nfl_teams` VALUES (0, 'BUF', 'Buffalo', 'Bills');
INSERT INTO `nfl_teams` VALUES (1, 'IND', 'Indianapolis', 'Colts');
INSERT INTO `nfl_teams` VALUES (2, 'MIA', 'Miami', 'Dolphins');
INSERT INTO `nfl_teams` VALUES (3, 'NE', 'New England', 'Patriots');
INSERT INTO `nfl_teams` VALUES (4, 'NYJ', 'New York', 'Jets');
INSERT INTO `nfl_teams` VALUES (5, 'CIN', 'Cincinnati', 'Bengals');
INSERT INTO `nfl_teams` VALUES (6, 'CLE', 'Cleveland', 'Browns');
INSERT INTO `nfl_teams` VALUES (7, 'TEN', 'Tennessee', 'Titans');
INSERT INTO `nfl_teams` VALUES (8, 'JAX', 'Jacksonville', 'Jaguars');
INSERT INTO `nfl_teams` VALUES (9, 'PIT', 'Pittsburgh', 'Steelers');
INSERT INTO `nfl_teams` VALUES (10, 'DEN', 'Denver', 'Broncos');
INSERT INTO `nfl_teams` VALUES (11, 'KC', 'Kansas City', 'Chiefs');
INSERT INTO `nfl_teams` VALUES (12, 'OAK', 'Oakland', 'Raiders');
INSERT INTO `nfl_teams` VALUES (13, 'SD', 'San Diego', 'Chargers');
INSERT INTO `nfl_teams` VALUES (14, 'SEA', 'Seattle', 'Seahawks');
INSERT INTO `nfl_teams` VALUES (15, 'DAL', 'Dallas', 'Cowboys');
INSERT INTO `nfl_teams` VALUES (16, 'NYG', 'New York', 'Giants');
INSERT INTO `nfl_teams` VALUES (17, 'PHI', 'Philadelphia', 'Eagles');
INSERT INTO `nfl_teams` VALUES (18, 'ARI', 'Arizona', 'Cardinals');
INSERT INTO `nfl_teams` VALUES (19, 'WAS', 'Washington', 'Redskins');
INSERT INTO `nfl_teams` VALUES (20, 'CHI', 'Chicago', 'Bears');
INSERT INTO `nfl_teams` VALUES (21, 'DET', 'Detroit', 'Lions');
INSERT INTO `nfl_teams` VALUES (22, 'GB', 'Green Bay', 'Packers');
INSERT INTO `nfl_teams` VALUES (23, 'MIN', 'Minnesota', 'Vikings');
INSERT INTO `nfl_teams` VALUES (24, 'TB', 'Tampa Bay', 'Buccaneers');
INSERT INTO `nfl_teams` VALUES (25, 'ATL', 'Atlanta', 'Falcons');
INSERT INTO `nfl_teams` VALUES (26, 'CAR', 'Carolina', 'Panthers');
INSERT INTO `nfl_teams` VALUES (27, 'STL', 'St. Louis', 'Rams');
INSERT INTO `nfl_teams` VALUES (28, 'NO', 'New Orleans', 'Saints');
INSERT INTO `nfl_teams` VALUES (29, 'SF', 'San Francisco', '49ers');
INSERT INTO `nfl_teams` VALUES (30, 'BAL', 'Baltimore', 'Ravens');
INSERT INTO `nfl_teams` VALUES (31, 'HOU', 'Houston', 'Texans');
