--
-- Struktura tabulky `vypujcky`
--

CREATE TABLE `vypujcky` (
  `idVypujcky` int(11) NOT NULL,
  `signatura` int(11) NOT NULL DEFAULT 0,
  `cisloLegitimace` int(11) NOT NULL DEFAULT 0,
  `datumVypujcky` date NOT NULL DEFAULT '0000-00-00',
  `datumVraceni` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `vypujcky`
--

INSERT INTO `vypujcky` (`idVypujcky`, `signatura`, `cisloLegitimace`, `datumVypujcky`, `datumVraceni`) VALUES
(1, 1, 1, '2022-12-02', '2023-01-09'),
(2, 1, 10,'2022-11-10', NULL),
(3, 2, 2, '2023-01-08', NULL),
(5, 3, 3, '2023-01-03', NULL),
(6, 3, 6, '2022-10-07', '2022-12-09'),
(7, 4, 3, '2022-12-20', '2023-01-04'),
(8, 4, 2, '2022-12-09', NULL);

--
-- Klíče pro exportované tabulky
--

--
-- Klíče pro tabulku `vypujcky`
--
ALTER TABLE `vypujcky`
  ADD PRIMARY KEY (`idVypujcky`),
  ADD KEY `signatura` (`signatura`),
  ADD KEY `cislo_legitimace` (`cisloLegitimace`);

