-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `car_slug` varchar(200) DEFAULT NULL,
  `custom_url` varchar(500) DEFAULT NULL,
  `button_text` varchar(100) DEFAULT 'Shiko Detajet',
  `image_position` enum('cover','contain','repeat') DEFAULT 'cover',
  `text_position` enum('left','center','right') DEFAULT 'left',
  `use_car_title` tinyint(1) DEFAULT 1,
  `is_active` tinyint(1) DEFAULT 1,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `subtitle`, `image`, `car_slug`, `custom_url`, `button_text`, `image_position`, `text_position`, `use_car_title`, `is_active`, `display_order`, `created_at`) VALUES
(40, 'FORD PUMA 1.0 HYBRID', '€ 12.900', 'banner_69f871fa6fa6f_fromcar.jpeg', 'ford-puma-1-0-hybrid', NULL, 'View Details', 'cover', 'left', 1, 1, 0, '2026-05-04 10:16:26'),
(42, 'BMW Serie 420 2021', '€ 29.900', 'banner_6a0ed00dcdbb2_fromcar.jpeg', 'bmw-serie-420-2021', NULL, 'Vedi Dettagli', 'cover', 'left', 1, 1, 0, '2026-05-21 09:27:41');

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

--
-- Table structure for table `banners_backup`
--

CREATE TABLE `banners_backup` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `car_slug` varchar(200) DEFAULT NULL,
  `custom_url` varchar(500) DEFAULT NULL,
  `button_text` varchar(100) DEFAULT 'Shiko Detajet',
  `is_active` tinyint(1) DEFAULT 1,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `image_position` enum('cover','contain','repeat') DEFAULT 'cover',
  `text_position` enum('left','center','right') DEFAULT 'left',
  `use_car_title` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cars`
--

CREATE TABLE `cars` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  `model` varchar(100) DEFAULT NULL,
  `transmission` varchar(50) DEFAULT NULL,
  `kilometers` int(11) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `cylinder` int(11) DEFAULT NULL,
  `fuel` varchar(50) DEFAULT NULL,
  `price` decimal(12,2) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `admin_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `slug` varchar(200) DEFAULT NULL,
  `is_sold` tinyint(1) DEFAULT 0,
  `custom_badge` varchar(50) DEFAULT NULL,
  `power` varchar(50) DEFAULT NULL,
  `consumption` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT 'sedan',
  `car_category` enum('Autovetture','Camion','Furgoni','Motorbikes','Trailer') DEFAULT 'Autovetture',
  `views` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` (`id`, `title`, `category_id`, `model`, `transmission`, `kilometers`, `year`, `cylinder`, `fuel`, `price`, `description`, `image`, `thumbnail`, `admin_id`, `created_at`, `slug`, `is_sold`, `custom_badge`, `power`, `consumption`, `type`, `car_category`, `views`) VALUES
(80, 'Shitet Volswagen Amarok 2.0', 4, '69', 'Manual', 195000, 2011, 2000, 'Diesel', 1900.00, 'Volkswagen Amarok 4 Motion (4×4 ) – Ottime condizioni\r\n\r\nPrezzo: 13.900€\r\n\r\nRitiriamo il tuo usato\r\nFinanziamento in sede\r\n\r\nImmatricolazione: Ottobre 2011\r\nAlimentazione: Diesel\r\nMotore: 2.0 –163 CV (120 kW)\r\nChilometraggio: 195.000 km\r\n\r\nManutenzione:\r\n?? Tagliando appena eseguito\r\n?? Kit distribuzione appena sostituito\r\n?? Revisione valida fino a 03/2026 (facciamo prima della consegna)\r\n\r\n?\r\n\r\nDotazioni e Accessori\r\n\r\n* Trazione integrale 4×4 con ridotte\r\n* Cambio manuale a 6 rapporti\r\n* Climatizzatore bi-zona\r\n* Navigatore\r\n* Sensori di parcheggio\r\n* Sedili riscaldabili\r\n* Cerchi in lega\r\n* Fendinebbia\r\n* Pedane laterali\r\n* Gancio traino\r\n\r\n?', 'UPL-20260421-205020-8696.jpeg', 'uploads/thumbnails/UPL-20260421-205020-8696.jpeg', 1, '2026-04-21 20:50:21', 'shitet-volswagen-amarok-2-0', 0, '4 x 4', '273', '5.5', 'suv', 'Autovetture', 68),
(93, 'Mercedes S 350 Brabus', 2, '15', 'Automatic', 245000, 2013, 3000, 'Diesel', 28900.00, 'MERCEDES-BENZ CLASSE S 350 BLUETEC LUNGA – ALLESTIMENTO BRABUS – FULL OPTIONAL\r\n\r\nPrezzo: €38.900\r\nAuto in conto vendita\r\n\r\n?\r\n\r\nDati principali\r\n\r\n* Modello: Mercedes Classe S (W222) S 350 BlueTEC Lunga\r\n* Motore: 3.0 Diesel – 258 CV (190 kW)\r\n* Anno: 16/10/2013\r\n* Chilometraggio: 245.000 km\r\n* Classe ambientale: Euro 6B\r\n* Revisione: valida fino 09/2026\r\n* Targa: GT000ZE\r\n\r\n?\r\n\r\nAllestimento & Optional\r\nVettura super accessoriata con allestimento BRABUS:\r\n\r\n* Pacchetto estetico BRABUS (scarichi, finiture, interni dedicati)\r\n* Volante multifunzione BRABUS / AMG\r\n* Fari Full LED\r\n* Tetto panoramico doppio apribile\r\n* Luci ambientali\r\n* Sistema audio premium Burmester\r\n* Sedili in pelle BRABUS anteriori e posteriori\r\n* Sedili elettrici con memoria (ant. e post.)\r\n* Sedili riscaldati, ventilati e con funzione massaggio\r\n* Cruise control adattivo (RADAR)\r\n* Assistenza al mantenimento corsia\r\n* Guida assistita\r\n* Sensori e assistenze alla guida complete\r\n\r\nEcc\r\n?\r\n\r\nCondizioni\r\nAuto elegante e confortevole, ideale per chi cerca il massimo del lusso Mercedes con un tocco sportivo esclusivo.\r\nVettura consegnata controllata e revisionata.\r\n\r\n?\r\n\r\nServizi\r\n? Possibilità di permuta\r\n? Finanziamento in sede\r\n? Garanzia disponibile su richiesta', 'UPL-20260503-232503-1784.jpeg', 'uploads/thumbnails/UPL-20260503-232503-1784.jpeg', 1, '2026-05-03 23:25:04', 'mercedes-s-350-brabus', 0, NULL, '258', NULL, 'sedan', 'Autovetture', 0),
(94, 'Mercedes c200 1997', 2, '13', 'Automatic', 129000, 1997, 200, 'Petrol', 7900.00, 'Mercedes-Benz C 200 Kompressor SW Sport – Automatico – Cerchi AMG\r\n\r\nTarga : AN901SW\r\n\r\n? Prezzo: 7.900 €\r\n\r\nDati veicolo\r\n• Marca: Mercedes-Benz\r\n• Modello: Classe C SW (S202)\r\n• Versione: C 200 Kompressor Sport\r\n• Alimentazione: Benzina\r\n• Cilindrata: 1998 cc\r\n• Potenza: 141 kW / 192 CV\r\n• Cambio: Automatico\r\n• Anno: 04/1997\r\n• Classe emissioni: Euro 2\r\n\r\n?\r\n\r\nEquipaggiamento\r\n• Climatizzatore automatico\r\n• Cerchi in lega AMG originali\r\n• Sedili riscaldati e gonfiabili\r\n• Vetri elettrici anteriori e posteriori\r\n• Volante regolabile\r\n• Autoradio originale Mercedes\r\n• Limitatore di velocità\r\nRadio originale Mercedes\r\nCambio automatico & sequenziale & S\r\n\r\n?\r\n\r\nStato veicolo\r\n\r\nAuto in buone condizioni meccaniche.\r\nCarrozzeria con segni dovuti all’età.\r\n\r\n?\r\n\r\n?? Garanzia 12 mesi (estendibile a 36 mesi)\r\n? Finanziamento disponibile\r\n? Permute accettate', 'UPL-20260503-232749-8647.jpeg', 'uploads/thumbnails/UPL-20260503-232749-8647.jpeg', 1, '2026-05-03 23:27:50', 'mercedes-c200-1997', 1, 'AUTOMATIC', '192', NULL, 'sedan', 'Autovetture', 1),
(95, 'AUDI A6 2.0', 3, '24', 'Automatic', 160000, 2015, 2000, 'Diesel', 16900.00, 'Audi A6 Avant 2.0 TDI 190 CV ultra S tronic Business Plus – €16.900\r\n\r\n? Immatricolazione: Gennaio 2015\r\n? Alimentazione: Diesel\r\n? Cilindrata: 2.0 TDI\r\n? Potenza: 190 CV – 140 kW\r\n? Classe ambientale: Euro 6\r\n? Chilometraggio: 160.000 km\r\n? Revisione valida fino a: 02/2027\r\n? Garanzia: 12 mesi (estendibile fino a 36 mesi)\r\n? Targa: EY534FH\r\n\r\n?\r\n\r\n? Allestimento Business Plus – Super Accessoriata\r\n• Cambio automatico S tronic\r\n• Climatizzatore automatico 4 zone\r\n• Sedili in pelle elettrici con memoria\r\n• Sensori di parcheggio anteriori e posteriori\r\n• Fari Full LED + Xenon\r\n• Navigatore satellitare\r\n• Cruise Control\r\n• Portellone bagagliaio elettrico\r\n• Sistema lavafari\r\n• Luci automatiche\r\n• Start & Stop\r\n• Auto Hold\r\n• Freno di stazionamento elettrico\r\n• Comandi multifunzione al volante\r\n• E molto altro…\r\n\r\n?\r\n\r\n? Finanziamento in sede\r\n? Accettiamo permute', 'UPL-20260503-233306-6580.jpeg', 'uploads/thumbnails/UPL-20260503-233306-6580.jpeg', 1, '2026-05-03 23:33:06', 'audi-a6-2-0', 1, NULL, '190', NULL, 'sedan', 'Autovetture', 0),
(97, 'FORD PUMA 1.0 HYBRID', 7, '55', 'Manual', 125000, 2021, NULL, 'Petrol', 12900.00, 'Targa : GC332AR\r\n\r\n-FORD:Puma 1.0 EcoBoost Hybrid 125 CV SeS ST-Line X (91 kw)\r\n-Cilindrata:1000\r\n-Alimentazione:Ibrida/benzina\r\n-Cavalli :124\r\n-KW :91\r\n-Classe Ambientale:EURO6D – ISC-FCM\r\n-IMMATRICOLAZIONE:gennaio 2021\r\n-Km 125.000\r\n\r\n-REVISIONE:02/2027\r\n\r\n-NEOPATENTATI:Si\r\nIl veicolo può essere guidato da un neopatentato.\r\n\r\nAccessoriata così :\r\n\r\nST -LINE\r\nTelecamera\r\nVolante multi funzioni\r\nRadar ( guida pilotata\r\nAssistenza corsia\r\nSensori di parcheggio ant & post\r\nNavigatore\r\nCambio manuale 6 rapporti\r\n4 vetri elettrici\r\nCerchi in lega\r\nClima automatica\r\nFari xenon LED\r\nParcheggia automatico\r\nStart & stop', 'UPL-20260504-100708-5099.jpeg', 'uploads/thumbnails/UPL-20260504-100708-5099.jpeg', 1, '2026-05-04 10:07:08', 'ford-puma-1-0-hybrid', 0, NULL, '125', NULL, 'coupe', 'Autovetture', 3),
(98, 'CITROEN C4 CACTUS', 18, '77', 'Automatic', 117000, 2017, 1200, 'Petrol', 7500.00, 'CITROËN C4 CACTUS 1.2 PURETECH 82CV AUTOMATICA – NEOPATENTATI OK!\r\n\r\nPrezzo: 7.500 €\r\nImmatricolazione: Febbraio 2017\r\nKm: 117.000 (tagliandi dimostrabili)\r\n\r\nTarga :FH400KR\r\n\r\nMotore benzina 1.2 PureTech – 82 CV (60 kW)\r\nCambio automatico ETG con modalità F1\r\nClasse ambientale Euro 6B\r\nGuidabile da neopatentati\r\nRevisione valida fino a 03/2027\r\n\r\n?\r\n\r\nAccessori:\r\n\r\n?? Climatizzatore\r\n?? Cruise control\r\n?? Fari LED\r\n?? Fendinebbia\r\n?? Volante multifunzione\r\n?? USB\r\n?? Barre portapacchi\r\n?? Cerchi in lega\r\n?? Doppio treno gomme\r\n\r\n?\r\n\r\n? Auto comoda, economica nei consumi e perfetta per uso quotidiano\r\n? Ideale anche come prima auto\r\n\r\n?\r\n\r\nDisponibile subito – pronta consegna\r\nVisionabile e test drive su appuntamento\r\n', 'UPL-20260504-101535-5977.jpeg', 'uploads/thumbnails/UPL-20260504-101535-5977.jpeg', 1, '2026-05-04 10:15:36', 'citroen-c4-cactus', 0, 'Euro 6', NULL, NULL, 'coupe', 'Autovetture', 0),
(99, 'TOYOTA YARIS', 5, '45', 'Manual', 133000, 2007, 1000, 'Petrol', 3900.00, 'TOYOTA YARIS 1.0 5 PORTE SOL – IDEALE NEOPATENTATI – GARANZIA\r\n\r\nTarga : DK089SJ\r\n\r\nimmatricolata 12/2007, in ottime condizioni generali, pronta consegna.\r\n\r\n? 133.000 km certificati\r\n? Motore 1.0 benzina – 69 CV / 51 kW\r\n? Euro 4 benzina\r\n? Adatta a neopatentati\r\n? Revisione valida fino a 10/2027\r\n\r\nAllestimento SOL con:\r\n? Climatizzatore\r\n? Volante multifunzione\r\n? Radio CD\r\n? Vetri elettrici\r\n? Chiusura centralizzata\r\n? 5 porte\r\n\r\nAuto molto affidabile, ideale per città e neopatentati, bassi consumi e costi di gestione contenuti.\r\n\r\nVeicolo consegnato controllato e tagliandato\r\n\r\nPrezzo promo: €3.900\r\nVisibile presso la nostra sede', 'UPL-20260504-102342-2207.jpeg', 'uploads/thumbnails/UPL-20260504-102342-2207.jpeg', 1, '2026-05-04 10:23:42', 'toyota-yaris', 0, 'OK NEOPATENTATI', '69', NULL, 'coupe', 'Autovetture', 10),
(100, 'SMART FORTWO BRABUS', 21, '81', 'Automatic', 132000, 2008, 1000, 'Petrol', 6900.00, '.Smart Fortwo BRABUS Xclusive – 2008\r\n\r\n? Prezzo: 6.900 €\r\n?? Garanzia: 12 mesi (estendibile fino a 36 mesi)\r\n? Finanziamento disponibile in sede\r\n? Permute accettate\r\n\r\n?\r\n\r\n? Dati principali\r\n• Modello: Smart Fortwo 2ª serie (2007–2015)\r\n• Versione: BRABUS Xclusive\r\n• Immatricolazione: Febbraio 2008\r\n• Motore: 1000 cc – Benzina\r\n• Potenza: 98 CV (72 kW)\r\n• Classe ambientale: EURO 4\r\n• Revisione: valida fino a 07/2027\r\n• Targa: DH666GA\r\nKm : 132.000\r\n?\r\n\r\n? Optional e accessori\r\n• Interni in pelle\r\n• Tetto interno in Alcantara\r\n• Fari Xenon\r\n• Fendinebbia\r\n• Cerchi in lega\r\n• Cambio automatico + sequenziale + modalità F1\r\n• Bluetooth\r\n• Radio touch\r\n• Tettuccio\r\n• Climatizzatore\r\n• E molto altro', 'UPL-20260504-204032-7974.jpeg', 'uploads/thumbnails/UPL-20260504-204032-7974.jpeg', 1, '2026-05-04 20:40:33', 'smart-fortwo-brabus', 0, NULL, '98', NULL, 'coupe', 'Autovetture', 1),
(102, 'BMW Serie 420 2021', 1, '4', 'Automatic', 127000, 2021, 200, 'Petrol', 29900.00, 'BMW Serie 4 Coupé 420i M-Sport\r\n\r\nPrezzo: €29.900\r\nTarga: GF408NW\r\n\r\nBMW Serie 4 Coupé (G22) 420i M-Sport\r\nImmatricolazione: 29/10/2021\r\nAlimentazione: Benzina\r\nCilindrata: 1998 cc\r\nPotenza: 184 CV – 135 kW\r\nClasse ambientale: Euro 6D ISC-FCM\r\nKm: 127.000 (tutti tagliandi BMW – appena tagliandata)\r\nRevisione valida fino a 10/2027\r\n\r\nSuper accessoriata:\r\n?? Head-Up Display\r\n?? Fari Full LED\r\n?? Interni in pelle marrone M-Sport\r\n?? Luci ambientali\r\n?? Clima automatico 4 zone\r\n?? Telecamera posteriore\r\n?? Navigatore\r\n?? Auto Hold\r\n?? Start & Stop\r\n?? Modalità guida Sport / Comfort / Eco Pro\r\n?? Cruise Control\r\n?? Cambio F1 al volante\r\n?? Sedili con memoria\r\n?? Luci automatiche\r\n?? Assistente luci\r\n?? Sensori parcheggio anteriori e posteriori\r\n?? Molto altro ancora!', 'UPL-20260512-224820-9420.jpeg', 'uploads/thumbnails/UPL-20260512-224820-9420.jpeg', 1, '2026-05-12 22:48:20', 'bmw-serie-420-2021', 0, 'M-Sport', '184', NULL, 'sedan', 'Autovetture', 0);

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

--
-- Table structure for table `car_gallery`
--

CREATE TABLE `car_gallery` (
  `id` int(11) NOT NULL,
  `car_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_gallery`
--

INSERT INTO `car_gallery` (`id`, `car_id`, `image`, `created_at`) VALUES
(799, 80, 'UPL-20260421-205021-01.jpeg', '2026-04-21 20:50:22'),
(800, 80, 'UPL-20260421-205022-02.jpeg', '2026-04-21 20:50:22'),
(801, 80, 'UPL-20260421-205022-03.jpeg', '2026-04-21 20:50:22'),
(802, 80, 'UPL-20260421-205022-04.jpeg', '2026-04-21 20:50:23'),
(803, 80, 'UPL-20260421-205023-05.jpeg', '2026-04-21 20:50:23'),
(804, 80, 'UPL-20260421-205023-06.jpeg', '2026-04-21 20:50:23'),
(805, 80, 'UPL-20260421-205023-07.jpeg', '2026-04-21 20:50:24'),
(806, 80, 'UPL-20260421-205024-08.jpeg', '2026-04-21 20:50:24'),
(807, 80, 'UPL-20260421-205024-09.jpeg', '2026-04-21 20:50:25'),
(808, 80, 'UPL-20260421-205025-10.jpeg', '2026-04-21 20:50:25'),
(972, 93, 'UPL-20260503-232504-01.jpeg', '2026-05-03 23:25:04'),
(973, 93, 'UPL-20260503-232504-02.jpeg', '2026-05-03 23:25:05'),
(974, 93, 'UPL-20260503-232505-03.jpeg', '2026-05-03 23:25:05'),
(975, 93, 'UPL-20260503-232505-04.jpeg', '2026-05-03 23:25:06'),
(976, 93, 'UPL-20260503-232506-05.jpeg', '2026-05-03 23:25:06'),
(977, 93, 'UPL-20260503-232506-06.jpeg', '2026-05-03 23:25:06'),
(978, 93, 'UPL-20260503-232506-07.jpeg', '2026-05-03 23:25:07'),
(979, 93, 'UPL-20260503-232507-08.jpeg', '2026-05-03 23:25:07'),
(980, 93, 'UPL-20260503-232507-09.jpeg', '2026-05-03 23:25:08'),
(981, 93, 'UPL-20260503-232508-10.jpeg', '2026-05-03 23:25:08'),
(982, 93, 'UPL-20260503-232508-11.jpeg', '2026-05-03 23:25:09'),
(983, 93, 'UPL-20260503-232509-12.jpeg', '2026-05-03 23:25:09'),
(984, 93, 'UPL-20260503-232509-13.jpeg', '2026-05-03 23:25:09'),
(985, 93, 'UPL-20260503-232509-14.jpeg', '2026-05-03 23:25:10'),
(986, 93, 'UPL-20260503-232510-15.jpeg', '2026-05-03 23:25:10'),
(987, 93, 'UPL-20260503-232510-16.jpeg', '2026-05-03 23:25:11'),
(988, 93, 'UPL-20260503-232511-17.jpeg', '2026-05-03 23:25:11'),
(989, 93, 'UPL-20260503-232511-18.jpeg', '2026-05-03 23:25:11'),
(990, 93, 'UPL-20260503-232511-19.jpeg', '2026-05-03 23:25:12'),
(991, 93, 'UPL-20260503-232512-20.jpeg', '2026-05-03 23:25:12'),
(992, 93, 'UPL-20260503-232512-21.jpeg', '2026-05-03 23:25:13'),
(993, 93, 'UPL-20260503-232513-22.jpeg', '2026-05-03 23:25:13'),
(994, 93, 'UPL-20260503-232513-23.jpeg', '2026-05-03 23:25:13'),
(995, 93, 'UPL-20260503-232513-24.jpeg', '2026-05-03 23:25:14'),
(996, 93, 'UPL-20260503-232514-25.jpeg', '2026-05-03 23:25:14'),
(997, 94, 'UPL-20260503-232750-01.jpeg', '2026-05-03 23:27:50'),
(998, 94, 'UPL-20260503-232750-02.jpeg', '2026-05-03 23:27:50'),
(999, 94, 'UPL-20260503-232750-03.jpeg', '2026-05-03 23:27:51'),
(1000, 94, 'UPL-20260503-232751-04.jpeg', '2026-05-03 23:27:51'),
(1001, 94, 'UPL-20260503-232751-05.jpeg', '2026-05-03 23:27:52'),
(1002, 94, 'UPL-20260503-232752-06.jpeg', '2026-05-03 23:27:52'),
(1003, 94, 'UPL-20260503-232752-07.jpeg', '2026-05-03 23:27:52'),
(1004, 94, 'UPL-20260503-232752-08.jpeg', '2026-05-03 23:27:53'),
(1005, 94, 'UPL-20260503-232753-09.jpeg', '2026-05-03 23:27:53'),
(1006, 95, 'UPL-20260503-233306-01.jpeg', '2026-05-03 23:33:07'),
(1007, 95, 'UPL-20260503-233307-02.jpeg', '2026-05-03 23:33:07'),
(1008, 95, 'UPL-20260503-233307-03.jpeg', '2026-05-03 23:33:08'),
(1009, 95, 'UPL-20260503-233308-04.jpeg', '2026-05-03 23:33:08'),
(1010, 95, 'UPL-20260503-233308-05.jpeg', '2026-05-03 23:33:08'),
(1011, 95, 'UPL-20260503-233308-06.jpeg', '2026-05-03 23:33:09'),
(1012, 95, 'UPL-20260503-233309-07.jpeg', '2026-05-03 23:33:09'),
(1013, 95, 'UPL-20260503-233309-08.jpeg', '2026-05-03 23:33:10'),
(1014, 95, 'UPL-20260503-233310-09.jpeg', '2026-05-03 23:33:10'),
(1015, 95, 'UPL-20260503-233310-10.jpeg', '2026-05-03 23:33:10'),
(1016, 95, 'UPL-20260503-233310-11.jpeg', '2026-05-03 23:33:11'),
(1017, 95, 'UPL-20260503-233311-12.jpeg', '2026-05-03 23:33:11'),
(1018, 95, 'UPL-20260503-233311-13.jpeg', '2026-05-03 23:33:12'),
(1019, 95, 'UPL-20260503-233312-14.jpeg', '2026-05-03 23:33:12'),
(1020, 95, 'UPL-20260503-233312-15.jpeg', '2026-05-03 23:33:12'),
(1021, 95, 'UPL-20260503-233312-16.jpeg', '2026-05-03 23:33:12'),
(1022, 95, 'UPL-20260503-233312-17.jpeg', '2026-05-03 23:33:13'),
(1023, 95, 'UPL-20260503-233313-18.jpeg', '2026-05-03 23:33:13'),
(1024, 95, 'UPL-20260503-233313-19.jpeg', '2026-05-03 23:33:14'),
(1039, 97, 'UPL-20260504-100708-01.jpeg', '2026-05-04 10:07:08'),
(1040, 97, 'UPL-20260504-100708-02.jpeg', '2026-05-04 10:07:09'),
(1041, 97, 'UPL-20260504-100709-03.jpeg', '2026-05-04 10:07:09'),
(1042, 97, 'UPL-20260504-100709-04.jpeg', '2026-05-04 10:07:09'),
(1043, 97, 'UPL-20260504-100709-05.jpeg', '2026-05-04 10:07:10'),
(1044, 97, 'UPL-20260504-100710-06.jpeg', '2026-05-04 10:07:10'),
(1045, 97, 'UPL-20260504-100710-07.jpeg', '2026-05-04 10:07:10'),
(1046, 97, 'UPL-20260504-100710-08.jpeg', '2026-05-04 10:07:11'),
(1047, 97, 'UPL-20260504-100711-09.jpeg', '2026-05-04 10:07:11'),
(1048, 97, 'UPL-20260504-100711-10.jpeg', '2026-05-04 10:07:11'),
(1049, 97, 'UPL-20260504-100711-11.jpeg', '2026-05-04 10:07:11'),
(1050, 97, 'UPL-20260504-100711-12.jpeg', '2026-05-04 10:07:12'),
(1051, 97, 'UPL-20260504-100712-13.jpeg', '2026-05-04 10:07:12'),
(1052, 97, 'UPL-20260504-100712-14.jpeg', '2026-05-04 10:07:12'),
(1053, 97, 'UPL-20260504-100712-15.jpeg', '2026-05-04 10:07:13'),
(1054, 97, 'UPL-20260504-100713-16.jpeg', '2026-05-04 10:07:13'),
(1055, 97, 'UPL-20260504-100713-17.jpeg', '2026-05-04 10:07:13'),
(1056, 97, 'UPL-20260504-100713-18.jpeg', '2026-05-04 10:07:13'),
(1057, 98, 'UPL-20260504-101536-01.jpeg', '2026-05-04 10:15:36'),
(1058, 98, 'UPL-20260504-101536-02.jpeg', '2026-05-04 10:15:36'),
(1059, 98, 'UPL-20260504-101536-03.jpeg', '2026-05-04 10:15:37'),
(1060, 98, 'UPL-20260504-101537-04.jpeg', '2026-05-04 10:15:37'),
(1061, 98, 'UPL-20260504-101537-05.jpeg', '2026-05-04 10:15:37'),
(1062, 98, 'UPL-20260504-101537-06.jpeg', '2026-05-04 10:15:38'),
(1063, 98, 'UPL-20260504-101538-07.jpeg', '2026-05-04 10:15:38'),
(1064, 98, 'UPL-20260504-101538-08.jpeg', '2026-05-04 10:15:38'),
(1065, 98, 'UPL-20260504-101538-09.jpeg', '2026-05-04 10:15:38'),
(1066, 98, 'UPL-20260504-101538-10.jpeg', '2026-05-04 10:15:39'),
(1067, 98, 'UPL-20260504-101539-11.jpeg', '2026-05-04 10:15:39'),
(1068, 98, 'UPL-20260504-101539-12.jpeg', '2026-05-04 10:15:39'),
(1069, 98, 'UPL-20260504-101539-13.jpeg', '2026-05-04 10:15:40'),
(1070, 98, 'UPL-20260504-101540-14.jpeg', '2026-05-04 10:15:40'),
(1071, 98, 'UPL-20260504-101540-15.jpeg', '2026-05-04 10:15:40'),
(1072, 98, 'UPL-20260504-101540-16.jpeg', '2026-05-04 10:15:40'),
(1073, 98, 'UPL-20260504-101540-17.jpeg', '2026-05-04 10:15:41'),
(1074, 99, 'UPL-20260504-102342-01.jpeg', '2026-05-04 10:23:43'),
(1075, 99, 'UPL-20260504-102343-02.jpeg', '2026-05-04 10:23:43'),
(1076, 99, 'UPL-20260504-102343-03.jpeg', '2026-05-04 10:23:43'),
(1077, 99, 'UPL-20260504-102343-04.jpeg', '2026-05-04 10:23:43'),
(1078, 99, 'UPL-20260504-102343-05.jpeg', '2026-05-04 10:23:44'),
(1079, 99, 'UPL-20260504-102344-06.jpeg', '2026-05-04 10:23:44'),
(1080, 99, 'UPL-20260504-102344-07.jpeg', '2026-05-04 10:23:44'),
(1081, 99, 'UPL-20260504-102344-08.jpeg', '2026-05-04 10:23:44'),
(1082, 99, 'UPL-20260504-102344-09.jpeg', '2026-05-04 10:23:45'),
(1083, 99, 'UPL-20260504-102345-10.jpeg', '2026-05-04 10:23:45'),
(1084, 99, 'UPL-20260504-102345-11.jpeg', '2026-05-04 10:23:45'),
(1085, 99, 'UPL-20260504-102345-12.jpeg', '2026-05-04 10:23:46'),
(1086, 99, 'UPL-20260504-102346-13.jpeg', '2026-05-04 10:23:46'),
(1087, 99, 'UPL-20260504-102346-14.jpeg', '2026-05-04 10:23:46'),
(1088, 99, 'UPL-20260504-102346-15.jpeg', '2026-05-04 10:23:46'),
(1089, 100, 'UPL-20260504-204033-01.jpeg', '2026-05-04 20:40:33'),
(1090, 100, 'UPL-20260504-204033-02.jpeg', '2026-05-04 20:40:34'),
(1091, 100, 'UPL-20260504-204034-03.jpeg', '2026-05-04 20:40:34'),
(1092, 100, 'UPL-20260504-204034-04.jpeg', '2026-05-04 20:40:34'),
(1093, 100, 'UPL-20260504-204034-05.jpeg', '2026-05-04 20:40:35'),
(1094, 100, 'UPL-20260504-204035-06.jpeg', '2026-05-04 20:40:35'),
(1095, 100, 'UPL-20260504-204035-07.jpeg', '2026-05-04 20:40:35'),
(1096, 100, 'UPL-20260504-204035-08.jpeg', '2026-05-04 20:40:36'),
(1097, 100, 'UPL-20260504-204036-09.jpeg', '2026-05-04 20:40:36'),
(1098, 100, 'UPL-20260504-204036-10.jpeg', '2026-05-04 20:40:37'),
(1099, 100, 'UPL-20260504-204037-11.jpeg', '2026-05-04 20:40:37'),
(1100, 100, 'UPL-20260504-204037-12.jpeg', '2026-05-04 20:40:37'),
(1101, 100, 'UPL-20260504-204037-13.jpeg', '2026-05-04 20:40:38'),
(1102, 100, 'UPL-20260504-204038-14.jpeg', '2026-05-04 20:40:38'),
(1103, 100, 'UPL-20260504-204038-15.jpeg', '2026-05-04 20:40:38'),
(1104, 100, 'UPL-20260504-204038-16.jpeg', '2026-05-04 20:40:39'),
(1105, 100, 'UPL-20260504-204039-17.jpeg', '2026-05-04 20:40:39'),
(1106, 100, 'UPL-20260504-204039-18.jpeg', '2026-05-04 20:40:40'),
(1107, 100, 'UPL-20260504-204040-19.jpeg', '2026-05-04 20:40:40'),
(1108, 100, 'UPL-20260504-204040-20.jpeg', '2026-05-04 20:40:40'),
(1109, 100, 'UPL-20260504-204040-21.jpeg', '2026-05-04 20:40:41'),
(1110, 100, 'UPL-20260504-204041-22.jpeg', '2026-05-04 20:40:41'),
(1111, 100, 'UPL-20260504-204041-23.jpeg', '2026-05-04 20:40:41'),
(1112, 100, 'UPL-20260504-204041-24.jpeg', '2026-05-04 20:40:42'),
(1124, 102, 'UPL-20260512-224820-01.jpeg', '2026-05-12 22:48:21'),
(1125, 102, 'UPL-20260512-224821-02.jpeg', '2026-05-12 22:48:21'),
(1126, 102, 'UPL-20260512-224821-03.jpeg', '2026-05-12 22:48:22'),
(1127, 102, 'UPL-20260512-224822-04.jpeg', '2026-05-12 22:48:22'),
(1128, 102, 'UPL-20260512-224822-05.jpeg', '2026-05-12 22:48:23'),
(1129, 102, 'UPL-20260512-224823-06.jpeg', '2026-05-12 22:48:23'),
(1130, 102, 'UPL-20260512-224823-07.jpeg', '2026-05-12 22:48:23'),
(1131, 102, 'UPL-20260512-224823-08.jpeg', '2026-05-12 22:48:24'),
(1132, 102, 'UPL-20260512-224824-09.jpeg', '2026-05-12 22:48:24'),
(1133, 102, 'UPL-20260512-224824-10.jpeg', '2026-05-12 22:48:24'),
(1134, 102, 'UPL-20260512-224824-11.jpeg', '2026-05-12 22:48:25'),
(1135, 102, 'UPL-20260512-224825-12.jpeg', '2026-05-12 22:48:25'),
(1136, 102, 'UPL-20260512-224825-13.jpeg', '2026-05-12 22:48:26'),
(1137, 102, 'UPL-20260512-224826-14.jpeg', '2026-05-12 22:48:26'),
(1138, 102, 'UPL-20260512-224826-15.jpeg', '2026-05-12 22:48:26'),
(1139, 102, 'UPL-20260512-224826-16.jpeg', '2026-05-12 22:48:27'),
(1140, 102, 'UPL-20260512-224827-17.jpeg', '2026-05-12 22:48:27'),
(1141, 102, 'UPL-20260512-224827-18.jpeg', '2026-05-12 22:48:28'),
(1142, 102, 'UPL-20260512-224828-19.jpeg', '2026-05-12 22:48:28'),
(1143, 102, 'UPL-20260512-224828-20.jpeg', '2026-05-12 22:48:28'),
(1144, 102, 'UPL-20260512-224828-21.jpeg', '2026-05-12 22:48:29'),
(1145, 102, 'UPL-20260512-224829-22.jpeg', '2026-05-12 22:48:29'),
(1146, 102, 'UPL-20260512-224829-23.jpeg', '2026-05-12 22:48:30'),
(1147, 102, 'UPL-20260512-224830-24.jpeg', '2026-05-12 22:48:30'),
(1148, 102, 'UPL-20260512-224830-25.jpeg', '2026-05-12 22:48:30'),
(1149, 102, 'UPL-20260512-224830-26.jpeg', '2026-05-12 22:48:31'),
(1150, 102, 'UPL-20260512-224831-27.jpeg', '2026-05-12 22:48:31'),
(1151, 102, 'UPL-20260512-224831-28.jpeg', '2026-05-12 22:48:31'),
(1152, 102, 'UPL-20260512-224831-29.jpeg', '2026-05-12 22:48:32'),
(1153, 102, 'UPL-20260512-224832-30.jpeg', '2026-05-12 22:48:32'),
(1154, 102, 'UPL-20260512-224832-31.jpeg', '2026-05-12 22:48:33'),
(1155, 102, 'UPL-20260512-224833-32.jpeg', '2026-05-12 22:48:33'),
(1156, 102, 'UPL-20260512-224833-33.jpeg', '2026-05-12 22:48:33');

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

--
-- Table structure for table `car_has_options`
--

CREATE TABLE `car_has_options` (
  `id` int(11) NOT NULL,
  `car_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_has_options`
--

INSERT INTO `car_has_options` (`id`, `car_id`, `option_id`) VALUES
(975, 80, 21),
(976, 80, 22),
(971, 80, 23),
(970, 80, 25),
(974, 80, 26),
(968, 80, 27),
(967, 80, 29),
(972, 80, 30),
(973, 80, 32),
(977, 80, 34),
(969, 80, 35),
(1012, 93, 21),
(1013, 93, 22),
(1006, 93, 23),
(1010, 93, 24),
(1005, 93, 25),
(1011, 93, 26),
(1002, 93, 27),
(1004, 93, 28),
(1001, 93, 29),
(1007, 93, 30),
(1008, 93, 31),
(1009, 93, 32),
(1014, 93, 33),
(1015, 93, 34),
(1003, 93, 35),
(1000, 94, 21),
(997, 94, 27),
(999, 94, 30),
(998, 94, 35),
(1027, 95, 21),
(1028, 95, 22),
(1021, 95, 23),
(1025, 95, 24),
(1020, 95, 25),
(1026, 95, 26),
(1017, 95, 27),
(1019, 95, 28),
(1016, 95, 29),
(1022, 95, 30),
(1023, 95, 31),
(1024, 95, 32),
(1029, 95, 33),
(1030, 95, 34),
(1018, 95, 35),
(1050, 97, 23),
(1054, 97, 24),
(1049, 97, 25),
(1055, 97, 26),
(1047, 97, 27),
(1046, 97, 29),
(1051, 97, 30),
(1052, 97, 31),
(1053, 97, 32),
(1056, 97, 34),
(1048, 97, 35),
(1077, 98, 23),
(1079, 98, 24),
(1076, 98, 25),
(1080, 98, 26),
(1073, 98, 27),
(1075, 98, 28),
(1072, 98, 29),
(1078, 98, 32),
(1081, 98, 33),
(1082, 98, 34),
(1074, 98, 35),
(1085, 99, 25),
(1083, 99, 27),
(1086, 99, 30),
(1087, 99, 32),
(1084, 99, 35),
(1092, 100, 22),
(1090, 100, 25),
(1091, 100, 26),
(1088, 100, 27),
(1093, 100, 33),
(1089, 100, 35),
(1120, 102, 21),
(1121, 102, 22),
(1114, 102, 23),
(1118, 102, 24),
(1113, 102, 25),
(1119, 102, 26),
(1110, 102, 27),
(1112, 102, 28),
(1109, 102, 29),
(1115, 102, 30),
(1116, 102, 31),
(1117, 102, 32),
(1122, 102, 33),
(1123, 102, 34),
(1111, 102, 35);

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

--
-- Table structure for table `car_models`
--

CREATE TABLE `car_models` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_models`
--

INSERT INTO `car_models` (`id`, `category_id`, `name`, `created_at`) VALUES
(1, 1, 'Seria 1', '2026-01-21 22:51:31'),
(2, 1, 'Seria 2', '2026-01-21 22:51:31'),
(3, 1, 'Seria 3', '2026-01-21 22:51:31'),
(4, 1, 'Seria 5', '2026-01-21 22:51:31'),
(5, 1, 'Seria 7', '2026-01-21 22:51:31'),
(6, 1, 'E260', '2026-01-21 22:51:31'),
(7, 1, 'Z1', '2026-01-21 22:51:31'),
(8, 1, 'X1', '2026-01-21 22:51:31'),
(9, 1, 'X3', '2026-01-21 22:51:31'),
(10, 1, 'X5', '2026-01-21 22:51:31'),
(11, 1, 'X7', '2026-01-21 22:51:31'),
(12, 2, 'A Class', '2026-01-21 22:51:31'),
(13, 2, 'C Class', '2026-01-21 22:51:31'),
(14, 2, 'E Class', '2026-01-21 22:51:31'),
(15, 2, 'S Class', '2026-01-21 22:51:31'),
(16, 2, 'G Class', '2026-01-21 22:51:31'),
(17, 2, 'GLA', '2026-01-21 22:51:31'),
(18, 2, 'GLC', '2026-01-21 22:51:31'),
(19, 2, 'GLE', '2026-01-21 22:51:31'),
(20, 2, 'GLS', '2026-01-21 22:51:31'),
(21, 3, 'A1', '2026-01-21 22:51:31'),
(22, 3, 'A3', '2026-01-21 22:51:31'),
(23, 3, 'A4', '2026-01-21 22:51:31'),
(24, 3, 'A6', '2026-01-21 22:51:31'),
(25, 3, 'A8', '2026-01-21 22:51:31'),
(26, 3, 'Q2', '2026-01-21 22:51:31'),
(27, 3, 'Q3', '2026-01-21 22:51:31'),
(28, 3, 'Q5', '2026-01-21 22:51:31'),
(29, 3, 'Q7', '2026-01-21 22:51:31'),
(30, 3, 'Q8', '2026-01-21 22:51:31'),
(31, 4, 'Golf', '2026-01-21 22:51:31'),
(32, 4, 'Jetta', '2026-01-21 22:51:31'),
(33, 4, 'Passat', '2026-01-21 22:51:31'),
(34, 4, 'Tiguan', '2026-01-21 22:51:31'),
(35, 4, 'Touareg', '2026-01-21 22:51:31'),
(36, 4, 'Polo', '2026-01-21 22:51:31'),
(37, 4, 'Beetle', '2026-01-21 22:51:31'),
(38, 4, 'T-Roc', '2026-01-21 22:51:31'),
(39, 5, 'Corolla', '2026-01-21 22:51:31'),
(40, 5, 'Camry', '2026-01-21 22:51:31'),
(41, 5, 'Prius', '2026-01-21 22:51:31'),
(42, 5, 'RAV4', '2026-01-21 22:51:31'),
(43, 5, 'Highlander', '2026-01-21 22:51:31'),
(44, 5, 'Land Cruiser', '2026-01-21 22:51:31'),
(45, 5, 'Yaris', '2026-01-21 22:51:31'),
(46, 6, 'Civic', '2026-01-21 22:51:31'),
(47, 6, 'Accord', '2026-01-21 22:51:31'),
(48, 6, 'CR-V', '2026-01-21 22:51:31'),
(49, 6, 'Pilot', '2026-01-21 22:51:31'),
(50, 6, 'Odyssey', '2026-01-21 22:51:31'),
(51, 7, 'Focus', '2026-01-21 22:51:31'),
(52, 7, 'Mondeo', '2026-01-21 22:51:31'),
(53, 7, 'Mustang', '2026-01-21 22:51:31'),
(54, 7, 'Explorer', '2026-01-21 22:51:31'),
(55, 7, 'Edge', '2026-01-21 22:51:31'),
(56, 8, '500', '2026-01-21 22:51:31'),
(57, 8, 'Panda', '2026-01-21 22:51:31'),
(58, 8, '500X', '2026-01-21 22:51:31'),
(59, 8, '500L', '2026-01-21 22:51:31'),
(60, 8, 'Tipo', '2026-01-21 22:51:31'),
(66, 11, 'Cayenne', '2026-01-21 23:05:41'),
(67, 12, '302', '2026-01-21 23:34:32'),
(68, 10, 'Bently 1', '2026-01-27 11:48:56'),
(69, 4, 'Amarok', '2026-02-10 23:01:29'),
(70, 2, 'S350', '2026-02-13 20:53:05'),
(71, 13, 'Micra', '2026-02-13 21:15:59'),
(72, 14, 'TGL', '2026-02-13 21:19:18'),
(74, 16, 'Gulia', '2026-02-13 21:29:09'),
(75, 7, 'Galaxy', '2026-02-13 21:33:52'),
(77, 18, 'Cactus', '2026-04-14 20:12:00'),
(78, 2, 'Viano', '2026-04-16 12:33:31'),
(79, 18, 'DS7', '2026-04-17 20:38:35'),
(80, 3, 'RS4', '2026-04-17 22:05:34'),
(81, 21, 'For Two', '2026-05-04 20:37:43');

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

--
-- Table structure for table `car_options`
--

CREATE TABLE `car_options` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_options`
--

INSERT INTO `car_options` (`id`, `name`, `description`, `created_at`) VALUES
(21, 'SRS', '', '2026-01-21 23:31:58'),
(22, 'Sunroof', '', '2026-01-25 12:39:10'),
(23, 'Cruise Control', '', '2026-01-25 12:39:52'),
(24, 'LED', '', '2026-01-26 16:26:56'),
(25, 'Bluetooth', '', '2026-01-27 11:49:11'),
(26, 'Navigator', '', '2026-02-10 23:01:36'),
(27, 'ABS', '', '2026-02-10 23:01:51'),
(28, 'Auto Hold', '', '2026-02-10 23:02:06'),
(29, '360° camera', '', '2026-02-13 20:58:01'),
(30, 'ESP', '', '2026-02-13 20:58:15'),
(31, 'Heating Seat', '', '2026-04-17 20:37:49'),
(32, 'Isofix', '', '2026-04-17 20:38:09'),
(33, 'USB', '', '2026-04-17 20:38:21'),
(34, 'Wirless Charging', '', '2026-04-17 20:38:27'),
(35, 'Airbag', '', '2026-05-03 21:48:08');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `logo`, `created_at`) VALUES
(1, 'BMW', 'logo_1776724948_69e6abd4223eb.png', '2026-01-21 12:58:49'),
(2, 'Mercedes', 'logo_1776724817_69e6ab5179bf0.png', '2026-01-21 12:58:49'),
(3, 'Audi', 'logo_1776722290_69e6a1725a20d.png', '2026-01-21 12:58:49'),
(4, 'Volkswagen', 'logo_1777850479_69f7d86f85382.png', '2026-01-21 12:58:49'),
(5, 'Toyota', 'logo_1777925961_69f8ff4973552.png', '2026-01-21 12:58:49'),
(6, 'Honda', 'logo_1776725280_69e6ad2038962.png', '2026-01-21 12:58:49'),
(7, 'Ford', 'logo_1776725102_69e6ac6e486d7.png', '2026-01-21 12:58:49'),
(8, 'Fiat', 'logo_1776725081_69e6ac590c6f4.png', '2026-01-21 12:58:49'),
(10, 'Bently', 'logo_1776724870_69e6ab86011ef.png', '2026-01-21 22:54:42'),
(11, 'Porsche', 'logo_1777851215_69f7db4f71b80.png', '2026-01-21 23:04:48'),
(12, 'Peugeot', 'logo_1776725357_69e6ad6d44b64.png', '2026-01-21 23:34:24'),
(13, 'Nissan', 'logo_1776725314_69e6ad420d952.png', '2026-02-13 21:15:51'),
(14, 'MAN', 'logo_1776725292_69e6ad2c3ad9a.png', '2026-02-13 21:19:09'),
(16, 'Alfa Romeo', 'logo_1776724843_69e6ab6b835c8.png', '2026-02-13 21:28:58'),
(18, 'Citroen', 'logo_1776724969_69e6abe98e675.png', '2026-04-14 20:11:53'),
(21, 'Smart', 'logo_1777926135_69f8fff7a5b72.png', '2026-05-04 20:21:08');

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

--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` int(11) NOT NULL,
  `car_id` int(11) DEFAULT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `type` enum('car','general') NOT NULL DEFAULT 'car',
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `message` text NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact_messages`
--

INSERT INTO `contact_messages` (`id`, `car_id`, `admin_id`, `type`, `name`, `email`, `phone`, `message`, `is_read`, `created_at`) VALUES
(54, 99, 1, 'car', 'Test Test', 'test@sdasd.com', '06994844223', 'Messagino', 0, '2026-05-05 10:25:34'),
(55, NULL, NULL, 'general', 'Test nr2', 'test2@opdfsjd.it', '0694156654564', 'test numero 2', 0, '2026-05-05 10:25:58');

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

--
-- Table structure for table `email_settings`
--

CREATE TABLE `email_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('text','textarea','checkbox','color','url','email') DEFAULT 'text',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_settings`
--

INSERT INTO `email_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `created_at`, `updated_at`) VALUES
(1, 'smtp_enabled', '1', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(2, 'smtp_host', 'mail.esc.al', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(3, 'smtp_port', '465', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(4, 'smtp_encryption', 'ssl', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(5, 'smtp_username', 'contact@esc.al', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(6, 'smtp_password', 'Azerbajxhan12', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(7, 'smtp_auth', '1', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(8, 'from_email', 'contact@esc.al', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(9, 'from_name', 'AutoMarket', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(10, 'reply_to_email', 'info@esc.al', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(11, 'cc_enabled', '0', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(12, 'cc_address', '', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(13, 'bcc_enabled', '0', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(14, 'bcc_address', '', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(15, 'email_notifications_enabled', '1', 'text', '2026-04-23 14:29:49', '2026-04-23 21:31:30'),
(16, 'auto_reply_enabled', '1', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(17, 'auto_reply_subject', 'Thank you for contacting AutoMarket', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(18, 'auto_reply_welcome_text', 'Thank you for your interest in our vehicles. We will get back to you shortly.', 'textarea', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(19, 'template_primary_color', '#379046', 'text', '2026-04-23 14:29:49', '2026-04-23 21:31:30'),
(20, 'template_secondary_color', '#2c3e50', 'color', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(21, 'template_logo', '', 'text', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(22, 'template_footer_text', '© 2026 AutoMarket - All rights reserved.', 'textarea', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(23, 'template_show_car_details', '1', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(24, 'template_show_social_links', '1', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(25, 'template_facebook_url', 'https://facebook.com/automarket', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(26, 'template_instagram_url', 'https://instagram.com/automarket', 'text', '2026-04-23 14:29:49', '2026-04-23 20:27:50'),
(27, 'template_show_map_link', '1', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(28, 'test_mode', '0', 'checkbox', '2026-04-23 14:29:49', '2026-04-23 14:29:49'),
(29, 'admin_email_subject', 'New Contact Request from Website ESCMarket', 'text', '2026-04-23 17:59:45', '2026-04-23 20:27:50'),
(30, 'admin_email_welcome_text', 'Someone is interested in your vehicle', 'textarea', '2026-04-23 17:59:45', '2026-04-23 17:59:45'),
(31, 'admin_email_show_car_details', '1', 'checkbox', '2026-04-23 17:59:45', '2026-04-23 17:59:45'),
(32, 'admin_email_show_social_links', '0', 'checkbox', '2026-04-23 17:59:45', '2026-04-23 17:59:45'),
(33, 'client_email_subject', 'Thank you for contacting ESCMarket', 'text', '2026-04-23 17:59:45', '2026-04-23 20:27:50'),
(34, 'client_email_welcome_text', 'Thank you for your interest in our vehicles. We will get back to you shortly.', 'textarea', '2026-04-23 17:59:45', '2026-04-23 17:59:45'),
(35, 'client_email_show_social_links', '1', 'text', '2026-04-23 17:59:45', '2026-04-23 20:27:50'),
(36, 'client_email_show_map_link', '0', 'text', '2026-04-23 17:59:45', '2026-04-23 20:27:50'),
(37, 'admin_header_text', 'Someone is interested in your vehicle: {car_title}', 'text', '2026-04-23 19:25:47', '2026-04-23 19:25:47'),
(38, 'admin_footer_text', 'This message was sent from {site_title}', 'text', '2026-04-23 19:25:47', '2026-04-23 19:25:47'),
(39, 'client_footer_text', '', 'text', '2026-04-23 19:25:47', '2026-04-23 20:27:50'),
(40, 'client_footer_message', 'This message was sent from ESCMarket', 'text', '2026-04-23 19:25:47', '2026-04-23 20:30:08'),
(41, 'client_welcome_text', 'Thank you for your interest in our vehicles. We will get back to you shortly.', 'text', '2026-04-23 19:25:47', '2026-04-23 20:27:50'),
(297, 'site_url', '', 'url', '2026-05-07 22:02:22', '2026-05-07 22:02:22');

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `attempts` int(11) NOT NULL DEFAULT 1,
  `last_attempt` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_blocked` tinyint(1) NOT NULL DEFAULT 0,
  `blocked_until` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `login_attempts`
--

INSERT INTO `login_attempts` (`id`, `ip_address`, `username`, `attempts`, `last_attempt`, `created_at`, `is_blocked`, `blocked_until`) VALUES
(6, '80.90.84.79', 'superadmin', 2, '2026-04-23 12:41:13', '2026-04-23 09:08:56', 0, NULL),
(7, '185.9.44.197', 'superadmin', 6, '2026-04-23 21:37:14', '2026-04-23 17:37:29', 0, NULL),
(8, '185.9.44.197', 'superadmin', 3, '2026-04-23 22:51:34', '2026-04-23 22:17:27', 1, '2026-04-23 21:06:34'),
(9, '185.9.44.197', 'test', 6, '2026-04-23 23:20:28', '2026-04-23 22:51:34', 0, NULL),
(10, '188.172.108.239', 'superadmin', 1, '2026-04-25 03:56:00', '2026-04-25 03:56:00', 0, NULL),
(11, '80.90.84.79', 'superadmin', 1, '2026-04-26 15:47:44', '2026-04-26 15:47:44', 0, NULL),
(12, '185.9.44.193', 'superadmin', 2, '2026-04-27 21:53:25', '2026-04-27 21:40:14', 0, NULL),
(13, '185.9.44.193', 'superadmin', 2, '2026-04-27 23:07:32', '2026-04-27 22:11:39', 0, NULL),
(14, '185.9.44.192', 'superadmin', 6, '2026-04-29 21:37:18', '2026-04-29 18:46:51', 0, NULL),
(15, '185.9.44.197', 'superadmin', 1, '2026-04-30 20:59:24', '2026-04-30 20:59:24', 0, NULL),
(16, '185.9.44.197', 'superadmin', 1, '2026-04-30 22:31:34', '2026-04-30 22:31:34', 0, NULL),
(17, '80.90.84.79', 'superadmin', 1, '2026-05-01 13:48:43', '2026-05-01 13:48:43', 0, NULL),
(18, '80.90.84.79', 'superadmin', 1, '2026-05-02 12:47:17', '2026-05-02 12:47:17', 0, NULL),
(19, '80.90.84.79', 'superadmin', 8, '2026-05-03 13:15:40', '2026-05-03 10:25:29', 0, NULL),
(20, '185.9.44.193', 'superadmin', 10, '2026-05-03 20:30:54', '2026-05-03 18:03:24', 0, NULL),
(21, '185.9.44.193', 'juri', 3, '2026-05-03 22:02:13', '2026-05-03 22:01:57', 1, '2026-05-03 20:17:13'),
(22, '185.9.44.193', 'superadmin', 3, '2026-05-03 23:19:09', '2026-05-03 22:02:24', 0, NULL),
(23, '188.172.109.213', 'superadmin', 1, '2026-05-04 10:03:26', '2026-05-04 10:03:26', 0, NULL),
(24, '185.9.44.194', 'superadmin', 2, '2026-05-04 20:41:15', '2026-05-04 20:19:07', 0, NULL),
(25, '185.9.44.194', 'superadmin', 1, '2026-05-04 22:27:13', '2026-05-04 22:27:13', 0, NULL),
(26, '80.90.84.79', 'demo', 4, '2026-05-05 09:41:40', '2026-05-05 08:12:31', 1, '2026-05-05 07:56:40'),
(27, '80.90.84.79', 'superadmin', 3, '2026-05-05 09:41:46', '2026-05-05 09:41:41', 1, '2026-05-05 07:56:46'),
(28, '80.90.84.79', 'demo', 3, '2026-05-05 10:24:35', '2026-05-05 09:41:53', 0, NULL),
(29, '185.9.44.196', 'demo', 2, '2026-05-12 22:46:16', '2026-05-12 22:44:20', 0, NULL);

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `setting_type` enum('text','textarea','image','color','select','checkbox') DEFAULT 'text',
  `setting_group` varchar(50) DEFAULT 'general',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `setting_group`, `created_at`, `updated_at`) VALUES
(1, 'contact_phone', '+355 69 123 4544', 'text', 'topbar', '2026-03-03 22:07:47', '2026-04-23 12:44:25'),
(2, 'contact_email', 'info@esc.com', 'text', 'topbar', '2026-03-03 22:07:47', '2026-03-03 22:09:02'),
(3, 'contact_address', 'Milano , Italia', 'text', 'topbar', '2026-03-03 22:07:47', '2026-05-05 10:04:36'),
(4, 'address_link', 'https://maps.google.com/?q=Milano', 'text', 'topbar', '2026-03-03 22:07:47', '2026-05-05 10:04:36'),
(5, 'facebook_url', 'https://facebook.com/111111', 'text', 'topbar', '2026-03-03 22:07:47', '2026-05-05 10:09:45'),
(6, 'instagram_url', 'https://instagram.com/11111', 'text', 'topbar', '2026-03-03 22:07:47', '2026-05-05 10:09:45'),
(7, 'youtube_url', '', 'text', 'topbar', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(8, 'tiktok_url', '', 'text', 'topbar', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(9, 'site_title', 'EscMarket - Auto nuove e usate in Italia', 'text', 'general', '2026-03-03 22:07:47', '2026-05-05 10:06:37'),
(10, 'site_description', 'EscMarket offre auto di qualità in Italia. Auto nuove e usate, prezzi competitivi, finanziamento e servizio post-vendita.', 'textarea', 'general', '2026-03-03 22:07:47', '2026-05-05 10:06:37'),
(11, 'site_keywords', 'auto, vendita auto, auto usate, auto nuove, auto market Italia, vetture, vendita auto', 'text', 'general', '2026-03-03 22:07:47', '2026-05-05 10:06:04'),
(12, 'site_author', 'EscMarket', 'text', 'general', '2026-03-03 22:07:47', '2026-05-05 10:06:37'),
(13, 'site_logo', 'uploads/settings/site_logo_1772917865.png', 'image', 'general', '2026-03-03 22:07:47', '2026-03-07 21:11:05'),
(14, 'site_logo_dark', '', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(15, 'favicon_16', '', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(16, 'favicon_32', '', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(17, 'favicon_ico', '', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(18, 'apple_touch_icon', '', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(19, 'og_image_default', 'Logo-Black-Transparent.png', 'image', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(20, 'twitter_handle', '@automarket', 'text', 'general', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(21, 'footer_copyright', '© 2026 EscMarket', 'textarea', 'footer', '2026-03-03 22:07:47', '2026-04-23 23:11:37'),
(22, 'footer_credit', '', 'text', 'footer', '2026-03-03 22:07:47', '2026-05-05 10:09:30'),
(23, 'google_analytics_id', '', 'text', 'scripts', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(24, 'google_tag_manager', '', 'text', 'scripts', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(25, 'header_scripts', '', 'textarea', 'scripts', '2026-03-03 22:07:47', '2026-04-27 22:12:16'),
(26, 'footer_scripts', '', 'textarea', 'scripts', '2026-03-03 22:07:47', '2026-03-03 22:07:47'),
(30, 'menu_bg_color', '#e0e0e0', 'color', 'general', '2026-03-06 22:33:06', '2026-05-03 22:19:22'),
(31, 'menu_text_color', '#000000', 'color', 'general', '2026-03-06 22:33:06', '2026-03-07 20:55:49'),
(32, 'menu_hover_color', '#4f720d', 'color', 'general', '2026-03-06 22:33:06', '2026-03-06 23:52:18'),
(33, 'admin_name_color', '#31bbdd', 'color', 'general', '2026-03-06 22:33:06', '2026-03-07 20:55:49'),
(34, 'topbar_bg_color', '#d1d1d1', 'color', 'topbar', '2026-03-06 22:33:06', '2026-03-06 23:42:02'),
(35, 'topbar_text_color', '#000000', 'color', 'topbar', '2026-03-06 22:33:06', '2026-03-06 23:51:30'),
(36, 'topbar_icon_color', '#70a7f0', 'color', 'topbar', '2026-03-06 22:33:06', '2026-03-06 23:51:30'),
(37, 'topbar_hover_color', '#3498db', 'color', 'topbar', '2026-03-06 22:33:06', '2026-03-06 22:33:06'),
(58, 'mobile_menu_icon_color', '#000000', 'text', 'general', '2026-03-06 23:25:55', '2026-04-21 20:41:18'),
(59, 'mobile_contact_bg', 'rgba(255, 255, 255, 0.5)', 'text', 'topbar', '2026-03-06 23:25:55', '2026-05-03 22:18:59'),
(60, 'mobile_contact_border', '#3498db', 'text', 'topbar', '2026-03-06 23:25:55', '2026-03-06 23:28:05'),
(61, 'logo_height', '80', 'text', 'general', '2026-03-06 23:49:56', '2026-03-07 21:11:10'),
(62, 'logo_padding', '', 'text', 'general', '2026-03-06 23:49:56', '2026-03-22 22:37:33'),
(63, 'logo_padding_left', '0', 'text', 'general', '2026-03-06 23:49:56', '2026-03-07 00:07:22'),
(64, 'logo_padding_right', '0', 'text', 'general', '2026-03-06 23:49:56', '2026-03-06 23:49:56'),
(65, 'logo_height_mobile', '70', 'text', 'general', '2026-03-06 23:58:06', '2026-03-07 21:11:15'),
(66, 'mobile_menu_close_color', '#4b5d22', 'color', 'general', '2026-04-21 20:44:26', '2026-04-21 20:44:47');

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

--
-- Table structure for table `whatsapp_settings`
--

CREATE TABLE `whatsapp_settings` (
  `id` int(11) NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `whatsapp_settings`
--

INSERT INTO `whatsapp_settings` (`id`, `setting_key`, `setting_value`) VALUES
(1, 'whatsapp_enabled', '1'),
(2, 'whatsapp_phone', '+355699484385'),
(3, 'whatsapp_link', 'https://wa.me/'),
(4, 'whatsapp_message', 'Hello, I am interested in a car!'),
(5, 'whatsapp_icon_size', '50'),
(6, 'whatsapp_icon_position', 'bottom-right'),
(7, 'whatsapp_icon_style', 'dark'),
(8, 'whatsapp_animation_type', 'pulse'),
(9, 'whatsapp_animation_speed', '2'),
(10, 'whatsapp_display_on_desktop', '1'),
(11, 'whatsapp_display_on_tablet', '1'),
(12, 'whatsapp_display_on_mobile', '1'),
(13, 'whatsapp_schedule_enabled', '0'),
(14, 'whatsapp_schedule_timezone', 'Europe/Tirane'),
(15, 'whatsapp_schedule_monday_start', '07:00'),
(16, 'whatsapp_schedule_monday_end', '18:00'),
(17, 'whatsapp_schedule_tuesday_start', '07:00'),
(18, 'whatsapp_schedule_tuesday_end', '18:00'),
(19, 'whatsapp_schedule_wednesday_start', '07:00'),
(20, 'whatsapp_schedule_wednesday_end', '18:00'),
(21, 'whatsapp_schedule_thursday_start', '07:00'),
(22, 'whatsapp_schedule_thursday_end', '18:00'),
(23, 'whatsapp_schedule_friday_start', '07:00'),
(24, 'whatsapp_schedule_friday_end', '18:00'),
(25, 'whatsapp_schedule_saturday_start', '07:00'),
(26, 'whatsapp_schedule_saturday_end', '10:00'),
(27, 'whatsapp_schedule_sunday_start', '00:00'),
(28, 'whatsapp_schedule_sunday_end', '00:00'),
(29, 'whatsapp_display_pages', 'all'),
(30, 'whatsapp_custom_css', ''),
(31, 'whatsapp_bottom_spacing', '20'),
(32, 'whatsapp_side_spacing', '20'),
(33, 'whatsapp_z_index', '9999');

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `car_slug` (`car_slug`);

--
-- Indexes for table `banners_backup`
--
ALTER TABLE `banners_backup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `car_slug` (`car_slug`);

--
-- Indexes for table `cars`
--
ALTER TABLE `cars`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD UNIQUE KEY `slug_2` (`slug`),
  ADD UNIQUE KEY `slug_3` (`slug`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `admin_id` (`admin_id`);

--
-- Indexes for table `car_gallery`
--
ALTER TABLE `car_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `car_id` (`car_id`);

--
-- Indexes for table `car_has_options`
--
ALTER TABLE `car_has_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_car_option` (`car_id`,`option_id`),
  ADD KEY `option_id` (`option_id`);

--
-- Indexes for table `car_models`
--
ALTER TABLE `car_models`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_model` (`category_id`,`name`);

--
-- Indexes for table `car_options`
--
ALTER TABLE `car_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `contact_messages`
--
ALTER TABLE `contact_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `car_id` (`car_id`),
  ADD KEY `admin_id` (`admin_id`),
  ADD KEY `idx_type` (`type`);

--
-- Indexes for table `email_settings`
--
ALTER TABLE `email_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `login_attempts`
--
ALTER TABLE `login_attempts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ip_address` (`ip_address`),
  ADD KEY `idx_blocked_until` (`blocked_until`);

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`),
  ADD KEY `idx_group` (`setting_group`);

--
-- Indexes for table `whatsapp_settings`
--
ALTER TABLE `whatsapp_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `banners_backup`
--
ALTER TABLE `banners_backup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cars`
--
ALTER TABLE `cars`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `car_gallery`
--
ALTER TABLE `car_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1157;

--
-- AUTO_INCREMENT for table `car_has_options`
--
ALTER TABLE `car_has_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1124;

--
-- AUTO_INCREMENT for table `car_models`
--
ALTER TABLE `car_models`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;

--
-- AUTO_INCREMENT for table `car_options`
--
ALTER TABLE `car_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `contact_messages`
--
ALTER TABLE `contact_messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=56;

--
-- AUTO_INCREMENT for table `email_settings`
--
ALTER TABLE `email_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=298;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `whatsapp_settings`
--
ALTER TABLE `whatsapp_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=382;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cars`
--
ALTER TABLE `cars`
  ADD CONSTRAINT `cars_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `cars_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`);

--
-- Constraints for table `car_gallery`
--
ALTER TABLE `car_gallery`
  ADD CONSTRAINT `car_gallery_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `car_has_options`
--
ALTER TABLE `car_has_options`
  ADD CONSTRAINT `car_has_options_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `car_has_options_ibfk_2` FOREIGN KEY (`option_id`) REFERENCES `car_options` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `car_models`
--
ALTER TABLE `car_models`
  ADD CONSTRAINT `car_models_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `contact_messages`
--
ALTER TABLE `contact_messages`
  ADD CONSTRAINT `contact_messages_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `contact_messages_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;
COMMIT;

