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

CREATE DATABASE IF NOT EXISTS `kezilabda` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_hungarian_ci;
USE `kezilabda`;

CREATE TABLE `jatekos` (
  `azon` int(3) NOT NULL,
  `nev` varchar(23) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `jatekos` (`azon`, `nev`) VALUES
(1, 'Adorján János'),
(2, 'Ancsin Gábor'),
(3, 'Andó Arián'),
(4, 'Balázs Jenő'),
(5, 'Balogh Zsolt'),
(6, 'Bánhidi Bence'),
(7, 'Bányai István'),
(8, 'Baranyai Gyula'),
(9, 'Bartalos Béla'),
(10, 'Bartók Csaba'),
(11, 'Bartók Donát'),
(12, 'Bartucz László'),
(13, 'Bencsik Ottó'),
(14, 'Bendó Csaba'),
(15, 'Bene Tamás'),
(16, 'Berendi József'),
(17, 'Bergendi Zoltán'),
(18, 'Berkesi Ferenc'),
(19, 'Bíró Imre'),
(20, 'Bodó Richárd'),
(21, 'Bóka Bendegúz'),
(22, 'Bolla Rudolf'),
(23, 'Borbély Ádám'),
(24, 'Bordás József'),
(25, 'Borsodi Péter'),
(26, 'Borsos Attila'),
(27, 'Borsos Tamás'),
(28, 'Buday Dániel'),
(29, 'Buday Ferenc'),
(30, 'Bujdosó Bendegúz'),
(31, 'Császár Gábor'),
(32, 'Csicsai Ottó'),
(33, 'Csík János'),
(34, 'Csoknyai István'),
(35, 'Debre Viktor'),
(36, 'Décsi Gábor'),
(37, 'Demjén Ferenc'),
(38, 'Diaz Ivo'),
(40, 'Doros Ákos'),
(41, 'dr. Süvöltös Mihály'),
(42, 'Drobnits Vilmos'),
(43, 'Dubán Dénes'),
(44, 'Eklemovics Nikola'),
(45, 'Éles József'),
(46, 'Faludi Mihály'),
(47, 'Faluvégi Rudolf'),
(48, 'Fazekas Gergő'),
(49, 'Fazekas Nándor'),
(50, 'Fekete Bálint'),
(51, 'Fekete Gábor'),
(52, 'Fekete Róbert'),
(53, 'Fekete Sándor'),
(54, 'Fenyő András'),
(55, 'Fenyő Kálmán'),
(56, 'Fodor János'),
(57, 'Füzesi Ferenc'),
(58, 'Gál Gyula'),
(59, 'Gazdag Tibor'),
(60, 'Grebenár Gábor'),
(61, 'Gubányi Ernő'),
(62, 'Gulyás István'),
(63, 'Gulyás Péter'),
(64, 'Györffy Sándor'),
(65, 'Győrffy Sándor'),
(66, 'Győri Mátyás'),
(67, 'Gyurka János'),
(68, 'Gyűrű Ferenc'),
(69, 'Hanusz Egon'),
(70, 'Harka László'),
(71, 'Harsányi Gergely'),
(72, 'Herbert Gábor'),
(73, 'Hetényi Ottó'),
(74, 'Hoffmann László'),
(75, 'Hornyák Péter'),
(76, 'Horváth Attila'),
(77, 'Horváth Gábor'),
(78, 'Horváth Jenő'),
(79, 'Horváth József'),
(80, 'Hunyadkürti János'),
(81, 'ifj. Rosta Miklós'),
(82, 'Igor Zubjuk'),
(83, 'Ilic Zoran'),
(84, 'Ilyés Ferenc'),
(85, 'Imre Bence'),
(86, 'Iváncsik Gergő'),
(87, 'Iváncsik Mihály'),
(88, 'Iváncsik Tamás'),
(89, 'Jamali Iman'),
(90, 'Janovszki László'),
(91, 'Jánovszki László'),
(92, 'Jegenyés Alpár'),
(93, 'Józsa Máté'),
(94, 'Juhász Ádám'),
(95, 'Kaló Sándor'),
(96, 'Katzirz Dávid'),
(97, 'Kele Miklós'),
(98, 'Kenyeres József'),
(99, 'Kertész Balázs'),
(100, 'Kesjár András'),
(101, 'Kis Ákos'),
(102, 'Kiss István'),
(103, 'Klein József'),
(104, 'Koch Ádám'),
(105, 'Kocsis Pál'),
(106, 'Kontra Zsolt'),
(107, 'Kotormán Attila'),
(108, 'Kovács János'),
(109, 'Kovács László'),
(110, 'Kovács Mihály'),
(111, 'Kovács Péter'),
(112, 'Kovacsics Miklós'),
(113, 'Köszegi Tibor'),
(114, 'Krakovszki Bence'),
(115, 'Krakovszki Zsolt'),
(116, 'Krivokapics Milorad'),
(117, 'Kubasi Rudolf'),
(118, 'Laluska Balázs'),
(119, 'Lehel Géza'),
(120, 'Leimeter Csaba'),
(121, 'Lékai Máté'),
(122, 'Lele Ambrus'),
(123, 'Lendvay Péter'),
(124, 'Lengyel Gábor'),
(125, 'Ligetvári Patrik'),
(126, 'Lukács Péter'),
(127, 'Marosi István'),
(128, 'Marosi László'),
(129, 'Máthé Dominik'),
(130, 'Mezei Richárd'),
(131, 'Mikler Roland'),
(132, 'Mocsai Tamás'),
(133, 'Mohácsi Árpád'),
(134, 'Molnár Gyula'),
(135, 'Nagy Attila'),
(136, 'Nagy Bence'),
(137, 'Nagy Kornél'),
(138, 'Nagy László'),
(139, 'Nagy Zoltán'),
(140, 'Németh Zoltán'),
(141, 'Ónodi-Jánoskúti Máté'),
(142, 'Oross Tibor'),
(143, 'Országh Ádám'),
(144, 'Oszlánczi András'),
(145, 'Pál Árpád'),
(146, 'Palasics Kristóf'),
(147, 'Papp Tamás'),
(148, 'Pásztor Ákos'),
(149, 'Pásztor István'),
(150, 'Pérez Carlos'),
(151, 'Pergel Andrej'),
(152, 'Perger Zsolt'),
(153, 'Pribék István'),
(154, 'Puljezevics Nenad'),
(155, 'Putics Barna'),
(156, 'Putics Jenő'),
(157, 'Rácz Béla'),
(158, 'Rodríguez Álvarez Pedro'),
(160, 'Rosta István'),
(161, 'Rosta Miklós'),
(162, 'Schuch Timuzsin'),
(163, 'Schvajda Béla'),
(164, 'Sibalin Jakab'),
(165, 'Simó Lajos'),
(166, 'Sipos Adrián'),
(167, 'Som Ferenc'),
(168, 'Sótonyi László'),
(169, 'Stiller János'),
(170, 'Stiller László'),
(171, 'Sunajko Stefan'),
(172, 'Süvöltös Mihály'),
(173, 'Szabó István'),
(174, 'Szabó László'),
(175, 'Szalafai Gábor'),
(176, 'Szathmári János'),
(177, 'Székely Márton'),
(178, 'Szente Gábor'),
(179, 'Szilágyi István'),
(180, 'Szita Zoltán'),
(182, 'Szotyori István'),
(183, 'Szöllösi Szabolcs'),
(185, 'Takács Sándor'),
(186, 'Tamásdi Sándor'),
(187, 'Tatai Péter'),
(188, 'Timár Béla'),
(189, 'Tombor Csaba'),
(190, 'Topic Petar'),
(191, 'Tornóczky János'),
(192, 'Tóth Ádám'),
(193, 'Tóth Géza'),
(194, 'Töltő Károly'),
(195, 'Törő Szabolcs'),
(196, 'Török Lajos'),
(197, 'Tyetyák Tibor'),
(198, 'Ubornyák Dávid'),
(199, 'Vadkerti Attila'),
(200, 'Vajna István'),
(201, 'Varga István'),
(202, 'Várkonyi Zoltán'),
(203, 'Vass Károly'),
(204, 'Vass Sándor'),
(205, 'Verőci Gábor'),
(206, 'Vigh Ferenc'),
(207, 'Vilovski Uros'),
(208, 'Zdolik Bence'),
(209, 'Zubai Szabolcs'),
(210, 'Zuber Titusz'),
(211, 'Zubjuk Igor'),
(212, 'Zsigmond György');

CREATE TABLE `reszvetel` (
  `torna_azon` int(2) NOT NULL,
  `jatekos_azon` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `reszvetel` (`torna_azon`, `jatekos_azon`) VALUES
(1, 1),
(1, 9),
(1, 33),
(1, 70),
(1, 79),
(1, 95),
(1, 127),
(1, 165),
(1, 169),
(1, 173),
(1, 174),
(1, 185),
(1, 201),
(1, 203),
(1, 204),
(2, 9),
(2, 29),
(2, 61),
(2, 90),
(2, 98),
(2, 106),
(2, 111),
(2, 172),
(2, 179),
(2, 201),
(2, 203),
(2, 205),
(3, 9),
(3, 56),
(3, 61),
(3, 90),
(3, 92),
(3, 98),
(3, 106),
(3, 111),
(3, 112),
(3, 122),
(3, 145),
(3, 174),
(3, 179),
(3, 204),
(4, 19),
(4, 24),
(4, 32),
(4, 56),
(4, 67),
(4, 74),
(4, 87),
(4, 110),
(4, 111),
(4, 128),
(4, 142),
(4, 164),
(4, 174),
(4, 193),
(5, 19),
(5, 26),
(5, 32),
(5, 34),
(5, 45),
(5, 57),
(5, 64),
(5, 76),
(5, 87),
(5, 128),
(5, 130),
(5, 164),
(5, 168),
(5, 176),
(5, 211),
(6, 31),
(6, 38),
(6, 49),
(6, 58),
(6, 71),
(6, 84),
(6, 86),
(6, 118),
(6, 123),
(6, 130),
(6, 132),
(6, 138),
(6, 149),
(6, 150),
(6, 176),
(7, 31),
(7, 49),
(7, 63),
(7, 71),
(7, 84),
(7, 86),
(7, 118),
(7, 121),
(7, 131),
(7, 132),
(7, 138),
(7, 150),
(7, 155),
(7, 162),
(7, 199),
(7, 209),
(8, 2),
(8, 6),
(8, 12),
(8, 20),
(8, 21),
(8, 48),
(8, 69),
(8, 81),
(8, 83),
(8, 85),
(8, 121),
(8, 125),
(8, 131),
(8, 146),
(8, 158),
(8, 166),
(8, 180),
(9, 4),
(9, 7),
(9, 13),
(9, 16),
(9, 22),
(9, 46),
(9, 53),
(9, 73),
(9, 78),
(9, 97),
(9, 113),
(9, 124),
(9, 163),
(9, 167),
(9, 194),
(9, 200),
(10, 1),
(10, 8),
(10, 18),
(10, 42),
(10, 43),
(10, 54),
(10, 100),
(10, 103),
(10, 108),
(10, 109),
(10, 127),
(10, 157),
(10, 170),
(10, 186),
(10, 188),
(10, 206),
(11, 1),
(11, 54),
(11, 68),
(11, 95),
(11, 103),
(11, 104),
(11, 108),
(11, 109),
(11, 127),
(11, 135),
(11, 165),
(11, 188),
(11, 191),
(11, 201),
(12, 1),
(12, 33),
(12, 54),
(12, 79),
(12, 95),
(12, 109),
(12, 127),
(12, 165),
(12, 169),
(12, 173),
(12, 174),
(12, 185),
(12, 201),
(12, 204),
(13, 9),
(13, 29),
(13, 37),
(13, 61),
(13, 79),
(13, 80),
(13, 105),
(13, 111),
(13, 165),
(13, 169),
(13, 179),
(13, 203),
(13, 204),
(13, 210),
(14, 9),
(14, 29),
(14, 41),
(14, 61),
(14, 91),
(14, 98),
(14, 105),
(14, 106),
(14, 111),
(14, 134),
(14, 174),
(14, 179),
(14, 202),
(14, 205),
(15, 9),
(15, 67),
(15, 74),
(15, 77),
(15, 92),
(15, 98),
(15, 105),
(15, 106),
(15, 110),
(15, 111),
(15, 122),
(15, 174),
(15, 179),
(15, 193),
(15, 203),
(16, 19),
(16, 24),
(16, 35),
(16, 56),
(16, 67),
(16, 74),
(16, 77),
(16, 87),
(16, 98),
(16, 106),
(16, 110),
(16, 111),
(16, 128),
(16, 142),
(16, 174),
(17, 19),
(17, 24),
(17, 26),
(17, 57),
(17, 65),
(17, 67),
(17, 74),
(17, 87),
(17, 110),
(17, 119),
(17, 128),
(17, 153),
(17, 156),
(17, 164),
(18, 10),
(18, 19),
(18, 26),
(18, 34),
(18, 45),
(18, 52),
(18, 55),
(18, 65),
(18, 67),
(18, 76),
(18, 99),
(18, 130),
(18, 133),
(18, 149),
(18, 168),
(18, 176),
(19, 26),
(19, 45),
(19, 52),
(19, 62),
(19, 82),
(19, 102),
(19, 107),
(19, 111),
(19, 133),
(19, 152),
(19, 160),
(19, 161),
(19, 168),
(19, 176),
(19, 196),
(19, 212),
(20, 14),
(20, 17),
(20, 34),
(20, 45),
(20, 62),
(20, 82),
(20, 99),
(20, 101),
(20, 130),
(20, 149),
(20, 152),
(20, 161),
(20, 168),
(20, 176),
(20, 197),
(20, 212),
(21, 14),
(21, 15),
(21, 34),
(21, 36),
(21, 45),
(21, 49),
(21, 62),
(21, 99),
(21, 101),
(21, 107),
(21, 130),
(21, 138),
(21, 152),
(21, 160),
(21, 168),
(21, 176),
(22, 14),
(22, 28),
(22, 40),
(22, 49),
(22, 58),
(22, 86),
(22, 93),
(22, 96),
(22, 99),
(22, 118),
(22, 123),
(22, 138),
(22, 149),
(22, 150),
(22, 161),
(22, 176),
(23, 31),
(23, 38),
(23, 49),
(23, 58),
(23, 72),
(23, 84),
(23, 86),
(23, 88),
(23, 96),
(23, 132),
(23, 137),
(23, 138),
(23, 154),
(23, 187),
(23, 189),
(23, 199),
(24, 31),
(24, 44),
(24, 49),
(24, 58),
(24, 71),
(24, 72),
(24, 84),
(24, 86),
(24, 88),
(24, 96),
(24, 132),
(24, 138),
(24, 154),
(24, 155),
(24, 195),
(24, 209),
(25, 31),
(25, 49),
(25, 58),
(25, 63),
(25, 71),
(25, 84),
(25, 86),
(25, 88),
(25, 96),
(25, 121),
(25, 131),
(25, 132),
(25, 137),
(25, 150),
(25, 162),
(25, 195),
(25, 209),
(26, 2),
(26, 31),
(26, 71),
(26, 86),
(26, 116),
(26, 121),
(26, 131),
(26, 132),
(26, 137),
(26, 138),
(26, 155),
(26, 162),
(26, 183),
(26, 187),
(26, 199),
(26, 209),
(27, 2),
(27, 5),
(27, 6),
(27, 20),
(27, 31),
(27, 49),
(27, 63),
(27, 71),
(27, 89),
(27, 94),
(27, 121),
(27, 125),
(27, 131),
(27, 138),
(27, 162),
(27, 183),
(27, 209),
(28, 2),
(28, 5),
(28, 6),
(28, 20),
(28, 21),
(28, 31),
(28, 75),
(28, 84),
(28, 89),
(28, 94),
(28, 121),
(28, 125),
(28, 129),
(28, 131),
(28, 138),
(28, 162),
(28, 166),
(28, 177),
(28, 180),
(29, 2),
(29, 5),
(29, 6),
(29, 20),
(29, 21),
(29, 23),
(29, 66),
(29, 69),
(29, 75),
(29, 81),
(29, 121),
(29, 129),
(29, 131),
(29, 136),
(29, 158),
(29, 166),
(29, 171),
(29, 177),
(29, 180),
(29, 190),
(30, 2),
(30, 6),
(30, 20),
(30, 21),
(30, 30),
(30, 69),
(30, 81),
(30, 83),
(30, 120),
(30, 121),
(30, 125),
(30, 131),
(30, 146),
(30, 158),
(30, 166),
(30, 177),
(30, 180),
(30, 183),
(31, 2),
(31, 6),
(31, 12),
(31, 20),
(31, 21),
(31, 48),
(31, 69),
(31, 81),
(31, 83),
(31, 85),
(31, 114),
(31, 115),
(31, 121),
(31, 125),
(31, 131),
(31, 141),
(31, 146),
(31, 158),
(31, 166),
(31, 180),
(32, 10),
(32, 26),
(32, 34),
(32, 45),
(32, 52),
(32, 62),
(32, 99),
(32, 102),
(32, 130),
(32, 140),
(32, 149),
(32, 152),
(32, 168),
(32, 176),
(32, 212),
(33, 10),
(33, 14),
(33, 25),
(33, 34),
(33, 52),
(33, 101),
(33, 107),
(33, 117),
(33, 130),
(33, 139),
(33, 144),
(33, 149),
(33, 168),
(33, 176),
(33, 182),
(33, 212),
(34, 10),
(34, 34),
(34, 52),
(34, 62),
(34, 99),
(34, 101),
(34, 107),
(34, 130),
(34, 149),
(34, 161),
(34, 168),
(34, 176),
(34, 212),
(35, 28),
(35, 31),
(35, 38),
(35, 49),
(35, 58),
(35, 84),
(35, 86),
(35, 99),
(35, 118),
(35, 130),
(35, 132),
(35, 133),
(35, 138),
(35, 149),
(35, 161),
(35, 176),
(36, 28),
(36, 31),
(36, 49),
(36, 58),
(36, 71),
(36, 84),
(36, 86),
(36, 88),
(36, 93),
(36, 118),
(36, 123),
(36, 131),
(36, 138),
(36, 178),
(36, 195),
(36, 209),
(37, 31),
(37, 44),
(37, 49),
(37, 58),
(37, 60),
(37, 63),
(37, 72),
(37, 84),
(37, 86),
(37, 88),
(37, 118),
(37, 132),
(37, 137),
(37, 138),
(37, 154),
(37, 195),
(37, 209),
(38, 31),
(38, 44),
(38, 49),
(38, 58),
(38, 63),
(38, 84),
(38, 86),
(38, 88),
(38, 96),
(38, 116),
(38, 118),
(38, 137),
(38, 154),
(38, 162),
(38, 195),
(38, 209),
(39, 2),
(39, 31),
(39, 49),
(39, 71),
(39, 84),
(39, 86),
(39, 88),
(39, 116),
(39, 118),
(39, 131),
(39, 132),
(39, 137),
(39, 155),
(39, 162),
(39, 183),
(39, 199),
(39, 209),
(40, 2),
(40, 31),
(40, 63),
(40, 84),
(40, 86),
(40, 121),
(40, 131),
(40, 132),
(40, 137),
(40, 155),
(40, 162),
(40, 175),
(40, 183),
(40, 187),
(40, 199),
(40, 208),
(40, 209),
(41, 2),
(41, 6),
(41, 12),
(41, 20),
(41, 27),
(41, 47),
(41, 59),
(41, 75),
(41, 86),
(41, 89),
(41, 131),
(41, 137),
(41, 138),
(41, 148),
(41, 162),
(41, 209),
(42, 2),
(42, 5),
(42, 6),
(42, 11),
(42, 20),
(42, 23),
(42, 31),
(42, 51),
(42, 75),
(42, 89),
(42, 94),
(42, 121),
(42, 125),
(42, 131),
(42, 143),
(42, 162),
(42, 183),
(42, 207),
(43, 5),
(43, 6),
(43, 11),
(43, 21),
(43, 50),
(43, 66),
(43, 75),
(43, 81),
(43, 125),
(43, 129),
(43, 131),
(43, 136),
(43, 166),
(43, 177),
(43, 180),
(43, 192),
(43, 198),
(44, 2),
(44, 6),
(44, 20),
(44, 21),
(44, 30),
(44, 69),
(44, 81),
(44, 121),
(44, 125),
(44, 129),
(44, 131),
(44, 158),
(44, 166),
(44, 177),
(44, 180),
(44, 190),
(45, 2),
(45, 3),
(45, 6),
(45, 12),
(45, 20),
(45, 21),
(45, 48),
(45, 69),
(45, 81),
(45, 83),
(45, 85),
(45, 114),
(45, 115),
(45, 121),
(45, 125),
(45, 129),
(45, 146),
(45, 166),
(45, 180),
(45, 183),
(46, 12),
(46, 20),
(46, 21),
(46, 48),
(46, 69),
(46, 81),
(46, 83),
(46, 85),
(46, 114),
(46, 125),
(46, 126),
(46, 141),
(46, 146),
(46, 147),
(46, 151),
(46, 158),
(46, 166),
(46, 180);

CREATE TABLE `torna` (
  `azon` int(2) NOT NULL,
  `ev` int(4) DEFAULT NULL,
  `nev` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `helyezes` int(2) DEFAULT NULL,
  `kapitany` varchar(17) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

INSERT INTO `torna` (`azon`, `ev`, `nev`, `helyezes`, `kapitany`) VALUES
(1, 1972, 'Olimpia', 8, 'Albrecht Miklós'),
(2, 1976, 'Olimpia', 6, 'Faludi Mihály'),
(3, 1980, 'Olimpia', 4, 'Faludi Mihály'),
(4, 1988, 'Olimpia', 4, 'Mocsai Lajos'),
(5, 1992, 'Olimpia', 7, 'Joósz Attila'),
(6, 2004, 'Olimpia', 4, 'Skaliczki László'),
(7, 2012, 'Olimpia', 4, 'Mocsai Lajos'),
(8, 2024, 'Olimpia', 10, 'Chema Rodríguez'),
(9, 1958, 'Világbajnokság', 7, 'Cséfay Sándor'),
(10, 1964, 'Világbajnokság', 8, 'Csicsmányi Árpád'),
(11, 1967, 'Világbajnokság', 8, 'Albrecht Miklós'),
(12, 1970, 'Világbajnokság', 8, 'Albrecht Miklós'),
(13, 1974, 'Világbajnokság', 7, 'Faludi Mihály'),
(14, 1978, 'Világbajnokság', 9, 'Faludi Mihály'),
(15, 1982, 'Világbajnokság', 9, 'Faludi Mihály'),
(16, 1986, 'Világbajnokság', 2, 'Mocsai Lajos'),
(17, 1990, 'Világbajnokság', 6, 'Csík János'),
(18, 1993, 'Világbajnokság', 11, 'Kovács László'),
(19, 1995, 'Világbajnokság', 17, 'Kaló Sándor'),
(20, 1997, 'Világbajnokság', 4, 'Vass Sándor'),
(21, 1999, 'Világbajnokság', 11, 'Vass Sándor'),
(22, 2003, 'Világbajnokság', 6, 'Skaliczky László'),
(23, 2007, 'Világbajnokság', 9, 'Skaliczky László'),
(24, 2009, 'Világbajnokság', 6, 'Hajdu János'),
(25, 2011, 'Világbajnokság', 7, 'Mocsai Lajos'),
(26, 2013, 'Világbajnokság', 8, 'Mocsai Lajos'),
(27, 2017, 'Világbajnokság', 7, 'Xavier Sabaté'),
(28, 2019, 'Világbajnokság', 10, 'Csoknyai István'),
(29, 2021, 'Világbajnokság', 5, 'Gulyás István'),
(30, 2023, 'Világbajnokság', 8, 'Chema Rodríguez'),
(31, 2025, 'Világbajnokság', 8, 'Chema Rodríguez'),
(32, 1994, 'Európa-bajnokság', 7, 'Kaló Sándor'),
(33, 1996, 'Európa-bajnokság', 10, 'Kővári Árpád'),
(34, 1998, 'Európa-bajnokság', 6, 'Vass Sándor'),
(35, 2004, 'Európa-bajnokság', 9, 'Skaliczky László'),
(36, 2006, 'Európa-bajnokság', 13, 'Skaliczky László'),
(37, 2008, 'Európa-bajnokság', 8, 'Skaliczky László'),
(38, 2010, 'Európa-bajnokság', 14, 'Csoknyai István'),
(39, 2012, 'Európa-bajnokság', 8, 'Mocsai Lajos'),
(40, 2014, 'Európa-bajnokság', 8, 'Mocsai Lajos'),
(41, 2016, 'Európa-bajnokság', 12, 'Talant Dujsebajev'),
(42, 2018, 'Európa-bajnokság', 14, 'Ljubomir Vranjes'),
(43, 2020, 'Európa-bajnokság', 9, 'Gulyás István'),
(44, 2022, 'Európa-bajnokság', 15, 'Gulyás István'),
(45, 2024, 'Európa-bajnokság', 5, 'Chema Rodríguez'),
(46, 2026, 'Európa-bajnokság', 10, 'Chema Rodríguez');


ALTER TABLE `jatekos`
  ADD PRIMARY KEY (`azon`);

ALTER TABLE `reszvetel`
  ADD PRIMARY KEY (`torna_azon`,`jatekos_azon`);

ALTER TABLE `torna`
  ADD PRIMARY KEY (`azon`);
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 */;
