-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 09, 2017 at 07:00 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 7.0.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `baseball`
--

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

--
-- Table structure for table `test_pitch`
--

CREATE TABLE `test_pitch` (
  `id` int(11) NOT NULL,
  `match_id` int(11) DEFAULT NULL,
  `PlayID` int(11) DEFAULT NULL,
  `AwayTeamRuns` int(11) DEFAULT NULL,
  `HomeTeamRuns` int(11) DEFAULT NULL,
  `HitterID` int(11) DEFAULT NULL,
  `PitcherID` int(11) DEFAULT NULL,
  `Updated` int(11) DEFAULT NULL,
  `is_sent` int(11) DEFAULT '0',
  `season` int(11) DEFAULT NULL,
  `outs` int(11) DEFAULT NULL,
  `InningId` int(11) DEFAULT NULL,
  `Balls` int(11) NOT NULL DEFAULT '0',
  `Strikes` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_pitch`
--

INSERT INTO `test_pitch` (`id`, `match_id`, `PlayID`, `AwayTeamRuns`, `HomeTeamRuns`, `HitterID`, `PitcherID`, `Updated`, `is_sent`, `season`, `outs`, `InningId`, `Balls`, `Strikes`) VALUES
(1, 47311, 2325530, 0, 0, 10000405, 10000282, 1475180233, 0, NULL, 0, 292558, 0, 0),
(2, 47311, 2325536, 0, 0, 10000395, 10000282, 1475180341, 0, NULL, 0, 292558, 1, 2),
(3, 47311, 2325541, 1, 0, 10000393, 10000282, 1475180595, 0, NULL, 1, 292558, 2, 2),
(4, 47311, 2325552, 1, 0, 10000407, 10000282, 1475180678, 0, NULL, 1, 292558, 0, 2),
(5, 47311, 2325557, 2, 0, 10005716, 10000282, 1475180752, 0, NULL, 2, 292558, 0, 0),
(6, 47311, 2325560, 2, 0, 10001939, 10000282, 1475180855, 0, NULL, 2, 292558, 2, 2),
(7, 47311, 2325573, 2, 0, 10001368, 10002058, 1475181066, 0, NULL, 0, 292558, 4, 0),
(8, 47311, 2325577, 2, 0, 10001129, 10002058, 1475181262, 0, NULL, 0, 292558, 0, 2),
(9, 47311, 2325582, 2, 0, 10001123, 10002058, 1475181316, 0, NULL, 2, 292558, 1, 2),
(10, 47311, 2325586, 2, 0, 10000737, 10000282, 1475181484, 0, NULL, 0, 292564, 2, 1),
(11, 47311, 2325587, 2, 0, 10000392, 10000282, 1475181514, 0, NULL, 0, 292564, 0, 0),
(12, 47311, 2325590, 2, 0, 10002058, 10000282, 1475181654, 0, NULL, 1, 292564, 1, 2),
(13, 47311, 2325596, 2, 0, 10000405, 10000282, 1475181771, 0, NULL, 2, 292564, 2, 1),
(14, 47311, 2325601, 2, 0, 10001144, 10002058, 1475181951, 0, NULL, 0, 292564, 1, 1),
(15, 47311, 2325604, 2, 0, 10001130, 10002058, 1475182038, 0, NULL, 1, 292564, 1, 1),
(16, 47311, 2325606, 2, 0, 10001142, 10002058, 1475182179, 0, NULL, 2, 292564, 2, 2),
(17, 47311, 2325610, 2, 0, 10001136, 10002058, 1475182324, 0, NULL, 2, 292564, 2, 2),
(18, 47311, 2325616, 2, 0, 10000395, 10000282, 1475182478, 0, NULL, 0, 292567, 1, 0),
(19, 47311, 2325618, 2, 0, 10000393, 10000282, 1475182797, 0, NULL, 0, 292567, 3, 2),
(20, 47311, 2325625, 2, 0, 10000407, 10000282, 1475182865, 0, NULL, 1, 292567, 0, 1),
(21, 47311, 2325627, 2, 0, 10005716, 10000282, 1475183009, 0, NULL, 1, 292567, 4, 2),
(22, 47311, 2325631, 2, 0, 10001939, 10000282, 1475183075, 0, NULL, 1, 292567, 0, 2),
(23, 47311, 2325637, 2, 0, 10000262, 10002058, 1475183367, 0, NULL, 0, 292567, 2, 2),
(24, 47311, 2325638, 2, 0, 10000282, 10002058, 1475183367, 0, NULL, 0, 292567, 0, 0),
(25, 47311, 2325640, 2, 0, 10001368, 10002058, 1475183420, 0, NULL, 1, 292567, 0, 0),
(26, 47311, 2325641, 2, 0, 10001129, 10002058, 1475183689, 0, NULL, 2, 292567, 3, 2),
(27, 47311, 2325646, 2, 0, 10000737, 10000282, 1475184009, 0, NULL, 0, 292570, 3, 2),
(28, 47311, 2325650, 2, 0, 10000392, 10000282, 1475184086, 0, NULL, 1, 292570, 1, 2),
(29, 47311, 2325652, 2, 0, 10002058, 10000282, 1475184150, 0, NULL, 2, 292570, 0, 1),
(30, 47311, 2325653, 2, 0, 10000405, 10000282, 1475184291, 0, NULL, 2, 292570, 1, 2),
(31, 47311, 2325659, 2, 0, 10001123, 10002058, 1475184587, 0, NULL, 0, 292570, 4, 2),
(32, 47311, 2325662, 2, 0, 10001144, 10002058, 1475185049, 0, NULL, 0, 292570, 1, 1),
(33, 47311, 2325665, 2, 1, 10001130, 10002058, 1475184819, 0, NULL, 0, 292570, 0, 1),
(34, 47311, 2325667, 2, 1, 10001142, 10002058, 1475184931, 0, NULL, 1, 292570, 1, 1),
(35, 47311, 2325668, 2, 2, 10001136, 10002058, 1475185061, 0, NULL, 2, 292570, 0, 0),
(36, 47311, 2325670, 2, 2, 10000262, 10002058, 1475185178, 0, NULL, 2, 292570, 1, 2),
(37, 47311, 2325674, 2, 2, 10000282, 10002058, 1475185267, 0, NULL, 2, 292570, 1, 2),
(38, 47311, 2325681, 2, 2, 10000395, 10000282, 1475185539, 0, NULL, 0, 292575, 2, 2),
(39, 47311, 2325685, 2, 2, 10000393, 10000282, 1475185706, 0, NULL, 1, 292575, 1, 2),
(40, 47311, 2325688, 2, 2, 10000407, 10000282, 1475185810, 0, NULL, 1, 292575, 0, 2),
(41, 47311, 2325690, 2, 2, 10005716, 10000282, 1475185950, 0, NULL, 2, 292575, 3, 2),
(42, 47311, 2325695, 2, 2, 10001368, 10002058, 1475186131, 0, NULL, 0, 292575, 2, 0),
(43, 47311, 2325696, 2, 2, 10001129, 10002058, 1475186169, 0, NULL, 1, 292575, 0, 0),
(44, 47311, 2325700, 2, 2, 10001123, 10002058, 1475186287, 0, NULL, 2, 292575, 4, 1),
(45, 47311, 2325703, 2, 2, 10001144, 10002058, 1475186442, 0, NULL, 2, 292575, 1, 1),
(46, 47311, 2325706, 2, 2, 10001939, 10000282, 1475186658, 0, NULL, 0, 292576, 1, 2),
(47, 47311, 2325708, 2, 2, 10000737, 10000282, 1475186668, 0, NULL, 1, 292576, 0, 0),
(48, 47311, 2325709, 2, 2, 10000392, 10000282, 1475186786, 0, NULL, 1, 292576, 0, 1),
(49, 47311, 2325712, 2, 2, 10001130, 10002058, 1475186964, 0, NULL, 0, 292576, 0, 1),
(50, 47311, 2325717, 2, 2, 10001142, 10002058, 1475187120, 0, NULL, 0, 292576, 0, 0),
(51, 47311, 2325718, 2, 2, 10001136, 10002058, 1475187366, 0, NULL, 0, 292576, 0, 0),
(52, 47311, 2325722, 2, 3, 10000262, 10002058, 1475187377, 0, NULL, 1, 292576, 0, 0),
(53, 47311, 2325723, 2, 5, 10000282, 10002058, 1475187646, 0, NULL, 2, 292576, 0, 1),
(54, 47311, 2325728, 2, 5, 10001368, 10000387, 1475187829, 0, NULL, 2, 292576, 2, 2),
(55, 47311, 2325730, 2, 5, 10001129, 10000387, 1475188044, 0, NULL, 3, 292576, 3, 2),
(56, 47311, 2325738, 2, 5, 10007281, 10000282, 1475188299, 0, NULL, 0, 292580, 1, 2),
(57, 47311, 2325740, 2, 5, 10000405, 10000282, 1475188586, 0, NULL, 1, 292580, 3, 2),
(58, 47311, 2325745, 2, 5, 10000395, 10000282, 1475188586, 0, NULL, 2, 292580, 0, 1),
(59, 47311, 2325746, 2, 5, 10001123, 10000381, 1475188648, 0, NULL, 0, 292580, 0, 0),
(60, 47311, 2325748, 2, 5, 10001144, 10000381, 1475188765, 0, NULL, 1, 292580, 2, 1),
(61, 47311, 2325751, 2, 5, 10001130, 10000381, 1475188816, 0, NULL, 2, 292580, 0, 1),
(62, 47311, 2325754, 2, 5, 10001142, 10000381, 1475188975, 0, NULL, 2, 292580, 1, 2),
(63, 47311, 2325757, 2, 5, 10000393, 10003246, 1475189186, 0, NULL, 0, 292582, 2, 2),
(64, 47311, 2325761, 2, 5, 10000407, 10001116, 1475189437, 0, NULL, 1, 292582, 2, 2),
(65, 47311, 2325765, 2, 5, 10005716, 10001116, 1475189559, 0, NULL, 1, 292582, 1, 2),
(66, 47311, 2325770, 2, 5, 10001939, 10001121, 1475189847, 0, NULL, 2, 292582, 0, 2),
(67, 47311, 2325771, 2, 5, 10001136, 10000381, 1475189940, 0, NULL, 0, 292582, 0, 1),
(68, 47311, 2325773, 2, 5, 10000262, 10000381, 1475190161, 0, NULL, 1, 292582, 4, 2),
(69, 47311, 2325775, 2, 5, 10001143, 10000381, 1475190387, 0, NULL, 1, 292582, 2, 2),
(70, 47311, 2325777, 2, 5, 10001368, 10001200, 1475190568, 0, NULL, 1, 292582, 1, 0),
(71, 47311, 2325778, 2, 6, 10001129, 10001200, 1475190772, 0, NULL, 1, 292582, 4, 2),
(72, 47311, 2325779, 2, 7, 10001123, 10000195, 1475191100, 0, NULL, 1, 292582, 0, 1),
(73, 47311, 2325780, 2, 7, 10001144, 10000195, 1475191169, 0, NULL, 2, 292582, 4, 2),
(74, 47311, 2325781, 2, 7, 10001130, 10000195, 1475191219, 0, NULL, 2, 292582, 0, 0),
(75, 47311, 2325782, 2, 7, 10005353, 10001120, 1475191426, 0, NULL, 0, 292584, 0, 2),
(76, 47311, 2325783, 2, 7, 10000392, 10001120, 1475191476, 0, NULL, 1, 292584, 0, 0),
(77, 47311, 2325784, 2, 7, 10006543, 10001120, 1475191605, 0, NULL, 1, 292584, 1, 2),
(78, 47311, 2325785, 2, 7, 10000405, 10001120, 1475191823, 0, NULL, 2, 292584, 3, 2);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `test_pitch`
--
ALTER TABLE `test_pitch`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `test_pitch`
--
ALTER TABLE `test_pitch`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
