INSERT INTO `races` (`Season`, `Date`, `Time`, `Race`, `Venue`, `Flag`, `Round`) VALUES
(2018, '2018-10-21', '20:10:00', 'United States', 'Circuit of the Americas', 0x[encoded data, 49112 characters], 18);
INSERT INTO `races` (`Season`, `Date`, `Time`, `Race`, `Venue`, `Flag`, `Round`) VALUES
(2018, '2018-10-28', '21:10:00', 'Mexico', 'Mexico City', 0x[encoded data, 36870 characters], 19);
INSERT INTO `races` (`Season`, `Date`, `Time`, `Race`, `Venue`, `Flag`, `Round`) VALUES
(2018, '2018-11-11', '19:10:00', 'Brazil', 'Interlagos', 0x[encoded data, 46078 characters], 20);
INSERT INTO `races` (`Season`, `Date`, `Time`, `Race`, `Venue`, `Flag`, `Round`) VALUES
(2018, '2018-11-25', '15:10:00', 'Abu Dhabi', 'Yas Marina', 0x[encoded data, 33232 characters], 21);

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

--
-- Table structure for table `regform`
--

CREATE TABLE `regform` (
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `phoneno` varchar(10) NOT NULL,
  `email` varchar(50) NOT NULL,
  `USER_ENABLED` int(11) NOT NULL DEFAULT '0',
  `NAME` varchar(50) NOT NULL,
  `IsAdmin` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `regform`
--

INSERT INTO `regform` (`username`, `password`, `phoneno`, `email`, `USER_ENABLED`, `NAME`, `IsAdmin`) VALUES
('moose', 'moose', '1234', 'tyr', 1, 'joaquim', 1),
('jems', 'j123', '', '', 1, 'James', 0);

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

--
-- Table structure for table `results`
--

CREATE TABLE `results` (
  `Season` int(11) NOT NULL,
  `Country` varchar(50) NOT NULL,
  `Position` int(11) NOT NULL,
  `Round` int(11) NOT NULL,
  `DriverName` varchar(100) NOT NULL,
  `Points` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `results`
--

INSERT INTO `results` (`Season`, `Country`, `Position`, `Round`, `DriverName`, `Points`) VALUES
(2018, 'Australia', 1, 1, 'Sebastian Vettel', 25),
(2018, 'Australia', 2, 1, 'Lewis Hamilton', 18),
(2018, 'Australia', 3, 1, 'Kimi Räikkönen', 15),
(2018, 'Australia', 4, 1, 'Daniel Ricciardo', 12),
(2018, 'Australia', 5, 1, 'Fernando Alonso', 10),
(2018, 'Australia', 6, 1, 'Max Verstappen', 8),
(2018, 'Australia', 7, 1, 'Nico Hülkenberg', 6),
(2018, 'Australia', 8, 1, 'Valtteri Bottas', 4),
(2018, 'Australia', 9, 1, 'Stoffel Vandoorne', 2),
(2018, 'Australia', 10, 1, 'Carlos Sainz', 1),
(2018, 'Australia', 11, 1, 'Sergio Pérez', 0),
(2018, 'Australia', 12, 1, 'Esteban Ocon', 0),
(2018, 'Australia', 13, 1, 'Charles Leclerc', 0),
(2018, 'Australia', 14, 1, 'Lance Stroll', 0),
(2018, 'Australia', 15, 1, 'Brendon Hartley', 0),
(2018, 'Australia', 16, 1, 'Romain Grosjean', 0),
(2018, 'Australia', 17, 1, 'Kevin Magnussen', 0),
(2018, 'Australia', 18, 1, 'Pierre Gasly', 0),
(2018, 'Australia', 19, 1, 'Marcus Ericsson', 0),
(2018, 'Australia', 20, 1, 'Sergey Sirotkin', 0),
(2018, 'Australia', 99, 1, 'Daniel Ricciardo', 0),
(2018, 'Bahrain', 1, 2, 'Sebastian Vettel', 25),
(2018, 'Bahrain', 2, 2, 'Valtteri Bottas', 18),
(2018, 'Bahrain', 3, 2, 'Lewis Hamilton', 15),
(2018, 'Bahrain', 4, 2, 'Pierre Gasly', 12),
(2018, 'Bahrain', 5, 2, 'Kevin Magnussen', 10),
(2018, 'Bahrain', 6, 2, 'Nico Hülkenberg', 8),
(2018, 'Bahrain', 7, 2, 'Fernando Alonso', 6),
(2018, 'Bahrain', 8, 2, 'Stoffel Vandoorne', 4),
(2018, 'Bahrain', 9, 2, 'Marcus Ericsson', 2),
(2018, 'Bahrain', 10, 2, 'Esteban Ocon', 1),
(2018, 'Bahrain', 11, 2, 'Carlos Sainz', 0),
(2018, 'Bahrain', 12, 2, 'Charles Leclerc', 0),
(2018, 'Bahrain', 13, 2, 'Romain Grosjean', 0),
(2018, 'Bahrain', 14, 2, 'Lance Stroll', 0),
(2018, 'Bahrain', 15, 2, 'Sergey Sirotkin', 0),
(2018, 'Bahrain', 16, 2, 'Sergio Pérez', 0),
(2018, 'Bahrain', 17, 2, 'Brendon Hartley', 0),
(2018, 'Bahrain', 18, 2, 'Kimi Räikkönen', 0),
(2018, 'Bahrain', 99, 2, 'Valtteri Bottas', 0),
(2018, 'China', 1, 3, 'Daniel Ricciardo', 25),
(2018, 'China', 2, 3, 'Valtteri Bottas', 18),
(2018, 'China', 3, 3, 'Kimi Räikkönen', 15),
(2018, 'China', 4, 3, 'Lewis Hamilton', 12),
(2018, 'China', 5, 3, 'Max Verstappen', 10),
(2018, 'China', 6, 3, 'Nico Hülkenberg', 8),
(2018, 'China', 7, 3, 'Fernando Alonso', 6),
(2018, 'China', 8, 3, 'Sebastian Vettel', 4),
(2018, 'China', 9, 3, 'Carlos Sainz', 2),
(2018, 'China', 10, 3, 'Kevin Magnussen', 1),
(2018, 'China', 11, 3, 'Esteban Ocon', 0),
(2018, 'China', 12, 3, 'Sergio Pérez', 0),
(2018, 'China', 13, 3, 'Stoffel Vandoorne', 0),
(2018, 'China', 14, 3, 'Lance Stroll', 0),
(2018, 'China', 15, 3, 'Sergey Sirotkin', 0),
(2018, 'China', 16, 3, 'Marcus Ericsson', 0),
(2018, 'China', 17, 3, 'Romain Grosjean', 0),
(2018, 'China', 18, 3, 'Pierre Gasly', 0),
(2018, 'China', 19, 3, 'Charles Leclerc', 0),
(2018, 'China', 20, 3, 'Brendon Hartley', 0),
(2018, 'China', 99, 3, 'Daniel Ricciardo', 0),
(2018, 'Azerbaijan', 1, 4, 'Lewis Hamilton', 25),
(2018, 'Azerbaijan', 2, 4, 'Kimi Räikkönen', 18),
(2018, 'Azerbaijan', 3, 4, 'Sergio Pérez', 15),
(2018, 'Azerbaijan', 4, 4, 'Sebastian Vettel', 12),
(2018, 'Azerbaijan', 5, 4, 'Carlos Sainz', 10),
(2018, 'Azerbaijan', 6, 4, 'Charles Leclerc', 8),
(2018, 'Azerbaijan', 7, 4, 'Fernando Alonso', 6),
(2018, 'Azerbaijan', 8, 4, 'Lance Stroll', 4),
(2018, 'Azerbaijan', 9, 4, 'Stoffel Vandoorne', 2),
(2018, 'Azerbaijan', 10, 4, 'Brendon Hartley', 1),
(2018, 'Azerbaijan', 11, 4, 'Marcus Ericsson', 0),
(2018, 'Azerbaijan', 12, 4, 'Pierre Gasly', 0),
(2018, 'Azerbaijan', 13, 4, 'Kevin Magnussen', 0),
(2018, 'Azerbaijan', 14, 4, 'Valtteri Bottas', 0),
(2018, 'Azerbaijan', 15, 4, 'Romain Grosjean', 0),
(2018, 'Azerbaijan', 16, 4, 'Max Verstappen', 0),
(2018, 'Azerbaijan', 17, 4, 'Daniel Ricciardo', 0),
(2018, 'Azerbaijan', 18, 4, 'Nico Hülkenberg', 0),
(2018, 'Azerbaijan', 99, 4, 'Valtteri Bottas', 0),
(2018, 'Spain', 1, 5, 'Lewis Hamilton', 25),
(2018, 'Spain', 2, 5, 'Valtteri Bottas', 18),
(2018, 'Spain', 3, 5, 'Max Verstappen', 15),
(2018, 'Spain', 4, 5, 'Sebastian Vettel', 12),
(2018, 'Spain', 5, 5, 'Daniel Ricciardo', 10),
(2018, 'Spain', 6, 5, 'Kevin Magnussen', 8),
(2018, 'Spain', 7, 5, 'Carlos Sainz', 6),
(2018, 'Spain', 8, 5, 'Fernando Alonso', 4),
(2018, 'Spain', 9, 5, 'Sergio Pérez', 2),
(2018, 'Spain', 10, 5, 'Charles Leclerc', 1),
(2018, 'Spain', 11, 5, 'Lance Stroll', 0),
(2018, 'Spain', 12, 5, 'Brendon Hartley', 0),
(2018, 'Spain', 13, 5, 'Marcus Ericsson', 0),
(2018, 'Spain', 14, 5, 'Sergey Sirotkin', 0),
(2018, 'Spain', 15, 5, 'Stoffel Vandoorne', 0),
(2018, 'Spain', 16, 5, 'Esteban Ocon', 0),
(2018, 'Spain', 17, 5, 'Kimi Räikkönen', 0),
(2018, 'Spain', 99, 5, 'Daniel Ricciardo', 0),
(2018, 'Monaco', 1, 6, 'Daniel Ricciardo', 25),
(2018, 'Monaco', 2, 6, 'Sebastian Vettel', 18),
(2018, 'Monaco', 3, 6, 'Lewis Hamilton', 15),
(2018, 'Monaco', 4, 6, 'Kimi Räikkönen', 12),
(2018, 'Monaco', 5, 6, 'Valtteri Bottas', 10),
(2018, 'Monaco', 6, 6, 'Esteban Ocon', 8),
(2018, 'Monaco', 7, 6, 'Pierre Gasly', 6),
(2018, 'Monaco', 8, 6, 'Nico Hülkenberg', 4),
(2018, 'Monaco', 9, 6, 'Max Verstappen', 2),
(2018, 'Monaco', 10, 6, 'Carlos Sainz', 1),
(2018, 'Monaco', 11, 6, 'Marcus Ericsson', 0),
(2018, 'Monaco', 12, 6, 'Sergio Pérez', 0),
(2018, 'Monaco', 13, 6, 'Kevin Magnussen', 0),
(2018, 'Monaco', 14, 6, 'Stoffel Vandoorne', 0),
(2018, 'Monaco', 15, 6, 'Romain Grosjean', 0),
(2018, 'Monaco', 16, 6, 'Sergey Sirotkin', 0),
(2018, 'Monaco', 17, 6, 'Lance Stroll', 0),
(2018, 'Monaco', 18, 6, 'Charles Leclerc', 0),
(2018, 'Monaco', 19, 6, 'Brendon Hartley', 0),
(2018, 'Monaco', 20, 6, 'Fernando Alonso', 0),
(2018, 'Monaco', 99, 6, 'Max Verstappen', 0),
(2018, 'Canada', 1, 7, 'Sebastian Vettel', 25),
(2018, 'Canada', 2, 7, 'Valtteri Bottas', 18),
(2018, 'Canada', 3, 7, 'Max Verstappen', 15),
(2018, 'Canada', 4, 7, 'Daniel Ricciardo', 12),
(2018, 'Canada', 5, 7, 'Lewis Hamilton', 10),
(2018, 'Canada', 6, 7, 'Kimi Räikkönen', 8),
(2018, 'Canada', 7, 7, 'Nico Hülkenberg', 6),
(2018, 'Canada', 8, 7, 'Carlos Sainz', 4),
(2018, 'Canada', 9, 7, 'Esteban Ocon', 2),
(2018, 'Canada', 10, 7, 'Charles Leclerc', 1),
(2018, 'Canada', 11, 7, 'Pierre Gasly', 0),
(2018, 'Canada', 12, 7, 'Romain Grosjean', 0),
(2018, 'Canada', 13, 7, 'Kevin Magnussen', 0),
(2018, 'Canada', 14, 7, 'Sergio Pérez', 0),
(2018, 'Canada', 15, 7, 'Marcus Ericsson', 0),
(2018, 'Canada', 16, 7, 'Stoffel Vandoorne', 0),
(2018, 'Canada', 17, 7, 'Sergey Sirotkin', 0),
(2018, 'Canada', 18, 7, 'Fernando Alonso', 0),
(2018, 'Canada', 99, 7, 'Max Verstappen', 0),
(2018, 'France', 1, 8, 'Lewis Hamilton', 25),
(2018, 'France', 2, 8, 'Max Verstappen', 18),
(2018, 'France', 3, 8, 'Kimi Räikkönen', 15),
(2018, 'France', 4, 8, 'Daniel Ricciardo', 12),
(2018, 'France', 5, 8, 'Sebastian Vettel', 10),
(2018, 'France', 6, 8, 'Kevin Magnussen', 8),
(2018, 'France', 7, 8, 'Valtteri Bottas', 6),
(2018, 'France', 8, 8, 'Carlos Sainz', 4),
(2018, 'France', 9, 8, 'Nico Hülkenberg', 2),
(2018, 'France', 10, 8, 'Charles Leclerc', 1),
(2018, 'France', 11, 8, 'Romain Grosjean', 0),
(2018, 'France', 12, 8, 'Stoffel Vandoorne', 0),
(2018, 'France', 13, 8, 'Marcus Ericsson', 0),
(2018, 'France', 14, 8, 'Brendon Hartley', 0),
(2018, 'France', 15, 8, 'Sergey Sirotkin', 0),
(2018, 'France', 16, 8, 'Fernando Alonso', 0),
(2018, 'France', 17, 8, 'Lance Stroll', 0),
(2018, 'France', 18, 8, 'Sergio Pérez', 0),
(2018, 'France', 99, 8, 'Valtteri Bottas', 0),
(2018, 'Austria', 1, 9, 'Max Verstappen', 25),
(2018, 'Austria', 2, 9, 'Kimi Räikkönen', 18),
(2018, 'Austria', 3, 9, 'Sebastian Vettel', 15),
(2018, 'Austria', 4, 9, 'Romain Grosjean', 12),
(2018, 'Austria', 5, 9, 'Kevin Magnussen', 10),
(2018, 'Austria', 6, 9, 'Esteban Ocon', 8),
(2018, 'Austria', 7, 9, 'Sergio Pérez', 6),
(2018, 'Austria', 8, 9, 'Fernando Alonso', 4),
(2018, 'Austria', 9, 9, 'Charles Leclerc', 2),
(2018, 'Austria', 10, 9, 'Marcus Ericsson', 1),
(2018, 'Austria', 11, 9, 'Pierre Gasly', 0),
(2018, 'Austria', 12, 9, 'Carlos Sainz', 0),
(2018, 'Austria', 13, 9, 'Sergey Sirotkin', 0),
(2018, 'Austria', 14, 9, 'Lance Stroll', 0),
(2018, 'Austria', 15, 9, 'Stoffel Vandoorne', 0),
(2018, 'Austria', 16, 9, 'Lewis Hamilton', 0),
(2018, 'Austria', 17, 9, 'Brendon Hartley', 0),
(2018, 'Austria', 18, 9, 'Daniel Ricciardo', 0),
(2018, 'Austria', 19, 9, 'Valtteri Bottas', 0),
(2018, 'Austria', 20, 9, 'Nico Hülkenberg', 0),
(2018, 'Austria', 99, 9, 'Kimi Räikkönen', 0),
(2018, 'UK', 1, 10, 'Sebastian Vettel', 25),
(2018, 'UK', 2, 10, 'Lewis Hamilton', 18),
(2018, 'UK', 3, 10, 'Kimi Räikkönen', 15),
(2018, 'UK', 4, 10, 'Valtteri Bottas', 12),
(2018, 'UK', 5, 10, 'Daniel Ricciardo', 10),
(2018, 'UK', 6, 10, 'Nico Hülkenberg', 8),
(2018, 'UK', 7, 10, 'Esteban Ocon', 6),
(2018, 'UK', 8, 10, 'Fernando Alonso', 4),
(2018, 'UK', 9, 10, 'Kevin Magnussen', 2),
(2018, 'UK', 10, 10, 'Sergio Pérez', 1),
(2018, 'UK', 11, 10, 'Stoffel Vandoorne', 0),
(2018, 'UK', 12, 10, 'Lance Stroll', 0),
(2018, 'UK', 13, 10, 'Pierre Gasly', 0),
(2018, 'UK', 14, 10, 'Sergey Sirotkin', 0),
(2018, 'UK', 15, 10, 'Max Verstappen', 0),
(2018, 'UK', 16, 10, 'Romain Grosjean', 0),
(2018, 'UK', 17, 10, 'Carlos Sainz', 0),
(2018, 'UK', 18, 10, 'Marcus Ericsson', 0),
(2018, 'UK', 19, 10, 'Charles Leclerc', 0),
(2018, 'UK', 99, 10, 'Sebastian Vettel', 0),
(2018, 'Germany', 1, 11, 'Lewis Hamilton', 25),
(2018, 'Germany', 2, 11, 'Valtteri Bottas', 18),
(2018, 'Germany', 3, 11, 'Kimi Räikkönen', 15),
(2018, 'Germany', 4, 11, 'Max Verstappen', 12),
(2018, 'Germany', 5, 11, 'Nico Hülkenberg', 10),
(2018, 'Germany', 6, 11, 'Romain Grosjean', 8),
(2018, 'Germany', 7, 11, 'Sergio Pérez', 6),
(2018, 'Germany', 8, 11, 'Esteban Ocon', 4),
(2018, 'Germany', 9, 11, 'Marcus Ericsson', 2),
(2018, 'Germany', 10, 11, 'Brendon Hartley', 1),
(2018, 'Germany', 11, 11, 'Kevin Magnussen', 0),
(2018, 'Germany', 12, 11, 'Carlos Sainz', 0),
(2018, 'Germany', 13, 11, 'Stoffel Vandoorne', 0),
(2018, 'Germany', 14, 11, 'Pierre Gasly', 0),
(2018, 'Germany', 15, 11, 'Charles Leclerc', 0),
(2018, 'Germany', 16, 11, 'Fernando Alonso', 0),
(2018, 'Germany', 17, 11, 'Lance Stroll', 0),
(2018, 'Germany', 18, 11, 'Sebastian Vettel', 0),
(2018, 'Germany', 19, 11, 'Sergey Sirotkin', 0),
(2018, 'Germany', 20, 11, 'Daniel Ricciardo', 0),
(2018, 'Germany', 99, 11, 'Lewis Hamilton', 0),
(2018, 'Hungary', 1, 12, 'Lewis Hamilton', 25),
(2018, 'Hungary', 2, 12, 'Sebastian Vettel', 18),
(2018, 'Hungary', 3, 12, 'Kimi Räikkönen', 15),
(2018, 'Hungary', 4, 12, 'Daniel Ricciardo', 12),
(2018, 'Hungary', 5, 12, 'Valtteri Bottas', 10),
(2018, 'Hungary', 6, 12, 'Pierre Gasly', 8),
(2018, 'Hungary', 7, 12, 'Kevin Magnussen', 6),
(2018, 'Hungary', 8, 12, 'Fernando Alonso', 4),
(2018, 'Hungary', 9, 12, 'Carlos Sainz', 2),
(2018, 'Hungary', 10, 12, 'Romain Grosjean', 1),
(2018, 'Hungary', 11, 12, 'Brendon Hartley', 0),
(2018, 'Hungary', 12, 12, 'Nico Hülkenberg', 0),
(2018, 'Hungary', 13, 12, 'Esteban Ocon', 0),
(2018, 'Hungary', 14, 12, 'Sergio Pérez', 0),
(2018, 'Hungary', 15, 12, 'Marcus Ericsson', 0),
(2018, 'Hungary', 16, 12, 'Sergey Sirotkin', 0),
(2018, 'Hungary', 17, 12, 'Lance Stroll', 0),
(2018, 'Hungary', 18, 12, 'Stoffel Vandoorne', 0),
(2018, 'Hungary', 19, 12, 'Max Verstappen', 0),
(2018, 'Hungary', 99, 12, 'Daniel Ricciardo', 0),
(2018, 'Belgium', 1, 13, 'Sebastian Vettel', 25),
(2018, 'Belgium', 2, 13, 'Lewis Hamilton', 18),
(2018, 'Belgium', 3, 13, 'Max Verstappen', 15),
(2018, 'Belgium', 4, 13, 'Valtteri Bottas', 12),
(2018, 'Belgium', 5, 13, 'Sergio Pérez', 10),
(2018, 'Belgium', 6, 13, 'Esteban Ocon', 8),
(2018, 'Belgium', 7, 13, 'Romain Grosjean', 6),
(2018, 'Belgium', 8, 13, 'Kevin Magnussen', 4),
(2018, 'Belgium', 9, 13, 'Pierre Gasly', 2),
(2018, 'Belgium', 10, 13, 'Marcus Ericsson', 1),
(2018, 'Belgium', 11, 13, 'Carlos Sainz', 0),
(2018, 'Belgium', 12, 13, 'Sergey Sirotkin', 0),
(2018, 'Belgium', 13, 13, 'Lance Stroll', 0),
(2018, 'Belgium', 14, 13, 'Brendon Hartley', 0),
(2018, 'Belgium', 15, 13, 'Stoffel Vandoorne', 0),
(2018, 'Belgium', 16, 13, 'Daniel Ricciardo', 0),
(2018, 'Belgium', 17, 13, 'Kimi Räikkönen', 0),
(2018, 'Belgium', 99, 13, 'Valtteri Bottas', 0),
(2018, 'Italy', 1, 14, 'Lewis Hamilton', 25),
(2018, 'Italy', 2, 14, 'Kimi Räikkönen', 18),
(2018, 'Italy', 3, 14, 'Valtteri Bottas', 15),
(2018, 'Italy', 4, 14, 'Sebastian Vettel', 12),
(2018, 'Italy', 5, 14, 'Max Verstappen', 10),
(2018, 'Italy', 6, 14, 'Romain Grosjean', 8),
(2018, 'Italy', 7, 14, 'Esteban Ocon', 6),
(2018, 'Italy', 8, 14, 'Sergio Pérez', 4),
(2018, 'Italy', 9, 14, 'Carlos Sainz', 2),
(2018, 'Italy', 10, 14, 'Lance Stroll', 1),
(2018, 'Italy', 11, 14, 'Sergey Sirotkin', 0),
(2018, 'Italy', 12, 14, 'Charles Leclerc', 0),
(2018, 'Italy', 13, 14, 'Stoffel Vandoorne', 0),
(2018, 'Italy', 14, 14, 'Nico Hülkenberg', 0),
(2018, 'Italy', 15, 14, 'Pierre Gasly', 0),
(2018, 'Italy', 16, 14, 'Marcus Ericsson', 0),
(2018, 'Italy', 17, 14, 'Kevin Magnussen', 0),
(2018, 'Italy', 18, 14, 'Daniel Ricciardo', 0),
(2018, 'Italy', 19, 14, 'Fernando Alonso', 0),
(2018, 'Italy', 99, 14, 'Lewis Hamilton', 0),
(2018, 'Singapore', 1, 15, 'Lewis Hamilton', 25),
(2018, 'Singapore', 2, 15, 'Max Verstappen', 18),
(2018, 'Singapore', 3, 15, 'Sebastian Vettel', 15),
(2018, 'Singapore', 4, 15, 'Valtteri Bottas', 12),
(2018, 'Singapore', 5, 15, 'Kimi Räikkönen', 10),
(2018, 'Singapore', 6, 15, 'Daniel Ricciardo', 8),
(2018, 'Singapore', 7, 15, 'Fernando Alonso', 6),
(2018, 'Singapore', 8, 15, 'Carlos Sainz', 4),
(2018, 'Singapore', 9, 15, 'Charles Leclerc', 2),
(2018, 'Singapore', 10, 15, 'Nico Hülkenberg', 1),
(2018, 'Singapore', 11, 15, 'Marcus Ericsson', 0),
(2018, 'Singapore', 12, 15, 'Stoffel Vandoorne', 0),
(2018, 'Singapore', 13, 15, 'Pierre Gasly', 0),
(2018, 'Singapore', 14, 15, 'Lance Stroll', 0),
(2018, 'Singapore', 15, 15, 'Romain Grosjean', 0),
(2018, 'Singapore', 16, 15, 'Sergio Pérez', 0),
(2018, 'Singapore', 17, 15, 'Brendon Hartley', 0),
(2018, 'Singapore', 18, 15, 'Kevin Magnussen', 0),
(2018, 'Singapore', 19, 15, 'Sergey Sirotkin', 0),
(2018, 'Singapore', 99, 15, 'Kevin Magnussen', 0),
(2018, 'Brazil', 1, 20, 'Lewis Hamilton', 25),
(2018, 'Brazil', 2, 20, 'Max Verstappen', 18),
(2018, 'Brazil', 3, 20, 'Kimi Räikkönen', 15),
(2018, 'Brazil', 4, 20, 'Daniel Ricciardo', 12),
(2018, 'Brazil', 5, 20, 'Valtteri Bottas', 10),
(2018, 'Brazil', 6, 20, 'Sebastian Vettel', 8),
(2018, 'Brazil', 7, 20, 'Charles Leclerc', 6),
(2018, 'Brazil', 8, 20, 'Romain Grosjean', 4),
(2018, 'Brazil', 9, 20, 'Kevin Magnussen', 2),
(2018, 'Brazil', 10, 20, 'Sergio Pérez', 1),
(2018, 'Brazil', 11, 20, 'Brendon Hartley', 0),
(2018, 'Brazil', 12, 20, 'Carlos Sainz', 0),
(2018, 'Brazil', 13, 20, 'Pierre Gasly', 0),
(2018, 'Brazil', 14, 20, 'Stoffel Vandoorne', 0),
(2018, 'Brazil', 15, 20, 'Esteban Ocon', 0),
(2018, 'Brazil', 16, 20, 'Sergey Sirotkin', 0),
(2018, 'Brazil', 17, 20, 'Fernando Alonso', 0),
(2018, 'Brazil', 18, 20, 'Lance Stroll', 0),
(2018, 'Brazil', 19, 20, 'Nico Hülkenberg', 0),
(2018, 'Brazil', 20, 20, 'Marcus Ericsson', 0),
(2018, 'Brazil', 99, 20, 'Valtteri Bottas', 0);

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

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

CREATE TABLE `teams` (
  `Name` varchar(50) NOT NULL,
  `Picture` blob,
  `info` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`Name`, `Picture`, `info`) VALUES
('Ferrari', 0x[encoded data, 11114 characters], 'en.wikipedia.org/wiki/Scuderia_Ferrari'),
('Force-India', 0x[encoded data, 18184 characters], 'en.wikipedia.org/wiki/Force_India'),
('Haas', 0x[encoded data, 10294 characters], 'en.wikipedia.org/wiki/Haas_F1_Team');
INSERT INTO `teams` (`Name`, `Picture`, `info`) VALUES
('McLaren', 0x[encoded data, 19068 characters], 'en.wikipedia.org/wiki/McLaren'),
('Red-Bull', 0x[encoded data, 12186 characters], 'en.wikipedia.org/wiki/Red_Bull_Racing'),
('Renault', 0x[encoded data, 10706 characters], 'en.wikipedia.org/wiki/Renault_in_Formula_One');
INSERT INTO `teams` (`Name`, `Picture`, `info`) VALUES
('Sauber', 0x[encoded data, 15894 characters], 'en.wikipedia.org/wiki/Sauber'),
('Toro-Rosso', 0x[encoded data, 12868 characters], 'en.wikipedia.org/wiki/Scuderia_Toro_Rosso');
INSERT INTO `teams` (`Name`, `Picture`, `info`) VALUES
('Williams', 0x[encoded data, 49132 characters], 'en.wikipedia.org/wiki/Williams_Grand_Prix_Engineering');
INSERT INTO `teams` (`Name`, `Picture`, `info`) VALUES
('Mercedes', 0x[encoded data, 11016 characters], 'en.wikipedia.org/wiki/Mercedes-Benz_in_Formula_One');

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

--
-- Table structure for table `userextrapoints`
--

CREATE TABLE `userextrapoints` (
  `UserName` varchar(50) NOT NULL,
  `ExtraPointsName` varchar(500) NOT NULL,
  `value` int(11) NOT NULL DEFAULT '0',
  `Season` int(11) NOT NULL,
  `Round` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userextrapoints`
--

INSERT INTO `userextrapoints` (`UserName`, `ExtraPointsName`, `value`, `Season`, `Round`) VALUES
('jems', 'Was Present', 1, 2018, 7),
('jems', 'Wore Shirt', 1, 2018, 7),
('moose', 'Was Present', 1, 2018, 7),
('moose', 'Wore Shirt', 1, 2018, 7),
('moose', 'Was Present', 1, 2018, 8),
('moose', 'Wore Shirt', 1, 2018, 8),
('moose', 'Was Present', 1, 2018, 9),
('moose', 'Wore Shirt', 1, 2018, 9),
('moose', 'Was Present', 1, 2018, 15),
('moose', 'Wore Shirt', 1, 2018, 15);

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

--
-- Table structure for table `userselection`
--

CREATE TABLE `userselection` (
  `Season` int(11) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `DateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Round` int(11) NOT NULL,
  `1stPlace` varchar(100) NOT NULL,
  `2ndPlace` varchar(100) NOT NULL,
  `3rdPlace` varchar(100) NOT NULL,
  `FatestLap` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userselection`
--

INSERT INTO `userselection` (`Season`, `UserName`, `DateTime`, `Round`, `1stPlace`, `2ndPlace`, `3rdPlace`, `FatestLap`) VALUES
(2018, 'moose', '2018-05-27 21:25:03', 6, '---------', '---------', '---------', '---------'),
(2018, 'moose', '2018-06-10 21:38:56', 7, 'Sebastian Vettel', 'Max Verstappen', 'Lewis Hamilton', 'Sebastian Vettel'),
(2018, 'moose', '2018-06-24 16:41:11', 8, 'Lewis Hamilton', 'Sebastian Vettel', 'Valtteri Bottas', 'Max Verstappen'),
(2018, 'moose', '2018-07-01 15:35:02', 9, 'Lewis Hamilton', 'Max Verstappen', 'Sebastian Vettel', 'Max Verstappen'),
(2018, 'moose', '2018-07-08 15:11:29', 10, 'Lewis Hamilton', 'Sebastian Vettel', 'Max Verstappen', 'Max Verstappen'),
(2018, 'moose', '2018-09-16 15:32:59', 15, 'Lewis Hamilton', 'Sebastian Vettel', 'Max Verstappen', 'Max Verstappen'),
(2018, 'moose', '2018-10-07 07:00:33', 17, 'Valtteri Bottas', 'Lewis Hamilton', 'Max Verstappen', 'Max Verstappen'),
(2018, 'moose', '2018-11-25 15:06:31', 21, 'Valtteri Bottas', 'Lewis Hamilton', 'Max Verstappen', 'Max Verstappen');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `drivers`
--
ALTER TABLE `drivers`
  ADD UNIQUE KEY `Name` (`Name`);

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

--
-- Indexes for table `results`
--
ALTER TABLE `results`
  ADD PRIMARY KEY (`Season`,`Round`,`Position`) USING BTREE;

--
-- Indexes for table `userselection`
--
ALTER TABLE `userselection`
  ADD PRIMARY KEY (`Season`,`Round`,`UserName`) USING BTREE;

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

