migrations/Version20220623090625.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  9. use Symfony\Component\Finder\Finder;
  11. /**
  12.  * Auto-generated Migration: Please modify to your needs!
  13.  */
  14. final class Version20220623090625 extends AbstractMigration
  15. {
  16.     public function getDescription(): string
  17.     {
  18.         return 'import basic protocol data';
  19.     }
  21.     public function up(Schema $schema): void
  22.     {
  23.         // this up() migration is auto-generated, please modify it to your needs
  24.         $this->abortIf(
  25.             !$this->connection->getDatabasePlatform() instanceof \Doctrine\DBAL\Platforms\MySQL80Platform,
  26.             "Migration can only be executed safely on '\Doctrine\DBAL\Platforms\MySQL80Platform'."
  27.         );
  29.         //$this->addSql(file_get_contents(__DIR__ . '/protocol.sql'));
  30.         $this->addSql("SET FOREIGN_KEY_CHECKS = 0;");
  32.         $this->addSql("INSERT INTO protocol_info (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('000363c7-f8b7-49d8-ad79-57d38c231286','153','','114','','155','Diesel','','Bosch','EDC16C39','ECM','','2020-05-21 20:17:13','2020-05-21 20:17:13',1,0,'0a30aa485edd57e35cfe-MJgTvBiHUqVLzXYV7eUNWO1EUIov6WgrLs2NINMA3oUEhrNiugRdx442Zuo','bc1a7a20-e97d-406f-996d-21e3dcd94b61','1e98cfc9-745f-4a22-af07-95b6124c58cb','a831165e-a0d0-4430-b09d-277b9673b945','680b7a96-634f-4f19-a6ca-4ef5a5992d62');");
  33.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('000d1cf2-865f-43ec-897f-1f13decca9ac','94','210','70','1493','95','Diesel','Euro 4','Bosch','EDC16C33','ECM','','2020-05-21 20:25:24','2020-05-21 20:25:24',1,0,'ff80da0fd9b0a608f39b-imlUo0ptDjVd5uR9jtAgAHh04i3jvryWxgXGFIJAxRms03YoUruYzNg3IHJ','bc1a7a20-e97d-406f-996d-21e3dcd94b61','7356bcd8-9154-479c-8caa-4011e3240610','4b39f8c2-f704-492f-b1c2-f2aa8fdd4991','74b68d14-17ca-4943-80d1-c6ed26850a10');
  34. ");
  35.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('0024b47b-30ae-448f-b6a8-8c7fd98a317a','161','350','120','2461','163','Diesel','','Bosch','EDC16U1','ECM','','2020-05-21 20:26:28','2020-05-21 20:26:28',1,0,'db7dc9812a49719e069c-4z2M3OG0eHcQlqg0wZFiShUI710a7wKmE7oYYe2gY6z3ZOnJcKhULKurbRp','bc1a7a20-e97d-406f-996d-21e3dcd94b61','67eda378-abad-46b0-9817-e3d032ff23f0','01a3cf8d-2fbf-4d2e-a0b9-78d941083584','36c98722-d56d-4339-9fd0-665b49941066');
  36. ");
  37.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('002a4c36-a4ee-4fda-9a6b-b32f79ed8506','161','340','120','2400','163','Diesel','Euro 4','Bosch','EDC16C31','ECM','MPC561','2020-05-21 20:27:52','2020-05-21 20:27:52',1,0,'45f4a95d6fe6620f5811-wkS81qjSY4EtWYNRAwX4OHny3rFIDG1aj2TOrVU5sWvoKUJKuGoaPN8dBqO','bc1a7a20-e97d-406f-996d-21e3dcd94b61','948c5ad9-5856-43f4-a316-f7f5b5cf26e4','478c6be2-4ec1-452d-961b-51ebefda4c3b','12dfbbbd-4be1-45be-b5b6-44b0f94cf89e');
  38. ");
  39.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('0042c2b9-ddcc-433b-96f8-2c57d44a7ec7','174','','130','','177','Diesel','','Bosch','EDC16CP31','ECM','','2020-05-21 20:19:57','2020-05-21 20:19:57',1,0,'11739cf53a3a9ad5a4c1-BBLM3tyx8i2SXoYfA8bhldTzcIgsKGaQyGqRRIDUJNXGCPKTi6D6sApMWoT','bc1a7a20-e97d-406f-996d-21e3dcd94b61','889ebb26-e51a-43d9-a8bc-bdc0dd5332fc','780b2e4a-25d5-4af8-a0b2-650c3637f08f','371222c9-3cbe-4b8c-851b-530a43351619');
  40. ");
  41.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('004a4a21-00f7-4a66-afb3-a0c4cf437520','208','540','155','2987','211','Diesel','','Bosch','EDC16CP36','ECM','','2020-05-21 20:21:16','2020-05-21 20:21:16',1,0,'b81a575b9a8b59622400-iFcyTAvvPfJqlQzXzEgn9dS0Zf8SITGWPfeSsjDRj3L36qdOOsIv7pPMraU','bc1a7a20-e97d-406f-996d-21e3dcd94b61','7b7e55f5-15ec-44fd-a07b-36c06d690182','a19bd6c9-a55a-47cb-a856-7eea56034a45','e6fab8a0-3462-4207-b224-3bbaccfa4db5');
  42. ");
  43.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('004d6dd9-0ba4-46ca-860c-a5098d4c30d8','138','','103','','140','Diesel','','Bosch','EDC16C39','ECM','','2020-05-21 20:20:03','2020-05-21 20:20:03',1,0,'2f1eabe9eb3f3dcdd524-umSBctb0FUuJKJdniRfOrbUopol6NK5MTIWOYr2gJ0dnu1cwIfZLi9APskn','bc1a7a20-e97d-406f-996d-21e3dcd94b61','2ee430ba-a62d-4de0-89c0-67fb563bfd88','d3715bc8-89c5-4c63-9007-f3ed14e129a2','21f9f6b6-5695-41af-be8a-5a01638a2e79');
  44. ");
  45.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('004eb381-1fb7-49ae-b26c-c62d5bf51dea','89','215','66','1560','90','Diesel','','Bosch','EDC16C3','ECM','','2020-05-21 20:18:20','2020-05-21 20:18:20',1,0,'4c3222b42180d8bef586-4KfJC7TJO9evjfSL4GD2h7gWdKEK50POPmjruHBMk4PlORGOrjmvtlCra4z','bc1a7a20-e97d-406f-996d-21e3dcd94b61','6e4fa7ad-fe15-437b-80e2-9be7c8a4f77d','73a69361-50e4-400b-a93b-44fe3611487e','8861960c-c569-4a44-811a-7ff04fc16dfb');
  46. ");
  47.         $this->addSql("INSERT INTO `protocol_info` (`id`,`horse_power`,`newton_meters`,`kilo_watts`,`engine_measurement_centimeters_cubed`,`power_output_rating`,`fuel_type`,`euro_standard`,`ecu_manufacturer`,`ecu_protocol`,`ecu_type`,`ecu_micro`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`,`vehicleType_id`,`vehicleMake_id`,`vehicleModel_id`,`vehiclePowerTrain_id`) VALUES ('00550a0b-92a7-4664-b067-8715d0821804','125','295','93','','126','Diesel','Euro 4','Bosch','EDC16C39','ECM','','2020-05-21 20:18:54','2020-05-21 20:18:54',1,0,'2f94f23c0dd9fe16373c-kdU1M8BYSFT6ve7vbR2cdjCHG3oIwnmLhaPWfEsvS5qw4MehNuKFLdGjuOH','bc1a7a20-e97d-406f-996d-21e3dcd94b61','33755d22-d3f6-43da-af20-9616493f29df','9de3988f-bfd5-47e3-b226-48bab5cc9ca0','2454ba6a-dc51-462e-a329-49977ef1f0c9');
  48. ");
  49.         $this->addSql("INSERT INTO `protocol_vehicle_type` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('20fa4877-eae9-4321-9e6b-8be88fdfac2b','Boat','2020-05-21 15:26:46','2020-05-21 15:26:46',1,0,'6d662a4f0118370f23f8-J1hs3Tns2x1uQjAfqSS4anM1XY1Eq0pimDNfMAqHxstEiUrS8AeBfHEfBrT');
  50. ");
  51.         $this->addSql("INSERT INTO `protocol_vehicle_type` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('3c490e8e-2850-4f5f-8b77-4176db4c1f12','Tractor','2020-05-21 20:28:03','2020-05-21 20:28:03',1,0,'1a6998983ed9bc74fda6-TcFcTczL0OwnRSsVsO0eQ11BVLm2AgJD04LD2c8WXnF4QjBjwUf4cTgbtIU');
  52. ");
  53.         $this->addSql("INSERT INTO `protocol_vehicle_type` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('a1d0512c-cffa-4b1f-a446-bb8b8b0d85c9','Truck','2020-05-21 20:29:32','2020-05-21 20:29:32',1,0,'2740ee3d299865a4689a-y5NJofIa0klWarfeaRMvhVtcsqNDoudwuk8fJp0KkJtLwiQ1VpElzaDiePc');
  54. ");
  55.         $this->addSql("INSERT INTO `protocol_vehicle_type` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('bc1a7a20-e97d-406f-996d-21e3dcd94b61','Car','2020-05-21 15:28:17','2020-05-21 15:28:17',1,0,'86e59d1c2fb2c331ab58-ec8vivt710kRb7kEcZnP6B6XG6o6EsT4Qzf8jSXQ8GUNeMK2dAFoEoX2eUt');
  56. ");
  57.         $this->addSql("INSERT INTO `protocol_vehicle_type` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('c644b048-65d8-406a-a3ea-97c560d11f27','Bike','2020-05-21 15:22:08','2020-05-21 15:22:08',1,0,'40130eb4f28d6126caa1-evYDEWwMuZvjvxID7oI8WO32odJL4ymGEN09SfVIYhQg9I96lvh76JqdJr6');
  58. ");
  59.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('1e98cfc9-745f-4a22-af07-95b6124c58cb','Citroen',NULL,'2020-05-21 20:17:01','2020-05-21 20:17:01',1,0,'9129b37a3b5b76b4b543-TgOrPDMClpvVTlP2lSKFB4OfzVyjVYs8D49tTwHkcc4RGOgzcEsvMKBgIzG');
  60. ");
  61.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('2ee430ba-a62d-4de0-89c0-67fb563bfd88','Kia','kia.png','2020-05-21 20:19:58','2020-05-21 20:19:58',1,0,'887bb6d21b24ae83b3c1-DqSaEkjR1xjPpD15DsGlL2ctmVq43A1hrgixst4MgjSKc2T92TcvjB2SLyy');
  62. ");
  63.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('33755d22-d3f6-43da-af20-9616493f29df','Holden','holden.png','2020-05-21 20:18:53','2020-05-21 20:18:53',1,0,'79cd7e748aee99b534df-1pQVW0eDGaJ4MlobssjOs5gCVAhO5U2K5QHQ7o42FTzRq2vbNpFQme53xjj');
  64. ");
  65.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('67eda378-abad-46b0-9817-e3d032ff23f0','Volkswagen','vw.png','2020-05-21 20:26:11','2020-05-21 20:26:11',1,0,'f33a348fe952fa541e8e-jOijqa7RkMevqHDWzImurush6Hx5eNoa1nUvae6QneuVM0riNW9HTHnGKN0');
  66. ");
  67.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('6e4fa7ad-fe15-437b-80e2-9be7c8a4f77d','Ford','ford.png','2020-05-21 20:17:49','2020-05-21 20:17:49',1,0,'6fdca3831b1c841f015a-PN9yOa2V0DT53i6rklHXc11HlZERrYnx5okPmsoh4cV8pnLbcvb0ArEsdwm');
  68. ");
  69.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('7356bcd8-9154-479c-8caa-4011e3240610','Smart','smart.png','2020-05-21 20:25:24','2020-05-21 20:25:24',1,0,'34df3831983e11dc2e0e-uQ8JzwQdIrC3LaVg0D7wNaGYJ1cJ3DmAHN3jzesd0N1yhYW8G76uvKcu8bt');
  70. ");
  71.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('7b7e55f5-15ec-44fd-a07b-36c06d690182','Mercedes-Benz','mercedes_benz.png','2020-05-21 20:20:41','2020-05-21 20:20:41',1,0,'3f380d4517248762a85e-0m1uYidH7cfrtCL2gvZpgZDQcCNcJJak2u7SoFvh4i1zjZ1uiB0dTOxbFZ2');
  72. ");
  73.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('889ebb26-e51a-43d9-a8bc-bdc0dd5332fc','Jeep','jeep.png','2020-05-21 20:19:55','2020-05-21 20:19:55',1,0,'2a6e1233280bbd1b3a45-f4nBrgPZsjNvRR4pUhTFShxznJu3r8ye0mE6RuzoOx03zvIdhQB8QZyFsGX');
  74. ");
  75.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('948c5ad9-5856-43f4-a316-f7f5b5cf26e4','Volvo','volvo.png','2020-05-21 20:27:49','2020-05-21 20:27:49',1,0,'0377916bacd1831b6fc7-O01BEYki9S9TzhtglepYEOzHRbyBEruH0bYK1Cp3Q9xAaOnM6FTPV3fd9MK');
  76. ");
  77.         $this->addSql("INSERT INTO `protocol_vehicle_make` (`id`,`name`,`logo`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('a5c72a13-0bfe-4943-9eff-3b24af4e947f','Renault','renault.png','2020-05-21 20:23:58','2020-05-21 20:23:58',1,0,'0b045f514faa36f77fe1-72JhIHzLTZvcSzJGdO398uqnLh9UjU9LBpHWUDLmx9BcgbvaYsufBBprGhU');
  78. ");
  79.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('01a3cf8d-2fbf-4d2e-a0b9-78d941083584','Caravelle 2006 ()','2020-05-21 20:26:27','2020-05-21 20:26:27',1,0,'58b72cbd47066906ca4d-j96yG8BCEbayPVlOcEFDmW71hxGY9l8hr3FuCjvgiqZzuubj3NXrSQGxWlU');
  80. ");
  81.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('478c6be2-4ec1-452d-961b-51ebefda4c3b','C70 2006 ()','2020-05-21 20:27:51','2020-05-21 20:27:51',1,0,'1406fce01cc88052a931-kLkZlWzwefBfGoEqkomVfWHIsWWHPvuFXFqqvoeYfHqkvwSFYnydIdyDJMd');
  82. ");
  83.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('4b39f8c2-f704-492f-b1c2-f2aa8fdd4991','Forfour 2004 (W454)','2020-05-21 20:25:24','2020-05-21 20:25:24',1,0,'59a9454bfaf9d948fbc1-f1gJ8DeQ9Gk3AdcuKNVcCZgIu9u0aUG0itumRxBpYcOiMuff5d3F6FxQ9y3');
  84. ");
  85.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('73a69361-50e4-400b-a93b-44fe3611487e','Focus C-Max 2004 (DM2)','2020-05-21 20:18:20','2020-05-21 20:18:20',1,0,'9bfe492181bae699eb40-Vo469NWfQY0G9lgq0gm9wOHhags4pawVJfyJ0Iow9e89U2caE58id2JYykD');
  86. ");
  87.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('780b2e4a-25d5-4af8-a0b2-650c3637f08f','Liberty  (KJ)','2020-05-21 20:19:57','2020-05-21 20:19:57',1,0,'053b5864db804de594e9-rmbLco4uwYl3dfAFFxnSHgvbwQ0MtEMP4RsXSqQJQb2aWZK9gRv98RyIiPg');
  88. ");
  89.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('80deee8a-d9c1-4095-b357-bf64614b459e','Koleos 2010 ()','2020-05-21 20:24:07','2020-05-21 20:24:07',1,0,'4835c0779c271522d9bd-tprQc3dxSfAZcDRGnPArIRrDTdP47bnNX6i5pSKdxoa0lWNUCQVDRoAz3Ow');
  90. ");
  91.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('9de3988f-bfd5-47e3-b226-48bab5cc9ca0','Captiva 2010 ()','2020-05-21 20:16:48','2020-05-21 20:16:48',1,0,'ee83ec0f097bca726fb8-GXiyRvGrAFMr3C3oGW9Ufw0z26fI0JYwcZ3ryPGZXHzPEEsKEtQ5Snz1FHc');
  92. ");
  93.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('a19bd6c9-a55a-47cb-a856-7eea56034a45','E-Class 2008 (W211)','2020-05-21 20:21:15','2020-05-21 20:21:15',1,0,'b7cf09cc6bbfeca26c34-5wk96aRCyT5tUEUlkGYYc9JEnOlK5X4niZiB2JC2ztuvgusTs8xW4aEat7d');
  94. ");
  95.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('a831165e-a0d0-4430-b09d-277b9673b945','Jumper 2010 (U9)','2020-05-21 20:17:13','2020-05-21 20:17:13',1,0,'23531867257c1db6b619-LxACFkP0qcXUIYbyGLhgn8prCpOjRuoeQQonxeEN0y1Qm1Kq9Qw2xd80B7c');
  96. ");
  97.         $this->addSql("INSERT INTO `protocol_vehicle_model` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('d3715bc8-89c5-4c63-9007-f3ed14e129a2','Optima 2005 ()','2020-05-21 20:20:03','2020-05-21 20:20:03',1,0,'6d294f7b562823a5c5f7-hWIg4n9N01AVujv7p9lGNJgt8dPOGlNb0S81RJeHfalMLq1Czwb8pAV4Oo0');
  98. ");
  99.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('07aba8dc-15b0-4a35-9de5-6942397b1b31','2.0 dCi AT  ()','2020-05-21 20:24:07','2020-05-21 20:24:07',1,0,'7144fc3210ce0267d5ce-oG6TMJ4ZfMaGVsAC3aDNFdPIqV2GJkG6HB2ZWv666kDyIqJPMzy1NBqJXfo');
  100. ");
  101.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('12dfbbbd-4be1-45be-b5b6-44b0f94cf89e','2.4 20v D5 VED5 Gen2 (D5244T9)','2020-05-21 20:27:50','2020-05-21 20:27:50',1,0,'42da71deea9c3d6eae9f-PzfvSz5oERrt2ICndTDtIJjq8SarWCwFebE5PJt7TsDvB8GZQN1rMk8jgt1');
  102. ");
  103.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('21f9f6b6-5695-41af-be8a-5a01638a2e79','2.0 16v CRDI  (D-D4EA)','2020-05-21 20:19:59','2020-05-21 20:19:59',1,0,'f58690dfab5356014b80-vVwN1m3DY7oESazKhIY14UkjHDJSHLgfrGOSJDC5vCcE4DYM66rStfTmRqM');
  104. ");
  105.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('2454ba6a-dc51-462e-a329-49977ef1f0c9','2.0 16v VCDi 125 2WD  (RA 420)','2020-05-21 20:17:20','2020-05-21 20:17:20',1,0,'ab087ca53a125b0e974b-GeSr9vtXDEvPeAEF8fzPf7IiIDjULV1jhbbZIJagXQ9x9rSoWKbjmMaBFiQ');
  106. ");
  107.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('36c98722-d56d-4339-9fd0-665b49941066','2.5 TDI 6MT  (BLJ)','2020-05-21 20:26:25','2020-05-21 20:26:25',1,0,'67363d8e834af5783ebf-B5XwGVo9GBxghO1XoaVUCUgi4oxjc5tAQqJ04Q3xp21i5zBZWGmwXVCzuH7');
  108. ");
  109.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('371222c9-3cbe-4b8c-851b-530a43351619','2.8 16 VCRD  ()','2020-05-21 20:19:57','2020-05-21 20:19:57',1,0,'5ceeb94d0a71fc0314f9-kTq4gVcq0f1VKIsz1PAWlBtOuadZ7dWK5URz8QSBmrdp2qwoHOQwNNy1gMh');
  110. ");
  111.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('680b7a96-634f-4f19-a6ca-4ef5a5992d62','3.0 HDI  (F1CE0481D)','2020-05-21 20:17:13','2020-05-21 20:17:13',1,0,'2f11e47e039de480f9ec-LJFWm3YiVvHT0fAGHP5EYxTukbUmUhtU82FqIq5v6tXsritdcvHEoK7ZLaJ');
  112. ");
  113.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('74b68d14-17ca-4943-80d1-c6ed26850a10','1.5 CDI 5MT  (OM639DE15LA)','2020-05-21 20:25:24','2020-05-21 20:25:24',1,0,'3631f91753c2a45be491-Z4jcVFJqOIdm7IEHmGhiblVhEkhexdW7DSw0kokg5Fh3mucraDhF1rbjvoi');
  114. ");
  115.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('8861960c-c569-4a44-811a-7ff04fc16dfb','1.6 TDCi 5MT Duratorq (HHDA)','2020-05-21 20:17:51','2020-05-21 20:17:51',1,0,'9a79b2343b2a2d884a21-rzp1NuALA3S47HAeJygvevRLly7yFFM0fFuQTGDYAlBg7X1U9NLQPQSkCyZ');
  116. ");
  117.         $this->addSql("INSERT INTO `protocol_vehicle_power_train` (`id`,`name`,`created_date`,`updated_date`,`enabled`,`deleted`,`hash`) VALUES ('e6fab8a0-3462-4207-b224-3bbaccfa4db5','300 BlueTEC  (642.92)','2020-05-21 20:21:15','2020-05-21 20:21:15',1,0,'f371b044a8375f6b4a4b-pXubgL6Feh0mngJyn4in5TE3tOERO5Sd0SQQw39GhgpoLgtVANSbqDt58iP');
  118. ");
  119.         $this->addSql("SET FOREIGN_KEY_CHECKS = 1;");
  121.         //$this->addSql("");
  122.     }
  124.     public function down(Schema $schema): void
  125.     {
  126.         // this down() migration is auto-generated, please modify it to your needs
  128.     }
  129. }