sad_cars.sql

-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Gazdă: 127.0.0.1:3306
-- Timp de generare: mart. 18, 2020 la 07:47 PM
-- Versiune server: 10.4.10-MariaDB
-- Versiune PHP: 7.3.12

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

--
-- Bază de date: `sad_cars`
--

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

--
-- Structură tabel pentru tabel `clase`
--

DROP TABLE IF EXISTS `clase`;
CREATE TABLE IF NOT EXISTS `clase` (
  `id_clasa` int(3) NOT NULL AUTO_INCREMENT,
  `denumire_clasa` varchar(50) NOT NULL,
  PRIMARY KEY (`id_clasa`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `clase`
--

INSERT INTO `clase` (`id_clasa`, `denumire_clasa`) VALUES
(1, 'Lux'),
(2, 'Off-road'),
(3, 'Sport'),
(4, 'Automobile');

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

--
-- Structură tabel pentru tabel `clasificare`
--

DROP TABLE IF EXISTS `clasificare`;
CREATE TABLE IF NOT EXISTS `clasificare` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `id_subclasa` int(3) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `clasificare`
--

INSERT INTO `clasificare` (`id_model`, `id_subclasa`) VALUES
(1, 2),
(2, 8),
(3, 9),
(4, 8),
(5, 3),
(6, 8),
(7, 4),
(8, 8),
(9, 8),
(10, 10),
(11, 10),
(12, 10),
(13, 10),
(14, 10),
(15, 10),
(16, 10),
(17, 10),
(18, 10),
(19, 10),
(20, 3),
(21, 3),
(22, 3),
(23, 3),
(24, 3),
(25, 3),
(26, 3),
(27, 3),
(28, 3),
(29, 3),
(30, 3),
(31, 3),
(32, 3),
(33, 3),
(34, 3),
(35, 3),
(36, 8),
(37, 8),
(38, 8),
(39, 8),
(40, 8),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 9),
(47, 9),
(48, 9),
(49, 9),
(50, 9),
(51, 9),
(52, 3),
(53, 3),
(54, 3),
(55, 3),
(56, 3),
(57, 3),
(58, 3),
(59, 3),
(60, 3),
(61, 3),
(62, 3),
(63, 3),
(64, 3),
(65, 3),
(66, 3),
(67, 4),
(68, 9),
(69, 9),
(70, 9),
(71, 9),
(72, 9),
(73, 8),
(74, 8),
(75, 8),
(76, 8),
(77, 9),
(78, 9),
(79, 9),
(80, 9),
(81, 9),
(82, 4),
(83, 4),
(84, 4),
(85, 9),
(86, 8),
(87, 4),
(88, 9),
(89, 9),
(90, 9),
(91, 9),
(92, 9),
(93, 9),
(94, 9),
(95, 9),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 4),
(101, 4),
(102, 4),
(103, 4),
(104, 4),
(105, 4),
(106, 1),
(107, 1),
(108, 1),
(109, 9),
(110, 9),
(111, 9),
(112, 9),
(113, 9),
(114, 9),
(115, 9),
(116, 9),
(117, 9),
(118, 9),
(119, 9),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 2),
(125, 2),
(126, 2),
(127, 2),
(128, 1),
(129, 1),
(130, 9),
(131, 9),
(132, 9),
(133, 9),
(134, 9),
(135, 9),
(136, 9),
(137, 9),
(138, 9),
(139, 9),
(140, 9),
(141, 9),
(142, 9),
(143, 9),
(144, 9),
(145, 4),
(146, 9),
(147, 9),
(148, 9),
(149, 9),
(150, 9),
(151, 9),
(152, 10),
(153, 10),
(154, 10),
(155, 10),
(156, 10),
(157, 10),
(158, 10),
(159, 10),
(160, 4),
(161, 4),
(162, 4),
(163, 5),
(164, 5),
(165, 5),
(166, 5),
(167, 5),
(168, 7),
(169, 7),
(170, 5),
(171, 5),
(172, 5),
(173, 7),
(174, 9),
(175, 9),
(176, 9),
(177, 9),
(178, 9),
(179, 6),
(180, 6),
(181, 6),
(182, 6),
(183, 6),
(184, 6),
(185, 6),
(186, 6),
(187, 6),
(188, 2),
(189, 2),
(190, 2),
(191, 2),
(192, 4),
(193, 4),
(194, 4),
(195, 9),
(196, 9),
(197, 4),
(198, 4),
(199, 4),
(200, 8),
(201, 8),
(202, 8),
(203, 8),
(204, 4),
(205, 4),
(206, 4),
(207, 4),
(208, 4),
(209, 8),
(210, 8),
(211, 8),
(212, 1),
(213, 1),
(214, 1),
(215, 2),
(216, 4),
(217, 4),
(218, 4),
(219, 4),
(220, 4),
(221, 8),
(222, 8),
(223, 8),
(224, 9),
(225, 9),
(226, 9),
(227, 9),
(228, 10),
(229, 10),
(230, 10),
(231, 4),
(232, 10),
(233, 10),
(234, 4),
(235, 10),
(236, 8),
(237, 8),
(238, 9),
(239, 9),
(240, 10),
(241, 10),
(242, 4),
(243, 4),
(244, 9),
(245, 2),
(246, 2),
(247, 1),
(248, 1),
(249, 5),
(250, 5),
(251, 5),
(252, 8),
(253, 8),
(254, 9),
(255, 1),
(256, 8),
(257, 8),
(258, 8),
(259, 1),
(260, 6),
(261, 10),
(262, 8),
(263, 8),
(264, 8),
(265, 8),
(266, 9),
(267, 8),
(268, 8),
(269, 8),
(270, 8),
(271, 8),
(272, 8),
(273, 10),
(274, 8),
(275, 8),
(276, 8),
(277, 4),
(278, 8),
(279, 9),
(280, 10),
(281, 4);

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

--
-- Structură tabel pentru tabel `depreciere_pret`
--

DROP TABLE IF EXISTS `depreciere_pret`;
CREATE TABLE IF NOT EXISTS `depreciere_pret` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `depreciere` int(2) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `depreciere_pret`
--

INSERT INTO `depreciere_pret` (`id_model`, `depreciere`) VALUES
(1, 98),
(2, 97),
(3, 90),
(4, 90),
(5, 96),
(6, 96),
(7, 93),
(8, 90),
(9, 93),
(10, 96),
(11, 97),
(12, 91),
(13, 95),
(14, 91),
(15, 95),
(16, 98),
(17, 97),
(18, 91),
(19, 98),
(20, 93),
(21, 97),
(22, 99),
(23, 98),
(24, 96),
(25, 94),
(26, 99),
(27, 99),
(28, 92),
(29, 94),
(30, 93),
(31, 98),
(32, 97),
(33, 98),
(34, 96),
(35, 95),
(36, 90),
(37, 93),
(38, 98),
(39, 92),
(40, 94),
(41, 98),
(42, 93),
(43, 96),
(44, 97),
(45, 92),
(46, 95),
(47, 96),
(48, 92),
(49, 96),
(50, 97),
(51, 96),
(52, 98),
(53, 97),
(54, 94),
(55, 98),
(56, 95),
(57, 97),
(58, 96),
(59, 91),
(60, 92),
(61, 96),
(62, 90),
(63, 94),
(64, 96),
(65, 92),
(66, 91),
(67, 99),
(68, 99),
(69, 97),
(70, 99),
(71, 96),
(72, 93),
(73, 96),
(74, 93),
(75, 94),
(76, 90),
(77, 92),
(78, 99),
(79, 91),
(80, 97),
(81, 90),
(82, 99),
(83, 91),
(84, 98),
(85, 92),
(86, 98),
(87, 97),
(88, 95),
(89, 90),
(90, 95),
(91, 97),
(92, 93),
(93, 93),
(94, 90),
(95, 90),
(96, 90),
(97, 95),
(98, 96),
(99, 96),
(100, 98),
(101, 96),
(102, 92),
(103, 91),
(104, 98),
(105, 90),
(106, 99),
(107, 96),
(108, 93),
(109, 97),
(110, 99),
(111, 98),
(112, 90),
(113, 95),
(114, 94),
(115, 96),
(116, 97),
(117, 90),
(118, 90),
(119, 94),
(120, 95),
(121, 90),
(122, 90),
(123, 90),
(124, 92),
(125, 92),
(126, 94),
(127, 90),
(128, 99),
(129, 90),
(130, 94),
(131, 97),
(132, 92),
(133, 99),
(134, 91),
(135, 99),
(136, 97),
(137, 98),
(138, 95),
(139, 92),
(140, 96),
(141, 99),
(142, 92),
(143, 93),
(144, 97),
(145, 99),
(146, 97),
(147, 93),
(148, 99),
(149, 97),
(150, 92),
(151, 99),
(152, 97),
(153, 92),
(154, 97),
(155, 99),
(156, 98),
(157, 96),
(158, 91),
(159, 99),
(160, 95),
(161, 90),
(162, 98),
(163, 90),
(164, 90),
(165, 98),
(166, 93),
(167, 93),
(168, 92),
(169, 96),
(170, 91),
(171, 93),
(172, 97),
(173, 92),
(174, 92),
(175, 97),
(176, 97),
(177, 98),
(178, 94),
(179, 96),
(180, 91),
(181, 96),
(182, 92),
(183, 98),
(184, 90),
(185, 92),
(186, 98),
(187, 93),
(188, 96),
(189, 93),
(190, 95),
(191, 99),
(192, 97),
(193, 97),
(194, 98),
(195, 99),
(196, 94),
(197, 93),
(198, 98),
(199, 97),
(200, 98),
(201, 97),
(202, 97),
(203, 94),
(204, 91),
(205, 99),
(206, 98),
(207, 91),
(208, 93),
(209, 92),
(210, 94),
(211, 98),
(212, 98),
(213, 99),
(214, 98),
(215, 92),
(216, 92),
(217, 93),
(218, 93),
(219, 98),
(220, 95),
(221, 91),
(222, 95),
(223, 91),
(224, 92),
(225, 94),
(226, 91),
(227, 95),
(228, 90),
(229, 97),
(230, 90),
(231, 96),
(232, 94),
(233, 97),
(234, 95),
(235, 94),
(236, 98),
(237, 95),
(238, 90),
(239, 99),
(240, 90),
(241, 98),
(242, 92),
(243, 98),
(244, 98),
(245, 91),
(246, 93),
(247, 97),
(248, 99),
(249, 91),
(250, 95),
(251, 93),
(252, 96),
(253, 94),
(254, 90),
(255, 94),
(256, 91),
(257, 99),
(258, 91),
(259, 99),
(260, 94),
(261, 99),
(262, 91),
(263, 98),
(264, 91),
(265, 91),
(266, 98),
(267, 92),
(268, 95),
(269, 91),
(270, 98),
(271, 93),
(272, 94),
(273, 98),
(274, 99),
(275, 92),
(276, 98),
(277, 96),
(278, 90),
(279, 97),
(280, 97),
(281, 90);

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

--
-- Structură tabel pentru tabel `intretinere_modele`
--

DROP TABLE IF EXISTS `intretinere_modele`;
CREATE TABLE IF NOT EXISTS `intretinere_modele` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `RCA20` int(4) NOT NULL DEFAULT 1700,
  `RCA40` int(4) NOT NULL DEFAULT 1200,
  `RCA60` int(4) NOT NULL DEFAULT 1000,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `intretinere_modele`
--

INSERT INTO `intretinere_modele` (`id_model`, `RCA20`, `RCA40`, `RCA60`) VALUES
(1, 1309, 674, 941),
(2, 1204, 629, 712),
(3, 1371, 453, 1053),
(4, 1261, 481, 745),
(5, 1530, 364, 854),
(6, 1376, 397, 1108),
(7, 1038, 430, 1083),
(8, 1581, 414, 715),
(9, 1525, 496, 951),
(10, 1265, 431, 1093),
(11, 1338, 362, 1196),
(12, 1404, 641, 1177),
(13, 1249, 385, 733),
(14, 1508, 578, 900),
(15, 1454, 604, 1112),
(16, 1584, 300, 974),
(17, 1169, 582, 1159),
(18, 1477, 482, 829),
(19, 1103, 554, 1081),
(20, 1310, 383, 888),
(21, 1326, 398, 1032),
(22, 1200, 645, 844),
(23, 1269, 690, 1095),
(24, 1450, 440, 1130),
(25, 1446, 449, 879),
(26, 1290, 572, 1190),
(27, 1566, 366, 789),
(28, 1459, 609, 1060),
(29, 1487, 343, 1072),
(30, 1378, 497, 1155),
(31, 1405, 304, 933),
(32, 1433, 308, 1087),
(33, 1511, 467, 999),
(34, 1020, 411, 889),
(35, 1563, 615, 1190),
(36, 1130, 482, 1063),
(37, 1162, 658, 708),
(38, 1420, 348, 1063),
(39, 1045, 374, 712),
(40, 1022, 285, 963),
(41, 1413, 454, 775),
(42, 1020, 364, 705),
(43, 1559, 611, 1094),
(44, 1271, 426, 1198),
(45, 1027, 350, 1110),
(46, 1336, 682, 813),
(47, 1252, 602, 867),
(48, 1108, 415, 717),
(49, 1263, 430, 1089),
(50, 1587, 325, 947),
(51, 1225, 319, 1083),
(52, 1428, 641, 1033),
(53, 1305, 314, 1106),
(54, 1464, 419, 952),
(55, 1014, 414, 1112),
(56, 1188, 332, 1046),
(57, 1557, 469, 1103),
(58, 1567, 406, 1064),
(59, 1533, 630, 810),
(60, 1156, 594, 1174),
(61, 1307, 506, 857),
(62, 1487, 280, 1112),
(63, 1097, 487, 962),
(64, 1111, 682, 839),
(65, 1187, 525, 707),
(66, 1369, 387, 1073),
(67, 1020, 303, 1084),
(68, 1444, 341, 807),
(69, 1420, 465, 1172),
(70, 1417, 310, 972),
(71, 1119, 452, 845),
(72, 1498, 496, 1091),
(73, 1592, 439, 830),
(74, 1420, 352, 732),
(75, 1035, 343, 841),
(76, 1561, 550, 742),
(77, 1079, 497, 796),
(78, 1508, 595, 896),
(79, 1098, 393, 943),
(80, 1020, 360, 709),
(81, 1474, 533, 876),
(82, 1287, 572, 938),
(83, 1421, 693, 700),
(84, 1109, 460, 1085),
(85, 1126, 514, 1112),
(86, 1225, 557, 1127),
(87, 1115, 633, 1022),
(88, 1199, 390, 702),
(89, 1224, 359, 1083),
(90, 1366, 598, 1042),
(91, 1235, 485, 987),
(92, 1472, 464, 1095),
(93, 1227, 497, 837),
(94, 1066, 475, 974),
(95, 1133, 489, 1159),
(96, 1371, 552, 946),
(97, 1282, 601, 864),
(98, 1181, 541, 1158),
(99, 1555, 647, 1168),
(100, 1309, 626, 755),
(101, 1512, 398, 805),
(102, 1217, 300, 1187),
(103, 1405, 489, 719),
(104, 1292, 369, 986),
(105, 1204, 541, 756),
(106, 1350, 555, 961),
(107, 1336, 561, 908),
(108, 1151, 504, 1101),
(109, 1066, 603, 877),
(110, 1213, 688, 1044),
(111, 1066, 493, 1003),
(112, 1353, 370, 867),
(113, 1471, 339, 859),
(114, 1557, 500, 1123),
(115, 1000, 362, 968),
(116, 1288, 614, 1181),
(117, 1537, 576, 832),
(118, 1545, 435, 945),
(119, 1358, 397, 907),
(120, 1098, 481, 709),
(121, 1167, 682, 1047),
(122, 1174, 568, 990),
(123, 1201, 465, 1162),
(124, 1454, 561, 1066),
(125, 1119, 466, 866),
(126, 1349, 351, 837),
(127, 1352, 472, 755),
(128, 1588, 668, 805),
(129, 1163, 417, 1053),
(130, 1494, 445, 986),
(131, 1091, 622, 929),
(132, 1363, 455, 780),
(133, 1057, 689, 879),
(134, 1108, 330, 993),
(135, 1272, 436, 934),
(136, 1091, 697, 713),
(137, 1472, 501, 880),
(138, 1415, 434, 1075),
(139, 1084, 359, 864),
(140, 1361, 352, 815),
(141, 1047, 337, 1110),
(142, 1521, 545, 1009),
(143, 1247, 424, 866),
(144, 1038, 529, 1038),
(145, 1156, 427, 1089),
(146, 1363, 398, 1006),
(147, 1554, 352, 769),
(148, 1499, 547, 1143),
(149, 1108, 505, 1045),
(150, 1525, 339, 1022),
(151, 1126, 324, 1055),
(152, 1522, 381, 986),
(153, 1096, 348, 822),
(154, 1293, 674, 1120),
(155, 1406, 303, 1147),
(156, 1590, 623, 831),
(157, 1436, 516, 1146),
(158, 1273, 409, 836),
(159, 1472, 385, 904),
(160, 1258, 676, 726),
(161, 1313, 529, 1066),
(162, 1533, 321, 872),
(163, 1486, 300, 1143),
(164, 1362, 332, 939),
(165, 1176, 697, 853),
(166, 1278, 465, 934),
(167, 1388, 641, 1026),
(168, 1059, 374, 868),
(169, 1595, 676, 925),
(170, 1580, 376, 1155),
(171, 1211, 611, 1119),
(172, 1527, 493, 798),
(173, 1209, 294, 1093),
(174, 1037, 511, 1027),
(175, 1121, 586, 1060),
(176, 1357, 297, 878),
(177, 1517, 673, 1058),
(178, 1350, 677, 788),
(179, 1296, 354, 914),
(180, 1206, 459, 1192),
(181, 1414, 478, 860),
(182, 1590, 307, 813),
(183, 1139, 439, 790),
(184, 1248, 394, 1106),
(185, 1008, 486, 1074),
(186, 1061, 686, 717),
(187, 1127, 441, 1019),
(188, 1090, 408, 948),
(189, 1039, 465, 793),
(190, 1524, 526, 973),
(191, 1235, 607, 829),
(192, 1554, 340, 1050),
(193, 1199, 454, 836),
(194, 1077, 456, 708),
(195, 1240, 672, 994),
(196, 1386, 451, 1035),
(197, 1600, 640, 1184),
(198, 1490, 583, 1171),
(199, 1372, 596, 932),
(200, 1459, 688, 769),
(201, 1035, 516, 1164),
(202, 1022, 641, 1001),
(203, 1348, 343, 1076),
(204, 1375, 646, 725),
(205, 1136, 502, 745),
(206, 1472, 592, 1117),
(207, 1404, 604, 892),
(208, 1046, 692, 752),
(209, 1145, 348, 909),
(210, 1561, 458, 1110),
(211, 1181, 651, 763),
(212, 1205, 534, 891),
(213, 1010, 466, 1185),
(214, 1413, 492, 1188),
(215, 1278, 531, 1097),
(216, 1543, 362, 829),
(217, 1352, 417, 965),
(218, 1351, 641, 910),
(219, 1006, 375, 912),
(220, 1355, 586, 854),
(221, 1145, 672, 973),
(222, 1330, 616, 979),
(223, 1393, 394, 956),
(224, 1487, 656, 1060),
(225, 1099, 307, 895),
(226, 1357, 687, 777),
(227, 1014, 322, 808),
(228, 1238, 567, 1189),
(229, 1333, 564, 730),
(230, 1040, 405, 921),
(231, 1117, 602, 967),
(232, 1546, 560, 1056),
(233, 1426, 317, 1112),
(234, 1484, 533, 789),
(235, 1131, 424, 863),
(236, 1098, 305, 1123),
(237, 1263, 431, 751),
(238, 1039, 363, 1089),
(239, 1431, 495, 955),
(240, 1434, 358, 1177),
(241, 1299, 370, 801),
(242, 1017, 301, 883),
(243, 1095, 640, 964),
(244, 1180, 627, 973),
(245, 1530, 302, 1172),
(246, 1210, 337, 764),
(247, 1347, 690, 1035),
(248, 1063, 519, 1117),
(249, 1443, 610, 1116),
(250, 1008, 507, 1174),
(251, 1385, 645, 1126),
(252, 1288, 296, 712),
(253, 1061, 375, 833),
(254, 1095, 540, 754),
(255, 1528, 431, 795),
(256, 1120, 647, 816),
(257, 1352, 459, 949),
(258, 1173, 631, 825),
(259, 1207, 596, 988),
(260, 1464, 304, 997),
(261, 1234, 643, 1197),
(262, 1169, 377, 1098),
(263, 1573, 558, 1176),
(264, 1019, 464, 1134),
(265, 1553, 541, 905),
(266, 1383, 494, 933),
(267, 1008, 466, 1133),
(268, 1274, 587, 862),
(269, 1084, 323, 828),
(270, 1201, 403, 780),
(271, 1390, 383, 1096),
(272, 1299, 513, 922),
(273, 1033, 367, 904),
(274, 1551, 296, 1116),
(275, 1331, 452, 1070),
(276, 1239, 317, 928),
(277, 1006, 286, 933),
(278, 1031, 398, 1019),
(279, 1320, 426, 1200),
(280, 1087, 283, 745),
(281, 1311, 302, 802);

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

--
-- Structură tabel pentru tabel `preturi_modele`
--

DROP TABLE IF EXISTS `preturi_modele`;
CREATE TABLE IF NOT EXISTS `preturi_modele` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `pret` double(8,2) NOT NULL,
  `trimestru` int(2) NOT NULL,
  `an` int(4) NOT NULL,
  PRIMARY KEY (`id_model`,`trimestru`,`an`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `preturi_modele`
--

INSERT INTO `preturi_modele` (`id_model`, `pret`, `trimestru`, `an`) VALUES
(1, 12000.00, 4, 2018),
(1, 11000.00, 1, 2019),
(1, 9000.00, 2, 2019),
(2, 5000.00, 1, 2017),
(2, 4500.00, 2, 2017),
(2, 4250.00, 3, 2017),
(3, 7000.00, 2, 2015),
(3, 6000.00, 3, 2015),
(3, 5800.00, 4, 2015),
(4, 8700.00, 3, 2017),
(4, 7800.00, 4, 2017),
(4, 7100.00, 1, 2018),
(5, 15700.00, 1, 2017),
(5, 12600.00, 2, 2017),
(5, 11100.00, 3, 2017),
(6, 5600.00, 2, 2015),
(6, 4300.00, 3, 2015),
(6, 3880.00, 4, 2015),
(7, 13000.00, 4, 2016),
(7, 11800.00, 1, 2017),
(7, 11000.00, 2, 2017),
(8, 43500.00, 4, 2020),
(9, 18700.00, 1, 2018),
(9, 17100.00, 2, 2018),
(9, 15800.00, 3, 2018),
(10, 24000.00, 4, 2018),
(10, 22100.00, 1, 2019),
(10, 21000.00, 2, 2019),
(11, 13000.00, 2, 2014),
(11, 11600.00, 3, 2014),
(11, 9200.00, 4, 2014),
(12, 10500.00, 1, 2014),
(12, 9000.00, 2, 2014),
(12, 7450.00, 3, 2014),
(13, 8000.00, 3, 2012),
(13, 7100.00, 4, 2012),
(13, 6230.00, 1, 2013),
(14, 58300.00, 2, 2021),
(15, 7000.00, 1, 2009),
(15, 6100.00, 2, 2009),
(15, 5800.00, 3, 2009),
(16, 5000.00, 1, 2006),
(16, 4200.00, 2, 2006),
(16, 3900.00, 3, 2006),
(17, 23000.00, 4, 2017),
(17, 21200.00, 1, 2018),
(17, 19300.00, 2, 2018),
(18, 13000.00, 1, 2014),
(18, 11500.00, 2, 2014),
(18, 10000.00, 3, 2014),
(19, 10000.00, 1, 2012),
(19, 9100.00, 2, 2012),
(19, 7150.00, 3, 2012),
(20, 38000.00, 2, 2017),
(20, 35000.00, 3, 2017),
(20, 31200.00, 4, 2017),
(21, 25000.00, 1, 2014),
(21, 23000.00, 2, 2014),
(21, 19200.00, 3, 2014),
(22, 29000.00, 2, 2016),
(22, 24100.00, 3, 2016),
(22, 22000.00, 4, 2016),
(23, 15000.00, 4, 2012),
(23, 13000.00, 1, 2013),
(23, 12000.00, 2, 2013),
(24, 16900.00, 1, 2013),
(24, 15200.00, 2, 2013),
(24, 13000.00, 3, 2013),
(25, 19000.00, 4, 2015),
(25, 18100.00, 1, 2016),
(25, 16900.00, 2, 2016),
(26, 18000.00, 3, 2015),
(26, 17000.00, 4, 2015),
(26, 15900.00, 1, 2016),
(27, 30000.00, 1, 2017),
(27, 26000.00, 2, 2017),
(27, 24000.00, 3, 2017),
(28, 24000.00, 2, 2015),
(28, 22000.00, 3, 2015),
(28, 19200.00, 4, 2015),
(29, 23000.00, 4, 2015),
(29, 20000.00, 1, 2016),
(29, 18000.00, 2, 2016),
(30, 16000.00, 3, 2012),
(30, 14300.00, 4, 2012),
(30, 12000.00, 1, 2013),
(31, 34000.00, 1, 2018),
(31, 31000.00, 2, 2018),
(31, 29500.00, 3, 2018),
(32, 16000.00, 2, 2014),
(32, 12000.00, 3, 2014),
(32, 10500.00, 4, 2014),
(33, 18000.00, 1, 2015),
(33, 16500.00, 2, 2015),
(33, 13000.00, 3, 2015),
(34, 20000.00, 2, 2016),
(34, 17000.00, 3, 2016),
(34, 15900.00, 4, 2016),
(35, 25000.00, 3, 2017),
(35, 23000.00, 4, 2017),
(35, 21500.00, 1, 2018),
(36, 48000.00, 3, 2021),
(37, 18000.00, 1, 2016),
(37, 16200.00, 2, 2016),
(37, 13500.00, 3, 2016),
(38, 16000.00, 1, 2016),
(38, 15000.00, 2, 2016),
(38, 13000.00, 3, 2016),
(39, 25000.00, 4, 2017),
(39, 23000.00, 1, 2018),
(39, 20000.00, 2, 2018),
(40, 41500.00, 2, 2018),
(40, 38000.00, 3, 2018),
(40, 35000.00, 4, 2018),
(41, 52000.00, 1, 2018),
(41, 50000.00, 2, 2018),
(41, 48600.00, 3, 2018),
(42, 70000.00, 2, 2018),
(42, 67000.00, 3, 2018),
(42, 66500.00, 4, 2018),
(43, 80500.00, 1, 2018),
(43, 78000.00, 2, 2018),
(43, 75000.00, 3, 2018),
(44, 120000.00, 4, 2018),
(44, 118000.00, 1, 2019),
(44, 117000.00, 2, 2019),
(45, 62000.00, 3, 2018),
(45, 59000.00, 4, 2018),
(45, 57000.00, 1, 2019),
(46, 31000.00, 3, 2016),
(46, 28000.00, 4, 2016),
(46, 27100.00, 1, 2017),
(47, 35000.00, 2, 2016),
(47, 33500.00, 3, 2016),
(47, 32100.00, 4, 2016),
(48, 30000.00, 1, 2016),
(48, 28000.00, 2, 2016),
(48, 26000.00, 3, 2016),
(49, 32000.00, 1, 2017),
(49, 31000.00, 2, 2017),
(49, 29000.00, 3, 2017),
(50, 175000.00, 4, 2020),
(51, 25000.00, 3, 2014),
(51, 24100.00, 4, 2014),
(51, 22000.00, 1, 2015),
(52, 24000.00, 2, 2014),
(52, 22000.00, 3, 2014),
(52, 21000.00, 4, 2014),
(53, 31000.00, 1, 2016),
(53, 30000.00, 2, 2016),
(53, 28100.00, 3, 2016),
(54, 21000.00, 1, 2013),
(54, 19700.00, 2, 2013),
(54, 17440.00, 3, 2013),
(55, 23000.00, 4, 2014),
(55, 21000.00, 1, 2015),
(55, 17600.00, 2, 2015),
(56, 29000.00, 2, 2016),
(56, 28050.00, 3, 2016),
(56, 26500.00, 4, 2016),
(57, 25000.00, 3, 2016),
(57, 23800.00, 4, 2016),
(57, 21100.00, 1, 2017),
(58, 26000.00, 2, 2016),
(58, 24000.00, 3, 2016),
(58, 23000.00, 4, 2017),
(59, 33000.00, 2, 2017),
(59, 32400.00, 3, 2017),
(59, 30500.00, 4, 2017),
(60, 57000.00, 1, 2018),
(60, 54100.00, 2, 2018),
(60, 52300.00, 3, 2018),
(61, 34000.00, 1, 2016),
(61, 32150.00, 2, 2016),
(61, 30100.00, 3, 2016),
(62, 26750.00, 1, 2015),
(62, 24800.00, 2, 2015),
(62, 22340.00, 3, 2015),
(63, 46000.00, 2, 2017),
(63, 42500.00, 3, 2017),
(63, 41000.00, 4, 2017),
(64, 31000.00, 3, 2016),
(64, 28500.00, 4, 2016),
(64, 26900.00, 1, 2017),
(65, 30500.00, 4, 2016),
(65, 27800.00, 1, 2017),
(65, 24300.00, 2, 2017),
(66, 189000.00, 4, 2020),
(67, 9300.00, 4, 2015),
(67, 8650.00, 1, 2016),
(67, 7500.00, 2, 2016),
(68, 18300.00, 2, 2018),
(68, 16000.00, 3, 2018),
(68, 15400.00, 4, 2018),
(69, 15200.00, 1, 2017),
(69, 13400.00, 2, 2017),
(69, 12000.00, 3, 2017),
(70, 15700.00, 2, 2016),
(70, 12300.00, 3, 2016),
(70, 11500.00, 4, 2016),
(71, 16500.00, 1, 2017),
(71, 15400.00, 2, 2017),
(71, 13900.00, 3, 2017),
(72, 15200.00, 2, 2017),
(72, 14200.00, 3, 2017),
(72, 12100.00, 4, 2017),
(73, 53000.00, 1, 2020),
(74, 16300.00, 2, 2017),
(74, 14200.00, 3, 2017),
(74, 12600.00, 4, 2017),
(75, 18900.00, 4, 2018),
(75, 17100.00, 1, 2019),
(75, 16600.00, 2, 2019),
(76, 23000.00, 2, 2018),
(76, 22000.00, 3, 2018),
(76, 19700.00, 4, 2018),
(77, 27100.00, 2, 2018),
(77, 26200.00, 3, 2018),
(77, 23600.00, 4, 2018),
(78, 21000.00, 1, 2017),
(78, 20000.00, 2, 2017),
(78, 18600.00, 3, 2017),
(79, 18600.00, 4, 2018),
(79, 17600.00, 1, 2019),
(79, 16100.00, 2, 2019),
(80, 19000.00, 3, 2018),
(80, 18100.00, 4, 2018),
(80, 16000.00, 1, 2019),
(81, 56000.00, 1, 2022),
(82, 15000.00, 1, 2015),
(82, 14100.00, 2, 2015),
(82, 12000.00, 3, 2015),
(83, 18100.00, 4, 2016),
(83, 16700.00, 1, 2017),
(83, 15000.00, 2, 2017),
(84, 18100.00, 2, 2018),
(84, 16500.00, 3, 2018),
(84, 11000.00, 4, 2018),
(85, 21000.00, 1, 2018),
(85, 18900.00, 2, 2018),
(85, 16700.00, 3, 2018),
(86, 16700.00, 2, 2016),
(86, 15000.00, 3, 2016),
(86, 13900.00, 4, 2016),
(87, 26000.00, 4, 2017),
(87, 23400.00, 1, 2018),
(87, 21000.00, 2, 2018),
(88, 45000.00, 2, 2018),
(88, 43200.00, 3, 2018),
(88, 41100.00, 4, 2018),
(89, 30000.00, 1, 2016),
(89, 28700.00, 2, 2016),
(89, 25600.00, 3, 2016),
(90, 37000.00, 2, 2018),
(90, 35500.00, 3, 2018),
(90, 31200.00, 4, 2018),
(91, 38100.00, 1, 2018),
(91, 37000.00, 2, 2018),
(91, 35600.00, 3, 2018),
(92, 28900.00, 3, 2016),
(92, 27100.00, 4, 2016),
(92, 25900.00, 1, 2017),
(93, 27400.00, 2, 2017),
(93, 25100.00, 3, 2017),
(93, 23300.00, 4, 2017),
(94, 25600.00, 1, 2015),
(94, 23900.00, 2, 2015),
(94, 22100.00, 3, 2015),
(95, 21000.00, 3, 2014),
(95, 20100.00, 4, 2014),
(95, 18700.00, 1, 2015),
(96, 28000.00, 1, 2017),
(96, 27100.00, 2, 2017),
(96, 25300.00, 3, 2017),
(97, 145000.00, 1, 2020),
(98, 25600.00, 1, 2017),
(98, 23100.00, 2, 2017),
(98, 22800.00, 3, 2017),
(99, 21300.00, 1, 2015),
(99, 20050.00, 2, 2015),
(99, 18200.00, 3, 2015),
(100, 27100.00, 2, 2017),
(100, 24300.00, 3, 2017),
(100, 22100.00, 4, 2017),
(101, 35100.00, 1, 2018),
(101, 32900.00, 2, 2018),
(101, 31200.00, 3, 2018),
(102, 156000.00, 3, 2021),
(103, 25100.00, 2, 2016),
(103, 24100.00, 3, 2016),
(103, 22500.00, 4, 2016),
(104, 29000.00, 4, 2017),
(104, 27800.00, 1, 2018),
(104, 25000.00, 2, 2018),
(105, 29900.00, 1, 2018),
(105, 28000.00, 2, 2018),
(105, 27100.00, 3, 2018),
(106, 27500.00, 1, 2017),
(106, 25000.00, 2, 2017),
(106, 22300.00, 3, 2017),
(107, 21000.00, 4, 2017),
(107, 20000.00, 1, 2018),
(107, 17600.00, 2, 2018),
(108, 75000.00, 3, 2017),
(108, 71000.00, 4, 2017),
(108, 67400.00, 1, 2018),
(109, 7000.00, 2, 2014),
(109, 6700.00, 3, 2014),
(109, 5600.00, 4, 2014),
(110, 13000.00, 1, 2017),
(110, 12050.00, 2, 2017),
(110, 10500.00, 3, 2017),
(111, 11000.00, 1, 2014),
(111, 9400.00, 2, 2014),
(111, 8200.00, 3, 2014),
(112, 18100.00, 1, 2017),
(112, 17500.00, 2, 2017),
(112, 15000.00, 3, 2017),
(113, 19060.00, 4, 2017),
(113, 16700.00, 1, 2018),
(113, 14800.00, 2, 2018),
(114, 50000.00, 3, 2020),
(115, 15100.00, 3, 2015),
(115, 14000.00, 4, 2015),
(115, 12100.00, 1, 2016),
(116, 16800.00, 4, 2016),
(116, 15010.00, 1, 2017),
(116, 14100.00, 2, 2017),
(117, 20500.00, 2, 2018),
(117, 19700.00, 3, 2018),
(117, 16100.00, 4, 2018),
(118, 14100.00, 1, 2016),
(118, 13100.00, 2, 2016),
(118, 11500.00, 3, 2016),
(119, 17100.00, 1, 2017),
(119, 15200.00, 2, 2017),
(119, 13600.00, 3, 2017),
(120, 260000.00, 1, 2020),
(121, 120000.00, 4, 2017),
(121, 112000.00, 1, 2018),
(121, 107000.00, 2, 2018),
(122, 106000.00, 3, 2017),
(122, 103600.00, 4, 2017),
(122, 100000.00, 1, 2018),
(123, 97000.00, 2, 2014),
(123, 79000.00, 3, 2014),
(123, 73000.00, 4, 2014),
(124, 68500.00, 1, 2012),
(124, 66000.00, 2, 2012),
(124, 62100.00, 3, 2012),
(125, 65900.00, 1, 2011),
(125, 63000.00, 2, 2011),
(125, 61800.00, 3, 2011),
(126, 360000.00, 4, 2022),
(127, 161000.00, 3, 2017),
(127, 152000.00, 4, 2017),
(127, 148000.00, 1, 2018),
(128, 320000.00, 2, 2022),
(129, 390000.00, 2, 2021),
(130, 15000.00, 2, 2016),
(130, 14100.00, 3, 2016),
(130, 12100.00, 4, 2016),
(131, 15600.00, 1, 2016),
(131, 13500.00, 2, 2016),
(131, 12100.00, 3, 2016),
(132, 18000.00, 4, 2017),
(132, 17200.00, 1, 2018),
(132, 15600.00, 2, 2018),
(133, 16900.00, 2, 2017),
(133, 15100.00, 3, 2017),
(133, 13200.00, 4, 2017),
(134, 15000.00, 1, 2017),
(134, 13200.00, 2, 2017),
(134, 11600.00, 3, 2017),
(135, 16700.00, 1, 2017),
(135, 15100.00, 2, 2017),
(135, 13600.00, 3, 2017),
(136, 11000.00, 4, 2013),
(136, 10000.00, 1, 2014),
(136, 8900.00, 2, 2014),
(137, 12300.00, 2, 2017),
(137, 11000.00, 3, 2017),
(137, 9800.00, 4, 2017),
(138, 8200.00, 2, 2012),
(138, 7100.00, 3, 2012),
(138, 5800.00, 4, 2012),
(139, 16100.00, 1, 2016),
(139, 14700.00, 2, 2016),
(139, 12900.00, 3, 2016),
(140, 13100.00, 4, 2015),
(140, 12000.00, 1, 2016),
(140, 10400.00, 2, 2016),
(141, 18900.00, 4, 2017),
(141, 17200.00, 1, 2018),
(141, 15600.00, 2, 2018),
(142, 19200.00, 1, 2017),
(142, 17960.00, 2, 2017),
(142, 15700.00, 3, 2017),
(143, 100000.00, 3, 2024),
(144, 11600.00, 2, 2017),
(144, 10050.00, 3, 2017),
(144, 8910.00, 4, 2017),
(145, 17200.00, 1, 2017),
(145, 16100.00, 2, 2017),
(145, 14500.00, 3, 2017),
(146, 18900.00, 1, 2017),
(146, 17500.00, 2, 2017),
(146, 15700.00, 3, 2017),
(147, 18000.00, 1, 2017),
(147, 16700.00, 2, 2017),
(147, 15100.00, 3, 2017),
(148, 19100.00, 1, 2017),
(148, 18600.00, 2, 2017),
(148, 16000.00, 3, 2017),
(149, 17600.00, 4, 2017),
(149, 15500.00, 1, 2018),
(149, 13500.00, 2, 2018),
(150, 11000.00, 2, 2012),
(150, 10000.00, 3, 2012),
(150, 9400.00, 4, 2012),
(151, 19400.00, 4, 2017),
(151, 15000.00, 1, 2018),
(151, 13500.00, 2, 2018),
(152, 200000.00, 2, 2025),
(153, 15100.00, 3, 2015),
(153, 14000.00, 4, 2015),
(153, 12500.00, 1, 2016),
(154, 17000.00, 2, 2017),
(154, 16010.00, 3, 2017),
(154, 15300.00, 4, 2017),
(155, 14100.00, 1, 2015),
(155, 13100.00, 2, 2015),
(155, 11000.00, 3, 2015),
(156, 18550.00, 1, 2017),
(156, 18200.00, 2, 2017),
(156, 17100.00, 3, 2017),
(157, 19600.00, 1, 2017),
(157, 18200.00, 2, 2017),
(157, 17800.00, 3, 2017),
(158, 18100.00, 1, 2017),
(158, 17200.00, 2, 2017),
(158, 16400.00, 3, 2017),
(159, 13900.00, 2, 2017),
(159, 12000.00, 3, 2017),
(159, 10700.00, 4, 2017),
(160, 17500.00, 2, 2017),
(160, 16900.00, 3, 2017),
(160, 13500.00, 4, 2017),
(161, 16010.00, 2, 2017),
(161, 15400.00, 3, 2017),
(161, 13200.00, 4, 2017),
(162, 19100.00, 2, 2011),
(162, 18200.00, 3, 2011),
(162, 15000.00, 4, 2011),
(163, 12000.00, 1, 2012),
(163, 10400.00, 2, 2012),
(163, 9800.00, 3, 2012),
(164, 18200.00, 1, 2017),
(164, 17400.00, 2, 2017),
(164, 15020.00, 3, 2017),
(165, 120000.00, 1, 2023),
(166, 16090.00, 4, 2017),
(166, 14100.00, 1, 2018),
(166, 12400.00, 2, 2018),
(167, 14100.00, 4, 2013),
(167, 12100.00, 1, 2014),
(167, 10700.00, 2, 2014),
(168, 13200.00, 3, 2012),
(168, 11200.00, 4, 2012),
(168, 10000.00, 1, 2013),
(169, 9200.00, 2, 2011),
(169, 8400.00, 3, 2011),
(169, 7100.00, 4, 2011),
(170, 18400.00, 1, 2017),
(170, 15000.00, 2, 2017),
(170, 13900.00, 3, 2017),
(171, 16200.00, 3, 2017),
(171, 14100.00, 4, 2017),
(171, 13100.00, 1, 2018),
(172, 14100.00, 2, 2017),
(172, 12400.00, 3, 2017),
(172, 11000.00, 4, 2017),
(173, 16200.00, 1, 2017),
(173, 14100.00, 2, 2017),
(173, 12900.00, 3, 2017),
(174, 19200.00, 4, 2017),
(174, 18100.00, 1, 2018),
(174, 15800.00, 2, 2018),
(175, 16200.00, 1, 2017),
(175, 14100.00, 2, 2017),
(175, 13000.00, 3, 2017),
(176, 17600.00, 1, 2017),
(176, 15400.00, 2, 2017),
(176, 14000.00, 3, 2017),
(177, 16200.00, 4, 2017),
(177, 13450.00, 1, 2018),
(177, 11600.00, 2, 2018),
(178, 60000.00, 3, 2021),
(179, 92000.00, 2, 2017),
(179, 86000.00, 3, 2017),
(179, 82500.00, 4, 2017),
(180, 60200.00, 1, 2012),
(180, 57200.00, 2, 2012),
(180, 54300.00, 3, 2012),
(181, 125000.00, 4, 2018),
(181, 122000.00, 1, 2019),
(181, 118000.00, 2, 2019),
(182, 110000.00, 3, 2017),
(182, 106000.00, 4, 2017),
(182, 103400.00, 1, 2018),
(183, 160200.00, 3, 2018),
(183, 156000.00, 4, 2018),
(183, 141000.00, 1, 2019),
(184, 112000.00, 2, 2016),
(184, 108300.00, 3, 2016),
(184, 106000.00, 4, 2016),
(185, 141000.00, 1, 2017),
(185, 138000.00, 2, 2017),
(185, 135000.00, 3, 2017),
(186, 89000.00, 4, 2015),
(186, 85100.00, 1, 2016),
(186, 83400.00, 2, 2016),
(187, 75600.00, 3, 2014),
(187, 73100.00, 4, 2014),
(187, 71500.00, 1, 2015),
(188, 201000.00, 1, 2017),
(188, 198000.00, 2, 2017),
(188, 189000.00, 3, 2017),
(189, 205000.00, 1, 2017),
(189, 201000.00, 2, 2017),
(189, 198000.00, 3, 2017),
(190, 220000.00, 1, 2017),
(190, 217000.00, 2, 2017),
(190, 215000.00, 3, 2017),
(191, 460000.00, 1, 2023),
(192, 28200.00, 1, 2012),
(192, 26000.00, 2, 2012),
(192, 23100.00, 3, 2012),
(193, 22100.00, 2, 2015),
(193, 20000.00, 3, 2015),
(193, 18700.00, 4, 2015),
(194, 180000.00, 4, 2022),
(195, 14100.00, 2, 2017),
(195, 12000.00, 3, 2017),
(195, 10600.00, 4, 2017),
(196, 8700.00, 1, 2011),
(196, 7500.00, 2, 2011),
(196, 6460.00, 3, 2011),
(197, 21000.00, 4, 2017),
(197, 18700.00, 1, 2018),
(197, 16200.00, 2, 2018),
(198, 26400.00, 2, 2017),
(198, 23400.00, 3, 2017),
(198, 21000.00, 4, 2017),
(199, 24000.00, 1, 2017),
(199, 22100.00, 2, 2017),
(199, 21000.00, 3, 2017),
(200, 25800.00, 2, 2017),
(200, 24100.00, 3, 2017),
(200, 22600.00, 4, 2017),
(201, 26100.00, 1, 2017),
(201, 23850.00, 2, 2017),
(201, 21700.00, 3, 2017),
(202, 18600.00, 1, 2017),
(202, 17500.00, 2, 2017),
(202, 15000.00, 3, 2017),
(203, 21000.00, 1, 2017),
(203, 18500.00, 2, 2017),
(203, 17100.00, 3, 2017),
(204, 29120.00, 4, 2017),
(204, 27500.00, 1, 2018),
(204, 26800.00, 2, 2018),
(205, 21000.00, 2, 2017),
(205, 20000.00, 3, 2017),
(205, 18500.00, 4, 2017),
(206, 27400.00, 3, 2017),
(206, 25200.00, 4, 2017),
(206, 23500.00, 1, 2018),
(207, 26500.00, 2, 2017),
(207, 24800.00, 3, 2017),
(207, 22000.00, 4, 2017),
(208, 26500.00, 1, 2017),
(208, 23000.00, 2, 2017),
(208, 22000.00, 3, 2017),
(209, 25100.00, 1, 2017),
(209, 23700.00, 2, 2017),
(209, 22000.00, 3, 2017),
(210, 27400.00, 1, 2017),
(210, 25010.00, 2, 2017),
(210, 24210.00, 3, 2017),
(211, 42100.00, 3, 2017),
(211, 39700.00, 4, 2017),
(211, 37000.00, 1, 2018),
(212, 29000.00, 2, 2017),
(212, 27600.00, 3, 2017),
(212, 25900.00, 4, 2017),
(213, 29800.00, 1, 2017),
(213, 27800.00, 2, 2017),
(213, 25900.00, 3, 2017),
(214, 26800.00, 4, 2017),
(214, 23900.00, 1, 2018),
(214, 22800.00, 2, 2018),
(215, 26500.00, 3, 2017),
(215, 24000.00, 4, 2017),
(215, 22000.00, 1, 2018),
(216, 27400.00, 2, 2017),
(216, 24200.00, 3, 2017),
(216, 22000.00, 4, 2017),
(217, 67000.00, 1, 2021),
(218, 25400.00, 1, 2017),
(218, 23400.00, 2, 2017),
(218, 22000.00, 3, 2017),
(219, 26100.00, 1, 2017),
(219, 25000.00, 2, 2017),
(219, 24100.00, 3, 2017),
(220, 23400.00, 2, 2017),
(220, 21000.00, 3, 2017),
(220, 19800.00, 4, 2017),
(221, 32500.00, 3, 2017),
(221, 31200.00, 4, 2017),
(221, 29200.00, 1, 2018),
(222, 39800.00, 2, 2017),
(222, 37020.00, 3, 2017),
(222, 35000.00, 4, 2017),
(223, 45000.00, 4, 2020),
(224, 25000.00, 1, 2017),
(224, 24500.00, 2, 2017),
(224, 23000.00, 3, 2017),
(225, 26010.00, 2, 2017),
(225, 24500.00, 3, 2017),
(225, 23000.00, 4, 2017),
(226, 25100.00, 1, 2017),
(226, 23000.00, 2, 2017),
(226, 21400.00, 3, 2017),
(227, 35100.00, 4, 2017),
(227, 33600.00, 1, 2018),
(227, 31000.00, 2, 2018),
(228, 37500.00, 2, 2012),
(228, 34500.00, 3, 2012),
(228, 33100.00, 4, 2012),
(229, 43100.00, 3, 2011),
(229, 39500.00, 4, 2011),
(229, 38000.00, 1, 2012),
(230, 26800.00, 2, 2017),
(230, 24500.00, 3, 2017),
(230, 25100.00, 4, 2017),
(231, 26000.00, 2, 2011),
(231, 23400.00, 3, 2011),
(231, 22100.00, 4, 2011),
(232, 54000.00, 1, 2017),
(232, 52100.00, 2, 2017),
(232, 50500.00, 3, 2017),
(233, 25410.00, 1, 2017),
(233, 23100.00, 2, 2017),
(233, 22100.00, 3, 2017),
(234, 24010.00, 3, 2017),
(234, 22500.00, 4, 2017),
(234, 21000.00, 1, 2018),
(235, 31400.00, 2, 2013),
(235, 29170.00, 3, 2013),
(235, 28400.00, 4, 2013),
(236, 41000.00, 1, 2017),
(236, 38200.00, 2, 2017),
(236, 35400.00, 3, 2017),
(237, 32010.00, 2, 2017),
(237, 30100.00, 3, 2017),
(237, 29400.00, 4, 2017),
(238, 17400.00, 1, 2017),
(238, 15000.00, 2, 2017),
(238, 13100.00, 3, 2017),
(239, 34100.00, 4, 2017),
(239, 29000.00, 1, 2018),
(239, 28400.00, 2, 2018),
(240, 41000.00, 3, 2017),
(240, 39200.00, 4, 2017),
(240, 37800.00, 1, 2018),
(241, 37100.00, 2, 2017),
(241, 36500.00, 3, 2017),
(241, 34000.00, 4, 2017),
(242, 54100.00, 1, 2017),
(242, 52100.00, 2, 2017),
(242, 49700.00, 3, 2017),
(243, 23000.00, 4, 2017),
(243, 21000.00, 1, 2018),
(243, 20000.00, 2, 2018),
(244, 41040.00, 3, 2017),
(244, 38500.00, 4, 2017),
(244, 37000.00, 1, 2018),
(245, 41000.00, 2, 2017),
(245, 38400.00, 3, 2017),
(245, 37500.00, 4, 2017),
(246, 112000.00, 1, 2023),
(247, 89000.00, 2, 2021),
(248, 25000.00, 3, 2012),
(248, 23100.00, 4, 2012),
(248, 18500.00, 1, 203),
(249, 32400.00, 4, 2017),
(249, 31000.00, 1, 2018),
(249, 29300.00, 2, 2018),
(250, 34000.00, 1, 2017),
(250, 31000.00, 2, 2017),
(250, 28100.00, 3, 2017),
(251, 29200.00, 1, 2017),
(251, 27300.00, 2, 2017),
(251, 25100.00, 3, 2017),
(252, 31000.00, 1, 2017),
(252, 27400.00, 2, 2017),
(252, 25600.00, 3, 2017),
(253, 29000.00, 1, 2017),
(253, 27400.00, 2, 2017),
(253, 24100.00, 3, 2017),
(254, 31040.00, 1, 2017),
(254, 28400.00, 2, 2017),
(254, 26500.00, 3, 2017),
(255, 35000.00, 2, 2017),
(255, 31500.00, 3, 2017),
(255, 28500.00, 4, 2017),
(256, 25000.00, 2, 2017),
(256, 23400.00, 3, 2017),
(256, 21400.00, 4, 2017),
(257, 25800.00, 2, 2017),
(257, 24100.00, 3, 2017),
(257, 22400.00, 4, 2017),
(258, 25100.00, 4, 2017),
(258, 24000.00, 1, 2018),
(258, 22100.00, 2, 2018),
(259, 35000.00, 4, 2020),
(260, 22100.00, 2, 2018),
(260, 19600.00, 3, 2018),
(260, 18000.00, 4, 2018),
(261, 21400.00, 4, 2017),
(261, 20000.00, 1, 2018),
(261, 18400.00, 2, 2018),
(262, 12400.00, 3, 2012),
(262, 11100.00, 4, 2012),
(262, 9900.00, 1, 2013),
(263, 24100.00, 1, 2017),
(263, 21400.00, 2, 2017),
(263, 20000.00, 3, 2017),
(264, 25100.00, 4, 2017),
(264, 23000.00, 1, 2018),
(264, 21000.00, 2, 2018),
(265, 25000.00, 1, 2017),
(265, 23500.00, 2, 2017),
(265, 21000.00, 3, 2017),
(266, 10000.00, 1, 2011),
(266, 8600.00, 2, 2011),
(266, 7800.00, 3, 2011),
(267, 41200.00, 1, 2017),
(267, 38600.00, 2, 2017),
(267, 37300.00, 3, 2017),
(268, 7600.00, 1, 2010),
(268, 6800.00, 2, 2010),
(268, 5400.00, 3, 2010),
(269, 31000.00, 4, 2017),
(269, 28100.00, 1, 2018),
(269, 26700.00, 2, 2018),
(270, 24100.00, 3, 2017),
(270, 22600.00, 4, 2017),
(270, 21000.00, 1, 2018),
(271, 42500.00, 2, 2017),
(271, 39600.00, 3, 2017),
(271, 37500.00, 4, 2017),
(272, 29500.00, 1, 2017),
(272, 26500.00, 2, 2017),
(272, 22900.00, 3, 2017),
(273, 25000.00, 4, 2017),
(273, 22500.00, 1, 2018),
(273, 21600.00, 2, 2018),
(274, 37600.00, 1, 2017),
(274, 35900.00, 2, 2017),
(274, 33700.00, 3, 2017),
(275, 87000.00, 1, 2022),
(276, 34000.00, 1, 2017),
(276, 31000.00, 2, 2017),
(276, 29700.00, 3, 2017),
(277, 25300.00, 4, 2017),
(277, 22700.00, 1, 2018),
(277, 21500.00, 2, 2018),
(278, 31000.00, 2, 2017),
(278, 29600.00, 3, 2017),
(278, 26700.00, 4, 2017),
(279, 23000.00, 2, 2017),
(279, 22100.00, 3, 2017),
(279, 20500.00, 4, 2017),
(280, 73000.00, 1, 2021),
(281, 25000.00, 4, 2017),
(281, 23100.00, 1, 2018),
(281, 21200.00, 2, 2018);

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

--
-- Structură tabel pentru tabel `producatori`
--

DROP TABLE IF EXISTS `producatori`;
CREATE TABLE IF NOT EXISTS `producatori` (
  `id_producator` int(3) NOT NULL AUTO_INCREMENT,
  `den_producator` varchar(50) NOT NULL,
  `an_infiintare` int(4) NOT NULL,
  PRIMARY KEY (`id_producator`),
  UNIQUE KEY `den_producator` (`den_producator`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `producatori`
--

INSERT INTO `producatori` (`id_producator`, `den_producator`, `an_infiintare`) VALUES
(1, 'Dacia', 1920),
(2, 'Audi', 1980),
(3, 'Mercedes', 1800),
(4, 'BMW', 1890),
(5, 'Volkswagen', 1920),
(6, 'Opel', 1946),
(7, 'Toyota', 1709),
(8, 'Honda', 1879),
(9, 'Isuzu', 1862),
(10, 'Mitsubishi', 1972),
(11, 'Mazda', 2000),
(12, 'Suzuki', 1789),
(13, 'Jaguar', 1962),
(14, 'Bentley', 1821),
(15, 'Rolls Royce', 1907),
(16, 'Range Rover', 1972),
(17, 'Aston Martin', 2000),
(18, 'Volvo', 1952),
(19, 'Ford', 1872),
(20, 'Alfa Romeo', 1890),
(21, 'Fiat', 1999),
(22, 'Renault', 1982),
(23, 'Peugeot', 1982),
(24, 'Citroen', 2001),
(25, 'Hyundai', 1921),
(26, 'Kia', 1821);

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

--
-- Structură tabel pentru tabel `serii_modele`
--

DROP TABLE IF EXISTS `serii_modele`;
CREATE TABLE IF NOT EXISTS `serii_modele` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `id_producator` int(3) NOT NULL,
  `den_producator` varchar(100) NOT NULL,
  `den_model` varchar(100) NOT NULL,
  `an_fabricatie` int(4) NOT NULL,
  `lansat` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `serii_modele`
--

INSERT INTO `serii_modele` (`id_model`, `id_producator`, `den_producator`, `den_model`, `an_fabricatie`, `lansat`) VALUES
(1, 1, 'Dacia', 'Duster', 2018, 1),
(2, 6, 'Opel', 'Astra GTC', 2017, 1),
(3, 4, 'BMW', 'Seria 5 520', 2014, 1),
(4, 24, 'Citroen', 'C2', 2016, 1),
(5, 19, 'Dodge', 'Challenger', 2015, 1),
(6, 25, 'Hyundai', 'i40', 2014, 1),
(7, 22, 'Renault', 'Kadjar', 2016, 1),
(8, 21, 'Fiat', '500', 2020, 0),
(9, 19, 'Ford', 'Focus', 2018, 1),
(10, 2, 'Audi', 'A6', 2017, 1),
(11, 2, 'Audi', 'A6', 2014, 1),
(12, 2, 'Audi', 'A6 Combi', 2014, 1),
(13, 2, 'Audi', 'A6', 2012, 1),
(14, 2, 'Audi', 'A6 Avant', 2021, 0),
(15, 2, 'Audi', 'A6 Allroad', 2009, 1),
(16, 2, 'Audi', 'A6', 2006, 1),
(17, 2, 'Audi', 'S6', 2017, 1),
(18, 2, 'Audi', 'S6', 2014, 1),
(19, 2, 'Audi', 'S6', 2012, 1),
(20, 2, 'Audi', 'RS6', 2017, 1),
(21, 2, 'Audi', 'RS6', 2014, 1),
(22, 2, 'Audi', 'A7', 2016, 1),
(23, 2, 'Audi', 'A7', 2012, 1),
(24, 2, 'Audi', 'A7', 2013, 1),
(25, 2, 'Audi', 'A7', 2015, 1),
(26, 2, 'Audi', 'A7', 2015, 1),
(27, 2, 'Audi', 'S7', 2017, 1),
(28, 2, 'Audi', 'S7', 2015, 1),
(29, 2, 'Audi', 'S7', 2015, 1),
(30, 2, 'Audi', 'S7', 2012, 1),
(31, 2, 'Audi', 'A5', 2018, 1),
(32, 2, 'Audi', 'A5', 2014, 1),
(33, 2, 'Audi', 'A5', 2015, 1),
(34, 2, 'Audi', 'A5', 2016, 1),
(35, 2, 'Audi', 'A5', 2017, 1),
(36, 2, 'Audi', 'A1 SportBack', 2021, 0),
(37, 2, 'Audi', 'A1', 2016, 1),
(38, 2, 'Audi', 'A1 Urban', 2016, 1),
(39, 2, 'Audi', 'A1 Quattro', 2017, 1),
(40, 2, 'Audi', 'A1 e-tron', 2018, 1),
(41, 2, 'Audi', 'A8', 2018, 1),
(42, 2, 'Audi', 'A8 L', 2018, 1),
(43, 2, 'Audi', 'A8 L hybrid', 2018, 1),
(44, 2, 'Audi', 'A8 L Security', 2018, 1),
(45, 2, 'Audi', 'A8 4.0 TDI', 2018, 1),
(46, 3, 'Mercedes', 'CLA C117', 2016, 1),
(47, 3, 'Mercedes', 'CLA X117', 2016, 1),
(48, 3, 'Mercedes', 'CLC A205', 2016, 1),
(49, 3, 'Mercedes', 'CLC C205', 2017, 1),
(50, 3, 'Mercedes', 'CLK C238', 2020, 0),
(51, 3, 'Mercedes', 'CL C217', 2014, 1),
(52, 3, 'Mercedes', 'E S212', 2014, 1),
(53, 3, 'Mercedes', 'E S213', 2016, 1),
(54, 3, 'Mercedes', 'S V212', 2013, 1),
(55, 3, 'Mercedes', 'SLK R172', 2014, 1),
(56, 3, 'Mercedes', 'SLK R172', 2016, 1),
(57, 3, 'Mercedes', 'GLK X204', 2016, 1),
(58, 3, 'Mercedes', 'GLK X253', 2016, 1),
(59, 3, 'Mercedes', 'GLA X156', 2017, 1),
(60, 3, 'Mercedes', 'M W166', 2018, 1),
(61, 3, 'Mercedes', 'M C292', 2016, 1),
(62, 3, 'Mercedes', 'CLS C257', 2015, 1),
(63, 3, 'Mercedes', 'SLS GT', 2017, 1),
(64, 3, 'Mercedes', 'SLS GT', 2016, 1),
(65, 3, 'Mercedes', 'X BR470', 2016, 1),
(66, 3, 'Mercedes', 'CLS X218', 2020, 0),
(67, 1, 'Dacia', 'Duster', 2015, 1),
(68, 1, 'Dacia', 'Logan', 2018, 1),
(69, 1, 'Dacia', 'Sandero', 2017, 1),
(70, 1, 'Dacia', 'Dokker Van', 2016, 1),
(71, 1, 'Dacia', 'Lodgy', 2017, 1),
(72, 1, 'Dacia', 'Logan MCV', 2017, 1),
(73, 5, 'Volkswagen', 'Golf 8', 2020, 0),
(74, 5, 'Volkswagen', 'Golf 7', 2017, 1),
(75, 5, 'Volkswagen', 'Polo Happy', 2018, 1),
(76, 5, 'Volkswagen', 'e-up', 2018, 1),
(77, 5, 'Volkswagen', 'Jetta', 2018, 1),
(78, 5, 'Volkswagen', 'Passat', 2017, 1),
(79, 5, 'Volkswagen', 'Polo', 2018, 1),
(80, 5, 'Volkswagen', 'Bettle', 2018, 1),
(81, 5, 'Volkswagen', 'Arteon', 2022, 0),
(82, 5, 'Volkswagen', 'Touran', 2015, 1),
(83, 5, 'Volkswagen', 'Tiguan', 2016, 1),
(84, 5, 'Volkswagen', 'Touareg', 2018, 1),
(85, 5, 'Volkswagen', 'Caddy', 2018, 1),
(86, 5, 'Volkswagen', 'Golf GTI', 2016, 1),
(87, 5, 'Volkswagen', 'T-Roc', 2017, 1),
(88, 4, 'BMW', 'Seria 1 130', 2018, 1),
(89, 4, 'BMW', 'Seria 1 M140i', 2016, 1),
(90, 4, 'BMW', 'Seria 2 200', 2018, 1),
(91, 4, 'BMW', 'Seria 2 M240i Coupe', 2018, 1),
(92, 4, 'BMW', 'Seria 2 230 Cabriolet', 2016, 1),
(93, 4, 'BMW', 'Seria 3 350 Sedan', 2017, 1),
(94, 4, 'BMW', 'Seria 4 440 Gran Coupe', 2015, 1),
(95, 4, 'BMW', 'Seria 4 M440 Cabriolet', 2014, 1),
(96, 4, 'BMW', 'Seria 5 M550i xDrive Sedan', 2017, 1),
(97, 4, 'BMW', 'Seria 5 M550 Competition', 2020, 0),
(98, 4, 'BMW', 'Seria 6 640 Grand Turismo', 2017, 1),
(99, 4, 'BMW', 'Seria i i8 Roadster', 2015, 1),
(100, 4, 'BMW', 'Seria X5 M', 2017, 1),
(101, 4, 'BMW', 'Seria X6 M ', 2018, 1),
(102, 4, 'BMW', 'Seria X3 M40i', 2021, 0),
(103, 4, 'BMW', 'Seria X4 400', 2016, 1),
(104, 4, 'BMW', 'Seria X2', 2017, 1),
(105, 4, 'BMW', 'Seria X1', 2018, 1),
(106, 4, 'BMW', 'Seria 7 750 Sedan', 2017, 1),
(107, 4, 'BMW', 'Seria 7 740i Performance', 2017, 1),
(108, 4, 'BMW', 'Seria 7 M760Li xDrive', 2017, 1),
(109, 25, 'Hyundai', 'Eon', 2014, 1),
(110, 25, 'Hyundai', 'i10', 2017, 1),
(111, 25, 'Hyundai', 'Accent', 2014, 1),
(112, 25, 'Hyundai', 'i20', 2017, 1),
(113, 25, 'Hyundai', 'i30', 2017, 1),
(114, 25, 'Hyundai', 'i40', 2020, 0),
(115, 25, 'Hyundai', 'Elantra', 2015, 1),
(116, 25, 'Hyundai', 'Sonata', 2016, 1),
(117, 25, 'Hyundai', 'Grandeur', 2018, 1),
(118, 25, 'Hyundai', 'Equus', 2016, 1),
(119, 25, 'Hyundai', 'Genesis', 2017, 1),
(120, 3, 'Maybach', 'Mercedes-Maybach G 650 Landaulet', 2020, 0),
(121, 3, 'Maybach', 'Mercedes-Maybach S600 Pullman', 2017, 1),
(122, 3, 'Maybach', 'Mercedes-Maybach S500', 2017, 1),
(123, 3, 'Maybach', 'Mercedes-Maybach S600', 2014, 1),
(124, 3, 'Maybach', 'Maybach Guard', 2012, 1),
(125, 3, 'Maybach', 'Maybach 62 Landaulet', 2011, 1),
(126, 3, 'Maybach', 'Maybach 62S', 2022, 0),
(127, 3, 'Maybach', 'Maybach Exelero ', 2017, 1),
(128, 3, 'Maybach', 'Maybach 62 Zeppelin', 2022, 0),
(129, 3, 'Maybach', 'Maybach 57 Zeppelin', 2021, 0),
(130, 6, 'Opel', 'Agila', 2016, 1),
(131, 6, 'Opel', 'Karl', 2016, 1),
(132, 6, 'Opel', 'Corsa', 2017, 1),
(133, 6, 'Opel', 'Tigra', 2017, 1),
(134, 6, 'Opel', 'Astra F', 2017, 1),
(135, 6, 'Opel', 'Astra G', 2017, 1),
(136, 6, 'Opel', 'Astra H', 2013, 1),
(137, 6, 'Opel', 'Astra J', 2017, 1),
(138, 6, 'Opel', 'Astra K', 2012, 1),
(139, 6, 'Opel', 'Ampera', 2016, 1),
(140, 6, 'Opel', 'Vectra', 2015, 1),
(141, 6, 'Opel', 'Signum', 2017, 1),
(142, 6, 'Opel', 'Insignia', 2017, 1),
(143, 6, 'Opel', 'Combo', 2024, 0),
(144, 6, 'Opel', 'Zafira', 2017, 1),
(145, 6, 'Opel', 'Mokka', 2017, 1),
(146, 8, 'Honda', 'Accord', 2017, 1),
(147, 8, 'Honda', 'Amaze', 2017, 1),
(148, 8, 'Honda', 'Civic', 2017, 1),
(149, 8, 'Honda', 'Civic Type R', 2017, 1),
(150, 8, 'Honda', 'CR-V', 2012, 1),
(151, 8, 'Honda', 'HR-V', 2017, 1),
(152, 8, 'Honda', 'Legend', 2025, 0),
(153, 8, 'Honda', 'NSX', 2015, 1),
(154, 8, 'Honda', 'Pilot', 2017, 1),
(155, 8, 'Honda', 'S660', 2015, 1),
(156, 8, 'Honda', 'Spirior', 2017, 1),
(157, 8, 'Honda', 'UR-V', 2017, 1),
(158, 8, 'Honda', 'Vamos', 2017, 1),
(159, 8, 'Honda', 'Clarity', 2017, 1),
(160, 8, 'Honda', 'WR-V', 2017, 1),
(161, 8, 'Honda', 'XR-V', 2017, 1),
(162, 10, 'Mitsubishi', 'Pajero', 2011, 1),
(163, 10, 'Mitsubishi', 'Eclipse', 2012, 1),
(164, 10, 'Mitsubishi', 'Outlander', 2017, 1),
(165, 10, 'Mitsubishi', 'ASX', 2023, 0),
(166, 10, 'Mitsubishi', 'Lancer VII', 2017, 1),
(167, 10, 'Mitsubishi', 'Triton', 2013, 1),
(168, 10, 'Mitsubishi', 'Montero', 2012, 1),
(169, 10, 'Mitsubishi', 'Mirage', 2011, 1),
(170, 10, 'Mitsubishi', 'Lancer VIII', 2017, 1),
(171, 10, 'Mitsubishi', 'Lancer IX', 2017, 1),
(172, 10, 'Mitsubishi', 'Lancer X', 2017, 1),
(173, 20, 'Alfa Romeo', 'MiTo', 2017, 1),
(174, 20, 'Alfa Romeo', 'Giulietta', 2017, 1),
(175, 20, 'Alfa Romeo', '4C', 2017, 1),
(176, 20, 'Alfa Romeo', 'Giulia', 2017, 1),
(177, 20, 'Alfa Romeo', 'Stelvio', 2017, 1),
(178, 20, 'Alfa Romeo', '8C', 2021, 0),
(179, 17, 'Aston Martin', 'Vanquish ', 2017, 1),
(180, 17, 'Aston Martin', 'Rapide', 2012, 1),
(181, 17, 'Aston Martin', 'DB9', 2019, 1),
(182, 17, 'Aston Martin', 'DB11', 2017, 1),
(183, 17, 'Aston Martin', 'V12 Vantage', 2018, 1),
(184, 17, 'Aston Martin', 'V8 Vantage', 2016, 1),
(185, 17, 'Aston Martin', 'Lagonda', 2017, 1),
(186, 17, 'Aston Martin', 'Volante', 2015, 1),
(187, 17, 'Aston Martin', 'Vulcan', 2014, 1),
(188, 14, 'Bentley', 'Mulsanne', 2017, 1),
(189, 14, 'Bentley', 'Flying Spur', 2017, 1),
(190, 14, 'Bentley', 'Bentayga', 2017, 1),
(191, 14, 'Bentley', 'Continental GT', 2023, 0),
(192, 16, 'Range Rover', 'Fourth Generation 3L', 2012, 1),
(193, 16, 'Range Rover', 'Fourth Generation 4.4L', 2015, 1),
(194, 16, 'Range Rover', 'Fourth Generation 5.0L', 2022, 0),
(195, 7, 'Toyota', 'Prius', 2017, 1),
(196, 7, 'Toyota', 'Corolla', 2011, 1),
(197, 7, 'Toyota', 'CH-R', 2017, 1),
(198, 7, 'Toyota', 'Land Cruiser', 2017, 1),
(199, 7, 'Toyota', 'Hilux', 2017, 1),
(200, 7, 'Toyota', 'Avensis', 2017, 1),
(201, 7, 'Toyota', 'Auris', 2017, 1),
(202, 7, 'Toyota', 'Aygo', 2017, 1),
(203, 7, 'Toyota', 'Yaris', 2017, 1),
(204, 11, 'Mazda', 'CX-9', 2017, 1),
(205, 11, 'Mazda', 'CX-8', 2017, 1),
(206, 11, 'Mazda', 'CX-5', 2017, 1),
(207, 11, 'Mazda', 'CX-4', 2017, 1),
(208, 11, 'Mazda', 'CX-3', 2017, 1),
(209, 11, 'Mazda', 'MX-5', 2017, 1),
(210, 11, 'Mazda', 'Mazda 3', 2017, 1),
(211, 11, 'Mazda', 'Mazda 6', 2017, 1),
(212, 13, 'Jaguar', 'XJ', 2017, 1),
(213, 13, 'Jaguar', 'XF', 2017, 1),
(214, 13, 'Jaguar', 'XE', 2017, 1),
(215, 13, 'Jaguar', 'F-Type', 2017, 1),
(216, 9, 'Isuzu', 'D-Max', 2017, 1),
(217, 9, 'Isuzu', 'Mu-X', 2021, 0),
(218, 12, 'Suzuki', 'SX4', 2017, 1),
(219, 12, 'Suzuki', 'Jimny', 2017, 1),
(220, 12, 'Suzuki', 'Vitara', 2017, 1),
(221, 12, 'Suzuki', 'Swift', 2017, 1),
(222, 12, 'Suzuki', 'Alto', 2017, 1),
(223, 12, 'Suzuki', 'Ignis', 2020, 0),
(224, 17, 'Saab', '9-4X', 2017, 1),
(225, 17, 'Saab', '9-5', 2017, 1),
(226, 17, 'Saab', '9-3', 2017, 1),
(227, 17, 'Saab', '9-7X', 2017, 1),
(228, 18, 'Volvo', 'S60', 2012, 1),
(229, 18, 'Volvo', 'V60', 2011, 1),
(230, 18, 'Volvo', 'V40', 2017, 1),
(231, 18, 'Volvo', 'XC90', 2011, 1),
(232, 18, 'Volvo', 'S90', 2017, 1),
(233, 18, 'Volvo', 'V90', 2017, 1),
(234, 18, 'Volvo', 'XC60', 2017, 1),
(235, 18, 'Volvo', 'C70', 2013, 1),
(236, 19, 'Ford', 'Ka', 2017, 1),
(237, 19, 'Ford', 'Fiesta', 2017, 1),
(238, 19, 'Ford', 'Mondeo', 2017, 1),
(239, 19, 'Ford', 'Mustang', 2017, 1),
(240, 19, 'Ford', 'C-Max', 2017, 1),
(241, 19, 'Ford', 'Galaxy', 2017, 1),
(242, 19, 'Ford', 'Kuga', 2017, 1),
(243, 19, 'Ford', 'Ecosport', 2017, 1),
(244, 14, 'Cadillac', 'CTS', 2017, 1),
(245, 19, 'Hummer', 'H2', 2017, 1),
(246, 19, 'Hummer', 'H3', 2023, 0),
(247, 19, 'Pontiac', 'Vibe', 2021, 0),
(248, 19, 'Pontiac', 'Solstice', 2012, 1),
(249, 19, 'Dodge', 'Avenger', 2017, 1),
(250, 19, 'Dodge', 'Caliber', 2017, 1),
(251, 19, 'Dodge', 'Colt', 2017, 1),
(252, 19, 'Chrysler', '200', 2017, 1),
(253, 19, 'Chrysler', 'Crossfire', 2017, 1),
(254, 19, 'Chrysler', 'Cruiser', 2017, 1),
(255, 19, 'Chrysler', 'Hemi', 2017, 1),
(256, 24, 'Chevrolet', 'Spark', 2017, 1),
(257, 24, 'Chevrolet', 'Bolt', 2017, 1),
(258, 24, 'Chevrolet', 'Impala', 2017, 1),
(259, 24, 'Chevrolet', 'Captiva', 2020, 0),
(260, 24, 'Chevrolet', 'Camaro', 2018, 1),
(261, 21, 'Fiat', 'Panda', 2017, 1),
(262, 21, 'Fiat', 'Doblo', 2012, 1),
(263, 21, 'Fiat', 'Punto', 2017, 1),
(264, 22, 'Renault', 'Captur', 2017, 1),
(265, 22, 'Renault', 'Clio', 2017, 1),
(266, 22, 'Renault', 'Talisman', 2011, 1),
(267, 22, 'Renault', 'Megane', 2017, 1),
(268, 22, 'Renault', 'Twingo', 2010, 1),
(269, 23, 'Peugeot', '301', 2017, 1),
(270, 23, 'Peugeot', '308', 2017, 1),
(271, 23, 'Peugeot', '108', 2017, 1),
(272, 23, 'Peugeot', '208', 2017, 1),
(273, 23, 'Peugeot', '3008', 2017, 1),
(274, 24, 'Citroen', 'C3', 2017, 1),
(275, 24, 'Citroen', 'C5', 2022, 0),
(276, 24, 'Citroen', 'C6', 2017, 1),
(277, 24, 'Citroen', 'C-Crosser', 2017, 1),
(278, 26, 'Kia', 'Cee`d', 2017, 1),
(279, 26, 'Kia', 'Optima', 2017, 1),
(280, 26, 'Kia', 'Picanto', 2021, 0),
(281, 26, 'Kia', 'Sportage', 2017, 1);

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

--
-- Structură tabel pentru tabel `specificatii_confort`
--

DROP TABLE IF EXISTS `specificatii_confort`;
CREATE TABLE IF NOT EXISTS `specificatii_confort` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `nr_portiere` int(2) NOT NULL,
  `AC` tinyint(1) NOT NULL,
  `tip_AC` varchar(20) NOT NULL,
  `Comenzi_volan` tinyint(1) NOT NULL,
  `Cruise_control` tinyint(1) NOT NULL,
  `rating_siguranta` int(1) NOT NULL,
  `incalzire_scaune` tinyint(1) NOT NULL,
  `computer_bord` tinyint(1) NOT NULL,
  `plafon_panoramic` tinyint(1) NOT NULL,
  `tapiterie` varchar(50) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `specificatii_confort`
--

INSERT INTO `specificatii_confort` (`id_model`, `nr_portiere`, `AC`, `tip_AC`, `Comenzi_volan`, `Cruise_control`, `rating_siguranta`, `incalzire_scaune`, `computer_bord`, `plafon_panoramic`, `tapiterie`) VALUES
(1, 3, 1, 'AC', 1, 1, 4, 0, 0, 0, 'Piele'),
(2, 4, 0, 'Bizonal', 1, 1, 1, 1, 0, 0, 'Piele'),
(3, 3, 0, 'Bizonal', 0, 0, 2, 0, 0, 0, 'Piele'),
(4, 2, 0, 'AC', 0, 1, 5, 0, 0, 1, 'Alcantara'),
(5, 4, 1, 'AC', 1, 0, 2, 1, 1, 1, 'Piele'),
(6, 4, 1, 'AC', 0, 0, 2, 1, 0, 1, 'Textil'),
(7, 4, 0, 'Climatronic', 1, 0, 1, 0, 1, 1, 'Textil'),
(8, 3, 0, 'Climatronic', 1, 0, 1, 1, 1, 0, 'Piele'),
(9, 4, 0, 'AC', 1, 0, 3, 1, 0, 0, 'Piele'),
(10, 4, 1, 'AC', 1, 1, 2, 0, 0, 0, 'Piele'),
(11, 3, 1, 'AC', 0, 0, 3, 0, 0, 1, 'Alcantara'),
(12, 3, 0, 'Climatronic', 1, 0, 3, 1, 0, 1, 'Alcantara'),
(13, 4, 1, 'Climatronic', 1, 0, 3, 0, 0, 0, 'Alcantara'),
(14, 4, 1, 'Bizonal', 1, 1, 2, 1, 0, 1, 'Piele'),
(15, 3, 0, 'Climatronic', 1, 0, 3, 1, 0, 0, 'Piele'),
(16, 2, 1, 'Bizonal', 0, 1, 1, 0, 1, 0, 'Textil'),
(17, 4, 0, 'Climatronic', 0, 1, 1, 0, 1, 0, 'Alcantara'),
(18, 4, 0, 'AC', 1, 1, 3, 0, 0, 0, 'Alcantara'),
(19, 2, 0, 'AC', 0, 1, 2, 0, 1, 1, 'Alcantara'),
(20, 4, 1, 'AC', 1, 0, 2, 1, 1, 1, 'Piele'),
(21, 3, 0, 'Bizonal', 1, 0, 5, 1, 1, 1, 'Piele'),
(22, 4, 0, 'Bizonal', 1, 0, 3, 0, 0, 0, 'Piele'),
(23, 3, 1, 'Climatronic', 1, 0, 4, 0, 1, 1, 'Alcantara'),
(24, 3, 0, 'Climatronic', 1, 1, 2, 0, 0, 1, 'Textil'),
(25, 3, 1, 'Bizonal', 1, 0, 1, 1, 1, 0, 'Alcantara'),
(26, 3, 0, 'Bizonal', 0, 0, 5, 0, 1, 0, 'Alcantara'),
(27, 4, 0, 'Bizonal', 0, 0, 2, 1, 1, 1, 'Alcantara'),
(28, 3, 0, 'Climatronic', 0, 0, 3, 0, 1, 1, 'Piele'),
(29, 3, 1, 'Climatronic', 1, 0, 5, 1, 1, 0, 'Piele'),
(30, 4, 1, 'Bizonal', 0, 1, 3, 1, 1, 0, 'Textil'),
(31, 2, 1, 'Climatronic', 0, 1, 1, 0, 0, 0, 'Textil'),
(32, 2, 0, 'AC', 1, 1, 5, 1, 0, 1, 'Textil'),
(33, 3, 1, 'Climatronic', 1, 1, 2, 0, 1, 0, 'Textil'),
(34, 3, 1, 'Bizonal', 1, 1, 3, 1, 0, 0, 'Textil'),
(35, 2, 0, 'Climatronic', 0, 0, 1, 0, 0, 1, 'Piele'),
(36, 2, 0, 'AC', 1, 0, 2, 0, 0, 1, 'Textil'),
(37, 4, 1, 'Bizonal', 0, 0, 3, 0, 0, 1, 'Piele'),
(38, 4, 0, 'AC', 0, 0, 1, 0, 0, 0, 'Piele'),
(39, 3, 0, 'Bizonal', 0, 0, 1, 0, 1, 0, 'Textil'),
(40, 3, 0, 'AC', 0, 1, 1, 0, 1, 1, 'Alcantara'),
(41, 2, 1, 'AC', 0, 0, 3, 1, 0, 1, 'Alcantara'),
(42, 4, 0, 'AC', 1, 0, 5, 1, 0, 0, 'Textil'),
(43, 4, 1, 'Climatronic', 0, 0, 1, 0, 0, 0, 'Piele'),
(44, 4, 1, 'Climatronic', 0, 1, 2, 0, 0, 1, 'Textil'),
(45, 4, 0, 'AC', 0, 1, 2, 0, 1, 1, 'Piele'),
(46, 2, 1, 'AC', 1, 0, 2, 0, 0, 1, 'Textil'),
(47, 3, 1, 'AC', 1, 1, 1, 0, 0, 1, 'Alcantara'),
(48, 4, 0, 'Bizonal', 0, 1, 2, 1, 0, 0, 'Alcantara'),
(49, 2, 1, 'Climatronic', 0, 0, 4, 1, 0, 1, 'Alcantara'),
(50, 2, 1, 'Bizonal', 0, 1, 2, 0, 0, 1, 'Textil'),
(51, 2, 0, 'Climatronic', 0, 1, 3, 0, 1, 0, 'Alcantara'),
(52, 4, 1, 'Climatronic', 0, 0, 1, 1, 1, 1, 'Piele'),
(53, 4, 1, 'AC', 1, 1, 3, 1, 0, 1, 'Textil'),
(54, 2, 0, 'Climatronic', 0, 0, 2, 0, 1, 1, 'Textil'),
(55, 2, 1, 'AC', 0, 0, 1, 1, 0, 0, 'Textil'),
(56, 4, 0, 'AC', 1, 1, 2, 1, 1, 0, 'Alcantara'),
(57, 4, 1, 'AC', 0, 1, 3, 0, 0, 1, 'Piele'),
(58, 2, 1, 'AC', 1, 1, 2, 1, 0, 1, 'Textil'),
(59, 2, 1, 'AC', 0, 0, 2, 1, 0, 1, 'Textil'),
(60, 3, 0, 'Bizonal', 0, 0, 2, 0, 0, 0, 'Alcantara'),
(61, 2, 0, 'Bizonal', 1, 1, 4, 0, 1, 1, 'Alcantara'),
(62, 3, 1, 'Bizonal', 1, 1, 3, 1, 1, 1, 'Alcantara'),
(63, 4, 1, 'Climatronic', 1, 1, 3, 0, 1, 0, 'Textil'),
(64, 2, 0, 'Climatronic', 1, 0, 5, 0, 0, 0, 'Alcantara'),
(65, 3, 0, 'AC', 0, 1, 4, 0, 0, 1, 'Alcantara'),
(66, 2, 0, 'Bizonal', 0, 0, 3, 1, 1, 1, 'Alcantara'),
(67, 4, 1, 'Bizonal', 1, 1, 4, 1, 1, 0, 'Alcantara'),
(68, 4, 0, 'Climatronic', 0, 1, 5, 1, 1, 0, 'Textil'),
(69, 4, 1, 'AC', 0, 0, 4, 0, 0, 0, 'Alcantara'),
(70, 2, 0, 'Climatronic', 0, 1, 4, 0, 1, 1, 'Textil'),
(71, 4, 1, 'Bizonal', 1, 0, 3, 0, 1, 0, 'Textil'),
(72, 2, 1, 'Bizonal', 1, 1, 3, 0, 0, 1, 'Piele'),
(73, 2, 0, 'Climatronic', 0, 0, 1, 1, 0, 0, 'Piele'),
(74, 3, 0, 'Climatronic', 0, 1, 3, 0, 1, 0, 'Textil'),
(75, 4, 1, 'Climatronic', 1, 0, 3, 1, 1, 1, 'Alcantara'),
(76, 4, 1, 'AC', 1, 1, 1, 1, 0, 1, 'Piele'),
(77, 2, 0, 'AC', 0, 1, 5, 1, 1, 0, 'Alcantara'),
(78, 4, 1, 'AC', 1, 0, 3, 1, 0, 1, 'Piele'),
(79, 4, 0, 'Bizonal', 1, 0, 5, 0, 0, 0, 'Piele'),
(80, 4, 1, 'Climatronic', 0, 1, 1, 1, 0, 1, 'Textil'),
(81, 4, 1, 'Bizonal', 0, 1, 3, 0, 1, 1, 'Piele'),
(82, 4, 1, 'AC', 0, 0, 3, 0, 0, 0, 'Alcantara'),
(83, 2, 0, 'AC', 0, 0, 4, 1, 0, 0, 'Piele'),
(84, 4, 1, 'AC', 1, 1, 2, 1, 1, 1, 'Alcantara'),
(85, 2, 1, 'AC', 1, 1, 2, 1, 1, 0, 'Alcantara'),
(86, 3, 1, 'AC', 0, 0, 3, 1, 0, 0, 'Piele'),
(87, 2, 1, 'AC', 1, 0, 1, 1, 1, 0, 'Alcantara'),
(88, 3, 0, 'Climatronic', 0, 0, 5, 0, 0, 1, 'Textil'),
(89, 4, 0, 'Bizonal', 0, 0, 5, 1, 0, 1, 'Alcantara'),
(90, 2, 1, 'Climatronic', 0, 0, 4, 1, 1, 0, 'Textil'),
(91, 3, 1, 'AC', 1, 1, 4, 0, 1, 1, 'Piele'),
(92, 3, 0, 'AC', 1, 1, 5, 1, 0, 1, 'Textil'),
(93, 2, 1, 'AC', 1, 1, 3, 0, 0, 1, 'Alcantara'),
(94, 4, 0, 'Bizonal', 0, 0, 1, 1, 1, 1, 'Alcantara'),
(95, 2, 0, 'Climatronic', 1, 0, 4, 0, 0, 1, 'Alcantara'),
(96, 4, 0, 'Climatronic', 0, 0, 1, 0, 0, 0, 'Textil'),
(97, 2, 0, 'Bizonal', 1, 0, 4, 1, 1, 0, 'Alcantara'),
(98, 3, 0, 'Climatronic', 1, 1, 2, 0, 1, 1, 'Piele'),
(99, 4, 1, 'Bizonal', 0, 1, 3, 1, 1, 0, 'Textil'),
(100, 4, 0, 'Bizonal', 0, 0, 4, 0, 0, 1, 'Textil'),
(101, 4, 0, 'AC', 0, 1, 4, 0, 1, 1, 'Piele'),
(102, 3, 1, 'Climatronic', 0, 0, 2, 0, 0, 1, 'Textil'),
(103, 3, 0, 'Climatronic', 1, 1, 2, 0, 0, 1, 'Piele'),
(104, 2, 1, 'AC', 1, 0, 4, 1, 0, 0, 'Textil'),
(105, 2, 0, 'AC', 0, 0, 4, 0, 1, 0, 'Alcantara'),
(106, 2, 0, 'Climatronic', 1, 1, 3, 1, 0, 1, 'Alcantara'),
(107, 3, 0, 'AC', 1, 1, 1, 1, 0, 0, 'Textil'),
(108, 2, 0, 'Climatronic', 1, 0, 1, 0, 0, 1, 'Piele'),
(109, 2, 0, 'AC', 1, 1, 3, 0, 0, 0, 'Textil'),
(110, 2, 0, 'Climatronic', 0, 0, 1, 1, 0, 1, 'Textil'),
(111, 4, 0, 'Bizonal', 0, 0, 5, 0, 1, 1, 'Alcantara'),
(112, 4, 0, 'Bizonal', 1, 0, 1, 0, 0, 1, 'Alcantara'),
(113, 3, 1, 'AC', 0, 1, 1, 0, 1, 1, 'Textil'),
(114, 2, 0, 'AC', 0, 1, 4, 1, 1, 0, 'Piele'),
(115, 2, 0, 'Bizonal', 0, 1, 4, 1, 1, 0, 'Piele'),
(116, 3, 0, 'Climatronic', 0, 0, 1, 1, 1, 0, 'Textil'),
(117, 3, 1, 'Climatronic', 0, 0, 4, 0, 0, 0, 'Alcantara'),
(118, 2, 0, 'Bizonal', 1, 1, 3, 0, 0, 1, 'Piele'),
(119, 2, 1, 'Bizonal', 0, 0, 3, 0, 0, 1, 'Textil'),
(120, 4, 0, 'Climatronic', 1, 1, 3, 1, 1, 0, 'Textil'),
(121, 3, 0, 'AC', 1, 1, 3, 1, 1, 1, 'Alcantara'),
(122, 3, 1, 'AC', 0, 1, 3, 1, 1, 1, 'Textil'),
(123, 3, 1, 'Bizonal', 0, 1, 4, 0, 1, 1, 'Piele'),
(124, 2, 0, 'Bizonal', 0, 0, 4, 1, 1, 0, 'Alcantara'),
(125, 3, 0, 'AC', 1, 1, 5, 0, 1, 0, 'Alcantara'),
(126, 3, 0, 'Climatronic', 0, 0, 1, 0, 1, 1, 'Piele'),
(127, 3, 0, 'AC', 0, 1, 5, 1, 0, 1, 'Textil'),
(128, 3, 0, 'AC', 0, 0, 3, 0, 0, 0, 'Alcantara'),
(129, 3, 0, 'AC', 1, 1, 2, 0, 0, 0, 'Textil'),
(130, 3, 0, 'AC', 1, 0, 3, 0, 1, 0, 'Alcantara'),
(131, 2, 0, 'Climatronic', 0, 1, 3, 1, 1, 0, 'Alcantara'),
(132, 2, 1, 'AC', 0, 0, 2, 0, 0, 0, 'Textil'),
(133, 4, 1, 'AC', 0, 0, 3, 0, 0, 1, 'Piele'),
(134, 3, 1, 'AC', 1, 0, 1, 0, 1, 0, 'Textil'),
(135, 3, 0, 'Climatronic', 1, 1, 5, 0, 1, 1, 'Textil'),
(136, 2, 1, 'AC', 0, 1, 4, 0, 0, 0, 'Piele'),
(137, 3, 1, 'AC', 1, 0, 5, 1, 1, 0, 'Textil'),
(138, 4, 0, 'Bizonal', 1, 0, 2, 1, 1, 1, 'Alcantara'),
(139, 4, 1, 'Bizonal', 0, 1, 1, 0, 1, 1, 'Textil'),
(140, 3, 0, 'Bizonal', 1, 0, 5, 1, 0, 0, 'Textil'),
(141, 2, 1, 'Climatronic', 0, 0, 2, 1, 0, 1, 'Piele'),
(142, 3, 0, 'Climatronic', 1, 0, 3, 0, 0, 1, 'Piele'),
(143, 4, 1, 'Bizonal', 1, 1, 3, 0, 0, 0, 'Piele'),
(144, 2, 0, 'Climatronic', 0, 1, 4, 1, 1, 1, 'Textil'),
(145, 3, 0, 'Climatronic', 0, 1, 1, 0, 0, 1, 'Textil'),
(146, 4, 0, 'Bizonal', 1, 0, 2, 0, 0, 1, 'Textil'),
(147, 4, 1, 'Climatronic', 1, 1, 3, 0, 1, 1, 'Piele'),
(148, 2, 0, 'AC', 0, 0, 4, 0, 1, 0, 'Piele'),
(149, 2, 0, 'Climatronic', 0, 1, 1, 0, 1, 1, 'Piele'),
(150, 2, 0, 'Bizonal', 0, 1, 1, 0, 0, 1, 'Textil'),
(151, 2, 0, 'AC', 0, 0, 1, 0, 1, 0, 'Textil'),
(152, 3, 1, 'Climatronic', 1, 1, 5, 0, 1, 0, 'Alcantara'),
(153, 4, 0, 'AC', 0, 0, 1, 0, 0, 0, 'Textil'),
(154, 3, 1, 'Bizonal', 0, 0, 4, 0, 0, 0, 'Alcantara'),
(155, 2, 1, 'AC', 1, 1, 4, 1, 1, 1, 'Textil'),
(156, 2, 1, 'AC', 0, 0, 1, 0, 1, 1, 'Alcantara'),
(157, 3, 1, 'Climatronic', 0, 1, 3, 0, 1, 1, 'Piele'),
(158, 2, 1, 'AC', 1, 0, 1, 0, 1, 1, 'Piele'),
(159, 3, 1, 'AC', 0, 0, 3, 0, 0, 0, 'Textil'),
(160, 4, 0, 'AC', 0, 1, 3, 0, 0, 1, 'Textil'),
(161, 4, 1, 'Bizonal', 1, 1, 4, 0, 0, 0, 'Alcantara'),
(162, 3, 0, 'AC', 1, 0, 3, 1, 0, 0, 'Piele'),
(163, 4, 1, 'AC', 0, 0, 2, 1, 1, 1, 'Textil'),
(164, 2, 0, 'Bizonal', 0, 0, 3, 0, 0, 0, 'Textil'),
(165, 3, 0, 'AC', 0, 1, 1, 0, 1, 1, 'Piele'),
(166, 2, 0, 'Bizonal', 1, 0, 4, 1, 1, 0, 'Alcantara'),
(167, 4, 1, 'Climatronic', 1, 0, 1, 0, 0, 1, 'Textil'),
(168, 4, 0, 'AC', 1, 0, 2, 1, 1, 1, 'Alcantara'),
(169, 4, 1, 'AC', 1, 0, 4, 0, 1, 1, 'Piele'),
(170, 4, 1, 'AC', 0, 1, 1, 1, 1, 0, 'Alcantara'),
(171, 4, 0, 'AC', 1, 0, 4, 1, 1, 0, 'Piele'),
(172, 3, 0, 'AC', 1, 1, 1, 0, 1, 0, 'Alcantara'),
(173, 3, 0, 'Climatronic', 0, 1, 5, 1, 1, 0, 'Textil'),
(174, 4, 1, 'Bizonal', 0, 0, 2, 0, 1, 0, 'Alcantara'),
(175, 2, 0, 'Bizonal', 0, 0, 4, 0, 1, 1, 'Alcantara'),
(176, 3, 1, 'Bizonal', 0, 0, 5, 0, 0, 1, 'Textil'),
(177, 2, 0, 'Climatronic', 0, 0, 5, 1, 0, 1, 'Alcantara'),
(178, 2, 0, 'Bizonal', 1, 0, 1, 0, 1, 0, 'Textil'),
(179, 4, 1, 'AC', 0, 1, 2, 0, 0, 1, 'Textil'),
(180, 3, 1, 'Bizonal', 1, 0, 5, 0, 0, 1, 'Alcantara'),
(181, 2, 1, 'AC', 0, 0, 5, 0, 0, 0, 'Alcantara'),
(182, 4, 1, 'Climatronic', 0, 1, 3, 0, 1, 1, 'Textil'),
(183, 2, 0, 'AC', 0, 0, 4, 1, 1, 1, 'Alcantara'),
(184, 4, 1, 'Bizonal', 0, 1, 2, 1, 1, 1, 'Textil'),
(185, 2, 0, 'Climatronic', 0, 0, 4, 0, 1, 0, 'Alcantara'),
(186, 4, 1, 'Bizonal', 0, 1, 3, 1, 0, 1, 'Textil'),
(187, 2, 1, 'Bizonal', 1, 1, 3, 0, 1, 1, 'Textil'),
(188, 4, 0, 'AC', 0, 0, 1, 0, 0, 0, 'Textil'),
(189, 3, 1, 'Climatronic', 0, 1, 2, 0, 0, 0, 'Piele'),
(190, 3, 0, 'Bizonal', 0, 1, 2, 0, 1, 0, 'Textil'),
(191, 2, 1, 'Climatronic', 0, 0, 5, 1, 1, 0, 'Piele'),
(192, 3, 0, 'AC', 0, 0, 3, 0, 1, 0, 'Textil'),
(193, 4, 1, 'Climatronic', 0, 0, 2, 1, 1, 0, 'Piele'),
(194, 3, 1, 'AC', 0, 1, 4, 1, 0, 1, 'Alcantara'),
(195, 4, 0, 'AC', 0, 0, 3, 0, 1, 0, 'Textil'),
(196, 2, 0, 'Climatronic', 1, 0, 1, 0, 1, 1, 'Alcantara'),
(197, 4, 0, 'Bizonal', 1, 1, 2, 0, 0, 1, 'Alcantara'),
(198, 3, 0, 'Bizonal', 1, 1, 4, 0, 0, 0, 'Piele'),
(199, 2, 1, 'Bizonal', 0, 1, 1, 0, 1, 0, 'Textil'),
(200, 4, 0, 'AC', 1, 1, 4, 0, 0, 0, 'Alcantara'),
(201, 2, 1, 'Climatronic', 1, 1, 4, 1, 0, 1, 'Piele'),
(202, 3, 0, 'Bizonal', 0, 0, 4, 0, 1, 0, 'Piele'),
(203, 2, 0, 'Bizonal', 1, 0, 2, 1, 0, 0, 'Alcantara'),
(204, 3, 1, 'Bizonal', 0, 0, 4, 0, 0, 0, 'Textil'),
(205, 4, 1, 'Bizonal', 1, 1, 4, 0, 1, 0, 'Alcantara'),
(206, 3, 1, 'Bizonal', 0, 1, 4, 1, 1, 1, 'Alcantara'),
(207, 3, 1, 'AC', 0, 0, 5, 1, 1, 1, 'Piele'),
(208, 2, 0, 'Bizonal', 0, 0, 3, 0, 1, 0, 'Alcantara'),
(209, 2, 1, 'Bizonal', 1, 1, 3, 1, 0, 0, 'Alcantara'),
(210, 4, 0, 'Bizonal', 1, 0, 4, 0, 0, 0, 'Alcantara'),
(211, 4, 1, 'Bizonal', 0, 0, 5, 1, 0, 1, 'Textil'),
(212, 2, 0, 'Climatronic', 0, 0, 2, 0, 0, 1, 'Alcantara'),
(213, 2, 1, 'AC', 1, 1, 2, 1, 0, 1, 'Alcantara'),
(214, 3, 0, 'Climatronic', 0, 1, 5, 0, 1, 1, 'Textil'),
(215, 2, 0, 'AC', 0, 1, 5, 0, 0, 1, 'Alcantara'),
(216, 3, 0, 'AC', 1, 0, 4, 0, 0, 1, 'Piele'),
(217, 2, 1, 'AC', 1, 1, 2, 0, 0, 1, 'Textil'),
(218, 2, 1, 'Bizonal', 0, 1, 3, 0, 1, 1, 'Alcantara'),
(219, 4, 0, 'Bizonal', 1, 0, 4, 0, 0, 1, 'Piele'),
(220, 2, 0, 'Climatronic', 1, 0, 5, 0, 1, 0, 'Alcantara'),
(221, 3, 1, 'Bizonal', 1, 1, 4, 0, 0, 1, 'Piele'),
(222, 3, 0, 'AC', 0, 1, 5, 0, 1, 1, 'Alcantara'),
(223, 3, 0, 'Bizonal', 1, 0, 4, 0, 0, 1, 'Alcantara'),
(224, 4, 0, 'Climatronic', 1, 0, 3, 1, 0, 0, 'Alcantara'),
(225, 4, 0, 'Bizonal', 1, 0, 2, 0, 1, 1, 'Piele'),
(226, 3, 0, 'Bizonal', 0, 1, 2, 0, 0, 1, 'Alcantara'),
(227, 4, 1, 'Climatronic', 1, 1, 3, 0, 0, 0, 'Textil'),
(228, 2, 0, 'Climatronic', 1, 1, 5, 1, 1, 1, 'Piele'),
(229, 2, 1, 'AC', 0, 0, 4, 1, 1, 1, 'Alcantara'),
(230, 3, 0, 'Bizonal', 1, 0, 3, 1, 1, 1, 'Textil'),
(231, 4, 0, 'Bizonal', 0, 0, 1, 0, 1, 0, 'Textil'),
(232, 2, 0, 'AC', 0, 0, 2, 0, 1, 1, 'Textil'),
(233, 2, 1, 'Climatronic', 0, 0, 4, 1, 1, 0, 'Alcantara'),
(234, 4, 0, 'AC', 1, 0, 2, 0, 0, 0, 'Alcantara'),
(235, 2, 0, 'Bizonal', 1, 1, 2, 0, 0, 0, 'Piele'),
(236, 2, 1, 'Climatronic', 0, 0, 2, 1, 1, 0, 'Alcantara'),
(237, 3, 1, 'Climatronic', 1, 0, 1, 0, 1, 1, 'Piele'),
(238, 2, 1, 'AC', 0, 0, 3, 0, 1, 0, 'Piele'),
(239, 3, 0, 'Climatronic', 0, 0, 4, 1, 1, 1, 'Alcantara'),
(240, 4, 1, 'AC', 1, 1, 5, 0, 0, 1, 'Textil'),
(241, 3, 0, 'Climatronic', 1, 0, 3, 0, 1, 0, 'Textil'),
(242, 2, 1, 'Climatronic', 0, 1, 3, 0, 1, 1, 'Textil'),
(243, 2, 1, 'Bizonal', 0, 0, 2, 0, 0, 0, 'Piele'),
(244, 2, 1, 'AC', 1, 1, 3, 1, 1, 1, 'Textil'),
(245, 2, 1, 'Climatronic', 1, 0, 2, 1, 0, 0, 'Textil'),
(246, 2, 0, 'Bizonal', 0, 0, 1, 0, 0, 1, 'Textil'),
(247, 2, 0, 'Bizonal', 1, 1, 1, 1, 0, 0, 'Alcantara'),
(248, 2, 0, 'AC', 0, 1, 4, 1, 1, 1, 'Alcantara'),
(249, 4, 0, 'Climatronic', 1, 0, 5, 0, 0, 0, 'Alcantara'),
(250, 3, 1, 'Bizonal', 1, 1, 5, 0, 0, 1, 'Textil'),
(251, 2, 0, 'Climatronic', 1, 0, 5, 0, 0, 0, 'Alcantara'),
(252, 3, 1, 'Climatronic', 0, 1, 2, 0, 1, 0, 'Piele'),
(253, 3, 0, 'Climatronic', 0, 0, 1, 0, 0, 1, 'Alcantara'),
(254, 4, 1, 'Bizonal', 0, 0, 1, 0, 0, 0, 'Textil'),
(255, 2, 1, 'Climatronic', 0, 1, 5, 0, 0, 1, 'Piele'),
(256, 4, 1, 'Climatronic', 1, 1, 1, 1, 0, 1, 'Alcantara'),
(257, 4, 1, 'AC', 0, 1, 5, 0, 0, 0, 'Piele'),
(258, 2, 1, 'Climatronic', 0, 0, 2, 1, 1, 0, 'Piele'),
(259, 2, 0, 'Climatronic', 0, 0, 4, 1, 1, 0, 'Piele'),
(260, 4, 0, 'Climatronic', 0, 0, 4, 1, 0, 1, 'Piele'),
(261, 4, 0, 'Bizonal', 1, 1, 3, 0, 0, 1, 'Alcantara'),
(262, 3, 1, 'AC', 1, 0, 5, 1, 1, 1, 'Textil'),
(263, 2, 0, 'AC', 1, 1, 4, 0, 0, 0, 'Alcantara'),
(264, 3, 1, 'Climatronic', 0, 1, 5, 0, 1, 1, 'Alcantara'),
(265, 2, 1, 'Bizonal', 0, 0, 2, 1, 0, 0, 'Textil'),
(266, 2, 0, 'Bizonal', 0, 0, 2, 1, 1, 0, 'Piele'),
(267, 4, 1, 'AC', 1, 1, 1, 1, 0, 1, 'Piele'),
(268, 3, 1, 'AC', 1, 0, 3, 0, 0, 1, 'Alcantara'),
(269, 4, 0, 'AC', 1, 0, 2, 0, 1, 0, 'Textil'),
(270, 2, 0, 'Bizonal', 1, 1, 1, 0, 1, 1, 'Alcantara'),
(271, 4, 1, 'AC', 1, 1, 1, 0, 1, 1, 'Textil'),
(272, 2, 1, 'Bizonal', 1, 0, 1, 1, 1, 1, 'Piele'),
(273, 3, 1, 'AC', 0, 1, 3, 0, 0, 0, 'Textil'),
(274, 3, 1, 'AC', 1, 1, 2, 1, 1, 1, 'Piele'),
(275, 4, 0, 'AC', 1, 1, 1, 1, 0, 1, 'Textil'),
(276, 4, 0, 'AC', 1, 1, 1, 1, 0, 0, 'Textil'),
(277, 2, 0, 'AC', 0, 1, 3, 1, 0, 0, 'Alcantara'),
(278, 4, 0, 'AC', 1, 1, 1, 0, 0, 0, 'Textil'),
(279, 4, 0, 'Bizonal', 0, 0, 5, 1, 0, 1, 'Alcantara'),
(280, 2, 0, 'Bizonal', 0, 0, 5, 1, 1, 1, 'Alcantara'),
(281, 3, 1, 'Bizonal', 1, 1, 3, 0, 1, 1, 'Alcantara');

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

--
-- Structură tabel pentru tabel `specificatii_dimensiuni`
--

DROP TABLE IF EXISTS `specificatii_dimensiuni`;
CREATE TABLE IF NOT EXISTS `specificatii_dimensiuni` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `lungime` int(5) NOT NULL,
  `latime` int(5) NOT NULL,
  `inaltime` int(3) NOT NULL,
  `portbagaj_lt` int(4) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `specificatii_dimensiuni`
--

INSERT INTO `specificatii_dimensiuni` (`id_model`, `lungime`, `latime`, `inaltime`, `portbagaj_lt`) VALUES
(1, 476, 291, 207, 376),
(2, 433, 340, 156, 363),
(3, 597, 319, 160, 231),
(4, 318, 357, 197, 238),
(5, 390, 286, 222, 270),
(6, 372, 359, 133, 197),
(7, 503, 366, 183, 327),
(8, 515, 256, 196, 279),
(9, 384, 291, 142, 167),
(10, 555, 223, 190, 121),
(11, 557, 224, 120, 294),
(12, 373, 270, 122, 129),
(13, 611, 242, 184, 105),
(14, 580, 234, 183, 339),
(15, 425, 361, 168, 260),
(16, 346, 224, 219, 170),
(17, 523, 230, 157, 371),
(18, 467, 331, 206, 276),
(19, 332, 365, 178, 336),
(20, 464, 341, 219, 216),
(21, 352, 323, 156, 242),
(22, 593, 222, 184, 298),
(23, 623, 306, 224, 193),
(24, 576, 245, 230, 108),
(25, 581, 217, 225, 272),
(26, 485, 367, 224, 240),
(27, 565, 213, 229, 311),
(28, 558, 309, 150, 330),
(29, 517, 361, 128, 325),
(30, 615, 323, 129, 334),
(31, 438, 351, 129, 110),
(32, 479, 331, 222, 229),
(33, 546, 230, 228, 147),
(34, 417, 250, 184, 155),
(35, 321, 344, 162, 293),
(36, 609, 344, 205, 155),
(37, 372, 326, 229, 255),
(38, 413, 260, 205, 273),
(39, 394, 241, 206, 161),
(40, 370, 310, 184, 220),
(41, 317, 286, 155, 294),
(42, 477, 232, 193, 337),
(43, 495, 354, 229, 218),
(44, 570, 317, 190, 191),
(45, 316, 238, 173, 302),
(46, 484, 364, 176, 370),
(47, 372, 292, 146, 189),
(48, 575, 285, 164, 142),
(49, 544, 368, 171, 269),
(50, 337, 286, 191, 330),
(51, 348, 345, 136, 136),
(52, 584, 270, 147, 342),
(53, 493, 312, 216, 156),
(54, 339, 280, 164, 170),
(55, 376, 287, 164, 219),
(56, 506, 339, 138, 236),
(57, 487, 299, 207, 308),
(58, 412, 283, 171, 111),
(59, 556, 217, 171, 263),
(60, 378, 212, 155, 229),
(61, 454, 224, 196, 131),
(62, 508, 269, 172, 276),
(63, 597, 239, 186, 101),
(64, 400, 293, 177, 156),
(65, 354, 339, 204, 373),
(66, 370, 323, 180, 359),
(67, 368, 313, 120, 212),
(68, 474, 367, 169, 272),
(69, 482, 340, 171, 324),
(70, 449, 327, 196, 193),
(71, 546, 332, 181, 348),
(72, 599, 333, 222, 220),
(73, 362, 330, 229, 223),
(74, 353, 276, 179, 218),
(75, 372, 240, 155, 216),
(76, 555, 218, 146, 221),
(77, 369, 324, 214, 120),
(78, 444, 303, 230, 136),
(79, 609, 242, 175, 272),
(80, 377, 332, 189, 288),
(81, 472, 216, 158, 271),
(82, 504, 323, 143, 177),
(83, 350, 213, 161, 198),
(84, 561, 304, 168, 118),
(85, 404, 347, 131, 130),
(86, 503, 256, 222, 376),
(87, 370, 218, 166, 197),
(88, 402, 220, 138, 194),
(89, 360, 277, 193, 234),
(90, 480, 284, 177, 197),
(91, 346, 313, 144, 202),
(92, 624, 343, 220, 164),
(93, 495, 296, 153, 258),
(94, 525, 269, 125, 230),
(95, 496, 244, 200, 355),
(96, 502, 225, 160, 210),
(97, 352, 304, 230, 227),
(98, 485, 286, 199, 336),
(99, 405, 337, 167, 260),
(100, 379, 276, 184, 317),
(101, 483, 266, 204, 231),
(102, 594, 341, 136, 251),
(103, 308, 228, 163, 297),
(104, 545, 259, 214, 116),
(105, 309, 289, 139, 107),
(106, 562, 227, 221, 306),
(107, 377, 221, 210, 112),
(108, 587, 254, 185, 185),
(109, 473, 297, 179, 367),
(110, 569, 338, 156, 203),
(111, 577, 334, 139, 101),
(112, 369, 239, 177, 201),
(113, 614, 231, 137, 135),
(114, 369, 330, 201, 180),
(115, 323, 281, 202, 230),
(116, 478, 220, 184, 128),
(117, 310, 317, 188, 370),
(118, 596, 351, 213, 241),
(119, 615, 267, 209, 245),
(120, 549, 213, 169, 187),
(121, 454, 361, 212, 252),
(122, 588, 277, 192, 162),
(123, 346, 299, 222, 206),
(124, 456, 224, 123, 319),
(125, 439, 241, 151, 113),
(126, 417, 267, 128, 233),
(127, 536, 299, 188, 195),
(128, 513, 274, 166, 246),
(129, 378, 323, 223, 262),
(130, 454, 284, 153, 330),
(131, 417, 310, 121, 191),
(132, 375, 354, 183, 311),
(133, 416, 217, 230, 260),
(134, 440, 369, 209, 256),
(135, 356, 328, 216, 178),
(136, 430, 326, 131, 184),
(137, 538, 321, 222, 118),
(138, 352, 311, 209, 249),
(139, 570, 275, 213, 106),
(140, 349, 350, 227, 153),
(141, 483, 350, 130, 195),
(142, 582, 294, 167, 257),
(143, 596, 363, 191, 323),
(144, 540, 271, 145, 159),
(145, 445, 320, 139, 295),
(146, 445, 225, 216, 247),
(147, 569, 305, 171, 292),
(148, 470, 351, 213, 132),
(149, 557, 231, 212, 308),
(150, 613, 286, 199, 332),
(151, 501, 307, 180, 369),
(152, 454, 339, 224, 358),
(153, 471, 305, 178, 182),
(154, 421, 336, 146, 345),
(155, 469, 273, 183, 147),
(156, 602, 297, 176, 134),
(157, 609, 361, 171, 116),
(158, 346, 218, 140, 208),
(159, 315, 272, 215, 102),
(160, 483, 216, 151, 228),
(161, 561, 241, 177, 360),
(162, 311, 303, 151, 255),
(163, 580, 348, 202, 299),
(164, 596, 243, 125, 338),
(165, 515, 349, 198, 329),
(166, 555, 224, 183, 351),
(167, 499, 355, 158, 212),
(168, 482, 216, 199, 336),
(169, 454, 326, 120, 269),
(170, 564, 332, 211, 217),
(171, 553, 328, 206, 146),
(172, 402, 219, 123, 339),
(173, 550, 260, 172, 320),
(174, 562, 296, 171, 226),
(175, 488, 365, 150, 284),
(176, 327, 308, 151, 329),
(177, 585, 277, 206, 272),
(178, 464, 221, 202, 245),
(179, 598, 355, 151, 265),
(180, 474, 350, 220, 174),
(181, 506, 229, 184, 371),
(182, 340, 308, 142, 206),
(183, 483, 244, 132, 228),
(184, 439, 348, 230, 148),
(185, 540, 330, 161, 310),
(186, 545, 244, 159, 172),
(187, 603, 252, 220, 136),
(188, 405, 332, 172, 179),
(189, 453, 233, 210, 260),
(190, 391, 342, 187, 270),
(191, 378, 294, 200, 376),
(192, 451, 267, 188, 223),
(193, 576, 356, 151, 152),
(194, 366, 335, 185, 101),
(195, 391, 316, 199, 375),
(196, 480, 215, 228, 325),
(197, 618, 353, 130, 221),
(198, 395, 219, 217, 299),
(199, 333, 252, 209, 357),
(200, 501, 219, 189, 363),
(201, 315, 297, 154, 130),
(202, 398, 341, 199, 115),
(203, 621, 217, 221, 236),
(204, 310, 289, 229, 371),
(205, 476, 345, 225, 357),
(206, 379, 358, 196, 247),
(207, 327, 354, 202, 293),
(208, 554, 292, 202, 225),
(209, 320, 368, 193, 313),
(210, 447, 363, 145, 372),
(211, 536, 356, 127, 132),
(212, 319, 351, 124, 340),
(213, 321, 281, 167, 181),
(214, 326, 317, 120, 342),
(215, 520, 337, 193, 290),
(216, 590, 230, 174, 359),
(217, 468, 337, 156, 347),
(218, 470, 213, 178, 133),
(219, 367, 224, 212, 349),
(220, 530, 370, 182, 189),
(221, 402, 231, 176, 203),
(222, 593, 234, 202, 142),
(223, 485, 357, 142, 250),
(224, 586, 354, 182, 274),
(225, 575, 247, 125, 225),
(226, 509, 310, 176, 260),
(227, 520, 248, 190, 143),
(228, 403, 320, 193, 140),
(229, 429, 325, 144, 201),
(230, 478, 290, 194, 203),
(231, 339, 282, 229, 269),
(232, 419, 301, 201, 240),
(233, 571, 354, 209, 181),
(234, 615, 233, 204, 340),
(235, 590, 307, 215, 313),
(236, 343, 217, 165, 331),
(237, 602, 219, 171, 282),
(238, 620, 313, 180, 121),
(239, 541, 318, 194, 184),
(240, 450, 308, 126, 316),
(241, 367, 264, 156, 331),
(242, 603, 355, 230, 220),
(243, 345, 240, 215, 331),
(244, 468, 333, 155, 193),
(245, 338, 292, 160, 362),
(246, 323, 301, 180, 251),
(247, 350, 327, 196, 187),
(248, 483, 344, 210, 278),
(249, 479, 248, 222, 168),
(250, 565, 368, 225, 208),
(251, 450, 355, 157, 167),
(252, 480, 355, 218, 248),
(253, 556, 281, 158, 206),
(254, 462, 306, 168, 173),
(255, 394, 224, 206, 110),
(256, 491, 289, 173, 113),
(257, 349, 218, 224, 308),
(258, 496, 304, 191, 110),
(259, 619, 344, 204, 347),
(260, 607, 285, 218, 242),
(261, 398, 315, 214, 103),
(262, 585, 342, 200, 192),
(263, 346, 318, 172, 117),
(264, 357, 260, 150, 315),
(265, 589, 340, 127, 178),
(266, 412, 349, 160, 367),
(267, 611, 327, 153, 351),
(268, 452, 365, 206, 214),
(269, 404, 302, 142, 106),
(270, 434, 306, 152, 147),
(271, 333, 269, 187, 295),
(272, 386, 338, 163, 302),
(273, 375, 243, 135, 307),
(274, 392, 271, 208, 128),
(275, 450, 277, 223, 311),
(276, 546, 335, 143, 235),
(277, 465, 217, 178, 181),
(278, 377, 226, 145, 179),
(279, 619, 347, 189, 314),
(280, 616, 258, 194, 282),
(281, 590, 282, 134, 172);

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

--
-- Structură tabel pentru tabel `specificatii_siguranta`
--

DROP TABLE IF EXISTS `specificatii_siguranta`;
CREATE TABLE IF NOT EXISTS `specificatii_siguranta` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `ESP` tinyint(1) NOT NULL,
  `ABS` tinyint(1) NOT NULL,
  `Lane_Assist` tinyint(1) NOT NULL,
  `Brake_Assist` tinyint(1) NOT NULL,
  `Asistenta_urcare_coborare` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `specificatii_siguranta`
--

INSERT INTO `specificatii_siguranta` (`id_model`, `ESP`, `ABS`, `Lane_Assist`, `Brake_Assist`, `Asistenta_urcare_coborare`) VALUES
(1, 0, 1, 0, 1, 0),
(2, 0, 1, 0, 1, 0),
(3, 0, 0, 0, 0, 1),
(4, 0, 1, 0, 0, 0),
(5, 0, 0, 0, 1, 1),
(6, 1, 1, 0, 1, 1),
(7, 0, 0, 1, 0, 1),
(8, 1, 0, 0, 1, 0),
(9, 0, 0, 0, 1, 1),
(10, 0, 1, 1, 1, 1),
(11, 0, 0, 0, 0, 1),
(12, 0, 0, 1, 1, 1),
(13, 0, 1, 1, 1, 1),
(14, 0, 1, 0, 1, 1),
(15, 0, 1, 0, 1, 0),
(16, 0, 0, 1, 1, 0),
(17, 0, 0, 1, 1, 1),
(18, 0, 1, 1, 1, 1),
(19, 0, 0, 1, 1, 1),
(20, 0, 1, 0, 0, 0),
(21, 0, 0, 1, 1, 1),
(22, 1, 0, 1, 0, 1),
(23, 1, 1, 0, 1, 1),
(24, 0, 0, 0, 0, 0),
(25, 0, 1, 0, 1, 1),
(26, 0, 0, 0, 1, 1),
(27, 0, 0, 1, 0, 0),
(28, 0, 0, 1, 1, 1),
(29, 1, 1, 0, 1, 1),
(30, 0, 1, 0, 1, 0),
(31, 1, 0, 1, 1, 0),
(32, 0, 1, 0, 0, 0),
(33, 0, 1, 0, 1, 0),
(34, 0, 0, 1, 0, 0),
(35, 0, 1, 1, 0, 1),
(36, 0, 1, 1, 1, 1),
(37, 1, 1, 0, 1, 0),
(38, 1, 0, 1, 0, 0),
(39, 1, 1, 1, 0, 1),
(40, 0, 1, 1, 1, 1),
(41, 0, 0, 0, 0, 1),
(42, 0, 1, 1, 1, 0),
(43, 1, 1, 0, 0, 0),
(44, 1, 0, 1, 1, 1),
(45, 0, 0, 1, 0, 0),
(46, 0, 1, 0, 0, 1),
(47, 1, 0, 1, 1, 1),
(48, 1, 0, 0, 1, 1),
(49, 1, 1, 1, 1, 0),
(50, 0, 1, 0, 1, 1),
(51, 0, 1, 1, 0, 0),
(52, 1, 1, 0, 0, 1),
(53, 0, 1, 1, 1, 0),
(54, 0, 0, 1, 1, 0),
(55, 0, 0, 1, 0, 0),
(56, 0, 0, 0, 0, 1),
(57, 1, 1, 1, 1, 0),
(58, 1, 0, 1, 1, 1),
(59, 0, 1, 1, 1, 0),
(60, 0, 0, 1, 0, 1),
(61, 1, 1, 0, 1, 1),
(62, 1, 0, 0, 1, 0),
(63, 1, 1, 0, 0, 1),
(64, 0, 1, 1, 1, 0),
(65, 0, 0, 1, 0, 1),
(66, 1, 0, 1, 1, 0),
(67, 1, 1, 1, 1, 0),
(68, 1, 1, 0, 1, 1),
(69, 1, 0, 0, 0, 0),
(70, 1, 0, 0, 0, 0),
(71, 1, 0, 1, 0, 0),
(72, 1, 0, 0, 1, 0),
(73, 1, 1, 1, 1, 1),
(74, 0, 1, 1, 0, 1),
(75, 1, 1, 1, 1, 0),
(76, 1, 1, 1, 1, 0),
(77, 1, 1, 0, 0, 1),
(78, 1, 0, 0, 1, 1),
(79, 1, 0, 1, 0, 1),
(80, 0, 0, 0, 1, 1),
(81, 0, 1, 0, 0, 1),
(82, 0, 1, 1, 1, 1),
(83, 0, 1, 0, 1, 1),
(84, 1, 0, 0, 1, 0),
(85, 1, 0, 0, 1, 0),
(86, 1, 0, 1, 0, 0),
(87, 1, 1, 0, 1, 0),
(88, 1, 1, 0, 0, 1),
(89, 0, 0, 0, 0, 0),
(90, 0, 0, 1, 0, 0),
(91, 1, 1, 0, 1, 0),
(92, 1, 1, 1, 0, 1),
(93, 1, 0, 0, 0, 1),
(94, 0, 1, 0, 1, 0),
(95, 0, 0, 0, 0, 0),
(96, 0, 0, 1, 0, 1),
(97, 1, 1, 0, 0, 1),
(98, 1, 0, 1, 0, 1),
(99, 0, 1, 0, 1, 0),
(100, 0, 0, 0, 1, 0),
(101, 1, 0, 1, 1, 1),
(102, 0, 1, 0, 0, 1),
(103, 0, 1, 1, 1, 0),
(104, 0, 1, 1, 1, 1),
(105, 1, 1, 1, 1, 1),
(106, 0, 0, 1, 0, 1),
(107, 1, 1, 0, 1, 1),
(108, 1, 1, 0, 1, 0),
(109, 1, 1, 1, 1, 1),
(110, 0, 0, 0, 0, 1),
(111, 1, 0, 0, 0, 0),
(112, 1, 0, 1, 1, 0),
(113, 0, 1, 1, 1, 0),
(114, 1, 1, 1, 1, 0),
(115, 1, 0, 1, 1, 1),
(116, 0, 1, 0, 1, 1),
(117, 1, 1, 0, 0, 0),
(118, 1, 1, 1, 1, 1),
(119, 1, 0, 1, 1, 0),
(120, 0, 1, 1, 0, 1),
(121, 0, 0, 1, 0, 1),
(122, 1, 0, 1, 0, 0),
(123, 1, 0, 1, 1, 1),
(124, 0, 0, 1, 0, 0),
(125, 1, 1, 0, 1, 1),
(126, 1, 0, 0, 0, 0),
(127, 0, 1, 0, 0, 0),
(128, 1, 1, 1, 1, 0),
(129, 1, 1, 1, 0, 1),
(130, 1, 0, 0, 0, 0),
(131, 0, 0, 1, 0, 1),
(132, 0, 1, 0, 0, 1),
(133, 1, 0, 0, 1, 0),
(134, 1, 0, 1, 0, 0),
(135, 0, 0, 0, 1, 0),
(136, 0, 0, 0, 0, 1),
(137, 1, 0, 0, 0, 0),
(138, 0, 1, 0, 0, 1),
(139, 1, 0, 0, 1, 0),
(140, 0, 0, 1, 0, 1),
(141, 0, 1, 0, 0, 1),
(142, 1, 1, 1, 0, 1),
(143, 1, 0, 1, 0, 0),
(144, 1, 1, 0, 1, 0),
(145, 1, 0, 1, 0, 0),
(146, 1, 0, 0, 0, 0),
(147, 1, 0, 1, 1, 1),
(148, 0, 0, 1, 0, 0),
(149, 0, 0, 1, 1, 1),
(150, 0, 0, 1, 0, 0),
(151, 0, 1, 1, 1, 0),
(152, 0, 1, 1, 0, 1),
(153, 0, 0, 0, 1, 0),
(154, 0, 0, 0, 0, 1),
(155, 0, 1, 1, 1, 1),
(156, 1, 0, 0, 1, 1),
(157, 0, 0, 1, 0, 1),
(158, 1, 1, 0, 1, 0),
(159, 0, 1, 0, 0, 1),
(160, 1, 1, 0, 0, 1),
(161, 0, 0, 0, 0, 1),
(162, 0, 1, 0, 0, 0),
(163, 0, 1, 0, 0, 1),
(164, 0, 1, 1, 1, 1),
(165, 1, 1, 1, 0, 0),
(166, 0, 1, 1, 0, 1),
(167, 1, 1, 1, 0, 0),
(168, 0, 0, 1, 1, 0),
(169, 0, 1, 0, 1, 0),
(170, 0, 0, 1, 1, 0),
(171, 0, 0, 1, 0, 1),
(172, 1, 0, 0, 0, 0),
(173, 1, 1, 0, 1, 0),
(174, 1, 0, 1, 1, 1),
(175, 0, 0, 0, 0, 1),
(176, 1, 0, 0, 0, 1),
(177, 1, 1, 0, 0, 1),
(178, 0, 1, 0, 1, 0),
(179, 0, 1, 0, 0, 1),
(180, 0, 1, 1, 1, 0),
(181, 1, 0, 1, 1, 0),
(182, 0, 0, 1, 0, 1),
(183, 0, 1, 0, 0, 1),
(184, 1, 0, 0, 0, 0),
(185, 0, 0, 1, 0, 1),
(186, 0, 1, 1, 1, 1),
(187, 0, 1, 1, 1, 0),
(188, 0, 1, 0, 0, 1),
(189, 1, 1, 1, 0, 0),
(190, 1, 1, 0, 0, 0),
(191, 1, 0, 0, 1, 1),
(192, 0, 1, 0, 0, 0),
(193, 0, 1, 0, 1, 1),
(194, 1, 0, 1, 0, 0),
(195, 0, 0, 1, 0, 1),
(196, 0, 1, 1, 0, 0),
(197, 1, 1, 1, 0, 1),
(198, 0, 0, 1, 1, 0),
(199, 1, 0, 1, 1, 1),
(200, 0, 0, 0, 0, 0),
(201, 1, 1, 0, 1, 0),
(202, 1, 1, 0, 0, 1),
(203, 1, 0, 0, 0, 1),
(204, 1, 1, 0, 0, 1),
(205, 0, 1, 0, 0, 0),
(206, 1, 1, 1, 0, 1),
(207, 1, 0, 1, 1, 1),
(208, 1, 1, 0, 0, 1),
(209, 0, 0, 1, 0, 0),
(210, 0, 1, 1, 1, 0),
(211, 1, 0, 1, 0, 1),
(212, 1, 1, 1, 0, 0),
(213, 1, 0, 1, 1, 0),
(214, 1, 1, 0, 0, 0),
(215, 0, 1, 0, 0, 1),
(216, 1, 1, 0, 1, 0),
(217, 0, 1, 1, 0, 1),
(218, 1, 0, 0, 1, 1),
(219, 0, 1, 0, 1, 0),
(220, 0, 1, 0, 0, 1),
(221, 1, 0, 1, 0, 0),
(222, 0, 0, 1, 1, 1),
(223, 0, 1, 0, 1, 0),
(224, 1, 1, 0, 1, 0),
(225, 1, 0, 1, 1, 0),
(226, 1, 0, 0, 1, 0),
(227, 0, 1, 1, 1, 0),
(228, 1, 0, 0, 0, 1),
(229, 0, 0, 0, 0, 0),
(230, 0, 1, 1, 0, 0),
(231, 1, 0, 0, 1, 1),
(232, 1, 1, 0, 1, 1),
(233, 1, 0, 1, 0, 1),
(234, 0, 1, 0, 1, 1),
(235, 1, 1, 0, 1, 0),
(236, 0, 1, 0, 0, 1),
(237, 1, 1, 0, 0, 0),
(238, 1, 0, 0, 0, 1),
(239, 1, 0, 1, 0, 0),
(240, 1, 0, 0, 0, 0),
(241, 0, 0, 1, 1, 1),
(242, 1, 0, 0, 0, 1),
(243, 1, 1, 0, 0, 1),
(244, 1, 1, 1, 0, 1),
(245, 1, 1, 1, 0, 1),
(246, 1, 0, 0, 1, 0),
(247, 0, 1, 1, 0, 0),
(248, 1, 0, 0, 0, 0),
(249, 1, 1, 0, 1, 1),
(250, 0, 1, 0, 0, 1),
(251, 0, 1, 1, 0, 0),
(252, 0, 1, 0, 0, 1),
(253, 1, 1, 0, 1, 0),
(254, 0, 1, 1, 0, 1),
(255, 1, 0, 0, 1, 1),
(256, 1, 1, 1, 1, 0),
(257, 0, 0, 0, 0, 1),
(258, 0, 0, 1, 0, 1),
(259, 1, 1, 0, 0, 0),
(260, 0, 1, 1, 1, 0),
(261, 0, 1, 1, 1, 0),
(262, 0, 0, 1, 1, 1),
(263, 0, 1, 1, 1, 1),
(264, 1, 1, 0, 0, 0),
(265, 1, 0, 1, 1, 1),
(266, 0, 0, 0, 0, 1),
(267, 0, 0, 0, 0, 0),
(268, 1, 1, 1, 0, 1),
(269, 1, 0, 0, 1, 0),
(270, 0, 1, 1, 1, 0),
(271, 0, 0, 1, 1, 0),
(272, 0, 0, 0, 1, 0),
(273, 1, 0, 1, 1, 1),
(274, 1, 0, 0, 0, 1),
(275, 1, 0, 0, 1, 1),
(276, 1, 0, 0, 1, 0),
(277, 0, 1, 1, 1, 0),
(278, 1, 1, 0, 1, 1),
(279, 0, 0, 1, 1, 0),
(280, 1, 1, 1, 1, 1),
(281, 1, 1, 1, 1, 1);

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

--
-- Structură tabel pentru tabel `specificatii_tehnice`
--

DROP TABLE IF EXISTS `specificatii_tehnice`;
CREATE TABLE IF NOT EXISTS `specificatii_tehnice` (
  `id_model` int(3) NOT NULL AUTO_INCREMENT,
  `dimensiune_motor` int(4) NOT NULL,
  `tip_motor` varchar(50) NOT NULL,
  `Consum` int(2) NOT NULL,
  `carburant` varchar(50) NOT NULL,
  `tip_cutie` varchar(30) NOT NULL,
  `trepte_cutie` int(2) NOT NULL,
  `cai_putere` int(3) NOT NULL,
  `cuplu` int(3) NOT NULL,
  `Suspensie` varchar(100) NOT NULL,
  `Turbina` varchar(100) NOT NULL,
  `Faruri` varchar(100) NOT NULL,
  `Senzori` varchar(100) NOT NULL,
  `greutate` int(4) NOT NULL,
  PRIMARY KEY (`id_model`)
) ENGINE=MyISAM AUTO_INCREMENT=282 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `specificatii_tehnice`
--

INSERT INTO `specificatii_tehnice` (`id_model`, `dimensiune_motor`, `tip_motor`, `Consum`, `carburant`, `tip_cutie`, `trepte_cutie`, `cai_putere`, `cuplu`, `Suspensie`, `Turbina`, `Faruri`, `Senzori`, `greutate`) VALUES
(1, 3525, 'Euro 4', 11, 'M', 'automata', 6, 474, 318, 'arcuri reglabile', 'none', 'led', 'fara', 1899),
(2, 5543, 'Euro 5', 3, 'H', 'manuala', 6, 70, 640, ' perne aer', 'mono', 'xenon', 'parcare', 4392),
(3, 2844, 'Euro 4', 9, 'B', 'automata', 5, 169, 535, ' perne aer', 'mono', 'led', 'full', 2254),
(4, 1418, 'Euro 4', 20, 'B', 'manuala', 7, 101, 595, 'arcuri', 'none', 'halogen', 'full', 4423),
(5, 1270, 'Euro 5', 24, 'E', 'manuala', 7, 326, 220, 'arcuri reglabile', 'none', 'led', 'fara', 1256),
(6, 1369, 'Euro 4', 19, 'M', 'manuala', 9, 429, 410, ' perne aer', 'multiple', 'xenon', 'fara', 2454),
(7, 3285, 'Euro 6', 29, 'B', 'manuala', 6, 451, 208, 'arcuri reglabile', 'multiple', 'led', 'parcare', 860),
(8, 3329, 'Euro 6', 25, 'E', 'dual automata', 6, 119, 647, 'arcuri reglabile', 'mono', 'led', 'full', 3310),
(9, 5880, 'Euro 5', 27, 'B', 'dual automata', 4, 438, 604, 'arcuri reglabile', 'multiple', 'halogen', 'full', 2190),
(10, 2593, 'Euro 4', 25, 'E', 'dual automata', 8, 82, 660, ' perne aer', 'multiple', 'xenon', 'full', 1789),
(11, 3203, 'Euro 5', 26, 'B', 'manuala', 9, 460, 410, ' perne aer', 'multiple', 'led', 'parcare', 1520),
(12, 4855, 'Euro 4', 22, 'M', 'automata', 9, 329, 316, 'arcuri reglabile', 'mono', 'led', 'fara', 2047),
(13, 2074, 'Euro 4', 6, 'B', 'dual automata', 6, 468, 466, 'arcuri reglabile', 'mono', 'led', 'full', 1327),
(14, 4646, 'Euro 6', 8, 'M', 'automata', 5, 225, 648, ' perne aer', 'multiple', 'halogen', 'full', 1593),
(15, 1168, 'Euro 5', 11, 'H', 'dual automata', 6, 61, 303, 'arcuri', 'multiple', 'led', 'fara', 2993),
(16, 1718, 'Euro 4', 16, 'H', 'dual automata', 8, 277, 151, 'arcuri reglabile', 'none', 'halogen', 'parcare', 3070),
(17, 5762, 'Euro 6', 24, 'E', 'dual automata', 6, 327, 153, 'arcuri', 'none', 'led', 'fara', 1989),
(18, 1105, 'Euro 5', 8, 'B', 'automata', 4, 556, 412, 'arcuri', 'mono', 'xenon', 'parcare', 3760),
(19, 3043, 'Euro 6', 24, 'B', 'automata', 7, 507, 479, 'arcuri', 'multiple', 'led', 'parcare', 1093),
(20, 2421, 'Euro 4', 12, 'B', 'manuala', 8, 483, 641, 'arcuri reglabile', 'multiple', 'led', 'parcare', 3672),
(21, 4405, 'Euro 5', 16, 'H', 'manuala', 5, 498, 672, 'arcuri reglabile', 'multiple', 'led', 'parcare', 1265),
(22, 1148, 'Euro 5', 23, 'B', 'dual automata', 7, 81, 595, 'arcuri reglabile', 'mono', 'halogen', 'parcare', 4296),
(23, 2757, 'Euro 4', 20, 'B', 'manuala', 7, 539, 399, ' perne aer', 'multiple', 'led', 'full', 4225),
(24, 3794, 'Euro 4', 25, 'B', 'dual automata', 8, 70, 438, 'arcuri reglabile', 'mono', 'led', 'fara', 3258),
(25, 3929, 'Euro 5', 16, 'H', 'automata', 4, 450, 454, 'arcuri reglabile', 'multiple', 'halogen', 'parcare', 3565),
(26, 5511, 'Euro 6', 15, 'M', 'dual automata', 5, 82, 277, 'arcuri', 'multiple', 'led', 'parcare', 1576),
(27, 1384, 'Euro 4', 23, 'B', 'automata', 8, 350, 609, 'arcuri', 'mono', 'led', 'full', 3346),
(28, 3037, 'Euro 6', 17, 'M', 'automata', 9, 395, 321, 'arcuri reglabile', 'mono', 'led', 'parcare', 1832),
(29, 4361, 'Euro 4', 13, 'B', 'manuala', 9, 118, 437, ' perne aer', 'mono', 'xenon', 'fara', 4192),
(30, 4782, 'Euro 5', 28, 'B', 'automata', 6, 505, 194, 'arcuri', 'none', 'xenon', 'full', 2821),
(31, 5907, 'Euro 6', 19, 'H', 'manuala', 8, 466, 375, ' perne aer', 'none', 'halogen', 'parcare', 3322),
(32, 1817, 'Euro 5', 21, 'M', 'manuala', 8, 368, 693, 'arcuri reglabile', 'multiple', 'xenon', 'parcare', 2999),
(33, 3990, 'Euro 5', 13, 'M', 'dual automata', 9, 252, 545, 'arcuri', 'none', 'led', 'full', 3255),
(34, 4461, 'Euro 5', 13, 'H', 'manuala', 7, 141, 585, ' perne aer', 'mono', 'led', 'full', 2306),
(35, 5646, 'Euro 6', 20, 'H', 'automata', 4, 133, 408, 'arcuri', 'mono', 'halogen', 'fara', 3272),
(36, 6038, 'Euro 5', 22, 'E', 'automata', 9, 365, 302, 'arcuri', 'none', 'xenon', 'fara', 3431),
(37, 5573, 'Euro 6', 4, 'B', 'dual automata', 7, 623, 219, ' perne aer', 'mono', 'xenon', 'parcare', 1117),
(38, 3576, 'Euro 4', 22, 'H', 'automata', 6, 263, 270, 'arcuri reglabile', 'multiple', 'xenon', 'parcare', 2370),
(39, 3591, 'Euro 6', 16, 'B', 'dual automata', 9, 423, 457, ' perne aer', 'multiple', 'led', 'fara', 2399),
(40, 2503, 'Euro 5', 30, 'E', 'dual automata', 4, 282, 427, 'arcuri', 'mono', 'led', 'full', 3890),
(41, 3254, 'Euro 6', 22, 'B', 'automata', 6, 474, 568, ' perne aer', 'none', 'halogen', 'parcare', 3281),
(42, 3147, 'Euro 6', 19, 'E', 'manuala', 7, 217, 156, 'arcuri', 'none', 'xenon', 'fara', 4155),
(43, 3122, 'Euro 5', 17, 'B', 'manuala', 5, 546, 698, 'arcuri reglabile', 'multiple', 'xenon', 'full', 1407),
(44, 5763, 'Euro 4', 4, 'B', 'automata', 9, 169, 646, 'arcuri', 'mono', 'xenon', 'parcare', 4281),
(45, 3536, 'Euro 4', 16, 'M', 'automata', 6, 249, 191, 'arcuri', 'multiple', 'led', 'fara', 4426),
(46, 3232, 'Euro 6', 18, 'M', 'dual automata', 4, 95, 448, 'arcuri reglabile', 'mono', 'led', 'fara', 1039),
(47, 2781, 'Euro 5', 27, 'M', 'dual automata', 9, 150, 700, ' perne aer', 'multiple', 'xenon', 'parcare', 1877),
(48, 1897, 'Euro 5', 30, 'E', 'dual automata', 9, 414, 404, 'arcuri reglabile', 'multiple', 'halogen', 'full', 1021),
(49, 2173, 'Euro 5', 10, 'B', 'automata', 8, 640, 332, 'arcuri', 'mono', 'xenon', 'full', 1377),
(50, 3716, 'Euro 4', 17, 'B', 'manuala', 6, 332, 409, 'arcuri reglabile', 'multiple', 'halogen', 'parcare', 1859),
(51, 4095, 'Euro 6', 30, 'M', 'dual automata', 4, 187, 467, 'arcuri reglabile', 'mono', 'led', 'full', 3388),
(52, 5402, 'Euro 6', 24, 'M', 'automata', 8, 97, 241, ' perne aer', 'multiple', 'xenon', 'full', 3285),
(53, 4236, 'Euro 6', 4, 'M', 'automata', 5, 543, 217, 'arcuri', 'multiple', 'halogen', 'full', 2648),
(54, 5119, 'Euro 6', 21, 'M', 'dual automata', 8, 317, 447, 'arcuri', 'mono', 'led', 'full', 3240),
(55, 3285, 'Euro 6', 22, 'E', 'manuala', 9, 293, 685, 'arcuri reglabile', 'none', 'halogen', 'fara', 3311),
(56, 2278, 'Euro 4', 15, 'H', 'manuala', 8, 157, 342, 'arcuri', 'multiple', 'xenon', 'fara', 4452),
(57, 2684, 'Euro 5', 13, 'H', 'automata', 5, 454, 535, ' perne aer', 'mono', 'xenon', 'parcare', 1735),
(58, 5285, 'Euro 6', 29, 'H', 'automata', 4, 268, 662, 'arcuri', 'none', 'halogen', 'full', 937),
(59, 3111, 'Euro 4', 3, 'B', 'automata', 8, 116, 606, ' perne aer', 'none', 'led', 'full', 1076),
(60, 4836, 'Euro 5', 27, 'B', 'dual automata', 8, 201, 241, 'arcuri reglabile', 'none', 'led', 'parcare', 2493),
(61, 4823, 'Euro 6', 4, 'H', 'dual automata', 5, 187, 201, 'arcuri reglabile', 'multiple', 'xenon', 'fara', 1269),
(62, 4014, 'Euro 5', 15, 'H', 'manuala', 6, 113, 549, 'arcuri reglabile', 'mono', 'led', 'fara', 4324),
(63, 1088, 'Euro 5', 26, 'M', 'automata', 5, 294, 431, ' perne aer', 'none', 'led', 'parcare', 3845),
(64, 4698, 'Euro 4', 18, 'E', 'automata', 4, 457, 442, 'arcuri', 'none', 'led', 'full', 2499),
(65, 5805, 'Euro 5', 20, 'E', 'automata', 6, 223, 349, 'arcuri', 'mono', 'halogen', 'parcare', 3066),
(66, 5845, 'Euro 4', 4, 'B', 'automata', 9, 332, 632, 'arcuri reglabile', 'mono', 'led', 'parcare', 1196),
(67, 2681, 'Euro 5', 17, 'B', 'automata', 4, 469, 496, ' perne aer', 'mono', 'led', 'full', 1383),
(68, 2183, 'Euro 5', 22, 'H', 'dual automata', 4, 343, 697, 'arcuri reglabile', 'multiple', 'led', 'fara', 1736),
(69, 4132, 'Euro 4', 11, 'M', 'manuala', 8, 519, 264, 'arcuri', 'none', 'halogen', 'fara', 2371),
(70, 3949, 'Euro 4', 25, 'H', 'manuala', 7, 596, 572, ' perne aer', 'multiple', 'halogen', 'fara', 2912),
(71, 4178, 'Euro 6', 29, 'M', 'manuala', 9, 608, 585, 'arcuri reglabile', 'multiple', 'led', 'full', 1372),
(72, 4275, 'Euro 4', 17, 'M', 'manuala', 9, 557, 246, 'arcuri', 'none', 'led', 'full', 2564),
(73, 5345, 'Euro 4', 30, 'E', 'dual automata', 6, 552, 445, ' perne aer', 'multiple', 'halogen', 'full', 3002),
(74, 4572, 'Euro 4', 20, 'H', 'manuala', 9, 590, 577, ' perne aer', 'mono', 'halogen', 'parcare', 1185),
(75, 2320, 'Euro 5', 8, 'E', 'automata', 4, 472, 325, ' perne aer', 'multiple', 'xenon', 'fara', 2373),
(76, 5362, 'Euro 4', 22, 'H', 'automata', 9, 433, 561, 'arcuri', 'none', 'led', 'fara', 1485),
(77, 2408, 'Euro 5', 25, 'B', 'dual automata', 5, 180, 503, ' perne aer', 'mono', 'xenon', 'parcare', 3846),
(78, 3283, 'Euro 4', 28, 'H', 'automata', 8, 126, 316, 'arcuri reglabile', 'none', 'led', 'full', 1681),
(79, 1187, 'Euro 4', 10, 'M', 'automata', 5, 553, 296, 'arcuri', 'multiple', 'xenon', 'fara', 2065),
(80, 2675, 'Euro 4', 21, 'H', 'dual automata', 7, 240, 697, ' perne aer', 'multiple', 'xenon', 'parcare', 3746),
(81, 5828, 'Euro 5', 22, 'M', 'manuala', 5, 267, 321, 'arcuri', 'multiple', 'halogen', 'full', 1532),
(82, 4309, 'Euro 6', 11, 'E', 'manuala', 6, 498, 176, 'arcuri reglabile', 'none', 'halogen', 'fara', 3232),
(83, 5227, 'Euro 4', 17, 'M', 'manuala', 9, 377, 400, ' perne aer', 'multiple', 'led', 'full', 4032),
(84, 1881, 'Euro 4', 18, 'B', 'manuala', 5, 429, 602, ' perne aer', 'none', 'xenon', 'fara', 3933),
(85, 1512, 'Euro 5', 14, 'M', 'manuala', 8, 186, 342, 'arcuri', 'multiple', 'led', 'parcare', 2486),
(86, 5096, 'Euro 6', 18, 'B', 'dual automata', 7, 508, 348, 'arcuri reglabile', 'none', 'led', 'parcare', 4001),
(87, 2566, 'Euro 4', 30, 'B', 'manuala', 7, 368, 529, 'arcuri', 'none', 'halogen', 'fara', 3183),
(88, 2007, 'Euro 6', 16, 'E', 'automata', 9, 550, 386, 'arcuri', 'multiple', 'halogen', 'parcare', 1440),
(89, 5292, 'Euro 6', 15, 'M', 'manuala', 8, 450, 642, ' perne aer', 'mono', 'halogen', 'parcare', 4247),
(90, 4322, 'Euro 6', 23, 'M', 'manuala', 9, 618, 504, 'arcuri reglabile', 'none', 'led', 'fara', 999),
(91, 1868, 'Euro 4', 13, 'H', 'automata', 7, 486, 339, ' perne aer', 'mono', 'xenon', 'full', 2638),
(92, 5599, 'Euro 6', 23, 'B', 'manuala', 4, 529, 153, 'arcuri', 'mono', 'halogen', 'parcare', 1265),
(93, 5958, 'Euro 4', 9, 'H', 'automata', 5, 446, 691, 'arcuri', 'mono', 'xenon', 'full', 1002),
(94, 4410, 'Euro 5', 10, 'M', 'automata', 4, 150, 159, ' perne aer', 'none', 'halogen', 'parcare', 4339),
(95, 4608, 'Euro 4', 7, 'B', 'manuala', 7, 274, 648, ' perne aer', 'multiple', 'led', 'fara', 1017),
(96, 1918, 'Euro 6', 3, 'E', 'automata', 4, 581, 384, 'arcuri', 'multiple', 'halogen', 'parcare', 3958),
(97, 2275, 'Euro 4', 23, 'H', 'dual automata', 4, 307, 220, 'arcuri', 'multiple', 'halogen', 'full', 2230),
(98, 5046, 'Euro 6', 25, 'E', 'automata', 7, 477, 594, 'arcuri reglabile', 'mono', 'xenon', 'full', 3094),
(99, 4615, 'Euro 4', 28, 'B', 'automata', 4, 545, 601, 'arcuri reglabile', 'mono', 'halogen', 'full', 1184),
(100, 1739, 'Euro 4', 15, 'B', 'dual automata', 5, 257, 546, 'arcuri', 'none', 'xenon', 'fara', 1053),
(101, 4045, 'Euro 6', 27, 'M', 'dual automata', 7, 600, 203, ' perne aer', 'none', 'halogen', 'parcare', 2358),
(102, 1423, 'Euro 5', 18, 'B', 'automata', 7, 128, 624, 'arcuri', 'mono', 'led', 'fara', 4249),
(103, 4517, 'Euro 4', 15, 'M', 'automata', 4, 396, 518, 'arcuri', 'mono', 'xenon', 'fara', 3342),
(104, 4031, 'Euro 6', 3, 'H', 'automata', 5, 531, 190, 'arcuri reglabile', 'mono', 'xenon', 'fara', 3412),
(105, 4311, 'Euro 4', 11, 'B', 'automata', 9, 99, 595, 'arcuri', 'none', 'halogen', 'parcare', 4340),
(106, 6166, 'Euro 6', 25, 'B', 'dual automata', 4, 590, 244, 'arcuri', 'mono', 'led', 'fara', 3942),
(107, 1137, 'Euro 4', 28, 'B', 'automata', 4, 444, 497, 'arcuri', 'mono', 'halogen', 'fara', 3911),
(108, 2910, 'Euro 4', 12, 'M', 'manuala', 6, 510, 366, ' perne aer', 'mono', 'halogen', 'full', 1802),
(109, 4844, 'Euro 5', 30, 'H', 'manuala', 8, 300, 609, ' perne aer', 'multiple', 'halogen', 'full', 3342),
(110, 2048, 'Euro 6', 12, 'M', 'dual automata', 5, 527, 614, 'arcuri reglabile', 'mono', 'halogen', 'parcare', 4161),
(111, 4510, 'Euro 4', 7, 'E', 'manuala', 4, 186, 419, 'arcuri reglabile', 'multiple', 'led', 'full', 2322),
(112, 3272, 'Euro 6', 24, 'B', 'dual automata', 9, 401, 255, 'arcuri', 'none', 'halogen', 'parcare', 1493),
(113, 5665, 'Euro 4', 23, 'B', 'manuala', 7, 638, 436, 'arcuri', 'multiple', 'halogen', 'fara', 3596),
(114, 1584, 'Euro 6', 20, 'B', 'automata', 7, 431, 690, 'arcuri', 'multiple', 'halogen', 'parcare', 2437),
(115, 4510, 'Euro 4', 17, 'E', 'automata', 6, 398, 180, 'arcuri reglabile', 'mono', 'xenon', 'full', 3823),
(116, 1533, 'Euro 4', 25, 'H', 'manuala', 5, 318, 327, ' perne aer', 'multiple', 'led', 'full', 4215),
(117, 5707, 'Euro 5', 22, 'E', 'automata', 4, 144, 528, 'arcuri reglabile', 'none', 'led', 'parcare', 2776),
(118, 4010, 'Euro 6', 9, 'B', 'automata', 8, 320, 345, 'arcuri reglabile', 'multiple', 'led', 'full', 4005),
(119, 5642, 'Euro 4', 14, 'B', 'automata', 9, 331, 577, ' perne aer', 'mono', 'led', 'parcare', 1789),
(120, 5802, 'Euro 5', 6, 'M', 'manuala', 7, 454, 422, ' perne aer', 'none', 'led', 'fara', 989),
(121, 5649, 'Euro 6', 17, 'H', 'dual automata', 9, 385, 300, 'arcuri', 'multiple', 'xenon', 'parcare', 3530),
(122, 5780, 'Euro 4', 22, 'H', 'dual automata', 4, 125, 494, 'arcuri reglabile', 'mono', 'xenon', 'parcare', 4222),
(123, 2017, 'Euro 6', 6, 'B', 'dual automata', 6, 352, 331, 'arcuri reglabile', 'mono', 'halogen', 'fara', 4014),
(124, 1617, 'Euro 6', 11, 'B', 'dual automata', 4, 612, 637, ' perne aer', 'none', 'xenon', 'fara', 1494),
(125, 4201, 'Euro 4', 15, 'H', 'automata', 6, 573, 623, 'arcuri', 'multiple', 'halogen', 'fara', 3436),
(126, 2696, 'Euro 6', 6, 'E', 'manuala', 5, 516, 541, 'arcuri', 'multiple', 'xenon', 'full', 1027),
(127, 3056, 'Euro 4', 30, 'H', 'manuala', 7, 568, 655, 'arcuri reglabile', 'none', 'led', 'parcare', 2146),
(128, 2196, 'Euro 6', 21, 'H', 'automata', 6, 331, 293, 'arcuri', 'mono', 'led', 'fara', 2318),
(129, 3630, 'Euro 6', 3, 'B', 'dual automata', 5, 572, 492, 'arcuri reglabile', 'multiple', 'halogen', 'full', 1790),
(130, 2694, 'Euro 6', 21, 'B', 'automata', 9, 470, 203, 'arcuri', 'multiple', 'halogen', 'fara', 1272),
(131, 4928, 'Euro 5', 7, 'B', 'automata', 5, 640, 530, 'arcuri reglabile', 'multiple', 'led', 'fara', 2851),
(132, 1431, 'Euro 6', 9, 'H', 'automata', 6, 597, 346, 'arcuri', 'mono', 'xenon', 'fara', 1979),
(133, 5387, 'Euro 5', 4, 'B', 'automata', 5, 465, 393, 'arcuri', 'multiple', 'xenon', 'full', 2066),
(134, 2342, 'Euro 5', 4, 'E', 'dual automata', 8, 125, 665, 'arcuri reglabile', 'mono', 'halogen', 'full', 1660),
(135, 3744, 'Euro 5', 24, 'M', 'automata', 5, 623, 442, 'arcuri reglabile', 'mono', 'led', 'parcare', 3106),
(136, 1468, 'Euro 4', 3, 'B', 'dual automata', 6, 600, 236, ' perne aer', 'mono', 'halogen', 'fara', 4332),
(137, 5087, 'Euro 5', 16, 'H', 'manuala', 9, 613, 378, 'arcuri', 'multiple', 'led', 'full', 1710),
(138, 2100, 'Euro 5', 4, 'E', 'manuala', 4, 107, 288, 'arcuri', 'mono', 'halogen', 'full', 4260),
(139, 1329, 'Euro 5', 28, 'B', 'dual automata', 8, 283, 168, 'arcuri', 'none', 'xenon', 'fara', 976),
(140, 5056, 'Euro 5', 3, 'M', 'dual automata', 8, 607, 205, ' perne aer', 'multiple', 'xenon', 'full', 3064),
(141, 2212, 'Euro 5', 17, 'H', 'automata', 9, 465, 598, 'arcuri', 'mono', 'halogen', 'full', 3621),
(142, 6108, 'Euro 5', 7, 'E', 'automata', 7, 173, 296, 'arcuri', 'multiple', 'halogen', 'fara', 3430),
(143, 5638, 'Euro 4', 14, 'B', 'automata', 9, 68, 644, 'arcuri reglabile', 'none', 'halogen', 'parcare', 3999),
(144, 3912, 'Euro 4', 4, 'H', 'manuala', 9, 163, 230, ' perne aer', 'none', 'xenon', 'full', 1861),
(145, 1729, 'Euro 6', 12, 'H', 'automata', 6, 134, 266, ' perne aer', 'none', 'xenon', 'parcare', 1041),
(146, 1357, 'Euro 5', 9, 'E', 'dual automata', 9, 562, 592, 'arcuri', 'mono', 'halogen', 'fara', 3977),
(147, 2716, 'Euro 5', 24, 'H', 'automata', 8, 162, 246, 'arcuri reglabile', 'mono', 'xenon', 'fara', 1457),
(148, 4905, 'Euro 6', 10, 'E', 'manuala', 9, 228, 668, ' perne aer', 'none', 'xenon', 'parcare', 3716),
(149, 5147, 'Euro 4', 8, 'M', 'automata', 7, 130, 389, 'arcuri reglabile', 'multiple', 'led', 'full', 3950),
(150, 4643, 'Euro 4', 20, 'H', 'manuala', 4, 383, 605, 'arcuri', 'multiple', 'xenon', 'full', 4265),
(151, 3888, 'Euro 6', 9, 'B', 'dual automata', 4, 305, 398, 'arcuri', 'none', 'halogen', 'full', 1281),
(152, 3606, 'Euro 6', 8, 'E', 'dual automata', 8, 281, 330, 'arcuri reglabile', 'none', 'led', 'parcare', 2731),
(153, 6165, 'Euro 5', 23, 'M', 'dual automata', 9, 554, 523, ' perne aer', 'mono', 'led', 'fara', 2492),
(154, 5795, 'Euro 5', 11, 'H', 'manuala', 8, 383, 323, ' perne aer', 'mono', 'xenon', 'parcare', 3015),
(155, 4994, 'Euro 4', 30, 'E', 'automata', 4, 85, 366, 'arcuri reglabile', 'multiple', 'led', 'parcare', 841),
(156, 1166, 'Euro 6', 30, 'E', 'automata', 5, 557, 697, 'arcuri reglabile', 'mono', 'halogen', 'fara', 1075),
(157, 5219, 'Euro 6', 9, 'H', 'automata', 6, 453, 473, 'arcuri reglabile', 'multiple', 'xenon', 'full', 3562),
(158, 2815, 'Euro 5', 15, 'H', 'automata', 8, 164, 200, ' perne aer', 'none', 'halogen', 'full', 4305),
(159, 3216, 'Euro 6', 4, 'E', 'manuala', 5, 595, 598, 'arcuri', 'mono', 'led', 'full', 1741),
(160, 2431, 'Euro 4', 9, 'B', 'dual automata', 5, 198, 611, 'arcuri', 'mono', 'halogen', 'fara', 3326),
(161, 5537, 'Euro 6', 3, 'H', 'dual automata', 9, 78, 543, 'arcuri reglabile', 'mono', 'led', 'parcare', 1150),
(162, 4569, 'Euro 6', 21, 'E', 'manuala', 5, 191, 309, ' perne aer', 'multiple', 'halogen', 'full', 2294),
(163, 1854, 'Euro 6', 14, 'E', 'manuala', 7, 441, 615, 'arcuri', 'mono', 'xenon', 'parcare', 2556),
(164, 4899, 'Euro 6', 3, 'M', 'manuala', 7, 199, 436, ' perne aer', 'multiple', 'xenon', 'full', 2407),
(165, 2439, 'Euro 6', 3, 'H', 'dual automata', 6, 472, 542, 'arcuri reglabile', 'none', 'halogen', 'fara', 1300),
(166, 5468, 'Euro 5', 19, 'E', 'dual automata', 9, 628, 609, ' perne aer', 'multiple', 'xenon', 'parcare', 3028),
(167, 2327, 'Euro 5', 11, 'H', 'manuala', 9, 494, 222, 'arcuri reglabile', 'multiple', 'led', 'parcare', 1231),
(168, 4806, 'Euro 4', 23, 'H', 'automata', 4, 352, 340, ' perne aer', 'mono', 'led', 'full', 893),
(169, 2814, 'Euro 6', 20, 'E', 'automata', 9, 95, 167, ' perne aer', 'multiple', 'led', 'full', 4205),
(170, 5005, 'Euro 5', 8, 'B', 'automata', 5, 558, 550, 'arcuri reglabile', 'mono', 'xenon', 'parcare', 4088),
(171, 1215, 'Euro 5', 29, 'H', 'automata', 4, 540, 350, 'arcuri reglabile', 'none', 'xenon', 'parcare', 3261),
(172, 3287, 'Euro 6', 23, 'H', 'manuala', 5, 541, 225, ' perne aer', 'mono', 'led', 'full', 1824),
(173, 3318, 'Euro 4', 10, 'M', 'dual automata', 6, 353, 354, 'arcuri', 'mono', 'xenon', 'fara', 1218),
(174, 3764, 'Euro 5', 23, 'E', 'manuala', 9, 521, 615, ' perne aer', 'none', 'led', 'full', 849),
(175, 3930, 'Euro 5', 23, 'M', 'automata', 8, 306, 313, ' perne aer', 'mono', 'xenon', 'parcare', 4070),
(176, 2625, 'Euro 5', 27, 'M', 'dual automata', 7, 519, 266, ' perne aer', 'none', 'xenon', 'fara', 2976),
(177, 2485, 'Euro 5', 22, 'H', 'dual automata', 8, 100, 569, 'arcuri', 'multiple', 'xenon', 'parcare', 3024),
(178, 5492, 'Euro 4', 25, 'B', 'dual automata', 8, 510, 291, 'arcuri reglabile', 'none', 'led', 'full', 3116),
(179, 5073, 'Euro 6', 28, 'B', 'manuala', 9, 314, 252, 'arcuri', 'none', 'led', 'full', 1341),
(180, 4753, 'Euro 5', 5, 'E', 'automata', 5, 191, 180, 'arcuri', 'multiple', 'halogen', 'parcare', 4335),
(181, 5824, 'Euro 5', 19, 'B', 'manuala', 6, 193, 629, 'arcuri reglabile', 'none', 'xenon', 'fara', 931),
(182, 2823, 'Euro 5', 17, 'H', 'automata', 8, 519, 188, ' perne aer', 'none', 'xenon', 'full', 1916),
(183, 4071, 'Euro 4', 19, 'H', 'automata', 5, 202, 302, 'arcuri reglabile', 'mono', 'led', 'full', 3398),
(184, 1254, 'Euro 5', 18, 'M', 'manuala', 9, 291, 161, 'arcuri', 'multiple', 'xenon', 'parcare', 2977),
(185, 3671, 'Euro 4', 13, 'H', 'manuala', 5, 121, 314, 'arcuri', 'mono', 'halogen', 'full', 4196),
(186, 5292, 'Euro 6', 10, 'H', 'manuala', 6, 524, 320, ' perne aer', 'none', 'halogen', 'fara', 3492),
(187, 6033, 'Euro 5', 28, 'M', 'manuala', 7, 407, 551, 'arcuri', 'multiple', 'xenon', 'parcare', 2939),
(188, 6065, 'Euro 5', 3, 'H', 'dual automata', 4, 413, 361, ' perne aer', 'multiple', 'led', 'parcare', 3639),
(189, 4696, 'Euro 4', 3, 'M', 'manuala', 8, 545, 193, 'arcuri reglabile', 'multiple', 'xenon', 'fara', 1447),
(190, 1094, 'Euro 6', 13, 'B', 'manuala', 7, 484, 337, 'arcuri reglabile', 'multiple', 'xenon', 'parcare', 2893),
(191, 1771, 'Euro 4', 10, 'H', 'dual automata', 4, 173, 572, ' perne aer', 'multiple', 'halogen', 'full', 4043),
(192, 2838, 'Euro 5', 20, 'E', 'automata', 6, 510, 274, 'arcuri reglabile', 'multiple', 'led', 'full', 2033),
(193, 3483, 'Euro 4', 13, 'B', 'dual automata', 6, 335, 215, 'arcuri reglabile', 'none', 'xenon', 'parcare', 2445),
(194, 4582, 'Euro 5', 26, 'M', 'dual automata', 4, 460, 267, 'arcuri reglabile', 'multiple', 'xenon', 'parcare', 2396),
(195, 5854, 'Euro 5', 9, 'H', 'dual automata', 5, 155, 315, 'arcuri reglabile', 'mono', 'led', 'parcare', 4118),
(196, 2087, 'Euro 6', 30, 'H', 'dual automata', 7, 188, 599, 'arcuri reglabile', 'mono', 'xenon', 'fara', 2194),
(197, 2929, 'Euro 5', 14, 'H', 'automata', 4, 637, 697, 'arcuri', 'none', 'halogen', 'parcare', 3434),
(198, 2380, 'Euro 4', 12, 'E', 'automata', 6, 607, 566, 'arcuri reglabile', 'multiple', 'halogen', 'fara', 4203),
(199, 6196, 'Euro 6', 4, 'E', 'manuala', 9, 68, 647, 'arcuri', 'mono', 'led', 'parcare', 1621),
(200, 1942, 'Euro 4', 5, 'E', 'manuala', 6, 506, 460, 'arcuri reglabile', 'multiple', 'led', 'full', 879),
(201, 6170, 'Euro 6', 6, 'M', 'dual automata', 6, 357, 559, 'arcuri', 'mono', 'led', 'fara', 3596),
(202, 2866, 'Euro 6', 5, 'H', 'manuala', 7, 224, 239, ' perne aer', 'mono', 'halogen', 'parcare', 2907),
(203, 1801, 'Euro 4', 6, 'E', 'dual automata', 4, 315, 618, ' perne aer', 'mono', 'halogen', 'fara', 3867),
(204, 4684, 'Euro 5', 20, 'M', 'dual automata', 8, 530, 501, ' perne aer', 'mono', 'xenon', 'parcare', 3638),
(205, 3068, 'Euro 6', 17, 'B', 'dual automata', 9, 311, 262, 'arcuri reglabile', 'mono', 'led', 'full', 1369),
(206, 1513, 'Euro 6', 23, 'M', 'automata', 6, 64, 280, ' perne aer', 'none', 'led', 'parcare', 3584),
(207, 2587, 'Euro 5', 27, 'B', 'automata', 9, 401, 665, ' perne aer', 'none', 'halogen', 'full', 2594),
(208, 5941, 'Euro 4', 30, 'M', 'manuala', 8, 91, 229, 'arcuri reglabile', 'mono', 'led', 'full', 2363),
(209, 3082, 'Euro 5', 26, 'H', 'manuala', 6, 553, 171, ' perne aer', 'mono', 'xenon', 'full', 2875),
(210, 4743, 'Euro 5', 5, 'E', 'dual automata', 9, 350, 616, 'arcuri', 'multiple', 'xenon', 'full', 1858),
(211, 5356, 'Euro 5', 29, 'B', 'automata', 4, 146, 267, 'arcuri reglabile', 'none', 'led', 'full', 2180),
(212, 1145, 'Euro 6', 29, 'H', 'dual automata', 6, 625, 336, 'arcuri reglabile', 'mono', 'xenon', 'parcare', 1413),
(213, 3047, 'Euro 5', 23, 'H', 'dual automata', 9, 228, 432, 'arcuri', 'mono', 'halogen', 'fara', 2496),
(214, 6166, 'Euro 4', 29, 'M', 'dual automata', 5, 190, 495, 'arcuri', 'none', 'halogen', 'parcare', 4425),
(215, 3515, 'Euro 6', 30, 'B', 'dual automata', 6, 179, 583, ' perne aer', 'multiple', 'halogen', 'parcare', 2460),
(216, 4050, 'Euro 4', 30, 'H', 'manuala', 6, 491, 612, ' perne aer', 'mono', 'halogen', 'parcare', 2658),
(217, 2408, 'Euro 6', 26, 'E', 'dual automata', 4, 374, 427, 'arcuri reglabile', 'none', 'xenon', 'parcare', 4456),
(218, 2576, 'Euro 4', 30, 'E', 'automata', 8, 454, 187, 'arcuri reglabile', 'multiple', 'xenon', 'fara', 1340),
(219, 3315, 'Euro 4', 3, 'M', 'dual automata', 8, 312, 400, ' perne aer', 'mono', 'led', 'parcare', 3020),
(220, 5897, 'Euro 4', 17, 'H', 'manuala', 8, 609, 400, 'arcuri', 'none', 'halogen', 'parcare', 4053),
(221, 2439, 'Euro 6', 16, 'H', 'automata', 9, 270, 660, 'arcuri reglabile', 'mono', 'halogen', 'full', 4233),
(222, 1064, 'Euro 4', 30, 'B', 'dual automata', 9, 95, 377, 'arcuri reglabile', 'multiple', 'led', 'fara', 2124),
(223, 5893, 'Euro 5', 6, 'M', 'manuala', 4, 239, 335, 'arcuri', 'none', 'led', 'fara', 4457),
(224, 2257, 'Euro 6', 22, 'M', 'manuala', 9, 301, 165, 'arcuri reglabile', 'none', 'led', 'full', 2398),
(225, 4189, 'Euro 6', 25, 'M', 'manuala', 5, 494, 332, ' perne aer', 'multiple', 'halogen', 'full', 2045),
(226, 4311, 'Euro 5', 8, 'E', 'automata', 8, 438, 219, 'arcuri', 'mono', 'xenon', 'full', 2347),
(227, 5919, 'Euro 5', 3, 'M', 'manuala', 6, 237, 503, 'arcuri', 'mono', 'led', 'full', 3697),
(228, 5319, 'Euro 6', 4, 'B', 'manuala', 6, 270, 549, ' perne aer', 'multiple', 'xenon', 'full', 2618),
(229, 4595, 'Euro 5', 24, 'M', 'dual automata', 8, 573, 697, 'arcuri reglabile', 'mono', 'led', 'fara', 1055),
(230, 2306, 'Euro 4', 19, 'H', 'manuala', 9, 504, 561, 'arcuri', 'none', 'halogen', 'fara', 3902),
(231, 3598, 'Euro 6', 24, 'M', 'automata', 4, 547, 525, 'arcuri reglabile', 'multiple', 'led', 'parcare', 1135),
(232, 1771, 'Euro 5', 17, 'B', 'automata', 5, 260, 474, 'arcuri reglabile', 'multiple', 'led', 'parcare', 1224),
(233, 3930, 'Euro 5', 8, 'M', 'dual automata', 8, 639, 195, 'arcuri', 'multiple', 'led', 'parcare', 3502),
(234, 3467, 'Euro 4', 6, 'M', 'manuala', 7, 570, 245, 'arcuri reglabile', 'mono', 'led', 'parcare', 1434),
(235, 5748, 'Euro 5', 30, 'H', 'manuala', 7, 328, 433, ' perne aer', 'multiple', 'led', 'fara', 3103),
(236, 4929, 'Euro 5', 19, 'E', 'automata', 9, 256, 503, 'arcuri', 'multiple', 'xenon', 'fara', 2689),
(237, 1154, 'Euro 6', 5, 'H', 'automata', 6, 76, 388, 'arcuri reglabile', 'mono', 'led', 'parcare', 2871),
(238, 4567, 'Euro 5', 21, 'E', 'manuala', 8, 608, 543, ' perne aer', 'none', 'halogen', 'parcare', 2016),
(239, 4194, 'Euro 6', 24, 'E', 'automata', 8, 79, 517, 'arcuri reglabile', 'mono', 'xenon', 'fara', 1780),
(240, 5209, 'Euro 6', 11, 'E', 'dual automata', 9, 174, 224, 'arcuri reglabile', 'multiple', 'led', 'full', 4395),
(241, 4033, 'Euro 5', 19, 'B', 'dual automata', 5, 403, 429, ' perne aer', 'multiple', 'led', 'full', 1756),
(242, 3975, 'Euro 5', 24, 'H', 'automata', 4, 466, 476, 'arcuri reglabile', 'none', 'halogen', 'fara', 848),
(243, 5804, 'Euro 6', 19, 'M', 'dual automata', 9, 279, 231, ' perne aer', 'none', 'xenon', 'full', 1938),
(244, 2886, 'Euro 5', 15, 'B', 'dual automata', 5, 342, 429, 'arcuri', 'mono', 'halogen', 'parcare', 2044),
(245, 6151, 'Euro 4', 6, 'H', 'automata', 6, 375, 432, 'arcuri reglabile', 'none', 'xenon', 'parcare', 1857),
(246, 1994, 'Euro 6', 7, 'H', 'automata', 4, 362, 276, 'arcuri', 'none', 'xenon', 'full', 2815),
(247, 2916, 'Euro 6', 29, 'M', 'automata', 8, 170, 289, ' perne aer', 'none', 'halogen', 'fara', 1939),
(248, 3763, 'Euro 5', 22, 'M', 'automata', 6, 139, 339, ' perne aer', 'mono', 'halogen', 'fara', 2331),
(249, 1439, 'Euro 5', 4, 'M', 'manuala', 6, 570, 643, ' perne aer', 'none', 'led', 'fara', 3204),
(250, 1989, 'Euro 5', 17, 'H', 'dual automata', 8, 270, 357, 'arcuri reglabile', 'multiple', 'xenon', 'full', 1935),
(251, 2737, 'Euro 5', 30, 'H', 'automata', 8, 280, 559, 'arcuri', 'mono', 'xenon', 'parcare', 1853),
(252, 5471, 'Euro 4', 15, 'M', 'dual automata', 8, 264, 314, 'arcuri reglabile', 'multiple', 'led', 'fara', 2394),
(253, 3397, 'Euro 4', 10, 'E', 'automata', 4, 534, 677, 'arcuri reglabile', 'mono', 'halogen', 'full', 4344),
(254, 1861, 'Euro 6', 19, 'M', 'dual automata', 4, 505, 616, 'arcuri', 'none', 'halogen', 'fara', 3198),
(255, 1379, 'Euro 6', 29, 'H', 'manuala', 4, 231, 409, ' perne aer', 'multiple', 'halogen', 'fara', 981),
(256, 6015, 'Euro 5', 7, 'E', 'dual automata', 7, 583, 548, ' perne aer', 'none', 'halogen', 'full', 2349),
(257, 4581, 'Euro 4', 14, 'E', 'manuala', 8, 366, 370, 'arcuri', 'mono', 'led', 'full', 2662),
(258, 4202, 'Euro 4', 15, 'H', 'dual automata', 5, 229, 355, 'arcuri reglabile', 'none', 'xenon', 'full', 3679),
(259, 5654, 'Euro 6', 19, 'M', 'automata', 8, 464, 326, 'arcuri', 'mono', 'led', 'full', 2281),
(260, 5364, 'Euro 6', 6, 'M', 'manuala', 6, 76, 391, ' perne aer', 'multiple', 'xenon', 'fara', 1112),
(261, 4016, 'Euro 5', 17, 'H', 'automata', 9, 566, 430, 'arcuri reglabile', 'mono', 'led', 'parcare', 3148),
(262, 2112, 'Euro 5', 23, 'M', 'automata', 7, 518, 632, 'arcuri reglabile', 'multiple', 'led', 'parcare', 1921),
(263, 3529, 'Euro 6', 14, 'M', 'automata', 7, 327, 203, ' perne aer', 'mono', 'halogen', 'parcare', 1049),
(264, 4077, 'Euro 5', 8, 'E', 'manuala', 7, 467, 481, ' perne aer', 'mono', 'xenon', 'parcare', 1532),
(265, 3168, 'Euro 5', 25, 'M', 'automata', 9, 194, 503, ' perne aer', 'multiple', 'xenon', 'fara', 1456),
(266, 1599, 'Euro 6', 28, 'H', 'manuala', 9, 208, 578, ' perne aer', 'none', 'halogen', 'fara', 3632),
(267, 2347, 'Euro 5', 19, 'H', 'dual automata', 8, 140, 173, 'arcuri reglabile', 'mono', 'xenon', 'full', 3093),
(268, 3133, 'Euro 6', 30, 'B', 'automata', 4, 99, 327, 'arcuri', 'none', 'xenon', 'full', 2224),
(269, 6191, 'Euro 6', 30, 'M', 'manuala', 9, 86, 473, 'arcuri', 'none', 'led', 'full', 848),
(270, 1633, 'Euro 6', 21, 'M', 'automata', 4, 584, 541, 'arcuri', 'none', 'xenon', 'fara', 1957),
(271, 4626, 'Euro 5', 3, 'M', 'automata', 5, 347, 411, 'arcuri', 'mono', 'led', 'parcare', 4141),
(272, 5035, 'Euro 6', 11, 'E', 'dual automata', 4, 627, 644, 'arcuri', 'none', 'led', 'full', 1129),
(273, 1867, 'Euro 4', 22, 'H', 'automata', 9, 236, 186, ' perne aer', 'mono', 'halogen', 'full', 4186),
(274, 4744, 'Euro 6', 13, 'M', 'automata', 9, 432, 212, ' perne aer', 'none', 'xenon', 'full', 3628),
(275, 3127, 'Euro 5', 7, 'M', 'automata', 6, 264, 557, 'arcuri reglabile', 'multiple', 'led', 'fara', 1461),
(276, 3310, 'Euro 4', 30, 'M', 'manuala', 4, 209, 364, 'arcuri', 'mono', 'led', 'parcare', 1449),
(277, 2622, 'Euro 4', 29, 'B', 'manuala', 9, 588, 439, ' perne aer', 'multiple', 'led', 'fara', 3105),
(278, 4267, 'Euro 6', 7, 'H', 'dual automata', 4, 246, 591, 'arcuri reglabile', 'none', 'led', 'fara', 1610),
(279, 1174, 'Euro 6', 8, 'B', 'dual automata', 8, 528, 352, 'arcuri', 'mono', 'led', 'fara', 846),
(280, 1270, 'Euro 5', 20, 'E', 'manuala', 5, 490, 287, 'arcuri reglabile', 'none', 'xenon', 'fara', 3687),
(281, 4733, 'Euro 4', 22, 'M', 'automata', 5, 331, 241, 'arcuri reglabile', 'mono', 'led', 'parcare', 2667);

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

--
-- Structură tabel pentru tabel `subclase`
--

DROP TABLE IF EXISTS `subclase`;
CREATE TABLE IF NOT EXISTS `subclase` (
  `id_subclasa` int(3) NOT NULL AUTO_INCREMENT,
  `denumire_subclasa` varchar(50) NOT NULL,
  `id_clasa` int(3) NOT NULL,
  PRIMARY KEY (`id_subclasa`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `subclase`
--

INSERT INTO `subclase` (`id_subclasa`, `denumire_subclasa`, `id_clasa`) VALUES
(1, 'Compacte', 1),
(2, 'SUV', 1),
(3, 'Sport', 1),
(4, 'SUV', 2),
(5, 'Rally', 2),
(6, 'Lux', 3),
(7, 'Compact', 3),
(8, 'Clasa mica', 4),
(9, 'Clasa medie', 4),
(10, 'Clasa mare', 5);

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

--
-- Structură tabel pentru tabel `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `nume_user` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `user_type` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Eliminarea datelor din tabel `users`
--

INSERT INTO `users` (`id_user`, `nume_user`, `username`, `email`, `password`, `user_type`, `active`) VALUES
(1, 'Admin', 'admin', 'admin@mail.com', '7c4a8d09ca3762af61e59520943dc26494f8941b', 'admin', 1);
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 */;