CREATE DATABASE IF NOT EXISTS `evautoja` DEFAULT CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
USE `evautoja`;

CREATE TABLE `auto` (
  `azon` int(11) NOT NULL,
  `ev` int(11) NOT NULL,
  `helyezes` int(11) NOT NULL,
  `gyar` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
  `modell` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
  `pont` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;

INSERT INTO `auto` (`azon`, `ev`, `helyezes`, `gyar`, `modell`, `pont`) VALUES
(1, 1964, 1, 'Rover', '2000', 76),
(2, 1965, 1, 'Austin', '1800', 78),
(3, 1966, 1, 'Renault', '16', 98),
(4, 1967, 1, 'Fiat', '124', 144),
(5, 1968, 1, 'NSU', 'Ro 80', 197),
(6, 1969, 1, 'Peugeot', '504', 119),
(7, 1970, 1, 'Fiat', '128', 235),
(8, 1971, 1, 'Citroën', 'GS', 233),
(9, 1972, 1, 'Fiat', '127', 239),
(10, 1973, 1, 'Audi', '80', 114),
(11, 1974, 1, 'Mercedes', '450S', 115),
(12, 1975, 1, 'Citroën', 'CX', 229),
(13, 1976, 1, 'Simca', '1307-1308', 192),
(14, 1977, 1, 'Rover', '3500', 157),
(15, 1978, 1, 'Porsche', '928', 261),
(16, 1979, 1, 'Simca-Chrysler', 'Horizon', 251),
(17, 1980, 1, 'Lancia', 'Delta', 369),
(18, 1981, 1, 'Ford', 'Escort', 326),
(19, 1982, 1, 'Renault', '9', 335),
(20, 1983, 1, 'Audi', '100', 410),
(21, 1984, 1, 'Fiat', 'Uno', 346),
(22, 1985, 1, 'Opel', 'Kadett', 326),
(23, 1986, 1, 'Ford', 'Scorpio', 337),
(24, 1987, 1, 'Opel', 'Omega', 275),
(25, 1988, 1, 'Peugeot', '405', 464),
(26, 1989, 1, 'Fiat', 'Tipo', 356),
(27, 1990, 1, 'Citroën', 'XM', 390),
(28, 1991, 1, 'Renault', 'Clio', 312),
(29, 1992, 1, 'Volkswagen', 'Golf', 276),
(30, 1993, 1, 'Nissan', 'Micra', 338),
(31, 1994, 1, 'Ford', 'Mondeo', 290),
(32, 1995, 1, 'Fiat', 'Punto', 370),
(33, 1996, 1, 'Fiat', 'Bravo', 378),
(34, 1997, 1, 'Renault', 'Mégane Scénic', 405),
(35, 1998, 1, 'Alfa Romeo', '156', 454),
(36, 1999, 1, 'Ford', 'Focus', 444),
(37, 2000, 1, 'Toyota', 'Yaris', 344),
(38, 2001, 1, 'Alfa Romeo', '147', 238),
(39, 2002, 1, 'Peugeot', '307', 286),
(40, 2003, 1, 'Renault', 'Mégane', 322),
(41, 2004, 1, 'Fiat', 'Panda', 281),
(42, 2005, 1, 'Toyota', 'Prius', 406),
(43, 2006, 1, 'Renault', 'Clio', 256),
(44, 2007, 1, 'Ford', 'S-MAX', 235),
(45, 1964, 2, 'Mercedes', '600', 64),
(46, 1965, 2, 'Autobianchi', 'Primula', 51),
(47, 1966, 2, 'Rolls-Royce', 'Silver Shadow', 81),
(48, 1967, 2, 'BMW', '1600', 69),
(49, 1968, 2, 'Fiat', '125', 133),
(50, 1969, 2, 'BMW', '2500/2800', 77),
(51, 1970, 2, 'Autobianchi', 'A112', 96),
(52, 1971, 2, 'Volkswagen', 'K70', 121),
(53, 1972, 2, 'Renault', '15/17', 107),
(54, 1973, 2, 'Renault', '5', 109),
(55, 1974, 2, 'Fiat', 'X1/9', 99),
(56, 1975, 2, 'Volkswagen', 'Golf', 164),
(57, 1976, 2, 'BMW', '3-series', 144),
(58, 1977, 2, 'Audi', '100', 138),
(59, 1978, 2, 'BMW', '7-series', 231),
(60, 1979, 2, 'Fiat', 'Ritmo', 239),
(61, 1980, 2, 'Opel', 'Kadett', 301),
(62, 1981, 2, 'Fiat', 'Panda', 308),
(63, 1982, 2, 'Opel', 'Ascona', 304),
(64, 1983, 2, 'Ford', 'Sierra', 386),
(65, 1984, 2, 'Peugeot', '205', 325),
(66, 1985, 2, 'Renault', '25', 261),
(67, 1986, 2, 'Lancia', 'Y10', 291),
(68, 1987, 2, 'Audi', '80', 238),
(69, 1988, 2, 'Citroën', 'AX', 252),
(70, 1989, 2, 'Opel', 'Vectra', 261),
(71, 1990, 2, 'Mercedes-Benz', 'SL', 215),
(72, 1991, 2, 'Nissan', 'Primera', 258),
(73, 1992, 2, 'Opel', 'Astra', 231),
(74, 1993, 2, 'Fiat', 'Cinquecento', 304),
(75, 1994, 2, 'Citroën', 'Xantia', 264),
(76, 1995, 2, 'Volkswagen', 'Polo', 292),
(77, 1996, 2, 'Peugeot', '406', 363),
(78, 1997, 2, 'Ford', 'Ka', 293),
(79, 1998, 2, 'Volkswagen', 'Golf', 266),
(80, 1999, 2, 'Opel', 'Astra', 269),
(81, 2000, 2, 'Fiat', 'Multipla', 325),
(82, 2001, 2, 'Ford', 'Mondeo', 237),
(83, 2002, 2, 'Renault', 'Laguna', 244),
(84, 2003, 2, 'Mazda', '6', 302),
(85, 2004, 2, 'Mazda', '3', 241),
(86, 2005, 2, 'Citroën', 'C4', 267),
(87, 2006, 2, 'Volkswagen', 'Passat', 251),
(88, 2007, 2, 'Opel/Vauxhall', 'Corsa', 233),
(89, 1964, 3, 'Hillman', 'Imp', 31),
(90, 1965, 3, 'Ford', 'Mustang', 18),
(91, 1966, 3, 'Oldsmobile', 'Toronado', 59),
(92, 1967, 3, 'Jensen', 'FF', 61),
(93, 1968, 3, 'Simca', '1100', 94),
(94, 1969, 3, 'Alfa Romeo', '1750', 76),
(95, 1970, 3, 'Renault', '12', 79),
(96, 1971, 3, 'Citroën', 'SM', 105),
(97, 1972, 3, 'Mercedes', '350SL', 96),
(98, 1973, 3, 'Alfa Romeo', 'Alfetta', 95),
(99, 1974, 3, 'Honda', 'Civic', 90),
(100, 1975, 3, 'Audi', '50', 136),
(101, 1976, 3, 'Renault', '30 TS', 107),
(102, 1977, 3, 'Ford', 'Fiesta', 135),
(103, 1978, 3, 'Ford', 'Granada', 203),
(104, 1979, 3, 'Audi', '80', 181),
(105, 1980, 3, 'Peugeot', '505', 199),
(106, 1981, 3, 'Austin', 'Metro', 255),
(107, 1982, 3, 'Volkswagen', 'Polo', 252),
(108, 1983, 3, 'Volvo', '760', 157),
(109, 1984, 3, 'Volkswagen', 'Golf', 156),
(110, 1985, 3, 'Lancia', 'Thema', 191),
(111, 1986, 3, 'Mercedes-Benz', '200-300E', 273),
(112, 1987, 3, 'BMW', '7-series', 175),
(113, 1988, 3, 'Honda', 'Prelude', 234),
(114, 1989, 3, 'Volkswagen', 'Passat', 194),
(115, 1990, 3, 'Ford', 'Fiesta', 214),
(116, 1991, 3, 'Opel', 'Calibra', 183),
(117, 1992, 3, 'Citroën', 'ZX', 213),
(118, 1993, 3, 'Renault', 'Safrane', 244),
(119, 1994, 3, 'Mercedes-Benz', 'C', 192),
(120, 1995, 3, 'Opel', 'Omega', 272),
(121, 1996, 3, 'Audi', 'A4', 246),
(122, 1997, 3, 'Volkswagen', 'Passat', 248),
(123, 1998, 3, 'Audi', 'A6', 265),
(124, 1999, 3, 'Peugeot', '206', 248),
(125, 2000, 3, 'Opel', 'Zafira', 265),
(126, 2001, 3, 'Toyota', 'Prius', 229),
(127, 2002, 3, 'Fiat', 'Stilo', 243),
(128, 2003, 3, 'Citroën', 'C3', 214),
(129, 2004, 3, 'Volkswagen', 'Golf', 241),
(130, 2005, 3, 'Ford', 'Focus', 228),
(131, 2006, 3, 'Alfa Romeo', '159', 212),
(132, 2007, 3, 'Citroën', 'C4 Picasso', 222),
(133, 2008, 1, 'Fiat', '500', 385),
(134, 2008, 2, 'Mazda', '2', 325),
(135, 2008, 3, 'Ford', 'Mondeo', 202),
(136, 2009, 1, 'Opel/Vauxhall', 'Insignia', 321),
(137, 2009, 2, 'Ford', 'Fiesta', 320),
(138, 2009, 3, 'Volkswagen', 'Golf', 223),
(139, 2010, 1, 'Volkswagen', 'Polo', 347),
(140, 2010, 2, 'Toyota', 'iQ', 337),
(141, 2010, 3, 'Opel/Vauxhall', 'Astra', 221),
(142, 2011, 1, 'Nissan', 'Leaf', 257),
(143, 2011, 2, 'Alfa Romeo', 'Giulietta', 248),
(144, 2011, 3, 'Opel/Vauxhall', 'Meriva', 244),
(145, 2012, 1, 'Opel', 'Ampera', 330),
(146, 2012, 2, 'Volkswagen', 'Up!', 281),
(147, 2012, 3, 'Ford', 'Focus', 256),
(148, 2013, 1, 'Volkswagen', 'Golf', 414),
(149, 2013, 2, 'Toyota', 'GT86', 202),
(150, 2013, 3, 'Volvo', 'V40', 189),
(151, 2014, 1, 'Peugeot', '308', 307),
(152, 2014, 2, 'BMW', 'i3', 223),
(153, 2014, 3, 'Tesla', 'Model S', 216),
(154, 2015, 1, 'Volkswagen', 'Passat', 340),
(155, 2015, 2, 'Citroën', 'C4 Cactus', 248),
(156, 2015, 3, 'Mercedes-Benz', 'C', 221),
(157, 2016, 1, 'Opel', 'Astra', 312),
(158, 2016, 2, 'Volvo', 'XC90', 294),
(159, 2016, 3, 'Mazda', 'MX-5', 202),
(160, 2017, 1, 'Peugeot', '3008', 319),
(161, 2017, 2, 'Alfa Romeo', 'Giulia', 296),
(162, 2017, 3, 'Mercedes-Benz', 'E', 197),
(163, 2018, 1, 'Volvo', 'XC40', 325),
(164, 2018, 2, 'Seat', 'Ibiza', 242),
(165, 2018, 3, 'BMW', '5', 226),
(166, 2019, 1, 'Jaguar', 'I-Pace', 250),
(167, 2019, 2, 'Alpine', 'A110', 250),
(168, 2019, 3, 'Kia', 'Ceed', 247),
(169, 2020, 1, 'Peugeot', '208', 281),
(170, 2020, 2, 'Tesla', 'Model 3', 242),
(171, 2020, 3, 'Porsche', 'Taycan', 222),
(172, 2021, 1, 'Toyota', 'Yaris', 266),
(173, 2021, 2, 'Fiat', '500e', 240),
(174, 2021, 3, 'Cupra', 'Formentor', 239),
(175, 2022, 1, 'Kia', 'EV6', 279),
(176, 2022, 2, 'Renault', 'Megane E-Tech', 265),
(177, 2022, 3, 'Hyundai', 'Ioniq 5', 261),
(178, 2023, 1, 'Jeep', 'Avenger', 328),
(179, 2023, 2, 'Volkswagen', 'ID.Buzz', 241),
(180, 2023, 3, 'Nissan', 'Ariya', 211);


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


ALTER TABLE `auto`
  MODIFY `azon` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;
COMMIT;
