-- phpMyAdmin SQL Dump -- version 4.6.6 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Czas generowania: 11 Lut 2019, 17:23 -- Wersja serwera: 5.7.17-log -- Wersja PHP: 5.6.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `siec_zakopane` -- -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `administrowanie` -- CREATE TABLE `administrowanie` ( `id` int(11) NOT NULL, `login` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(20) NOT NULL, `mail` varchar(30) NOT NULL, `avatar` varchar(30) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `language` varchar(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `administrowanie` -- INSERT INTO `administrowanie` (`id`, `login`, `password`, `name`, `mail`, `avatar`, `data`, `language`) VALUES (1, 'admin', 'admin', 'L. Andrzej', 'poczta@mail.com', 'avatar.jpg', '2019-02-11 17:05:53', 'ru'); -- -------------------------------------------------------- -- -- 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 `pracowniki` -- CREATE TABLE `pracowniki` ( `id` int(11) NOT NULL, `login` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(25) NOT NULL, `mail` varchar(255) NOT NULL, `avatar` varchar(255) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status` varchar(20) NOT NULL, `naprampracy` 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'); -- -- Indeksy dla zrzutów tabel -- -- -- Indexes for table `administrowanie` -- ALTER TABLE `administrowanie` ADD PRIMARY KEY (`id`); -- -- 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 `pracowniki` -- ALTER TABLE `pracowniki` 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 for dumped tables -- -- -- AUTO_INCREMENT dla tabeli `administrowanie` -- ALTER TABLE `administrowanie` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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 `pracowniki` -- ALTER TABLE `pracowniki` 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; /*!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 */;