-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: fdb15.biz.nf
-- Generation Time: Aug 29, 2016 at 12:21 AM
-- Server version: 5.7.13-log
-- PHP Version: 5.5.38

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: `2185821_robzmlb`
--

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

--
-- Table structure for table `40manRoster`
--

CREATE TABLE `40manRoster` (
  `id` int(11) NOT NULL,
  `No.` int(11) NOT NULL,
  `player` text NOT NULL,
  `BAT` text NOT NULL,
  `THW` text NOT NULL,
  `HT` text NOT NULL,
  `WT` text NOT NULL,
  `DOB` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `40manRoster`
--

INSERT INTO `40manRoster` (`id`, `No.`, `player`, `BAT`, `THW`, `HT`, `WT`, `DOB`) VALUES
(57, 24, 'Gary Sanchez', 'R', 'R', '6''2', '230', '12/2/92'),
(53, 34, 'Brian McCann', 'L', 'R', '6''3', '225', '2/20/84'),
(55, 27, 'Austin Romine', 'R', 'R', '6''1', '220', '11/22/88'),
(89, 0, 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(65, 18, 'Didi Gregorius', 'L', 'R', '6''3', '205', '2/18/90'),
(63, 14, 'Starlin Castro', 'R', 'R', '6''2', '230', '3/24/90'),
(71, 25, 'Mark Teixeira', 'S', 'R', '6''3', '225', '4/11/80'),
(67, 12, 'Chase Headley', 'S', 'R', '6''2', '215', '5/9/84'),
(73, 17, 'Ronald Torreyes', 'R', 'R', '5''10', '150', '9/9/92'),
(61, 33, 'Greg Bird', 'L', 'R', '6''4', '220', '11/9/92'),
(69, 38, 'Rob Refsnyder', 'R', 'R', '6''0', '220', '3/26/91'),
(59, 26, 'Tyler Austin', 'R', 'R', '6''2', '220', '9/6/91'),
(77, 22, 'Jacoby Ellsbury', 'L', 'L', '6''1', '195', '9/11/83'),
(81, 11, 'Brett Gardner', 'L', 'L', '5''11', '195', '8/24/83'),
(83, 31, 'Aaron Hicks', 'S', 'R', '6''1', '205', '10/2/89'),
(85, 99, 'Aaron Judge', 'R', 'R', '6''7', '275', '4/26/92'),
(75, 29, 'Dustin Ackley', 'L', 'R', '6''1', '205', '2/26/88'),
(79, 64, 'Ben Gamel', 'L', 'L', '5''11', '185', '5/17/92'),
(87, 66, 'Mason Williams', 'L', 'R', '6''1', '185', '8/21/91'),
(1, 26, 'Johnny Barbato', 'R', 'R', '6''1', '235', '7/11/92'),
(3, 68, 'Dellin Betances', 'R', 'R', '6''8', '365', '3/23/88'),
(5, 50, 'Richard Bleier', 'L', 'L', '6''3', '215', '4/16/87'),
(7, 85, 'Luis Cessa', 'R', 'R', '6''0', '205', '4/25/92'),
(9, 29, 'Tyler Clippard', 'R', 'R', '6''3', '200', '2/14/85'),
(11, 30, 'Nathan Eovaldi', 'R', 'R', '6''2', '225', '2/13/90'),
(13, 57, 'Nick Goody', 'R', 'R', '5''11', '195', '7/6/91'),
(15, 0, 'J.R. Graham', 'R', '', '5''11', '195', '1/14/90'),
(17, 57, 'Chad Green', 'L', 'R', '6''3', '210', '5/24/91'),
(19, 50, 'Ben Heller', 'R', 'R', '6''3', '205', '8/5/91'),
(21, 39, 'Tommy Layne', 'L', 'L', '6''2', '195', '11/2/84'),
(23, 65, 'Jacob Lindgren', 'L', 'L', '5''11', '210', '3/12/93'),
(25, 55, 'Bryan Mitchell', 'L', 'R', '6''3', '210', '4/19/91'),
(27, 57, 'Conor Mullee', 'R', 'R', '6''4', '195', '2/25/88'),
(29, 47, 'Blake Parker', 'R', 'R', '6''3', '225', '6/19/85'),
(31, 0, 'James Pazos', 'R', 'L', '6''2', '235', '5/5/91'),
(33, 0, 'Branden Pinder', 'R', 'R', '6''4', '215', '1/26/89'),
(35, 35, 'Michael Pineda', 'R', 'R', '6''7', '260', '1/18/89'),
(37, 50, 'Nick Rumbelow', 'R', 'R', '6''0', '190', '9/6/91'),
(39, 52, 'CC Sabathia', 'L', 'L', '6''6', '300', '7/21/80'),
(41, 40, 'Luis Severino', 'R', 'R', '6''2', '215', '2/20/94'),
(43, 45, 'Chasen Shreve', 'L', 'L', '6''4', '195', '7/12/90'),
(45, 41, 'Anthony Swarzak', 'R', 'R', '6''4', '215', '9/10/85'),
(47, 19, 'Masahiro Tanaka', 'R', 'R', '6''3', '215', '11/1/88'),
(49, 43, 'Adam Warren', 'R', 'R', '6''1', '225', '8/25/87'),
(51, 50, 'Kirby Yates', 'L', 'R', '5''10', '210', '3/25/87');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `40manRoster`
--
ALTER TABLE `40manRoster`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38123124;
/*!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 */;
