-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `longreach`
--

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

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
  `ID` int(100) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Position` varchar(50) NOT NULL,
  `Price` int(100) NOT NULL,
  `Goals` int(100) NOT NULL,
  `Assists` int(100) NOT NULL,
  `Games_Played` int(100) NOT NULL,
  `Clean_sheets` int(100) NOT NULL,
  `MOTMs` int(100) NOT NULL,
  `Yellow_Cards` int(100) NOT NULL,
  `Red_Cards` int(100) NOT NULL,
  `Points` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `players`
--

INSERT INTO `players` (`ID`, `Name`, `Position`, `Price`, `Goals`, `Assists`, `Games_Played`, `Clean_sheets`, `MOTMs`, `Yellow_Cards`, `Red_Cards`, `Points`) VALUES
(1, 'Lewis C', 'MID', 5, 2, 4, 17, 0, 1, 1, 0, 38),
(2, 'Matt T', 'ATT', 8, 46, 12, 18, 0, 2, 0, 0, 242),
(3, 'Pinky', 'DEF', 6, 0, 12, 17, 4, 1, 0, 0, 67),
(4, 'Conor B', 'DEF', 5, 0, 4, 19, 4, 0, 0, 0, 43),
(5, 'Steven W', 'MID', 5, 0, 1, 17, 0, 0, 0, 0, 20),
(6, 'Jack C', 'MID', 6, 5, 10, 16, 0, 2, 0, 0, 70),
(7, 'Tyler D', 'MID', 6, 9, 6, 13, 0, 0, 0, 0, 67),
(8, 'Jordan C', 'ATT', 6, 10, 9, 19, 0, 1, 0, 0, 88),
(9, 'Josh C', 'ATT', 5, 2, 2, 16, 0, 0, 0, 0, 30),
(10, 'Josh S', 'MID', 5, 1, 1, 12, 0, 0, 0, 0, 19),
(11, 'Jack D', 'DEF', 5, 0, 0, 11, 3, 0, 0, 0, 20),
(12, 'Ash M', 'DEF', 5, 0, 1, 16, 3, 0, 0, 0, 28),
(13, 'Cam E', 'DEF', 5, 0, 4, 20, 4, 0, 0, 0, 44);

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `Team_ID` int(50) NOT NULL,
  `Team_Points` int(255) NOT NULL,
  `User` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`Team_ID`);
COMMIT;

