-- MySQL dump 10.11
--
-- Host: localhost    Database: baseball
-- ------------------------------------------------------
-- Server version	5.0.38-Ubuntu_0ubuntu1.4-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `gameday_action`
--

DROP TABLE IF EXISTS `gameday_action`;
CREATE TABLE `gameday_action` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `pitch` varchar(4) default NULL,
  `b` smallint(1) default NULL,
  `des` varchar(255) default NULL,
  `event` varchar(200) default NULL,
  `o` varchar(200) default NULL,
  `player` varchar(150) default NULL,
  `s` varchar(25) default NULL,
  `score` varchar(6) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_atbat`
--

DROP TABLE IF EXISTS `gameday_atbat`;
CREATE TABLE `gameday_atbat` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `num` int(11) default NULL,
  `b` int(11) default NULL,
  `batter` varchar(6) default NULL,
  `des` text,
  `event` text,
  `o` varchar(177) default NULL,
  `pitcher` varchar(91) default NULL,
  `s` varchar(15) default NULL,
  `score` varchar(6) default NULL,
  `stand` varchar(6) default NULL,
  KEY `atbat_gameid_idx` (`gameid`),
  KEY `atbat_num_idx` (`num`),
  KEY `atbat_gameid_num_idx` (`gameid`,`num`),
  KEY `atbat_gameid_idx_gameday_atbat` (`gameid`),
  KEY `atbat_num_idx_gameday_atbat` (`num`),
  KEY `atbat_pitcher_idx_gameday_atba` (`pitcher`),
  KEY `atbat_batter_idx_gameday_atbat` (`batter`),
  KEY `gameid_gameday_atbat` (`gameid`,`inning`,`half`,`num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_batting`
--

DROP TABLE IF EXISTS `gameday_batting`;
CREATE TABLE `gameday_batting` (
  `eliasid` int(11) default NULL,
  `teamid` int(11) default NULL,
  `gameid` varchar(32) default NULL,
  `pos` varchar(64) default NULL,
  `h` int(11) default NULL,
  `hr` int(11) default NULL,
  `bb` int(11) default NULL,
  `so` int(11) default NULL,
  `rbi` int(11) default NULL,
  `ab` int(11) default NULL,
  `runs` int(11) default NULL,
  `t` int(11) default NULL,
  `d` int(11) default NULL,
  `lob` int(11) default NULL,
  `sb` int(11) default NULL,
  `cs` int(11) default NULL,
  `bo` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_coaches`
--

DROP TABLE IF EXISTS `gameday_coaches`;
CREATE TABLE `gameday_coaches` (
  `gameid` varchar(30) default NULL,
  `team` char(3) default NULL,
  `coachid` int(11) default NULL,
  `first` varchar(200) default NULL,
  `last` varchar(200) default NULL,
  `num` int(11) default NULL,
  `position` varchar(200) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_fielding`
--

DROP TABLE IF EXISTS `gameday_fielding`;
CREATE TABLE `gameday_fielding` (
  `eliasid` int(11) default NULL,
  `teamid` int(11) default NULL,
  `gameid` varchar(32) default NULL,
  `pos` varchar(64) default NULL,
  `po` int(11) default NULL,
  `a` int(11) default NULL,
  `e` int(11) default NULL,
  `pb` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_game_info`
--

DROP TABLE IF EXISTS `gameday_game_info`;
CREATE TABLE `gameday_game_info` (
  `gameid` varchar(32) default NULL,
  `game_type` varchar(3) default NULL,
  `type` varchar(3) default NULL,
  `local_game_time` time default NULL,
  `gameday_sw` varchar(6) default NULL,
  `home_team` varchar(6) default NULL,
  `home_id` varchar(4) default NULL,
  `home_name` varchar(23) default NULL,
  `home_w` int(11) default NULL,
  `home_l` int(11) default NULL,
  `home_lg` varchar(5) default NULL,
  `away_team` varchar(6) default NULL,
  `away_id` varchar(4) default NULL,
  `away_name` varchar(23) default NULL,
  `away_w` int(11) default NULL,
  `away_l` int(11) default NULL,
  `away_lg` varchar(5) default NULL,
  `home_runs` int(11) default NULL,
  `home_hits` int(11) default NULL,
  `home_errors` int(11) default NULL,
  `away_runs` int(11) default NULL,
  `away_hits` int(11) default NULL,
  `away_errors` int(11) default NULL,
  `stadium_id` int(11) default NULL,
  `stadium_name` varchar(49) default NULL,
  `stadium_loc` varchar(25) default NULL,
  KEY `gameday_game_info_gameid_idx` (`gameid`),
  KEY `gameday_game_info_gameid_idx_g` (`gameid`),
  KEY `gameday_game_info_stadium_id_idx_gameday_game_i` (`stadium_id`),
  KEY `gameday_game_info_game_type_idx_gameday_game_in` (`game_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `gameday_hit_locations`;
CREATE TABLE `gameday_hit_locations` (
  `game_id` varchar(30) default NULL,
  `x` float default NULL,
  `y` float default NULL,
  `inning` int(11) default NULL,
  `batter` int(11) default NULL,
  `pitcher` int(11) default NULL,
  `type` char(1) default NULL,
  `des` varchar(25) default NULL,
  `team` char(1) default NULL,
  KEY `gameday_hit_locations_game_id_idx_gameday_hit_locat` (`game_id`),
  KEY `gameday_hit_locations_pitcher_idx_gameday_hit_locat` (`pitcher`),
  KEY `gameday_hit_locations_batter_idx_gameday_hit_locati` (`batter`),
  KEY `gameday_hit_locations_type_idx_gameday_hit_location` (`type`),
  KEY `gameday_hit_locations_des_idx_` (`des`),
  KEY `gameday_hit_locations_team_idx_gameday_hit_location` (`team`),
  KEY `gameday_hit_locations_inning_idx_gameday_hit_locati` (`inning`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_hitting_totals`
--

DROP TABLE IF EXISTS `gameday_hitting_totals`;
CREATE TABLE `gameday_hitting_totals` (
  `playerid` int(11) default NULL,
  `year` varchar(4) default NULL,
  `type` varchar(3) default NULL,
  `game_type` varchar(3) default NULL,
  `stadium_id` int(11) default NULL,
  `teamid` int(11) default NULL,
  `pos` varchar(64) default NULL,
  `bo` int(11) default NULL,
  `games` bigint(21) NOT NULL default '0',
  `ab` decimal(32,0) default NULL,
  `h` decimal(32,0) default NULL,
  `d` decimal(32,0) default NULL,
  `t` decimal(32,0) default NULL,
  `hr` decimal(32,0) default NULL,
  `rbi` decimal(32,0) default NULL,
  `runs` decimal(32,0) default NULL,
  `bb` decimal(32,0) default NULL,
  `so` decimal(32,0) default NULL,
  `lob` decimal(32,0) default NULL,
  `sb` decimal(32,0) default NULL,
  `cs` decimal(32,0) default NULL,
  KEY `gameday_hitting_totals_playerid_idx` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_linescore`
--

DROP TABLE IF EXISTS `gameday_linescore`;
CREATE TABLE `gameday_linescore` (
  `gameid` varchar(32) default NULL,
  `inning` int(11) default NULL,
  `home_runs` int(11) default NULL,
  `away_runs` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_pitch`
--

DROP TABLE IF EXISTS `gameday_pitch`;
CREATE TABLE `gameday_pitch` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `atbat_num` int(11) default NULL,
  `atbat_pitch_num` int(11) default NULL,
  `id` int(11) default NULL,
  `ax` float default NULL,
  `ay` float default NULL,
  `az` float default NULL,
  `break_angle` float default NULL,
  `break_length` float default NULL,
  `break_x` float default NULL,
  `break_y` float default NULL,
  `break_z` float default NULL,
  `des` varchar(30) default NULL,
  `end_speed` float default NULL,
  `on_1b` int(11) default NULL,
  `on_2b` int(11) default NULL,
  `on_3b` int(11) default NULL,
  `pfx_x` float default NULL,
  `pfx_z` float default NULL,
  `px` float default NULL,
  `pz` float default NULL,
  `start_speed` float default NULL,
  `sz_bot` float default NULL,
  `sz_top` float default NULL,
  `type` varchar(5) default NULL,
  `vx0` float default NULL,
  `vy0` float default NULL,
  `vz0` float default NULL,
  `x` float default NULL,
  `x0` float default NULL,
  `y` float default NULL,
  `y0` float default NULL,
  `z0` float default NULL,
  `pitch_type` varchar(8) default NULL,
  `pitch_type_conf` float default NULL,
  KEY `gameday_pitch_gameid_idx` (`gameid`),
  KEY `gameday_pitch_atbat_num_idx` (`atbat_num`),
  KEY `pitch_gameid_atbat_num` (`gameid`,`atbat_num`),
  KEY `pitch_atbat_num_idx_gameday_pi` (`atbat_num`),
  KEY `pitch_gameid_idx_gameday_pitch` (`gameid`),
  KEY `gameid_gameday_pitch` (`gameid`,`inning`,`half`,`atbat_num`,`atbat_pitch_num`,`id`),
  KEY `pitch_id_index_gameday_pitch` (`id`),
  KEY `gameday_pitch_gameid_idx_gamed` (`gameid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_pitching`
--

DROP TABLE IF EXISTS `gameday_pitching`;
CREATE TABLE `gameday_pitching` (
  `eliasid` int(11) default NULL,
  `teamid` int(11) default NULL,
  `gameid` varchar(32) default NULL,
  `pos` varchar(64) default NULL,
  `outs` int(11) default NULL,
  `bf` int(11) default NULL,
  `hr` int(11) default NULL,
  `bb` int(11) default NULL,
  `so` int(11) default NULL,
  `er` int(11) default NULL,
  `runs` int(11) default NULL,
  `hits` int(11) default NULL,
  `wins` int(11) default NULL,
  `losses` int(11) default NULL,
  `holds` int(11) default NULL,
  `hopps` int(11) default NULL,
  `saves` int(11) default NULL,
  `sopps` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_pitching_info`
--

DROP TABLE IF EXISTS `gameday_pitching_info`;
CREATE TABLE `gameday_pitching_info` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `num` int(11) default NULL,
  `atbat_pitch_num` int(11) default NULL,
  `pitcher` varchar(91) default NULL,
  `batter` varchar(6) default NULL,
  `start_speed` float default NULL,
  `end_speed` float default NULL,
  `sz_top` float default NULL,
  `sz_bot` float default NULL,
  `px` float default NULL,
  `pz` float default NULL,
  `comp_call` char(1) default NULL,
  `comp_call_2` char(1) default NULL,
  `type` varchar(5) default NULL,
  `des` varchar(30) default NULL,
  `event` text,
  `pfx_x` float default NULL,
  `pfx_z` float default NULL,
  `stand` varchar(6) default NULL,
  `pitcher_hand` varchar(3) default NULL,
  `break_angle` float default NULL,
  `break_length` float default NULL,
  `break_x` double default NULL,
  `break_z` double default NULL,
  `time` double(12,3) default NULL,
  `px0` double(12,3) default NULL,
  `pz0` double(12,3) default NULL,
  `comp_call_3` char(1) default NULL,
  `comp_call_4` char(1) default NULL,
  KEY `gameday_pitching_info_gameid_idx_gameday_pitching_i` (`gameid`),
  KEY `gameday_pitching_info_picher_idx_gameday_pitching_i` (`pitcher`),
  KEY `gameday_pitching_info_batter_idx_gameday_pitching_i` (`batter`),
  KEY `gameday_pitching_info_stand_idx_gameday_pitching_in` (`stand`),
  KEY `gameday_pitching_info_pitcher_hand_idx_gameday_pitc` (`pitcher_hand`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_player_name`
--

DROP TABLE IF EXISTS `gameday_player_name`;
CREATE TABLE `gameday_player_name` (
  `playerid` int(11) default NULL,
  `first` varchar(200) default NULL,
  `last` varchar(200) default NULL,
  KEY `gameday_player_name_playerid_idx` (`playerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_players`
--

DROP TABLE IF EXISTS `gameday_players`;
CREATE TABLE `gameday_players` (
  `gameid` varchar(32) default NULL,
  `teamid` char(3) default NULL,
  `playerid` int(11) default NULL,
  `pos` varchar(3) default NULL,
  `first` varchar(200) default NULL,
  `last` varchar(200) default NULL,
  `num` int(11) default NULL,
  `height` varchar(10) default NULL,
  `weight` int(11) default NULL,
  `b` varchar(3) default NULL,
  `t` varchar(3) default NULL,
  `dob` date default NULL,
  KEY `players_gameid_idx` (`gameid`),
  KEY `players_playerid_idx` (`playerid`),
  KEY `players_gameid_playerid_idx` (`gameid`,`playerid`),
  KEY `gameday_players_gameid_idx_gam` (`gameid`),
  KEY `gameday_players_playerid_idx_g` (`playerid`),
  KEY `gameday_players_teamid_idx_gam` (`teamid`),
  KEY `gameday_players_gameid_playerid_idx_gameday_p` (`gameid`,`playerid`),
  KEY `gameday_players_gameid_t_idx_g` (`t`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_players_class`
--

DROP TABLE IF EXISTS `gameday_players_class`;
CREATE TABLE `gameday_players_class` (
  `playerid` int(11) default NULL,
  `name` varchar(401) default NULL,
  `team` char(3) default NULL,
  `year` varchar(4) default NULL,
  `class` varchar(3) default NULL,
  `games` bigint(21) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_po`
--

DROP TABLE IF EXISTS `gameday_po`;
CREATE TABLE `gameday_po` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` varchar(6) default NULL,
  `atbat_num` int(11) default NULL,
  `atbat_pitch_num` int(11) default NULL,
  `des` varchar(18) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_rosters`
--

DROP TABLE IF EXISTS `gameday_rosters`;
CREATE TABLE `gameday_rosters` (
  `gameid` varchar(32) default NULL,
  `teamid` char(3) default NULL,
  `playerid` int(11) default NULL,
  `first` varchar(200) default NULL,
  `last` varchar(200) default NULL,
  `num` int(11) default NULL,
  `boxname` varchar(200) default NULL,
  `b` varchar(3) default NULL,
  KEY `rosters_playerid_idx_gameday_r` (`playerid`),
  KEY `gameday_rosters_gameid_gameday` (`gameid`),
  KEY `gameday_rosters_teamid_gameday` (`teamid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_runner`
--

DROP TABLE IF EXISTS `gameday_runner`;
CREATE TABLE `gameday_runner` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `atbat_num` int(11) default NULL,
  `atbat_pitch_num` int(11) default NULL,
  `id` int(11) default NULL,
  `earned` varchar(4) default NULL,
  `end` varchar(2) default NULL,
  `event` varchar(24) default NULL,
  `rbi` varchar(4) default NULL,
  `score` varchar(4) default NULL,
  `start` varchar(6) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gameday_umps`
--

DROP TABLE IF EXISTS `gameday_umps`;
CREATE TABLE `gameday_umps` (
  `gameid` varchar(30) default NULL,
  `name` varchar(200) default NULL,
  `position` varchar(200) default NULL,
  KEY `gameday_umps_gameid_idx_gameda` (`gameid`),
  KEY `gameday_umps_name_idx_gameday_` (`name`),
  KEY `gameday_umps_position_idx_game` (`position`),
  KEY `gameday_umps_gameid_position_idx_gameday_u` (`gameid`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `new_pitching`
--

DROP TABLE IF EXISTS `new_pitching`;
CREATE TABLE `new_pitching` (
  `gameid` varchar(30) default NULL,
  `inning` int(11) default NULL,
  `half` int(11) default NULL,
  `num` int(11) default NULL,
  `atbat_pitch_num` int(11) default NULL,
  `pitcher` varchar(91) default NULL,
  `batter` varchar(6) default NULL,
  `x0` float default NULL,
  `y0` float default NULL,
  `z0` float default NULL,
  `start_speed` float default NULL,
  `end_speed` float default NULL,
  `sz_top` float default NULL,
  `sz_bot` float default NULL,
  `px` float default NULL,
  `pz` float default NULL,
  `type` varchar(5) default NULL,
  `des` varchar(30) default NULL,
  `event` text,
  `pfx_x` float default NULL,
  `pfx_z` float default NULL,
  `stand` varchar(6) default NULL,
  `pitcher_hand` varchar(3) default NULL,
  `break_angle` float default NULL,
  `break_length` float default NULL,
  `break_x` double default NULL,
  `break_z` double default NULL,
  `pitch_type` varchar(8) default NULL,
  `pitch_type_conf` float default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `pitch_counts`
--

DROP TABLE IF EXISTS `pitch_counts`;
CREATE TABLE `pitch_counts` (
  `gameid` varchar(30) default NULL,
  `pitcher` varchar(91) default NULL,
  `batter` varchar(6) default NULL,
  `atbat_num` int(11) default NULL,
  `pitchcount` bigint(21) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;