-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Gazdă: localhost:3306
-- Timp de generare: sept. 05, 2024 la 09:21 AM
-- Versiune server: 10.6.18-MariaDB-cll-lve
-- Versiune PHP: 8.3.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `zadio_zadiocars`
--

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

--
-- Structură tabel pentru tabel `additionals_form`
--

CREATE TABLE `additionals_form` (
  `id` int(11) NOT NULL,
  `json` longtext NOT NULL,
  `date_updated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `additionals_form`
--

INSERT INTO `additionals_form` (`id`, `json`, `date_updated`) VALUES
(1, '{\r\n   \"name\":\"frmExtra\",\r\n   \"title\":\"Extra\",\r\n   \"description\":\"Extra\",\r\n   \"method\":\"post\",\r\n   \"enctype\":\"\",\r\n   \"action\":\"\",\r\n   \"properties\":{\r\n      \"Energy\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Energy\"\r\n      },\r\n      \"Fuel consumption / 100 km (comb.)\":{\r\n         \"type\":\"number\",\r\n         \"title\":\"Fuel consumption / 100 km (comb.)\",\r\n         \"name\":\"Fuel consumption / 100 km (comb.)\",\r\n         \"value\":\"\",\r\n         \"class\":\"form-control\"\r\n      },\r\n      \"CO2 emissions\":{\r\n         \"type\":\"number\",\r\n         \"title\":\"CO2 emissions\",\r\n         \"name\":\"CO2 emissions\",\r\n         \"class\":\"form-control\"\r\n      },\r\n      \"Pain_colour\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Paint colour\"\r\n      },\r\n      \"Colour\":{\r\n         \"type\":\"input\",\r\n         \"title\":\"Colour\",\r\n         \"name\":\"Colour\",\r\n         \"class\":\"form-control\"\r\n      },\r\n      \"Manufacturer colour\":{\r\n         \"type\":\"input\",\r\n         \"title\":\"Manufacturer colour\",\r\n         \"name\":\"Manufacturer colour\",\r\n         \"placeholder\":\"\",\r\n         \"class\":\"form-control\"\r\n      },\r\n      \"Paint type\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Paint type\",\r\n         \"name\":\"Paint type\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Standard\":\"Standard\",\r\n            \"Metallic\":\"Metallic\",\r\n            \"Matt\":\"Matt\"\r\n         }\r\n      },\r\n      \"Upholstery\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Upholstery\"\r\n      },\r\n      \"Upholstery material\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Upholstery material\",\r\n         \"name\":\"Upholstery material\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Leather\":\"Leather\",\r\n            \"Alcantara\":\"Alcantara\",\r\n            \"Leather-alcantara\":\"Leather-alcantara\",\r\n            \"Leather-textile\":\"Leather-textile\",\r\n            \"Fabric\":\"Fabric\"\r\n         }\r\n      },\r\n      \"safety\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Safety & security\"\r\n      },\r\n      \"Automatic stability control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Automatic stability control\",\r\n         \"name\":\"Automatic stability control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electronic stability control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electronic stability control\",\r\n         \"name\":\"Electronic stability control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electronic stabilization program\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electronic stabilization program\",\r\n         \"name\":\"Electronic stabilization program\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Traction control system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Traction control system\",\r\n         \"name\":\"Traction control system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Anti-lock system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Anti-lock system\",\r\n         \"name\":\"Anti-lock system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Brake Assist System\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Brake Assist System\",\r\n         \"name\":\"Brake Assist System\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Emergency brake assistant\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Emergency brake assistant\",\r\n         \"name\":\"Emergency brake assistant\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electronic parking brake\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electronic parking brake\",\r\n         \"name\":\"Electronic parking brake\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"ABS\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"ABS\",\r\n         \"name\":\"ABS\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Emergency system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Emergency system\",\r\n         \"name\":\"Emergency system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Emergency call system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Emergency call system\",\r\n         \"name\":\"Emergency call system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Cruise_control\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Cruise control\"\r\n      },\r\n      \"Cruise control system (autopilot)\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Cruise control system (autopilot)\",\r\n         \"name\":\"Cruise control system (autopilot)\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Adaptive cruise control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Adaptive cruise control\",\r\n         \"name\":\"Adaptive cruise control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Predictive adaptive cruise control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Predictive adaptive cruise control\",\r\n         \"name\":\"Predictive adaptive cruise control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Speed limit control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Speed limit control\",\r\n         \"name\":\"Speed limit control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Airbags\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Airbags\"\r\n      },\r\n      \"Front\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Front\",\r\n         \"name\":\"Front\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Rear\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Rear\",\r\n         \"name\":\"Rear\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Side\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Side\",\r\n         \"name\":\"Side\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Driver-side\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Driver-side\",\r\n         \"name\":\"Driver-side\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Driver-head\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Driver-head\",\r\n         \"name\":\"Driver-head\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Passenger-side\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Passenger-side\",\r\n         \"name\":\"Passenger-side\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Headlights\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Headlights\"\r\n      },\r\n      \"Adaptive headlights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Adaptive headlights\",\r\n         \"name\":\"Adaptive headlights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Bi-xenon headlights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Bi-xenon headlights\",\r\n         \"name\":\"Bi-xenon headlights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Laser headlights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Laser headlights\",\r\n         \"name\":\"Laser headlights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"LED headlights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"LED headlights\",\r\n         \"name\":\"LED headlights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Headlights xenon\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Headlights xenon\",\r\n         \"name\":\"Headlights xenon\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Headlights halogen\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Headlights halogen\",\r\n         \"name\":\"Headlights halogen\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Dynamic directional lights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Dynamic directional lights\",\r\n         \"name\":\"Dynamic directional lights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Headlights wash system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Headlights wash system\",\r\n         \"name\":\"Headlights wash system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Ambient lighting\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Ambient lighting\",\r\n         \"name\":\"Ambient lighting\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"LED Daytime Running Lights\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"LED Daytime Running Lights\",\r\n         \"name\":\"LED Daytime Running Lights\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sunroof / Panoramic roof\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Sunroof / Panoramic roof\"\r\n      },\r\n      \"Sunroof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sunroof\",\r\n         \"name\":\"Sunroof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Panoramic sliding roof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Panoramic sliding roof\",\r\n         \"name\":\"Panoramic sliding roof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Panoramic sunroof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Panoramic sunroof\",\r\n         \"name\":\"Panoramic sunroof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electric sunroof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electric sunroof\",\r\n         \"name\":\"Electric sunroof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Manual sunroof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Manual sunroof\",\r\n         \"name\":\"Manual sunroof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Rear electric glass sunroof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Rear electric glass sunroof\",\r\n         \"name\":\"Rear electric glass sunroof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Railing on the roof\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Railing on the roof\",\r\n         \"name\":\"Railing on the roof\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Protection\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Protection\"\r\n      },\r\n      \"Alarm\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Alarm\",\r\n         \"name\":\"Alarm\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Central door lock\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Central door lock\",\r\n         \"name\":\"Central door lock\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Central door lock with remote control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Central door lock with remote control\",\r\n         \"name\":\"Central door lock with remote control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Immobilizer\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Immobilizer\",\r\n         \"name\":\"Immobilizer\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Comfort\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Comfort\"\r\n      },\r\n      \"Apple Carplay\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Apple Carplay\",\r\n         \"name\":\"Apple Carplay\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Android Auto\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Android Auto\",\r\n         \"name\":\"Android Auto\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Bluetooth / handsfree system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Bluetooth / handsfree system\",\r\n         \"name\":\"Bluetooth / handsfree system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"USB, audio/video, IN/AUX outputs\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"USB, audio/video, IN/AUX outputs\",\r\n         \"name\":\"USB, audio/video, IN/AUX outputs\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Navigation system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Navigation system\",\r\n         \"name\":\"Navigation system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"CD player\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"CD player\",\r\n         \"name\":\"CD player\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Fully digital instrument cluster\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Fully digital instrument cluster\",\r\n         \"name\":\"Fully digital instrument cluster\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Music streaming integrated\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Music streaming integrated\",\r\n         \"name\":\"Music streaming integrated\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Radio DAB\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Radio DAB\",\r\n         \"name\":\"Radio DAB\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sound system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sound system\",\r\n         \"name\":\"Sound system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Touch screen\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Touch screen\",\r\n         \"name\":\"Touch screen\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Tuner / Radio\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Tuner / Radio\",\r\n         \"name\":\"Tuner / Radio\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"TV\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"TV\",\r\n         \"name\":\"TV\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Voice control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Voice control\",\r\n         \"name\":\"Voice control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"WLAN / WiFi Hotspot\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"WLAN / WiFi Hotspot\",\r\n         \"name\":\"WLAN / WiFi Hotspot\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Internet connection\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Internet connection\",\r\n         \"name\":\"Internet connection\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Wireless charging\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Wireless charging\",\r\n         \"name\":\"Wireless charging\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Induction charging for smartphones\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Induction charging for smartphones\",\r\n         \"name\":\"Induction charging for smartphones\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Cooling glove compartment\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Cooling glove compartment\",\r\n         \"name\":\"Cooling glove compartment\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Keyless entry\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Keyless entry\",\r\n         \"name\":\"Keyless entry\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Keyless ignition\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Keyless ignition\",\r\n         \"name\":\"Keyless ignition\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Keyless go\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Keyless go\",\r\n         \"name\":\"Keyless go\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Board computer\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Board computer\",\r\n         \"name\":\"Board computer\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electrical side mirrors\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electrical side mirrors\",\r\n         \"name\":\"Electrical side mirrors\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electrically folding mirrors\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electrically folding mirrors\",\r\n         \"name\":\"Electrically folding mirrors\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electrical windows\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electrical windows\",\r\n         \"name\":\"Electrical windows\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Heated windshield\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated windshield\",\r\n         \"name\":\"Heated windshield\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Heated rear window\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated rear window\",\r\n         \"name\":\"Heated rear window\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Air conditioning label\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Air conditioning\"\r\n      },\r\n      \"Air conditioning\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Air conditioning\",\r\n         \"name\":\"Air conditioning\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Automatic air conditioning\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Automatic air conditioning\",\r\n         \"name\":\"Automatic air conditioning\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Automatic air conditioning zones\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Automatic air conditioning\",\r\n         \"name\":\"Automatic air conditioning\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"2 zones\":\"2 zones\",\r\n            \"3 zones\":\"3 zones\",\r\n            \"4 zones\":\"4 zones\"\r\n         }\r\n      },\r\n      \"Automatic climate control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Automatic climate control\",\r\n         \"name\":\"Automatic climate control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Steering wheel\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Steering wheel\"\r\n      },\r\n      \"Multifunctional steering wheel\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Multifunctional steering wheel\",\r\n         \"name\":\"Multifunctional steering wheel\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sport steering wheel\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sport steering wheel\",\r\n         \"name\":\"Sport steering wheel\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Steering wheel with gear shifter\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Steering wheel with gear shifter\",\r\n         \"name\":\"Steering wheel with gear shifter\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Steering wheel adjustment\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Steering wheel adjustment\",\r\n         \"name\":\"Steering wheel adjustment\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Heated steering wheel\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated steering wheel\",\r\n         \"name\":\"Heated steering wheel\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Leather steering wheel\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Leather steering wheel\",\r\n         \"name\":\"Leather steering wheel\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Shift paddles\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Shift paddles\",\r\n         \"name\":\"Shift paddles\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Power steering\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Power steering\",\r\n         \"name\":\"Power steering\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electric power steering\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electric power steering\",\r\n         \"name\":\"Electric power steering\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Seats\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Seats\"\r\n      },\r\n      \"Heated seats\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated seats\",\r\n         \"name\":\"Heated seats\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Ventilated seats\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Ventilated seats\",\r\n         \"name\":\"Ventilated seats\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Seats with memory\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Seats with memory\",\r\n         \"name\":\"Seats with memory\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Seats with massage\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Seats with massage\",\r\n         \"name\":\"Seats with massage\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sports seats\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sports seats\",\r\n         \"name\":\"Sports seats\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electrically adjustable seats\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electrically adjustable seats\",\r\n         \"name\":\"Electrically adjustable seats\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Driver seat with massage\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Driver seat with massage\",\r\n         \"name\":\"Driver seat with massage\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sports driver`s seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sports driver`s seat\",\r\n         \"name\":\"Sports driver`s seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electric driver seat adjustment\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electric driver seat adjustment\",\r\n         \"name\":\"Electric driver seat adjustmentt\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Driver`s seat with lumbar support\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Driver`s seat with lumbar support\",\r\n         \"name\":\"Driver`s seat with lumbar support\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Heated passenger seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated passenger seat\",\r\n         \"name\":\"Heated passenger seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Ventilated passenger seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Ventilated passenger seat\",\r\n         \"name\":\"Ventilated passenger seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Passenger seat with memory\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Passenger seat with memory\",\r\n         \"name\":\"Passenger seat with memory\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Passenger seat with massage\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Passenger seat with massage\",\r\n         \"name\":\"Passenger seat with massage\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sports passenger seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sports passenger seat\",\r\n         \"name\":\"Sports passenger seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electrically adjustable passenger seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electrically adjustable passenger seat\",\r\n         \"name\":\"Electrically adjustable passenger seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Passenger seat with lumbar support\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Passenger seat with lumbar support\",\r\n         \"name\":\"Passenger seat with lumbar support\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Folding passenger seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Folding passenger seat\",\r\n         \"name\":\"Folding passenger seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Heated back seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Heated back seat\",\r\n         \"name\":\"Heated back seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Ventilated back seat\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Ventilated back seat\",\r\n         \"name\":\"Ventilated back seat\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Rear seat with memory\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Rear seat with memory\",\r\n         \"name\":\"Rear seat with memory\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Electric seat adjustment, rear\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Electric seat adjustment, rear\",\r\n         \"name\":\"Electric seat adjustment, rear\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Split rear seats\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Split rear seats\",\r\n         \"name\":\"Split rear seats\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Back seat with lumbar support\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Back seat with lumbar support\",\r\n         \"name\":\"Back seat with lumbar support\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Front armrest\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Front armrest\",\r\n         \"name\":\"Front armrest\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Rear armrest\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Rear armrest\",\r\n         \"name\":\"Rear armrest\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking assitance\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Parking assitance\"\r\n      },\r\n      \"Park distance control\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Park distance control\",\r\n         \"name\":\"Park distance control\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking sensors front\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Parking sensors front\",\r\n         \"name\":\"Parking sensors frontt\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking sensors rear\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Parking sensors rear\",\r\n         \"name\":\"Parking sensors rear\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking camera front\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Parking camera front\",\r\n         \"name\":\"Parking camera front\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking camera rear\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Parking camera rear\",\r\n         \"name\":\"Parking camera rear\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"360 camera\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"360 camera\",\r\n         \"name\":\"360 camera\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Parking assist system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Parking assist system\",\r\n         \"name\":\"Parking assist system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Automatic parking system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Automatic parking system\",\r\n         \"name\":\"Automatic parking system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sensors\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"\"\r\n      },\r\n      \"Interior mirror automatically dimming\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Interior mirror automatically dimming\",\r\n         \"name\":\"Interior mirror automatically dimming\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Head-Up Display\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Head-Up Display\",\r\n         \"name\":\"Head-Up Display\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Attention assist\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Attention assist\",\r\n         \"name\":\"Attention assist\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Fatigue warning\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Fatigue warning\",\r\n         \"name\":\"Fatigue warning\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Lane assist\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Lane assist\",\r\n         \"name\":\"Lane assist\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Lane departure warning system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Lane departure warning system\",\r\n         \"name\":\"Lane departure warning system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Blind spot monitor\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Blind spot monitor\",\r\n         \"name\":\"Blind spot monitor\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Distance warning system (Radar?)\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Distance warning system (Radar?)\",\r\n         \"name\":\"Distance warning system (Radar?)\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Collision warning\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Collision warning\",\r\n         \"name\":\"Collision warning\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Autonomous driving\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Autonomous driving\",\r\n         \"name\":\"Autonomous driving\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Follow me home\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Follow me home\",\r\n         \"name\":\"Follow me home\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Tires\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"\"\r\n      },\r\n      \"Tire pressure monitoring system\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Tire pressure monitoring system\",\r\n         \"name\":\"Tire pressure monitoring system\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Rain sensor\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Rain sensor\",\r\n         \"name\":\"Rain sensor\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Light sensor\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Light sensor\",\r\n         \"name\":\"Light sensor\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Packages\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"\"\r\n      },\r\n      \"Smoking package\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Smoking package\",\r\n         \"name\":\"Smoking package\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Winter package\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Winter package\",\r\n         \"name\":\"Winter package\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Sport package\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Sport package\",\r\n         \"name\":\"Sport package\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Extras\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"Extras\"\r\n      },\r\n      \"Auxiliary heating\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Auxiliary heating\",\r\n         \"name\":\"Auxiliary heatinge\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Luggage compartment partition\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Luggage compartment partition\",\r\n         \"name\":\"Luggage compartment partition\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Tow bar\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Tow bar\",\r\n         \"name\":\"Tow bar\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Trailer hitch\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Trailer hitch\",\r\n         \"name\":\"Trailer hitch\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Isofix\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Isofix\",\r\n         \"name\":\"Isofix\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"warranty\":{\r\n         \"type\":\"label\",\r\n         \"title\":\"\"\r\n      },\r\n      \"Manufacturer`s warranty\":{\r\n         \"type\":\"select\",\r\n         \"title\":\"Manufacturer`s warranty\",\r\n         \"name\":\"Manufacturer`s warranty\",\r\n         \"class\":\"form-control\",\r\n         \"options\":{\r\n            \"\":\"\",\r\n            \"Yes\":\"Yes\"\r\n         }\r\n      },\r\n      \"Months\":{\r\n         \"type\":\"number\",\r\n         \"title\":\"Months\",\r\n         \"name\":\"Months\",\r\n         \"class\":\"form-control\"\r\n      }\r\n   }\r\n}', '2024-08-07 08:17:54');

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

--
-- Structură tabel pentru tabel `cars`
--

CREATE TABLE `cars` (
  `id` bigint(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `price_bgn` decimal(10,2) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `brand` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `model_dec` varchar(50) NOT NULL,
  `body_type` varchar(50) NOT NULL,
  `steering_whell` varchar(50) NOT NULL,
  `cubic_capacity` int(11) NOT NULL,
  `engine_power_kw` int(11) NOT NULL,
  `engine_power_hp` int(11) NOT NULL,
  `fuel` varchar(50) NOT NULL,
  `emission_standard` varchar(10) NOT NULL,
  `date_manufacture` varchar(20) NOT NULL,
  `gear_box` varchar(20) NOT NULL,
  `drivetrain` varchar(10) NOT NULL,
  `km` int(11) NOT NULL,
  `vin` varchar(30) NOT NULL,
  `technical_status` varchar(30) NOT NULL,
  `registered` tinyint(4) NOT NULL,
  `country_of_origin` varchar(20) NOT NULL,
  `notes` text DEFAULT NULL,
  `additionals` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

--
-- Eliminarea datelor din tabel `cars`
--

INSERT INTO `cars` (`id`, `code`, `client_id`, `price_bgn`, `created_at`, `updated_at`, `status`, `brand`, `model`, `model_dec`, `body_type`, `steering_whell`, `cubic_capacity`, `engine_power_kw`, `engine_power_hp`, `fuel`, `emission_standard`, `date_manufacture`, `gear_box`, `drivetrain`, `km`, `vin`, `technical_status`, `registered`, `country_of_origin`, `notes`, `additionals`) VALUES
(57, 'CAR8PBD5TIBI', 2, 65000.00, '2024-08-10 21:17:56', '2024-08-28 10:48:27', 3, 'Mercedes-Benz', 'CL', 'Mercedes  CL', 'Hatchback', 'Left', 3500, 0, 220, 'Diesel', 'EURO1', '2020-01', 'Manual', 'Front', 3500, '12345678901234568', 'Accident-free', 0, 'Belgium', 'Very nice car', '[{\"name\":\"Fuel consumption / 100 km (comb.)\",\"value\":\"5\"},{\"name\":\"CO2 emissions\",\"value\":\"220\"},{\"name\":\"Colour\",\"value\":\"Black\"},{\"name\":\"Manufacturer colour\",\"value\":\"Black\"},{\"name\":\"Paint type\",\"value\":\"Metallic\"},{\"name\":\"Upholstery material\",\"value\":\"Leather\"}]'),
(59, 'CAR4ZWXWUFEN', 2, 25000.00, '2024-08-10 21:21:04', '2024-09-01 18:24:00', 3, 'Mazda', 'Mx-6', 'Great shape', 'Sedan', 'Left', 2500, 0, 200, 'Diesel', 'EURO1', '2018-01', 'Manual', 'Front', 2500, '12345678901234567', 'Accident-free', 0, 'Bulgaria', '', '[{\"name\":\"Fuel consumption / 100 km (comb.)\",\"value\":\"8.5\"},{\"name\":\"CO2 emissions\",\"value\":\"120\"},{\"name\":\"Colour\",\"value\":\"Red\"},{\"name\":\"Manufacturer colour\",\"value\":\"Red\"},{\"name\":\"Paint type\",\"value\":\"Metallic\"},{\"name\":\"Upholstery material\",\"value\":\"Leather-textile\"}]'),
(61, 'CAREAIGR4EOA', 2, 75000.00, '2024-08-10 21:23:13', '2024-08-10 18:23:17', 3, 'BMW', 'X5', 'X5', 'Hatchback', 'Left', 2500, 0, 200, 'Diesel', 'EURO1', '2020-01', 'Manual', 'Front', 2500, '12345678901234568', 'Accident-free', 0, 'Germany', '', '[{\"name\":\"Fuel consumption / 100 km (comb.)\",\"value\":\"9\"},{\"name\":\"CO2 emissions\",\"value\":\"150\"},{\"name\":\"Colour\",\"value\":\"Black\"},{\"name\":\"Manufacturer colour\",\"value\":\"Black\"},{\"name\":\"Paint type\",\"value\":\"Metallic\"},{\"name\":\"Upholstery material\",\"value\":\"Leather\"}]'),
(63, 'CAR0KVTW85X9', 8, 60000.00, '2024-08-13 15:52:00', '2024-08-28 20:26:16', 3, 'Mercedes-Benz', 'CLS', 'CLS400', 'Hatchback', 'Left', 3500, 0, 333, 'Gasoline', 'EURO5', '2017-01', 'Manual', '4x4', 3500, '12345678901234567', 'Accident-free', 0, 'Bulgaria', 'masina mea 1', '[]'),
(71, 'CAR791BUW2NE', 1, 140000.00, '2024-08-26 22:00:15', '2024-08-28 04:37:12', 3, 'BMW', 'M4', 'M440i', 'Sports car / coupe', 'Left', 3000, 0, 400, 'Gasoline', 'EURO6', '2021-09', 'Automatic', '4x4', 3000, '01234567891234567', 'Accident-free', 0, 'Bulgaria', 'mica nota de subsol', '[]'),
(79, 'CARQD5CU7UAX', 9, 34223.00, '2024-09-04 10:27:58', '2024-09-04 07:48:47', 3, 'Mazda', '3', 'Mazda 3', 'Sedan', 'Left', 1998, 0, 122, 'Gasoline', 'EURO5', '2019-04', 'Automatic', 'Front', 1998, '1HGCM82633A123456', 'Accident-free', 1, 'Romania', '', '[]'),
(81, 'CARP6K1Z43J3', 9, 30309.84, '2024-09-04 10:44:18', '2024-09-04 07:46:21', 3, 'Honda', 'Civic', 'Honda Civic', 'Hatchback', 'Left', 1597, 0, 120, 'Diesel', 'EURO6', '2019-10', 'Manual', 'Front', 1597, '1HGCM82633A123456', 'Accident-free', 1, 'Romania', '', '[]');

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

--
-- Structură tabel pentru tabel `cars_detail`
--

CREATE TABLE `cars_detail` (
  `id` bigint(20) NOT NULL,
  `cylinders` tinyint(4) DEFAULT NULL,
  `gears` tinyint(4) DEFAULT NULL,
  `empty_weight` int(11) DEFAULT NULL,
  `sport_suspension` int(11) DEFAULT NULL,
  `air_suspension` int(11) DEFAULT NULL,
  `seats` int(11) NOT NULL,
  `wheels` varchar(20) NOT NULL,
  `wheels_size` int(11) NOT NULL,
  `fuel_consumption` decimal(10,2) NOT NULL,
  `start_stop` tinyint(4) NOT NULL,
  `color` varchar(20) NOT NULL,
  `manuf-color` varchar(20) NOT NULL,
  `paint_type` varchar(20) NOT NULL,
  `upholstery_colour` varchar(20) NOT NULL,
  `auto_stab_ctl` tinyint(4) DEFAULT NULL,
  `elec_stab_ctl` tinyint(4) DEFAULT NULL,
  `elec_stab_proh` tinyint(4) DEFAULT NULL,
  `traction_ctl` tinyint(4) DEFAULT NULL,
  `anti_lock` tinyint(4) DEFAULT NULL,
  `brake_assist` tinyint(4) DEFAULT NULL,
  `emerg_brake_assist` tinyint(4) DEFAULT NULL,
  `elec_ park_brake` tinyint(4) DEFAULT NULL,
  `abs` tinyint(4) DEFAULT NULL,
  `emerg_sys` tinyint(4) DEFAULT NULL,
  `emerg_call` tinyint(4) DEFAULT NULL,
  `autopilot` varchar(20) DEFAULT NULL,
  `airbags` varchar(20) DEFAULT NULL,
  `headlights` tinyint(20) DEFAULT NULL,
  `sunroof` varchar(20) DEFAULT NULL,
  `protection` varchar(20) DEFAULT NULL,
  `comfort` varchar(20) DEFAULT NULL,
  `air_conditioning` varchar(50) DEFAULT NULL,
  `ateering_wheel` varchar(50) DEFAULT NULL,
  `seats_specs` varchar(50) DEFAULT NULL,
  `parking_assit` varchar(30) DEFAULT NULL,
  `packages` varchar(30) DEFAULT NULL,
  `manuf_warranty` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

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

--
-- Structură tabel pentru tabel `cars_old`
--

CREATE TABLE `cars_old` (
  `id` bigint(20) NOT NULL,
  `barnd` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `body_type` varchar(50) NOT NULL,
  `steering_whell` varchar(50) NOT NULL,
  `cubic_capacity` int(11) NOT NULL,
  `engine_power_kw` int(11) NOT NULL,
  `engine_power_hp` int(11) NOT NULL,
  `fuel` varchar(50) NOT NULL,
  `emission_standard` varchar(10) NOT NULL,
  `date_manufacture` date NOT NULL,
  `gear_box` varchar(20) NOT NULL,
  `drivetrain` varchar(10) NOT NULL,
  `km` int(11) NOT NULL,
  `vin` varchar(30) NOT NULL,
  `technical_status` varchar(30) NOT NULL,
  `registered` tinyint(4) NOT NULL,
  `country_of_origin` varchar(20) NOT NULL,
  `notes` text DEFAULT NULL,
  `cylinders` tinyint(4) DEFAULT NULL,
  `gears` tinyint(4) DEFAULT NULL,
  `empty_weight` int(11) DEFAULT NULL,
  `sport_suspension` int(11) DEFAULT NULL,
  `air_suspension` int(11) DEFAULT NULL,
  `seats` int(11) NOT NULL,
  `wheels` varchar(20) NOT NULL,
  `wheels_size` int(11) NOT NULL,
  `fuel_consumption` decimal(10,2) NOT NULL,
  `co2` decimal(10,2) NOT NULL,
  `start-stop` tinyint(4) NOT NULL,
  `color` varchar(20) NOT NULL,
  `manuf-color` varchar(20) NOT NULL,
  `paint_type` varchar(20) NOT NULL,
  `upholstery_colour` varchar(20) NOT NULL,
  `auto_stab_ctl` tinyint(4) DEFAULT NULL,
  `elec_stab_ctl` tinyint(4) DEFAULT NULL,
  `elec_stab_proh` tinyint(4) DEFAULT NULL,
  `traction_ctl` tinyint(4) DEFAULT NULL,
  `anti_lock` tinyint(4) DEFAULT NULL,
  `brake_assist` tinyint(4) DEFAULT NULL,
  `emerg_brake_assist` tinyint(4) DEFAULT NULL,
  `elec_ park_brake` tinyint(4) DEFAULT NULL,
  `abs` tinyint(4) DEFAULT NULL,
  `emerg_sys` tinyint(4) DEFAULT NULL,
  `emerg_call` tinyint(4) DEFAULT NULL,
  `autopilot` varchar(20) DEFAULT NULL,
  `airbags` varchar(20) DEFAULT NULL,
  `headlights` tinyint(20) DEFAULT NULL,
  `sunroof` varchar(20) DEFAULT NULL,
  `protection` varchar(20) DEFAULT NULL,
  `comfort` varchar(20) DEFAULT NULL,
  `air_conditioning` varchar(50) DEFAULT NULL,
  `ateering_wheel` varchar(50) DEFAULT NULL,
  `seats_specs` varchar(50) DEFAULT NULL,
  `parking_assit` varchar(30) DEFAULT NULL,
  `packages` varchar(30) DEFAULT NULL,
  `manuf_warranty` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

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

--
-- Structură tabel pentru tabel `cars_status`
--

CREATE TABLE `cars_status` (
  `id` int(11) NOT NULL,
  `status_name` varchar(20) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `cars_status`
--

INSERT INTO `cars_status` (`id`, `status_name`, `active`) VALUES
(-1, 'Publish rejected', 1),
(0, 'Draft', 1),
(1, 'Pending approval', 1),
(2, 'Published', 1);

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

--
-- Structură tabel pentru tabel `car_additionals`
--

CREATE TABLE `car_additionals` (
  `car_code` varchar(20) NOT NULL,
  `client_id` int(11) NOT NULL,
  `additionals` text CHARACTER SET utf16 COLLATE utf16_bin NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `car_additionals`
--

INSERT INTO `car_additionals` (`car_code`, `client_id`, `additionals`, `updated_at`) VALUES
('CARZKT1SQG0W', 2, '[{\"Fuel_consumption_/_100_km_(comb_)\":\"9.5\"},{\"CO2_emissions\":\"120\"},{\"Colour\":\"Black\"},{\"Paint_type\":\"Metallic\"},{\"upholstery_material\":\"Leather\"}]', '2024-08-08 08:25:52');

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

--
-- Structură tabel pentru tabel `car_brand`
--

CREATE TABLE `car_brand` (
  `id` int(11) NOT NULL,
  `brand_name` varchar(50) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `car_brand`
--

INSERT INTO `car_brand` (`id`, `brand_name`, `active`) VALUES
(1, 'Abarth', 1),
(2, 'Acura', 1),
(3, 'Alfa Romeo', 1),
(4, 'Aston Martin', 1),
(5, 'Audi', 1),
(6, 'BMW', 1),
(7, 'Bentley', 1),
(8, 'Buick', 1),
(9, 'Cadillac', 1),
(10, 'Chevrolet', 1),
(11, 'Chrysler', 1),
(12, 'Citroen', 1),
(13, 'Cupra', 1),
(14, 'DS', 1),
(15, 'Dacia', 1),
(16, 'Daewoo', 1),
(17, 'Daihatsu', 1),
(18, 'Dodge', 1),
(19, 'Ferrari', 1),
(20, 'Fiat', 1),
(21, 'Ford', 1),
(22, 'GMC', 1),
(23, 'Genesis', 1),
(24, 'Great Wall', 1),
(25, 'Honda', 1),
(26, 'Hummer', 1),
(27, 'Hyundai', 1),
(28, 'Infiniti', 1),
(29, 'Isuzu', 1),
(30, 'Jaguar', 1),
(31, 'Jeep', 1),
(32, 'Kia', 1),
(33, 'Lamborghini', 1),
(34, 'Lancia', 1),
(35, 'Land Rover', 1),
(36, 'Lexus', 1),
(37, 'Lincoln', 1),
(38, 'MG', 1),
(39, 'Maserati', 1),
(40, 'Maybach', 1),
(41, 'Mazda', 1),
(42, 'Mercedes-Benz', 1),
(43, 'Mini', 1),
(44, 'Mitsubishi', 1),
(45, 'Nissan', 1),
(46, 'Opel', 1),
(47, 'Peugeot', 1),
(48, 'Porsche', 1),
(49, 'Renault', 1),
(50, 'Rolls-Royce', 1),
(51, 'Seat', 1),
(52, 'Skoda', 1),
(53, 'Smart', 1),
(54, 'SsangYong', 1),
(55, 'Subaru', 1),
(56, 'Suzuki', 1),
(57, 'Tesla', 1),
(58, 'Toyota', 1),
(59, 'VW', 0),
(60, 'Volvo', 1);

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

--
-- Structură tabel pentru tabel `car_images`
--

CREATE TABLE `car_images` (
  `id` int(11) NOT NULL,
  `car_code` varchar(20) NOT NULL,
  `url` varchar(200) NOT NULL,
  `sort` int(11) DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `car_images`
--

INSERT INTO `car_images` (`id`, `car_code`, `url`, `sort`, `date_created`) VALUES
(1, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img4.jpg', 1, '2024-08-10 21:17:54'),
(2, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img2.jpg', 1, '2024-08-10 21:17:54'),
(3, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img3.jpg', 1, '2024-08-10 21:17:54'),
(4, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img5.jpg', 1, '2024-08-10 21:17:54'),
(5, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img1.jpg', 1, '2024-08-10 21:17:54'),
(6, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img6.jpg', 1, '2024-08-10 21:17:55'),
(7, 'CAR8PBD5TIBI', 'CAR8PBD5TIBI/img7.jpg', 1, '2024-08-10 21:17:55'),
(8, 'CAR4ZWXWUFEN', 'CAR4ZWXWUFEN/pic3.jpg', 1, '2024-08-10 21:21:03'),
(9, 'CAR4ZWXWUFEN', 'CAR4ZWXWUFEN/pic2.jpg', 1, '2024-08-10 21:21:03'),
(10, 'CAR4ZWXWUFEN', 'CAR4ZWXWUFEN/pic1.jpg', 1, '2024-08-10 21:21:03'),
(11, 'CAREAIGR4EOA', 'CAREAIGR4EOA/image-2.jpg', 1, '2024-08-10 21:23:12'),
(12, 'CAREAIGR4EOA', 'CAREAIGR4EOA/image-1.jpg', 1, '2024-08-10 21:23:12'),
(13, 'CAREAIGR4EOA', 'CAREAIGR4EOA/image-4.jpg', 1, '2024-08-10 21:23:12'),
(14, 'CAREAIGR4EOA', 'CAREAIGR4EOA/image-3.jpg', 1, '2024-08-10 21:23:12'),
(15, 'CAREAIGR4EOA', 'CAREAIGR4EOA/image-5.jpg', 1, '2024-08-10 21:23:12'),
(16, 'CAR0KVTW85X9', 'CAR0KVTW85X9/IMG_20210701_163456_495.jpg', 1, '2024-08-13 15:51:59'),
(17, 'CAR0KVTW85X9', 'CAR0KVTW85X9/IMG_20210701_163350_218.jpg', 1, '2024-08-13 15:51:59'),
(18, 'CAR0KVTW85X9', 'CAR0KVTW85X9/IMG_20210701_163437_426.jpg', 1, '2024-08-13 15:52:00'),
(19, 'CAR0KVTW85X9', 'CAR0KVTW85X9/IMG_20210701_163409_695.jpg', 1, '2024-08-13 15:52:00'),
(20, 'CAREAIGR4EOA', 'CAREAIGR4EOA/bmw.png', 1, '2024-08-20 00:10:34'),
(21, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_2C.jpg', 1, '2024-08-26 22:00:14'),
(22, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_bD.jpg', 1, '2024-08-26 22:00:14'),
(23, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_45.jpg', 1, '2024-08-26 22:00:14'),
(24, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_im.jpg', 1, '2024-08-26 22:00:14'),
(25, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_hq.jpg', 1, '2024-08-26 22:00:14'),
(26, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_qZ.jpg', 1, '2024-08-26 22:00:16'),
(27, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_xi.jpg', 1, '2024-08-26 22:00:16'),
(28, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_jB.jpg', 1, '2024-08-26 22:00:16'),
(29, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_r3.jpg', 1, '2024-08-26 22:00:16'),
(30, 'CAR791BUW2NE', 'CAR791BUW2NE/11669798426120066_P3.jpg', 1, '2024-08-26 22:00:16'),
(31, 'CARQD5CU7UAX', 'CARQD5CU7UAX/JDPA_2019-Mazda-Mazda3-Premium-Sedan-Soul-Red-Front-Quarter-Large.jpg', 1, '2024-09-04 10:27:57'),
(32, 'CARP6K1Z43J3', 'CARP6K1Z43J3/2019_honda_civic_hatchback_angularfront.jpg', 1, '2024-09-04 10:44:17');

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

--
-- Structură tabel pentru tabel `car_model`
--

CREATE TABLE `car_model` (
  `id` int(11) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `model_name` varchar(50) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `car_model`
--

INSERT INTO `car_model` (`id`, `brand`, `model_name`, `active`) VALUES
(1, 'BMW', '1', 1),
(2, 'BMW', '2', 1),
(3, 'BMW', '3', 1),
(4, 'BMW', '4', 1),
(5, 'BMW', '5', 1),
(6, 'BMW', '6', 1),
(7, 'BMW', '7', 1),
(8, 'BMW', '8', 1),
(9, 'BMW', 'i3', 1),
(10, 'BMW', 'i4', 1),
(11, 'BMW', 'i5', 1),
(12, 'BMW', 'i7', 1),
(13, 'BMW', 'i8', 1),
(14, 'BMW', 'iX', 1),
(15, 'BMW', 'iX1', 1),
(16, 'BMW', 'iX2', 1),
(17, 'BMW', 'iX3', 1),
(18, 'BMW', 'M1', 1),
(19, 'BMW', 'M2', 1),
(20, 'BMW', 'M3', 1),
(21, 'BMW', 'M4', 1),
(22, 'BMW', 'M5', 1),
(23, 'BMW', 'M6', 1),
(24, 'BMW', 'M7', 1),
(25, 'BMW', 'M8', 1),
(26, 'BMW', 'X1', 1),
(27, 'BMW', 'X2', 1),
(28, 'BMW', 'X3', 1),
(29, 'BMW', 'X3M', 1),
(30, 'BMW', 'X4', 1),
(31, 'BMW', 'X4M', 1),
(32, 'BMW', 'X5', 1),
(33, 'BMW', 'X5M', 1),
(34, 'BMW', 'X6', 1),
(35, 'BMW', 'X6M', 1),
(36, 'BMW', 'X7', 1),
(37, 'BMW', 'X7M', 1),
(38, 'BMW', 'XM', 1),
(39, 'BMW', 'Z1', 1),
(40, 'BMW', 'Z3', 1),
(41, 'BMW', 'Z3M', 1),
(42, 'BMW', 'Z4', 1),
(43, 'BMW', 'Z4M', 1),
(44, 'BMW', 'Z8', 1),
(45, 'Abarth', '595', 1),
(46, 'Acura', 'ILX', 1),
(47, 'Acura', 'Mdx', 1),
(48, 'Acura', 'Rdx', 1),
(49, 'Acura', 'Rl', 1),
(50, 'Acura', 'TLX', 1),
(51, 'Acura', 'Tl', 1),
(52, 'Acura', 'ZDX', 1),
(53, 'Alfa Romeo', '145', 1),
(54, 'Alfa Romeo', '146', 1),
(55, 'Alfa Romeo', '147', 1),
(56, 'Alfa Romeo', '155', 1),
(57, 'Alfa Romeo', '156', 1),
(58, 'Alfa Romeo', '156 sports wagon', 1),
(59, 'Alfa Romeo', '159', 1),
(60, 'Alfa Romeo', '159 sports wagon', 1),
(61, 'Alfa Romeo', '164', 1),
(62, 'Alfa Romeo', '166', 1),
(63, 'Alfa Romeo', '4C', 1),
(64, 'Alfa Romeo', '8C Competizione', 1),
(65, 'Alfa Romeo', '90', 1),
(66, 'Alfa Romeo', 'Brera', 1),
(67, 'Alfa Romeo', 'Crosswagon q4', 1),
(68, 'Alfa Romeo', 'Giulia', 1),
(69, 'Alfa Romeo', 'Giulietta', 1),
(70, 'Alfa Romeo', 'GT', 1),
(71, 'Alfa Romeo', 'Gtv', 1),
(72, 'Alfa Romeo', 'MiTo', 1),
(73, 'Alfa Romeo', 'Spider', 1),
(74, 'Alfa Romeo', 'Stelvio', 1),
(75, 'Alfa Romeo', 'Tonale', 1),
(76, 'Aston Martin', 'DBS', 1),
(77, 'Aston Martin', 'DBX', 1),
(78, 'Aston Martin', 'Db9', 1),
(79, 'Aston Martin', 'V12 Vantage', 1),
(80, 'Aston Martin', 'V8 Vantage', 1),
(81, 'Aston Martin', 'Vanquish', 1),
(82, 'Audi', '100', 1),
(83, 'Audi', '80', 1),
(84, 'Audi', '90', 1),
(85, 'Audi', 'A1', 1),
(86, 'Audi', 'A2', 1),
(87, 'Audi', 'A3', 1),
(88, 'Audi', 'A4', 1),
(89, 'Audi', 'A4 Allroad', 1),
(90, 'Audi', 'A5', 1),
(91, 'Audi', 'A6', 1),
(92, 'Audi', 'A6 Allroad', 1),
(93, 'Audi', 'A7', 1),
(94, 'Audi', 'A8', 1),
(95, 'Audi', 'Allroad', 1),
(96, 'Audi', 'Cabriolet', 1),
(97, 'Audi', 'Coupe', 1),
(98, 'Audi', 'E-Tron', 1),
(99, 'Audi', 'E-Tron GT', 1),
(100, 'Audi', 'Q2', 1),
(101, 'Audi', 'Q3', 1),
(102, 'Audi', 'Q4', 1),
(103, 'Audi', 'Q5', 1),
(104, 'Audi', 'Q7', 1),
(105, 'Audi', 'Q8', 1),
(106, 'Audi', 'Quattro', 1),
(107, 'Audi', 'R8', 1),
(108, 'Audi', 'RSQ3', 1),
(109, 'Audi', 'RSQ8', 1),
(110, 'Audi', 'Rs3', 1),
(111, 'Audi', 'Rs4', 1),
(112, 'Audi', 'Rs5', 1),
(113, 'Audi', 'RS6', 1),
(114, 'Audi', 'RS7', 1),
(115, 'Audi', 'S1', 1),
(116, 'Audi', 'S2', 1),
(117, 'Audi', 'S3', 1),
(118, 'Audi', 'S4', 1),
(119, 'Audi', 'S5', 1),
(120, 'Audi', 'S6', 1),
(121, 'Audi', 'S7', 1),
(122, 'Audi', 'S8', 1),
(123, 'Audi', 'SQ5', 1),
(124, 'Audi', 'SQ7', 1),
(125, 'Audi', 'SQ8', 1),
(126, 'Audi', 'TT', 1),
(127, 'Bentley', 'Arnage', 1),
(128, 'Bentley', 'Bentayga', 1),
(129, 'Bentley', 'Continental', 1),
(130, 'Bentley', 'Continental GT', 1),
(131, 'Bentley', 'Flying Spur', 1),
(132, 'Bentley', 'Mulsanne', 1),
(133, 'Bentley', 'T-series', 1),
(134, 'Buick', 'Century', 1),
(135, 'Buick', 'Park avenue', 1),
(136, 'Buick', 'Riviera', 1),
(137, 'Buick', 'Skylark', 1),
(138, 'Cadillac', 'ATS', 1),
(139, 'Cadillac', 'BLS', 1),
(140, 'Cadillac', 'Brougham', 1),
(141, 'Cadillac', 'CT6', 1),
(142, 'Cadillac', 'Cts', 1),
(143, 'Cadillac', 'DTS', 1),
(144, 'Cadillac', 'Deville', 1),
(145, 'Cadillac', 'Eldorado', 1),
(146, 'Cadillac', 'Escalade', 1),
(147, 'Cadillac', 'Fleetwood', 1),
(148, 'Cadillac', 'STS', 1),
(149, 'Cadillac', 'Seville', 1),
(150, 'Cadillac', 'Srx', 1),
(151, 'Cadillac', 'XT4', 1),
(152, 'Cadillac', 'XT5', 1),
(153, 'Cadillac', 'XTS', 1),
(154, 'Cadillac', 'Xlr', 1),
(155, 'Chevrolet', 'Alero', 1),
(156, 'Chevrolet', 'Astro', 1),
(157, 'Chevrolet', 'Avalanche', 1),
(158, 'Chevrolet', 'Aveo', 1),
(159, 'Chevrolet', 'Blazer', 1),
(160, 'Chevrolet', 'Bolt', 1),
(161, 'Chevrolet', 'Camaro', 1),
(162, 'Chevrolet', 'Caprice', 1),
(163, 'Chevrolet', 'Captiva', 1),
(164, 'Chevrolet', 'Cavalier', 1),
(165, 'Chevrolet', 'Colorado', 1),
(166, 'Chevrolet', 'Corvette', 1),
(167, 'Chevrolet', 'Cruze', 1),
(168, 'Chevrolet', 'ElCamino', 1),
(169, 'Chevrolet', 'Epica', 1),
(170, 'Chevrolet', 'Equinox', 1),
(171, 'Chevrolet', 'Evanda', 1),
(172, 'Chevrolet', 'Gmc', 1),
(173, 'Chevrolet', 'Hhr', 1),
(174, 'Chevrolet', 'Impala', 1),
(175, 'Chevrolet', 'Kalos', 1),
(176, 'Chevrolet', 'Lacetti', 1),
(177, 'Chevrolet', 'Malibu', 1),
(178, 'Chevrolet', 'Matiz', 1),
(179, 'Chevrolet', 'Nova', 1),
(180, 'Chevrolet', 'Nubira', 1),
(181, 'Chevrolet', 'Orlando', 1),
(182, 'Chevrolet', 'Rezzo', 1),
(183, 'Chevrolet', 'Silverado', 1),
(184, 'Chevrolet', 'Spark', 1),
(185, 'Chevrolet', 'Suburban', 1),
(186, 'Chevrolet', 'Tacuma', 1),
(187, 'Chevrolet', 'Tahoe', 1),
(188, 'Chevrolet', 'Trailblazer', 1),
(189, 'Chevrolet', 'Transport', 1),
(190, 'Chevrolet', 'Trax', 1),
(191, 'Chevrolet', 'Volt', 1),
(192, 'Chrysler', '200', 1),
(193, 'Chrysler', '300c', 1),
(194, 'Chrysler', '300m', 1),
(195, 'Chrysler', 'Crossfire', 1),
(196, 'Chrysler', 'Gr.voyager', 1),
(197, 'Chrysler', 'Grand Cherokee', 1),
(198, 'Chrysler', 'Gts', 1),
(199, 'Chrysler', 'Neon', 1),
(200, 'Chrysler', 'Pacifica', 1),
(201, 'Chrysler', 'Pt cruiser', 1),
(202, 'Chrysler', 'Sebring', 1),
(203, 'Chrysler', 'Stratus', 1),
(204, 'Chrysler', 'Town and Country', 1),
(205, 'Chrysler', 'Vision', 1),
(206, 'Chrysler', 'Voyager', 1),
(207, 'Citroen', 'Ami', 1),
(208, 'Citroen', 'Ax', 1),
(209, 'Citroen', 'Berlingo', 1),
(210, 'Citroen', 'C-Zero', 1),
(211, 'Citroen', 'C-Crosser', 1),
(212, 'Citroen', 'C-Elysee', 1),
(213, 'Citroen', 'C1', 1),
(214, 'Citroen', 'C2', 1),
(215, 'Citroen', 'C3', 1),
(216, 'Citroen', 'C3 Aircross', 1),
(217, 'Citroen', 'C3 Picasso', 1),
(218, 'Citroen', 'C3 pluriel', 1),
(219, 'Citroen', 'C4', 1),
(220, 'Citroen', 'C4 AIRCROSS', 1),
(221, 'Citroen', 'C4 Cactus', 1),
(222, 'Citroen', 'C4 Picasso', 1),
(223, 'Citroen', 'C4X', 1),
(224, 'Citroen', 'C5', 1),
(225, 'Citroen', 'C5 Aircross', 1),
(226, 'Citroen', 'C5X', 1),
(227, 'Citroen', 'C6', 1),
(228, 'Citroen', 'C8', 1),
(229, 'Citroen', 'Cx', 1),
(230, 'Citroen', 'Evasion', 1),
(231, 'Citroen', 'Grand C4 Picasso', 1),
(232, 'Citroen', 'Jumpy', 1),
(233, 'Citroen', 'Nemo', 1),
(234, 'Citroen', 'Citroën Saxo', 1),
(235, 'Citroen', 'Spacetourer', 1),
(236, 'Citroen', 'Xantia', 1),
(237, 'Citroen', 'Xm', 1),
(238, 'Citroen', 'Xsara', 1),
(239, 'Citroen', 'Xsara picasso', 1),
(240, 'Citroen', 'Zx', 1),
(241, 'Cupra', 'Ateca', 1),
(242, 'Cupra', 'Born', 1),
(243, 'Cupra', 'Formentor', 1),
(244, 'Cupra', 'Leon', 1),
(245, 'DS', '3', 1),
(246, 'DS', '4', 1),
(247, 'DS', '5', 1),
(248, 'DS', '7', 1),
(249, 'DS', '9', 1),
(250, 'DS', '3 Crossback', 1),
(251, 'DS', '4 Crossback', 1),
(252, 'DS', '7 Crossback', 1),
(253, 'Dacia', '1100', 1),
(254, 'Dacia', '1310', 1),
(255, 'Dacia', 'Dokker', 1),
(256, 'Dacia', 'Duster', 1),
(257, 'Dacia', 'Jogger', 1),
(258, 'Dacia', 'Lodgy', 1),
(259, 'Dacia', 'Logan', 1),
(260, 'Dacia', 'Pickup', 1),
(261, 'Dacia', 'Sandero', 1),
(262, 'Dacia', 'Spring', 1),
(263, 'Daewoo', 'Espero', 1),
(264, 'Daewoo', 'Evanda', 1),
(265, 'Daewoo', 'Fso', 1),
(266, 'Daewoo', 'Kalos', 1),
(267, 'Daewoo', 'Korando', 1),
(268, 'Daewoo', 'Lacetti', 1),
(269, 'Daewoo', 'Lanos', 1),
(270, 'Daewoo', 'Matiz', 1),
(271, 'Daewoo', 'Musso', 1),
(272, 'Daewoo', 'Nexia', 1),
(273, 'Daewoo', 'Nubira', 1),
(274, 'Daewoo', 'Tacuma', 1),
(275, 'Daihatsu', 'Applause', 1),
(276, 'Daihatsu', 'Copen', 1),
(277, 'Daihatsu', 'Cuore', 1),
(278, 'Daihatsu', 'Feroza', 1),
(279, 'Daihatsu', 'Gran move', 1),
(280, 'Daihatsu', 'Materia', 1),
(281, 'Daihatsu', 'Move', 1),
(282, 'Daihatsu', 'Rocky', 1),
(283, 'Daihatsu', 'Sirion', 1),
(284, 'Daihatsu', 'Taft', 1),
(285, 'Daihatsu', 'Terios', 1),
(286, 'Daihatsu', 'Trevis', 1),
(287, 'Daihatsu', 'Yrv', 1),
(288, 'Dodge', 'Avenger', 1),
(289, 'Dodge', 'Caliber', 1),
(290, 'Dodge', 'Caravan', 1),
(291, 'Dodge', 'Challenger', 1),
(292, 'Dodge', 'Charger', 1),
(293, 'Dodge', 'Dakota', 1),
(294, 'Dodge', 'Dart', 1),
(295, 'Dodge', 'Durango', 1),
(296, 'Dodge', 'Journey', 1),
(297, 'Dodge', 'Magnum', 1),
(298, 'Dodge', 'Nitro', 1),
(299, 'Dodge', 'Ram 1500', 1),
(300, 'Dodge', 'RAM 2500', 1),
(301, 'Dodge', 'Ram', 1),
(302, 'Dodge', 'Stealth', 1),
(303, 'Dodge', 'Viper', 1),
(304, 'Ferrari', '296GTB', 1),
(305, 'Ferrari', '348', 1),
(306, 'Ferrari', '360 modena', 1),
(307, 'Ferrari', '458 Italia', 1),
(308, 'Ferrari', '488', 1),
(309, 'Ferrari', '812 GTS', 1),
(310, 'Ferrari', '812 Superfast', 1),
(311, 'Ferrari', 'California', 1),
(312, 'Ferrari', 'F12 berlinetta', 1),
(313, 'Ferrari', 'F430', 1),
(314, 'Ferrari', 'F8', 1),
(315, 'Ferrari', 'GTC4 Lusso', 1),
(316, 'Ferrari', 'LaFerrari', 1),
(317, 'Ferrari', 'Portofino', 1),
(318, 'Ferrari', 'Purosangue', 1),
(319, 'Ferrari', 'Roma', 1),
(320, 'Ferrari', 'SF90', 1),
(321, 'Ferrari', 'Testarossa', 1),
(322, 'Fiat', '1100', 1),
(323, 'Fiat', '124', 1),
(324, 'Fiat', '125', 1),
(325, 'Fiat', '126', 1),
(326, 'Fiat', '131', 1),
(327, 'Fiat', '1400', 1),
(328, 'Fiat', '500', 1),
(329, 'Fiat', '500L', 1),
(330, 'Fiat', '500X', 1),
(331, 'Fiat', '600', 1),
(332, 'Fiat', 'Barchetta', 1),
(333, 'Fiat', 'Brava', 1),
(334, 'Fiat', 'Bravo', 1),
(335, 'Fiat', 'Campagnola', 1),
(336, 'Fiat', 'Cinquecento', 1),
(337, 'Fiat', 'Coupe', 1),
(338, 'Fiat', 'Croma', 1),
(339, 'Fiat', 'Doblo', 1),
(340, 'Fiat', 'Fiorino', 1),
(341, 'Fiat', 'Freemont', 1),
(342, 'Fiat', 'Fullback', 1),
(343, 'Fiat', 'Idea', 1),
(344, 'Fiat', 'Linea', 1),
(345, 'Fiat', 'Marea', 1),
(346, 'Fiat', 'Multipla', 1),
(347, 'Fiat', 'Palio', 1),
(348, 'Fiat', 'Panda', 1),
(349, 'Fiat', 'Punto', 1),
(350, 'Fiat', 'Qubo', 1),
(351, 'Fiat', 'Ritmo', 1),
(352, 'Fiat', 'Scudo', 1),
(353, 'Fiat', 'Sedici', 1),
(354, 'Fiat', 'Seicento', 1),
(355, 'Fiat', 'Stilo', 1),
(356, 'Fiat', 'Strada', 1),
(357, 'Fiat', 'Tempra', 1),
(358, 'Fiat', 'Tipo', 1),
(359, 'Fiat', 'Ulysse', 1),
(360, 'Fiat', 'Uno', 1),
(361, 'Ford', '12m', 1),
(362, 'Ford', '17m', 1),
(363, 'Ford', '20m', 1),
(364, 'Ford', 'B-Max', 1),
(365, 'Ford', 'Bronco', 1),
(366, 'Ford', 'C-max', 1),
(367, 'Ford', 'Capri', 1),
(368, 'Ford', 'Connect', 1),
(369, 'Ford', 'Consul', 1),
(370, 'Ford', 'Cougar', 1),
(371, 'Ford', 'Courier', 1),
(372, 'Ford', 'Crown Victoria', 1),
(373, 'Ford', 'EcoSport', 1),
(374, 'Ford', 'Edge', 1),
(375, 'Ford', 'Escape', 1),
(376, 'Ford', 'Escort', 1),
(377, 'Ford', 'Excursion', 1),
(378, 'Ford', 'Expedition', 1),
(379, 'Ford', 'Explorer', 1),
(380, 'Ford', 'F150', 1),
(381, 'Ford', 'F250', 1),
(382, 'Ford', 'F350', 1),
(383, 'Ford', 'F450', 1),
(384, 'Ford', 'Fiesta', 1),
(385, 'Ford', 'Flex', 1),
(386, 'Ford', 'Focus', 1),
(387, 'Ford', 'Fusion', 1),
(388, 'Ford', 'Galaxy', 1),
(389, 'Ford', 'Granada', 1),
(390, 'Ford', 'Grand C-Max', 1),
(391, 'Ford', 'Ka', 1),
(392, 'Ford', 'Kuga', 1),
(393, 'Ford', 'Maverick', 1),
(394, 'Ford', 'Mondeo', 1),
(395, 'Ford', 'Mustang', 1),
(396, 'Ford', 'Orion', 1),
(397, 'Ford', 'Probe', 1),
(398, 'Ford', 'Puma', 1),
(399, 'Ford', 'Ranger', 1),
(400, 'Ford', 'Raptor', 1),
(401, 'Ford', 'S-Max', 1),
(402, 'Ford', 'Scorpio', 1),
(403, 'Ford', 'Sierra', 1),
(404, 'Ford', 'Sportka', 1),
(405, 'Ford', 'Streetka', 1),
(406, 'Ford', 'Taunus', 1),
(407, 'Ford', 'Thunderbird', 1),
(408, 'Genesis', 'G70', 1),
(409, 'Genesis', 'G80', 1),
(410, 'Genesis', 'G90', 1),
(411, 'Genesis', 'GV60', 1),
(412, 'Genesis', 'GV70', 1),
(413, 'Genesis', 'GV80', 1),
(414, 'GMC', 'Acadia', 1),
(415, 'GMC', 'Canyon', 1),
(416, 'GMC', 'Jimmy', 1),
(417, 'GMC', 'Savana', 1),
(418, 'GMC', 'Sierra', 1),
(419, 'GMC', 'Sonoma', 1),
(420, 'GMC', 'Terrain', 1),
(421, 'GMC', 'Yukon', 1),
(422, 'Great Wall', 'Haval H2', 1),
(423, 'Great Wall', 'Hover Cuv', 1),
(424, 'Great Wall', 'Hover H5', 1),
(425, 'Great Wall', 'Hover H6', 1),
(426, 'Great Wall', 'ORA 03', 1),
(427, 'Great Wall', 'Poer', 1),
(428, 'Great Wall', 'Steed 3', 1),
(429, 'Great Wall', 'Steed 5', 1),
(430, 'Great Wall', 'Steed 6', 1),
(431, 'Great Wall', 'Volex C10', 1),
(432, 'Great Wall', 'Volex C20', 1),
(433, 'Great Wall', 'Volex C30', 1),
(434, 'Honda', 'Accord', 1),
(435, 'Honda', 'City', 1),
(436, 'Honda', 'Civic', 1),
(437, 'Honda', 'Concerto', 1),
(438, 'Honda', 'Cr-v', 1),
(439, 'Honda', 'Crosstour', 1),
(440, 'Honda', 'Crx', 1),
(441, 'Honda', 'Crz', 1),
(442, 'Honda', 'Electric', 1),
(443, 'Honda', 'Element', 1),
(444, 'Honda', 'Fr-v', 1),
(445, 'Honda', 'Hr-v', 1),
(446, 'Honda', 'Insight', 1),
(447, 'Honda', 'Jazz', 1),
(448, 'Honda', 'Legend', 1),
(449, 'Honda', 'Logo', 1),
(450, 'Honda', 'Odyssey', 1),
(451, 'Honda', 'Pilot', 1),
(452, 'Honda', 'Prelude', 1),
(453, 'Honda', 'Ridgeline', 1),
(454, 'Honda', 'S2000', 1),
(455, 'Honda', 'Stream', 1),
(456, 'Honda', 'ZR-V', 1),
(457, 'Honda', 'e', 1),
(458, 'Honda', 'e:Ny1', 1),
(459, 'Hummer', 'H1', 1),
(460, 'Hummer', 'H2', 1),
(461, 'Hummer', 'H3', 1),
(462, 'Hyundai', 'Accent', 1),
(463, 'Hyundai', 'Atos', 1),
(464, 'Hyundai', 'Bayon', 1),
(465, 'Hyundai', 'Coupe', 1),
(466, 'Hyundai', 'Elantra', 1),
(467, 'Hyundai', 'Equus', 1),
(468, 'Hyundai', 'Galloper', 1),
(469, 'Hyundai', 'Genesis', 1),
(470, 'Hyundai', 'Getz', 1),
(471, 'Hyundai', 'Grandeur', 1),
(472, 'Hyundai', 'I10', 1),
(473, 'Hyundai', 'i20', 1),
(474, 'Hyundai', 'I30', 1),
(475, 'Hyundai', 'I40', 1),
(476, 'Hyundai', 'IX35', 1),
(477, 'Hyundai', 'IX55', 1),
(478, 'Hyundai', 'Ioniq', 1),
(479, 'Hyundai', 'Ioniq 5', 1),
(480, 'Hyundai', 'Ioniq 6', 1),
(481, 'Hyundai', 'Ix20', 1),
(482, 'Hyundai', 'Kona', 1),
(483, 'Hyundai', 'Lantra', 1),
(484, 'Hyundai', 'Matrix', 1),
(485, 'Hyundai', 'Palisade', 1),
(486, 'Hyundai', 'Santa fe', 1),
(487, 'Hyundai', 'Santamo', 1),
(488, 'Hyundai', 'Sonata', 1),
(489, 'Hyundai', 'Sonica', 1),
(490, 'Hyundai', 'Starex', 1),
(491, 'Hyundai', 'Staria', 1),
(492, 'Hyundai', 'Terracan', 1),
(493, 'Hyundai', 'Trajet', 1),
(494, 'Hyundai', 'Tucson', 1),
(495, 'Hyundai', 'Veloster', 1),
(496, 'Hyundai', 'Venue', 1),
(497, 'Hyundai', 'Xg', 1),
(498, 'Infiniti', 'Ex30', 1),
(499, 'Infiniti', 'Ex35', 1),
(500, 'Infiniti', 'Ex37', 1),
(501, 'Infiniti', 'Fx 30', 1),
(502, 'Infiniti', 'Fx 35', 1),
(503, 'Infiniti', 'Fx 37', 1),
(504, 'Infiniti', 'Fx 45', 1),
(505, 'Infiniti', 'FX50', 1),
(506, 'Infiniti', 'Fx45', 1),
(507, 'Infiniti', 'G', 1),
(508, 'Infiniti', 'G sedan', 1),
(509, 'Infiniti', 'G37', 1),
(510, 'Infiniti', 'M', 1),
(511, 'Infiniti', 'Q', 1),
(512, 'Infiniti', 'Q30', 1),
(513, 'Infiniti', 'Q50', 1),
(514, 'Infiniti', 'Q70', 1),
(515, 'Infiniti', 'QX30', 1),
(516, 'Infiniti', 'QX50', 1),
(517, 'Infiniti', 'QX56', 1),
(518, 'Infiniti', 'QX60', 1),
(519, 'Infiniti', 'QX70', 1),
(520, 'Infiniti', 'QX80', 1),
(521, 'Isuzu', 'D-max', 1),
(522, 'Isuzu', 'Pickup', 1),
(523, 'Isuzu', 'Rodeo', 1),
(524, 'Isuzu', 'Tfs', 1),
(525, 'Isuzu', 'Trooper', 1),
(526, 'Isuzu', 'Vehi cross', 1),
(527, 'Jaguar', 'Daimler', 1),
(528, 'Jaguar', 'E-pace', 1),
(529, 'Jaguar', 'F-PACE', 1),
(530, 'Jaguar', 'F-Type', 1),
(531, 'Jaguar', 'I-Pace', 1),
(532, 'Jaguar', 'S-type', 1),
(533, 'Jaguar', 'Sovereign', 1),
(534, 'Jaguar', 'X-type', 1),
(535, 'Jaguar', 'XE', 1),
(536, 'Jaguar', 'Xf', 1),
(537, 'Jaguar', 'Xj', 1),
(538, 'Jaguar', 'Xjr', 1),
(539, 'Jaguar', 'Xjs', 1),
(540, 'Jaguar', 'Xk8', 1),
(541, 'Jaguar', 'Xkr', 1),
(542, 'Jeep', 'Avenger', 1),
(543, 'Jeep', 'Cherokee', 1),
(544, 'Jeep', 'Commander', 1),
(545, 'Jeep', 'Compass', 1),
(546, 'Jeep', 'Grand Wagoneer', 1),
(547, 'Jeep', 'Grand Cherokee', 1),
(548, 'Jeep', 'Patriot', 1),
(549, 'Jeep', 'Renegade', 1),
(550, 'Jeep', 'Wrangler', 1),
(551, 'Kia', 'Avella delta', 1),
(552, 'Kia', 'Carens', 1),
(553, 'Kia', 'Carnival', 1),
(554, 'Kia', 'Ceed', 1),
(555, 'Kia', 'Cerato', 1),
(556, 'Kia', 'EV6', 1),
(557, 'Kia', 'EV9', 1),
(558, 'Kia', 'Forte', 1),
(559, 'Kia', 'Joyce', 1),
(560, 'Kia', 'K3', 1),
(561, 'Kia', 'K5', 1),
(562, 'Kia', 'K7', 1),
(563, 'Kia', 'K8', 1),
(564, 'Kia', 'K9', 1),
(565, 'Kia', 'Magentis', 1),
(566, 'Kia', 'Mohave', 1),
(567, 'Kia', 'Morning', 1),
(568, 'Kia', 'Niro', 1),
(569, 'Kia', 'Opirus', 1),
(570, 'Kia', 'Optima', 1),
(571, 'Kia', 'Picanto', 1),
(572, 'Kia', 'Pro ceed', 1),
(573, 'Kia', 'Rio', 1),
(574, 'Kia', 'Sedona', 1),
(575, 'Kia', 'Seltos', 1),
(576, 'Kia', 'Shuma', 1),
(577, 'Kia', 'Sorento', 1),
(578, 'Kia', 'Soul', 1),
(579, 'Kia', 'Sportage', 1),
(580, 'Kia', 'Stinger', 1),
(581, 'Kia', 'Stonic', 1),
(582, 'Kia', 'Telluride', 1),
(583, 'Kia', 'Venga', 1),
(584, 'Kia', 'XCeed', 1),
(585, 'Lamborghini', 'Aventador', 1),
(586, 'Lamborghini', 'Gallardo', 1),
(587, 'Lamborghini', 'Huracan', 1),
(588, 'Lamborghini', 'Urus', 1),
(589, 'Lancia', 'A112', 1),
(590, 'Lancia', 'Aurelia', 1),
(591, 'Lancia', 'Dedra', 1),
(592, 'Lancia', 'Delta', 1),
(593, 'Lancia', 'Flaminia', 1),
(594, 'Lancia', 'Kappa', 1),
(595, 'Lancia', 'Lybra', 1),
(596, 'Lancia', 'Musa', 1),
(597, 'Lancia', 'Phedra', 1),
(598, 'Lancia', 'Thema', 1),
(599, 'Lancia', 'Thesis', 1),
(600, 'Lancia', 'Voyager', 1),
(601, 'Lancia', 'Ypsilon', 1),
(602, 'Land Rover', 'Defender', 1),
(603, 'Land Rover', 'Discovery', 1),
(604, 'Land Rover', 'Evoque', 1),
(605, 'Land Rover', 'Freelander', 1),
(606, 'Land Rover', 'Range Rover Evoque', 1),
(607, 'Land Rover', 'Range Rover Sport', 1),
(608, 'Land Rover', 'Range Rover Velar', 1),
(609, 'Land Rover', 'Range Rover', 1),
(610, 'Lexus', 'CT', 1),
(611, 'Lexus', 'ES', 1),
(612, 'Lexus', 'GS', 1),
(613, 'Lexus', 'GX', 1),
(614, 'Lexus', 'IS', 1),
(615, 'Lexus', 'LBX', 1),
(616, 'Lexus', 'LC', 1),
(617, 'Lexus', 'LS', 1),
(618, 'Lexus', 'LX', 1),
(619, 'Lexus', 'NX', 1),
(620, 'Lexus', 'RC', 1),
(621, 'Lexus', 'RX', 1),
(622, 'Lexus', 'SC', 1),
(623, 'Lexus', 'UX', 1),
(624, 'Lincoln', 'Continental', 1),
(625, 'Lincoln', 'Ls', 1),
(626, 'Lincoln', 'MKC', 1),
(627, 'Lincoln', 'MKS', 1),
(628, 'Lincoln', 'Mark Lt', 1),
(629, 'Lincoln', 'Mkx', 1),
(630, 'Lincoln', 'Mkz', 1),
(631, 'Lincoln', 'Navigator', 1),
(632, 'Lincoln', 'Town car', 1),
(633, 'Maserati', 'Ghibli', 1),
(634, 'Maserati', 'GranCabrio', 1),
(635, 'Maserati', 'GranTurismo', 1),
(636, 'Maserati', 'Grecale', 1),
(637, 'Maserati', 'Levante', 1),
(638, 'Maserati', 'MC20', 1),
(639, 'Maserati', 'Quattroporte', 1),
(640, 'Maybach', '57', 1),
(641, 'Maybach', '62', 1),
(642, 'Maybach', '650', 1),
(643, 'Maybach', 'S 560', 1),
(644, 'Maybach', 'S580', 1),
(645, 'Mazda', '2', 1),
(646, 'Mazda', '3', 1),
(647, 'Mazda', '5', 1),
(648, 'Mazda', '6', 1),
(649, 'Mazda', '121', 1),
(650, 'Mazda', '323', 1),
(651, 'Mazda', '626', 1),
(652, 'Mazda', '929', 1),
(653, 'Mazda', 'B2500', 1),
(654, 'Mazda', 'BT-50', 1),
(655, 'Mazda', 'CX-3', 1),
(656, 'Mazda', 'CX-30', 1),
(657, 'Mazda', 'CX-5', 1),
(658, 'Mazda', 'CX-60', 1),
(659, 'Mazda', 'CX-7', 1),
(660, 'Mazda', 'CX-9', 1),
(661, 'Mazda', 'Demio', 1),
(662, 'Mazda', 'Mpv', 1),
(663, 'Mazda', 'Mx-3', 1),
(664, 'Mazda', 'MX-30', 1),
(665, 'Mazda', 'Mx-5', 1),
(666, 'Mazda', 'Mx-6', 1),
(667, 'Mazda', 'Premacy', 1),
(668, 'Mazda', 'Tribute', 1),
(669, 'Mazda', 'Xedos', 1),
(670, 'Mercedes-Benz', 'A', 1),
(671, 'Mercedes-Benz', 'B', 1),
(672, 'Mercedes-Benz', 'C', 1),
(673, 'Mercedes-Benz', 'CL', 1),
(674, 'Mercedes-Benz', 'CLA', 1),
(675, 'Mercedes-Benz', 'CLC', 1),
(676, 'Mercedes-Benz', 'CLE', 1),
(677, 'Mercedes-Benz', 'CLK', 1),
(678, 'Mercedes-Benz', 'CLS', 1),
(679, 'Mercedes-Benz', 'E', 1),
(680, 'Mercedes-Benz', 'EQA', 1),
(681, 'Mercedes-Benz', 'EQB', 1),
(682, 'Mercedes-Benz', 'EQC', 1),
(683, 'Mercedes-Benz', 'EQE', 1),
(684, 'Mercedes-Benz', 'EQS', 1),
(685, 'Mercedes-Benz', 'EQV', 1),
(686, 'Mercedes-Benz', 'G', 1),
(687, 'Mercedes-Benz', 'GL', 1),
(688, 'Mercedes-Benz', 'GL', 1),
(689, 'Mercedes-Benz', 'GLA', 1),
(690, 'Mercedes-Benz', 'GLB', 1),
(691, 'Mercedes-Benz', 'GLC', 1),
(692, 'Mercedes-Benz', 'GLE', 1),
(693, 'Mercedes-Benz', 'GLK', 1),
(694, 'Mercedes-Benz', 'GLS', 1),
(695, 'Mercedes-Benz', 'GT', 1),
(696, 'Mercedes-Benz', 'ML', 1),
(697, 'Mercedes-Benz', 'Maybach', 1),
(698, 'Mercedes-Benz', 'R', 1),
(699, 'Mercedes-Benz', 'S', 1),
(700, 'Mercedes-Benz', 'SL', 1),
(701, 'Mercedes-Benz', 'SLC', 1),
(702, 'Mercedes-Benz', 'SLK', 1),
(703, 'Mercedes-Benz', 'T', 1),
(704, 'Mercedes-Benz', 'V', 1),
(705, 'Mercedes-Benz', 'Vaneo', 1),
(706, 'Mercedes-Benz', 'Viano', 1),
(707, 'Mercedes-Benz', 'X', 1),
(708, 'MG', 'MG4', 1),
(709, 'MG', 'Marvel R', 1),
(710, 'MG', 'Mgb', 1),
(711, 'MG', 'Mgf', 1),
(712, 'MG', 'ZS EV', 1),
(713, 'MG', 'Zr', 1),
(714, 'MG', 'Zs', 1),
(715, 'Mini', 'Clubman', 1),
(716, 'Mini', 'Cooper', 1),
(717, 'Mini', 'Cooper cabrio', 1),
(718, 'Mini', 'Cooper s', 1),
(719, 'Mini', 'Cooper s cabrio', 1),
(720, 'Mini', 'Countryman', 1),
(721, 'Mini', 'Coupe', 1),
(722, 'Mini', 'D one', 1),
(723, 'Mini', 'John Cooper Works', 1),
(724, 'Mini', 'One', 1),
(725, 'Mini', 'One cabrio', 1),
(726, 'Mini', 'Paceman', 1),
(727, 'Mitsubishi', '3000 gt', 1),
(728, 'Mitsubishi', 'ASX', 1),
(729, 'Mitsubishi', 'Carisma', 1),
(730, 'Mitsubishi', 'Colt', 1),
(731, 'Mitsubishi', 'Eclipse', 1),
(732, 'Mitsubishi', 'Eclipse Cross', 1),
(733, 'Mitsubishi', 'Galant', 1),
(734, 'Mitsubishi', 'Grandis', 1),
(735, 'Mitsubishi', 'I-MiEV', 1),
(736, 'Mitsubishi', 'L200', 1),
(737, 'Mitsubishi', 'Lancer', 1),
(738, 'Mitsubishi', 'Mirage', 1),
(739, 'Mitsubishi', 'Outlander', 1),
(740, 'Mitsubishi', 'Pajero', 1),
(741, 'Mitsubishi', 'Pajero pinin', 1),
(742, 'Mitsubishi', 'Pajero sport', 1),
(743, 'Mitsubishi', 'RVR', 1),
(744, 'Mitsubishi', 'Space gear', 1),
(745, 'Mitsubishi', 'Space runner', 1),
(746, 'Mitsubishi', 'Space star', 1),
(747, 'Mitsubishi', 'Space wagon', 1),
(748, 'Mitsubishi', 'Starion', 1),
(749, 'Nissan', '100 nx', 1),
(750, 'Nissan', '200 sx', 1),
(751, 'Nissan', '280 z', 1),
(752, 'Nissan', '300 zx', 1),
(753, 'Nissan', '350z', 1),
(754, 'Nissan', '370Z', 1),
(755, 'Nissan', 'Almera', 1),
(756, 'Nissan', 'Almera tino', 1),
(757, 'Nissan', 'Altima', 1),
(758, 'Nissan', 'Ariya', 1),
(759, 'Nissan', 'Armada', 1),
(760, 'Nissan', 'Bluebird', 1),
(761, 'Nissan', 'Cube', 1),
(762, 'Nissan', 'Frontier', 1),
(763, 'Nissan', 'Gt-r', 1),
(764, 'Nissan', 'Juke', 1),
(765, 'Nissan', 'Kubistar', 1),
(766, 'Nissan', 'Leaf', 1),
(767, 'Nissan', 'Maxima', 1),
(768, 'Nissan', 'Micra', 1),
(769, 'Nissan', 'Murano', 1),
(770, 'Nissan', 'Navara', 1),
(771, 'Nissan', 'Note', 1),
(772, 'Nissan', 'Pathfinder', 1),
(773, 'Nissan', 'Patrol', 1),
(774, 'Nissan', 'Pickup', 1),
(775, 'Nissan', 'Pixo', 1),
(776, 'Nissan', 'Primera', 1),
(777, 'Nissan', 'Pulsar', 1),
(778, 'Nissan', 'Qashqai', 1),
(779, 'Nissan', 'Quest', 1),
(780, 'Nissan', 'Rogue', 1),
(781, 'Nissan', 'Sentra', 1),
(782, 'Nissan', 'Serena', 1),
(783, 'Nissan', 'Silvia', 1),
(784, 'Nissan', 'Sunny', 1),
(785, 'Nissan', 'Terrano', 1),
(786, 'Nissan', 'Tiida', 1),
(787, 'Nissan', 'Titan crew cab', 1),
(788, 'Nissan', 'Titan king', 1),
(789, 'Nissan', 'X-trail', 1),
(790, 'Nissan', 'Xterra', 1),
(791, 'Nissan', 'e-NV200', 1),
(792, 'Opel', 'Adam', 1),
(793, 'Opel', 'Admiral', 1),
(794, 'Opel', 'Agila', 1),
(795, 'Opel', 'Ampera', 1),
(796, 'Opel', 'Antara', 1),
(797, 'Opel', 'Ascona', 1),
(798, 'Opel', 'Astra', 1),
(799, 'Opel', 'Calibra', 1),
(800, 'Opel', 'Campo', 1),
(801, 'Opel', 'Cascada', 1),
(802, 'Opel', 'Combo', 1),
(803, 'Opel', 'Commodore', 1),
(804, 'Opel', 'Corsa', 1),
(805, 'Opel', 'Crossland X', 1),
(806, 'Opel', 'Frontera', 1),
(807, 'Opel', 'Grandland X', 1),
(808, 'Opel', 'Gt', 1),
(809, 'Opel', 'Insignia', 1),
(810, 'Opel', 'Kadett', 1),
(811, 'Opel', 'Kapitaen', 1),
(812, 'Opel', 'Karl', 1),
(813, 'Opel', 'Manta', 1),
(814, 'Opel', 'Meriva', 1),
(815, 'Opel', 'Mokka', 1),
(816, 'Opel', 'Mokka X', 1),
(817, 'Opel', 'Monterey', 1),
(818, 'Opel', 'Omega', 1),
(819, 'Opel', 'Rekord', 1),
(820, 'Opel', 'Senator', 1),
(821, 'Opel', 'Signum', 1),
(822, 'Opel', 'Sintra', 1),
(823, 'Opel', 'Tigra', 1),
(824, 'Opel', 'Vectra', 1),
(825, 'Opel', 'Zafira', 1),
(826, 'Peugeot', '1007', 1),
(827, 'Peugeot', '106', 1),
(828, 'Peugeot', '107', 1),
(829, 'Peugeot', '108', 1),
(830, 'Peugeot', '2008', 1),
(831, 'Peugeot', '205', 1),
(832, 'Peugeot', '206', 1),
(833, 'Peugeot', '207', 1),
(834, 'Peugeot', '208', 1),
(835, 'Peugeot', '3008', 1),
(836, 'Peugeot', '301', 1),
(837, 'Peugeot', '306', 1),
(838, 'Peugeot', '307', 1),
(839, 'Peugeot', '308', 1),
(840, 'Peugeot', '309', 1),
(841, 'Peugeot', '4007', 1),
(842, 'Peugeot', '4008', 1),
(843, 'Peugeot', '403', 1),
(844, 'Peugeot', '404', 1),
(845, 'Peugeot', '405', 1),
(846, 'Peugeot', '406', 1),
(847, 'Peugeot', '407', 1),
(848, 'Peugeot', '408', 1),
(849, 'Peugeot', '5008', 1),
(850, 'Peugeot', '508', 1),
(851, 'Peugeot', '604', 1),
(852, 'Peugeot', '605', 1),
(853, 'Peugeot', '607', 1),
(854, 'Peugeot', '806', 1),
(855, 'Peugeot', '807', 1),
(856, 'Peugeot', 'Bipper', 1),
(857, 'Peugeot', 'Expert', 1),
(858, 'Peugeot', 'Partner', 1),
(859, 'Peugeot', 'RCZ', 1),
(860, 'Peugeot', 'Range', 1),
(861, 'Peugeot', 'Rifter', 1),
(862, 'Peugeot', 'Traveler', 1),
(863, 'Peugeot', 'iOn', 1),
(864, 'Porsche', '911', 1),
(865, 'Porsche', '928', 1),
(866, 'Porsche', '944', 1),
(867, 'Porsche', '991', 1),
(868, 'Porsche', 'Boxster', 1),
(869, 'Porsche', 'Carrera', 1),
(870, 'Porsche', 'Cayenne', 1),
(871, 'Porsche', 'Cayman', 1),
(872, 'Porsche', 'Macan', 1),
(873, 'Porsche', 'Panamera', 1),
(874, 'Porsche', 'Taycan', 1),
(875, 'Renault', '11', 1),
(876, 'Renault', '16', 1),
(877, 'Renault', '18', 1),
(878, 'Renault', '19', 1),
(879, 'Renault', '20', 1),
(880, 'Renault', '21', 1),
(881, 'Renault', '25', 1),
(882, 'Renault', '4', 1),
(883, 'Renault', '5', 1),
(884, 'Renault', '8', 1),
(885, 'Renault', '9', 1),
(886, 'Renault', 'Alpine', 1),
(887, 'Renault', 'Arkana', 1),
(888, 'Renault', 'Austral', 1),
(889, 'Renault', 'Bulgar', 1),
(890, 'Renault', 'Captur', 1),
(891, 'Renault', 'Chamade', 1),
(892, 'Renault', 'Clio', 1),
(893, 'Renault', 'Espace', 1),
(894, 'Renault', 'Express', 1),
(895, 'Renault', 'Fluence', 1),
(896, 'Renault', 'Grand espace', 1),
(897, 'Renault', 'Grand scenic', 1),
(898, 'Renault', 'Kadjar', 1),
(899, 'Renault', 'Kangoo', 1),
(900, 'Renault', 'Koleos', 1),
(901, 'Renault', 'Laguna', 1),
(902, 'Renault', 'Laguna Coupe', 1),
(903, 'Renault', 'Latitude', 1),
(904, 'Renault', 'Megane', 1),
(905, 'Renault', 'Modus', 1),
(906, 'Renault', 'Safrane', 1),
(907, 'Renault', 'Scenic', 1),
(908, 'Renault', 'Scenic rx4', 1),
(909, 'Renault', 'Symbol', 1),
(910, 'Renault', 'Talisman', 1),
(911, 'Renault', 'Twingo', 1),
(912, 'Renault', 'Twizy', 1),
(913, 'Renault', 'Vel satis', 1),
(914, 'Renault', 'Wind', 1),
(915, 'Renault', 'Zoe', 1),
(916, 'Rolls-Royce', 'Cullinan', 1),
(917, 'Rolls-Royce', 'Dawn', 1),
(918, 'Rolls-Royce', 'Ghost', 1),
(919, 'Rolls-Royce', 'Phantom', 1),
(920, 'Rolls-Royce', 'Silver Cloud', 1),
(921, 'Rolls-Royce', 'Silver Seraph', 1),
(922, 'Rolls-Royce', 'Silver Spur', 1),
(923, 'Rolls-Royce', 'Wraith', 1),
(924, 'Seat', 'Alhambra', 1),
(925, 'Seat', 'Altea', 1),
(926, 'Seat', 'Arona', 1),
(927, 'Seat', 'Arosa', 1),
(928, 'Seat', 'Ateca', 1),
(929, 'Seat', 'Cordoba', 1),
(930, 'Seat', 'Cupra', 1),
(931, 'Seat', 'Exeo', 1),
(932, 'Seat', 'Ibiza', 1),
(933, 'Seat', 'Inka', 1),
(934, 'Seat', 'Leon', 1),
(935, 'Seat', 'Mii', 1),
(936, 'Seat', 'Tarraco', 1),
(937, 'Seat', 'Toledo', 1),
(938, 'Seat', 'Vario', 1),
(939, 'Skoda', '100', 1),
(940, 'Skoda', '1000', 1),
(941, 'Skoda', '105', 1),
(942, 'Skoda', '120', 1),
(943, 'Skoda', 'Citigo', 1),
(944, 'Skoda', 'Enyaq', 1),
(945, 'Skoda', 'Fabia', 1),
(946, 'Skoda', 'Favorit', 1),
(947, 'Skoda', 'Felicia', 1),
(948, 'Skoda', 'Kamiq', 1),
(949, 'Skoda', 'Karoq', 1),
(950, 'Skoda', 'Kodiaq', 1),
(951, 'Skoda', 'Octavia', 1),
(952, 'Skoda', 'Praktik', 1),
(953, 'Skoda', 'Rapid', 1),
(954, 'Skoda', 'Roomster', 1),
(955, 'Skoda', 'Scala', 1),
(956, 'Skoda', 'Superb', 1),
(957, 'Skoda', 'Yeti', 1),
(958, 'Smart', 'Forfour', 1),
(959, 'Smart', 'Fortwo', 1),
(960, 'Smart', 'Mc', 1),
(961, 'Smart', 'Roadster', 1),
(962, 'SsangYong', 'Chairman', 1),
(963, 'SsangYong', 'Rodius', 1),
(964, 'SsangYong', 'Actyon', 1),
(965, 'SsangYong', 'Actyon Sports', 1),
(966, 'SsangYong', 'Korando', 1),
(967, 'SsangYong', 'Kyron', 1),
(968, 'SsangYong', 'Musso', 1),
(969, 'SsangYong', 'Rexton', 1),
(970, 'SsangYong', 'Tivoli', 1),
(971, 'SsangYong', 'XLV', 1),
(972, 'Subaru', 'Ascent', 1),
(973, 'Subaru', 'B10 Tribeka', 1),
(974, 'Subaru', 'B9 tribeca', 1),
(975, 'Subaru', 'BRZ', 1),
(976, 'Subaru', 'Baja', 1),
(977, 'Subaru', 'Forester', 1),
(978, 'Subaru', 'G3x justy', 1),
(979, 'Subaru', 'Impreza', 1),
(980, 'Subaru', 'Justy', 1),
(981, 'Subaru', 'Legacy', 1),
(982, 'Subaru', 'Levorg', 1),
(983, 'Subaru', 'Libero', 1),
(984, 'Subaru', 'Outback', 1),
(985, 'Subaru', 'Solterra', 1),
(986, 'Subaru', 'Svx', 1),
(987, 'Subaru', 'Trezia', 1),
(988, 'Subaru', 'Vivio', 1),
(989, 'Subaru', 'XV', 1),
(990, 'Suzuki', 'Across', 1),
(991, 'Suzuki', 'Alto', 1),
(992, 'Suzuki', 'Baleno', 1),
(993, 'Suzuki', 'Celerio', 1),
(994, 'Suzuki', 'Grand vitara', 1),
(995, 'Suzuki', 'Ignis', 1),
(996, 'Suzuki', 'Jimny', 1),
(997, 'Suzuki', 'Kizashi', 1),
(998, 'Suzuki', 'Liana', 1),
(999, 'Suzuki', 'SX4', 1),
(1000, 'Suzuki', 'SX4 S-Cross', 1),
(1001, 'Suzuki', 'Samurai', 1),
(1002, 'Suzuki', 'Splash', 1),
(1003, 'Suzuki', 'Swace', 1),
(1004, 'Suzuki', 'Swift', 1),
(1005, 'Suzuki', 'Vitara', 1),
(1006, 'Suzuki', 'Wagon r', 1),
(1007, 'Suzuki', 'X-90', 1),
(1008, 'Suzuki', 'XL-7', 1),
(1009, 'Tesla', 'Cybertruck', 1),
(1010, 'Tesla', 'Model 3', 1),
(1011, 'Tesla', 'Model S', 1),
(1012, 'Tesla', 'Model X', 1),
(1013, 'Tesla', 'Model Y', 1),
(1014, 'Tesla', 'Roadster Sport', 1),
(1015, 'Toyota', '4runner', 1),
(1016, 'Toyota', 'Auris', 1),
(1017, 'Toyota', 'Avalon', 1),
(1018, 'Toyota', 'Avensis', 1),
(1019, 'Toyota', 'Avensis verso', 1),
(1020, 'Toyota', 'Aygo', 1),
(1021, 'Toyota', 'C-HR', 1),
(1022, 'Toyota', 'Camry', 1),
(1023, 'Toyota', 'Carina', 1),
(1024, 'Toyota', 'Celica', 1),
(1025, 'Toyota', 'Corolla', 1),
(1026, 'Toyota', 'Corolla Cross', 1),
(1027, 'Toyota', 'Corolla verso', 1),
(1028, 'Toyota', 'Fj cruiser', 1),
(1029, 'Toyota', 'GT86', 1),
(1030, 'Toyota', 'Harrier', 1),
(1031, 'Toyota', 'Highlander', 1),
(1032, 'Toyota', 'Hilux', 1),
(1033, 'Toyota', 'IQ', 1),
(1034, 'Toyota', 'Land cruiser', 1),
(1035, 'Toyota', 'Mr2', 1),
(1036, 'Toyota', 'Paseo', 1),
(1037, 'Toyota', 'Picnic', 1),
(1038, 'Toyota', 'Previa', 1),
(1039, 'Toyota', 'Prius', 1),
(1040, 'Toyota', 'Proace City', 1),
(1041, 'Toyota', 'Proace City Verso', 1),
(1042, 'Toyota', 'Rav4', 1),
(1043, 'Toyota', 'Scion', 1),
(1044, 'Toyota', 'Sequoia', 1),
(1045, 'Toyota', 'Sienna', 1),
(1046, 'Toyota', 'Starlet', 1),
(1047, 'Toyota', 'Suarer', 1),
(1048, 'Toyota', 'Supra', 1),
(1049, 'Toyota', 'Tacoma', 1),
(1050, 'Toyota', 'Tercel', 1),
(1051, 'Toyota', 'Tundra', 1),
(1052, 'Toyota', 'Urban Cruiser', 1),
(1053, 'Toyota', 'Venza', 1),
(1054, 'Toyota', 'Verso', 1),
(1055, 'Toyota', 'Verso S', 1),
(1056, 'Toyota', 'Yaris', 1),
(1057, 'Toyota', 'Yaris Cross', 1),
(1058, 'Toyota', 'Yaris verso', 1),
(1059, 'Toyota', 'bZ4X', 1),
(1060, 'VW', '1200', 1),
(1061, 'VW', '1300', 1),
(1062, 'VW', '1303', 1),
(1063, 'VW', '1600', 1),
(1064, 'VW', 'Alltrack', 1),
(1065, 'VW', 'Amarok', 1),
(1066, 'VW', 'Arteon', 1),
(1067, 'VW', 'Atlas', 1),
(1068, 'VW', 'Beetle', 1),
(1069, 'VW', 'Bora', 1),
(1070, 'VW', 'CC', 1),
(1071, 'VW', 'Caddy', 1),
(1072, 'VW', 'Corrado', 1),
(1073, 'VW', 'Eos', 1),
(1074, 'VW', 'Fox', 1),
(1075, 'VW', 'Golf', 1),
(1076, 'VW', 'Golf Plus', 1),
(1077, 'VW', 'Golf Variant', 1),
(1078, 'VW', 'ID.3', 1),
(1079, 'VW', 'ID.4', 1),
(1080, 'VW', 'ID.5', 1),
(1081, 'VW', 'ID.6', 1),
(1082, 'VW', 'ID.7', 1),
(1083, 'VW', 'ID.Buzz', 1),
(1084, 'VW', 'Jetta', 1),
(1085, 'VW', 'Karmann-ghia', 1),
(1086, 'VW', 'Lupo', 1),
(1087, 'VW', 'Multivan', 1),
(1088, 'VW', 'New beetle', 1),
(1089, 'VW', 'Passat', 1),
(1090, 'VW', 'Phaeton', 1),
(1091, 'VW', 'Polo', 1),
(1092, 'VW', 'Scirocco', 1),
(1093, 'VW', 'Sharan', 1),
(1094, 'VW', 'Sportsvan', 1),
(1095, 'VW', 'T-Cross', 1),
(1096, 'VW', 'T-Roc', 1),
(1097, 'VW', 'Taigo', 1),
(1098, 'VW', 'Taro', 1),
(1099, 'VW', 'Tiguan', 1),
(1100, 'VW', 'Touareg', 1),
(1101, 'VW', 'Touran', 1),
(1102, 'VW', 'Up', 1),
(1103, 'VW', 'Vento', 1),
(1104, 'Volvo', '144', 1),
(1105, 'Volvo', '1800 es', 1),
(1106, 'Volvo', '244', 1),
(1107, 'Volvo', '744', 1),
(1108, 'Volvo', '760', 1),
(1109, 'Volvo', '850', 1),
(1110, 'Volvo', '940', 1),
(1111, 'Volvo', '960', 1),
(1112, 'Volvo', 'C30', 1),
(1113, 'Volvo', 'C40', 1),
(1114, 'Volvo', 'C70', 1),
(1115, 'Volvo', 'S40', 1),
(1116, 'Volvo', 'S60', 1),
(1117, 'Volvo', 'S70', 1),
(1118, 'Volvo', 'S80', 1),
(1119, 'Volvo', 'S90', 1),
(1120, 'Volvo', 'V40', 1),
(1121, 'Volvo', 'V40 Cross Country', 1),
(1122, 'Volvo', 'V50', 1),
(1123, 'Volvo', 'V60', 1),
(1124, 'Volvo', 'V60 Cross Country', 1),
(1125, 'Volvo', 'V70', 1),
(1126, 'Volvo', 'V90', 1),
(1127, 'Volvo', 'V90 Cross Country', 1),
(1128, 'Volvo', 'XC40', 1),
(1129, 'Volvo', 'XC60', 1),
(1130, 'Volvo', 'Xc70', 1),
(1131, 'Volvo', 'Xc90', 1);

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

--
-- Structură tabel pentru tabel `car_status`
--

CREATE TABLE `car_status` (
  `id` int(11) NOT NULL,
  `status_name` varchar(20) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `car_status`
--

INSERT INTO `car_status` (`id`, `status_name`, `active`) VALUES
(-1, 'Publish rejected', 1),
(0, 'Draft', 1),
(1, 'Publish request', 1),
(3, 'Published', 1);

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

--
-- Structură tabel pentru tabel `company_contacts`
--

CREATE TABLE `company_contacts` (
  `id` int(11) NOT NULL,
  `contact_name` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `company_contacts`
--

INSERT INTO `company_contacts` (`id`, `contact_name`, `phone`, `email`) VALUES
(1, 'Radu Cezar Gheorgheza', '+359 879 655 188 ', ''),
(2, 'Albena Staneva  ', '+359 879 655 186 ', '');

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

--
-- Structură tabel pentru tabel `company_details`
--

CREATE TABLE `company_details` (
  `id` int(11) NOT NULL,
  `company_name` varchar(50) NOT NULL,
  `vat_code` varchar(20) NOT NULL,
  `address1` varchar(100) NOT NULL,
  `address2` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `website` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `company_details`
--

INSERT INTO `company_details` (`id`, `company_name`, `vat_code`, `address1`, `address2`, `phone`, `email`, `website`) VALUES
(1, 'Zadio EOOD', 'BG201209745', 'Ploshtad Han Kubrat 1', 'Ruse, Bulgaria', '+359879655188', 'cars@zadio.bg', 'cars.zadio.bg');

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

--
-- Structură tabel pentru tabel `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `country_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

--
-- Eliminarea datelor din tabel `country`
--

INSERT INTO `country` (`id`, `country_name`) VALUES
(1, 'Austria'),
(2, 'Belgium'),
(3, 'Bulgaria'),
(4, 'Croatia'),
(5, 'Cyprus'),
(6, 'Czechia'),
(7, 'Denmark'),
(8, 'Estonia'),
(9, 'Finland'),
(10, 'France'),
(11, 'Germany'),
(12, 'Greece'),
(13, 'Hungary'),
(14, 'Ireland'),
(15, 'Italy'),
(16, 'Latvia'),
(17, 'Lithuania'),
(18, 'Luxembourg'),
(19, 'Malta'),
(20, 'Netherlands'),
(21, 'Poland'),
(22, 'Portugal'),
(23, 'Romania'),
(24, 'Slovakia'),
(25, 'Slovenia'),
(26, 'Spain'),
(27, 'Sweden');

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

--
-- Structură tabel pentru tabel `district`
--

CREATE TABLE `district` (
  `id` int(11) NOT NULL,
  `district_name` varchar(50) CHARACTER SET utf16 COLLATE utf16_bin NOT NULL,
  `country` varchar(50) CHARACTER SET utf16 COLLATE utf16_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `district`
--

INSERT INTO `district` (`id`, `district_name`, `country`) VALUES
(1, 'Alba', 'Romania'),
(2, 'Arad', 'Romania'),
(3, 'Argeș', 'Romania'),
(4, 'Bacău', 'Romania'),
(5, 'Bihor', 'Romania'),
(6, 'Bistrița-Năsăud', 'Romania'),
(7, 'Botoșani', 'Romania'),
(8, 'Brașov', 'Romania'),
(9, 'Brăila', 'Romania'),
(10, 'București', 'Romania'),
(11, 'Buzău', 'Romania'),
(12, 'Caraș-Severin', 'Romania'),
(13, 'Călărași', 'Romania'),
(14, 'Cluj', 'Romania'),
(15, 'Constanța', 'Romania'),
(16, 'Covasna', 'Romania'),
(17, 'Dâmbovița', 'Romania'),
(18, 'Dolj', 'Romania'),
(19, 'Galați', 'Romania'),
(20, 'Giurgiu', 'Romania'),
(21, 'Gorj', 'Romania'),
(22, 'Harghita', 'Romania'),
(23, 'Hunedoara', 'Romania'),
(24, 'Ialomița', 'Romania'),
(25, 'Iași', 'Romania'),
(26, 'Ilfov', 'Romania'),
(27, 'Maramureș', 'Romania'),
(28, 'Mehedinți', 'Romania'),
(29, 'Mureș', 'Romania'),
(30, 'Neamț', 'Romania'),
(31, 'Olt', 'Romania'),
(32, 'Prahova', 'Romania'),
(33, 'Satu Mare', 'Romania'),
(34, 'Sălaj', 'Romania'),
(35, 'Sibiu', 'Romania'),
(36, 'Suceava', 'Romania'),
(37, 'Teleorman', 'Romania'),
(38, 'Timiș', 'Romania'),
(39, 'Tulcea', 'Romania'),
(40, 'Vaslui', 'Romania'),
(41, 'Vâlcea', 'Romania'),
(42, 'Vrancea', 'Romania'),
(43, 'Blagoevgrad', 'Bulgaria'),
(44, 'Burgas', 'Bulgaria'),
(45, 'Dobrich', 'Bulgaria'),
(46, 'Gabrovo', 'Bulgaria'),
(47, 'Haskovo', 'Bulgaria'),
(48, 'Kardzhali', 'Bulgaria'),
(49, 'Kyustendil', 'Bulgaria'),
(50, 'Lovech', 'Bulgaria'),
(51, 'Montana', 'Bulgaria'),
(52, 'Pazardzhik', 'Bulgaria'),
(53, 'Pernik', 'Bulgaria'),
(54, 'Pleven', 'Bulgaria'),
(55, 'Plovdiv', 'Bulgaria'),
(56, 'Razgrad', 'Bulgaria'),
(57, 'Ruse', 'Bulgaria'),
(58, 'Shumen', 'Bulgaria'),
(59, 'Silistra', 'Bulgaria'),
(60, 'Sliven', 'Bulgaria'),
(61, 'Smolyan', 'Bulgaria'),
(62, 'Sofia City', 'Bulgaria'),
(63, 'Sofia Region', 'Bulgaria'),
(64, 'Stara Zagora', 'Bulgaria'),
(65, 'Targovishte', 'Bulgaria'),
(66, 'Varna', 'Bulgaria'),
(67, 'Veliko Tarnovo', 'Bulgaria'),
(68, 'Vidin', 'Bulgaria'),
(69, 'Vratsa', 'Bulgaria'),
(70, 'Yambol', 'Bulgaria');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `lastname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `email` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `website` varchar(100) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `password` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `companyname` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `country` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `district` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `city` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `address` varchar(200) DEFAULT NULL,
  `vatnumber` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  `active` smallint(6) NOT NULL DEFAULT 0,
  `readonly` tinyint(4) NOT NULL DEFAULT 0,
  `seller` tinyint(4) NOT NULL DEFAULT 0,
  `buyer` tinyint(4) NOT NULL DEFAULT 0,
  `isadmin` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf16 COLLATE=utf16_bin;

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

INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `website`, `phone`, `password`, `companyname`, `country`, `district`, `city`, `address`, `vatnumber`, `created_at`, `updated_at`, `active`, `readonly`, `seller`, `buyer`, `isadmin`) VALUES
(1, 'Radu', 'Gheorgheza', 'office@zadio.bg', NULL, '+359879655188', '$2y$10$xCILxYKH.e/b2OLY1NP.RuN9DuGoM81UdX4XD.ZejB4AwA2.8BKPa', 'Zadio EOOD', 'Bulgaria', 'ruse', 'ruse', 'Ploshtad Han Kubrat 1', 'BG201209745', '2024-07-30 08:36:19', '2024-08-07 10:36:20', 1, 0, 1, 1, 1),
(2, 'Edward', 'Hermann', 'edi.hermann@lemonbyte.ro', 'www.test.ro', '+40744555555', '$2y$10$6INXH0ygyMWkv5.cvk413.HMIawUl.wc1NNFuvMpITRi.oQGKJTaS', 'Developer', 'Romania', 'București', 'Bucuresti', 'N. Oncesu, nr.  6', 'RO 19092110', '2024-07-21 00:01:35', '2024-08-19 21:00:34', 1, 0, 1, 1, 1),
(8, 'ron', 'fox', 'ronfox600@gmail.com', 'kaloni.bg', '+40712345678', '$2y$10$F3q1ffc8p4alpaNbQRz2/O5jYHlO8A2A3BT/mt2B.qoj3p6.R/oqO', 'RonFox', 'Romania', 'Ilfov', 'bucuresti', 'strada 1', 'ZA611x', '2024-08-07 10:40:15', '2024-08-22 11:49:48', 1, 0, 0, 0, 0),
(9, 'Oroviceanu', 'Ruxandra', 'Ruxys15@yahoo.com', '', '0735970550', '$2y$10$OfksF/fh7mayEOGDw1ng..2TY2BucLHeAte/cOyGYz1cPMghRVaCi', 'Bookurier', 'Romania', 'Ilfov', 'Bragadiru', 'Lacului', 'RO12345678', '2024-09-03 12:53:36', '2024-09-03 19:09:17', 1, 0, 1, 1, 0);

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

--
-- Structură tabel pentru tabel `user_msg`
--

CREATE TABLE `user_msg` (
  `id` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `subject` varchar(50) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Eliminarea datelor din tabel `user_msg`
--

INSERT INTO `user_msg` (`id`, `user`, `subject`, `msg`, `date_created`) VALUES
(1, 3, 'Welcome', 'Welcome to cars.zadio.bg!', '2024-08-04 13:17:43');

--
-- Indexuri pentru tabele eliminate
--

--
-- Indexuri pentru tabele `additionals_form`
--
ALTER TABLE `additionals_form`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `cars`
--
ALTER TABLE `cars`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ixCarCode` (`code`) USING BTREE;

--
-- Indexuri pentru tabele `cars_old`
--
ALTER TABLE `cars_old`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `cars_status`
--
ALTER TABLE `cars_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `car_additionals`
--
ALTER TABLE `car_additionals`
  ADD PRIMARY KEY (`car_code`);

--
-- Indexuri pentru tabele `car_brand`
--
ALTER TABLE `car_brand`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `car_images`
--
ALTER TABLE `car_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ixImgCarcode` (`car_code`);

--
-- Indexuri pentru tabele `car_model`
--
ALTER TABLE `car_model`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `car_status`
--
ALTER TABLE `car_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `company_contacts`
--
ALTER TABLE `company_contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `company_details`
--
ALTER TABLE `company_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `district`
--
ALTER TABLE `district`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- Indexuri pentru tabele `user_msg`
--
ALTER TABLE `user_msg`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pentru tabele eliminate
--

--
-- AUTO_INCREMENT pentru tabele `additionals_form`
--
ALTER TABLE `additionals_form`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pentru tabele `cars`
--
ALTER TABLE `cars`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT pentru tabele `cars_old`
--
ALTER TABLE `cars_old`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pentru tabele `cars_status`
--
ALTER TABLE `cars_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pentru tabele `car_brand`
--
ALTER TABLE `car_brand`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT pentru tabele `car_images`
--
ALTER TABLE `car_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT pentru tabele `car_model`
--
ALTER TABLE `car_model`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1132;

--
-- AUTO_INCREMENT pentru tabele `car_status`
--
ALTER TABLE `car_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pentru tabele `company_contacts`
--
ALTER TABLE `company_contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pentru tabele `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT pentru tabele `district`
--
ALTER TABLE `district`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT pentru tabele `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT pentru tabele `user_msg`
--
ALTER TABLE `user_msg`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;
