-- =====================================================
-- Babioto — Données véhicules
-- Marques (48), Modèles (269), Motorisations (960)
-- =====================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ─── TABLES ───────────────────────────────────────────────────────────────────

CREATE TABLE IF NOT EXISTS `babi_marques` (
  `id`  INT UNSIGNED     NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(100)     NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_nom` (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `babi_modeles` (
  `id`          INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `marque_id`   INT UNSIGNED NOT NULL,
  `nom`         VARCHAR(100) NOT NULL,
  `annee_debut` SMALLINT UNSIGNED NOT NULL DEFAULT 1990,
  `annee_fin`   SMALLINT UNSIGNED NOT NULL DEFAULT 2026,
  PRIMARY KEY (`id`),
  INDEX `idx_marque` (`marque_id`),
  CONSTRAINT `fk_modele_marque` FOREIGN KEY (`marque_id`) REFERENCES `babi_marques` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `babi_motorisations` (
  `id`        INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `modele_id` INT UNSIGNED NOT NULL,
  `nom`       VARCHAR(100) NOT NULL,
  `carburant` ENUM('essence','diesel','hybride','electrique') NOT NULL DEFAULT 'essence',
  PRIMARY KEY (`id`),
  INDEX `idx_modele` (`modele_id`),
  CONSTRAINT `fk_motor_modele` FOREIGN KEY (`modele_id`) REFERENCES `babi_modeles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ─── MARQUES (48) ────────────────────────────────────────────────────────────

INSERT IGNORE INTO `babi_marques` (`id`, `nom`) VALUES
(1,'Peugeot'),(2,'Renault'),(3,'Toyota'),(4,'Volkswagen'),(5,'BMW'),
(6,'Mercedes-Benz'),(7,'Citroën'),(8,'Honda'),(9,'Nissan'),(10,'Hyundai'),
(11,'Ford'),(12,'Kia'),(13,'Mazda'),(14,'Mitsubishi'),(15,'Suzuki'),
(16,'Dacia'),(17,'Opel'),(18,'Fiat'),(19,'Audi'),(20,'Land Rover'),
(21,'BYD'),(22,'Chery'),(23,'Geely'),(24,'BAIC'),(25,'Changan'),
(26,'Haval'),(27,'MG'),(28,'Dongfeng'),(29,'JAC'),(30,'Wuling'),
(31,'SAIC Motor'),(32,'Great Wall'),(33,'Foton'),(34,'DFSK'),(35,'Lifan'),
(36,'Zotye'),(37,'Volvo'),(38,'Jeep'),(39,'Subaru'),(40,'Skoda'),
(41,'Isuzu'),(42,'Lexus'),(43,'Chevrolet'),(44,'Seat'),(45,'Alfa Romeo'),
(46,'Porsche'),(47,'Infiniti'),(48,'Acura');

-- ─── MODELES (269) ───────────────────────────────────────────────────────────

INSERT IGNORE INTO `babi_modeles` (`id`, `marque_id`, `nom`, `annee_debut`, `annee_fin`) VALUES
-- Peugeot (1)
(1,1,'504',1968,2005),(2,1,'205',1983,1998),(3,1,'206',1998,2012),(4,1,'207',2006,2015),
(5,1,'208',2012,2026),(6,1,'301',2012,2022),(7,1,'307',2001,2009),(8,1,'308',2007,2026),
(9,1,'3008',2009,2026),(10,1,'407',2004,2011),(11,1,'5008',2009,2026),(12,1,'Partner',1996,2026),
-- Renault (2)
(13,2,'Twingo',1992,2026),(14,2,'Clio',1990,2026),(15,2,'Mégane',1996,2026),(16,2,'Logan',2004,2026),
(17,2,'Sandero',2008,2026),(18,2,'Duster',2010,2026),(19,2,'Scénic',1997,2024),(20,2,'Koleos',2008,2026),
(21,2,'Kangoo',1997,2026),(22,2,'Symbol',2000,2022),
-- Toyota (3)
(23,3,'Yaris',1999,2026),(24,3,'Corolla',1966,2026),(25,3,'Camry',1982,2026),(26,3,'Avensis',1997,2018),
(27,3,'Auris',2006,2019),(28,3,'RAV4',1994,2026),(29,3,'Hilux',1968,2026),(30,3,'Land Cruiser',1951,2026),
(31,3,'Prado',1984,2026),(32,3,'Fortuner',2005,2026),(33,3,'Verso',2004,2018),
-- Volkswagen (4)
(34,4,'Polo',1975,2026),(35,4,'Golf',1974,2026),(36,4,'Passat',1973,2026),(37,4,'Tiguan',2007,2026),
(38,4,'Touareg',2002,2026),(39,4,'T-Roc',2017,2026),(40,4,'Caddy',1983,2026),
-- BMW (5)
(41,5,'Série 1',2004,2026),(42,5,'Série 2',2013,2026),(43,5,'Série 3',1975,2026),
(44,5,'Série 5',1972,2026),(45,5,'X1',2009,2026),(46,5,'X3',2003,2026),(47,5,'X5',1999,2026),
-- Mercedes-Benz (6)
(48,6,'Classe A',1997,2026),(49,6,'Classe B',2005,2026),(50,6,'Classe C',1993,2026),
(51,6,'Classe E',1984,2026),(52,6,'GLC',2015,2026),(53,6,'Vito',1996,2026),(54,6,'Sprinter',1995,2026),
-- Citroën (7)
(55,7,'C2',2003,2009),(56,7,'C3',2002,2026),(57,7,'C4',2004,2026),(58,7,'C5',2001,2022),
(59,7,'C3 Aircross',2017,2026),(60,7,'Berlingo',1996,2026),(61,7,'Jumper',1994,2026),(62,7,'C-Elysée',2012,2022),
-- Honda (8)
(63,8,'Jazz',2001,2026),(64,8,'Civic',1972,2026),(65,8,'Accord',1976,2026),
(66,8,'CR-V',1995,2026),(67,8,'HR-V',1999,2026),(68,8,'BR-V',2016,2026),
-- Nissan (9)
(69,9,'Micra',1982,2026),(70,9,'Juke',2010,2026),(71,9,'Qashqai',2007,2026),(72,9,'X-Trail',2000,2026),
(73,9,'Navara',2005,2026),(74,9,'Patrol',1951,2026),(75,9,'Terrano',1987,2010),
-- Hyundai (10)
(76,10,'i10',2007,2026),(77,10,'i20',2008,2026),(78,10,'i30',2007,2026),(79,10,'Accent',1994,2026),
(80,10,'Tucson',2004,2026),(81,10,'Santa Fe',2000,2026),(82,10,'Creta',2015,2026),
-- Ford (11)
(83,11,'Fiesta',1976,2023),(84,11,'Focus',1998,2026),(85,11,'Mondeo',1993,2022),
(86,11,'EcoSport',2012,2022),(87,11,'Kuga',2008,2026),(88,11,'Ranger',1983,2026),(89,11,'Transit',1965,2026),
-- Kia (12)
(90,12,'Picanto',2004,2026),(91,12,'Rio',2000,2026),(92,12,'Ceed',2006,2026),
(93,12,'Sportage',1993,2026),(94,12,'Sorento',2002,2026),
-- Mazda (13)
(95,13,'Mazda2',2002,2026),(96,13,'Mazda3',2003,2026),(97,13,'Mazda6',2002,2026),
(98,13,'CX-3',2015,2026),(99,13,'CX-5',2012,2026),(100,13,'CX-30',2019,2026),
-- Mitsubishi (14)
(101,14,'Colt',1962,2012),(102,14,'Lancer',1973,2017),(103,14,'Outlander',2001,2026),
(104,14,'ASX',2010,2026),(105,14,'L200',1978,2026),(106,14,'Pajero',1981,2026),(107,14,'Eclipse Cross',2017,2026),
-- Suzuki (15)
(108,15,'Alto',1979,2022),(109,15,'Swift',2004,2026),(110,15,'S-Cross',2013,2026),
(111,15,'Vitara',1988,2026),(112,15,'Grand Vitara',1998,2015),(113,15,'Jimny',1970,2026),
-- Dacia (16)
(114,16,'Logan',2004,2026),(115,16,'Sandero',2008,2026),(116,16,'Duster',2010,2026),
(117,16,'Lodgy',2012,2022),(118,16,'Dokker',2012,2022),(119,16,'Spring',2021,2026),
-- Opel (17)
(120,17,'Corsa',1982,2026),(121,17,'Astra',1984,2026),(122,17,'Insignia',2008,2026),
(123,17,'Mokka',2012,2026),(124,17,'Crossland',2017,2026),(125,17,'Zafira',1999,2019),
-- Fiat (18)
(126,18,'Panda',1980,2026),(127,18,'Punto',1993,2018),(128,18,'500',2007,2026),
(129,18,'Bravo',2007,2014),(130,18,'Doblò',2001,2026),(131,18,'Ducato',1981,2026),
-- Audi (19)
(132,19,'A1',2010,2026),(133,19,'A3',1996,2026),(134,19,'A4',1994,2026),
(135,19,'A6',1994,2026),(136,19,'Q3',2011,2026),(137,19,'Q5',2008,2026),
-- Land Rover (20)
(138,20,'Freelander',1997,2014),(139,20,'Discovery Sport',2014,2026),(140,20,'Discovery',1989,2026),
(141,20,'Defender',1983,2026),(142,20,'Range Rover Sport',2005,2026),(143,20,'Range Rover',1969,2026),
-- BYD (21)
(144,21,'Dolphin',2021,2026),(145,21,'Atto 3',2022,2026),(146,21,'Seal',2022,2026),
(147,21,'Han',2020,2026),(148,21,'Tang',2018,2026),(149,21,'Song Plus',2021,2026),(150,21,'F3',2005,2022),
-- Chery (22)
(151,22,'QQ',2003,2022),(152,22,'Arrizo 5',2015,2026),(153,22,'Arrizo 6',2018,2026),
(154,22,'Tiggo 4',2017,2026),(155,22,'Tiggo 7',2016,2026),(156,22,'Tiggo 8',2018,2026),
-- Geely (23)
(157,23,'Emgrand',2009,2026),(158,23,'Atlas',2016,2026),(159,23,'Coolray',2019,2026),
(160,23,'Azkarra',2019,2026),(161,23,'Monjaro',2022,2026),
-- BAIC (24)
(162,24,'Senova D20',2014,2022),(163,24,'Senova X35',2015,2022),(164,24,'X55',2018,2026),
(165,24,'BJ40',2013,2026),(166,24,'BJ80',2015,2026),
-- Changan (25)
(167,25,'Eado',2012,2026),(168,25,'CS35',2012,2026),(169,25,'CS55',2017,2026),
(170,25,'CS75',2014,2026),(171,25,'CS85',2018,2026),(172,25,'Lumin',2022,2026),
-- Haval (26)
(173,26,'H1',2014,2022),(174,26,'H2',2014,2022),(175,26,'H4',2017,2026),
(176,26,'H6',2011,2026),(177,26,'H9',2017,2026),(178,26,'Jolion',2021,2026),(179,26,'Big Dog',2020,2026),
-- MG (27)
(180,27,'MG3',2011,2026),(181,27,'MG5 EV',2020,2026),(182,27,'MG6',2010,2026),
(183,27,'MG ZS',2017,2026),(184,27,'RX5',2016,2026),(185,27,'HS',2018,2026),
-- Dongfeng (28)
(186,28,'AX7',2015,2026),(187,28,'A60',2013,2022),(188,28,'Fengon 580',2019,2026),
(189,28,'SX6',2015,2022),(190,28,'Rich 6',2019,2026),
-- JAC (29)
(191,29,'J7',2020,2026),(192,29,'S3',2014,2022),(193,29,'S4 Pro',2019,2026),
(194,29,'T8 Pro',2021,2026),(195,29,'E10X',2021,2026),
-- Wuling (30)
(196,30,'Mini EV',2020,2026),(197,30,'Baojun 310',2016,2022),(198,30,'Almaz',2019,2026),
-- SAIC Motor (31)
(199,31,'Roewe 350',2010,2020),(200,31,'Roewe 550',2008,2022),(201,31,'Roewe 750',2006,2018),
-- Great Wall (32)
(202,32,'Wingle 5',2011,2022),(203,32,'Wingle 7',2018,2026),(204,32,'Pao',2019,2026),
-- Foton (33)
(205,33,'Tunland',2012,2026),(206,33,'View C2',2015,2026),(207,33,'Sauvana',2016,2026),
-- DFSK (34)
(208,34,'Glory 500',2017,2026),(209,34,'Glory 580',2018,2026),(210,34,'K01H',2010,2026),
-- Lifan (35)
(211,35,'X60',2011,2022),(212,35,'X70',2017,2022),(213,35,'820',2015,2022),
-- Zotye (36)
(214,36,'T300',2016,2022),(215,36,'T600',2013,2022),
-- Volvo (37)
(216,37,'S60',2000,2026),(217,37,'S90',2016,2026),(218,37,'V40',2012,2019),
(219,37,'V60',2010,2026),(220,37,'XC40',2017,2026),(221,37,'XC60',2008,2026),(222,37,'XC90',2002,2026),
-- Jeep (38)
(223,38,'Renegade',2014,2026),(224,38,'Compass',2006,2026),(225,38,'Cherokee',1974,2024),
(226,38,'Grand Cherokee',1992,2026),(227,38,'Wrangler',1986,2026),
-- Subaru (39)
(228,39,'Impreza',1992,2026),(229,39,'Legacy',1989,2026),(230,39,'Forester',1997,2026),
(231,39,'Outback',1994,2026),(232,39,'XV',2012,2026),
-- Skoda (40)
(233,40,'Fabia',1999,2026),(234,40,'Octavia',1996,2026),(235,40,'Superb',2001,2026),
(236,40,'Karoq',2017,2026),(237,40,'Kodiaq',2016,2026),
-- Isuzu (41)
(238,41,'D-Max',2002,2026),(239,41,'MU-X',2013,2026),(240,41,'TFR',1982,2010),
(241,41,'NPR',1980,2026),(242,41,'Trooper',1981,2002),
-- Lexus (42)
(243,42,'IS',1999,2026),(244,42,'ES',1989,2026),(245,42,'GS',1993,2012),
(246,42,'UX',2018,2026),(247,42,'NX',2014,2026),(248,42,'RX',1997,2026),(249,42,'GX',2002,2026),
-- Chevrolet (43)
(250,43,'Spark',1998,2022),(251,43,'Aveo',2002,2022),(252,43,'Cruze',2008,2019),
(253,43,'Malibu',1964,2023),(254,43,'Captiva',2006,2018),(255,43,'TrailBlazer',2001,2026),
-- Seat (44)
(256,44,'Ibiza',1984,2026),(257,44,'León',1999,2026),(258,44,'Arona',2017,2026),(259,44,'Ateca',2016,2026),
-- Alfa Romeo (45)
(260,45,'Giulietta',2010,2020),(261,45,'Giulia',2015,2026),(262,45,'Stelvio',2016,2026),
-- Porsche (46)
(263,46,'Cayenne',2002,2026),(264,46,'Macan',2014,2026),(265,46,'911',1963,2026),
-- Infiniti (47)
(266,47,'Q50',2013,2026),(267,47,'QX60',2013,2026),
-- Acura (48)
(268,48,'MDX',2000,2026),(269,48,'RDX',2006,2026);

-- ─── MOTORISATIONS batch 1/10 (IDs 1–96) ────────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
-- 504 (1)
(1,1,'1.8 L4','essence'),(2,1,'2.0 L4','essence'),(3,1,'2.3 XD','diesel'),(4,1,'2.5 D','diesel'),
-- 205 (2)
(5,2,'1.0','essence'),(6,2,'1.1','essence'),(7,2,'1.4','essence'),(8,2,'1.6','essence'),(9,2,'1.7 D','diesel'),
-- 206 (3)
(10,3,'1.1','essence'),(11,3,'1.4','essence'),(12,3,'1.6 16V','essence'),(13,3,'1.4 HDi','diesel'),(14,3,'1.6 HDi','diesel'),
-- 207 (4)
(15,4,'1.4 VTi','essence'),(16,4,'1.6 VTi 120','essence'),(17,4,'1.6 THP 150','essence'),(18,4,'1.4 HDi','diesel'),(19,4,'1.6 HDi','diesel'),
-- 208 (5)
(20,5,'1.0 PureTech 68','essence'),(21,5,'1.2 PureTech 82','essence'),(22,5,'1.2 PureTech 110','essence'),
(23,5,'1.5 BlueHDi 100','diesel'),(24,5,'1.6 BlueHDi 120','diesel'),
-- 301 (6)
(25,6,'1.2 PureTech 82','essence'),(26,6,'1.6 VTi 115','essence'),(27,6,'1.6 BlueHDi 100','diesel'),
-- 307 (7)
(28,7,'1.4 16V','essence'),(29,7,'1.6 16V','essence'),(30,7,'2.0 16V','essence'),
(31,7,'1.4 HDi','diesel'),(32,7,'1.6 HDi','diesel'),(33,7,'2.0 HDi','diesel'),
-- 308 (8)
(34,8,'1.2 PureTech 110','essence'),(35,8,'1.2 PureTech 130','essence'),(36,8,'1.6 THP 155','essence'),
(37,8,'1.5 BlueHDi 100','diesel'),(38,8,'1.6 BlueHDi 120','diesel'),(39,8,'2.0 BlueHDi 150','diesel'),
-- 3008 (9)
(40,9,'1.2 PureTech 130','essence'),(41,9,'1.6 PureTech 180','essence'),
(42,9,'1.5 BlueHDi 130','diesel'),(43,9,'2.0 BlueHDi 150','diesel'),(44,9,'1.6 Hybrid4 300','hybride'),
-- 407 (10)
(45,10,'1.8 16V','essence'),(46,10,'2.0 16V 140','essence'),(47,10,'2.2 V6','essence'),
(48,10,'1.6 HDi 110','diesel'),(49,10,'2.0 HDi 135','diesel'),
-- 5008 (11)
(50,11,'1.2 PureTech 130','essence'),(51,11,'1.6 THP 156','essence'),
(52,11,'1.5 BlueHDi 130','diesel'),(53,11,'2.0 BlueHDi 150','diesel'),(54,11,'2.0 BlueHDi 180','diesel'),
-- Partner (12)
(55,12,'1.2 PureTech 110','essence'),(56,12,'1.4i','essence'),(57,12,'1.6 BlueHDi 100','diesel'),(58,12,'2.0 HDi 90','diesel'),
-- Twingo (13)
(59,13,'1.0 SCe 65','essence'),(60,13,'1.0 TCe 90','essence'),(61,13,'1.2 16V','essence'),(62,13,'1.5 dCi 65','diesel'),
-- Clio (14)
(63,14,'1.0 SCe 65','essence'),(64,14,'0.9 TCe 90','essence'),(65,14,'1.2 16V','essence'),
(66,14,'1.4 16V','essence'),(67,14,'1.6 16V','essence'),(68,14,'1.5 dCi 65','diesel'),(69,14,'1.5 dCi 90','diesel'),
-- Mégane (15)
(70,15,'1.2 TCe 115','essence'),(71,15,'1.3 TCe 140','essence'),(72,15,'1.4 TCe 130','essence'),(73,15,'1.6 16V','essence'),
(74,15,'1.5 dCi 90','diesel'),(75,15,'1.5 dCi 110','diesel'),(76,15,'1.6 dCi 130','diesel'),
-- Logan Renault (16)
(77,16,'1.0 SCe 75','essence'),(78,16,'1.6 MPI 90','essence'),(79,16,'1.6 MPI 105','essence'),
(80,16,'1.5 dCi 75','diesel'),(81,16,'1.5 dCi 90','diesel'),
-- Sandero Renault (17)
(82,17,'1.0 SCe 75','essence'),(83,17,'1.0 TCe 90','essence'),(84,17,'1.6 MPI 90','essence'),
(85,17,'1.5 dCi 75','diesel'),(86,17,'1.5 dCi 90','diesel'),
-- Duster (18)
(87,18,'1.3 TCe 130','essence'),(88,18,'1.6 MPI 115','essence'),(89,18,'2.0 MPI 144','essence'),
(90,18,'1.5 dCi 90','diesel'),(91,18,'1.5 dCi 110','diesel'),
-- Scénic (19)
(92,19,'1.2 TCe 115','essence'),(93,19,'1.3 TCe 140','essence'),(94,19,'1.6 16V 115','essence'),
(95,19,'1.5 dCi 95','diesel'),(96,19,'1.6 dCi 130','diesel');

-- ─── MOTORISATIONS batch 2/10 (IDs 97–196) ───────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(97,19,'1.9 dCi 120','diesel'),
-- Koleos (20)
(98,20,'1.3 TCe 160','essence'),(99,20,'2.5 MPI','essence'),(100,20,'1.6 dCi 130','diesel'),(101,20,'2.0 dCi 175','diesel'),
-- Kangoo (21)
(102,21,'1.0 TCe 100','essence'),(103,21,'1.2 TCe 115','essence'),(104,21,'1.6 MPI','essence'),
(105,21,'1.5 dCi 75','diesel'),(106,21,'1.5 dCi 90','diesel'),
-- Symbol (22)
(107,22,'1.2 16V','essence'),(108,22,'1.4 MPI','essence'),(109,22,'1.6 MPI','essence'),(110,22,'1.5 dCi','diesel'),
-- Yaris (23)
(111,23,'1.0 VVTi','essence'),(112,23,'1.3 VVTi','essence'),(113,23,'1.5 VVTi','essence'),
(114,23,'1.4 D-4D','diesel'),(115,23,'1.5 Hybrid','hybride'),
-- Corolla (24)
(116,24,'1.3 VVTi','essence'),(117,24,'1.4 VVTi','essence'),(118,24,'1.6 VVTi','essence'),
(119,24,'1.8 VVTi','essence'),(120,24,'2.0 D-4D','diesel'),(121,24,'1.8 Hybrid','hybride'),
-- Camry (25)
(122,25,'2.0 4-cyl','essence'),(123,25,'2.4 VVTi','essence'),(124,25,'2.5 VVTi','essence'),
(125,25,'3.5 V6','essence'),(126,25,'2.5 Hybrid','hybride'),
-- Avensis (26)
(127,26,'1.6 VVTi','essence'),(128,26,'1.8 VVTi','essence'),(129,26,'2.0 VVTi','essence'),
(130,26,'2.0 D-4D','diesel'),(131,26,'2.2 D-4D','diesel'),
-- Auris (27)
(132,27,'1.3 VVTi','essence'),(133,27,'1.6 VVTi','essence'),(134,27,'1.4 D-4D','diesel'),
(135,27,'2.0 D-4D','diesel'),(136,27,'1.8 Hybrid','hybride'),
-- RAV4 (28)
(137,28,'2.0 VVTi','essence'),(138,28,'2.5 VVTi','essence'),(139,28,'2.0 D-4D','diesel'),
(140,28,'2.2 D-4D','diesel'),(141,28,'2.5 Hybrid','hybride'),
-- Hilux (29)
(142,29,'2.4 GD-6 D','diesel'),(143,29,'2.5 D-4D','diesel'),(144,29,'2.8 GD-6 D','diesel'),
(145,29,'3.0 KD D','diesel'),(146,29,'2.7 VVTi','essence'),
-- Land Cruiser (30)
(147,30,'3.0 KD D-4D','diesel'),(148,30,'4.2 HD-FT D','diesel'),(149,30,'4.5 V8 D-4D','diesel'),
(150,30,'4.0 1GR-FE','essence'),(151,30,'3.5 V6 Twin Turbo','essence'),
-- Prado (31)
(152,31,'2.7 VVTi','essence'),(153,31,'3.4 V6','essence'),(154,31,'4.0 V6','essence'),
(155,31,'2.8 GD-6 D','diesel'),(156,31,'3.0 KD D-4D','diesel'),
-- Fortuner (32)
(157,32,'2.4 GD-6 D','diesel'),(158,32,'2.8 GD-6 D','diesel'),(159,32,'2.7 VVTi','essence'),(160,32,'4.0 V6','essence'),
-- Verso (33)
(161,33,'1.6 VVTi','essence'),(162,33,'1.8 VVTi','essence'),(163,33,'2.0 D-4D','diesel'),(164,33,'2.2 D-4D','diesel'),
-- Polo (34)
(165,34,'1.0 MPI 65','essence'),(166,34,'1.0 TSI 95','essence'),(167,34,'1.2 TSI 90','essence'),
(168,34,'1.4 TDI 80','diesel'),(169,34,'1.6 TDI 90','diesel'),
-- Golf (35)
(170,35,'1.0 TSI 110','essence'),(171,35,'1.2 TSI 85','essence'),(172,35,'1.4 TSI 125','essence'),
(173,35,'1.5 TSI 130','essence'),(174,35,'1.6 TDI 105','diesel'),(175,35,'2.0 TDI 150','diesel'),
-- Passat (36)
(176,36,'1.4 TSI 125','essence'),(177,36,'1.5 TSI 150','essence'),(178,36,'1.8 TSI 180','essence'),
(179,36,'2.0 TSI 220','essence'),(180,36,'1.6 TDI 120','diesel'),(181,36,'2.0 TDI 150','diesel'),
-- Tiguan (37)
(182,37,'1.4 TSI 125','essence'),(183,37,'1.5 TSI 150','essence'),(184,37,'2.0 TSI 190','essence'),(185,37,'2.0 TDI 150','diesel'),
-- Touareg (38)
(186,38,'3.0 V6 TSI','essence'),(187,38,'3.6 FSI V6','essence'),(188,38,'3.0 V6 TDI','diesel'),(189,38,'4.2 V8 TDI','diesel'),
-- T-Roc (39)
(190,39,'1.0 TSI 110','essence'),(191,39,'1.5 TSI 150','essence'),(192,39,'2.0 TSI 190','essence'),
(193,39,'1.6 TDI 115','diesel'),(194,39,'2.0 TDI 150','diesel'),
-- Caddy (40)
(195,40,'1.0 TSI 102','essence'),(196,40,'1.5 TSI 114','essence');

-- ─── MOTORISATIONS batch 3/10 (IDs 197–296) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(197,40,'2.0 TDI 102','diesel'),(198,40,'2.0 TDI 122','diesel'),
-- Série 1 (41)
(199,41,'116i','essence'),(200,41,'118i','essence'),(201,41,'120i','essence'),
(202,41,'116d','diesel'),(203,41,'118d','diesel'),(204,41,'120d','diesel'),
-- Série 2 (42)
(205,42,'218i','essence'),(206,42,'220i','essence'),(207,42,'216d','diesel'),(208,42,'218d','diesel'),
-- Série 3 (43)
(209,43,'316i','essence'),(210,43,'318i','essence'),(211,43,'320i','essence'),(212,43,'325i','essence'),
(213,43,'316d','diesel'),(214,43,'318d','diesel'),(215,43,'320d','diesel'),
-- Série 5 (44)
(216,44,'520i','essence'),(217,44,'523i','essence'),(218,44,'528i','essence'),
(219,44,'518d','diesel'),(220,44,'520d','diesel'),(221,44,'525d','diesel'),(222,44,'530d','diesel'),
-- X1 (45)
(223,45,'18i','essence'),(224,45,'20i','essence'),(225,45,'16d','diesel'),(226,45,'18d','diesel'),(227,45,'20d','diesel'),
-- X3 (46)
(228,46,'20i','essence'),(229,46,'28i','essence'),(230,46,'30i','essence'),(231,46,'20d','diesel'),(232,46,'30d','diesel'),
-- X5 (47)
(233,47,'35i','essence'),(234,47,'40i','essence'),(235,47,'25d','diesel'),(236,47,'30d','diesel'),(237,47,'40d','diesel'),
-- Classe A (48)
(238,48,'A160','essence'),(239,48,'A180','essence'),(240,48,'A200','essence'),
(241,48,'A160d','diesel'),(242,48,'A180d','diesel'),(243,48,'A200d','diesel'),
-- Classe B (49)
(244,49,'B160','essence'),(245,49,'B180','essence'),(246,49,'B200','essence'),
(247,49,'B160d','diesel'),(248,49,'B180d','diesel'),(249,49,'B200d','diesel'),
-- Classe C (50)
(250,50,'C180','essence'),(251,50,'C200','essence'),(252,50,'C220','essence'),(253,50,'C250','essence'),
(254,50,'C180d','diesel'),(255,50,'C200d','diesel'),(256,50,'C220d','diesel'),
-- Classe E (51)
(257,51,'E200','essence'),(258,51,'E220','essence'),(259,51,'E250','essence'),
(260,51,'E200d','diesel'),(261,51,'E220d','diesel'),(262,51,'E250d','diesel'),
-- GLC (52)
(263,52,'200','essence'),(264,52,'250','essence'),(265,52,'300','essence'),
(266,52,'200d','diesel'),(267,52,'220d','diesel'),(268,52,'300d','diesel'),
-- Vito (53)
(269,53,'114 BT','essence'),(270,53,'116 CDI','diesel'),(271,53,'119 CDI','diesel'),(272,53,'120 CDI','diesel'),
-- Sprinter (54)
(273,54,'211 CDI','diesel'),(274,54,'213 CDI','diesel'),(275,54,'315 CDI','diesel'),(276,54,'319 CDI','diesel'),
-- C2 (55)
(277,55,'1.1i','essence'),(278,55,'1.4i','essence'),(279,55,'1.6i','essence'),(280,55,'1.4 HDi','diesel'),
-- C3 (56)
(281,56,'1.0 PureTech 68','essence'),(282,56,'1.2 PureTech 82','essence'),(283,56,'1.2 PureTech 110','essence'),
(284,56,'1.4 HDi 70','diesel'),(285,56,'1.5 BlueHDi 75','diesel'),(286,56,'1.6 BlueHDi 100','diesel'),
-- C4 (57)
(287,57,'1.2 PureTech 130','essence'),(288,57,'1.4i 90','essence'),(289,57,'1.6i 120','essence'),
(290,57,'1.6 THP 155','essence'),(291,57,'1.4 HDi 70','diesel'),(292,57,'1.6 HDi 92','diesel'),(293,57,'2.0 HDi 138','diesel'),
-- C5 (58)
(294,58,'1.8i 16V 115','essence'),(295,58,'2.0i 16V 143','essence'),
(296,58,'2.0 HDi 138','diesel');

-- ─── MOTORISATIONS batch 4/10 (IDs 297–396) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(297,58,'2.2 HDi 170','diesel'),
-- C3 Aircross (59)
(298,59,'1.0 PureTech 110','essence'),(299,59,'1.2 PureTech 110','essence'),(300,59,'1.2 PureTech 130','essence'),
(301,59,'1.5 BlueHDi 100','diesel'),(302,59,'1.6 BlueHDi 120','diesel'),
-- Berlingo (60)
(303,60,'1.2 PureTech 110','essence'),(304,60,'1.4i 75','essence'),
(305,60,'1.5 BlueHDi 100','diesel'),(306,60,'1.6 BlueHDi 75','diesel'),
-- Jumper (61)
(307,61,'2.0 BlueHDi 110','diesel'),(308,61,'2.0 BlueHDi 130','diesel'),(309,61,'2.2 HDi 100','diesel'),
(310,61,'2.2 HDi 120','diesel'),(311,61,'3.0 HDi 160','diesel'),
-- C-Elysée (62)
(312,62,'1.2 PureTech 82','essence'),(313,62,'1.6 VTi 115','essence'),(314,62,'1.6 e-HDi 92','diesel'),
-- Jazz (63)
(315,63,'1.2 i-VTEC','essence'),(316,63,'1.4 i-VTEC','essence'),(317,63,'1.5 VTEC','essence'),
(318,63,'1.3 IMA Hybrid','hybride'),(319,63,'1.5 Hybrid','hybride'),
-- Civic (64)
(320,64,'1.4 i-VTEC','essence'),(321,64,'1.6 i-VTEC','essence'),(322,64,'1.8 i-VTEC','essence'),
(323,64,'2.0 i-VTEC','essence'),(324,64,'1.6 i-DTEC','diesel'),
-- Accord (65)
(325,65,'2.0 i-VTEC','essence'),(326,65,'2.4 i-VTEC','essence'),(327,65,'3.5 V6','essence'),(328,65,'2.2 i-CTDi','diesel'),
-- CR-V (66)
(329,66,'1.5 VTEC Turbo','essence'),(330,66,'2.0 i-VTEC','essence'),(331,66,'2.4 i-VTEC','essence'),
(332,66,'1.6 i-DTEC','diesel'),(333,66,'2.0 i-MMD Hybrid','hybride'),
-- HR-V (67)
(334,67,'1.5 i-VTEC','essence'),(335,67,'1.8 i-VTEC','essence'),(336,67,'1.6 i-DTEC','diesel'),
-- BR-V (68)
(337,68,'1.5 i-VTEC','essence'),
-- Micra (69)
(338,69,'1.0 IG-T 100','essence'),(339,69,'1.2 DIG-S','essence'),(340,69,'1.2 16V','essence'),
(341,69,'1.4 16V','essence'),(342,69,'1.5 dCi 65','diesel'),
-- Juke (70)
(343,70,'1.0 DIG-T 117','essence'),(344,70,'1.2 DIG-T 115','essence'),(345,70,'1.6 DIG-T 190','essence'),
(346,70,'1.5 dCi 110','diesel'),(347,70,'1.6 dCi 130','diesel'),
-- Qashqai (71)
(348,71,'1.2 DIG-T 115','essence'),(349,71,'1.3 DIG-T 140','essence'),(350,71,'1.6 DIG-T 163','essence'),
(351,71,'1.5 dCi 110','diesel'),(352,71,'1.6 dCi 130','diesel'),
-- X-Trail (72)
(353,72,'1.3 DIG-T 158','essence'),(354,72,'1.6 DIG-T 163','essence'),(355,72,'2.0 4x4','essence'),
(356,72,'1.6 dCi 130','diesel'),(357,72,'2.0 dCi 177','diesel'),
-- Navara (73)
(358,73,'2.3 dCi 160','diesel'),(359,73,'2.3 dCi 190','diesel'),(360,73,'2.5 YD25','diesel'),(361,73,'2.5 QR25','essence'),
-- Patrol (74)
(362,74,'3.0 ZD30 D','diesel'),(363,74,'4.2 TB42 6-cyl','essence'),(364,74,'4.8 TB48 6-cyl','essence'),
-- Terrano (75)
(365,75,'2.4 TZE','essence'),(366,75,'2.7 TDi','diesel'),(367,75,'3.0 TDi','diesel'),
-- i10 (76)
(368,76,'1.0 MPi 67','essence'),(369,76,'1.0 T-GDi 100','essence'),(370,76,'1.2 MPi 84','essence'),
-- i20 (77)
(371,77,'1.0 T-GDi 100','essence'),(372,77,'1.2 MPi 84','essence'),(373,77,'1.4 MPi 100','essence'),
(374,77,'1.1 CRDi 75','diesel'),(375,77,'1.4 CRDi 90','diesel'),(376,77,'1.6 CRDi 110','diesel'),
-- i30 (78)
(377,78,'1.0 T-GDi 120','essence'),(378,78,'1.4 T-GDi 140','essence'),(379,78,'1.6 GDi 135','essence'),
(380,78,'2.0 GDi 160','essence'),(381,78,'1.4 CRDi 90','diesel'),(382,78,'1.6 CRDi 110','diesel'),
-- Accent (79)
(383,79,'1.2 MPi 84','essence'),(384,79,'1.4 MPi 100','essence'),(385,79,'1.6 MPi 123','essence'),
(386,79,'1.4 CRDi 75','diesel'),(387,79,'1.6 CRDi 115','diesel'),
-- Tucson (80)
(388,80,'1.6 GDi 132','essence'),(389,80,'1.6 T-GDi 177','essence'),(390,80,'2.0 GDi 155','essence'),
(391,80,'1.7 CRDi 115','diesel'),(392,80,'2.0 CRDi 185','diesel'),
-- Santa Fe (81)
(393,81,'2.0 MPi','essence'),(394,81,'2.4 GDi 188','essence'),
(395,81,'2.0 CRDi 150','diesel'),(396,81,'2.2 CRDi 200','diesel');

-- ─── MOTORISATIONS batch 5/10 (IDs 397–496) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
-- Creta (82)
(397,82,'1.5 MPi 114','essence'),(398,82,'1.4 T-GDi 140','essence'),(399,82,'1.5 CRDi 115','diesel'),
-- Fiesta (83)
(400,83,'1.0 EcoBoost 100','essence'),(401,83,'1.0 EcoBoost 125','essence'),(402,83,'1.1 Ti-VCT 70','essence'),
(403,83,'1.4 Ti-VCT 96','essence'),(404,83,'1.4 TDCi 70','diesel'),(405,83,'1.5 TDCi 85','diesel'),
-- Focus (84)
(406,84,'1.0 EcoBoost 100','essence'),(407,84,'1.0 EcoBoost 125','essence'),(408,84,'1.5 EcoBoost 150','essence'),
(409,84,'1.5 TDCi 95','diesel'),(410,84,'1.6 TDCi 95','diesel'),(411,84,'2.0 TDCi 150','diesel'),
-- Mondeo (85)
(412,85,'1.5 EcoBoost 160','essence'),(413,85,'2.0 EcoBoost 240','essence'),(414,85,'2.5 Duratec 220','essence'),
(415,85,'1.6 TDCi 115','diesel'),(416,85,'2.0 TDCi 150','diesel'),
-- EcoSport (86)
(417,86,'1.0 EcoBoost 125','essence'),(418,86,'1.5 Ti-VCT 112','essence'),(419,86,'1.5 TDCi 90','diesel'),
-- Kuga (87)
(420,87,'1.5 EcoBoost 150','essence'),(421,87,'2.5 PHEV 225','hybride'),
(422,87,'1.5 EcoBlue 120','diesel'),(423,87,'2.0 EcoBlue 150','diesel'),
-- Ranger (88)
(424,88,'2.0 EcoBlue 170','diesel'),(425,88,'2.2 TDCi 150','diesel'),(426,88,'3.2 TDCi 200','diesel'),(427,88,'2.5 Duratec','essence'),
-- Transit (89)
(428,89,'2.0 EcoBlue 105','diesel'),(429,89,'2.0 EcoBlue 130','diesel'),(430,89,'2.0 EcoBlue 170','diesel'),
-- Picanto (90)
(431,90,'1.0 MPi 67','essence'),(432,90,'1.0 T-GDi 100','essence'),(433,90,'1.2 DOHC 84','essence'),
-- Rio (91)
(434,91,'1.0 T-GDi 100','essence'),(435,91,'1.2 MPi 84','essence'),(436,91,'1.4 MPi 100','essence'),(437,91,'1.4 CRDi 90','diesel'),
-- Ceed (92)
(438,92,'1.0 T-GDi 120','essence'),(439,92,'1.4 T-GDi 140','essence'),(440,92,'1.5 T-GDi 160','essence'),(441,92,'1.6 CRDi 115','diesel'),
-- Sportage (93)
(442,93,'1.6 GDi 132','essence'),(443,93,'1.6 T-GDi 177','essence'),(444,93,'2.0 MPi 150','essence'),
(445,93,'1.7 CRDi 115','diesel'),(446,93,'2.0 CRDi 185','diesel'),
-- Sorento (94)
(447,94,'2.0 MPi 149','essence'),(448,94,'2.4 GDi 188','essence'),(449,94,'1.6 T-GDi Hybrid','hybride'),
(450,94,'2.0 CRDi 150','diesel'),(451,94,'2.2 CRDi 200','diesel'),
-- Mazda2 (95)
(452,95,'1.3 DOHC 84','essence'),(453,95,'1.5 SKYACTIV-G 90','essence'),(454,95,'1.4 CD Diesel','diesel'),
-- Mazda3 (96)
(455,96,'1.5 SKYACTIV-G 100','essence'),(456,96,'2.0 SKYACTIV-G 120','essence'),(457,96,'2.5 SKYACTIV-G 186','essence'),
(458,96,'1.5 SKYACTIV-D 105','diesel'),(459,96,'2.2 SKYACTIV-D 150','diesel'),
-- Mazda6 (97)
(460,97,'2.0 SKYACTIV-G 145','essence'),(461,97,'2.5 SKYACTIV-G 192','essence'),
(462,97,'2.0 SKYACTIV-D 150','diesel'),(463,97,'2.2 SKYACTIV-D 175','diesel'),
-- CX-3 (98)
(464,98,'1.5 SKYACTIV-G 105','essence'),(465,98,'2.0 SKYACTIV-G 120','essence'),(466,98,'1.5 SKYACTIV-D 105','diesel'),
-- CX-5 (99)
(467,99,'2.0 SKYACTIV-G 165','essence'),(468,99,'2.5 SKYACTIV-G 194','essence'),(469,99,'2.5 Turbo 231','essence'),
(470,99,'2.2 SKYACTIV-D 150','diesel'),(471,99,'2.2 SKYACTIV-D 184','diesel'),
-- CX-30 (100)
(472,100,'2.0 SKYACTIV-G 122','essence'),(473,100,'2.0 SKYACTIV-X 180','hybride'),(474,100,'1.8 SKYACTIV-D 116','diesel'),
-- Colt (101)
(475,101,'1.1','essence'),(476,101,'1.3 MIVEC','essence'),(477,101,'1.5 MIVEC','essence'),(478,101,'1.5 Di-D','diesel'),
-- Lancer (102)
(479,102,'1.3 MIVEC','essence'),(480,102,'1.5 MIVEC','essence'),(481,102,'1.8 MIVEC','essence'),
(482,102,'2.0 Turbo 280','essence'),(483,102,'2.0 DI-D','diesel'),
-- Outlander (103)
(484,103,'2.0 MIVEC 145','essence'),(485,103,'2.4 MIVEC 170','essence'),(486,103,'3.0 V6','essence'),
(487,103,'2.0 DI-D 140','diesel'),(488,103,'2.2 DI-D 150','diesel'),(489,103,'2.4 PHEV','hybride'),
-- ASX (104)
(490,104,'1.6 MIVEC 115','essence'),(491,104,'2.0 MIVEC 150','essence'),
(492,104,'1.6 DI-D 115','diesel'),(493,104,'2.2 DI-D 150','diesel'),
-- L200 (105)
(494,105,'2.4 MIVEC 4N15 D','diesel'),(495,105,'2.5 4D56 D','diesel'),(496,105,'3.2 DI-D 160','diesel');

-- ─── MOTORISATIONS batch 6/10 (IDs 497–596) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(497,105,'2.5 4D65','essence'),
-- Pajero (106)
(498,106,'3.2 DI-D V6','diesel'),(499,106,'3.5 V6 SOHC','essence'),(500,106,'3.8 V6 SOHC','essence'),(501,106,'4.0 V6','essence'),
-- Eclipse Cross (107)
(502,107,'1.5 MIVEC Turbo 163','essence'),(503,107,'2.4 PHEV','hybride'),
-- Alto (108)
(504,108,'0.8','essence'),(505,108,'1.0','essence'),(506,108,'1.1','essence'),
-- Swift (109)
(507,109,'1.0 Boosterjet 111','essence'),(508,109,'1.2 DUALJET 90','essence'),(509,109,'1.3 VVT 94','essence'),
(510,109,'1.4 MHEV 129','hybride'),(511,109,'1.3 DDiS 75','diesel'),
-- S-Cross (110)
(512,110,'1.0 Boosterjet 112','essence'),(513,110,'1.4 Boosterjet 140','essence'),
(514,110,'1.4 Mild Hybrid 129','hybride'),(515,110,'1.6 DDiS 120','diesel'),
-- Vitara (111)
(516,111,'1.0 Boosterjet 112','essence'),(517,111,'1.4 Boosterjet 140','essence'),(518,111,'1.6 VVT 120','essence'),
(519,111,'1.5 Hybrid 140','hybride'),(520,111,'1.6 DDiS 120','diesel'),
-- Grand Vitara (112)
(521,112,'1.6 VVT 106','essence'),(522,112,'2.0 VVT 140','essence'),(523,112,'2.4 VVT 163','essence'),
(524,112,'1.9 DDiS 129','diesel'),(525,112,'2.4 DDiS','diesel'),
-- Jimny (113)
(526,113,'1.0','essence'),(527,113,'1.3 VVT 85','essence'),(528,113,'1.5 K15B 102','essence'),
-- Logan Dacia (114)
(529,114,'0.9 TCe 90','essence'),(530,114,'1.0 SCe 75','essence'),(531,114,'1.6 MPI 82','essence'),(532,114,'1.5 dCi 90','diesel'),
-- Sandero Dacia (115)
(533,115,'1.0 SCe 75','essence'),(534,115,'0.9 TCe 90','essence'),(535,115,'1.0 TCe 100','essence'),
(536,115,'1.5 dCi 75','diesel'),(537,115,'1.5 dCi 95','diesel'),
-- Duster Dacia (116)
(538,116,'0.9 TCe 90','essence'),(539,116,'1.0 TCe 90','essence'),(540,116,'1.3 TCe 130','essence'),
(541,116,'1.5 dCi 90','diesel'),(542,116,'1.5 dCi 110','diesel'),
-- Lodgy (117)
(543,117,'0.9 TCe 90','essence'),(544,117,'1.2 TCe 115','essence'),
(545,117,'1.5 dCi 90','diesel'),(546,117,'1.5 dCi 110','diesel'),
-- Dokker (118)
(547,118,'1.0 TCe 100','essence'),(548,118,'1.2 TCe 115','essence'),
(549,118,'1.5 dCi 75','diesel'),(550,118,'1.5 dCi 90','diesel'),
-- Spring (119)
(551,119,'33 kW Electric','electrique'),
-- Corsa Opel (120)
(552,120,'1.0 SIDI Turbo 115','essence'),(553,120,'1.2 Turbo 100','essence'),(554,120,'1.4 Turbo 150','essence'),
(555,120,'1.6 Turbo 207','essence'),(556,120,'1.0 CDTI 75','diesel'),(557,120,'1.3 CDTI 95','diesel'),
-- Astra (121)
(558,121,'1.0 Turbo 105','essence'),(559,121,'1.2 Turbo 130','essence'),(560,121,'1.4 Turbo 150','essence'),
(561,121,'1.6 Turbo 200','essence'),(562,121,'1.5 CDTI 105','diesel'),(563,121,'1.6 CDTI 136','diesel'),
-- Insignia (122)
(564,122,'1.5 Turbo 140','essence'),(565,122,'2.0 Turbo 260','essence'),
(566,122,'1.6 CDTI 110','diesel'),(567,122,'2.0 CDTI 170','diesel'),
-- Mokka (123)
(568,123,'1.0 Turbo 115','essence'),(569,123,'1.2 Turbo 130','essence'),(570,123,'1.4 Turbo 140','essence'),(571,123,'1.6 CDTI 136','diesel'),
-- Crossland (124)
(572,124,'1.0 Turbo 110','essence'),(573,124,'1.2 Turbo 130','essence'),(574,124,'1.5 BlueHDi 110','diesel'),
-- Zafira (125)
(575,125,'1.4 Turbo 140','essence'),(576,125,'1.6 Turbo 180','essence'),(577,125,'2.0 Turbo 200','essence'),
(578,125,'1.6 CDTI 136','diesel'),(579,125,'2.0 CDTI 130','diesel'),
-- Panda (126)
(580,126,'0.9 TwinAir 85','essence'),(581,126,'1.0 Hybrid 70','hybride'),(582,126,'1.2 8V 69','essence'),(583,126,'1.3 Multijet 75','diesel'),
-- Punto (127)
(584,127,'1.2 8V 69','essence'),(585,127,'1.4 8V 77','essence'),(586,127,'1.4 16V 95','essence'),(587,127,'1.3 Multijet 75','diesel'),
-- 500 (128)
(588,128,'0.9 TwinAir 85','essence'),(589,128,'1.0 Hybrid 70','hybride'),(590,128,'1.2 8V 69','essence'),
(591,128,'1.4 8V 100','essence'),(592,128,'1.3 Multijet 75','diesel'),
-- Bravo (129)
(593,129,'1.4 T-Jet 150','essence'),(594,129,'1.6 16V 103','essence'),(595,129,'1.6 Multijet 105','diesel'),
(596,129,'1.9 Multijet 120','diesel');

-- ─── MOTORISATIONS batch 7/10 (IDs 597–696) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(597,129,'2.0 Multijet 165','diesel'),
-- Doblò (130)
(598,130,'1.4 8V 95','essence'),(599,130,'1.6 Multijet 105','diesel'),(600,130,'2.0 Multijet 135','diesel'),
-- Ducato (131)
(601,131,'2.0 Multijet 115','diesel'),(602,131,'2.2 Multijet 140','diesel'),
(603,131,'2.3 Multijet 130','diesel'),(604,131,'3.0 Multijet 160','diesel'),
-- A1 (132)
(605,132,'1.0 TFSI 95','essence'),(606,132,'1.2 TFSI 86','essence'),(607,132,'1.4 TFSI 125','essence'),
(608,132,'1.8 TFSI 192','essence'),(609,132,'1.6 TDI 116','diesel'),
-- A3 (133)
(610,133,'1.0 TFSI 116','essence'),(611,133,'1.2 TFSI 105','essence'),(612,133,'1.4 TFSI 125','essence'),
(613,133,'1.5 TFSI 150','essence'),(614,133,'1.6 TDI 116','diesel'),(615,133,'2.0 TDI 150','diesel'),
-- A4 (134)
(616,134,'1.4 TFSI 150','essence'),(617,134,'2.0 TFSI 190','essence'),(618,134,'2.0 TFSI 245','essence'),
(619,134,'3.0 TFSI V6','essence'),(620,134,'2.0 TDI 150','diesel'),(621,134,'3.0 TDI 218','diesel'),
-- A6 (135)
(622,135,'2.0 TFSI 190','essence'),(623,135,'3.0 TFSI V6 340','essence'),
(624,135,'2.0 TDI 150','diesel'),(625,135,'2.7 TDI 190','diesel'),(626,135,'3.0 TDI 218','diesel'),
-- Q3 (136)
(627,136,'1.4 TFSI 150','essence'),(628,136,'2.0 TFSI 220','essence'),
(629,136,'1.6 TDI 116','diesel'),(630,136,'2.0 TDI 150','diesel'),
-- Q5 (137)
(631,137,'2.0 TFSI 190','essence'),(632,137,'2.0 TFSI 252','essence'),(633,137,'3.0 TFSI V6 354','essence'),
(634,137,'2.0 TDI 163','diesel'),(635,137,'3.0 TDI 286','diesel'),
-- Freelander (138)
(636,138,'1.8 i4 117','essence'),(637,138,'2.0 Si4 240','essence'),
(638,138,'2.0 Td4 150','diesel'),(639,138,'2.2 Td4 190','diesel'),
-- Discovery Sport (139)
(640,139,'2.0 Si4 290','essence'),(641,139,'1.5 P300e','hybride'),
(642,139,'2.0 D180','diesel'),(643,139,'2.0 D200','diesel'),
-- Discovery (140)
(644,140,'2.0 Si4 300','essence'),(645,140,'3.0 V6 340','essence'),
(646,140,'2.0 Sd4 240','diesel'),(647,140,'3.0 Td6 258','diesel'),
-- Defender (141)
(648,141,'2.0 P300','essence'),(649,141,'3.0 P400','essence'),(650,141,'5.0 V8 525','essence'),
(651,141,'2.0 D200','diesel'),(652,141,'3.0 D300','diesel'),
-- Range Rover Sport (142)
(653,142,'2.0 P300','essence'),(654,142,'3.0 P400','essence'),(655,142,'5.0 V8 Supercharged','essence'),
(656,142,'2.0 D200','diesel'),(657,142,'3.0 D350','diesel'),
-- Range Rover (143)
(658,143,'3.0 P400','essence'),(659,143,'4.4 P530 V8','essence'),(660,143,'5.0 V8 Supercharged','essence'),
(661,143,'3.0 D300','diesel'),(662,143,'4.4 D350 V8','diesel'),
-- BYD Dolphin (144)
(663,144,'70 kW EV','electrique'),(664,144,'130 kW EV','electrique'),
-- BYD Atto 3 (145)
(665,145,'150 kW EV','electrique'),(666,145,'204 kW AWD EV','electrique'),
-- BYD Seal (146)
(667,146,'150 kW EV','electrique'),(668,146,'230 kW AWD EV','electrique'),
-- BYD Han (147)
(669,147,'197 kW EV','electrique'),(670,147,'320 kW AWD EV','electrique'),(671,147,'1.5T DM-i','hybride'),
-- BYD Tang (148)
(672,148,'180 kW EV','electrique'),(673,148,'320 kW AWD EV','electrique'),(674,148,'1.5T DM-i','hybride'),
-- BYD Song Plus (149)
(675,149,'132 kW EV','electrique'),(676,149,'1.5T DM-i','hybride'),
-- BYD F3 (150)
(677,150,'1.5','essence'),(678,150,'1.6','essence'),
-- Chery QQ (151)
(679,151,'0.8','essence'),(680,151,'1.1','essence'),
-- Chery Arrizo 5 (152)
(681,152,'1.5 CVT','essence'),(682,152,'1.5T 147ch','essence'),
-- Chery Arrizo 6 (153)
(683,153,'1.5T 147ch','essence'),
-- Chery Tiggo 4 (154)
(684,154,'1.6 CVT','essence'),(685,154,'1.5T 147ch','essence'),
-- Chery Tiggo 7 (155)
(686,155,'1.5T 156ch','essence'),(687,155,'2.0T 197ch','essence'),
-- Chery Tiggo 8 (156)
(688,156,'1.5T 147ch','essence'),(689,156,'2.0T 197ch','essence'),(690,156,'1.5T PHEV','hybride'),
-- Geely Emgrand (157)
(691,157,'1.5 102ch','essence'),(692,157,'1.5T 177ch','essence'),
-- Geely Atlas (158)
(693,158,'1.8T 181ch','essence'),(694,158,'2.4 150ch','essence'),
-- Geely Coolray (159)
(695,159,'1.5T 150ch','essence'),
-- Geely Azkarra (160)
(696,160,'2.0T 218ch','essence');

-- ─── MOTORISATIONS batch 8/10 (IDs 697–796) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(697,160,'2.0T PHEV','hybride'),
-- Geely Monjaro (161)
(698,161,'2.0T 218ch','essence'),(699,161,'2.0T PHEV','hybride'),
-- BAIC Senova D20 (162)
(700,162,'1.3','essence'),(701,162,'1.5','essence'),
-- BAIC Senova X35 (163)
(702,163,'1.3T 130ch','essence'),
-- BAIC X55 (164)
(703,164,'1.5T 150ch','essence'),(704,164,'1.5T 177ch','essence'),
-- BAIC BJ40 (165)
(705,165,'2.0T 204ch','essence'),(706,165,'2.4 Diesel','diesel'),
-- BAIC BJ80 (166)
(707,166,'3.0T V6','essence'),(708,166,'2.0T Diesel','diesel'),
-- Changan Eado (167)
(709,167,'1.4T 126ch','essence'),(710,167,'1.6 110ch','essence'),
-- Changan CS35 (168)
(711,168,'1.5 109ch','essence'),(712,168,'1.6 114ch','essence'),
-- Changan CS55 (169)
(713,169,'1.4T 156ch','essence'),(714,169,'1.5T 177ch','essence'),
-- Changan CS75 (170)
(715,170,'1.5T 156ch','essence'),(716,170,'2.0T 197ch','essence'),(717,170,'1.5T PHEV','hybride'),
-- Changan CS85 (171)
(718,171,'2.0T 254ch','essence'),
-- Changan Lumin (172)
(719,172,'20 kW EV','electrique'),(720,172,'30 kW EV','electrique'),
-- Haval H1 (173)
(721,173,'1.5 107ch','essence'),
-- Haval H2 (174)
(722,174,'1.5T 150ch','essence'),
-- Haval H4 (175)
(723,175,'1.5T 150ch','essence'),
-- Haval H6 (176)
(724,176,'1.5T 150ch','essence'),(725,176,'2.0T 197ch','essence'),(726,176,'1.5T PHEV','hybride'),
-- Haval H9 (177)
(727,177,'2.0T 230ch','essence'),(728,177,'3.0T V6','essence'),
-- Haval Jolion (178)
(729,178,'1.5T 150ch','essence'),(730,178,'1.5T HEV','hybride'),
-- Haval Big Dog (179)
(731,179,'2.0T 190ch','essence'),
-- MG3 (180)
(732,180,'1.5 VTi 106ch','essence'),
-- MG5 EV (181)
(733,181,'180 kW EV','electrique'),(734,181,'115 kW EV','electrique'),
-- MG6 (182)
(735,182,'1.5T 166ch','essence'),(736,182,'1.8T 218ch','essence'),
-- MG ZS (183)
(737,183,'1.0T 111ch','essence'),(738,183,'1.5 106ch','essence'),(739,183,'44.5 kWh EV','electrique'),
-- MG RX5 (184)
(740,184,'1.5T 166ch','essence'),(741,184,'2.0T 224ch','essence'),
-- MG HS (185)
(742,185,'1.5T 162ch','essence'),(743,185,'2.0T 224ch','essence'),
-- Dongfeng AX7 (186)
(744,186,'2.0T 197ch','essence'),
-- Dongfeng A60 (187)
(745,187,'1.6 115ch','essence'),(746,187,'1.8 133ch','essence'),
-- Dongfeng Fengon 580 (188)
(747,188,'1.8T Diesel 130ch','diesel'),
-- Dongfeng SX6 (189)
(748,189,'1.5T 115ch','essence'),
-- Dongfeng Rich 6 (190)
(749,190,'2.0T Diesel 140ch','diesel'),
-- JAC J7 (191)
(750,191,'1.5T 177ch','essence'),
-- JAC S3 (192)
(751,192,'1.5 110ch','essence'),
-- JAC S4 Pro (193)
(752,193,'1.5T 156ch','essence'),
-- JAC T8 Pro (194)
(753,194,'2.0T Diesel 150ch','diesel'),
-- JAC E10X (195)
(754,195,'38 kW EV','electrique'),
-- Wuling Mini EV (196)
(755,196,'17 kW EV','electrique'),(756,196,'30 kW EV','electrique'),
-- Wuling Baojun 310 (197)
(757,197,'1.2 90ch','essence'),
-- Wuling Almaz (198)
(758,198,'1.5T 140ch','essence'),
-- SAIC Roewe 350 (199)
(759,199,'1.5 CVT 100ch','essence'),
-- SAIC Roewe 550 (200)
(760,200,'1.8T 140ch','essence'),(761,200,'2.0T 160ch','essence'),
-- SAIC Roewe 750 (201)
(762,201,'2.0T 180ch','essence'),
-- Great Wall Wingle 5 (202)
(763,202,'2.4 143ch','essence'),(764,202,'2.0T Diesel 120ch','diesel'),
-- Great Wall Wingle 7 (203)
(765,203,'2.0T 218ch','essence'),(766,203,'2.0T Diesel 150ch','diesel'),
-- Great Wall Pao (204)
(767,204,'2.0T 218ch','essence'),(768,204,'3.0T Diesel 180ch','diesel'),
-- Foton Tunland (205)
(769,205,'2.4 Diesel 120ch','diesel'),(770,205,'2.0T Diesel 136ch','diesel'),
-- Foton View C2 (206)
(771,206,'2.8 Diesel 82ch','diesel'),
-- Foton Sauvana (207)
(772,207,'2.4T Diesel 136ch','diesel'),
-- DFSK Glory 500 (208)
(773,208,'1.5T 109ch','essence'),
-- DFSK Glory 580 (209)
(774,209,'1.5T 109ch','essence'),
-- DFSK K01H (210)
(775,210,'1.2 70ch','essence'),
-- Lifan X60 (211)
(776,211,'1.8 132ch','essence'),(777,211,'1.8T 140ch','essence'),
-- Lifan X70 (212)
(778,212,'1.8T 136ch','essence'),
-- Lifan 820 (213)
(779,213,'1.8T 140ch','essence'),
-- Zotye T300 (214)
(780,214,'1.5T 140ch','essence'),
-- Zotye T600 (215)
(781,215,'1.5T 140ch','essence'),(782,215,'2.0T 170ch','essence'),
-- Volvo S60 (216)
(783,216,'2.0 T4 190ch','essence'),(784,216,'2.0 T5 254ch','essence'),
(785,216,'2.0 D4','diesel'),(786,216,'T8 Twin Engine','hybride'),
-- Volvo S90 (217)
(787,217,'2.0 T5 250ch','essence'),(788,217,'2.0 T6 320ch','essence'),
(789,217,'2.0 D4 190ch','diesel'),(790,217,'T8 Twin Engine','hybride'),
-- Volvo V40 (218)
(791,218,'1.5 T2 120ch','essence'),(792,218,'2.0 T4 190ch','essence'),
(793,218,'1.6 D2 115ch','diesel'),(794,218,'2.0 D4 190ch','diesel'),
-- Volvo V60 (219)
(795,219,'2.0 T4 190ch','essence'),(796,219,'2.0 T5 254ch','essence');

-- ─── MOTORISATIONS batch 9/10 (IDs 797–896) ──────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(797,219,'2.0 D4 190ch','diesel'),(798,219,'T8 Twin Engine','hybride'),
-- Volvo XC40 (220)
(799,220,'1.5 T3 163ch','essence'),(800,220,'2.0 T4 190ch','essence'),
(801,220,'2.0 D4 190ch','diesel'),(802,220,'Recharge EV','electrique'),
-- Volvo XC60 (221)
(803,221,'2.0 T4 190ch','essence'),(804,221,'2.0 T5 250ch','essence'),
(805,221,'2.0 D4 190ch','diesel'),(806,221,'T8 Twin Engine','hybride'),
-- Volvo XC90 (222)
(807,222,'2.0 T5 250ch','essence'),(808,222,'2.0 T6 320ch','essence'),
(809,222,'2.0 D5 225ch','diesel'),(810,222,'T8 Twin Engine','hybride'),
-- Jeep Renegade (223)
(811,223,'1.0 T3 120ch','essence'),(812,223,'1.3 T4 150ch','essence'),(813,223,'1.6 Multijet','diesel'),
-- Jeep Compass (224)
(814,224,'1.3 T4 150ch','essence'),(815,224,'2.0 Multijet 140ch','diesel'),
-- Jeep Cherokee (225)
(816,225,'2.4 Tigershark 184ch','essence'),(817,225,'3.2 V6 271ch','essence'),(818,225,'2.0 Multijet 140ch','diesel'),
-- Jeep Grand Cherokee (226)
(819,226,'3.6 V6 286ch','essence'),(820,226,'6.4 V8 468ch','essence'),
(821,226,'3.0 EcoDiesel','diesel'),(822,226,'4xe PHEV','hybride'),
-- Jeep Wrangler (227)
(823,227,'2.0 Turbo 272ch','essence'),(824,227,'3.6 V6 280ch','essence'),(825,227,'3.6 4xe PHEV','hybride'),
-- Subaru Impreza (228)
(826,228,'1.6i 114ch','essence'),(827,228,'2.0i 156ch','essence'),(828,228,'2.0D','diesel'),
-- Subaru Legacy (229)
(829,229,'2.0i 156ch','essence'),(830,229,'2.5i 175ch','essence'),
-- Subaru Forester (230)
(831,230,'2.0i 150ch','essence'),(832,230,'2.0XT 240ch','essence'),(833,230,'e-Boxer 145ch','hybride'),
-- Subaru Outback (231)
(834,231,'2.5i 175ch','essence'),(835,231,'e-Boxer 150ch','hybride'),
-- Subaru XV (232)
(836,232,'2.0i 150ch','essence'),(837,232,'e-Boxer 145ch','hybride'),
-- Skoda Fabia (233)
(838,233,'1.0 MPI 75ch','essence'),(839,233,'1.0 TSI 95ch','essence'),
(840,233,'1.0 TSI 110ch','essence'),(841,233,'1.4 TDI 90ch','diesel'),
-- Skoda Octavia (234)
(842,234,'1.0 TSI 116ch','essence'),(843,234,'1.5 TSI 150ch','essence'),(844,234,'2.0 TSI 190ch','essence'),
(845,234,'2.0 TDI 150ch','diesel'),(846,234,'2.0 TDI 190ch','diesel'),
-- Skoda Superb (235)
(847,235,'1.5 TSI 150ch','essence'),(848,235,'2.0 TSI 272ch','essence'),
(849,235,'2.0 TDI 150ch','diesel'),(850,235,'2.0 TDI 190ch','diesel'),
-- Skoda Karoq (236)
(851,236,'1.0 TSI 115ch','essence'),(852,236,'1.5 TSI 150ch','essence'),
(853,236,'1.6 TDI 115ch','diesel'),(854,236,'2.0 TDI 150ch','diesel'),
-- Skoda Kodiaq (237)
(855,237,'1.5 TSI 150ch','essence'),(856,237,'2.0 TSI 180ch','essence'),
(857,237,'2.0 TDI 150ch','diesel'),(858,237,'2.0 TDI 190ch','diesel'),
-- Isuzu D-Max (238)
(859,238,'1.9 Ddi 163ch','diesel'),(860,238,'3.0 Di-D 130ch','diesel'),
(861,238,'2.5 TD','diesel'),(862,238,'2.7 VVTi','essence'),
-- Isuzu MU-X (239)
(863,239,'1.9 Ddi 163ch','diesel'),(864,239,'3.0 V6','diesel'),
-- Isuzu TFR (240)
(865,240,'2.0','essence'),(866,240,'2.5 D','diesel'),
-- Isuzu NPR (241)
(867,241,'3.9 Diesel','diesel'),(868,241,'4.3 Diesel','diesel'),(869,241,'5.2 Diesel','diesel'),
-- Isuzu Trooper (242)
(870,242,'3.1 TD','diesel'),(871,242,'3.5 V6','essence'),
-- Lexus IS (243)
(872,243,'IS 250 2.5 V6','essence'),(873,243,'IS 300 2.0T','essence'),
(874,243,'IS 350 3.5 V6','essence'),(875,243,'IS 300h Hybrid','hybride'),
-- Lexus ES (244)
(876,244,'ES 250 2.5','essence'),(877,244,'ES 300h Hybrid','hybride'),
-- Lexus GS (245)
(878,245,'GS 300 3.0','essence'),(879,245,'GS 350 3.5','essence'),(880,245,'GS 450h Hybrid','hybride'),
-- Lexus UX (246)
(881,246,'UX 250h Hybrid','hybride'),(882,246,'UX 300e EV','electrique'),
-- Lexus NX (247)
(883,247,'NX 300 2.0T','essence'),(884,247,'NX 300h Hybrid','hybride'),(885,247,'NX 350h Hybrid','hybride'),
-- Lexus RX (248)
(886,248,'RX 300 2.0T','essence'),(887,248,'RX 350 3.5','essence'),(888,248,'RX 450h Hybrid','hybride'),
-- Lexus GX (249)
(889,249,'GX 400 4.0 V6','essence'),(890,249,'GX 460 4.6 V8','essence'),
-- Chevrolet Spark (250)
(891,250,'1.0','essence'),(892,250,'1.2','essence'),
-- Chevrolet Aveo (251)
(893,251,'1.2','essence'),(894,251,'1.4','essence'),(895,251,'1.6','essence'),
-- Chevrolet Cruze (252)
(896,252,'1.4 Turbo 140ch','essence');

-- ─── MOTORISATIONS batch 10/10 (IDs 897–960) ─────────────────────────────────

INSERT IGNORE INTO `babi_motorisations` (`id`, `modele_id`, `nom`, `carburant`) VALUES
(897,252,'1.6 113ch','essence'),(898,252,'1.7 CDTi 130ch','diesel'),
-- Chevrolet Malibu (253)
(899,253,'1.5 Turbo 163ch','essence'),(900,253,'2.0 Turbo 252ch','essence'),(901,253,'1.6 D 136ch','diesel'),
-- Chevrolet Captiva (254)
(902,254,'2.4 140ch','essence'),(903,254,'3.2 V6 230ch','essence'),(904,254,'2.0 CDTi 150ch','diesel'),
-- Chevrolet TrailBlazer (255)
(905,255,'2.5 TD 180ch','diesel'),(906,255,'2.8 TD 200ch','diesel'),(907,255,'3.6 V6 286ch','essence'),
-- Seat Ibiza (256)
(908,256,'1.0 MPI 75ch','essence'),(909,256,'1.0 TSI 95ch','essence'),
(910,256,'1.5 TSI 150ch','essence'),(911,256,'1.6 TDI 95ch','diesel'),
-- Seat León (257)
(912,257,'1.0 TSI 110ch','essence'),(913,257,'1.5 TSI 150ch','essence'),(914,257,'2.0 TSI 300ch','essence'),
(915,257,'1.6 TDI 115ch','diesel'),(916,257,'2.0 TDI 150ch','diesel'),
-- Seat Arona (258)
(917,258,'1.0 TSI 95ch','essence'),(918,258,'1.0 TSI 115ch','essence'),(919,258,'1.5 TSI 150ch','essence'),(920,258,'1.6 TDI 95ch','diesel'),
-- Seat Ateca (259)
(921,259,'1.0 TSI 115ch','essence'),(922,259,'1.5 TSI 150ch','essence'),(923,259,'2.0 TSI 190ch','essence'),
(924,259,'1.6 TDI 115ch','diesel'),(925,259,'2.0 TDI 150ch','diesel'),
-- Alfa Romeo Giulietta (260)
(926,260,'1.4 TB 120ch','essence'),(927,260,'1.4 TB 170ch','essence'),
(928,260,'1.6 JTDm 105ch','diesel'),(929,260,'2.0 JTDm 150ch','diesel'),
-- Alfa Romeo Giulia (261)
(930,261,'2.0 Turbo 200ch','essence'),(931,261,'2.0 Turbo 280ch','essence'),(932,261,'2.9 Bi-Turbo 510ch','essence'),
(933,261,'2.2 JTDm 160ch','diesel'),(934,261,'2.2 JTDm 190ch','diesel'),
-- Alfa Romeo Stelvio (262)
(935,262,'2.0 Turbo 200ch','essence'),(936,262,'2.0 Turbo 280ch','essence'),(937,262,'2.9 Bi-Turbo 510ch','essence'),
(938,262,'2.2 JTDm 160ch','diesel'),(939,262,'2.2 JTDm 190ch','diesel'),
-- Porsche Cayenne (263)
(940,263,'3.0 V6 340ch','essence'),(941,263,'3.0 V6 Turbo 440ch','essence'),
(942,263,'4.0 V8 Turbo 680ch','essence'),(943,263,'3.0 Hybrid','hybride'),
-- Porsche Macan (264)
(944,264,'2.0 245ch','essence'),(945,264,'2.0 265ch','essence'),
(946,264,'3.0 S 354ch','essence'),(947,264,'3.0 GTS 380ch','essence'),
-- Porsche 911 (265)
(948,265,'3.0 Carrera 379ch','essence'),(949,265,'3.0 Carrera S 450ch','essence'),
(950,265,'3.8 Turbo 580ch','essence'),(951,265,'3.8 Turbo S 650ch','essence'),
-- Infiniti Q50 (266)
(952,266,'2.0t 211ch','essence'),(953,266,'3.0t 405ch','essence'),(954,266,'2.2d 170ch','diesel'),
-- Infiniti QX60 (267)
(955,267,'2.5T Hybrid','hybride'),(956,267,'3.5 V6 295ch','essence'),
-- Acura MDX (268)
(957,268,'3.5 V6 290ch','essence'),(958,268,'3.0T PHEV','hybride'),
-- Acura RDX (269)
(959,269,'2.0T 272ch','essence'),(960,269,'3.5 V6 279ch','essence');

SET FOREIGN_KEY_CHECKS = 1;
