-- Adminer 4.8.1 MySQL 5.7.27-0ubuntu0.16.04.1 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brand` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `model` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `year` int(11) NOT NULL,
  `vin` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `license_plate` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `fuel` enum('Benzín','Diesel','Elektro','Hybrid','LPG/CNG') COLLATE utf8mb4_czech_ci NOT NULL,
  `color` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  `status` enum('Dostupné','Půjčené','Servis') COLLATE utf8mb4_czech_ci NOT NULL,
  `image` varchar(50) COLLATE utf8mb4_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;

INSERT INTO `vehicles` (`id`, `brand`, `model`, `year`, `vin`, `license_plate`, `fuel`, `color`, `status`, `image`) VALUES
(1,	'Škoda',	'Octavia',	2018,	'',	'1AB2345',	'Diesel',	'Černá',	'Dostupné',	'octavia1.webp'),
(2,	'Volkswagen',	'Golf',	2019,	'',	'2CD6789',	'Diesel',	'Šedá',	'Dostupné',	'golf1.webp'),
(3,	'Ford',	'Focus',	2017,	'',	'3EF0123',	'Benzín',	'Šedá',	'Půjčené',	'focus1.webp'),
(4,	'Toyota',	'Corolla',	2020,	'',	'4GH4567',	'Hybrid',	'Bílá',	'Servis',	'corolla1.png'),
(5,	'Renault',	'Clio',	2021,	'',	'5IJ8901',	'LPG/CNG',	'Bílá',	'Dostupné',	'clio1.webp');

-- 2025-04-29 07:19:08
