-- Adatbázis: `asztalitenisz`
CREATE DATABASE `asztalitenisz`
DEFAULT CHARACTER SET utf8
COLLATE utf8_hungarian_ci;
USE `asztalitenisz`;-- --------------------------------------------------------

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

CREATE TABLE `bajnok` (
  `id` int(10) NOT NULL,
  `ev` int(5) NOT NULL,
  `vsz_id` int(1) NOT NULL,
  `jatekos_id` int(5) NOT NULL,
  `egyesulet_id` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

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

INSERT INTO `bajnok` (`id`, `ev`, `vsz_id`, `jatekos_id`, `egyesulet_id`) VALUES
(1, 1905, 1, 1, 1),
(2, 1906, 1, 2, 1),
(3, 1907, 1, 3, 1),
(4, 1908, 1, 3, 1),
(5, 1909, 1, 4, 2),
(6, 1910, 1, 4, 3),
(7, 1911, 1, 5, 3),
(8, 1912, 1, 6, 3),
(9, 1925, 1, 7, 3),
(10, 1926, 1, 7, 3),
(11, 1927, 1, 8, 4),
(12, 1928, 1, 7, 3),
(13, 1929, 1, 9, 3),
(14, 1930, 1, 10, 3),
(15, 1931, 1, 9, 3),
(16, 1932, 1, 10, 3),
(17, 1933, 1, 11, 5),
(18, 1934, 1, 9, 6),
(19, 1935, 1, 12, 6),
(20, 1936, 1, 9, 6),
(21, 1937, 1, 13, 7),
(22, 1938, 1, 10, 6),
(23, 1939, 1, 14, 8),
(24, 1940, 1, 15, 6),
(25, 1941, 1, 16, 9),
(26, 1942, 1, 17, 10),
(27, 1944, 1, 17, 10),
(28, 1946, 1, 16, 11),
(29, 1947, 1, 18, 6),
(30, 1948, 1, 18, 11),
(31, 1949, 1, 19, 12),
(32, 1950, 1, 19, 5),
(33, 1951, 1, 18, 13),
(34, 1952, 1, 19, 14),
(35, 1953, 1, 18, 15),
(36, 1954, 1, 18, 16),
(37, 1955, 1, 19, 17),
(38, 1956, 1, 20, 18),
(39, 1957, 1, 20, 19),
(40, 1958, 1, 20, 19),
(41, 1959, 1, 21, 20),
(42, 1960, 1, 21, 20),
(43, 1961, 1, 21, 20),
(44, 1962, 1, 21, 20),
(45, 1963, 1, 21, 20),
(46, 1964, 1, 21, 20),
(47, 1965, 1, 22, 18),
(48, 1966, 1, 23, 16),
(49, 1967, 1, 24, 21),
(50, 1968, 1, 25, 22),
(51, 1969, 1, 26, 23),
(52, 1970, 1, 25, 18),
(53, 1971, 1, 27, 24),
(54, 1972, 1, 26, 25),
(55, 1973, 1, 26, 25),
(56, 1974, 1, 25, 18),
(57, 1975, 1, 25, 18),
(58, 1976, 1, 26, 18),
(59, 1977, 1, 25, 18),
(60, 1978, 1, 25, 18),
(61, 1979, 1, 26, 18),
(62, 1980, 1, 28, 21),
(63, 1981, 1, 26, 18),
(64, 1982, 1, 26, 18),
(65, 1983, 1, 26, 18),
(66, 1984, 1, 29, 18),
(67, 1985, 1, 26, 18),
(68, 1986, 1, 29, 18),
(69, 1987, 1, 29, 18),
(70, 1988, 1, 30, 26),
(71, 1989, 1, 31, 25),
(72, 1990, 1, 30, 26),
(73, 1991, 1, 31, 25),
(74, 1992, 1, 32, 27),
(75, 1993, 1, 31, 25),
(76, 1994, 1, 30, 28),
(77, 1995, 1, 30, 28),
(78, 1996, 1, 30, 28),
(79, 1997, 1, 31, 29),
(80, 1998, 1, 33, 21),
(81, 1999, 1, 34, 29),
(82, 2000, 1, 35, 30),
(83, 2001, 1, 31, 21),
(84, 2002, 1, 36, 29),
(85, 2003, 1, 35, 30),
(86, 2004, 1, 37, 31),
(87, 2005, 1, 37, 31),
(88, 2006, 1, 38, 32),
(89, 2007, 1, 39, 21),
(90, 2008, 1, 39, 21),
(91, 2009, 1, 39, 33),
(92, 2010, 1, 40, 34),
(93, 2011, 1, 39, 35),
(94, 2012, 1, 37, 36),
(95, 2013, 1, 41, 37),
(96, 2014, 1, 39, 38),
(97, 2015, 1, 37, 36),
(98, 2016, 1, 42, 39),
(99, 2017, 1, 43, 40),
(100, 2018, 1, 44, 40),
(101, 2019, 1, 43, 41),
(102, 2020, 1, 43, 41),
(103, 2021, 1, 42, 42),
(104, 1925, 2, 45, 43),
(105, 1926, 2, 46, 4),
(106, 1927, 2, 46, 4),
(107, 1928, 2, 47, 3),
(108, 1929, 2, 47, 3),
(109, 1930, 2, 47, 3),
(110, 1931, 2, 46, 5),
(111, 1932, 2, 47, 3),
(112, 1933, 2, 47, 3),
(113, 1934, 2, 47, 3),
(114, 1935, 2, 46, 44),
(115, 1936, 2, 48, 45),
(116, 1937, 2, 49, 6),
(117, 1938, 2, 50, 46),
(118, 1939, 2, 51, 44),
(119, 1940, 2, 52, 47),
(120, 1941, 2, 52, 48),
(121, 1942, 2, 52, 48),
(122, 1943, 2, 52, 48),
(123, 1944, 2, 52, 48),
(124, 1946, 2, 52, 49),
(125, 1947, 2, 52, 43),
(126, 1948, 2, 52, 50),
(127, 1949, 2, 52, 50),
(128, 1950, 2, 52, 16),
(129, 1951, 2, 53, 16),
(130, 1952, 2, 53, 51),
(131, 1953, 2, 53, 16),
(132, 1954, 2, 54, 52),
(133, 1955, 2, 55, 53),
(134, 1956, 2, 52, 16),
(135, 1957, 2, 56, 16),
(136, 1958, 2, 55, 16),
(137, 1959, 2, 55, 16),
(138, 1960, 2, 57, 45),
(139, 1961, 2, 58, 16),
(140, 1962, 2, 59, 54),
(141, 1963, 2, 58, 16),
(142, 1964, 2, 59, 54),
(143, 1965, 2, 59, 55),
(144, 1966, 2, 59, 55),
(145, 1967, 2, 55, 16),
(146, 1968, 2, 60, 56),
(147, 1969, 2, 61, 56),
(148, 1970, 2, 60, 56),
(149, 1971, 2, 62, 56),
(150, 1972, 2, 62, 56),
(151, 1973, 2, 63, 56),
(152, 1974, 2, 63, 56),
(153, 1975, 2, 60, 56),
(154, 1976, 2, 63, 56),
(155, 1977, 2, 60, 56),
(156, 1978, 2, 64, 56),
(157, 1979, 2, 64, 56),
(158, 1980, 2, 64, 56),
(159, 1981, 2, 65, 5),
(160, 1982, 2, 64, 56),
(161, 1983, 2, 64, 56),
(162, 1984, 2, 64, 56),
(163, 1985, 2, 64, 56),
(164, 1986, 2, 64, 56),
(165, 1987, 2, 66, 56),
(166, 1988, 2, 64, 56),
(167, 1989, 2, 65, 5),
(168, 1990, 2, 67, 5),
(169, 1991, 2, 68, 56),
(170, 1992, 2, 67, 57),
(171, 1993, 2, 67, 58),
(172, 1994, 2, 69, 5),
(173, 1995, 2, 70, 56),
(174, 1996, 2, 70, 56),
(175, 1997, 2, 70, 56),
(176, 1998, 2, 70, 56),
(177, 1999, 2, 70, 56),
(178, 2000, 2, 70, 56),
(179, 2001, 2, 71, 5),
(180, 2002, 2, 69, 5),
(181, 2003, 2, 72, 56),
(182, 2004, 2, 72, 56),
(183, 2005, 2, 72, 56),
(184, 2006, 2, 73, 56),
(185, 2007, 2, 74, 25),
(186, 2008, 2, 73, 56),
(187, 2009, 2, 72, 59),
(188, 2010, 2, 74, 25),
(189, 2011, 2, 74, 60),
(190, 2012, 2, 73, 61),
(191, 2013, 2, 75, 62),
(192, 2014, 2, 76, 59),
(193, 2015, 2, 73, 61),
(194, 2016, 2, 73, 61),
(195, 2017, 2, 76, 63),
(196, 2018, 2, 76, 63),
(197, 2019, 2, 77, 59),
(198, 2020, 2, 76, 64),
(199, 2021, 2, 78, 65),
(200, 1909, 3, 79, 2),
(201, 1909, 3, 80, 2),
(202, 1911, 3, 4, 3),
(203, 1911, 3, 5, 3),
(204, 1912, 3, 81, 3),
(205, 1912, 3, 82, 3),
(206, 1925, 3, 7, 3),
(207, 1925, 3, 83, 3),
(208, 1926, 3, 7, 3),
(209, 1926, 3, 84, 66),
(210, 1927, 3, 85, 4),
(211, 1927, 3, 8, 4),
(212, 1928, 3, 7, 3),
(213, 1928, 3, 83, 3),
(214, 1929, 3, 10, 67),
(215, 1929, 3, 9, 3),
(216, 1930, 3, 10, 3),
(217, 1930, 3, 9, 3),
(218, 1931, 3, 10, 3),
(219, 1931, 3, 9, 3),
(220, 1932, 3, 10, 3),
(221, 1932, 3, 9, 3),
(222, 1933, 3, 86, 3),
(223, 1933, 3, 87, 3),
(224, 1934, 3, 9, 6),
(225, 1934, 3, 12, 6),
(226, 1935, 3, 9, 6),
(227, 1935, 3, 12, 6),
(228, 1936, 3, 9, 6),
(229, 1936, 3, 85, 45),
(230, 1937, 3, 88, 7),
(231, 1937, 3, 14, 7),
(232, 1938, 3, 10, 6),
(233, 1938, 3, 86, 6),
(234, 1939, 3, 16, 8),
(235, 1939, 3, 14, 8),
(236, 1940, 3, 16, 8),
(237, 1940, 3, 14, 8),
(238, 1941, 3, 14, 8),
(239, 1941, 3, 89, 48),
(240, 1942, 3, 17, 10),
(241, 1942, 3, 90, 10),
(242, 1943, 3, 91, 9),
(243, 1943, 3, 16, 9),
(244, 1944, 3, 16, 9),
(245, 1944, 3, 17, 10),
(246, 1946, 3, 16, 11),
(247, 1946, 3, 18, 43),
(248, 1947, 3, 16, 11),
(249, 1947, 3, 18, 6),
(250, 1948, 3, 16, 11),
(251, 1948, 3, 18, 11),
(252, 1949, 3, 19, 12),
(253, 1949, 3, 18, 11),
(254, 1950, 3, 16, 68),
(255, 1950, 3, 18, 68),
(256, 1951, 3, 19, 69),
(257, 1951, 3, 18, 13),
(258, 1952, 3, 92, 14),
(259, 1952, 3, 19, 14),
(260, 1953, 3, 19, 69),
(261, 1953, 3, 18, 15),
(262, 1954, 3, 93, 70),
(263, 1954, 3, 94, 70),
(264, 1955, 3, 19, 17),
(265, 1955, 3, 18, 16),
(266, 1956, 3, 95, 16),
(267, 1956, 3, 20, 18),
(268, 1957, 3, 96, 19),
(269, 1957, 3, 20, 19),
(270, 1958, 3, 97, 20),
(271, 1958, 3, 98, 16),
(272, 1959, 3, 21, 20),
(273, 1959, 3, 98, 16),
(274, 1960, 3, 21, 20),
(275, 1960, 3, 18, 16),
(276, 1961, 3, 21, 20),
(277, 1961, 3, 18, 16),
(278, 1962, 3, 99, 16),
(279, 1962, 3, 21, 20),
(280, 1963, 3, 100, 16),
(281, 1963, 3, 21, 20),
(282, 1964, 3, 22, 18),
(283, 1964, 3, 100, 16),
(284, 1965, 3, 23, 16),
(285, 1965, 3, 101, 24),
(286, 1966, 3, 24, 21),
(287, 1966, 3, 23, 16),
(288, 1967, 3, 25, 22),
(289, 1967, 3, 21, 21),
(290, 1968, 3, 102, 71),
(291, 1968, 3, 103, 71),
(292, 1969, 3, 104, 18),
(293, 1969, 3, 26, 23),
(294, 1970, 3, 25, 18),
(295, 1970, 3, 26, 23),
(296, 1971, 3, 25, 18),
(297, 1971, 3, 26, 23),
(298, 1972, 3, 25, 18),
(299, 1972, 3, 26, 25),
(300, 1973, 3, 25, 18),
(301, 1973, 3, 26, 25),
(302, 1974, 3, 25, 18),
(303, 1974, 3, 26, 25),
(304, 1975, 3, 105, 21),
(305, 1975, 3, 25, 18),
(306, 1976, 3, 103, 18),
(307, 1976, 3, 26, 18),
(308, 1977, 3, 25, 18),
(309, 1977, 3, 26, 18),
(310, 1978, 3, 25, 18),
(311, 1978, 3, 26, 18),
(312, 1979, 3, 25, 18),
(313, 1979, 3, 26, 18),
(314, 1980, 3, 106, 21),
(315, 1980, 3, 29, 18),
(316, 1981, 3, 106, 21),
(317, 1981, 3, 29, 18),
(318, 1982, 3, 105, 21),
(319, 1982, 3, 25, 18),
(320, 1983, 3, 107, 18),
(321, 1983, 3, 29, 18),
(322, 1984, 3, 29, 18),
(323, 1984, 3, 26, 18),
(324, 1985, 3, 108, 18),
(325, 1985, 3, 107, 18),
(326, 1986, 3, 107, 18),
(327, 1986, 3, 109, 18),
(328, 1987, 3, 29, 18),
(329, 1987, 3, 30, 26),
(330, 1988, 3, 110, 25),
(331, 1988, 3, 31, 25),
(332, 1989, 3, 111, 72),
(333, 1989, 3, 112, 72),
(334, 1990, 3, 113, 21),
(335, 1990, 3, 114, 21),
(336, 1991, 3, 113, 21),
(337, 1991, 3, 114, 21),
(338, 1992, 3, 113, 25),
(339, 1992, 3, 114, 73),
(340, 1993, 3, 112, 27),
(341, 1993, 3, 110, 27),
(342, 1994, 3, 113, 74),
(343, 1994, 3, 115, 75),
(344, 1995, 3, 31, 25),
(345, 1995, 3, 115, 25),
(346, 1996, 3, 114, 28),
(347, 1996, 3, 30, 28),
(348, 1997, 3, 110, 29),
(349, 1997, 3, 31, 29),
(350, 1998, 3, 34, 76),
(351, 1998, 3, 31, 77),
(352, 1999, 3, 34, 29),
(353, 1999, 3, 31, 77),
(354, 2000, 3, 32, 74),
(355, 2000, 3, 33, 76),
(356, 2001, 3, 36, 76),
(357, 2001, 3, 116, 76),
(358, 2002, 3, 36, 29),
(359, 2002, 3, 116, 29),
(360, 2003, 3, 117, 30),
(361, 2003, 3, 35, 30),
(362, 2004, 3, 34, 78),
(363, 2004, 3, 37, 31),
(364, 2005, 3, 34, 78),
(365, 2005, 3, 37, 31),
(366, 2006, 3, 32, 79),
(367, 2006, 3, 40, 79),
(368, 2007, 3, 108, 80),
(369, 2007, 3, 116, 81),
(370, 2008, 3, 32, 79),
(371, 2008, 3, 40, 79),
(372, 2009, 3, 32, 82),
(373, 2009, 3, 40, 82),
(374, 2010, 3, 32, 83),
(375, 2010, 3, 40, 34),
(376, 2011, 3, 118, 36),
(377, 2011, 3, 37, 36),
(378, 2012, 3, 119, 83),
(379, 2012, 3, 36, 84),
(380, 2013, 3, 36, 85),
(381, 2013, 3, 116, 32),
(382, 2014, 3, 36, 86),
(383, 2014, 3, 116, 81),
(384, 2015, 3, 120, 36),
(385, 2015, 3, 37, 36),
(386, 2016, 3, 121, 87),
(387, 2016, 3, 44, 88),
(388, 2017, 3, 122, 89),
(389, 2017, 3, 44, 40),
(390, 2018, 3, 43, 40),
(391, 2018, 3, 122, 89),
(392, 2019, 3, 123, 78),
(393, 2019, 3, 37, 36),
(394, 2020, 3, 43, 41),
(395, 2020, 3, 122, 89),
(396, 2021, 3, 32, 90),
(397, 2021, 3, 124, 91),
(398, 1929, 4, 46, 5),
(399, 1929, 4, 47, 3),
(400, 1930, 4, 46, 5),
(401, 1930, 4, 47, 3),
(402, 1931, 4, 49, 92),
(403, 1931, 4, 46, 5),
(404, 1932, 4, 46, 5),
(405, 1932, 4, 47, 3),
(406, 1933, 4, 46, 5),
(407, 1933, 4, 47, 3),
(408, 1934, 4, 49, 6),
(409, 1934, 4, 47, 3),
(410, 1935, 4, 49, 6),
(411, 1935, 4, 46, 44),
(412, 1936, 4, 49, 6),
(413, 1936, 4, 47, 3),
(414, 1937, 4, 49, 6),
(415, 1937, 4, 125, 7),
(416, 1938, 4, 126, 6),
(417, 1938, 4, 125, 7),
(418, 1939, 4, 51, 44),
(419, 1939, 4, 47, 3),
(420, 1940, 4, 46, 44),
(421, 1940, 4, 52, 47),
(422, 1941, 4, 127, 93),
(423, 1941, 4, 128, 94),
(424, 1942, 4, 129, 95),
(425, 1942, 4, 52, 48),
(426, 1943, 4, 129, 96),
(427, 1943, 4, 52, 48),
(428, 1944, 4, 48, 97),
(429, 1944, 4, 52, 48),
(430, 1946, 4, 126, 11),
(431, 1946, 4, 52, 49),
(432, 1947, 4, 130, 98),
(433, 1947, 4, 52, 43),
(434, 1948, 4, 48, 50),
(435, 1948, 4, 52, 50),
(436, 1949, 4, 48, 50),
(437, 1949, 4, 52, 50),
(438, 1950, 4, 131, 16),
(439, 1950, 4, 52, 16),
(440, 1951, 4, 48, 16),
(441, 1951, 4, 53, 16),
(442, 1952, 4, 48, 51),
(443, 1952, 4, 53, 51),
(444, 1953, 4, 132, 99),
(445, 1953, 4, 53, 16),
(446, 1954, 4, 54, 52),
(447, 1954, 4, 53, 16),
(448, 1955, 4, 133, 100),
(449, 1955, 4, 134, 53),
(450, 1956, 4, 134, 16),
(451, 1956, 4, 56, 16),
(452, 1957, 4, 135, 45),
(453, 1957, 4, 55, 16),
(454, 1958, 4, 56, 16),
(455, 1958, 4, 136, 16),
(456, 1959, 4, 135, 45),
(457, 1959, 4, 55, 16),
(458, 1960, 4, 56, 16),
(459, 1960, 4, 136, 16),
(460, 1961, 4, 59, 45),
(461, 1961, 4, 58, 16),
(462, 1962, 4, 137, 45),
(463, 1962, 4, 56, 16),
(464, 1963, 4, 137, 45),
(465, 1963, 4, 58, 16),
(466, 1964, 4, 59, 54),
(467, 1964, 4, 58, 16),
(468, 1965, 4, 138, 45),
(469, 1965, 4, 58, 16),
(470, 1966, 4, 139, 55),
(471, 1966, 4, 59, 55),
(472, 1967, 4, 60, 56),
(473, 1967, 4, 59, 55),
(474, 1968, 4, 60, 56),
(475, 1968, 4, 138, 45),
(476, 1969, 4, 62, 101),
(477, 1969, 4, 140, 56),
(478, 1970, 4, 61, 56),
(479, 1970, 4, 60, 56),
(480, 1971, 4, 63, 56),
(481, 1971, 4, 62, 56),
(482, 1972, 4, 63, 56),
(483, 1972, 4, 62, 56),
(484, 1973, 4, 141, 45),
(485, 1973, 4, 142, 102),
(486, 1974, 4, 63, 56),
(487, 1974, 4, 62, 56),
(488, 1975, 4, 63, 56),
(489, 1975, 4, 62, 56),
(490, 1976, 4, 143, 55),
(491, 1976, 4, 142, 55),
(492, 1977, 4, 62, 56),
(493, 1977, 4, 144, 56),
(494, 1978, 4, 64, 56),
(495, 1978, 4, 143, 55),
(496, 1979, 4, 145, 103),
(497, 1979, 4, 146, 103),
(498, 1980, 4, 145, 103),
(499, 1980, 4, 146, 103),
(500, 1981, 4, 145, 103),
(501, 1981, 4, 146, 103),
(502, 1982, 4, 145, 103),
(503, 1982, 4, 146, 103),
(504, 1983, 4, 145, 103),
(505, 1983, 4, 146, 103),
(506, 1984, 4, 147, 56),
(507, 1984, 4, 148, 56),
(508, 1985, 4, 64, 56),
(509, 1985, 4, 67, 5),
(510, 1986, 4, 149, 56),
(511, 1986, 4, 150, 56),
(512, 1987, 4, 145, 103),
(513, 1987, 4, 146, 103),
(514, 1988, 4, 65, 5),
(515, 1988, 4, 67, 5),
(516, 1989, 4, 65, 5),
(517, 1989, 4, 67, 5),
(518, 1990, 4, 151, 104),
(519, 1990, 4, 66, 5),
(520, 1991, 4, 149, 56),
(521, 1991, 4, 152, 56),
(522, 1992, 4, 68, 56),
(523, 1992, 4, 67, 57),
(524, 1993, 4, 69, 5),
(525, 1993, 4, 67, 58),
(526, 1994, 4, 70, 56),
(527, 1994, 4, 67, 58),
(528, 1995, 4, 70, 56),
(529, 1995, 4, 67, 58),
(530, 1996, 4, 70, 56),
(531, 1996, 4, 67, 58),
(532, 1997, 4, 70, 56),
(533, 1997, 4, 153, 56),
(534, 1998, 4, 70, 56),
(535, 1998, 4, 67, 58),
(536, 1999, 4, 70, 56),
(537, 1999, 4, 67, 58),
(538, 2000, 4, 71, 5),
(539, 2000, 4, 69, 5),
(540, 2001, 4, 71, 5),
(541, 2001, 4, 153, 56),
(542, 2002, 4, 74, 105),
(543, 2002, 4, 72, 56),
(544, 2003, 4, 71, 56),
(545, 2003, 4, 72, 56),
(546, 2004, 4, 154, 29),
(547, 2004, 4, 153, 29),
(548, 2005, 4, 73, 56),
(549, 2005, 4, 72, 56),
(550, 2006, 4, 155, 5),
(551, 2006, 4, 69, 5),
(552, 2007, 4, 73, 56),
(553, 2007, 4, 77, 56),
(554, 2008, 4, 73, 56),
(555, 2008, 4, 156, 56),
(556, 2009, 4, 73, 106),
(557, 2009, 4, 156, 107),
(558, 2010, 4, 73, 106),
(559, 2010, 4, 156, 107),
(560, 2011, 4, 77, 59),
(561, 2011, 4, 74, 60),
(562, 2012, 4, 74, 61),
(563, 2012, 4, 73, 61),
(564, 2013, 4, 74, 61),
(565, 2013, 4, 73, 61),
(566, 2014, 4, 76, 59),
(567, 2014, 4, 77, 59),
(568, 2015, 4, 76, 108),
(569, 2015, 4, 77, 59),
(570, 2016, 4, 157, 25),
(571, 2016, 4, 75, 25),
(572, 2017, 4, 76, 63),
(573, 2017, 4, 77, 59),
(574, 2018, 4, 76, 63),
(575, 2018, 4, 77, 59),
(576, 2019, 4, 78, 63),
(577, 2019, 4, 158, 63),
(578, 2020, 4, 159, 65),
(579, 2020, 4, 75, 65),
(580, 2021, 4, 72, 59),
(581, 2021, 4, 76, 64),
(582, 1925, 5, 160, 109),
(583, 1925, 5, 161, 109),
(584, 1926, 5, 7, 3),
(585, 1926, 5, 162, 3),
(586, 1927, 5, 85, 4),
(587, 1927, 5, 46, 4),
(588, 1928, 5, 7, 3),
(589, 1928, 5, 47, 3),
(590, 1929, 5, 9, 3),
(591, 1929, 5, 47, 3),
(592, 1930, 5, 10, 3),
(593, 1930, 5, 46, 5),
(594, 1931, 5, 10, 3),
(595, 1931, 5, 46, 5),
(596, 1932, 5, 10, 3),
(597, 1932, 5, 46, 5),
(598, 1933, 5, 86, 3),
(599, 1933, 5, 47, 3),
(600, 1934, 5, 9, 6),
(601, 1934, 5, 47, 3),
(602, 1935, 5, 9, 6),
(603, 1935, 5, 46, 44),
(604, 1936, 5, 85, 45),
(605, 1936, 5, 126, 45),
(606, 1937, 5, 163, 6),
(607, 1937, 5, 125, 7),
(608, 1938, 5, 10, 6),
(609, 1938, 5, 125, 7),
(610, 1939, 5, 14, 8),
(611, 1939, 5, 51, 44),
(612, 1940, 5, 89, 110),
(613, 1940, 5, 52, 47),
(614, 1941, 5, 18, 9),
(615, 1941, 5, 129, 95),
(616, 1942, 5, 18, 48),
(617, 1942, 5, 129, 95),
(618, 1943, 5, 89, 48),
(619, 1943, 5, 52, 48),
(620, 1944, 5, 18, 48),
(621, 1944, 5, 52, 48),
(622, 1946, 5, 89, 49),
(623, 1946, 5, 52, 49),
(624, 1947, 5, 16, 11),
(625, 1947, 5, 52, 43),
(626, 1948, 5, 16, 11),
(627, 1948, 5, 52, 50),
(628, 1949, 5, 18, 11),
(629, 1949, 5, 52, 50),
(630, 1950, 5, 18, 68),
(631, 1950, 5, 52, 16),
(632, 1951, 5, 18, 13),
(633, 1951, 5, 53, 16),
(634, 1952, 5, 89, 51),
(635, 1952, 5, 53, 51),
(636, 1953, 5, 19, 69),
(637, 1953, 5, 53, 16),
(638, 1954, 5, 19, 111),
(639, 1954, 5, 55, 99),
(640, 1955, 5, 95, 16),
(641, 1955, 5, 55, 53),
(642, 1956, 5, 18, 16),
(643, 1956, 5, 52, 16),
(644, 1957, 5, 21, 20),
(645, 1957, 5, 136, 16),
(646, 1958, 5, 18, 16),
(647, 1958, 5, 55, 16),
(648, 1959, 5, 98, 16),
(649, 1959, 5, 55, 16),
(650, 1960, 5, 21, 20),
(651, 1960, 5, 55, 16),
(652, 1961, 5, 18, 16),
(653, 1961, 5, 58, 16),
(654, 1962, 5, 99, 16),
(655, 1962, 5, 58, 16),
(656, 1963, 5, 100, 16),
(657, 1963, 5, 58, 16),
(658, 1964, 5, 24, 20),
(659, 1964, 5, 59, 54),
(660, 1965, 5, 101, 24),
(661, 1965, 5, 59, 55),
(662, 1966, 5, 24, 21),
(663, 1966, 5, 59, 55),
(664, 1967, 5, 24, 21),
(665, 1967, 5, 59, 55),
(666, 1968, 5, 25, 22),
(667, 1968, 5, 55, 16),
(668, 1969, 5, 25, 22),
(669, 1969, 5, 60, 56),
(670, 1970, 5, 25, 18),
(671, 1970, 5, 61, 56),
(672, 1971, 5, 25, 18),
(673, 1971, 5, 62, 56),
(674, 1972, 5, 25, 18),
(675, 1972, 5, 62, 56),
(676, 1973, 5, 26, 25),
(677, 1973, 5, 142, 102),
(678, 1974, 5, 25, 18),
(679, 1974, 5, 62, 56),
(680, 1975, 5, 25, 18),
(681, 1975, 5, 62, 56),
(682, 1976, 5, 106, 112),
(683, 1976, 5, 164, 56),
(684, 1977, 5, 26, 18),
(685, 1977, 5, 144, 56),
(686, 1978, 5, 26, 18),
(687, 1978, 5, 144, 56),
(688, 1979, 5, 26, 18),
(689, 1979, 5, 65, 5),
(690, 1980, 5, 26, 18),
(691, 1980, 5, 62, 56),
(692, 1981, 5, 29, 18),
(693, 1981, 5, 65, 5),
(694, 1982, 5, 25, 18),
(695, 1982, 5, 144, 56),
(696, 1983, 5, 29, 18),
(697, 1983, 5, 64, 56),
(698, 1984, 5, 107, 18),
(699, 1984, 5, 64, 56),
(700, 1985, 5, 107, 18),
(701, 1985, 5, 64, 56),
(702, 1986, 5, 106, 21),
(703, 1986, 5, 65, 5),
(704, 1987, 5, 29, 18),
(705, 1987, 5, 66, 56),
(706, 1988, 5, 29, 18),
(707, 1988, 5, 66, 56),
(708, 1989, 5, 32, 21),
(709, 1989, 5, 65, 5),
(710, 1990, 5, 28, 113),
(711, 1990, 5, 165, 114),
(712, 1991, 5, 110, 115),
(713, 1991, 5, 68, 56),
(714, 1992, 5, 32, 27),
(715, 1992, 5, 69, 5),
(716, 1993, 5, 166, 25),
(717, 1993, 5, 67, 58),
(718, 1994, 5, 166, 116),
(719, 1994, 5, 70, 56),
(720, 1995, 5, 114, 28),
(721, 1995, 5, 152, 56),
(722, 1996, 5, 31, 25),
(723, 1996, 5, 69, 5),
(724, 1997, 5, 33, 21),
(725, 1997, 5, 70, 56),
(726, 1998, 5, 34, 76),
(727, 1998, 5, 71, 29),
(728, 1999, 5, 116, 29),
(729, 1999, 5, 167, 29),
(730, 2000, 5, 32, 74),
(731, 2000, 5, 153, 56),
(732, 2001, 5, 36, 76),
(733, 2001, 5, 154, 29),
(734, 2002, 5, 166, 29),
(735, 2002, 5, 70, 117),
(736, 2003, 5, 32, 74),
(737, 2003, 5, 153, 29),
(738, 2004, 5, 32, 74),
(739, 2004, 5, 153, 29),
(740, 2005, 5, 117, 118),
(741, 2005, 5, 168, 30),
(742, 2006, 5, 38, 32),
(743, 2006, 5, 77, 56),
(744, 2007, 5, 36, 36),
(745, 2007, 5, 154, 25),
(746, 2008, 5, 38, 21),
(747, 2008, 5, 77, 56),
(748, 2009, 5, 32, 82),
(749, 2009, 5, 69, 5),
(750, 2013, 5, 120, 119),
(751, 2013, 5, 76, 59),
(752, 2015, 5, 43, 120),
(753, 2015, 5, 77, 59),
(754, 2016, 5, 169, 34),
(755, 2016, 5, 157, 25),
(756, 2017, 5, 120, 121),
(757, 2017, 5, 76, 63),
(758, 2018, 5, 44, 40),
(759, 2018, 5, 77, 59),
(760, 2019, 5, 37, 36),
(761, 2019, 5, 170, 65),
(762, 2020, 5, 43, 41),
(763, 2020, 5, 77, 59);

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

CREATE TABLE `egyesulet` (
  `id` int(5) NOT NULL,
  `nev` varchar(30) COLLATE utf8mb4_hungarian_ci NOT NULL,
  `orszag` varchar(50) COLLATE utf8mb4_hungarian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

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

INSERT INTO `egyesulet` (`id`, `nev`, `orszag`) VALUES
(1, 'MAFC', 'Magyarország'),
(2, 'ZRY', 'Magyarország'),
(3, 'MTK', 'Magyarország'),
(4, 'Nemzeti SC', 'Magyarország'),
(5, 'BSE', 'Magyarország'),
(6, 'Duna SC', 'Magyarország'),
(7, 'VAC', 'Magyarország'),
(8, 'Újpesti TE', 'Magyarország'),
(9, 'Weiss Manfréd TK', 'Magyarország'),
(10, 'Szabadkai ATC', 'Magyarország'),
(11, 'Mezőkémia SE', 'Magyarország'),
(12, 'Elida SC', 'Magyarország'),
(13, 'Bp. Honvéd', 'Magyarország'),
(14, 'Dózsa SE', 'Magyarország'),
(15, 'Munkaerőtartalékok SE', 'Magyarország'),
(16, 'Bp. Vörös Meteor', 'Magyarország'),
(17, 'Bp. Petőfi', 'Magyarország'),
(18, 'Bp. Spartacus', 'Magyarország'),
(19, 'Egyetértés SC', 'Magyarország'),
(20, 'Vasútépítő Törekvés', 'Magyarország'),
(21, 'BVSC', 'Magyarország'),
(22, 'Diósgyőri VTK', 'Magyarország'),
(23, 'Bp. Postás', 'Magyarország'),
(24, 'VM Közért', 'Magyarország'),
(25, 'Postás SE', 'Magyarország'),
(26, 'Ceglédi VSE', 'Magyarország'),
(27, 'Kiskunfélegyházi Zöldmező SZSE', 'Magyarország'),
(28, 'Kiskunfélegyházi AC', 'Magyarország'),
(29, 'Postás-Matáv SE', 'Magyarország'),
(30, 'Kecskeméti Spartacus', 'Magyarország'),
(31, 'TTC Langenlois', 'Ausztria'),
(32, 'KSV Kapfenberg', 'Ausztria'),
(33, 'Levallois SC', 'Franciaország'),
(34, 'PTE-Pécsi EAC', 'Magyarország'),
(35, 'Borussia Düsseldorf', 'Németország'),
(36, 'Celldömölki VSE', 'Magyarország'),
(37, 'TT St. Louis', 'Franciaország'),
(38, 'TTC Stockerau', 'Ausztria'),
(39, '1. FC Saarbrücken', 'Németország'),
(40, 'Borussia Dortmund', 'Németország'),
(41, 'SPG Wels', 'Ausztria'),
(42, 'Amiens STT', 'Franciaország'),
(43, 'egyesületen kívüli', 'Magyarország'),
(44, 'Pénzintézeti SL', 'Magyarország'),
(45, 'Ferencvárosi TC', 'Magyarország'),
(46, 'Aurora București', 'Románia'),
(47, 'Miskolci Előre', 'Magyarország'),
(48, 'Diósgyőri MÁVAG', 'Magyarország'),
(49, 'Miskolci MTE', 'Magyarország'),
(50, 'Elektromos MSE', 'Magyarország'),
(51, 'SZOT', 'Magyarország'),
(52, 'Progresul București', 'Románia'),
(53, 'Bp. Vasas', 'Magyarország'),
(54, 'Földgép SK', 'Magyarország'),
(55, '31. sz. Építők', 'Magyarország'),
(56, 'Statisztika Petőfi SC', 'Magyarország'),
(57, 'Interagent Kikinda', 'Jugoszlávia'),
(58, 'FC Langweid', 'Németország'),
(59, 'Budaörsi SC', 'Magyarország'),
(60, 'TTC Berlin', 'Németország'),
(61, 'TTC Berlin Eastside', 'Németország'),
(62, 'SV DJK Kolbermoor', 'Németország'),
(63, 'Szekszárd AC', 'Magyarország'),
(64, 'CP Lys-lez-Lannoy', 'Franciaország'),
(65, 'Budapesti Erdért SE', 'Magyarország'),
(66, 'Wiener AC', 'Ausztria'),
(67, 'KISOK', 'Magyarország'),
(68, 'Központi Lombik', 'Magyarország'),
(69, 'Bp. Dózsa', 'Magyarország'),
(70, 'Kaposvári Vörös Meteor', 'Magyarország'),
(71, 'Aknamélyítő Bányász', 'Magyarország'),
(72, 'Ganz-MÁVAG VSE', 'Magyarország'),
(73, 'Békéscsabai Konzerv SE', 'Magyarország'),
(74, 'VÖEST Linz', 'Ausztria'),
(75, 'TuS 08 Reinberg', 'Németország'),
(76, 'LRI-Malév SC', 'Magyarország'),
(77, 'TTF Bad Honnef', 'Németország'),
(78, 'SV Plüderhausen', 'Németország'),
(79, 'ASKÖ Linz Altstadt', 'Ausztria'),
(80, 'TSV Untermberg', 'Németország'),
(81, 'SPG Ligist/Graz', 'Ausztria'),
(82, 'TTC Sachsen Döbeln', 'Németország'),
(83, 'UTTC Oberwart', 'Ausztria'),
(84, 'Crvena zvezda Beograd', 'Szerbia'),
(85, 'USD Apuania Carrara TT', 'Olaszország'),
(86, 'Komló Sport', 'Magyarország'),
(87, 'TTC Frickenhausen', 'Németország'),
(88, 'TTC 1946 Weinheim', 'Németország'),
(89, 'TTC Ober-Erlenbach', 'Németország'),
(90, 'Szegedi AC', 'Magyarország'),
(91, 'BVSC-Zugló', 'Magyarország'),
(92, 'Kitartás EAC', 'Magyarország'),
(93, 'MOVE Széchenyi TE', 'Magyarország'),
(94, 'Ceglédi MOVE', 'Magyarország'),
(95, 'Kolozsvári KASE', 'Magyarország'),
(96, 'Kolozsvári Postás', 'Magyarország'),
(97, 'Győri ETO', 'Magyarország'),
(98, 'Austria Wien', 'Ausztria'),
(99, 'Vasas MÁVAG', 'Magyarország'),
(100, 'Bp. Kinizsi', 'Magyarország'),
(101, 'KSI', 'Magyarország'),
(102, 'Miskolci Építők MTE', 'Magyarország'),
(103, 'Tolnai Vörös Lobogó', 'Magyarország'),
(104, 'Erzsébeti ATSE', 'Magyarország'),
(105, 'Orosházi MTK', 'Magyarország'),
(106, '3B Berlin', 'Németország'),
(107, 'TuS Bad Driburg', 'Németország'),
(108, 'SVNÖ Ströck', 'Ausztria'),
(109, 'BBTE', 'Magyarország'),
(110, 'Miskolci LE', 'Magyarország'),
(111, 'IX. ker. Lendület', 'Magyarország'),
(112, 'Honvéd Szondi SE', 'Magyarország'),
(113, 'Kaposplast SC', 'Magyarország'),
(114, 'Fővárosi Vízművek SK', 'Magyarország'),
(115, 'Kiskunfélegyházi Lenin TSZ SK', 'Magyarország'),
(116, 'Spvg Niedermark', 'Németország'),
(117, 'TSV Busenbach', 'Németország'),
(118, 'ASVÖ Lavamünd', 'Ausztria'),
(119, 'Københavns BTK', 'Dánia'),
(120, 'TTC Bietigheim-Bissingen', 'Németország'),
(121, 'Eslövs AI', 'Svédország');

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

CREATE TABLE `jatekos` (
  `id` int(10) NOT NULL,
  `nev` varchar(30) COLLATE utf8mb4_hungarian_ci NOT NULL,
  `neme` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

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

INSERT INTO `jatekos` (`id`, `nev`, `neme`) VALUES
(1, 'Redlich Béla', 1),
(2, 'Tolnay József', 1),
(3, 'László Albert', 1),
(4, 'Jacobi Roland', 1),
(5, 'Mechlovits Ármin', 1),
(6, 'Pécsi Dániel', 1),
(7, 'Mechlovits Zoltán', 1),
(8, 'Glancz Sándor', 1),
(9, 'Szabados Miklós', 1),
(10, 'Barna Viktor', 1),
(11, 'Dávid Lajos', 1),
(12, 'Házi Tibor', 1),
(13, 'Gárdos György', 1),
(14, 'Schmiedl Jenő', 1),
(15, 'Barna Tibor', 1),
(16, 'Soós Ferenc', 1),
(17, 'Harangozó Tibor', 1),
(18, 'Sidó Ferenc', 1),
(19, 'Kóczián József', 1),
(20, 'Gyetvai Elemér', 1),
(21, 'Berczik Zoltán', 1),
(22, 'Pigniczki László', 1),
(23, 'Harangi Sándor', 1),
(24, 'Rózsás Péter', 1),
(25, 'Jónyer István', 1),
(26, 'Klampár Tibor', 1),
(27, 'Beleznay Mátyás', 1),
(28, 'Frank Béla', 1),
(29, 'Kriston Zsolt', 1),
(30, 'Harczi Zsolt', 1),
(31, 'Németh Károly', 1),
(32, 'Vitsek Iván', 1),
(33, 'Pagonyi Róbert', 1),
(34, 'Pázsy Ferenc', 1),
(35, 'Demeter Lehel', 1),
(36, 'Lindner Ádám', 1),
(37, 'Fazekas Péter', 1),
(38, 'Zwickl Dániel', 1),
(39, 'Jakab János', 1),
(40, 'Muskó Péter', 1),
(41, 'Pattantyús Ádám', 1),
(42, 'Lakatos Tamás', 1),
(43, 'Szudi Ádám', 1),
(44, 'Majoros Bence', 1),
(45, 'Kornfeld Mária', 0),
(46, 'Sipos Anna', 0),
(47, 'Klucsikné Mednyánszky Mária', 0),
(48, 'Király Ilona', 0),
(49, 'Gál Magda', 0),
(50, 'Angelica Adelstein', 0),
(51, 'dr. Biróné Sipos Anna', 0),
(52, 'Farkas Gizella', 0),
(53, 'Gervainé Farkas Gizella', 0),
(54, 'Angelica Rozeanu', 0),
(55, 'Kóczián Éva', 0),
(56, 'Kerekes Imréné', 0),
(57, 'Máthé Sára', 0),
(58, 'Földyné Kóczián Éva', 0),
(59, 'Lukács Attiláné', 0),
(60, 'Kisházi Beatrix', 0),
(61, 'Papp Angéla', 0),
(62, 'Magos Judit', 0),
(63, 'Lotaller Henriette', 0),
(64, 'Oláh Zsuzsa', 0),
(65, 'Urbán Edit', 0),
(66, 'Káhn Szilvia', 0),
(67, 'Bátorfi Csilla', 0),
(68, 'Wirth Gabriella', 0),
(69, 'Braun Éva', 0),
(70, 'Tóth Krisztina', 0),
(71, 'Molnár Zita', 0),
(72, 'Fazekas Mária', 0),
(73, 'Póta Georgina', 0),
(74, 'Lovas Petra', 0),
(75, 'Ambrus Krisztina', 0),
(76, 'Madarász Dóra', 0),
(77, 'Pergel Szandra', 0),
(78, 'Imre Leila', 0),
(79, 'Biró Gyula', 1),
(80, 'Balassa Loránd', 1),
(81, 'Székely Zoltán', 1),
(82, 'Nádasi Gusztáv', 1),
(83, 'dr. Pécsi Dániel', 1),
(84, 'Eduard Freudenheim', 1),
(85, 'Bellák László', 1),
(86, 'Boros István', 1),
(87, 'Nyitray Béla', 1),
(88, 'Benkő Károly', 1),
(89, 'Farkas József', 1),
(90, 'Harangozó Vilmos', 1),
(91, 'Till Károly', 1),
(92, 'Halász János', 1),
(93, 'Morvay Lajos', 1),
(94, 'Antal Lajos', 1),
(95, 'Szepesi Kálmán', 1),
(96, 'Csender Jenő', 1),
(97, 'Bubonyi Zoltán', 1),
(98, 'Földy László', 1),
(99, 'dr. Péterfy Miklós', 1),
(100, 'Faházi János', 1),
(101, 'Harcsár István', 1),
(102, 'Volentics Lajos', 1),
(103, 'Papp József', 1),
(104, 'Tímár Ferenc', 1),
(105, 'Gergely Gábor', 1),
(106, 'Takács János', 1),
(107, 'Molnár János', 1),
(108, 'Simon Ferenc', 1),
(109, 'Káposztás Zoltán', 1),
(110, 'Varga Sándor', 1),
(111, 'Aranyosi Péter', 1),
(112, 'Szosznyák Attila', 1),
(113, 'Turbók Attila', 1),
(114, 'Somosi Miklós', 1),
(115, 'Holló Zsolt', 1),
(116, 'Gerold Gábor', 1),
(117, 'Zoltán Zoltán', 1),
(118, 'Kriston Dániel', 1),
(119, 'Marsi Márton', 1),
(120, 'Kosiba Dániel', 1),
(121, 'Szita Márton', 1),
(122, 'Ecseki Nándor', 1),
(123, 'Magyar László', 1),
(124, 'Terék Norbert', 1),
(125, 'Beregi Dóra', 0),
(126, 'Ferenczy Ida', 0),
(127, 'Ábrahám Piroska', 0),
(128, 'Aranyi Ottilia', 0),
(129, 'Kolozsvári Sára', 0),
(130, 'Gertrude Pritzi', 0),
(131, 'Farkas Anna', 0),
(132, 'Almási Ágnes', 0),
(133, 'Sági Edit', 0),
(134, 'Jávor Károlyné', 0),
(135, 'Mossóczy Lívia', 0),
(136, 'Lantosné Farkas Gizella', 0),
(137, 'Heirits Erzsébet', 0),
(138, 'Jurikné Heirits Erzsébet', 0),
(139, 'Faludi Júlia', 0),
(140, 'Juhos Eszter', 0),
(141, 'Szendy Katalin', 0),
(142, 'Molnár Anna', 0),
(143, 'Csík Márta', 0),
(144, 'Szabó Gabriella', 0),
(145, 'Bolvári Ildikó', 0),
(146, 'Balogh Ilona', 0),
(147, 'Gál Krisztina', 0),
(148, 'Böhm Gabriella', 0),
(149, 'Nagy Krisztina', 0),
(150, 'Fazekas Györgyi', 0),
(151, 'Karádi Krisztina', 0),
(152, 'Wirth Veronika', 0),
(153, 'Éllő Vivien', 0),
(154, 'Kertai Rita', 0),
(155, 'Iszajeva Anna', 0),
(156, 'Li Bin', 0),
(157, 'Nagyváradi Mercédesz', 0),
(158, 'Bálint Bernadett', 0),
(159, 'Tóth Kata', 0),
(160, 'dr. Jacobi Roland', 1),
(161, 'Wollemann Istvánné', 0),
(162, 'Friedmann Lili', 0),
(163, 'Földi Ernő', 1),
(164, 'Vasvári Nicolette', 0),
(165, 'Pidl Zita', 0),
(166, 'Bátorfi Zoltán', 1),
(167, 'Erdős Éva', 0),
(168, 'Kókai Ágnes', 0),
(169, 'Nagy Krisztián', 1),
(170, 'Peterman-Varga Tímea', 0);

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

CREATE TABLE `versenyszam` (
  `id` int(1) NOT NULL,
  `nev` varchar(30) COLLATE utf8mb4_hungarian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_hungarian_ci;

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

INSERT INTO `versenyszam` (`id`, `nev`) VALUES
(1, 'férfi egyéni'),
(2, 'női egyéni'),
(3, 'férfi páros'),
(4, 'női páros'),
(5, 'vegyes páros');

-- Indexek a kiírt táblákhoz
-- A tábla indexei `bajnok`
--
ALTER TABLE `bajnok`
  ADD PRIMARY KEY (`id`),
  ADD KEY `egyesulet_id` (`egyesulet_id`),
  ADD KEY `jatekos_id` (`jatekos_id`),
  ADD KEY `vsz_id` (`vsz_id`);

-- A tábla indexei `egyesulet`
--
ALTER TABLE `egyesulet`
  ADD PRIMARY KEY (`id`);

-- A tábla indexei `jatekos`
--
ALTER TABLE `jatekos`
  ADD PRIMARY KEY (`id`);

-- A tábla indexei `versenyszam`
--
ALTER TABLE `versenyszam`
  ADD PRIMARY KEY (`id`);

-- Megkötések a kiírt táblákhoz

--
-- Megkötések a táblához `bajnok`
--
ALTER TABLE `bajnok`
  ADD CONSTRAINT `bajnok_ibfk_1` FOREIGN KEY (`egyesulet_id`) REFERENCES `egyesulet` (`id`),
  ADD CONSTRAINT `bajnok_ibfk_2` FOREIGN KEY (`jatekos_id`) REFERENCES `jatekos` (`id`),
  ADD CONSTRAINT `bajnok_ibfk_3` FOREIGN KEY (`vsz_id`) REFERENCES `versenyszam` (`id`);
COMMIT;

