-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2016 at 10:57 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

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 utf8 */;

--
-- Database: `scoyote_crappie_records`
--

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

--
-- Table structure for table `crappie_records`
--

CREATE TABLE IF NOT EXISTS `crappie_records` (
  `State` text NOT NULL,
  `Weight` text NOT NULL,
  `Inches` text NOT NULL,
  `Lake` text NOT NULL,
  `Person` text NOT NULL,
  `Date` text NOT NULL,
  `Photo` text NOT NULL,
  `Species` varchar(128) DEFAULT 'Black',
  `pk_column` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`pk_column`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Black crappie records' AUTO_INCREMENT=86 ;

--
-- Dumping data for table `crappie_records`
--

INSERT INTO `crappie_records` (`State`, `Weight`, `Inches`, `Lake`, `Person`, `Date`, `Photo`, `Species`, `pk_column`) VALUES
('Alabama (tie)', '4 lbs 5 oz ', '  ', 'Fort Payne Res ', 'Shelley Meadows /Mentone', '3/27/2007', '0', 'Black', 1),
('Alabama (tie)', '4 lbs 5 oz ', '', 'Jefferson Co. pond', 'William D. Webb', '6/2/1997', '0', 'Black', 2),
('Arizona ', '4 lbs 10 oz ', '  ', 'San Carlos Lake  ', 'John Shadrick ', '1959', '0', 'Black', 3),
('Arkansas ', '5 lbs 0 oz ', '  ', 'Lake Wilhelmina', 'Donivan Echols', '6/6/2011', '1', 'Black', 4),
('California ', '4 lbs 1 oz ', '  ', 'New Hogan Lake  ', 'Wilma L. Honey ', '3/29/1975', '0', 'Black', 5),
('Colorado ', '3 lbs 4 oz ', '17" ', 'Private Pond  ', 'Clint Couch ', '1990', '0', 'Black', 6),
('Delaware ', '4 lbs 9 oz ', '  ', 'Noxontown Pond  ', 'Marvin Billips ', '5/30/1976', '0', 'Black', 7),
('Florida ', '3 lbs 13.28 oz ', '  ', 'Lake Talquin  ', 'Ben Curry Sr. ', '1/21/1992', '0', 'Black', 8),
('Georgia ', '4 lbs 4 oz ', '  ', 'Acrees Lake  ', 'Shirley Lavender ', '6/1/1971', '0', 'Black', 9),
('Georgia ', '4 lbs 4 oz ', '  ', 'Lake Spivey  ', 'Steve Cheek ', '3/1/1975', '0', 'Black', 10),
('Idaho ', '3 lbs 8.96 oz ', '17.5" ', 'Brownlee Reservoir ', 'Jason Monson ', '6/8/2003', '0', 'Black', 11),
('Illinois ', '4 lbs 8 oz ', '  ', 'Rend Lake  ', 'John Hampton ', '5/15/1976', '0', 'Black', 12),
('Indiana ', '4 lbs 11 oz ', '  ', 'Private Pond  ', 'Willis Halcomb ', '1994', '0', 'Black', 13),
('Iowa ', '3 lbs 14 oz ', '', 'Three Mile Lake', 'Dale Klein', '6/5/2013', '0', 'Black', 14),
('Kansas ', '4 lbs 10.08 oz ', '22" ', 'Woodson Lake  ', 'Hazel Fey ', '10/21/1957', '0', 'Black', 15),
('Kentucky ', '4 lbs 14 oz ', '  ', 'Watershed Lake ', 'Penny Hopper ', '5/8/2005', '0', 'Black', 16),
('Louisiana ', '3 lbs 13.44 oz ', '  ', 'Poverty Point Reservoir ', 'Randy K. Causey ', '4/1/2010', '0', 'Black', 17),
('Maine (tie)', '3 lbs 4 oz ', '  ', 'Sibley Pond ', 'Wayne S. Morey Sr. ', '9/12/1986', '0', 'Black', 18),
('Maine (tie)', '3 lbs 4 oz ', '', 'Pushineer Pond', 'Carter McLaughlin', '8/20/2008', '0', 'Black', 19),
('Maryland', '4 lbs 7 oz', '', 'Farm Pond ', 'Jason D. Morrison', '5/30/2004', '0', 'Black', 20),
('Massachusetts ', '4 lbs 10 oz ', '  ', 'Jakes Pond ', 'James Crowley ', '1980', '0', 'Black', 21),
('Michigan ', '4 lbs 1.92 oz ', '  ', 'Lincoln Lake  ', 'Frank Lee ', '1947', '0', 'Black', 22),
('Minnesota ', '5 lbs 0 oz ', '21" ', 'Vermillion River  ', 'Tom Christenson ', '1940', '0', 'Black', 23),
('Mississippi ', '4 lbs 4 oz ', '  ', 'Arkabutla Reservoir  ', 'Gerald Conlee ', '3/19/1991', '0', 'Black', 24),
('Missouri ', '5 lbs 0 oz ', '  ', 'Private Pond  ', 'John R. Horstman', '4/21/2006', '0', 'Black', 25),
('Montana ', '3 lbs 2.08 oz ', '16.7" ', 'Tongue River Reservoir  ', 'Al Elser ', '1973', '0', 'Black', 26),
('Nebraska ', '4 lbs 8 oz ', '19" ', 'Farm Pond ', 'Allen Paap Jr. ', '6/15/2003', '0', 'Black', 27),
('Nevada ', '3 lbs 2 oz ', '16.1" ', 'Lake Mead  ', 'Henry Herman ', '1976', '0', 'Black', 28),
('New Hampshire ', '2 lbs 12.8 oz ', '17.25" ', 'Bellamy Reservoir  ', 'Tom Noyes ', '2/9/2000', '0', 'Black', 29),
('New Jersey ', '4 lbs 8 oz ', '  ', 'Pompton Lake  ', 'Andy Tintle ', '1996', '0', 'Black', 30),
('New Mexico ', '4 lbs 9 oz ', '16" ', 'Black River  ', 'Oscar W. Buck ', '3/2/1983', '0', 'Black', 31),
('New York ', '3 lbs 12 oz ', '  ', 'Duck Lake  ', 'Kenneth Kierst ', '4/17/1998', '0', 'Black', 32),
('North Carolina ', '4 lbs 15 oz ', '  ', 'Asheboro City Lake ', 'Dean Dixon ', '4/27/1980', '0', 'Black', 33),
('North Dakota (tie)', '3 lbs 4 oz ', '  ', 'Lake Oahe  ', 'Don Newcomb ', '2/7/1998', '0', 'Black', 34),
('North Dakota (tie)', '3 lbs 4 oz ', '17"', 'Jamestown Reservoir', 'Chris Rick', '1/19/2013', '0', 'Black', 35),
('Ohio ', '4 lbs 8 oz ', '18.125" ', 'Private Pond  ', 'Ronald Stone ', '5/24/1981', '0', 'Black', 36),
('Oklahoma ', '4 lbs 10 oz ', '20" ', 'Private Pond  Ottawa County', 'Rollie Williams ', '6/16/1974', '0', 'Black', 37),
('Oregon ', '4 lbs 0 oz ', '  ', 'Lost River', 'Billy Biggs', '1978', '0', 'Black', 38),
('Pennsylvania ', '4 lbs 2.88 oz ', '  ', 'Hammond Lake  ', 'Richard A. Pino ', '2000', '0', 'Black', 39),
('Rhode Island ', '3 lbs 0 oz ', '15" ', 'Watchaug Pond ', 'R. Sevegny ', '7/1/1976', '0', 'Black', 40),
('South Carolina ', '5 lbs 0 oz ', '  ', 'Lake Moultrie  ', 'P.E. Foust ', '1957', '0', 'Black', 41),
('South Dakota ', '3 lbs 8 oz ', '  ', 'SDSU Pond ', 'Benjamin Wight ', '5/27/2004', '1', 'Black', 42),
('Tennessee ', '4 lbs 4 oz ', '  ', 'Browns Creek Lake  ', 'Clyde Freeman ', '3/23/1985', '0', 'Black', 43),
('Texas ', '3 lbs 14.72 oz ', '18.5" ', 'Lake Fork ', 'George Ward ', '4/27/2003', '0', 'Black', 44),
('Utah ', '3 lbs 5 oz ', '18.5"', 'Lake Powell', 'James Maack', '2009', '0', 'Black', 45),
('Vermont ', '3 lbs 8.5 oz ', '17.25"', 'Lake Hortonia ', 'Francis T. Geoffroy ', '5/28/2005', '0', 'Black', 46),
('Virginia ', '4 lbs 10 oz ', '  ', 'Private Pond  ', 'Justin Elliott ', '4/24/1994', '1', 'Black', 47),
('Washington ', '4 lbs 8 oz ', '  ', 'Lake Washington  ', 'John W. Smart ', '5/1/1956', '0', 'Black', 48),
('West Virginia', '4 lbs .8 oz', '19.75', 'Meathouse Fork', 'Leonard Edgell', '1971', '0', 'Black', 49),
('Wisconsin ', '4 lbs 8 oz ', '19.75', 'Gile Flowage  ', 'Unknown ', '8/12/1967', '0', 'Black', 50),
('Wyoming ', '2 lbs 7.4 oz ', '15 3/8"', 'Boysen Reservoir  ', 'Troy Schnepper', '12/31/2012', '0', 'Black', 51),
('Alabama ', '4 lbs 9 oz ', '  ', 'Martin Lake  ', 'Jeremy S. White ', '5/8/2000', '0', 'White', 52),
('Arizona ', '3 lbs 5.28 oz ', '16.75" ', 'Lake Pleasant  ', 'Robert Schnell ', '2/22/1982', '0', 'White', 53),
('Arkansas ', '4 lbs 7 oz ', '  ', 'Mingo Creek  ', 'Shelby D. Cooper ', '4/12/1993', '1', 'White', 54),
('California ', '4 lbs 8 oz ', '  ', 'Clear Lake  ', 'Carol Carlton ', '4/26/1971', '0', 'White', 55),
('Colorado ', '4 lbs 3.75 oz ', '17" ', 'Northglenn Lake  ', 'Daryel Thompson ', '1975', '0', 'White', 56),
('Georgia ', '5 lbs 0 oz ', '  ', 'Bibb county pond  ', 'Theresa Kemp ', '4/10/1984', '0', 'White', 57),
('Idaho ', '3 lbs 12.8 oz ', '17.5" ', 'Crane Creek Reservoir ', 'Trenten Smith ', '7/16/2012', '0', 'White', 58),
('Illinois ', '4 lbs 7 oz ', '  ', 'private pond  ', 'Kevin Dennis ', '4/8/1973', '0', 'White', 59),
('Iowa', '4 lbs 9 oz ', '', 'Green Castle Lake', 'Ted Trowbridge', '5/1/1981', '0', 'White', 60),
('Kansas ', '4 lbs 0.2 oz ', '17.5" ', 'Farm Pond Greenwood County', 'Frank Miller ', '3/30/1964', '0', 'White', 61),
('Louisiana', '3 lbs 7.04 oz', '', 'Lake Verret', 'Tim Ricca', '2/1/2015', '0', 'White', 62),
('Michigan ', '3 lbs 6.24 oz ', '19.5" ', 'Stony Creek Lake', 'Terrance Poirier ', '2000', '0', 'White', 63),
('Minnesota ', '3 lbs 15 oz ', '18" ', 'Constance Lake  ', 'Michael J. Woodward ', '7/28/2002', '0', 'White', 64),
('Mississippi ', '5 lbs 3 oz ', '  ', 'Enid Reservoir  ', 'Fred Bright ', '7/31/1957', '0', 'White', 65),
('Missouri ', '4 lbs 9 oz ', '  ', 'Private Pond  ', 'Samuel H. Barbee ', '3/5/2000', '0', 'White', 66),
('Montana ', '3 lbs 10.88 oz ', '18.5" ', 'Tongue River  ', 'Gene Bassett ', '5/10/1996', '0', 'White', 67),
('Nebraska ', '4 lbs 1 oz ', '  ', 'Red Willow Reservoir  ', 'Elsie M. Jensen ', '5/18/1980', '0', 'White', 68),
('Nevada ', '3 lbs 1 oz ', '16.1" ', 'Rye Patch Reservoir  ', 'David Lorain', '6/17/2006', '0', 'White', 69),
('New Jersey ', '3 lbs 11 oz ', '  ', 'Mercer Lake ', 'William Lewis ', '2009', '0', 'White', 70),
('New York ', '3 lbs 13 oz ', '  ', 'Sleepy Hollow Lake  ', 'James R. Weinberg ', '6/9/2001', '0', 'White', 71),
('North Carolina', '3 lbs 15 oz ', '', 'Private Lake Wake County', 'Joey Boretti', '4/1/2013', '1', 'White', 72),
('Ohio ', '3 lbs 14.4 oz ', '18.5" ', 'private pond  ', 'Kyle Rock ', '8/25/1995', '0', 'White', 73),
('Oklahoma ', '4 lbs 15 oz ', '19" ', 'private pond  Kingfisher County', 'Frank Robinson ', '5/4/1991', '0', 'White', 74),
('Oregon ', '4 lbs 12 oz ', '  ', 'Gerber Reservoir  ', 'Jim Duckett ', '1967', '0', 'White', 75),
('South Carolina ', '5 lbs 1 oz ', '  ', 'Lake Murray  ', 'Mrs. H.P. Owens ', '1949', '0', 'White', 76),
('South Dakota ', '3 lbs 9 oz ', '  ', 'private pond Hughes County', 'Gary Ernst ', '4/28/1974', '0', 'White', 77),
('Tennessee ', '5 lbs 1 oz ', '  ', 'Garner Brown''s Pond ', 'Bill Allen ', '4/20/1968', '0', 'White', 78),
('Texas ', '4 lbs 8.96 oz ', '  ', 'Navarro Mills Lake  ', 'G.G. Wooderson ', '2/14/1968', '0', 'White', 79),
('Washington ', '2 lbs 12.8 oz ', '  ', 'Columbia River - Burbank Slough ', 'Don J. Benson ', '7/21/1988', '0', 'White', 80),
('Wisconsin ', '3 lbs 13.1 oz ', '16.5" ', 'Cranberry Marsh ', 'unknown ', '5/4/2003', '0', 'White', 81),
('Wyoming ', '2 lbs 7.2 oz ', '16.25"', 'Glendo Reservoir  ', 'Terry Young ', '8/31/2009', '0', 'White', 82);

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