-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Czas generowania: 02 Sty 2021, 15:40
-- Wersja serwera: 10.4.13-MariaDB
-- Wersja PHP: 7.4.8

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

--
-- Baza danych: `hotele`
--

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

--
-- Struktura tabeli dla tabeli `hotele`
--

CREATE TABLE `hotele` (
  `id_hotel` int(11) NOT NULL,
  `nazwa` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_kraj` int(11) DEFAULT NULL,
  `id_miasto` int(11) DEFAULT NULL,
  `adres` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gwiazdki` int(11) DEFAULT NULL,
  `telefon` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `www` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `hotele`
--

INSERT INTO `hotele` (`id_hotel`, `nazwa`, `id_kraj`, `id_miasto`, `adres`, `gwiazdki`, `telefon`, `email`, `www`) VALUES
(1, 'Dwoobok', 1, 1, 'Ul.Zielona 11', 2, '+48 22 5896 57 49', 'Dwoobok@przyklad.pl', 'www.Dwoobok.twoja_domena.pl'),
(2, 'Tri-hotel', 1, 1, 'Ul.Zielna 14', 3, '+48 22 138 16 84', 'Tri-hotel@przyklad.pl', 'www.Tri-hotel.twoja_domena.pl'),
(3, 'Czworak', 1, 1, 'Ul.Barwna 67', 4, '+48 22 158 64 78', 'Czworak@przyklad.pl', 'www.Czworak.twoja_domena.pl'),
(4, 'PiÄtaszek', 1, 1, 'Ul.Jutra 1', 5, '+48 22 364 12 21', 'PiÄtaszek@przyklad.pl', 'www.PiÄtaszek.twoja_domena.pl'),
(5, 'SzeĹcian', 1, 1, 'Ul.SzeĹcienna 42', 4, '+48 22 137 98 65', 'SzeĹcian@przyklad.pl', 'www.SzeĹcian.twoja_domena.pl'),
(6, 'Sioodemka', 1, 2, 'Ul.JaĹminowa 12', 3, '+48 12 987 65 32', 'Sioodemka@przyklad.pl', 'www.Sioodemka.twoja_domena.pl'),
(7, 'O-Ratio', 1, 2, 'Ul.DÄbowa 33', 2, '+48 12 654 32 45', 'O-Ratio@przyklad.pl', 'www.O-Ratio.twoja_domena.pl'),
(8, 'Nine-levels', 1, 2, 'Ul.Klonowa 7', 3, '+48 12 546 12 78', 'Nine-levels@przyklad.pl', 'www.Nine-levels.twoja_domena.pl'),
(9, 'B-Ten', 1, 2, 'Ul.Bukowa 43', 4, '+48 12 753 45 45', 'B-Ten@przyklad.pl', 'www.B-Ten.twoja_domena.pl'),
(10, 'O-Eleven', 1, 3, 'Ul.Brzozowa 2', 5, '+48 32 123 45 45', 'O-Eleven@przyklad.pl', 'www.O-Eleven.twoja_domena.pl'),
(11, 'Twelwe', 1, 3, 'Ul.Czeremchowa 218', 4, '+48 32 654 87 54', 'Twelwe@przyklad.pl', 'www.Twelwe.twoja_domena.pl'),
(12, 'TTN', 1, 3, 'Ul.JabĹoni 23', 3, '+48 32 841 84 14', 'TTN@przyklad.pl', 'www.TTN.twoja_domena.pl'),
(13, 'F-T-Hotele', 1, 4, 'Ul.Jesionowa 63', 2, '+48 61 985 65 89', 'F-T-Hotele@przyklad.pl', 'www.F-T-Hotele.twoja_domena.pl'),
(14, 'Memo', 1, 4, 'Ul.Olchowa 83', 3, '+48 61 658 96 58', 'Memo@przyklad.pl', 'www.Memo.twoja_domena.pl'),
(15, 'Liil', 1, 4, 'Ul.GĹogowa 35', 4, '+48 61 225 44 66', 'Liil@przyklad.pl', 'www.Liil.twoja_domena.pl'),
(16, 'Paf', 1, 4, 'Ul.Ul.Zielna 11 63', 2, '+48 61 5896 57 49', 'Paf@przyklad.pl', 'www.Paf.twoja_domena.pl'),
(17, 'Tio', 1, 5, 'Ul.Piaskowa 6', 3, '+48 58 138 16 84', 'Tio@przyklad.pl', 'www.Tio.twoja_domena.pl'),
(18, 'Arrci', 1, 5, 'Ul.Pystynna 4', 4, '+48 58 158 64 78', 'Arrci@przyklad.pl', 'www.Arrci.twoja_domena.pl'),
(19, 'Ryzat', 1, 5, 'Ul.Rzeczna 66', 5, '+48 58 364 12 21', 'Ryzat@przyklad.pl', 'www.Ryzat.twoja_domena.pl'),
(20, 'Zia', 1, 5, 'Ul.Hotelowa 5', 4, '+48 58 137 98 65', 'Zia@przyklad.pl', 'www.Zia.twoja_domena.pl'),
(21, 'Velu', 1, 6, 'Ul.Jasna 2', 3, '+48 17 987 65 32', 'Velu@przyklad.pl', 'www.Velu.twoja_domena.pl'),
(22, 'Vea', 1, 6, 'Ul.BiaĹa 89', 2, '+48 17 654 32 45', 'Vea@przyklad.pl', 'www.Vea.twoja_domena.pl'),
(23, 'Gakof', 2, 7, 'White street 15', 3, '+353 546 12 78', 'Gakof@przyklad.pl', 'www.Gakof.twoja_domena.pl'),
(24, 'Hady', 2, 7, 'Orange street 69', 4, '+353 753 45 45', 'Hady@przyklad.pl', 'www.Hady.twoja_domena.pl'),
(25, 'Bel', 3, 8, 'St John St 5', 5, '+44 171 123 45 45', 'Bel@przyklad.pl', 'www.Bel.twoja_domena.pl'),
(26, 'Hifu', 3, 8, 'Elia St 1', 4, '+44 171 654 87 54', 'Hifu@przyklad.pl', 'www.Hifu.twoja_domena.pl'),
(27, 'Zumder', 3, 8, 'New St 7', 3, '+44 171 841 84 14', 'Zumder@przyklad.pl', 'www.Zumder.twoja_domena.pl'),
(28, 'Bumgi', 4, 9, 'Kreslicka 5', 3, '+420 658 96 58', 'Bumgi@przyklad.pl', 'www.Bumgi.twoja_domena.pl'),
(29, 'Cus', 4, 9, 'Kozacka 5', 2, '+420 985 65 89', 'Cus@przyklad.pl', 'www.Cus.twoja_domena.pl'),
(30, 'Bumgi', 4, 9, 'Krynmska 5', 3, '+420 658 96 58', 'Bumgi@przyklad.pl', 'www.Bumgi.twoja_domena.pl'),
(31, 'Cus', 5, 10, 'Medena 5', 2, '+421 7  985 65 89', 'Cus@przyklad.pl', 'www.Cus.twoja_domena.pl'),
(32, 'Lagi', 5, 10, 'Dunajska 8', 3, '+421 7  591 65 74', 'Lagi@przyklad.pl', 'www.Lagi.twoja_domena.pl'),
(33, 'Lumi', 6, 11, 'Kopenicker Str.3', 4, '+49 123846084', 'Lumi@przyklad.pl', 'www.Lumi.twoja_domena.pl'),
(34, 'Mikka', 6, 11, 'Berlin Str.74', 5, '+49 761954845', 'Mikka@przyklad.pl', 'www.Mikka.twoja_domena.pl'),
(35, 'Leo', 6, 11, 'Noger Str.37', 4, '+49 761845954', 'Leo@przyklad.pl', 'www.Leo.twoja_domena.pl'),
(36, 'Lungari', 7, 12, 'Rue de Rivoli 55', 3, '+32 985 89 65', 'Lungari@przyklad.pl', 'www.Lungari.twoja_domena.pl'),
(37, 'Lambe', 7, 12, 'Avenue Victoria 3', 2, '+32 965 32 87', 'Lambe@przyklad.pl', 'www.Lambe.twoja_domena.pl'),
(38, 'Pirue', 7, 12, 'Rue Pernelle 46', 3, '+32 652 45 43', 'Pirue@przyklad.pl', 'www.Pirue.twoja_domena.pl');

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

--
-- Struktura tabeli dla tabeli `klienci`
--

CREATE TABLE `klienci` (
  `id_klient` int(11) NOT NULL,
  `imie` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nazwisko` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `id_kraju` int(11) DEFAULT NULL,
  `id_miasto` int(11) DEFAULT NULL,
  `adres` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `licznik` int(11) DEFAULT NULL,
  `nr_dokumentacji` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `klienci`
--

INSERT INTO `klienci` (`id_klient`, `imie`, `nazwisko`, `id_kraju`, `id_miasto`, `adres`, `licznik`, `nr_dokumentacji`) VALUES
(1, 'Piotr', 'Aktoriusz', 1, 1, 'Ul.	Codzienna	3', 1, 'AAA 00000001'),
(2, 'Jan', 'Fejsbuczak', 1, 1, 'Ul.	Letnia	56', 0, 'AAA 00000002'),
(3, 'Aldona', 'Cisowiak', 1, 1, 'Ul.	Jesienna	8', 0, 'AAA 00000003'),
(4, 'Ilona', 'Murowanka', 1, 2, 'Ul.	Zimowa	3', 0, 'AAA 00000004'),
(5, 'Jacek', 'Profiliusz', 1, 2, 'Ul.	Zaporowa	4', 1, 'AAA 00000005'),
(6, 'Lucjusz', 'Mafojczak', 1, 3, 'Ul.	Ciemna	3', 0, 'AAA 00000006'),
(7, 'Lidia', 'Jazowiak', 1, 3, 'Ul.	Zimna	6', 1, 'AAA 00000007'),
(8, 'Zuza', 'Oneciak', 1, 4, 'Ul.	Zwierzyniecka	7', 2, 'AAA 00000008'),
(9, 'Pola', 'Interiusz', 1, 5, 'Ul.	Klonowa	45', 0, 'AAA 00000009'),
(10, 'Cyprian', 'KiepĹciuch', 1, 6, 'Ul.	Kwiatowa	34', 4, 'AAA 00000010'),
(11, 'Piotr', 'Komputerik', 1, 6, 'Ul.	PomaraĹczowa	6', 3, 'AAA 00000011'),
(12, 'Maria', 'Elmecka', 1, 6, 'Ul.	Zielona	43', 0, 'AAA 00000012'),
(13, 'Dariusz', 'DrzewoĹaz', 2, 7, 'Ul.	St Eve St	34', 1, 'AAA 00000013'),
(14, 'Cecylia', 'Kobiecka', 2, 7, 'Ul.	St John St	6', 0, 'AAA 00000014'),
(15, 'Leopold', 'Banko', 3, 8, 'Ul.	St Tomas St	3', 1, 'AAA 00000015'),
(16, 'Zofia', 'Otwarty', 3, 8, 'Ul.	St Lucas St	6', 0, 'AAA 00000016'),
(17, 'Adam', 'Euforik', 4, 9, 'Ul.	Podkopova	45', 0, 'AAA 00000017'),
(18, 'MichaĹ', 'KomĂłrczak', 5, 10, 'Ul.	Prekopova	6', 0, 'AAA 00000018'),
(19, 'MirosĹaw', 'Ekspresik', 6, 11, 'Ul.	Lukas Str.	34', 1, 'AAA 00000019'),
(20, 'Dariusz', 'Googlarz', 7, 12, 'Ul.	Rue De Rao	6', 0, 'AAA 00000020'),
(21, 'Milena', 'ZgĹoska', 7, 12, 'Ul.	Rue Di Deo	45', 1, 'AAA 00000021');

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

--
-- Struktura tabeli dla tabeli `kraje`
--

CREATE TABLE `kraje` (
  `id_kraju` int(11) NOT NULL,
  `nazwa_kraju` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kod_kraju` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `kraje`
--

INSERT INTO `kraje` (`id_kraju`, `nazwa_kraju`, `kod_kraju`) VALUES
(1, 'Polska', 'PL'),
(2, 'Irandia', 'IE'),
(3, 'Anglia', 'GB'),
(4, 'Czechy', 'CZ'),
(5, 'SĹowacja', 'SK'),
(6, 'Niemcy', 'DE'),
(7, 'Francja', 'FR');

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

--
-- Struktura tabeli dla tabeli `miasta`
--

CREATE TABLE `miasta` (
  `id_miasta` int(11) NOT NULL,
  `nazwa_miasta` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kod_miasta` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `miasta`
--

INSERT INTO `miasta` (`id_miasta`, `nazwa_miasta`, `kod_miasta`) VALUES
(1, 'Warszawa', '02-495'),
(2, 'KrakĂłw', '31-144'),
(3, 'Katowice', ''),
(4, 'PoznaĹ', ''),
(5, 'GdaĹsk', ''),
(6, 'RzeszĂłw', ''),
(7, 'Dublin', ''),
(8, 'Londyn', ''),
(9, 'Praga', ''),
(10, 'BratysĹawa', ''),
(11, 'Berlin', ''),
(12, 'ParyĹź', '');

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

--
-- Struktura tabeli dla tabeli `parking`
--

CREATE TABLE `parking` (
  `id_parking` int(11) NOT NULL,
  `id_hotel` int(11) DEFAULT NULL,
  `numer` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `parking`
--

INSERT INTO `parking` (`id_parking`, `id_hotel`, `numer`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 1, 4),
(5, 1, 5),
(6, 1, 6),
(7, 1, 7),
(8, 1, 8),
(9, 1, 9),
(10, 1, 10),
(11, 3, 1),
(12, 3, 2),
(13, 3, 3),
(14, 3, 4),
(15, 3, 5),
(16, 4, 1),
(17, 4, 2),
(18, 4, 3),
(19, 4, 4),
(20, 4, 5),
(21, 5, 1),
(22, 5, 2),
(23, 5, 3),
(24, 5, 4),
(25, 5, 5),
(26, 6, 1),
(27, 6, 2),
(28, 6, 3),
(29, 6, 4),
(30, 6, 5),
(31, 7, 1),
(32, 7, 2),
(33, 7, 3),
(34, 7, 4),
(35, 7, 5),
(36, 7, 6),
(37, 7, 7),
(38, 9, 1),
(39, 9, 2),
(40, 9, 3),
(41, 9, 4),
(42, 9, 5),
(43, 9, 6),
(44, 9, 7),
(45, 9, 8),
(46, 10, 1),
(47, 10, 2),
(48, 10, 3),
(49, 10, 4),
(50, 10, 5),
(51, 11, 1),
(52, 11, 2),
(53, 11, 3),
(54, 11, 4),
(55, 11, 5),
(56, 12, 1),
(57, 12, 2),
(58, 12, 3),
(59, 12, 4),
(60, 12, 5),
(61, 12, 6),
(62, 12, 7),
(63, 12, 8),
(64, 12, 9),
(65, 14, 1),
(66, 14, 2),
(67, 14, 3),
(68, 14, 4),
(69, 14, 5),
(70, 14, 6),
(71, 15, 1),
(72, 15, 2),
(73, 15, 3),
(74, 15, 4),
(75, 15, 5),
(76, 16, 1),
(77, 16, 2),
(78, 16, 3),
(79, 16, 4),
(80, 16, 5),
(81, 16, 6),
(82, 16, 7),
(83, 16, 8),
(84, 16, 9),
(85, 16, 10),
(86, 18, 1),
(87, 18, 2),
(88, 18, 3),
(89, 18, 4),
(90, 18, 5),
(91, 19, 1),
(92, 19, 2),
(93, 19, 3),
(94, 19, 4),
(95, 19, 5),
(96, 20, 1),
(97, 20, 2),
(98, 20, 3),
(99, 20, 4),
(100, 20, 5),
(101, 21, 1),
(102, 21, 2),
(103, 21, 3),
(104, 21, 4),
(105, 21, 5),
(106, 21, 6),
(107, 22, 1),
(108, 22, 2),
(109, 22, 3),
(110, 22, 4),
(111, 23, 1),
(112, 23, 2),
(113, 23, 3),
(114, 23, 4),
(115, 23, 5),
(116, 24, 1),
(117, 24, 2),
(118, 24, 3),
(119, 24, 4),
(120, 24, 5),
(121, 24, 6),
(122, 24, 7),
(123, 24, 8),
(124, 25, 1),
(125, 25, 2),
(126, 26, 1),
(127, 26, 2),
(128, 26, 3),
(129, 26, 4),
(130, 26, 5),
(131, 27, 1),
(132, 27, 2),
(133, 27, 3),
(134, 27, 4),
(135, 27, 5),
(136, 28, 1),
(137, 28, 2),
(138, 28, 3),
(139, 28, 4),
(140, 28, 5),
(141, 30, 1),
(142, 30, 2),
(143, 30, 3),
(144, 30, 4),
(145, 30, 5),
(146, 30, 6),
(147, 30, 7),
(148, 30, 8),
(149, 30, 9),
(150, 30, 10),
(151, 30, 11),
(152, 30, 12),
(153, 31, 1),
(154, 31, 2),
(155, 31, 3),
(156, 32, 1),
(157, 32, 2),
(158, 32, 3),
(159, 32, 4),
(160, 32, 5),
(161, 33, 1),
(162, 33, 2),
(163, 33, 3),
(164, 33, 4),
(165, 33, 5),
(166, 34, 1),
(167, 34, 2),
(168, 34, 3),
(169, 34, 4),
(170, 34, 5),
(171, 35, 1),
(172, 35, 2),
(173, 35, 3),
(174, 35, 4),
(175, 35, 5),
(176, 36, 1),
(177, 36, 2),
(178, 36, 3),
(179, 36, 4),
(180, 36, 5),
(181, 36, 6),
(182, 36, 7),
(183, 37, 1),
(184, 37, 2),
(185, 37, 3),
(186, 37, 4),
(187, 38, 1),
(188, 38, 2),
(189, 38, 3),
(190, 38, 4);

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

--
-- Struktura tabeli dla tabeli `pokoje`
--

CREATE TABLE `pokoje` (
  `id_pokoju` int(11) NOT NULL,
  `id_hotel` int(11) DEFAULT NULL,
  `nr_pokoju` int(11) DEFAULT NULL,
  `pietro` int(11) DEFAULT NULL,
  `ludzie` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `pokoje`
--

INSERT INTO `pokoje` (`id_pokoju`, `id_hotel`, `nr_pokoju`, `pietro`, `ludzie`) VALUES
(1, 1, 1, 1, 1),
(2, 1, 2, 2, 2),
(3, 1, 3, 3, 3),
(4, 1, 4, 4, 4),
(5, 1, 5, 5, 5),
(6, 2, 11, 1, 2),
(7, 2, 22, 2, 3),
(8, 2, 33, 3, 4),
(9, 2, 44, 4, 5),
(10, 2, 55, 5, 2),
(11, 3, 1, 1, 1),
(12, 3, 2, 1, 1),
(13, 3, 3, 2, 2),
(14, 3, 4, 2, 2),
(15, 3, 5, 3, 3),
(16, 4, 12, 2, 2),
(17, 4, 23, 2, 3),
(18, 4, 34, 2, 2),
(19, 4, 45, 2, 3),
(20, 4, 56, 2, 2),
(21, 5, 1, 2, 2),
(22, 5, 2, 2, 2),
(23, 5, 3, 3, 3),
(24, 5, 4, 3, 3),
(25, 5, 5, 4, 4),
(26, 6, 1, 1, 1),
(27, 6, 2, 2, 2),
(28, 6, 3, 3, 3),
(29, 6, 4, 4, 4),
(30, 6, 5, 5, 5),
(31, 7, 11, 1, 2),
(32, 7, 22, 2, 3),
(33, 7, 33, 3, 4),
(34, 7, 44, 4, 5),
(35, 7, 55, 5, 2),
(36, 8, 1, 1, 1),
(37, 8, 2, 1, 1),
(38, 8, 3, 2, 2),
(39, 8, 4, 2, 2),
(40, 8, 5, 3, 3),
(41, 9, 12, 2, 2),
(42, 9, 23, 2, 3),
(43, 9, 34, 2, 2),
(44, 9, 45, 2, 3),
(45, 9, 56, 2, 2),
(46, 10, 1, 2, 2),
(47, 10, 2, 2, 2),
(48, 10, 3, 3, 3),
(49, 10, 4, 3, 3),
(50, 10, 5, 4, 4),
(51, 11, 1, 1, 1),
(52, 11, 2, 2, 2),
(53, 11, 3, 3, 3),
(54, 11, 4, 4, 4),
(55, 11, 5, 5, 5),
(56, 12, 11, 1, 2),
(57, 12, 22, 2, 3),
(58, 12, 33, 3, 4),
(59, 12, 44, 4, 5),
(60, 12, 55, 5, 2),
(61, 13, 1, 1, 1),
(62, 13, 2, 1, 1),
(63, 13, 3, 2, 2),
(64, 13, 4, 2, 2),
(65, 13, 5, 3, 3),
(66, 14, 12, 2, 2),
(67, 14, 23, 2, 3),
(68, 14, 34, 2, 2),
(69, 14, 45, 2, 3),
(70, 14, 56, 2, 2),
(71, 15, 1, 2, 2),
(72, 15, 2, 2, 2),
(73, 15, 3, 3, 3),
(74, 15, 4, 3, 3),
(75, 15, 5, 4, 4),
(76, 16, 1, 1, 1),
(77, 16, 2, 2, 2),
(78, 16, 3, 3, 3),
(79, 16, 4, 4, 4),
(80, 16, 5, 5, 5),
(81, 17, 11, 1, 2),
(82, 17, 22, 2, 3),
(83, 17, 33, 3, 4),
(84, 17, 44, 4, 5),
(85, 17, 55, 5, 2),
(86, 18, 1, 1, 1),
(87, 18, 2, 1, 1),
(88, 18, 3, 2, 2),
(89, 18, 4, 2, 2),
(90, 18, 5, 3, 3),
(91, 19, 12, 2, 2),
(92, 19, 23, 2, 3),
(93, 19, 34, 2, 2),
(94, 19, 45, 2, 3),
(95, 19, 56, 2, 2),
(96, 20, 1, 2, 2),
(97, 20, 2, 2, 2),
(98, 20, 3, 3, 3),
(99, 20, 4, 3, 3),
(100, 20, 5, 4, 4),
(101, 21, 1, 1, 1),
(102, 21, 2, 2, 2),
(103, 21, 3, 3, 3),
(104, 21, 4, 4, 4),
(105, 21, 5, 5, 5),
(106, 22, 11, 1, 2),
(107, 22, 22, 2, 3),
(108, 22, 33, 3, 4),
(109, 22, 44, 4, 5),
(110, 22, 55, 5, 2),
(111, 23, 1, 1, 1),
(112, 23, 2, 1, 1),
(113, 23, 3, 2, 2),
(114, 23, 4, 2, 2),
(115, 23, 5, 3, 3),
(116, 24, 12, 2, 2),
(117, 24, 23, 2, 3),
(118, 24, 34, 2, 2),
(119, 24, 45, 2, 3),
(120, 24, 56, 2, 2),
(121, 25, 1, 2, 2),
(122, 25, 2, 2, 2),
(123, 25, 3, 3, 3),
(124, 25, 4, 3, 3),
(125, 25, 5, 4, 4),
(126, 26, 1, 1, 1),
(127, 26, 2, 2, 2),
(128, 26, 3, 3, 3),
(129, 26, 4, 4, 4),
(130, 26, 5, 5, 5),
(131, 27, 11, 1, 2),
(132, 27, 22, 2, 3),
(133, 27, 33, 3, 4),
(134, 27, 44, 4, 5),
(135, 27, 55, 5, 2),
(136, 28, 1, 1, 1),
(137, 28, 2, 1, 1),
(138, 28, 3, 2, 2),
(139, 28, 4, 2, 2),
(140, 28, 5, 3, 3),
(141, 29, 12, 2, 2),
(142, 29, 23, 2, 3),
(143, 29, 34, 2, 2),
(144, 29, 45, 2, 3),
(145, 29, 56, 2, 2),
(146, 30, 1, 2, 2),
(147, 30, 2, 2, 2),
(148, 30, 3, 3, 3),
(149, 30, 4, 3, 3),
(150, 30, 5, 4, 4),
(151, 31, 1, 1, 1),
(152, 31, 2, 2, 2),
(153, 31, 3, 3, 3),
(154, 31, 4, 4, 4),
(155, 31, 5, 5, 5),
(156, 32, 11, 1, 2),
(157, 32, 22, 2, 3),
(158, 32, 33, 3, 4),
(159, 32, 44, 4, 5),
(160, 32, 55, 5, 2),
(161, 33, 1, 1, 1),
(162, 33, 2, 1, 1),
(163, 33, 3, 2, 2),
(164, 33, 4, 2, 2),
(165, 33, 5, 3, 3),
(166, 34, 12, 2, 2),
(167, 34, 23, 2, 3),
(168, 34, 34, 2, 2),
(169, 34, 45, 2, 3),
(170, 34, 56, 2, 2),
(171, 35, 1, 2, 2),
(172, 35, 2, 2, 2),
(173, 35, 3, 3, 3),
(174, 35, 4, 3, 3),
(175, 35, 5, 4, 4),
(176, 36, 1, 1, 1),
(177, 36, 2, 2, 2),
(178, 36, 3, 3, 3),
(179, 36, 4, 4, 4),
(180, 36, 5, 5, 5),
(181, 37, 11, 1, 2),
(182, 37, 22, 2, 3),
(183, 37, 33, 3, 4),
(184, 37, 44, 4, 5),
(185, 37, 55, 5, 2),
(186, 38, 1, 1, 1),
(187, 38, 2, 1, 1),
(188, 38, 3, 2, 2),
(189, 38, 4, 2, 2),
(190, 38, 5, 3, 3);

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

--
-- Struktura tabeli dla tabeli `rezerwacje`
--

CREATE TABLE `rezerwacje` (
  `id_rezerwacji` int(11) NOT NULL,
  `id_klient` int(11) DEFAULT NULL,
  `data_start_rezerwacji` date DEFAULT NULL,
  `data_koniec_rezerwacji` date DEFAULT NULL,
  `id_pokoju` int(11) DEFAULT NULL,
  `id_parking` int(11) DEFAULT NULL,
  `zrealizowane` bit(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Zrzut danych tabeli `rezerwacje`
--

INSERT INTO `rezerwacje` (`id_rezerwacji`, `id_klient`, `data_start_rezerwacji`, `data_koniec_rezerwacji`, `id_pokoju`, `id_parking`, `zrealizowane`) VALUES
(1, 1, '2016-05-12', '2016-05-13', 3, NULL, b'1'),
(2, 2, '2016-05-14', '2016-05-16', 5, NULL, b'1'),
(3, 3, '2016-05-17', '2016-05-20', 8, NULL, b'1'),
(4, 4, '2016-05-21', '2016-05-25', 12, 3, b'1'),
(5, 5, '2016-05-26', '2016-05-31', 17, NULL, b'0'),
(6, 6, '2016-06-01', '2016-06-07', 23, 1, b'1'),
(7, 7, '2016-06-08', '2016-06-15', 30, 1, b'0'),
(8, 8, '2016-06-16', '2016-06-24', 38, NULL, b'0'),
(9, 9, '2016-06-25', '2016-07-04', 47, 1, b'0'),
(10, 10, '2016-07-05', '2016-07-15', 57, 2, b'1'),
(11, 11, '2016-07-16', '2016-07-27', 68, 2, b'1'),
(12, 12, '2016-07-28', '2016-08-09', 80, 3, b'1'),
(13, 13, '2016-08-10', '2016-08-23', 93, 1, b'0'),
(14, 14, '2016-08-24', '2016-09-07', 107, 4, b'1'),
(15, 15, '2016-09-08', '2016-09-23', 122, 1, b'1'),
(16, 16, '2016-09-24', '2016-10-10', 138, 2, b'0'),
(17, 17, '2016-10-11', '2016-10-28', 155, 3, b'0'),
(18, 18, '2016-10-29', '2016-11-16', 173, NULL, b'1'),
(19, 19, '2016-11-17', '2016-12-06', 190, NULL, b'0'),
(20, 20, '2016-12-07', '2016-12-27', 172, 1, b'1'),
(21, 5, '2016-12-12', '2016-12-17', 167, 1, b'0'),
(22, 7, '2016-12-19', '2016-12-26', 160, 3, b'1'),
(23, 9, '2016-12-28', '2017-01-06', 151, 1, b'1'),
(24, 1, '2016-12-29', '2016-12-30', 150, 1, b'1'),
(25, 5, '2017-01-03', '2017-01-08', 145, NULL, b'1'),
(26, 3, '2017-01-06', '2017-01-09', 142, NULL, b'1'),
(27, 7, '2017-01-13', '2017-01-20', 135, 1, b'1'),
(28, 2, '2017-01-15', '2017-01-17', 133, 2, b'1'),
(29, 4, '2017-01-19', '2017-01-23', 129, NULL, b'1'),
(30, 6, '2017-01-25', '2017-01-31', 123, 2, b'1'),
(31, 8, '2017-02-02', '2017-02-10', 115, 2, b'1'),
(32, 9, '2017-02-11', '2017-02-20', 106, 3, b'0'),
(33, 3, '2017-02-14', '2017-02-17', 103, NULL, b'1'),
(34, 2, '2017-02-16', '2017-02-18', 101, NULL, b'0'),
(35, 5, '2017-02-21', '2017-02-26', 96, 1, b'1'),
(36, 12, '2017-03-05', '2017-03-17', 84, NULL, b'1'),
(37, 14, '2017-03-19', '2017-04-02', 70, 1, b'1'),
(38, 17, '2017-04-05', '2017-04-22', 53, 2, b'1'),
(39, 19, '2017-04-24', '2017-05-13', 34, 2, b'1'),
(40, 3, '2017-04-27', '2017-04-30', 31, 3, b'1'),
(41, 5, '2017-05-02', '2017-05-07', 26, 1, b'0'),
(42, 9, '2017-05-11', '2017-05-20', 17, 2, b'1'),
(43, 11, '2017-05-22', '2017-06-02', 6, NULL, b'0'),
(44, 10, '2017-06-01', '2017-06-11', 17, 3, b'1'),
(45, 14, '2017-06-15', '2017-06-29', 27, 1, b'0'),
(46, 15, '2017-06-30', '2017-07-15', 41, 1, b'1'),
(47, 12, '2017-07-12', '2017-07-24', 56, 2, b'1'),
(48, 1, '2017-07-13', '2017-07-14', 68, 3, b'1'),
(49, 9, '2017-07-22', '2017-07-31', 69, 4, b'1'),
(50, 3, '2017-07-25', '2017-07-28', 78, NULL, b'1');

--
-- Indeksy dla zrzutĂłw tabel
--

--
-- Indeksy dla tabeli `hotele`
--
ALTER TABLE `hotele`
  ADD PRIMARY KEY (`id_hotel`),
  ADD KEY `fk_hotele_miasta` (`id_miasto`),
  ADD KEY `fk_hotele_kraje` (`id_kraj`);

--
-- Indeksy dla tabeli `klienci`
--
ALTER TABLE `klienci`
  ADD PRIMARY KEY (`id_klient`),
  ADD KEY `fk_klienci_miasta` (`id_miasto`),
  ADD KEY `fk_klienci_kraje` (`id_kraju`);

--
-- Indeksy dla tabeli `kraje`
--
ALTER TABLE `kraje`
  ADD PRIMARY KEY (`id_kraju`);

--
-- Indeksy dla tabeli `miasta`
--
ALTER TABLE `miasta`
  ADD PRIMARY KEY (`id_miasta`);

--
-- Indeksy dla tabeli `parking`
--
ALTER TABLE `parking`
  ADD PRIMARY KEY (`id_parking`);

--
-- Indeksy dla tabeli `pokoje`
--
ALTER TABLE `pokoje`
  ADD PRIMARY KEY (`id_pokoju`),
  ADD KEY `fk_pokoje_hotel` (`id_hotel`);

--
-- Indeksy dla tabeli `rezerwacje`
--
ALTER TABLE `rezerwacje`
  ADD PRIMARY KEY (`id_rezerwacji`),
  ADD KEY `fk_rezerwcje_pokoje` (`id_pokoju`),
  ADD KEY `fk_rezerwacje_klient` (`id_klient`),
  ADD KEY `fk_rezerwacje_parking` (`id_parking`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT dla tabeli `hotele`
--
ALTER TABLE `hotele`
  MODIFY `id_hotel` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT dla tabeli `klienci`
--
ALTER TABLE `klienci`
  MODIFY `id_klient` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT dla tabeli `kraje`
--
ALTER TABLE `kraje`
  MODIFY `id_kraju` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT dla tabeli `miasta`
--
ALTER TABLE `miasta`
  MODIFY `id_miasta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT dla tabeli `parking`
--
ALTER TABLE `parking`
  MODIFY `id_parking` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=191;

--
-- AUTO_INCREMENT dla tabeli `pokoje`
--
ALTER TABLE `pokoje`
  MODIFY `id_pokoju` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=191;

--
-- AUTO_INCREMENT dla tabeli `rezerwacje`
--
ALTER TABLE `rezerwacje`
  MODIFY `id_rezerwacji` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- Ograniczenia dla zrzutĂłw tabel
--

--
-- Ograniczenia dla tabeli `hotele`
--
ALTER TABLE `hotele`
  ADD CONSTRAINT `fk_hotele_kraje` FOREIGN KEY (`id_kraj`) REFERENCES `kraje` (`id_kraju`),
  ADD CONSTRAINT `fk_hotele_miasta` FOREIGN KEY (`id_miasto`) REFERENCES `miasta` (`id_miasta`);

--
-- Ograniczenia dla tabeli `klienci`
--
ALTER TABLE `klienci`
  ADD CONSTRAINT `fk_klienci_kraje` FOREIGN KEY (`id_kraju`) REFERENCES `kraje` (`id_kraju`),
  ADD CONSTRAINT `fk_klienci_miasta` FOREIGN KEY (`id_miasto`) REFERENCES `miasta` (`id_miasta`);

--
-- Ograniczenia dla tabeli `pokoje`
--
ALTER TABLE `pokoje`
  ADD CONSTRAINT `fk_pokoje_hotel` FOREIGN KEY (`id_hotel`) REFERENCES `hotele` (`id_hotel`);

--
-- Ograniczenia dla tabeli `rezerwacje`
--
ALTER TABLE `rezerwacje`
  ADD CONSTRAINT `fk_rezerwacje_klient` FOREIGN KEY (`id_klient`) REFERENCES `klienci` (`id_klient`),
  ADD CONSTRAINT `fk_rezerwacje_parking` FOREIGN KEY (`id_parking`) REFERENCES `parking` (`id_parking`),
  ADD CONSTRAINT `fk_rezerwcje_pokoje` FOREIGN KEY (`id_pokoju`) REFERENCES `pokoje` (`id_pokoju`);
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 */;