-- phpMyAdmin SQL Dump -- version 3.3.10deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 21, 2011 at 10:16 PM SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `MLB` -- -- -------------------------------------------------------- -- -- Table structure for table `TEAM` -- DROP TABLE IF EXISTS `TEAM`; CREATE TABLE IF NOT EXISTS `TEAM` ( `TEAM_ID` int(10) unsigned NOT NULL, `NAME` varchar(25) COLLATE latin1_general_ci DEFAULT NULL, `NAME_ABBR` varchar(3) COLLATE latin1_general_ci DEFAULT NULL, `LEAGUE` enum('AL','NL') COLLATE latin1_general_ci DEFAULT NULL, `DIVISION` enum('East','West','Central') COLLATE latin1_general_ci DEFAULT NULL, `CITY` varchar(45) COLLATE latin1_general_ci DEFAULT NULL, `STATE` varchar(2) COLLATE latin1_general_ci DEFAULT NULL, `STADIUM_NAME` varchar(45) COLLATE latin1_general_ci DEFAULT NULL, `STADIUM_TYPE` enum('Outdoors','Indoors','Retractable') COLLATE latin1_general_ci DEFAULT NULL, `STADIUM_SURFACE` enum('Grass','Turf') COLLATE latin1_general_ci DEFAULT NULL COMMENT 'What is the field covered with? (Turf, Grass, AstroTurf, etc)', `STADIUM_CAPACITY` int(10) unsigned DEFAULT NULL, `STADIUM_LENGHT_LF` tinyint(3) unsigned DEFAULT NULL, `STADIUM_LENGHT_CF` tinyint(3) unsigned DEFAULT NULL, `STADIUM_LENGHT_RF` tinyint(3) unsigned DEFAULT NULL, PRIMARY KEY (`TEAM_ID`), UNIQUE KEY `TeamID` (`TEAM_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='Data For All Teams In The MLB'; -- -- Dumping data for table `TEAM` -- INSERT INTO `TEAM` (`TEAM_ID`, `NAME`, `NAME_ABBR`, `LEAGUE`, `DIVISION`, `CITY`, `STATE`, `STADIUM_NAME`, `STADIUM_TYPE`, `STADIUM_SURFACE`, `STADIUM_CAPACITY`, `STADIUM_LENGHT_LF`, `STADIUM_LENGHT_CF`, `STADIUM_LENGHT_RF`) VALUES (108, 'Los Angeles Angels', 'ANA', 'AL', 'West', 'Los Angeles', 'CA', 'Angel Stadium of Anaheim', 'Outdoors', 'Grass', 45050, NULL, NULL, NULL), (109, 'Arizona Diamondbacks', 'ARI', 'NL', 'West', 'Phoenix', 'AZ', 'Chase Field', 'Retractable', 'Grass', 49033, NULL, NULL, NULL), (110, 'Baltimore Orioles', 'BAL', 'AL', 'East', 'Baltimore', 'MD', 'Oriole Park at Camden Yards', 'Outdoors', 'Grass', 48876, NULL, NULL, NULL), (111, 'Boston Red Sox', 'BOS', 'AL', 'East', 'Boston', 'MA', 'Fenway Park', 'Outdoors', 'Grass', 37654, NULL, NULL, NULL), (112, 'Chicago Cubs', 'CHN', 'NL', 'Central', 'Chicago', 'IL', 'Wrigley Field', 'Outdoors', 'Grass', 41160, NULL, NULL, NULL), (113, 'Cincinnati Reds', 'CIN', 'NL', 'Central', 'Cincinatti', 'OH', 'Great American Ball Park', 'Outdoors', 'Grass', 42059, NULL, NULL, NULL), (114, 'Cleveland Indians', 'CLE', 'AL', 'Central', 'Cleveland', 'OH', 'Progressive Field', 'Outdoors', 'Grass', 43515, NULL, NULL, NULL), (115, 'Colorado Rockies', 'COL', 'NL', 'West', 'Denver', 'CO', 'Coors Field', 'Outdoors', 'Grass', 50445, NULL, NULL, NULL), (116, 'Detroit Tigers', 'DET', 'AL', 'Central', 'Detroit', 'MI', 'Comerica Park', 'Outdoors', 'Grass', 41782, NULL, NULL, NULL), (117, 'Houston Astros', 'HOU', 'NL', 'Central', 'Houston', 'TX', 'Minute Maid Park', 'Retractable', 'Grass', 40950, NULL, NULL, NULL), (118, 'Kansas City Royals', 'KCA', 'AL', 'Central', 'Kansas City', 'MO', 'Kauffman Stadium', 'Outdoors', 'Grass', 39000, NULL, NULL, NULL), (119, 'Los Angeles Dodgers', 'LAN', 'NL', 'West', 'Los Angeles', 'CA', 'Dodger Stadium', 'Outdoors', 'Grass', 56000, NULL, NULL, NULL), (120, 'Washington Nationals', 'WAS', 'NL', 'East', 'Washington D.C', 'DC', 'Nationals Park', 'Outdoors', 'Grass', 41888, NULL, NULL, NULL), (121, 'New York Mets', 'NYN', 'NL', 'East', 'New York City', 'NY', 'Citi Field', 'Outdoors', 'Grass', 41800, NULL, NULL, NULL), (133, 'Oakland Athletics', 'OAK', 'AL', 'West', 'Oakland', 'CA', 'Oakland-Alameda County Coliseum', 'Outdoors', 'Grass', 35067, NULL, NULL, NULL), (134, 'Pittsburgh Pirates', 'PIT', 'NL', 'Central', 'Pittsburgh', 'PA', 'PNC Park', 'Outdoors', 'Grass', 38496, NULL, NULL, NULL), (135, 'San Diego Padres', 'SDN', 'NL', 'West', 'San Diego', 'CA', 'PetCo Park', 'Outdoors', 'Grass', 42445, NULL, NULL, NULL), (136, 'Seattle Mariners', 'SEA', 'AL', 'West', 'Seattle', 'WA', 'Safeco Field', 'Retractable', 'Grass', 47116, NULL, NULL, NULL), (137, 'San Francisco Giants', 'SFN', 'NL', 'West', 'San Francisco', 'CA', 'AT&T Park', 'Outdoors', 'Grass', 41503, NULL, NULL, NULL), (138, 'St. Louis Cardinals', 'SLN', 'NL', 'Central', 'St. Louis', 'MO', 'Busch Stadium', 'Outdoors', 'Grass', 46861, NULL, NULL, NULL), (139, 'Tampa Bay Rays', 'TBA', 'AL', 'East', 'St. Petersburg', 'FL', 'Tropicana Field', 'Indoors', 'Turf', 36973, NULL, NULL, NULL), (140, 'Texas Rangers', 'TEX', 'AL', 'West', 'Arlington', 'TX', 'Rangers Ballpark in Arlington', 'Outdoors', 'Grass', 49200, NULL, NULL, NULL), (141, 'Toronto Blue Jay', 'TOR', 'AL', 'East', 'Toronto', 'ON', 'Rogers Centre', 'Retractable', 'Turf', 49539, NULL, NULL, NULL), (142, 'Minnesota Twins', 'MIN', 'AL', 'Central', 'Minneapolis', 'MN', 'Target Field', 'Outdoors', 'Grass', 40000, NULL, NULL, NULL), (143, 'Philadelphia Phillies', 'PHI', 'NL', 'East', ' Phillies', 'PA', 'Citizens Bank Park', 'Outdoors', 'Grass', 43647, NULL, NULL, NULL), (144, 'Atlanta Braves', 'ATL', 'NL', 'East', 'Atlanta', 'GA', 'Turner Field', 'Outdoors', 'Grass', 50096, NULL, NULL, NULL), (145, 'Chicago White Sox', 'CHA', 'AL', 'Central', 'Chicago', 'IL', 'U.S. Cellular Field', 'Outdoors', 'Grass', 40615, NULL, NULL, NULL), (146, 'Florida Marlins', 'FLO', 'NL', 'East', 'Miami', 'FL', 'Sun Life Stadium ', 'Outdoors', 'Grass', 38560, NULL, NULL, NULL), (147, 'New York Yankees', 'NYA', 'AL', 'East', 'New York City', 'NY', 'Yankee Stadium', 'Outdoors', 'Grass', 52325, NULL, NULL, NULL), (158, 'Milwaukee Brewers', 'MIL', 'NL', 'Central', 'Milwaukee', 'WI', 'Miller Park', 'Retractable', 'Grass', 41900, NULL, NULL, NULL);