-- https://www.phpmyadmin.net/
--
-- Czas generowania: 11 Lut 2019, 17:23
-- Wersja serwera: 5.7.17-log
-- Wersja PHP: 5.6.30




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

--
-- Struktura tabeli dla tabeli `blocks`
--

CREATE TABLE `blocks` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pole1` longtext NOT NULL,
  `pole2` longtext NOT NULL,
  `pole3` longtext NOT NULL,
  `pole4` longtext NOT NULL,
  `pole5` longtext NOT NULL,
  `pole6` longtext NOT NULL,
  `pole7` longtext NOT NULL,
  `pole8` longtext NOT NULL,
  `pole9` longtext NOT NULL,
  `pole10` longtext NOT NULL,
  `pole11` longtext NOT NULL,
  `pole12` longtext NOT NULL,
  `pole13` longtext NOT NULL,
  `pole14` longtext NOT NULL,
  `pole15` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `bylostalo`
--

CREATE TABLE `bylostalo` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `img1` longtext NOT NULL,
  `alt1` longtext NOT NULL,
  `img2` longtext NOT NULL,
  `alt2` longtext NOT NULL,
  `description` longtext NOT NULL,
  `status_zapisu` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `image` varchar(255) NOT NULL,
  `alt` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `text` longtext NOT NULL,
  `mini_text` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status_zayavky` varchar(11) NOT NULL,
  `numer_formy` varchar(11) NOT NULL,
  `telefone` varchar(25) NOT NULL,
  `name` varchar(30) NOT NULL,
  `link_na_foto` varchar(100) NOT NULL,
  `comment` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Zrzut danych tabeli `comments`
--

INSERT INTO `comments` (`id`, `data`, `status_zayavky`, `numer_formy`, `telefone`, `name`, `link_na_foto`, `comment`) VALUES
(1, '2019-02-11 15:21:28', '1', '1', '+48098098098', 'Andrzej L.', 'https://site.com/img1.jpg', 'Text - Comment'),
(2, '2019-02-11 16:04:33', '1', 'Test', '+32100000000', '123Andrzej321', '123https://site.com/img1.jpg321', '123testextestextestextestext321'),
(3, '2019-02-11 16:22:14', '1', '000TesT000', '+32100000321', '000mmm000', '123https://site.com/img1.jpg321', 'TTTTTTTTTTTTTTTEEEEEEEEEEEEEESSSSSSSSSSSTTTTTTTTTTT');

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

--
-- Struktura tabeli dla tabeli `companies`
--

CREATE TABLE `companies` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `alt` varchar(255) NOT NULL,
  `text` longtext NOT NULL,
  `text2` longtext NOT NULL,
  `text3` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `grafik_pracy`
--

CREATE TABLE `grafik_pracy` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pole1` varchar(255) NOT NULL,
  `pole2` varchar(255) NOT NULL,
  `pole3` varchar(255) NOT NULL,
  `pole4` varchar(255) NOT NULL,
  `pole5` varchar(255) NOT NULL,
  `pole6` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `history`
--

CREATE TABLE `history` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `latitude` longtext NOT NULL,
  `longitude` longtext NOT NULL,
  `ip` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `language`
--

CREATE TABLE `language` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_lang_pack` int(11) NOT NULL,
  `name_langpack` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `podcategories`
--

CREATE TABLE `podcategories` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `image` varchar(255) NOT NULL,
  `alt` varchar(255) NOT NULL,
  `name` longtext NOT NULL,
  `slogan` longtext NOT NULL,
  `text` longtext NOT NULL,
  `mini_text` longtext NOT NULL,
  `cat_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `preimuszczestva`
--

CREATE TABLE `preimuszczestva` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status_zapisu` varchar(255) NOT NULL,
  `block` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `text` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `alt` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `data` int(11) NOT NULL,
  `meta_title` int(11) NOT NULL,
  `meta_keywords` int(11) NOT NULL,
  `meta_description` int(11) NOT NULL,
  `meta_favicon` int(11) NOT NULL,
  `status_strony` int(11) NOT NULL,
  `name` int(11) NOT NULL,
  `logo` int(11) NOT NULL,
  `alt_logo` int(11) NOT NULL,
  `email` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `social`
--

CREATE TABLE `social` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `name` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `icon` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `uslugi`
--

CREATE TABLE `uslugi` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status_zapisu` varchar(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slogan` varchar(255) NOT NULL,
  `text` longtext NOT NULL,
  `text2` longtext NOT NULL,
  `foto` varchar(255) NOT NULL,
  `alt` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `zayavki`
--

CREATE TABLE `zayavki` (
  `id` int(11) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status_zayavky` varchar(255) NOT NULL,
  `typ_zayavky` varchar(255) NOT NULL,
  `numer_formy` varchar(11) NOT NULL,
  `telefon` varchar(20) NOT NULL,
  `email` varchar(45) NOT NULL,
  `name` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Zrzut danych tabeli `zayavki`
--

INSERT INTO `zayavki` (`id`, `data`, `status_zayavky`, `typ_zayavky`, `numer_formy`, `telefon`, `email`, `name`) VALUES
(1, '2019-02-11 16:21:23', '1', 'Krotki', '1', '+48000000000', 'mail@mail.com', 'AdministratorTEST'),
(2, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(3, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(4, '2019-02-11 13:47:53', '1', 'Krotki', '1', '+48000111111', 'mail@mail.com', 'AdministratorTEST'),
(5, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(6, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(7, '2019-02-11 13:47:53', '1', 'Krotki', '1', '+48000111111', 'mail@mail.com', 'AdministratorTEST'),
(8, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(9, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(13, '2019-02-11 13:47:53', '1', 'Krotki', '1', '+48000111111', 'mail@mail.com', 'AdministratorTEST'),
(14, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(15, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(16, '2019-02-11 13:47:53', '1', 'Krotki', '1', '+48000111111', 'mail@mail.com', 'AdministratorTEST'),
(17, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(18, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(19, '2019-02-11 13:47:53', '1', 'Krotki', '1', '+48000111111', 'mail@mail.com', 'AdministratorTEST'),
(20, '2019-02-11 13:02:16', '2', 'Caly', '1', '+48000222222', 'mail@mail.com', 'AdministratorTEST'),
(21, '2019-02-11 13:02:21', '3', 'Caly', '1', '+48000333333', 'mail@mail.com', 'AdministratorTEST3'),
(25, '2019-02-11 15:53:43', '1', 'Krotki', 'Test', '+00000000000', 'mmm@mmm.com', 'mmm');

--
-- Indexes for table `blocks`
--
ALTER TABLE `blocks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bylostalo`
--
ALTER TABLE `bylostalo`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `grafik_pracy`
--
ALTER TABLE `grafik_pracy`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `history`
--
ALTER TABLE `history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `podcategories`
--
ALTER TABLE `podcategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `preimuszczestva`
--
ALTER TABLE `preimuszczestva`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social`
--
ALTER TABLE `social`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `uslugi`
--
ALTER TABLE `uslugi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zayavki`
--
ALTER TABLE `zayavki`
  ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT dla tabeli `blocks`
--
ALTER TABLE `blocks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `bylostalo`
--
ALTER TABLE `bylostalo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `comments`
--
ALTER TABLE `comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT dla tabeli `companies`
--
ALTER TABLE `companies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `grafik_pracy`
--
ALTER TABLE `grafik_pracy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `history`
--
ALTER TABLE `history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `language`
--
ALTER TABLE `language`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `podcategories`
--
ALTER TABLE `podcategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `preimuszczestva`
--
ALTER TABLE `preimuszczestva`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `social`
--
ALTER TABLE `social`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `uslugi`
--
ALTER TABLE `uslugi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT dla tabeli `zayavki`
--
ALTER TABLE `zayavki`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
