text: -- phpMyAdmin SQL Dump
  -- version 3.2.0
  -- http://www.phpmyadmin.net
  --
  -- Host: mysql.cs.virginia.edu:3306
  -- Generation Time: May 01, 2019 at 12:08 AM
  -- Server version: 5.5.60
  -- PHP Version: 5.4.16
  
  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: `gzg4zf`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Baseball_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `Baseball_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Runs` int(11) NOT NULL,
    `Hits` int(11) NOT NULL,
    `Home_runs` int(11) NOT NULL,
    `Runs_batted_in` int(11) NOT NULL,
    `ERA` decimal(10,2) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Baseball_Stats`
  --
  
  INSERT INTO `Baseball_Stats` (`Player_id`, `Year`, `Runs`, `Hits`, `Home_runs`, `Runs_batted_in`, `ERA`) VALUES
  (167, 2018, 0, 0, 0, 0, 0.00),
  (168, 2018, 0, 0, 0, 0, 0.00),
  (169, 2018, 1, 4, 1, 4, 0.00),
  (170, 2018, 30, 7, 3, 18, 0.00),
  (171, 2018, 5, 0, 0, 3, 0.00),
  (172, 2018, 60, 10, 0, 5, 18.90),
  (173, 2018, 11, 21, 2, 15, 0.00),
  (174, 2018, 45, 86, 11, 0, 3.96),
  (175, 2018, 39, 59, 2, 20, 0.00),
  (176, 2018, 27, 36, 2, 0, 5.23),
  (177, 2018, 19, 31, 0, 14, 0.00),
  (178, 2018, 24, 55, 4, 36, 0.00),
  (179, 2018, 43, 98, 12, 0, 3.48),
  (180, 2018, 19, 10, 1, 0, 3.26),
  (181, 2018, 21, 42, 3, 0, 3.18),
  (182, 2018, 24, 42, 0, 14, 0.00),
  (183, 2018, 42, 72, 5, 49, 0.00),
  (184, 2018, 0, 0, 0, 0, 0.00),
  (185, 2018, 17, 26, 3, 0, 2.70),
  (186, 2018, 24, 40, 0, 18, 0.00),
  (187, 2018, 14, 12, 2, 0, 4.96),
  (188, 2018, 18, 19, 2, 0, 8.15),
  (189, 2018, 0, 0, 0, 0, 0.00),
  (190, 2018, 16, 9, 1, 0, 5.40),
  (191, 2018, 7, 16, 1, 0, 3.57),
  (192, 2018, 3, 2, 0, 2, 0.00),
  (193, 2018, 17, 27, 12, 34, 0.00),
  (194, 2018, 28, 56, 3, 36, 0.00),
  (195, 2018, 12, 19, 0, 0, 3.64),
  (196, 2018, 18, 26, 0, 0, 5.81),
  (197, 2018, 1, 0, 0, 0, 0.00),
  (198, 2018, 0, 1, 0, 0, 0.00),
  (199, 2018, 25, 13, 4, 0, 3.70),
  (200, 2018, 28, 36, 4, 15, 0.00),
  (201, 2019, 0, 0, 0, 0, 0.00),
  (202, 2019, 10, 20, 0, 15, 0.00),
  (203, 2019, 29, 49, 5, 30, 0.00),
  (204, 2019, 8, 7, 0, 3, 0.00),
  (205, 2019, 0, 0, 0, 0, 0.00),
  (206, 2019, 7, 6, 1, 3, 0.00),
  (207, 2019, 33, 53, 5, 30, 0.00),
  (208, 2019, 1, 2, 0, 1, 0.00),
  (209, 2019, 44, 62, 5, 34, 0.00),
  (210, 2019, 0, 0, 0, 0, 0.00),
  (211, 2019, 17, 34, 0, 15, 0.00),
  (212, 2019, 25, 26, 2, 22, 0.00),
  (213, 2019, 0, 0, 0, 0, 0.00),
  (214, 2019, 9, 17, 1, 0, 3.72),
  (215, 2019, 20, 33, 2, 0, 4.45),
  (216, 2019, 31, 57, 1, 24, 0.00),
  (217, 2019, 32, 45, 5, 30, 0.00),
  (218, 2019, 0, 0, 0, 0, 0.00),
  (219, 2019, 20, 34, 0, 12, 0.00),
  (220, 2019, 7, 17, 0, 0, 4.20),
  (221, 2019, 25, 41, 3, 0, 4.24),
  (222, 2019, 19, 48, 4, 0, 3.51),
  (223, 2019, 38, 71, 7, 0, 5.17),
  (224, 2019, 14, 17, 2, 0, 3.54),
  (225, 2019, 0, 0, 0, 0, 0.00),
  (226, 2019, 27, 48, 2, 27, 0.00),
  (227, 2019, 8, 22, 1, 0, 2.82),
  (228, 2019, 14, 5, 0, 0, 8.04),
  (229, 2019, 8, 13, 1, 0, 4.70),
  (230, 2019, 13, 26, 3, 0, 3.90),
  (231, 2019, 3, 9, 0, 0, 2.31),
  (232, 2019, 0, 0, 0, 0, 0.00),
  (233, 2019, 0, 0, 0, 0, 0.00),
  (234, 2019, 34, 58, 6, 0, 6.19),
  (235, 2019, 13, 10, 0, 6, 0.00);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Basketball_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `Basketball_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Points_per_game` decimal(10,2) NOT NULL,
    `Rebounds_per_game` decimal(10,2) NOT NULL,
    `Assists_per_game` decimal(10,2) NOT NULL,
    `Blocks_per_game` decimal(10,2) NOT NULL,
    `Steals_per_game` decimal(10,2) NOT NULL,
    `Field_goal_percentage` decimal(10,2) NOT NULL,
    `Three_pointers_made` int(10) NOT NULL,
    `Three_point_percentage` decimal(10,2) NOT NULL,
    `Free_throw_percentage` decimal(10,2) NOT NULL,
    `Games_Played` int(11) NOT NULL,
    `Total_Points` int(10) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Triggers `Basketball_Stats`
  --
  DROP TRIGGER IF EXISTS `gzg4zf`.`tot_points`;
  DELIMITER //
  CREATE TRIGGER `gzg4zf`.`tot_points` BEFORE INSERT ON `gzg4zf`.`Basketball_Stats`
   FOR EACH ROW set new.Total_Points = new.Points_per_game * new.Games_Played
  //
  DELIMITER ;
  
  --
  -- Dumping data for table `Basketball_Stats`
  --
  
  INSERT INTO `Basketball_Stats` (`Player_id`, `Year`, `Points_per_game`, `Rebounds_per_game`, `Assists_per_game`, `Blocks_per_game`, `Steals_per_game`, `Field_goal_percentage`, `Three_pointers_made`, `Three_point_percentage`, `Free_throw_percentage`, `Games_Played`, `Total_Points`) VALUES
  (1, 2018, 15.40, 4.50, 2.10, 0.10, 0.70, 0.45, 3, 0.43, 0.83, 38, 585),
  (2, 2018, 15.00, 5.00, 2.00, 1.00, 1.00, 1.00, 1, 0.00, 1.00, 38, 0),
  (3, 2018, 14.00, 4.00, 6.00, 0.00, 2.00, 0.00, 2, 0.00, 1.00, 37, 0),
  (4, 2018, 7.00, 4.00, 0.00, 2.00, 0.00, 1.00, 0, 0.00, 1.00, 38, 0),
  (5, 2018, 6.00, 5.00, 1.00, 1.00, 1.00, 0.00, 1, 0.00, 1.00, 38, 0),
  (6, 2018, 5.00, 2.00, 3.00, 0.00, 1.00, 0.00, 1, 0.00, 1.00, 38, 0),
  (7, 2018, 4.00, 2.00, 0.00, 1.00, 0.00, 1.00, 0, 0.00, 1.00, 34, 0),
  (8, 2018, 4.00, 4.00, 0.00, 0.00, 0.00, 1.00, 0, 0.00, 1.00, 37, 0),
  (9, 2018, 2.00, 1.00, 0.00, 0.00, 0.00, 0.00, 0, 0.00, 1.00, 18, 0),
  (10, 2018, 1.00, 0.00, 0.00, 0.00, 0.00, 1.00, 0, 1.00, 1.00, 10, 0),
  (11, 2018, 1.00, 1.00, 1.00, 0.00, 0.00, 0.00, 0, 0.00, 1.00, 22, 0),
  (12, 2018, 1.00, 1.00, 0.00, 0.00, 0.00, 0.00, 0, 0.00, 0.00, 11, 0),
  (13, 2018, 1.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0.00, 1.00, 14, 0),
  (14, 2018, 1.00, 0.00, 0.00, 0.00, 0.00, 1.00, 0, 0.00, 1.00, 11, 0),
  (354, 2017, 14.00, 3.00, 2.00, 0.00, 1.00, 0.00, 2, 0.00, 1.00, 34, 0),
  (355, 2017, 12.00, 4.00, 3.00, 0.00, 1.00, 0.00, 2, 0.00, 1.00, 34, 0),
  (356, 2017, 11.00, 3.00, 4.00, 0.00, 2.00, 0.00, 2, 0.00, 1.00, 34, 0),
  (357, 2017, 9.00, 4.00, 1.00, 0.00, 1.00, 0.00, 1, 0.00, 1.00, 33, 0),
  (358, 2017, 6.00, 6.00, 2.00, 1.00, 1.00, 0.00, 0, 0.00, 1.00, 34, 0),
  (359, 2017, 5.00, 3.00, 0.00, 1.00, 0.00, 1.00, 0, 0.00, 1.00, 34, 0),
  (360, 2017, 5.00, 2.00, 2.00, 0.00, 1.00, 0.00, 1, 0.00, 1.00, 31, 0),
  (361, 2017, 3.00, 4.00, 0.00, 1.00, 0.00, 1.00, 0, 0.00, 1.00, 12, 0),
  (362, 2017, 3.00, 2.00, 0.00, 1.00, 0.00, 1.00, 0, 0.00, 0.00, 34, 0),
  (363, 2017, 2.00, 1.00, 1.00, 0.00, 0.00, 0.00, 0, 0.00, 0.00, 13, 0),
  (364, 2017, 1.00, 1.00, 0.00, 0.00, 0.00, 1.00, 0, 0.00, 1.00, 10, 0),
  (365, 2017, 1.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 1.00, 1.00, 10, 0),
  (366, 2017, 0.00, 0.00, 0.00, 0.00, 0.00, 1.00, 0, 0.00, 0.00, 10, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Coach`
  --
  
  CREATE TABLE IF NOT EXISTS `Coach` (
    `First_name` varchar(40) NOT NULL,
    `Last_name` varchar(50) NOT NULL,
    `Sport` varchar(50) NOT NULL,
    `Description` varchar(400) NOT NULL,
    `PictureUrl` varchar(200) NOT NULL,
    `ProfilePicUrl` varchar(200) NOT NULL,
    `WikiUrl` varchar(200) NOT NULL,
    `LinkUrl` varchar(200) NOT NULL,
    PRIMARY KEY (`Last_name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Coach`
  --
  
  INSERT INTO `Coach` (`First_name`, `Last_name`, `Sport`, `Description`, `PictureUrl`, `ProfilePicUrl`, `WikiUrl`, `LinkUrl`) VALUES
  ('Tony', 'Bennett', 'Basketball', 'Anthony Guy Bennett is an American basketball coach and former player. He has been the head men''s basketball coach at the University of Virginia since March 31, 2009.', 'http://www.cs.virginia.edu/~su9ej/docs/CS4750-Project/images/tony-bennett.jpg', 'https://virginiasports.com/images/2018/8/22/Bennett_Tony_Mug.jpg', 'https://en.wikipedia.org/wiki/Tony_Bennett_(basketball,_born_1969)', 'https://virginiasports.com/coaches.aspx?rc=48&path=mbball'),
  ('George', 'Gelnovatch', 'Soccer', 'George Gelnovatch is the men''s soccer coach at the University of Virginia. He played professionally in the Major Indoor Soccer League and American Professional Soccer League. As head coach, he has led Virginia men''s soccer to the College Cup Final Four in 1997, 2006, 2009, 2013, and 2014.', 'https://news.virginia.edu/sites/default/files/styles/uva_basic_article/public/article_image/george_gelnovatch_mr_header_3-2.jpg', 'https://virginiasports.com/images/2018/7/26/Gelnovatch_George_18M.JPG?width=300', 'https://en.wikipedia.org/wiki/George_Gelnovatch', 'https://virginiasports.com/coaches.aspx?rc=1528'),
  ('Bronco', 'Mendenhall', 'Football', 'Marc Bronco Clay Mendenhall is the head coach of the Virginia Cavaliers football team at the University of Virginia.', 'https://cdn.vox-cdn.com/thumbor/MgR7h-SGLX2UYYJ3RAiraw0QVmc=/0x0:4324x2882/1200x800/filters:focal(1662x696:2352x1386)/cdn.vox-cdn.com/uploads/chorus_image/image/60020843/usa_today_9671864.0.jpg', 'https://virginiasports.com/images/2018/7/17/Mendenhall_Bronco_16M.JPG', 'https://en.wikipedia.org/wiki/Bronco_Mendenhall', 'https://virginiasports.com/coaches.aspx?rc=131'),
  ('Brian', 'O''Connor', 'Baseball', 'Brian Patrick O''Connor is the head baseball coach of the Virginia Cavaliers. Previously serving as an Associate Head Coach at Notre Dame, he was hired on July 8, 2003, to replace the retiring Dennis Womack.', 'http://www.cs.virginia.edu/~su9ej/docs/CS4750-Project/images/brian-oconnor.jpg', 'https://virginiasports.com/images/2018/11/29/O_Connor_Brian_19M.jpg', 'https://en.wikipedia.org/wiki/Brian_O%27Connor_(baseball_coach)', 'https://virginiasports.com/coaches.aspx?rc=2580&path=baseball'),
  ('Steve', 'Swanson', 'wBasketball', 'Through 27 seasons as a head coach, including the last 17 years at the helm of Virginia''s program, Swanson has established himself as one of the elite coaches in collegiate soccer, and certainly one of the most respected. Swanson has led his teams to seven conference championships, 22 NCAA Tournament appearances and 26 consecutive winning seasons during his 27-year career.', 'https://virginia.sportswar.com/wp-content/uploads/sites/14/2015/07/2015SOC_us_swanson001b.jpg', 'https://virginiasports.com/images/2018/5/14/9122400.jpeg', 'https://en.wikipedia.org', 'https://virginiasports.com/coaches.aspx?rc=455'),
  ('Tina', 'Thompson', 'wSoccer', 'Tina Marie Thompson is an American former WNBA professional basketball player and the head coach of the Virginia Cavaliers women''s basketball team. Thompson was inducted into both the Women''s Basketball Hall of Fame and the Naismith Memorial Basketball Hall of Fame in 2018.', 'https://news.virginia.edu/sites/default/files/styles/uva_basic_article/public/article_image/tina_thompson_mr_header_3-2.jpg', 'https://virginiasports.com/images/2018/10/24/ThompsonT.jpg', 'https://en.wikipedia.org/wiki/Tina_Thompson', 'https://virginiasports.com/coaches.aspx?rc=87');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Football_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `Football_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Touchdowns` int(10) NOT NULL,
    `Yards` int(10) NOT NULL,
    `Long` int(10) NOT NULL,
    `Tackles` int(10) NOT NULL,
    `Sacks` decimal(10,1) NOT NULL,
    `Turnovers` int(10) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Football_Stats`
  --
  
  INSERT INTO `Football_Stats` (`Player_id`, `Year`, `Touchdowns`, `Yards`, `Long`, `Tackles`, `Sacks`, `Turnovers`) VALUES
  (86, 2017, 7, 1032, 25, 0, 0.0, 0),
  (87, 2017, 3, 361, 75, 0, 0.0, 0),
  (88, 2017, 0, 0, 0, 137, 3.5, 4),
  (89, 2017, 6, 1082, 81, 0, 0.0, 0),
  (90, 2017, 5, 647, 42, 0, 0.0, 0),
  (91, 2017, 25, 3207, 81, 0, 0.0, 0),
  (92, 2017, 2, 266, 25, 0, 0.0, 0),
  (93, 2017, 0, 0, 0, 46, 3.5, 1),
  (96, 2017, 0, 0, 0, 68, 7.5, 3),
  (97, 2017, 7, 689, 73, 0, 0.0, 0),
  (100, 2017, 0, 0, 0, 46, 0.0, 0),
  (101, 2017, 0, 0, 0, 0, 0.0, 0),
  (102, 2017, 0, 0, 0, 0, 0.0, 0),
  (103, 2017, 0, 0, 0, 0, 0.0, 0),
  (104, 2017, 0, 0, 0, 63, 0.5, 4),
  (105, 2017, 1, 110, 16, 0, 0.0, 0),
  (106, 2017, 0, 55, 18, 0, 0.0, 0),
  (107, 2017, 0, 0, 0, 0, 0.0, 0),
  (108, 2017, 0, 0, 0, 0, 0.0, 0),
  (109, 2017, 0, 0, 0, 0, 0.0, 0),
  (110, 2017, 0, 0, 0, 64, 2.0, 4),
  (111, 2017, 0, 0, 0, 0, 0.0, 0),
  (112, 2017, 0, 0, 0, 0, 0.0, 0),
  (113, 2017, 0, 0, 0, 0, 0.0, 0),
  (114, 2017, 0, 0, 0, 0, 0.0, 0),
  (115, 2017, 0, 0, 0, 0, 0.0, 0),
  (116, 2017, 0, 0, 0, 47, 1.0, 2),
  (117, 2017, 0, 0, 0, 0, 0.0, 0),
  (118, 2017, 0, 0, 0, 114, 3.0, 2),
  (119, 2017, 0, 0, 0, 0, 0.0, 0),
  (120, 2017, 0, 0, 0, 41, 0.0, 1),
  (121, 2017, 0, 0, 0, 0, 0.0, 0),
  (122, 2017, 0, 0, 0, 0, 0.0, 0),
  (123, 2017, 0, 0, 0, 0, 0.0, 0),
  (124, 2017, 0, 0, 0, 0, 0.0, 0),
  (125, 2017, 0, 0, 0, 0, 0.0, 0),
  (126, 2017, 0, 0, 0, 0, 0.0, 0),
  (127, 2017, 0, 0, 0, 0, 0.0, 0),
  (128, 2017, 0, 0, 0, 0, 0.0, 0),
  (129, 2017, 0, 0, 0, 0, 0.0, 0),
  (130, 2017, 0, 0, 0, 0, 0.0, 0),
  (131, 2017, 0, 0, 0, 0, 0.0, 0),
  (132, 2017, 0, 0, 0, 145, 5.0, 0),
  (133, 2017, 0, 0, 0, 0, 0.0, 0),
  (134, 2017, 0, 0, 0, 0, 0.0, 0),
  (135, 2017, 0, 0, 0, 0, 0.0, 0),
  (136, 2017, 0, 0, 0, 0, 0.0, 0),
  (137, 2017, 0, 0, 0, 58, 5.5, 0),
  (138, 2017, 0, 0, 0, 0, 0.0, 0),
  (139, 2017, 0, 0, 0, 0, 0.0, 0),
  (140, 2017, 0, 0, 0, 0, 0.0, 0),
  (141, 2017, 0, 0, 0, 0, 0.0, 0),
  (142, 2017, 0, 0, 0, 0, 0.0, 0),
  (143, 2017, 0, 0, 0, 0, 0.0, 0),
  (144, 2017, 0, 0, 0, 0, 0.0, 0),
  (145, 2017, 0, 0, 0, 0, 0.0, 0),
  (146, 2017, 0, 0, 0, 0, 0.0, 0),
  (147, 2017, 0, 0, 0, 0, 0.0, 0),
  (148, 2017, 0, 0, 0, 0, 0.0, 0),
  (149, 2017, 0, 0, 0, 0, 0.0, 0),
  (150, 2017, 0, 0, 0, 0, 0.0, 0),
  (151, 2017, 0, 0, 0, 0, 0.0, 0),
  (152, 2017, 0, 0, 0, 0, 0.0, 0),
  (153, 2017, 0, 0, 0, 0, 0.0, 0),
  (154, 2017, 0, 0, 0, 0, 0.0, 0),
  (155, 2017, 0, 0, 0, 0, 0.0, 0),
  (156, 2017, 0, 0, 0, 0, 0.0, 0),
  (157, 2017, 0, 0, 0, 0, 0.0, 0),
  (158, 2017, 0, 0, 0, 0, 0.0, 0),
  (159, 2017, 0, 0, 0, 0, 0.0, 0),
  (160, 2017, 0, 0, 0, 0, 0.0, 0),
  (161, 2017, 0, 0, 0, 0, 0.0, 0),
  (162, 2017, 0, 0, 0, 0, 0.0, 0),
  (163, 2017, 0, 0, 0, 0, 0.0, 0),
  (164, 2017, 0, 0, 0, 0, 0.0, 0),
  (165, 2017, 0, 0, 0, 0, 0.0, 0),
  (166, 2017, 0, 0, 0, 0, 0.0, 0),
  (236, 2018, 10, 1038, 75, 0, 0.0, 0),
  (237, 2018, 7, 465, 75, 0, 0.0, 0),
  (238, 2018, 34, 3876, 86, 0, 0.0, 0),
  (239, 2018, 9, 1018, 86, 0, 0.0, 0),
  (240, 2018, 0, 0, 0, 0, 0.0, 0),
  (241, 2018, 0, 0, 0, 0, 0.0, 0),
  (242, 2018, 0, 0, 0, 0, 0.0, 0),
  (243, 2018, 5, 578, 52, 0, 0.0, 0),
  (244, 2018, 0, 0, 0, 0, 0.0, 0),
  (245, 2018, 0, 0, 0, 0, 0.0, 0),
  (246, 2018, 0, 0, 0, 0, 0.0, 0),
  (247, 2018, 0, 0, 0, 65, 7.5, 0),
  (248, 2018, 0, 0, 0, 0, 0.0, 0),
  (249, 2018, 0, 0, 0, 0, 0.0, 0),
  (250, 2018, 0, 0, 0, 0, 0.0, 0),
  (251, 2018, 0, 0, 0, 0, 0.0, 0),
  (252, 2018, 0, 0, 0, 0, 0.0, 0),
  (253, 2018, 0, 0, 0, 0, 0.0, 0),
  (254, 2018, 0, 0, 0, 0, 0.0, 0),
  (255, 2018, 0, 0, 0, 98, 0.0, 6),
  (256, 2018, 0, 0, 0, 53, 1.0, 0),
  (257, 2018, 0, 0, 0, 0, 0.0, 0),
  (258, 2018, 0, 0, 0, 0, 0.0, 0),
  (259, 2018, 0, 0, 0, 0, 0.0, 0),
  (260, 2018, 0, 121, 32, 0, 0.0, 0),
  (261, 2018, 0, 0, 0, 41, 0.0, 1),
  (262, 2018, 0, 0, 0, 65, 0.0, 2),
  (263, 2018, 0, 0, 0, 0, 0.0, 0),
  (264, 2018, 2, 34, 20, 0, 0.0, 0),
  (265, 2018, 0, 0, 0, 0, 0.0, 0),
  (266, 2018, 0, 0, 0, 63, 2.0, 0),
  (267, 2018, 0, 0, 0, 62, 2.5, 2),
  (268, 2018, 0, 0, 0, 0, 0.0, 0),
  (269, 2018, 0, 0, 0, 66, 2.5, 0),
  (270, 2018, 0, 0, 0, 0, 0.0, 0),
  (271, 2018, 0, 0, 0, 0, 0.0, 0),
  (272, 2018, 0, 0, 0, 0, 0.0, 0),
  (273, 2018, 0, 0, 0, 0, 0.0, 0),
  (274, 2018, 0, 0, 0, 0, 0.0, 0),
  (275, 2018, 0, 0, 0, 0, 0.0, 0),
  (276, 2018, 0, 68, 40, 0, 0.0, 0),
  (277, 2018, 0, 0, 0, 0, 0.0, 0),
  (278, 2018, 2, 141, 16, 0, 0.0, 0),
  (279, 2018, 0, 0, 0, 0, 0.0, 0),
  (280, 2018, 0, 0, 0, 0, 0.0, 0),
  (281, 2018, 0, 0, 0, 0, 0.0, 0),
  (282, 2018, 0, 0, 0, 0, 0.0, 0),
  (283, 2018, 0, 0, 0, 0, 0.0, 0),
  (284, 2018, 0, 0, 0, 0, 0.0, 0),
  (285, 2018, 0, 0, 0, 0, 0.0, 0),
  (286, 2018, 0, 0, 0, 0, 0.0, 0),
  (287, 2018, 0, 0, 0, 0, 0.0, 0),
  (288, 2018, 0, 0, 0, 0, 0.0, 0),
  (289, 2018, 0, 0, 0, 46, 2.0, 0),
  (290, 2018, 0, 0, 0, 0, 0.0, 0),
  (291, 2018, 0, 0, 0, 0, 0.0, 0),
  (292, 2018, 0, 0, 0, 0, 0.0, 0),
  (293, 2018, 0, 0, 0, 0, 0.0, 0),
  (294, 2018, 0, 0, 0, 0, 0.0, 0),
  (295, 2018, 0, 0, 0, 0, 0.0, 0),
  (296, 2018, 0, 0, 0, 0, 0.0, 0),
  (297, 2018, 0, 0, 0, 0, 0.0, 0),
  (298, 2018, 0, 0, 0, 0, 0.0, 0),
  (299, 2018, 0, 0, 0, 0, 0.0, 0),
  (300, 2018, 0, 0, 0, 0, 0.0, 0),
  (301, 2018, 0, 0, 0, 0, 0.0, 0),
  (302, 2018, 0, 0, 0, 0, 0.0, 0),
  (303, 2018, 0, 0, 0, 0, 0.0, 0),
  (304, 2018, 0, 0, 0, 0, 0.0, 0),
  (305, 2018, 0, 0, 0, 0, 0.0, 0),
  (306, 2018, 0, 0, 0, 0, 0.0, 0),
  (307, 2018, 0, 0, 0, 0, 0.0, 0),
  (308, 2018, 0, 0, 0, 0, 0.0, 0),
  (309, 2018, 0, 0, 0, 0, 0.0, 0),
  (310, 2018, 0, 0, 0, 0, 0.0, 0),
  (311, 2018, 0, 0, 0, 0, 0.0, 0),
  (312, 2018, 0, 0, 0, 0, 0.0, 0),
  (313, 2018, 0, 0, 0, 0, 0.0, 0),
  (314, 2018, 0, 0, 0, 0, 0.0, 0),
  (315, 2018, 0, 0, 0, 0, 0.0, 0),
  (316, 2018, 0, 0, 0, 0, 0.0, 0),
  (317, 2018, 0, 0, 0, 0, 0.0, 0),
  (318, 2018, 0, 0, 0, 0, 0.0, 0),
  (319, 2018, 0, 0, 0, 0, 0.0, 0),
  (320, 2018, 0, 0, 0, 0, 0.0, 0),
  (321, 2018, 0, 0, 0, 0, 0.0, 0),
  (322, 2018, 0, 0, 0, 0, 0.0, 0),
  (323, 2018, 0, 0, 0, 0, 0.0, 0),
  (324, 2018, 1, 82, 34, 0, 0.0, 0),
  (325, 2018, 0, 0, 0, 0, 0.0, 0),
  (326, 2018, 0, 0, 0, 0, 0.0, 0),
  (327, 2018, 0, 0, 0, 0, 0.0, 0),
  (328, 2018, 0, 0, 0, 0, 0.0, 0),
  (329, 2018, 0, 0, 0, 0, 0.0, 0),
  (330, 2018, 0, 0, 0, 0, 0.0, 0),
  (331, 2018, 0, 0, 0, 0, 0.0, 0),
  (332, 2018, 0, 0, 0, 0, 0.0, 0),
  (333, 2018, 0, 0, 0, 0, 0.0, 0),
  (334, 2018, 0, 0, 0, 0, 0.0, 0),
  (335, 2018, 0, 0, 0, 0, 0.0, 0),
  (336, 2018, 0, 0, 0, 0, 0.0, 0),
  (337, 2018, 0, 0, 0, 0, 0.0, 0),
  (338, 2018, 0, 0, 0, 0, 0.0, 0),
  (339, 2018, 0, 0, 0, 0, 0.0, 0),
  (340, 2018, 0, 0, 0, 0, 0.0, 0),
  (341, 2018, 0, 0, 0, 0, 0.0, 0),
  (342, 2018, 0, 0, 0, 0, 0.0, 0),
  (343, 2018, 0, 0, 0, 0, 0.0, 0),
  (344, 2018, 0, 0, 0, 0, 0.0, 0),
  (345, 2018, 0, 0, 0, 0, 0.0, 0),
  (346, 2018, 0, 0, 0, 0, 0.0, 0),
  (347, 2018, 0, 0, 0, 0, 0.0, 0),
  (348, 2018, 0, 0, 0, 0, 0.0, 0),
  (349, 2018, 0, 0, 0, 0, 0.0, 0),
  (350, 2018, 0, 0, 0, 0, 0.0, 0),
  (351, 2018, 0, 0, 0, 0, 0.0, 0),
  (352, 2018, 0, 0, 0, 0, 0.0, 0),
  (353, 2018, 0, 0, 0, 0, 0.0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Player`
  --
  
  CREATE TABLE IF NOT EXISTS `Player` (
    `Player_id` int(11) NOT NULL,
    `First_name` varchar(40) NOT NULL,
    `Last_name` varchar(50) NOT NULL,
    `Year` int(11) NOT NULL,
    `Position` varchar(100) NOT NULL,
    PRIMARY KEY (`Player_id`,`Year`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Player`
  --
  
  INSERT INTO `Player` (`Player_id`, `First_name`, `Last_name`, `Year`, `Position`) VALUES
  (1, 'Kyle', 'Guy', 2018, 'G'),
  (2, 'De''Andre', 'Hunter', 2018, 'G'),
  (3, 'Ty', 'Jerome', 2018, 'G'),
  (4, 'Mamadi', 'Diakite', 2018, 'F'),
  (5, 'Braxton', 'Key', 2018, 'G'),
  (6, 'Kihei', 'Clark', 2018, 'G'),
  (7, 'Jay', 'Huff', 2018, 'F'),
  (8, 'Jack', 'Salt', 2018, 'C'),
  (9, 'Kody', 'Stattmann', 2018, 'G'),
  (10, 'Grant', 'Kersey', 2018, 'G'),
  (11, 'Austin', 'Katstra', 2018, 'F'),
  (13, 'Jayden', 'Nixon', 2018, 'G'),
  (14, 'Francesco', 'Badocchi', 2018, 'F'),
  (15, 'Francisco', 'Caffaro', 2018, 'C'),
  (25, 'Connor', 'Jones', 2017, 'GK'),
  (26, 'Jeff', 'Caldwell', 2017, 'GK'),
  (27, 'Sergi', 'Nus', 2017, 'D'),
  (28, 'Fabrice', 'Shema', 2017, 'D'),
  (29, 'Nate', 'Odusote', 2017, 'D'),
  (30, 'Henry', 'Kessler', 2017, 'D'),
  (31, 'Hayes', 'Fountain', 2017, 'M/D'),
  (32, 'Bay', 'Kurtz', 2017, 'D/M'),
  (33, 'Pablo', 'Aguilar', 2017, 'M'),
  (34, 'Kennedy', 'Nwabi', 2017, 'F'),
  (35, 'Edward', 'Opoku', 2017, 'F'),
  (36, 'Joe', 'Bell', 2017, 'M'),
  (37, 'Prosper', 'Figbe', 2017, 'D'),
  (38, 'Daniel', 'Barir', 2017, 'M'),
  (39, 'Liam', 'Jenkins', 2017, 'M/D'),
  (40, 'Simeon', 'Okoro', 2017, 'F'),
  (41, 'Colin', 'Shutler', 2017, 'GK'),
  (42, 'Nathaniel', 'Crofts', 2017, 'F'),
  (43, 'Ryan', 'Peterson', 2017, 'M/F'),
  (44, 'Aaron', 'James', 2017, 'M'),
  (45, 'Jean-Christophe', 'Koffi', 2017, 'M'),
  (46, 'Justin', 'Ingram', 2017, 'M'),
  (47, 'Jerren', 'Nixon Jr.', 2017, 'F'),
  (48, 'Max', 'Diamond', 2017, 'D/M'),
  (49, 'Raheem', 'Taylor-Parkes', 2017, 'F/M'),
  (50, 'Leon', 'Maric', 2017, 'F'),
  (51, 'Robin', 'Afamefuna', 2017, 'D/M'),
  (52, 'Sheldon', 'Sullivan', 2017, 'D'),
  (53, 'Julian', 'Cummings', 2017, 'M/D'),
  (54, 'Ahdan', 'Tait', 2017, 'F'),
  (55, 'Irakoze', 'Donasiyano', 2017, 'F'),
  (56, 'Brad ', 'Kurtz', 2017, 'M'),
  (57, 'Spencer', 'Patton', 2017, 'D'),
  (58, 'Beau', 'Bradley', 2017, 'M'),
  (59, 'Connor', 'Jones', 2018, 'GK'),
  (60, 'Colin', 'Shutler', 2018, 'GK'),
  (61, 'Sergi', 'Nus', 2018, 'D'),
  (62, 'Max', 'Diamond', 2018, 'D/M'),
  (63, 'Prosper', 'Figbe', 2018, 'D'),
  (64, 'Henry', 'Kessler', 2018, 'D'),
  (65, 'Aboubacar', 'Keita', 2018, 'D'),
  (66, 'Simeon', 'Okoro', 2018, 'F'),
  (67, 'Joe', 'Bell', 2018, 'M'),
  (68, 'Kennedy', 'Nwabi', 2018, 'F'),
  (69, 'Justin', 'Ingram', 2018, 'M'),
  (70, 'Irakoze', 'Donasiyano', 2018, 'F'),
  (71, 'Spencer', 'Patton', 2018, 'D'),
  (72, 'Daryl', 'Dike', 2018, 'F'),
  (73, 'Daniel', 'Barir', 2018, 'M'),
  (74, 'Jerren', 'Nixon Jr.', 2018, 'F'),
  (75, 'Marcel', 'Dasilva', 2018, 'GK'),
  (76, 'Nathaniel', 'Crofts', 2018, 'F'),
  (77, 'Cabrel', 'Happi Kamseu', 2018, 'F'),
  (78, 'Aaron', 'James', 2018, 'M'),
  (79, 'Daniel', 'Steedman', 2018, 'M'),
  (80, 'Bret', 'Halsey', 2018, 'M'),
  (81, 'Ben', 'Grant', 2018, 'M'),
  (82, 'Beau', 'Bradley', 2018, 'M'),
  (83, 'Enrique', 'Banuelos', 2018, 'F'),
  (84, 'Robin', 'Afamefuna', 2018, 'D/M'),
  (85, 'Brad ', 'Kurtz', 2018, 'M'),
  (86, 'Jordan', 'Ellis', 2017, 'TB'),
  (87, 'Joe', 'Reed', 2017, 'WR'),
  (88, 'Quin', 'Blanding', 2017, 'FS'),
  (89, 'Olamide', 'Zaccheaus', 2017, 'HB'),
  (90, 'Doni', 'Dowling', 2017, 'WR'),
  (91, 'Kurt', 'Benkert', 2017, 'QB'),
  (92, 'Hasise', 'Dubois', 2017, 'WR'),
  (93, 'Andrew', 'Brown', 2017, 'DE'),
  (94, 'Kirk', 'Garner', 2017, 'CB'),
  (95, 'Joe ', 'Spaziani', 2017, 'QB/LS'),
  (96, 'Chris', 'Peace', 2017, 'OLB'),
  (97, 'Andrew', 'Levrone', 2017, 'WR'),
  (98, 'Devante', 'Cross', 2017, 'QB/WR'),
  (99, 'Richard', 'Burney', 2017, 'DE'),
  (100, 'Malcolm', 'Cook', 2017, 'OLB'),
  (101, 'Ben', 'Hogg', 2017, 'WR'),
  (102, 'Chuck', 'Davis', 2017, 'WR'),
  (103, 'Nick', 'Grant', 2017, 'CB'),
  (104, 'Juan', 'Thornhill', 2017, 'SS'),
  (105, 'Daniel', 'Hamm', 2017, 'TB'),
  (106, 'Warren', 'Craft', 2017, 'WR'),
  (107, 'Lamont', 'Atkins', 2017, 'TB'),
  (108, 'PK', 'Kier', 2017, 'TB'),
  (109, 'Jamari', 'Peacock', 2017, 'FB'),
  (110, 'Brenton', 'Nelson', 2017, 'FS'),
  (111, 'Joey', 'Blount', 2017, 'FS'),
  (112, 'Dominic', 'Sheppard', 2017, 'ILB'),
  (113, 'Chris', 'Sharp', 2017, 'TB'),
  (114, 'Darrius', 'Bratton', 2017, 'DB'),
  (115, 'Zane', 'Zandier', 2017, 'LB'),
  (116, 'Bryce', 'Hall', 2017, 'CB'),
  (117, 'Lindell', 'Stone', 2017, 'QB'),
  (118, 'Jordan', 'Mack', 2017, 'ILB'),
  (119, 'Charles', 'Snowden', 2017, 'LB'),
  (120, 'Chris', 'Moore', 2017, 'OLB/FS'),
  (121, 'CJ', 'Stalker', 2017, 'ILB'),
  (122, 'Germane', 'Crowell', 2017, 'CB'),
  (123, 'Jahvoni', 'Simmons', 2017, 'ILB'),
  (124, 'Elliot ', 'Brown', 2017, 'LB'),
  (125, 'Tanner', 'Cowley', 2017, 'TE'),
  (126, 'Reed', 'Kellam', 2017, 'ILB'),
  (127, 'Evan', 'Butts', 2017, 'TE'),
  (128, 'Lester', 'Coleman', 2017, 'P'),
  (129, 'Alec', 'Shifflett', 2017, 'FB'),
  (130, 'Dre', 'Bryant', 2017, 'OLB'),
  (131, 'Shane', 'Eilers', 2017, 'WR'),
  (132, 'Micah', 'Kiser', 2017, 'ILB'),
  (133, 'Ryan', 'Nelson', 2017, 'OT'),
  (134, 'Brandon', 'Pertile', 2017, 'OT'),
  (135, 'Matt', 'Gahm', 2017, 'LB'),
  (136, 'James', 'Trucilla', 2017, 'DT'),
  (137, 'Eli', 'Hanback', 2017, 'DT'),
  (138, 'Ben ', 'Trent', 2017, 'OT'),
  (139, 'Ben', 'Knutson', 2017, 'OG'),
  (140, 'Jack', 'English', 2017, 'OT'),
  (141, 'Chris', 'Glaser', 2017, 'OT'),
  (142, 'Steven', 'Moss', 2017, 'OG'),
  (143, 'Jack', 'Mcdonald', 2017, 'OG'),
  (144, 'Tyler', 'Fannin', 2017, 'C'),
  (145, 'John', 'Montelus', 2017, 'OG'),
  (146, 'Osiris', 'Crutchfield', 2017, 'TE'),
  (147, 'Jake', 'Fieler', 2017, 'C'),
  (148, 'RJ', 'Proctor', 2017, 'OG'),
  (149, 'Dillon', 'Reinkensmeyer', 2017, 'OT'),
  (150, 'Heskin', 'Smith', 2017, 'WR'),
  (151, 'Nash', 'Griffin', 2017, 'PK/P'),
  (152, 'Braedon', 'Urie', 2017, 'WR'),
  (153, 'Hayden', 'Mitchell', 2017, 'WR'),
  (154, 'Terrell', 'Jana', 2017, 'WR'),
  (155, 'Andrew', 'Yavinsky', 2017, 'FB'),
  (156, 'Ross', 'Gardner', 2017, 'WR'),
  (157, 'Andrew', 'King', 2017, 'PK'),
  (158, 'Justin', 'Zollar', 2017, 'RB'),
  (159, 'Brian', 'Delaney', 2017, 'K'),
  (160, 'Mandy', 'Alonso', 2017, 'DE'),
  (161, 'Davion', 'Zeno', 2017, 'WR'),
  (162, 'Christian', 'Baumgardner', 2017, 'DE'),
  (163, 'Riah', 'Burton', 2017, 'CB'),
  (164, 'AJ', 'Mejia', 2017, 'PK'),
  (165, 'CJ', 'Epps', 2017, 'SS'),
  (166, 'John', 'Kirven', 2017, 'DL'),
  (167, 'Drew', 'Blakely', 2018, 'C'),
  (168, 'Jack', 'Weiller', 2018, 'INF'),
  (169, 'Andrew', 'Papontonis', 2018, 'INF'),
  (170, 'Caleb', 'Knight', 2018, 'C'),
  (171, 'Christian', 'Hlinka', 2018, 'OF'),
  (172, 'Devin', 'Ortiz', 2018, 'INF/RHP'),
  (173, 'Brendan', 'Rivoli', 2018, 'C'),
  (174, 'Daniel', 'Lynch', 2018, 'LHP'),
  (175, 'Tanner', 'Morris', 2018, 'INF'),
  (176, 'Bennett', 'Sousa', 2018, 'LHP'),
  (177, 'Charlie', 'Cody', 2018, 'OF/INF'),
  (178, 'Alex', 'Tappen', 2018, 'INF'),
  (179, 'Derek', 'Casey', 2018, 'RHP'),
  (180, 'Riley', 'Wilson', 2018, 'LHP'),
  (181, 'Andrew', 'Abbott', 2018, 'LHP'),
  (182, 'Justin', 'Novak', 2018, 'INF/C'),
  (183, 'Andy', 'Weber', 2018, 'INF'),
  (184, 'Cameron', 'Simmons', 2018, 'OF'),
  (185, 'Bobby', 'Nicholson', 2018, 'RHP'),
  (186, 'Cayman', 'Richardson', 2018, 'INF/OF'),
  (187, 'Grant', 'Donahue', 2018, 'RHP'),
  (188, 'Griff', 'McGarry', 2018, 'RHP'),
  (189, 'Chesdin', 'Harrington', 2018, 'RHP'),
  (190, 'Noah', 'Murdock', 2018, 'RHP'),
  (191, 'Blake', 'Rohm', 2018, 'RHP'),
  (192, 'Jalen', 'Harrison', 2018, 'OF'),
  (193, 'Jake', 'McCarthy', 2018, 'OF'),
  (194, 'Nate', 'Eikhoff', 2018, 'INF'),
  (195, 'Evan', 'Sperling', 2018, 'RHP'),
  (196, 'Kyle', 'Whitten', 2018, 'RHP'),
  (197, 'Jack', 'Gerstenmaier', 2018, 'INF'),
  (198, 'Will', 'Allocca', 2018, 'C/INF'),
  (199, 'Jack', 'Meyer', 2018, 'RHP'),
  (200, 'Cameron', 'Comer', 2018, 'C/INF'),
  (201, 'Drew', 'Blakely', 2019, 'C'),
  (202, 'Jack', 'Weiller', 2019, 'INF'),
  (203, 'Nic', 'Kent', 2019, 'INF'),
  (204, 'Drew', 'Hamrock', 2019, 'C'),
  (205, 'Christian', 'Hlinka', 2019, 'OF'),
  (206, 'Devin', 'Ortiz', 2019, 'INF/RHP'),
  (207, 'Brendan', 'Rivoli', 2019, 'C'),
  (208, 'Jack', 'Dragum', 2019, 'INF'),
  (209, 'Tanner', 'Morris', 2019, 'INF'),
  (210, 'Ben', 'Harris', 2019, 'OF/LHP'),
  (211, 'Logan', 'Michaels', 2019, 'C'),
  (212, 'Alex', 'Tappen', 2019, 'INF'),
  (213, 'Brandon', 'Neeck', 2019, 'LHP'),
  (214, 'Riley', 'Wilson', 2019, 'LHP'),
  (215, 'Andrew', 'Abbott', 2019, 'LHP'),
  (216, 'Zack', 'Gelof', 2019, 'INF'),
  (217, 'Cameron', 'Simmons', 2019, 'OF'),
  (218, 'Christian', 'Sanchez', 2019, 'RHP'),
  (219, 'Cayman', 'Richardson', 2019, 'INF/OF'),
  (220, 'Grant', 'Donahue', 2019, 'RHP'),
  (221, 'Griff', 'McGarry', 2019, 'RHP'),
  (222, 'Chesdin', 'Harrington', 2019, 'RHP'),
  (223, 'Noah', 'Murdock', 2019, 'RHP'),
  (224, 'Zach', 'Messinger', 2019, 'RHP'),
  (225, 'Jimmy', 'Sullivan', 2019, 'OF'),
  (226, 'Nate', 'Eikhoff', 2019, 'INF'),
  (227, 'Paul', 'Kosanovich', 2019, 'RHP'),
  (228, 'Evan', 'Sperling', 2019, 'RHP'),
  (229, 'Black', 'Bales', 2019, 'RHP'),
  (230, 'Kyle', 'Whitten', 2019, 'RHP'),
  (231, 'Billy', 'Price', 2019, 'LHP'),
  (232, 'Will', 'Allocca', 2019, 'C/INF'),
  (233, 'Sen', 'Kenneally', 2019, 'RHP'),
  (234, 'Mike', 'Vasil', 2019, 'RHP'),
  (235, 'Cameron', 'Comer', 2019, 'C/INF'),
  (236, 'Jordan', 'Ellis', 2018, 'RB'),
  (237, 'Joe', 'Reed', 2018, 'WR'),
  (238, 'Bryce', 'Perkins', 2018, 'QB'),
  (239, 'Olamide', 'Zaccheaus', 2018, 'HB'),
  (240, 'Tim', 'Harris', 2018, 'CB'),
  (241, 'PK', 'Kier', 2018, 'TB'),
  (242, 'Chris', 'Moore', 2018, 'OLB/FS'),
  (243, 'Hasise', 'Dubois', 2018, 'WR'),
  (244, 'Dominic', 'Sheppard', 2018, 'ILB'),
  (245, 'Jamari', 'Peacock', 2018, 'FB'),
  (246, 'Charles', 'Snowden', 2018, 'OLB'),
  (247, 'Chris', 'Peace', 2018, 'OLB'),
  (248, 'Donovan', 'Rolle', 2018, 'DB'),
  (249, 'DeVante', 'Cross', 2018, 'FS/WR'),
  (250, 'Richard', 'Burney', 2018, 'DE'),
  (251, 'Malcolm', 'Cook', 2018, 'ILB'),
  (252, 'Ben', 'Hogg', 2018, 'WR'),
  (253, 'Chuck', 'Davis', 2018, 'WR'),
  (254, 'Nick', 'Grant', 2018, 'CB'),
  (255, 'Juan', 'Thornhill', 2018, 'SS'),
  (256, 'Robert', 'Snyder', 2018, 'ILB'),
  (257, 'Heskin', 'Smith', 2018, 'DB'),
  (258, 'Lamont', 'Atkins', 2018, 'TB'),
  (259, 'Brian', 'Delaney', 2018, 'K'),
  (260, 'Tavares', 'Kelley', 2018, 'WR'),
  (261, 'Brenton', 'Nelson', 2018, 'FS'),
  (262, 'Joey', 'Blount', 2018, 'FS'),
  (263, 'Myles', 'Robinson', 2018, 'CB'),
  (264, 'Chris', 'Sharp', 2018, 'TB'),
  (265, 'Darrius', 'Bratton', 2018, 'CB'),
  (266, 'Zane', 'Zandier', 2018, 'LB'),
  (267, 'Bryce', 'Hall', 2018, 'CB'),
  (268, 'Lindell', 'Stone', 2018, 'QB'),
  (269, 'Jordan', 'Mack', 2018, 'ILB'),
  (270, 'Gladimir', 'Paul', 2018, 'OLB'),
  (271, 'CJ', 'Epps', 2018, 'SS'),
  (272, 'CJ', 'Stalker', 2018, 'ILB'),
  (273, 'Germane', 'Crowell', 2018, 'CB'),
  (274, 'Noah', 'Taylor', 2018, 'OLB'),
  (275, 'Elliott', 'Brown', 2018, 'OLB'),
  (276, 'Tanner', 'Cowley', 2018, 'TE'),
  (277, 'Reed', 'Kellam', 2018, 'ILB'),
  (278, 'Evan', 'Butts', 2018, 'TE'),
  (279, 'Lester', 'Coleman', 2018, 'P'),
  (280, 'Coen', 'King', 2018, 'DB'),
  (281, 'Tommy', 'Christ', 2018, 'DT'),
  (282, 'Javar', 'Garrett', 2018, 'LB'),
  (283, 'Grant', 'Misch', 2018, 'OLB'),
  (284, 'Gerrik', 'Vollmer', 2018, 'C/OG'),
  (285, 'Ryan', 'Nelson', 2018, 'OT'),
  (286, 'Mikey', 'McDonald', 2018, 'ILB'),
  (287, 'Matt', 'Gahm', 2018, 'OLB'),
  (288, 'TC', 'Harrison', 2018, 'LB'),
  (289, 'Eli', 'Hanback', 2018, 'DT'),
  (290, 'Dre', 'Bryant', 2018, 'OLB'),
  (291, 'Colin', 'Dixon', 2018, 'OLB'),
  (292, 'Isaac', 'Buell', 2018, 'DL'),
  (293, 'Samson', 'Reed', 2018, 'DL'),
  (294, 'Tyler', 'Fannin', 2018, 'C'),
  (295, 'Ben', 'Trent', 2018, 'OG'),
  (296, 'Ben', 'Knutson', 2018, 'OG'),
  (297, 'Martin', 'Weisz', 2018, 'OG'),
  (298, 'Derek', 'Devine', 2018, 'OG'),
  (299, 'Dylan', 'Thompson', 2018, 'NT'),
  (300, 'Chris', 'Glaser', 2018, 'OT'),
  (301, 'Bobby', 'Haskins', 2018, 'OT'),
  (302, 'Marcus', 'Applefield', 2018, 'OT'),
  (303, 'Ryan', 'Swoboda', 2018, 'OT'),
  (304, 'Ryan', 'Bischoff', 2018, 'OG'),
  (305, 'Jordan', 'Redmond', 2018, 'NT'),
  (306, 'Jake', 'Fieler', 2018, 'OG/C'),
  (307, 'RJ', 'Proctor', 2018, 'OG'),
  (308, 'Dillon', 'Reinkensmeyer', 2018, 'OT'),
  (309, 'Billy', 'Kemp', 2018, 'HB'),
  (310, 'Nash', 'Griffin', 2018, 'PK/P'),
  (311, 'Hayden', 'Mitchell', 2018, 'WR'),
  (312, 'Terrell', 'Jana', 2018, 'WR'),
  (313, 'Ugo', 'Obasi', 2018, 'WR'),
  (314, 'Justin', 'Zollar', 2018, 'RB'),
  (315, 'Osiris', 'Crutchfield', 2018, 'DE'),
  (316, 'Hunter', 'Pearson', 2018, 'PK'),
  (317, 'Andrew', 'Yavinsky', 2018, 'FB'),
  (318, 'Mandy', 'Alonso', 2018, 'DE'),
  (319, 'Perris', 'Jones', 2018, 'RB'),
  (320, 'Joseph', 'White', 2018, 'DB'),
  (321, 'Aaron', 'Faumui', 2018, 'DT'),
  (322, 'AJ', 'Mejia', 2018, 'PK'),
  (323, 'Cole', 'Lytle', 2018, 'S'),
  (324, 'Brennan', 'Armstrong', 2018, 'QB'),
  (325, 'Joe', 'Spaziani', 2018, 'QB/LS'),
  (326, 'Jaylon', 'Baker', 2018, 'CB'),
  (327, 'Joe', 'Bissinger', 2018, 'OL'),
  (328, 'Parker', 'Chenault', 2018, 'ILB'),
  (329, 'Mark', 'Chichester', 2018, 'CB'),
  (330, 'Evan', 'Clark', 2018, 'LB'),
  (331, 'Josh', 'Clifford', 2018, 'WR/DB'),
  (332, 'Jack', 'Collins', 2018, 'K'),
  (333, 'Dylan', 'Crawford', 2018, 'FB'),
  (334, 'Lee', 'Dudley', 2018, 'LS'),
  (335, 'Shane', 'Eilers', 2018, 'WR'),
  (336, 'Tucker', 'Finkelston', 2018, 'LS'),
  (337, 'Tristan', 'Hillerich', 2018, 'QB'),
  (338, 'Jerry', 'Horng', 2018, 'PK/P'),
  (339, 'Chris', 'Jones', 2018, 'RB'),
  (340, 'Jack', 'Keenan', 2018, 'OL'),
  (341, 'Zain', 'Khokhar', 2018, 'WR'),
  (342, 'TJ', 'Kitts', 2018, 'QB'),
  (343, 'Darren', 'Klein', 2018, 'S'),
  (344, 'Micah', 'Mariteragi', 2018, 'OL'),
  (345, 'DaJuan', 'Moore', 2018, 'QB'),
  (346, 'Daniel', 'Moore', 2018, 'OL/LS'),
  (347, 'Victor', 'Oluwatimi', 2018, 'OL'),
  (348, 'Darnell', 'Pratt', 2018, 'WR'),
  (349, 'Christian', 'Smith', 2018, 'DL'),
  (350, 'Trevor', 'Storm', 2018, 'DL'),
  (351, 'Wayne', 'Taulapapa', 2018, 'TB'),
  (352, 'Vinnie', 'Vladic', 2018, 'S'),
  (353, 'Brandon', 'White', 2018, 'WR'),
  (354, 'Kyle', 'Guy', 2017, 'G'),
  (355, 'Devon', 'Hall', 2017, 'G'),
  (356, 'Ty', 'Jerome', 2017, 'G'),
  (357, 'De''andre', 'Hunter', 2017, 'G'),
  (358, 'Isaiah', 'Wilkins', 2017, 'F'),
  (359, 'Mamadi', 'Diakite', 2017, 'F'),
  (360, 'Nigel', 'Johnson', 2017, 'G'),
  (361, 'Jack', 'Salt', 2017, 'C'),
  (362, 'Jay', 'Huff', 2017, 'F'),
  (363, 'Marco', 'Anthony', 2017, 'G'),
  (364, 'Austin', 'Katstra', 2017, 'F'),
  (365, 'Justice', 'Bartley', 2017, 'G'),
  (366, 'Trevon', 'Gross Jr.', 2017, 'G'),
  (367, 'Brianna', 'Tinsley', 2018, 'G'),
  (368, 'Dominique', 'Toussaint', 2018, 'G'),
  (369, 'Khyasia', 'Caldwell', 2018, 'G'),
  (370, 'Dani', 'Lawson', 2018, 'F'),
  (371, 'Jocelyn', 'Willoughby', 2018, 'G/F'),
  (372, 'Lisa', 'Jablonowski', 2018, 'F'),
  (373, 'Erica', 'Martinsen', 2018, 'G'),
  (374, 'Amandine', 'Toi', 2018, 'G'),
  (375, 'Felicia', 'Aiyeotan', 2018, 'C'),
  (376, 'Mone', 'Jones', 2018, 'F'),
  (377, 'Shakyna', 'Payne', 2018, 'F'),
  (378, 'Ivory', 'Laurel', 2018, 'GK'),
  (379, 'Moran', 'Michaela', 2018, 'GK'),
  (380, 'Serepca', 'Ashlynn', 2018, 'F/D'),
  (381, 'Sieracki', 'Lizzy', 2018, 'D'),
  (382, 'Sumpter', 'Anna', 2018, 'M'),
  (383, 'Petersen', 'Courtney', 2018, 'D/M'),
  (384, 'Torres', 'Taryn', 2018, 'M'),
  (385, 'Morse', 'Zoe', 2018, 'D'),
  (386, 'Constant', 'Claire', 2018, 'D'),
  (387, 'McClernon', 'Phoebe', 2018, 'D'),
  (388, 'Jarrett', 'Rebecca', 2018, 'F/M'),
  (389, 'Zandi', 'Sydney', 2018, 'M/D'),
  (390, 'McCool', 'Meghan', 2018, 'F'),
  (391, 'Angotti', 'McKenna', 2018, 'D'),
  (392, 'Spaanstra', 'Alexa', 2018, 'F/M'),
  (393, 'Gorzak', 'Alissa', 2018, 'F');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `PlayerSport`
  --
  
  CREATE TABLE IF NOT EXISTS `PlayerSport` (
    `Player_id` int(10) NOT NULL,
    `Sport` varchar(50) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `PlayerSport`
  --
  
  INSERT INTO `PlayerSport` (`Player_id`, `Sport`) VALUES
  (1, 'Basketball'),
  (2, 'Basketball'),
  (3, 'Basketball'),
  (4, 'Basketball'),
  (5, 'Basketball'),
  (6, 'Basketball'),
  (7, 'Basketball'),
  (8, 'Basketball'),
  (9, 'Basketball'),
  (10, 'Basketball'),
  (11, 'Basketball'),
  (12, 'Basketball'),
  (13, 'Basketball'),
  (14, 'Basketball'),
  (15, 'Basketball'),
  (25, 'Soccer'),
  (26, 'Soccer'),
  (27, 'Soccer'),
  (28, 'Soccer'),
  (29, 'Soccer'),
  (30, 'Soccer'),
  (31, 'Soccer'),
  (32, 'Soccer'),
  (33, 'Soccer'),
  (34, 'Soccer'),
  (35, 'Soccer'),
  (36, 'Soccer'),
  (37, 'Soccer'),
  (38, 'Soccer'),
  (39, 'Soccer'),
  (40, 'Soccer'),
  (41, 'Soccer'),
  (42, 'Soccer'),
  (43, 'Soccer'),
  (44, 'Soccer'),
  (45, 'Soccer'),
  (46, 'Soccer'),
  (47, 'Soccer'),
  (48, 'Soccer'),
  (49, 'Soccer'),
  (50, 'Soccer'),
  (51, 'Soccer'),
  (52, 'Soccer'),
  (53, 'Soccer'),
  (54, 'Soccer'),
  (55, 'Soccer'),
  (56, 'Soccer'),
  (57, 'Soccer'),
  (58, 'Soccer'),
  (59, 'Soccer'),
  (60, 'Soccer'),
  (61, 'Soccer'),
  (62, 'Soccer'),
  (63, 'Soccer'),
  (64, 'Soccer'),
  (65, 'Soccer'),
  (66, 'Soccer'),
  (67, 'Soccer'),
  (68, 'Soccer'),
  (69, 'Soccer'),
  (70, 'Soccer'),
  (71, 'Soccer'),
  (72, 'Soccer'),
  (73, 'Soccer'),
  (74, 'Soccer'),
  (75, 'Soccer'),
  (76, 'Soccer'),
  (77, 'Soccer'),
  (78, 'Soccer'),
  (79, 'Soccer'),
  (80, 'Soccer'),
  (81, 'Soccer'),
  (82, 'Soccer'),
  (83, 'Soccer'),
  (84, 'Soccer'),
  (85, 'Soccer'),
  (86, 'Football'),
  (87, 'Football'),
  (88, 'Football'),
  (89, 'Football'),
  (90, 'Football'),
  (91, 'Football'),
  (92, 'Football'),
  (93, 'Football'),
  (94, 'Football'),
  (95, 'Football'),
  (96, 'Football'),
  (97, 'Football'),
  (98, 'Football'),
  (99, 'Football'),
  (100, 'Football'),
  (101, 'Football'),
  (102, 'Football'),
  (103, 'Football'),
  (104, 'Football'),
  (105, 'Football'),
  (106, 'Football'),
  (107, 'Football'),
  (108, 'Football'),
  (109, 'Football'),
  (110, 'Football'),
  (111, 'Football'),
  (112, 'Football'),
  (113, 'Football'),
  (114, 'Football'),
  (115, 'Football'),
  (116, 'Football'),
  (117, 'Football'),
  (118, 'Football'),
  (119, 'Football'),
  (120, 'Football'),
  (121, 'Football'),
  (122, 'Football'),
  (123, 'Football'),
  (124, 'Football'),
  (125, 'Football'),
  (126, 'Football'),
  (127, 'Football'),
  (128, 'Football'),
  (129, 'Football'),
  (130, 'Football'),
  (131, 'Football'),
  (132, 'Football'),
  (133, 'Football'),
  (134, 'Football'),
  (135, 'Football'),
  (136, 'Football'),
  (137, 'Football'),
  (138, 'Football'),
  (139, 'Football'),
  (140, 'Football'),
  (141, 'Football'),
  (142, 'Football'),
  (143, 'Football'),
  (144, 'Football'),
  (145, 'Football'),
  (146, 'Football'),
  (147, 'Football'),
  (148, 'Football'),
  (149, 'Football'),
  (150, 'Football'),
  (151, 'Football'),
  (152, 'Football'),
  (153, 'Football'),
  (154, 'Football'),
  (155, 'Football'),
  (156, 'Football'),
  (157, 'Football'),
  (158, 'Football'),
  (159, 'Football'),
  (160, 'Football'),
  (161, 'Football'),
  (162, 'Football'),
  (163, 'Football'),
  (164, 'Football'),
  (165, 'Football'),
  (166, 'Football'),
  (167, 'Baseball'),
  (168, 'Baseball'),
  (169, 'Baseball'),
  (170, 'Baseball'),
  (171, 'Baseball'),
  (172, 'Baseball'),
  (173, 'Baseball'),
  (174, 'Baseball'),
  (175, 'Baseball'),
  (176, 'Baseball'),
  (177, 'Baseball'),
  (178, 'Baseball'),
  (179, 'Baseball'),
  (180, 'Baseball'),
  (181, 'Baseball'),
  (182, 'Baseball'),
  (183, 'Baseball'),
  (184, 'Baseball'),
  (185, 'Baseball'),
  (186, 'Baseball'),
  (187, 'Baseball'),
  (188, 'Baseball'),
  (189, 'Baseball'),
  (190, 'Baseball'),
  (191, 'Baseball'),
  (192, 'Baseball'),
  (193, 'Baseball'),
  (194, 'Baseball'),
  (195, 'Baseball'),
  (196, 'Baseball'),
  (197, 'Baseball'),
  (198, 'Baseball'),
  (199, 'Baseball'),
  (200, 'Baseball'),
  (201, 'Baseball'),
  (202, 'Baseball'),
  (203, 'Baseball'),
  (204, 'Baseball'),
  (205, 'Baseball'),
  (206, 'Baseball'),
  (207, 'Baseball'),
  (208, 'Baseball'),
  (209, 'Baseball'),
  (210, 'Baseball'),
  (211, 'Baseball'),
  (212, 'Baseball'),
  (213, 'Baseball'),
  (214, 'Baseball'),
  (215, 'Baseball'),
  (216, 'Baseball'),
  (217, 'Baseball'),
  (218, 'Baseball'),
  (219, 'Baseball'),
  (220, 'Baseball'),
  (221, 'Baseball'),
  (222, 'Baseball'),
  (223, 'Baseball'),
  (224, 'Baseball'),
  (225, 'Baseball'),
  (226, 'Baseball'),
  (227, 'Baseball'),
  (228, 'Baseball'),
  (229, 'Baseball'),
  (230, 'Baseball'),
  (231, 'Baseball'),
  (232, 'Baseball'),
  (233, 'Baseball'),
  (234, 'Baseball'),
  (235, 'Baseball'),
  (236, 'Football'),
  (237, 'Football'),
  (238, 'Football'),
  (239, 'Football'),
  (240, 'Football'),
  (241, 'Football'),
  (242, 'Football'),
  (243, 'Football'),
  (244, 'Football'),
  (245, 'Football'),
  (246, 'Football'),
  (247, 'Football'),
  (248, 'Football'),
  (249, 'Football'),
  (250, 'Football'),
  (251, 'Football'),
  (252, 'Football'),
  (253, 'Football'),
  (254, 'Football'),
  (255, 'Football'),
  (256, 'Football'),
  (257, 'Football'),
  (258, 'Football'),
  (259, 'Football'),
  (260, 'Football'),
  (261, 'Football'),
  (262, 'Football'),
  (263, 'Football'),
  (264, 'Football'),
  (265, 'Football'),
  (266, 'Football'),
  (267, 'Football'),
  (268, 'Football'),
  (269, 'Football'),
  (270, 'Football'),
  (271, 'Football'),
  (272, 'Football'),
  (273, 'Football'),
  (274, 'Football'),
  (275, 'Football'),
  (276, 'Football'),
  (277, 'Football'),
  (278, 'Football'),
  (279, 'Football'),
  (280, 'Football'),
  (281, 'Football'),
  (282, 'Football'),
  (283, 'Football'),
  (284, 'Football'),
  (285, 'Football'),
  (286, 'Football'),
  (287, 'Football'),
  (288, 'Football'),
  (289, 'Football'),
  (290, 'Football'),
  (291, 'Football'),
  (292, 'Football'),
  (293, 'Football'),
  (294, 'Football'),
  (295, 'Football'),
  (296, 'Football'),
  (297, 'Football'),
  (298, 'Football'),
  (299, 'Football'),
  (300, 'Football'),
  (301, 'Football'),
  (302, 'Football'),
  (303, 'Football'),
  (304, 'Football'),
  (305, 'Football'),
  (306, 'Football'),
  (307, 'Football'),
  (308, 'Football'),
  (309, 'Football'),
  (310, 'Football'),
  (311, 'Football'),
  (312, 'Football'),
  (313, 'Football'),
  (314, 'Football'),
  (315, 'Football'),
  (316, 'Football'),
  (317, 'Football'),
  (318, 'Football'),
  (319, 'Football'),
  (320, 'Football'),
  (321, 'Football'),
  (322, 'Football'),
  (323, 'Football'),
  (324, 'Football'),
  (325, 'Football'),
  (326, 'Football'),
  (327, 'Football'),
  (328, 'Football'),
  (329, 'Football'),
  (330, 'Football'),
  (331, 'Football'),
  (332, 'Football'),
  (333, 'Football'),
  (334, 'Football'),
  (335, 'Football'),
  (336, 'Football'),
  (337, 'Football'),
  (338, 'Football'),
  (339, 'Football'),
  (340, 'Football'),
  (341, 'Football'),
  (342, 'Football'),
  (343, 'Football'),
  (344, 'Football'),
  (345, 'Football'),
  (346, 'Football'),
  (347, 'Football'),
  (348, 'Football'),
  (349, 'Football'),
  (350, 'Football'),
  (351, 'Football'),
  (352, 'Football'),
  (353, 'Football'),
  (354, 'Basketball'),
  (355, 'Basketball'),
  (356, 'Basketball'),
  (357, 'Basketball'),
  (358, 'Basketball'),
  (359, 'Basketball'),
  (360, 'Basketball'),
  (361, 'Basketball'),
  (362, 'Basketball'),
  (363, 'Basketball'),
  (364, 'Basketball'),
  (365, 'Basketball'),
  (366, 'Basketball'),
  (367, 'wBasketball'),
  (368, 'wBasketball'),
  (369, 'wBasketball'),
  (370, 'wBasketball'),
  (371, 'wBasketball'),
  (372, 'wBasketball'),
  (373, 'wBasketball'),
  (374, 'wBasketball'),
  (375, 'wBasketball'),
  (376, 'wBasketball'),
  (377, 'wBasketball'),
  (378, 'wSoccer'),
  (379, 'wSoccer'),
  (380, 'wSoccer'),
  (381, 'wSoccer'),
  (382, 'wSoccer'),
  (383, 'wSoccer'),
  (384, 'wSoccer'),
  (385, 'wSoccer'),
  (386, 'wSoccer'),
  (387, 'wSoccer'),
  (388, 'wSoccer'),
  (389, 'wSoccer'),
  (390, 'wSoccer'),
  (391, 'wSoccer'),
  (392, 'wSoccer'),
  (393, 'wSoccer');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Soccer_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `Soccer_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Minutes` int(11) NOT NULL,
    `Goals` int(10) NOT NULL,
    `Assists` int(10) NOT NULL,
    `SOG` int(10) NOT NULL,
    `Saves` int(10) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Soccer_Stats`
  --
  
  INSERT INTO `Soccer_Stats` (`Player_id`, `Year`, `Minutes`, `Goals`, `Assists`, `SOG`, `Saves`) VALUES
  (25, 2017, 0, 0, 0, 0, 0),
  (26, 2017, 2022, 0, 0, 0, 50),
  (27, 2017, 1962, 6, 1, 13, 0),
  (28, 2017, 0, 0, 0, 0, 0),
  (29, 2017, 238, 0, 0, 0, 0),
  (30, 2017, 363, 0, 0, 0, 0),
  (31, 2017, 21, 0, 0, 0, 0),
  (32, 2017, 0, 0, 0, 0, 0),
  (33, 2017, 1995, 7, 4, 23, 0),
  (34, 2017, 95, 0, 0, 1, 0),
  (35, 2017, 1800, 8, 4, 16, 0),
  (36, 2017, 1907, 2, 1, 0, 5),
  (37, 2017, 1721, 0, 1, 0, 0),
  (38, 2017, 339, 1, 0, 3, 0),
  (39, 2017, 0, 0, 0, 0, 0),
  (40, 2017, 59, 0, 0, 0, 0),
  (41, 2017, 12, 0, 0, 0, 1),
  (42, 2017, 1452, 0, 2, 6, 0),
  (43, 2017, 795, 1, 1, 1, 0),
  (44, 2017, 15, 0, 0, 0, 0),
  (45, 2017, 1976, 3, 4, 5, 0),
  (46, 2017, 42, 0, 0, 1, 0),
  (47, 2017, 219, 0, 1, 0, 0),
  (48, 2017, 10, 0, 0, 0, 0),
  (49, 2017, 587, 2, 0, 5, 0),
  (50, 2017, 7, 0, 0, 0, 0),
  (51, 2017, 1129, 1, 1, 3, 0),
  (52, 2017, 1934, 0, 0, 0, 0),
  (53, 2017, 659, 1, 1, 4, 0),
  (54, 2017, 0, 0, 0, 0, 0),
  (55, 2017, 117, 0, 0, 1, 0),
  (56, 2017, 0, 0, 0, 0, 0),
  (57, 2017, 0, 0, 0, 0, 0),
  (58, 2017, 0, 0, 0, 0, 0),
  (59, 2018, 0, 0, 0, 0, 0),
  (60, 2018, 1410, 0, 0, 0, 43),
  (61, 2018, 0, 0, 0, 0, 0),
  (62, 2018, 10, 0, 0, 0, 0),
  (63, 2018, 1538, 0, 0, 9, 0),
  (64, 2018, 1495, 0, 0, 3, 0),
  (65, 2018, 1599, 1, 0, 3, 0),
  (66, 2018, 959, 2, 1, 6, 0),
  (67, 2018, 1600, 1, 5, 3, 0),
  (68, 2018, 512, 1, 1, 3, 0),
  (69, 2018, 242, 0, 0, 0, 0),
  (70, 2018, 1578, 1, 2, 4, 0),
  (71, 2018, 131, 0, 0, 2, 0),
  (72, 2018, 826, 5, 1, 10, 0),
  (73, 2018, 122, 0, 0, 0, 0),
  (74, 2018, 0, 0, 0, 0, 5),
  (75, 2018, 190, 0, 0, 0, 5),
  (76, 2018, 1448, 4, 6, 10, 0),
  (77, 2018, 1236, 5, 1, 9, 0),
  (78, 2018, 86, 0, 0, 0, 0),
  (79, 2018, 998, 2, 0, 9, 0),
  (80, 2018, 27, 0, 0, 0, 0),
  (81, 2018, 0, 0, 0, 0, 0),
  (82, 2018, 0, 0, 0, 0, 0),
  (83, 2018, 0, 0, 0, 0, 0),
  (84, 2018, 1600, 1, 0, 4, 0),
  (85, 2018, 0, 0, 0, 0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `Sports`
  --
  
  CREATE TABLE IF NOT EXISTS `Sports` (
    `name` varchar(50) NOT NULL,
    `dispname` varchar(50) NOT NULL,
    PRIMARY KEY (`name`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `Sports`
  --
  
  INSERT INTO `Sports` (`name`, `dispname`) VALUES
  ('Baseball', 'Men''s Baseball'),
  ('Basketball', 'Men''s Basketball'),
  ('Football', 'Men''s Football'),
  ('Soccer', 'Men''s Soccer'),
  ('wBasketball', 'Women''s Basketball'),
  ('wSoccer', 'Women''s Soccer');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `wBasketball_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `wBasketball_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Points_per_game` decimal(10,2) NOT NULL,
    `Rebounds_per_game` decimal(10,2) NOT NULL,
    `Assists_per_game` decimal(10,2) NOT NULL,
    `Blocks_per_game` decimal(10,2) NOT NULL,
    `Steals_per_game` decimal(10,2) NOT NULL,
    `Field_goal_percentage` decimal(10,2) NOT NULL,
    `Three_pointers_made` int(10) NOT NULL,
    `Three_point_percentage` decimal(10,2) NOT NULL,
    `Free_throw_percentage` decimal(10,2) NOT NULL,
    `Games_Played` int(11) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `wBasketball_Stats`
  --
  
  INSERT INTO `wBasketball_Stats` (`Player_id`, `Year`, `Points_per_game`, `Rebounds_per_game`, `Assists_per_game`, `Blocks_per_game`, `Steals_per_game`, `Field_goal_percentage`, `Three_pointers_made`, `Three_point_percentage`, `Free_throw_percentage`, `Games_Played`) VALUES
  (367, 2018, 7.60, 2.60, 1.80, 0.00, 0.80, 0.27, 44, 0.27, 0.79, 31),
  (368, 2018, 11.10, 3.70, 3.40, 0.40, 1.10, 0.33, 33, 0.23, 0.73, 31),
  (369, 2018, 5.20, 3.30, 1.30, 0.30, 0.70, 0.38, 7, 0.37, 0.60, 31),
  (370, 2018, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0.00, 0.00, 0),
  (371, 2018, 14.80, 8.20, 1.60, 0.60, 1.20, 0.39, 49, 0.40, 0.85, 31),
  (372, 2018, 7.20, 6.30, 1.20, 0.80, 1.10, 0.49, 2, 0.10, 0.67, 31),
  (373, 2018, 4.70, 1.40, 0.40, 0.20, 0.50, 0.33, 32, 0.31, 0.82, 26),
  (374, 2018, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 0.00, 0.00, 0),
  (375, 2018, 4.90, 6.90, 0.10, 2.40, 0.40, 0.55, 0, 0.00, 0.50, 7),
  (376, 2018, 6.60, 3.90, 1.10, 0.60, 0.50, 0.36, 5, 0.22, 0.82, 20),
  (377, 2018, 1.30, 1.60, 0.10, 0.20, 0.10, 0.32, 0, 0.00, 0.83, 31);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `wSoccer_Stats`
  --
  
  CREATE TABLE IF NOT EXISTS `wSoccer_Stats` (
    `Player_id` int(10) NOT NULL,
    `Year` int(11) NOT NULL,
    `Minutes` int(11) NOT NULL,
    `Goals` int(10) NOT NULL,
    `Assists` int(10) NOT NULL,
    `SOG` int(10) NOT NULL,
    `Saves` int(10) NOT NULL,
    PRIMARY KEY (`Player_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `wSoccer_Stats`
  --
  
  INSERT INTO `wSoccer_Stats` (`Player_id`, `Year`, `Minutes`, `Goals`, `Assists`, `SOG`, `Saves`) VALUES
  (378, 2018, 1727, 0, 0, 0, 39),
  (379, 2018, 236, 0, 0, 0, 1),
  (380, 2018, 543, 1, 2, 4, 0),
  (381, 2018, 922, 2, 3, 4, 0),
  (382, 2018, 837, 1, 2, 5, 0),
  (383, 2018, 913, 0, 4, 8, 0),
  (384, 2018, 1159, 2, 6, 8, 0),
  (385, 2018, 1686, 1, 1, 4, 0),
  (386, 2018, 863, 0, 0, 0, 0),
  (387, 2018, 1858, 0, 0, 1, 0),
  (388, 2018, 978, 6, 2, 16, 0),
  (389, 2018, 1259, 2, 4, 6, 0),
  (390, 2018, 1212, 9, 1, 26, 0),
  (391, 2018, 99, 0, 0, 0, 0),
  (392, 2018, 1409, 9, 6, 23, 0),
  (393, 2018, 772, 2, 4, 3, 0);
  