-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Počítač: 127.0.0.1
-- Vytvořeno: Úte 03. čen 2025, 19:11
-- Verze serveru: 10.4.32-MariaDB
-- Verze PHP: 8.2.12

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 */;

--
-- Databáze: `u-kulipe-01`
--

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

--
-- Struktura tabulky `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL,
  `brand` varchar(50) NOT NULL,
  `model` varchar(50) NOT NULL,
  `year` int(11) NOT NULL,
  `vin` varchar(50) NOT NULL,
  `license_plate` varchar(50) NOT NULL,
  `fuel` enum('Benzín','Diesel','Elektro','Hybrid','LPG/CNG') NOT NULL,
  `transmission` enum('Automatická','Manuální') NOT NULL,
  `color` varchar(50) NOT NULL,
  `status` enum('Dostupné','Půjčené','Servis') NOT NULL,
  `price_per_day` int(11) NOT NULL,
  `available_from` date DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_czech_ci;

--
-- Vypisuji data pro tabulku `vehicles`
--

INSERT INTO `vehicles` (`id`, `brand`, `model`, `year`, `vin`, `license_plate`, `fuel`, `transmission`, `color`, `status`, `price_per_day`, `available_from`, `image`) VALUES
(1, 'Škoda', 'Octavia', 2018, '85695274', '1AB2345', 'Diesel', 'Automatická', 'Černá', 'Dostupné', 0, NULL, 'images/octavia1.webp'),
(2, 'Volkswagen', 'Golf', 2019, '12385496', '2CD6789', 'Benzín', 'Automatická', 'Šedá', 'Servis', 0, '2025-06-27', 'images/golf1.webp'),
(3, 'Ford', 'Focus', 2017, '66937485', '3EF0123', 'Benzín', 'Automatická', 'Šedá', 'Půjčené', 0, '2025-05-24', 'images/focus1.webp'),
(4, 'Toyota', 'Corolla', 2020, '91738640', '4GH4567', 'Hybrid', 'Automatická', 'Bílá', 'Servis', 0, '2025-06-03', 'images/corolla1.png'),
(5, 'Renault', 'Clio', 2021, '07495315', '5IJ8901', 'Elektro', 'Automatická', 'Bílá', 'Půjčené', 0, '2025-06-08', 'images/clio1.webp');

--
-- Indexy pro exportované tabulky
--

--
-- Indexy pro tabulku `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
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 */;
