SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 */;

--
-- Adatbázis: `f1_2024`
--
CREATE DATABASE IF NOT EXISTS `f1_2024` DEFAULT CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
USE `f1_2024`;

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

--
-- Tábla szerkezet ehhez a táblához `csapat`
--

CREATE TABLE `csapat` (
  `csapatid` int(10) NOT NULL,
  `csapatnev` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `csapat`
--

INSERT INTO `csapat` (`csapatid`, `csapatnev`) VALUES
(1, 'Red Bull Racing Honda RBPT'),
(2, 'Ferrari'),
(3, 'Mercedes'),
(4, 'McLaren Mercedes'),
(5, 'Aston Martin Aramco Mercedes'),
(6, 'Kick Sauber Ferrari'),
(7, 'Haas Ferrari'),
(8, 'RB Honda RBPT'),
(9, 'Williams Mercedes'),
(10, 'Alpine Renault');

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

--
-- Tábla szerkezet ehhez a táblához `eredmeny`
--

CREATE TABLE `eredmeny` (
  `futamid` int(10) NOT NULL,
  `versenyzoid` int(10) NOT NULL,
  `helyezes` int(10) DEFAULT NULL,
  `korok` int(10) NOT NULL,
  `nemminositett` varchar(30) NOT NULL,
  `pont` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `eredmeny`
--

INSERT INTO `eredmeny` (`futamid`, `versenyzoid`, `helyezes`, `korok`, `nemminositett`, `pont`) VALUES
(1, 1, 1, 57, '', 26),
(1, 2, 2, 57, '', 18),
(1, 3, 3, 57, '', 15),
(1, 4, 4, 57, '', 12),
(1, 5, 5, 57, '', 10),
(1, 6, 6, 57, '', 8),
(1, 7, 7, 57, '', 6),
(1, 8, 8, 57, '', 4),
(1, 9, 9, 57, '', 2),
(1, 10, 10, 57, '', 1),
(1, 11, 11, 56, '', 0),
(1, 12, 12, 56, '', 0),
(1, 13, 13, 56, '', 0),
(1, 14, 14, 56, '', 0),
(1, 15, 15, 56, '', 0),
(1, 16, 16, 56, '', 0),
(1, 17, 17, 56, '', 0),
(1, 18, 18, 56, '', 0),
(1, 19, 19, 56, '', 0),
(1, 20, 20, 55, '', 0),
(2, 1, 1, 50, '', 25),
(2, 2, 2, 50, '', 18),
(2, 4, 3, 50, '', 16),
(2, 8, 4, 50, '', 12),
(2, 9, 5, 50, '', 10),
(2, 5, 6, 50, '', 8),
(2, 21, 7, 50, '', 6),
(2, 6, 8, 50, '', 4),
(2, 7, 9, 50, '', 2),
(2, 16, 10, 50, '', 1),
(2, 15, 11, 50, '', 0),
(2, 12, 12, 50, '', 0),
(2, 17, 13, 49, '', 0),
(2, 20, 14, 49, '', 0),
(2, 14, 15, 49, '', 0),
(2, 13, 16, 49, '', 0),
(2, 19, 17, 49, '', 0),
(2, 11, 18, 49, '', 0),
(2, 10, NULL, 5, 'kiesett', 0),
(2, 18, NULL, 1, 'kiesett', 0),
(3, 3, 1, 58, '', 25),
(3, 4, 2, 58, '', 19),
(3, 6, 3, 58, '', 15),
(3, 8, 4, 58, '', 12),
(3, 2, 5, 58, '', 10),
(3, 10, 6, 58, '', 8),
(3, 14, 7, 58, '', 6),
(3, 9, 8, 58, '', 4),
(3, 16, 9, 58, '', 2),
(3, 12, 10, 57, '', 1),
(3, 15, 11, 57, '', 0),
(3, 13, 12, 57, '', 0),
(3, 18, 13, 57, '', 0),
(3, 19, 14, 57, '', 0),
(3, 11, 15, 57, '', 0),
(3, 17, 16, 57, '', 0),
(3, 5, 17, 56, 'kiesett', 0),
(3, 7, NULL, 15, 'kiesett', 0),
(3, 1, NULL, 3, 'kiesett', 0),
(4, 1, 1, 53, '', 26),
(4, 2, 2, 53, '', 18),
(4, 3, 3, 53, '', 15),
(4, 4, 4, 53, '', 12),
(4, 6, 5, 53, '', 10),
(4, 9, 6, 53, '', 8),
(4, 5, 7, 53, '', 6),
(4, 8, 8, 53, '', 4),
(4, 7, 9, 53, '', 2),
(4, 14, 10, 52, '', 1),
(4, 16, 11, 52, '', 0),
(4, 10, 12, 52, '', 0),
(4, 12, 13, 52, '', 0),
(4, 19, 14, 52, '', 0),
(4, 17, 15, 52, '', 0),
(4, 18, 16, 52, '', 0),
(4, 20, 17, 52, '', 0),
(4, 11, NULL, 12, 'kiesett', 0),
(4, 13, NULL, 0, 'kiesett', 0),
(4, 15, NULL, 0, 'kiesett', 0),
(5, 1, 1, 56, '', 25),
(5, 6, 2, 56, '', 18),
(5, 2, 3, 56, '', 15),
(5, 4, 4, 56, '', 12),
(5, 3, 5, 56, '', 10),
(5, 5, 6, 56, '', 8),
(5, 9, 7, 56, '', 7),
(5, 8, 8, 56, '', 4),
(5, 7, 9, 56, '', 2),
(5, 16, 10, 56, '', 1),
(5, 17, 11, 56, '', 0),
(5, 15, 12, 56, '', 0),
(5, 18, 13, 56, '', 0),
(5, 11, 14, 56, '', 0),
(5, 10, 15, 56, '', 0),
(5, 12, 16, 56, '', 0),
(5, 20, 17, 56, '', 0),
(5, 13, NULL, 33, 'kiesett', 0),
(5, 14, NULL, 26, 'kiesett', 0),
(5, 19, NULL, 19, 'kiesett', 0),
(6, 6, 1, 57, '', 25),
(6, 1, 2, 57, '', 18),
(6, 4, 3, 57, '', 15),
(6, 2, 4, 57, '', 12),
(6, 3, 5, 57, '', 10),
(6, 7, 6, 57, '', 8),
(6, 14, 7, 57, '', 6),
(6, 5, 8, 57, '', 4),
(6, 9, 9, 57, '', 2),
(6, 17, 10, 57, '', 1),
(6, 16, 11, 57, '', 0),
(6, 18, 12, 57, '', 0),
(6, 8, 13, 57, '', 0),
(6, 11, 14, 57, '', 0),
(6, 13, 15, 57, '', 0),
(6, 19, 16, 57, '', 0),
(6, 10, 17, 57, '', 0),
(6, 15, 18, 57, '', 0),
(6, 12, 19, 57, '', 0),
(6, 20, NULL, 27, 'kiesett', 0),
(7, 1, 1, 63, '', 25),
(7, 6, 2, 63, '', 18),
(7, 4, 3, 63, '', 15),
(7, 8, 4, 63, '', 12),
(7, 3, 5, 63, '', 10),
(7, 7, 6, 63, '', 8),
(7, 5, 7, 63, '', 7),
(7, 2, 8, 63, '', 4),
(7, 10, 9, 63, '', 2),
(7, 14, 10, 62, '', 1),
(7, 16, 11, 62, '', 0),
(7, 12, 12, 62, '', 0),
(7, 13, 13, 62, '', 0),
(7, 17, 14, 62, '', 0),
(7, 11, 15, 62, '', 0),
(7, 18, 16, 62, '', 0),
(7, 20, 17, 62, '', 0),
(7, 19, 18, 62, '', 0),
(7, 9, 19, 62, '', 0),
(7, 15, NULL, 51, 'kiesett', 0),
(8, 4, 1, 78, '', 25),
(8, 8, 2, 78, '', 18),
(8, 3, 3, 78, '', 15),
(8, 6, 4, 78, '', 12),
(8, 5, 5, 78, '', 10),
(8, 1, 6, 78, '', 8),
(8, 7, 7, 78, '', 7),
(8, 14, 8, 77, '', 4),
(8, 15, 9, 77, '', 2),
(8, 18, 10, 77, '', 1),
(8, 9, 11, 76, '', 0),
(8, 13, 12, 76, '', 0),
(8, 19, 13, 76, '', 0),
(8, 10, 14, 76, '', 0),
(8, 20, 15, 76, '', 0),
(8, 11, 16, 76, '', 0),
(8, 17, NULL, 0, 'kiesett', 0),
(8, 2, NULL, 0, 'kiesett', 0),
(8, 16, NULL, 0, 'kiesett', 0),
(8, 12, NULL, 0, 'kiesett', 0),
(9, 1, 1, 70, '', 25),
(9, 6, 2, 70, '', 18),
(9, 5, 3, 70, '', 15),
(9, 7, 4, 70, '', 13),
(9, 8, 5, 70, '', 10),
(9, 9, 6, 70, '', 8),
(9, 10, 7, 70, '', 6),
(9, 13, 8, 70, '', 4),
(9, 18, 9, 70, '', 2),
(9, 17, 10, 70, '', 1),
(9, 16, 11, 70, '', 0),
(9, 12, 12, 70, '', 0),
(9, 19, 13, 70, '', 0),
(9, 14, 14, 70, '', 0),
(9, 11, 15, 69, '', 0),
(9, 3, NULL, 52, 'kiesett', 0),
(9, 15, NULL, 52, 'kiesett', 0),
(9, 2, NULL, 51, 'kiesett', 0),
(9, 4, NULL, 40, 'kiesett', 0),
(9, 20, NULL, 23, 'kiesett', 0),
(10, 1, 1, 66, '', 25),
(10, 6, 2, 66, '', 19),
(10, 7, 3, 66, '', 15),
(10, 5, 4, 66, '', 12),
(10, 4, 5, 66, '', 10),
(10, 3, 6, 66, '', 8),
(10, 8, 7, 66, '', 6),
(10, 2, 8, 66, '', 4),
(10, 18, 9, 66, '', 2),
(10, 17, 10, 66, '', 1),
(10, 16, 11, 66, '', 0),
(10, 9, 12, 65, '', 0),
(10, 11, 13, 65, '', 0),
(10, 10, 14, 65, '', 0),
(10, 13, 15, 65, '', 0),
(10, 19, 16, 65, '', 0),
(10, 12, 17, 65, '', 0),
(10, 15, 18, 65, '', 0),
(10, 14, 19, 65, '', 0),
(10, 20, 20, 64, '', 0),
(11, 5, 1, 71, '', 25),
(11, 8, 2, 71, '', 18),
(11, 3, 3, 71, '', 15),
(11, 7, 4, 71, '', 12),
(11, 1, 5, 71, '', 10),
(11, 16, 6, 71, '', 8),
(11, 2, 7, 71, '', 6),
(11, 12, 8, 71, '', 4),
(11, 13, 9, 71, '', 2),
(11, 18, 10, 71, '', 1),
(11, 4, 11, 71, '', 0),
(11, 17, 12, 71, '', 0),
(11, 10, 13, 70, '', 0),
(11, 14, 14, 70, '', 0),
(11, 15, 15, 70, '', 0),
(11, 19, 16, 70, '', 0),
(11, 11, 17, 70, '', 0),
(11, 9, 18, 70, '', 0),
(11, 20, 19, 69, '', 0),
(11, 6, 20, 64, '', 0),
(12, 7, 1, 52, '', 25),
(12, 1, 2, 52, '', 18),
(12, 6, 3, 52, '', 15),
(12, 8, 4, 52, '', 12),
(12, 3, 5, 52, '', 11),
(12, 16, 6, 52, '', 8),
(12, 10, 7, 52, '', 6),
(12, 9, 8, 52, '', 4),
(12, 15, 9, 52, '', 2),
(12, 14, 10, 52, '', 1),
(12, 20, 11, 52, '', 0),
(12, 12, 12, 52, '', 0),
(12, 13, 13, 51, '', 0),
(12, 4, 14, 51, '', 0),
(12, 19, 15, 51, '', 0),
(12, 17, 16, 50, '', 0),
(12, 2, 17, 50, '', 0),
(12, 11, 18, 50, '', 0),
(12, 5, NULL, 33, '', 0),
(12, 18, NULL, 0, '', 0),
(13, 8, 1, 70, '', 25),
(13, 6, 2, 70, '', 18),
(13, 7, 3, 70, '', 15),
(13, 4, 4, 70, '', 12),
(13, 1, 5, 70, '', 10),
(13, 3, 6, 70, '', 8),
(13, 2, 7, 70, '', 6),
(13, 5, 8, 70, '', 5),
(13, 14, 9, 70, '', 2),
(13, 10, 10, 70, '', 1),
(13, 9, 11, 70, '', 0),
(13, 13, 12, 69, '', 0),
(13, 16, 13, 69, '', 0),
(13, 15, 14, 69, '', 0),
(13, 12, 15, 69, '', 0),
(13, 19, 16, 69, '', 0),
(13, 20, 17, 69, '', 0),
(13, 17, 18, 69, '', 0),
(13, 11, 19, 69, '', 0),
(13, 18, NULL, 33, 'kiesett', 0),
(14, 5, NULL, 44, 'kizárták', 0),
(14, 7, 1, 44, '', 25),
(14, 8, 2, 44, '', 18),
(14, 4, 3, 44, '', 15),
(14, 1, 4, 44, '', 12),
(14, 6, 5, 44, '', 10),
(14, 3, 6, 44, '', 8),
(14, 2, 7, 44, '', 7),
(14, 9, 8, 44, '', 4),
(14, 17, 9, 44, '', 2),
(14, 13, 10, 44, '', 1),
(14, 10, 11, 44, '', 0),
(14, 15, 12, 44, '', 0),
(14, 18, 13, 44, '', 0),
(14, 12, 14, 44, '', 0),
(14, 19, 15, 44, '', 0),
(14, 14, 16, 44, '', 0),
(14, 20, 17, 44, '', 0),
(14, 16, 18, 44, '', 0),
(14, 11, NULL, 5, 'kiesett', 0),
(15, 6, 1, 72, '', 26),
(15, 1, 2, 72, '', 18),
(15, 4, 3, 72, '', 15),
(15, 8, 4, 72, '', 12),
(15, 3, 5, 72, '', 10),
(15, 2, 6, 72, '', 8),
(15, 5, 7, 72, '', 6),
(15, 7, 8, 72, '', 4),
(15, 18, 9, 71, '', 2),
(15, 9, 10, 71, '', 1),
(15, 16, 11, 71, '', 0),
(15, 13, 12, 71, '', 0),
(15, 10, 13, 71, '', 0),
(15, 15, 14, 71, '', 0),
(15, 17, 15, 71, '', 0),
(15, 20, 16, 71, '', 0),
(15, 14, 17, 71, '', 0),
(15, 12, 18, 71, '', 0),
(15, 19, 19, 70, '', 0),
(15, 11, 20, 70, '', 0),
(16, 4, 1, 53, '', 25),
(16, 8, 2, 53, '', 18),
(16, 6, 3, 53, '', 16),
(16, 3, 4, 53, '', 12),
(16, 7, 5, 53, '', 10),
(16, 1, 6, 53, '', 8),
(16, 5, 7, 53, '', 6),
(16, 2, 8, 53, '', 4),
(16, 15, 9, 53, '', 2),
(16, 12, 10, 53, '', 1),
(16, 9, 11, 53, '', 0),
(16, 22, 12, 53, '', 0),
(16, 13, 13, 53, '', 0),
(16, 17, 14, 52, '', 0),
(16, 18, 15, 52, '', 0),
(16, 19, 16, 52, '', 0),
(16, 16, 17, 52, '', 0),
(16, 11, 18, 52, '', 0),
(16, 10, 19, 52, '', 0),
(16, 14, NULL, 7, 'kiesett', 0),
(17, 8, 1, 51, '', 25),
(17, 4, 2, 51, '', 18),
(17, 5, 3, 51, '', 15),
(17, 6, 4, 51, '', 13),
(17, 1, 5, 51, '', 10),
(17, 9, 6, 51, '', 8),
(17, 15, 7, 51, '', 6),
(17, 22, 8, 51, '', 4),
(17, 7, 9, 51, '', 2),
(17, 21, 10, 51, '', 1),
(17, 16, 11, 51, '', 0),
(17, 18, 12, 51, '', 0),
(17, 13, 13, 51, '', 0),
(17, 11, 14, 51, '', 0),
(17, 17, 15, 50, '', 0),
(17, 19, 16, 50, '', 0),
(17, 2, 17, 49, 'kiesett', 0),
(17, 3, 18, 49, 'kiesett', 0),
(17, 10, 19, 45, 'kiesett', 0),
(17, 14, NULL, 14, 'kiesett', 0),
(18, 6, 1, 62, '', 25),
(18, 1, 2, 62, '', 18),
(18, 8, 3, 62, '', 15),
(18, 5, 4, 62, '', 12),
(18, 4, 5, 62, '', 10),
(18, 7, 6, 62, '', 8),
(18, 3, 7, 62, '', 6),
(18, 9, 8, 61, '', 4),
(18, 16, 9, 61, '', 2),
(18, 2, 10, 61, '', 1),
(18, 22, 11, 61, '', 0),
(18, 14, 12, 61, '', 0),
(18, 17, 13, 61, '', 0),
(18, 10, 14, 61, '', 0),
(18, 11, 15, 61, '', 0),
(18, 19, 16, 61, '', 0),
(18, 18, 17, 61, '', 0),
(18, 13, 18, 61, '', 0),
(18, 12, 19, 57, 'kiesett', 0),
(18, 15, NULL, 15, 'kiesett', 0),
(19, 4, 1, 56, '', 25),
(19, 3, 2, 56, '', 18),
(19, 1, 3, 56, '', 15),
(19, 6, 4, 56, '', 12),
(19, 8, 5, 56, '', 10),
(19, 5, 6, 56, '', 8),
(19, 2, 7, 56, '', 6),
(19, 16, 8, 56, '', 4),
(19, 23, 9, 56, '', 2),
(19, 22, 10, 56, '', 1),
(19, 12, 11, 56, '', 0),
(19, 18, 12, 56, '', 0),
(19, 9, 13, 55, '', 0),
(19, 14, 14, 55, '', 0),
(19, 10, 15, 55, '', 0),
(19, 15, 16, 55, '', 0),
(19, 19, 17, 55, '', 0),
(19, 17, 18, 55, '', 0),
(19, 11, 19, 55, '', 0),
(19, 7, NULL, 1, 'kiesett', 0),
(20, 3, 1, 71, '', 25),
(20, 6, 2, 71, '', 18),
(20, 4, 3, 71, '', 16),
(20, 7, 4, 71, '', 12),
(20, 5, 5, 71, '', 10),
(20, 1, 6, 71, '', 8),
(20, 12, 7, 71, '', 6),
(20, 8, 8, 71, '', 4),
(20, 16, 9, 70, '', 2),
(20, 18, 10, 70, '', 1),
(20, 10, 11, 70, '', 0),
(20, 22, 12, 70, '', 0),
(20, 17, 13, 70, '', 0),
(20, 19, 14, 70, '', 0),
(20, 11, 15, 70, '', 0),
(20, 23, 16, 70, '', 0),
(20, 2, 17, 70, '', 0),
(20, 9, NULL, 15, 'kiesett', 0),
(20, 15, NULL, 0, 'kiesett', 0),
(20, 14, NULL, 0, 'kiesett', 0),
(21, 1, 1, 69, '', 26),
(21, 17, 2, 69, '', 18),
(21, 18, 3, 69, '', 15),
(21, 5, 4, 69, '', 12),
(21, 4, 5, 69, '', 10),
(21, 6, 6, 69, '', 8),
(21, 14, 7, 69, '', 6),
(21, 8, 8, 69, '', 4),
(21, 23, 9, 69, '', 2),
(21, 7, 10, 69, '', 1),
(21, 2, 11, 69, '', 0),
(21, 21, 12, 69, '', 0),
(21, 19, 13, 69, '', 0),
(21, 9, 14, 69, '', 0),
(21, 11, 15, 69, '', 0),
(21, 3, NULL, 38, 'kiesett', 0),
(21, 22, NULL, 30, 'kiesett', 0),
(21, 15, NULL, 0, 'nem rajtolt', 0),
(21, 10, NULL, 0, 'nem rajtolt', 0),
(21, 16, NULL, 0, 'kizárták', 0),
(22, 5, 1, 50, '', 25),
(22, 7, 2, 50, '', 18),
(22, 3, 3, 50, '', 15),
(22, 4, 4, 50, '', 12),
(22, 1, 5, 50, '', 10),
(22, 6, 6, 50, '', 9),
(22, 8, 7, 50, '', 6),
(22, 16, 8, 50, '', 4),
(22, 14, 9, 50, '', 2),
(22, 2, 10, 50, '', 1),
(22, 9, 11, 50, '', 0),
(22, 12, 12, 50, '', 0),
(22, 11, 13, 50, '', 0),
(22, 22, 14, 50, '', 0),
(22, 10, 15, 50, '', 0),
(22, 23, 16, 50, '', 0),
(22, 17, 17, 49, '', 0),
(22, 19, 18, 49, '', 0),
(22, 15, NULL, 25, 'kiesett', 0),
(22, 18, NULL, 15, 'kiesett', 0),
(23, 1, 1, 57, '', 25),
(23, 4, 2, 57, '', 18),
(23, 8, 3, 57, '', 15),
(23, 5, 4, 57, '', 12),
(23, 18, 5, 57, '', 10),
(23, 3, 6, 57, '', 8),
(23, 9, 7, 57, '', 6),
(23, 11, 8, 57, '', 4),
(23, 12, 9, 57, '', 2),
(23, 6, 10, 57, '', 2),
(23, 19, 11, 57, '', 0),
(23, 7, 12, 57, '', 0),
(23, 14, 13, 57, '', 0),
(23, 23, 14, 57, '', 0),
(23, 15, 15, 56, '', 0),
(23, 16, NULL, 39, 'kiesett', 0),
(23, 2, NULL, 38, 'kiesett', 0),
(23, 10, NULL, 8, 'kiesett', 0),
(23, 22, NULL, 0, 'kiesett', 0),
(23, 17, NULL, 0, 'kiesett', 0),
(24, 6, 1, 58, '', 25),
(24, 3, 2, 58, '', 18),
(24, 4, 3, 58, '', 15),
(24, 7, 4, 58, '', 12),
(24, 5, 5, 58, '', 10),
(24, 1, 6, 58, '', 8),
(24, 18, 7, 58, '', 6),
(24, 16, 8, 58, '', 4),
(24, 9, 9, 58, '', 2),
(24, 8, 10, 58, '', 1),
(24, 15, 11, 57, '', 0),
(24, 14, 12, 57, '', 0),
(24, 11, 13, 57, '', 0),
(24, 10, 14, 57, '', 0),
(24, 24, 15, 57, '', 0),
(24, 12, 16, 57, '', 0),
(24, 23, 17, 55, 'kiesett', 0),
(24, 19, NULL, 30, 'kiesett', 0),
(24, 22, NULL, 26, 'kiesett', 0),
(24, 2, NULL, 0, 'kiesett', 0);

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

--
-- Tábla szerkezet ehhez a táblához `futam`
--

CREATE TABLE `futam` (
  `futamid` int(10) NOT NULL,
  `futamnev` varchar(100) NOT NULL,
  `varos` varchar(30) NOT NULL,
  `futamnapja` date NOT NULL,
  `futamkor` int(10) NOT NULL,
  `palyahossz` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `futam`
--

INSERT INTO `futam` (`futamid`, `futamnev`, `varos`, `futamnapja`, `futamkor`, `palyahossz`) VALUES
(1, 'Bahreini nagydíj', 'Szahír', '2024-03-02', 57, 5408),
(2, 'Szaúd-Arábia-i nagydíj', 'Dzsidda', '2024-03-09', 50, 6169),
(3, 'Ausztrál nagydíj', 'Melbourne', '2024-03-24', 58, 5450),
(4, 'Japán nagydíj', 'Szuzuka', '2024-04-07', 53, 5801),
(5, 'Kínai nagydíj', 'Sanghaj', '2024-04-21', 56, 5448),
(6, 'Miami nagydíj', 'Miami', '2024-05-05', 57, 5409),
(7, 'Imola nagydíj', 'Imola', '2024-05-19', 63, 4891),
(8, 'Monacói nagydíj', 'Monaco', '2024-05-26', 78, 3337),
(9, 'Kanadai nagydíj', 'Montréal', '2024-06-09', 70, 4361),
(10, 'Spanyol nagydíj', 'Montmeló', '2024-06-23', 66, 4673),
(11, 'Osztrák nagydíj', 'Spielberg', '2024-06-30', 71, 4316),
(12, 'Brit nagydíj', 'Silverstone', '2024-07-07', 52, 5888),
(13, 'Magyar nagydíj', 'Mogyoród', '2024-07-21', 70, 4380),
(14, 'Belga nagydíj', 'Stavelot', '2024-07-28', 44, 7001),
(15, 'Holland nagydíj', 'Zandvoort', '2024-08-25', 72, 4258),
(16, 'Olasz nagydíj', 'Monza', '2024-09-01', 53, 5787),
(17, 'Azerbajdzsáni nagydíj', 'Baku', '2024-09-15', 51, 6001),
(18, 'Szingapúri nagydíj', 'Szingapúr', '2024-09-22', 62, 4979),
(19, 'Amerikai nagydíj', 'Austin', '2024-10-20', 56, 5507),
(20, 'Mexikói nagydíj', 'Mexikóváros', '2024-10-27', 71, 4301),
(21, 'Brazil nagydíj', 'São Paulo', '2024-11-03', 69, 4433),
(22, 'Las vegasi nagydíj', 'Las Vegas', '2024-11-23', 50, 6118),
(23, 'Katari nagydíj', 'Loszaíl', '2024-12-01', 57, 5380),
(24, 'Abu dhabi nagydíj', 'Abu-Dzabi', '2024-12-06', 58, 5279);

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

--
-- Tábla szerkezet ehhez a táblához `futamido`
--

CREATE TABLE `futamido` (
  `futamid` int(10) NOT NULL,
  `ido` double(10,3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `futamido`
--

INSERT INTO `futamido` (`futamid`, `ido`) VALUES
(1, 5505.000),
(2, 4843.273),
(3, 4826.843),
(4, 6863.566),
(5, 6052.554),
(6, 5449.876),
(7, 5125.252),
(8, 8595.554),
(9, 6347.927),
(10, 5300.227),
(11, 5062.798),
(12, 4947.059),
(13, 5881.989),
(14, 4797.040),
(15, 5445.519),
(16, 4480.727),
(17, 5578.007),
(18, 6052.571),
(19, 5709.639),
(20, 6055.800),
(21, 7614.430),
(22, 4925.969),
(23, 5465.323),
(24, 5193.291);

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

--
-- Tábla szerkezet ehhez a táblához `leggyorsabbkor`
--

CREATE TABLE `leggyorsabbkor` (
  `futamid` int(11) NOT NULL,
  `versenyzoid` int(11) NOT NULL,
  `ido` double(10,4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `leggyorsabbkor`
--

INSERT INTO `leggyorsabbkor` (`futamid`, `versenyzoid`, `ido`) VALUES
(1, 1, 92.1000),
(1, 2, 94.0600),
(1, 3, 94.0827),
(1, 4, 94.0130),
(1, 5, 95.0105),
(1, 6, 94.0756),
(1, 7, 94.1202),
(1, 8, 94.1623),
(1, 9, 94.0319),
(1, 10, 95.1032),
(1, 11, 95.0738),
(1, 12, 95.0930),
(1, 13, 95.0243),
(1, 14, 95.1353),
(1, 15, 95.1203),
(1, 16, 94.1354),
(1, 17, 96.0346),
(1, 18, 94.1325),
(1, 19, 96.0322),
(1, 20, 94.1215),
(2, 1, 91.1253),
(2, 2, 92.0433),
(2, 4, 91.1032),
(2, 8, 92.0510),
(2, 9, 92.0627),
(2, 5, 92.0414),
(2, 21, 92.0306),
(2, 6, 91.1544),
(2, 7, 91.1226),
(2, 16, 92.0606),
(2, 15, 92.0507),
(2, 12, 92.0538),
(2, 17, 93.0801),
(2, 20, 93.0026),
(2, 14, 93.0843),
(2, 13, 93.0523),
(2, 19, 92.1146),
(2, 11, 92.0328),
(2, 10, 95.0920),
(2, 18, NULL),
(3, 3, 80.0031),
(3, 4, 79.1333),
(3, 6, 79.1515),
(3, 8, 80.0319),
(3, 2, 80.0628),
(3, 10, 80.1530),
(3, 14, 81.0214),
(3, 9, 80.0813),
(3, 16, 81.0225),
(3, 12, 81.0122),
(3, 15, 81.1018),
(3, 13, 81.0359),
(3, 18, 81.0130),
(3, 19, 81.0702),
(3, 11, 81.0527),
(3, 17, 81.0554),
(3, 5, 80.0444),
(3, 7, 82.0724),
(3, 1, 83.0155),
(4, 1, 93.1146),
(4, 2, 93.1545),
(4, 3, 93.1401),
(4, 4, 95.0044),
(4, 6, 95.0306),
(4, 9, 94.1206),
(4, 5, 94.0644),
(4, 8, 94.1322),
(4, 7, 93.1552),
(4, 14, 96.0542),
(4, 16, 95.0525),
(4, 10, 95.1318),
(4, 12, 96.1054),
(4, 19, 96.1008),
(4, 17, 96.0352),
(4, 18, 96.1042),
(4, 20, 94.1500),
(4, 11, 97.0240),
(4, 13, NULL),
(4, 15, NULL),
(5, 1, 98.0646),
(5, 6, 98.1231),
(5, 2, 99.0628),
(5, 4, 99.0624),
(5, 3, 99.1244),
(5, 5, 100.0152),
(5, 9, 97.1330),
(5, 8, 99.1219),
(5, 7, 100.1355),
(5, 16, 100.1335),
(5, 17, 100.1537),
(5, 15, 100.1310),
(5, 18, 99.0318),
(5, 11, 98.1033),
(5, 10, 99.0724),
(5, 12, 101.0117),
(5, 20, 101.0000),
(5, 13, 100.1634),
(5, 14, 101.0953),
(5, 19, 101.0436),
(6, 6, 90.1620),
(6, 1, 91.0421),
(6, 4, 91.0124),
(6, 2, 90.1415),
(6, 3, 90.1528),
(6, 7, 91.0353),
(6, 14, 91.1122),
(6, 5, 91.1521),
(6, 9, 91.1207),
(6, 17, 92.0037),
(6, 16, 91.1541),
(6, 18, 92.0055),
(6, 8, 90.1034),
(6, 11, 91.1631),
(6, 13, 92.0202),
(6, 19, 92.0138),
(6, 10, 91.0948),
(6, 15, 90.1409),
(6, 12, 91.1254),
(6, 20, 93.0732),
(7, 1, 80.0606),
(7, 6, 79.1634),
(7, 4, 79.1535),
(7, 8, 79.1507),
(7, 3, 80.0340),
(7, 7, 80.0531),
(7, 5, 78.0949),
(7, 2, 79.1126),
(7, 10, 80.0930),
(7, 14, 80.1536),
(7, 16, 81.1140),
(7, 12, 81.0009),
(7, 13, 81.0929),
(7, 17, 81.0504),
(7, 11, 81.0016),
(7, 18, 81.0611),
(7, 20, 81.0349),
(7, 19, 81.0735),
(7, 9, 79.0004),
(7, 15, 81.0434),
(8, 4, 75.0242),
(8, 8, 76.0441),
(8, 3, 74.1206),
(8, 6, 75.1222),
(8, 5, 75.0348),
(8, 1, 74.0929),
(8, 7, 74.0245),
(8, 14, 74.1200),
(8, 15, 77.0100),
(8, 18, 75.1025),
(8, 9, 77.1539),
(8, 13, 77.0252),
(8, 19, 76.0921),
(8, 10, 76.1150),
(8, 20, 75.0845),
(8, 11, 74.1158),
(8, 17, NULL),
(8, 2, NULL),
(8, 16, NULL),
(8, 12, NULL),
(9, 1, 75.0929),
(9, 6, 75.0918),
(9, 5, 74.1455),
(9, 7, 74.1416),
(9, 8, 76.0407),
(9, 9, 76.0503),
(9, 10, 76.1242),
(9, 13, 77.0116),
(9, 18, 77.0013),
(9, 17, 77.0012),
(9, 16, 76.1123),
(9, 12, 76.0819),
(9, 19, 77.0410),
(9, 14, 77.0509),
(9, 11, 77.0525),
(9, 3, 78.1557),
(9, 15, 79.0559),
(9, 2, 78.1339),
(9, 4, 86.0012),
(9, 20, 86.0804),
(10, 1, 77.1256),
(10, 6, 77.0155),
(10, 7, 77.1329),
(10, 5, 78.0450),
(10, 4, 77.1457),
(10, 3, 78.0859),
(10, 8, 77.1434),
(10, 2, 77.1305),
(10, 18, 79.0045),
(10, 17, 78.1622),
(10, 16, 78.1009),
(10, 9, 78.0534),
(10, 11, 78.1251),
(10, 10, 79.0518),
(10, 13, 79.0730),
(10, 19, 79.1008),
(10, 12, 79.1325),
(10, 15, 79.0212),
(10, 14, 79.0727),
(10, 20, 80.0252),
(11, 5, 69.0244),
(11, 8, 68.1137),
(11, 3, 69.0442),
(11, 7, 69.0922),
(11, 1, 67.1159),
(11, 16, 70.0335),
(11, 2, 69.1134),
(11, 12, 70.0205),
(11, 13, 70.0706),
(11, 18, 69.1009),
(11, 4, 69.0944),
(11, 17, 69.1049),
(11, 10, 70.0223),
(11, 14, 70.0518),
(11, 15, 70.0604),
(11, 19, 70.0729),
(11, 11, 70.0750),
(11, 9, 67.1134),
(11, 20, 70.0646),
(11, 6, 68.0016),
(12, 7, 89.0718),
(12, 1, 88.1552),
(12, 6, 89.0422),
(12, 8, 88.1228),
(12, 3, 88.0453),
(12, 16, 89.1356),
(12, 10, 89.1457),
(12, 9, 89.1150),
(12, 15, 89.1158),
(12, 14, 90.0349),
(12, 20, 89.1612),
(12, 12, 90.0133),
(12, 13, 90.1215),
(12, 4, 89.1228),
(12, 19, 91.0437),
(12, 17, 90.1435),
(12, 2, 89.1147),
(12, 11, 91.0014),
(12, 5, 91.0458),
(12, 18, NULL),
(13, 8, 81.1156),
(13, 6, 81.1152),
(13, 7, 82.0233),
(13, 4, 82.0302),
(13, 1, 80.1508),
(13, 3, 81.0721),
(13, 2, 81.0136),
(13, 5, 80.0505),
(13, 14, 83.0853),
(13, 10, 82.0538),
(13, 9, 83.0103),
(13, 13, 82.1040),
(13, 16, 83.0741),
(13, 15, 83.1530),
(13, 12, 83.0913),
(13, 19, 82.1312),
(13, 20, 80.0921),
(13, 17, 81.1010),
(13, 11, 83.0807),
(13, 18, 83.0540),
(14, 5, 107.0153),
(14, 7, 106.1053),
(14, 8, 105.1400),
(14, 4, 107.0013),
(14, 1, 106.0208),
(14, 6, 105.0923),
(14, 3, 106.0604),
(14, 2, 104.1141),
(14, 9, 108.0051),
(14, 17, 106.1557),
(14, 13, 107.0715),
(14, 10, 108.0145),
(14, 15, 107.1636),
(14, 18, 107.0658),
(14, 12, 107.1408),
(14, 19, 107.0019),
(14, 14, 107.1609),
(14, 20, 107.0810),
(14, 16, 108.1554),
(14, 11, 112.0139),
(15, 6, 73.1337),
(15, 1, 74.1232),
(15, 4, 74.0945),
(15, 8, 74.0357),
(15, 3, 74.0157),
(15, 2, 74.0947),
(15, 5, 73.1527),
(15, 7, 73.1438),
(15, 18, 74.1415),
(15, 9, 74.1238),
(15, 16, 75.1057),
(15, 13, 75.0342),
(15, 10, 75.0415),
(15, 15, 74.0714),
(15, 17, 75.0630),
(15, 20, 75.0859),
(15, 14, 75.0912),
(15, 12, 74.1554),
(15, 19, 75.1342),
(15, 11, 75.1204),
(16, 4, 83.0346),
(16, 8, 81.1543),
(16, 6, 81.0712),
(16, 3, 83.0339),
(16, 7, 81.0832),
(16, 1, 81.1225),
(16, 5, 82.0036),
(16, 2, 82.1611),
(16, 15, 83.1518),
(16, 12, 83.0717),
(16, 9, 82.1544),
(16, 22, 83.1208),
(16, 13, 84.0339),
(16, 17, 84.0543),
(16, 18, 83.1235),
(16, 19, 83.1009),
(16, 16, 83.0435),
(16, 11, 85.0132),
(16, 10, 82.0352),
(16, 14, 86.0318),
(17, 8, 107.0100),
(17, 4, 107.0107),
(17, 5, 106.1028),
(17, 6, 105.0415),
(17, 1, 106.1318),
(17, 9, 107.0057),
(17, 15, 106.1547),
(17, 22, 107.0434),
(17, 7, 107.0356),
(17, 21, 107.0048),
(17, 16, 107.1131),
(17, 18, 108.0018),
(17, 13, 108.0620),
(17, 11, 107.1044),
(17, 17, 108.1351),
(17, 19, 108.0658),
(17, 2, 107.0013),
(17, 3, 106.1426),
(17, 10, 108.0228),
(17, 14, 110.1447),
(18, 6, 94.1525),
(18, 1, 95.1607),
(18, 8, 95.1225),
(18, 5, 97.0047),
(18, 4, 95.0611),
(18, 7, 97.0633),
(18, 3, 96.0921),
(18, 9, 97.1221),
(18, 16, 97.0750),
(18, 2, 97.0757),
(18, 22, 97.0422),
(18, 14, 96.0633),
(18, 17, 97.1604),
(18, 10, 97.1411),
(18, 11, 97.0741),
(18, 19, 97.0844),
(18, 18, 96.1527),
(18, 13, 94.0806),
(18, 12, 97.0705),
(18, 15, 96.1448),
(19, 4, 97.1354),
(19, 3, 97.1243),
(19, 1, 98.0157),
(19, 6, 97.1119),
(19, 8, 97.1443),
(19, 5, 97.1056),
(19, 2, 98.0834),
(19, 16, 98.0644),
(19, 23, 98.0131),
(19, 22, 97.1011),
(19, 12, 98.0330),
(19, 18, 98.0511),
(19, 9, 99.0421),
(19, 14, 99.0313),
(19, 10, 99.0334),
(19, 15, 99.0124),
(19, 19, 100.0935),
(19, 17, 97.0530),
(19, 11, 99.0432),
(19, 7, NULL),
(20, 3, 80.0217),
(20, 6, 79.1131),
(20, 4, 78.0536),
(20, 7, 80.0611),
(20, 5, 80.1211),
(20, 1, 80.1432),
(20, 12, 80.1037),
(20, 8, 80.0104),
(20, 16, 80.1228),
(20, 18, 81.0434),
(20, 10, 81.0511),
(20, 22, 80.0130),
(20, 17, 80.1059),
(20, 19, 81.0125),
(20, 11, 81.0913),
(20, 23, 79.0822),
(20, 2, 79.0329),
(20, 9, 82.1202),
(20, 15, NULL),
(20, 14, NULL),
(21, 1, 80.0752),
(21, 17, 81.1251),
(21, 18, 81.1045),
(21, 5, 81.1045),
(21, 4, 81.1031),
(21, 6, 81.0837),
(21, 14, 81.1348),
(21, 8, 81.0852),
(21, 23, 82.0203),
(21, 7, 82.0041),
(21, 2, 82.0223),
(21, 21, 82.0814),
(21, 19, 82.1437),
(21, 9, 82.0453),
(21, 11, 83.0058),
(21, 3, 84.0321),
(21, 22, 84.0456),
(21, 15, NULL),
(21, 10, NULL),
(21, 16, 83.1244),
(22, 5, 95.1157),
(22, 7, 95.0800),
(22, 3, 95.1435),
(22, 4, 95.1114),
(22, 1, 96.0408),
(22, 6, 94.1436),
(22, 8, 96.0958),
(22, 16, 96.0945),
(22, 14, 96.1557),
(22, 2, 96.0526),
(22, 9, 96.0913),
(22, 12, 96.0917),
(22, 11, 96.0524),
(22, 22, 96.1427),
(22, 10, 97.0259),
(22, 23, 96.1620),
(22, 17, 96.0831),
(22, 19, 96.1001),
(22, 15, 98.0008),
(22, 18, 98.0514),
(23, 1, 82.1505),
(23, 4, 83.0402),
(23, 8, 83.0338),
(23, 5, 83.0555),
(23, 18, 83.1145),
(23, 3, 83.0745),
(23, 9, 83.1107),
(23, 11, 83.1449),
(23, 12, 84.0419),
(23, 6, 82.0624),
(23, 19, 85.0853),
(23, 7, 83.1425),
(23, 14, 86.0224),
(23, 23, 86.0116),
(23, 15, 85.0919),
(23, 16, 85.1247),
(23, 2, 85.0448),
(23, 10, 90.1535),
(23, 22, NULL),
(23, 17, NULL),
(24, 6, 87.0718),
(24, 3, 87.1245),
(24, 4, 88.0018),
(24, 7, 87.0438),
(24, 5, 88.0315),
(24, 1, 87.1245),
(24, 18, 89.0411),
(24, 16, 89.0232),
(24, 9, 87.1548),
(24, 8, 87.1130),
(24, 15, 89.0718),
(24, 14, 89.0320),
(24, 11, 87.1622),
(24, 10, 88.1004),
(24, 24, 89.0201),
(24, 12, 85.1037),
(24, 23, 88.1231),
(24, 19, 89.0802),
(24, 22, 89.0651),
(24, 2, NULL);

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

--
-- Tábla szerkezet ehhez a táblához `rajtpozicio`
--

CREATE TABLE `rajtpozicio` (
  `futamid` int(10) NOT NULL,
  `versenyzoid` int(10) NOT NULL,
  `pozicio` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `rajtpozicio`
--

INSERT INTO `rajtpozicio` (`futamid`, `versenyzoid`, `pozicio`) VALUES
(1, 1, 1),
(1, 2, 5),
(1, 3, 4),
(1, 4, 2),
(1, 5, 3),
(1, 6, 7),
(1, 7, 9),
(1, 8, 8),
(1, 9, 6),
(1, 10, 12),
(1, 11, 17),
(1, 12, 15),
(1, 13, 14),
(1, 14, 11),
(1, 15, 13),
(1, 16, 10),
(1, 17, 19),
(1, 18, 20),
(1, 19, 16),
(1, 20, 18),
(2, 1, 1),
(2, 2, 3),
(2, 4, 2),
(2, 8, 5),
(2, 9, 4),
(2, 5, 7),
(2, 21, 11),
(2, 6, 6),
(2, 7, 8),
(2, 16, 15),
(2, 15, 12),
(2, 12, 13),
(2, 17, 17),
(2, 20, 19),
(2, 14, 9),
(2, 13, 14),
(2, 19, 16),
(2, 11, 20),
(2, 10, 10),
(2, 18, 18),
(3, 3, 2),
(3, 4, 4),
(3, 6, 3),
(3, 8, 5),
(3, 2, 6),
(3, 10, 9),
(3, 14, 8),
(3, 9, 10),
(3, 16, 16),
(3, 12, 14),
(3, 15, 12),
(3, 13, 18),
(3, 18, 17),
(3, 19, 13),
(3, 11, 19),
(3, 17, 15),
(3, 5, 7),
(3, 7, 11),
(3, 1, 1),
(4, 1, 1),
(4, 2, 2),
(4, 3, 4),
(4, 4, 8),
(4, 6, 3),
(4, 9, 5),
(4, 5, 9),
(4, 8, 6),
(4, 7, 7),
(4, 14, 10),
(4, 16, 12),
(4, 10, 16),
(4, 12, 18),
(4, 19, 13),
(4, 17, 15),
(4, 18, 17),
(4, 20, 19),
(4, 11, 20),
(4, 13, 11),
(4, 15, 14),
(5, 1, 1),
(5, 6, 4),
(5, 2, 2),
(5, 4, 6),
(5, 3, 7),
(5, 5, 8),
(5, 9, 3),
(5, 8, 5),
(5, 7, 18),
(5, 16, 9),
(5, 17, 13),
(5, 15, 14),
(5, 18, 15),
(5, 11, 16),
(5, 10, 11),
(5, 12, 17),
(5, 20, 20),
(5, 13, 12),
(5, 14, 19),
(5, 19, 10),
(6, 6, 5),
(6, 1, 1),
(6, 4, 2),
(6, 2, 4),
(6, 3, 3),
(6, 7, 8),
(6, 14, 10),
(6, 5, 7),
(6, 9, 15),
(6, 17, 13),
(6, 16, 9),
(6, 18, 12),
(6, 8, 6),
(6, 11, 19),
(6, 13, 20),
(6, 19, 16),
(6, 10, 11),
(6, 15, 14),
(6, 12, 18),
(6, 20, 17),
(7, 1, 1),
(7, 6, 2),
(7, 4, 3),
(7, 8, 5),
(7, 3, 4),
(7, 7, 8),
(7, 5, 6),
(7, 2, 11),
(7, 10, 13),
(7, 14, 7),
(7, 16, 10),
(7, 12, 18),
(7, 13, 9),
(7, 17, 12),
(7, 11, 17),
(7, 18, 15),
(7, 20, 19),
(7, 19, 16),
(7, 9, 20),
(7, 15, 14),
(8, 4, 1),
(8, 8, 2),
(8, 3, 3),
(8, 6, 4),
(8, 5, 5),
(8, 1, 6),
(8, 7, 7),
(8, 14, 8),
(8, 15, 9),
(8, 18, 10),
(8, 9, 14),
(8, 13, 12),
(8, 19, 17),
(8, 10, 13),
(8, 20, 15),
(8, 11, 18),
(8, 17, 11),
(8, 2, 16),
(8, 16, 19),
(8, 12, 20),
(9, 1, 2),
(9, 6, 3),
(9, 5, 1),
(9, 7, 7),
(9, 8, 4),
(9, 9, 6),
(9, 10, 9),
(9, 13, 5),
(9, 18, 15),
(9, 17, 18),
(9, 16, 17),
(9, 12, 14),
(9, 19, 19),
(9, 14, 8),
(9, 11, 20),
(9, 3, 12),
(9, 15, 10),
(9, 2, 16),
(9, 4, 11),
(9, 20, 13),
(10, 1, 2),
(10, 6, 1),
(10, 7, 3),
(10, 5, 4),
(10, 4, 5),
(10, 3, 6),
(10, 8, 9),
(10, 2, 11),
(10, 18, 7),
(10, 17, 8),
(10, 16, 13),
(10, 9, 10),
(10, 11, 15),
(10, 10, 14),
(10, 13, 18),
(10, 19, 12),
(10, 12, 16),
(10, 15, 20),
(10, 14, 17),
(10, 20, 19),
(11, 5, 3),
(11, 8, 7),
(11, 3, 4),
(11, 7, 5),
(11, 1, 1),
(11, 16, 9),
(11, 2, 8),
(11, 12, 12),
(11, 13, 11),
(11, 18, 13),
(11, 4, 6),
(11, 17, 10),
(11, 10, 17),
(11, 14, 14),
(11, 15, 16),
(11, 19, 18),
(11, 11, 20),
(11, 9, 15),
(11, 20, 19),
(11, 6, 2),
(12, 7, 2),
(12, 1, 4),
(12, 6, 3),
(12, 8, 5),
(12, 3, 7),
(12, 16, 6),
(12, 10, 8),
(12, 9, 10),
(12, 15, 9),
(12, 14, 13),
(12, 20, 12),
(12, 12, 17),
(12, 13, 15),
(12, 4, 11),
(12, 19, 16),
(12, 17, 18),
(12, 2, 20),
(12, 11, 14),
(12, 5, 1),
(12, 18, 19),
(13, 8, 2),
(13, 6, 1),
(13, 7, 5),
(13, 4, 6),
(13, 1, 3),
(13, 3, 4),
(13, 2, 16),
(13, 5, 17),
(13, 14, 10),
(13, 10, 8),
(13, 9, 7),
(13, 13, 9),
(13, 16, 11),
(13, 15, 13),
(13, 12, 15),
(13, 19, 12),
(13, 20, 14),
(13, 17, 19),
(13, 11, 18),
(13, 18, 20),
(14, 5, 6),
(14, 7, 3),
(14, 8, 5),
(14, 4, 1),
(14, 1, 11),
(14, 6, 4),
(14, 3, 7),
(14, 2, 2),
(14, 9, 8),
(14, 17, 9),
(14, 13, 13),
(14, 10, 15),
(14, 15, 10),
(14, 18, 12),
(14, 12, 17),
(14, 19, 14),
(14, 14, 20),
(14, 20, 18),
(14, 16, 16),
(14, 11, 19),
(15, 6, 1),
(15, 1, 2),
(15, 4, 6),
(15, 8, 3),
(15, 3, 10),
(15, 2, 5),
(15, 5, 4),
(15, 7, 14),
(15, 18, 9),
(15, 9, 7),
(15, 16, 12),
(15, 13, 13),
(15, 10, 8),
(15, 15, 19),
(15, 17, 15),
(15, 20, 18),
(15, 14, 11),
(15, 12, 20),
(15, 19, 16),
(15, 11, 17),
(16, 4, 4),
(16, 8, 2),
(16, 6, 1),
(16, 3, 5),
(16, 7, 6),
(16, 1, 7),
(16, 5, 3),
(16, 2, 8),
(16, 15, 9),
(16, 12, 13),
(16, 9, 11),
(16, 22, 18),
(16, 13, 12),
(16, 17, 15),
(16, 18, 14),
(16, 19, 19),
(16, 16, 10),
(16, 11, 20),
(16, 10, 17),
(16, 14, 16),
(17, 8, 2),
(17, 4, 1),
(17, 5, 5),
(17, 6, 15),
(17, 1, 6),
(17, 9, 7),
(17, 15, 9),
(17, 22, 8),
(17, 7, 19),
(17, 21, 10),
(17, 16, 12),
(17, 18, 18),
(17, 13, 14),
(17, 11, 17),
(17, 17, 20),
(17, 19, 16),
(17, 2, 4),
(17, 3, 3),
(17, 10, 13),
(17, 14, 11),
(18, 6, 1),
(18, 1, 2),
(18, 8, 5),
(18, 5, 4),
(18, 4, 9),
(18, 7, 3),
(18, 3, 10),
(18, 9, 7),
(18, 16, 6),
(18, 2, 13),
(18, 22, 12),
(18, 14, 8),
(18, 17, 15),
(18, 10, 17),
(18, 11, 20),
(18, 19, 19),
(18, 18, 18),
(18, 13, 16),
(18, 12, 14),
(18, 15, 11),
(19, 4, 4),
(19, 3, 3),
(19, 1, 2),
(19, 6, 1),
(19, 8, 5),
(19, 5, 20),
(19, 2, 9),
(19, 16, 11),
(19, 23, 19),
(19, 22, 15),
(19, 12, 8),
(19, 18, 6),
(19, 9, 7),
(19, 14, 10),
(19, 10, 13),
(19, 15, 14),
(19, 19, 16),
(19, 17, 12),
(19, 11, 18),
(19, 7, 17),
(20, 3, 1),
(20, 6, 3),
(20, 4, 4),
(20, 7, 6),
(20, 5, 5),
(20, 1, 2),
(20, 12, 7),
(20, 8, 17),
(20, 16, 10),
(20, 18, 8),
(20, 10, 14),
(20, 22, 16),
(20, 17, 20),
(20, 19, 15),
(20, 11, 19),
(20, 23, 12),
(20, 2, 18),
(20, 9, 13),
(20, 15, 9),
(20, 14, 11),
(21, 1, 17),
(21, 17, 4),
(21, 18, 13),
(21, 5, 2),
(21, 4, 6),
(21, 6, 1),
(21, 14, 3),
(21, 8, 8),
(21, 23, 5),
(21, 7, 14),
(21, 2, 12),
(21, 21, 15),
(21, 19, 11),
(21, 9, 9),
(21, 11, 19),
(21, 3, 20),
(21, 22, 16),
(21, 15, 7),
(21, 10, 10),
(21, 16, 18),
(22, 5, 1),
(22, 7, 10),
(22, 3, 2),
(22, 4, 4),
(22, 1, 5),
(22, 6, 6),
(22, 8, 8),
(22, 16, 9),
(22, 14, 7),
(22, 2, 15),
(22, 9, 16),
(22, 12, 12),
(22, 11, 13),
(22, 22, 20),
(22, 10, 18),
(22, 23, 14),
(22, 17, 11),
(22, 19, 19),
(22, 15, 17),
(22, 18, 3),
(23, 1, 2),
(23, 4, 5),
(23, 8, 4),
(23, 5, 1),
(23, 18, 11),
(23, 3, 7),
(23, 9, 8),
(23, 11, 12),
(23, 12, 10),
(23, 6, 3),
(23, 19, 13),
(23, 7, 6),
(23, 14, 14),
(23, 23, 17),
(23, 15, 16),
(23, 16, 18),
(23, 2, 9),
(23, 10, 15),
(23, 22, 19),
(23, 17, 20),
(24, 6, 1),
(24, 3, 3),
(24, 4, 19),
(24, 7, 16),
(24, 5, 6),
(24, 1, 4),
(24, 18, 5),
(24, 16, 7),
(24, 9, 8),
(24, 8, 2),
(24, 15, 18),
(24, 14, 11),
(24, 11, 15),
(24, 10, 13),
(24, 24, 17),
(24, 12, 14),
(24, 23, 12),
(24, 19, 9),
(24, 22, 20),
(24, 2, 10);

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

--
-- Tábla szerkezet ehhez a táblához `versenyzo`
--

CREATE TABLE `versenyzo` (
  `versenyzoid` int(10) NOT NULL,
  `versenyzonev` varchar(100) NOT NULL,
  `szuletesiido` date NOT NULL,
  `rajtszam` int(10) NOT NULL,
  `csapatid` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

--
-- A tábla adatainak kiíratása `versenyzo`
--

INSERT INTO `versenyzo` (`versenyzoid`, `versenyzonev`, `szuletesiido`, `rajtszam`, `csapatid`) VALUES
(1, 'Max Verstappen', '1997-09-30', 1, 1),
(2, 'Sergio Perez', '1990-01-16', 11, 1),
(3, 'Carlos Sainz', '1994-09-01', 55, 2),
(4, 'Charles Leclerc', '1997-10-16', 16, 2),
(5, 'George Russell', '1998-02-15', 63, 3),
(6, 'Lando Norris', '1999-11-13', 4, 4),
(7, 'Lewis Hamilton', '1985-01-07', 44, 3),
(8, 'Oscar Piastri', '2001-04-06', 81, 4),
(9, 'Fernando Alonso', '1981-07-29', 14, 5),
(10, 'Lance Stroll', '1998-10-29', 18, 5),
(11, 'Guanyu Zhou', '1999-05-30', 24, 6),
(12, 'Kevin Magnussen', '1992-10-05', 20, 7),
(13, 'Daniel Ricciardo', '1989-07-01', 3, 8),
(14, 'Yuki Tsunoda', '2000-05-11', 22, 8),
(15, 'Alexander Albon', '1996-03-23', 23, 9),
(16, 'Nico Hulkenberg', '1987-08-19', 27, 7),
(17, 'Esteban Ocon', '1996-09-17', 31, 10),
(18, 'Pierre Gasly', '1996-02-07', 10, 10),
(19, 'Valtteri Bottas', '1989-08-28', 77, 6),
(20, 'Logan Sargeant', '2000-12-31', 2, 9),
(21, 'Oliver Bearman', '2005-05-08', 38, 2),
(22, 'Franco Colapinto', '2003-05-27', 43, 9),
(23, 'Liam Lawson', '2002-02-11', 30, 8),
(24, 'Jack Doohan', '2003-01-20', 61, 10);

--
-- Indexek a kiírt táblákhoz
--

--
-- A tábla indexei `csapat`
--
ALTER TABLE `csapat`
  ADD PRIMARY KEY (`csapatid`);

--
-- A tábla indexei `futam`
--
ALTER TABLE `futam`
  ADD PRIMARY KEY (`futamid`);

--
-- A tábla indexei `versenyzo`
--
ALTER TABLE `versenyzo`
  ADD PRIMARY KEY (`versenyzoid`);
COMMIT;

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