-- phpMyAdmin SQL Dump -- version 4.6.6 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Czas generowania: 15 Lut 2019, 15:58 -- 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-12 15:20:58', '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; -- -- Zrzut danych tabeli `blocks` -- INSERT INTO `blocks` (`id`, `data`, `pole1`, `pole2`, `pole3`, `pole4`, `pole5`, `pole6`, `pole7`, `pole8`, `pole9`, `pole10`, `pole11`, `pole12`, `pole13`, `pole14`, `pole15`) VALUES (1, '2019-02-15 08:52:39', 'index', 'Professionalne usługi', 'Montaż sieci komputerowych, zakładanie kamer i central telefonicznych. Naprawa i obsługa sieci LAN i sieci telefonicznych', 'internet-2.png', 'set2.jpg', 'поле альт', 'поле 7', 'поле 8', 'поле 9', 'поле 10', 'поле 11', 'поле 12', 'поле 13', 'поле 14', '1'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `bylostalo` -- CREATE TABLE `bylostalo` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status_zapisu` longtext NOT NULL, `name` longtext NOT NULL, `slogan` longtext NOT NULL, `text` longtext NOT NULL, `text2` longtext NOT NULL, `foto` longtext NOT NULL, `alt` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `bylostalo` -- INSERT INTO `bylostalo` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (1, '2019-02-15 15:47:37', '1', 'CMP1', 'SL1', 'TX1', 'TX2', 'FT1', 'ALT1'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status_zapisu` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `slogan` varchar(255) NOT NULL, `text` longtext NOT NULL, `text2` longtext NOT NULL, `foto` longtext NOT NULL, `alt` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `categories` -- INSERT INTO `categories` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (1, '2019-02-15 11:15:28', '1', 'Comp1', 'Sl1', 'TX1', 'TX2', 'FT1', 'ALT1'); -- -------------------------------------------------------- -- -- 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, `status_zapisu` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `slogan` longtext NOT NULL, `text` longtext NOT NULL, `text2` longtext NOT NULL, `foto` varchar(255) NOT NULL, `alt` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `companies` -- INSERT INTO `companies` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (1, '2019-02-15 10:44:21', '1', 'Name', 'Slogan', 'Text', 'Text 2', 'foto', 'alt'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `formy` -- CREATE TABLE `formy` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status_zapisu` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `slogan` varchar(255) NOT NULL, `text` varchar(255) NOT NULL, `text2` varchar(255) NOT NULL, `foto` varchar(255) NOT NULL, `alt` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `formy` -- INSERT INTO `formy` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (4, '2019-02-15 15:17:53', '1', 'Форма 1 (топ-справа)', '1', 'http://localhost/siec/##ost_zayavku', 'Описание 2', 'ИМГ', 'Альт'), (5, '2019-02-15 15:25:26', '1', 'Форма 2', '2', 'http://localhost/siec/##ost_zayavku2', 'Opis 2', 'IMG', 'Alt'); -- -------------------------------------------------------- -- -- 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 `language_pack` -- CREATE TABLE `language_pack` ( `id` int(11) NOT NULL, `language_pack_name` longtext NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `languagepack_id` varchar(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `language_pack` -- INSERT INTO `language_pack` (`id`, `language_pack_name`, `data`, `languagepack_id`) VALUES (1, 'Русский перевод', '2019-02-11 17:30:44', 'ru'), (2, 'Польский перевод', '2019-02-11 17:30:44', 'pl'), (3, 'Английский перевод', '2019-02-11 17:30:59', 'en'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `language_pack_vocabulary` -- CREATE TABLE `language_pack_vocabulary` ( `id` int(11) NOT NULL, `text` longtext NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `languagepack_id` text NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `language_pack_vocabulary` -- INSERT INTO `language_pack_vocabulary` (`id`, `text`, `data`, `languagepack_id`, `pole1`, `pole2`, `pole3`, `pole4`, `pole5`, `pole6`, `pole7`, `pole8`, `pole9`, `pole10`) VALUES (1, 'Активность', '2019-02-11 17:46:22', 'ru', 'navglub', 'catalog1', 'refresh', '', '', '', '', '', '', ''), (2, 'Контент', '2019-02-11 17:46:16', 'ru', 'navglub', 'catalog2', 'book', '', '', '', '', '', '', ''), (3, 'Категории', '2019-02-11 17:46:11', 'ru', 'navglub', 'catalog3', 'list', '', '', '', '', '', '', ''), (4, 'Социальные сети', '2019-02-11 17:46:05', 'ru', 'nav', 'catalog4', 'facebook', '', '', '', '', '', '', ''), (5, 'Настройки', '2019-02-11 17:45:58', 'ru', 'nav', 'catalog5', 'cogs', '', '', '', '', '', '', ''), (6, 'Отчеты', '2019-02-11 17:45:54', 'ru', 'nav', 'catalog6', 'check', '', '', '', '', '', '', ''), (7, 'Отчет по формам', '2019-02-11 17:45:48', 'ru', 'nav', 'catalog7', 'list', '', '', '', '', '', '', ''), (8, 'Загрузки', '2019-02-11 17:46:40', 'ru', 'nav', 'catalog8', 'download', '', '', '', '', '', '', ''), (9, 'Новые заявки', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php?status=1', '', '', '', '', '', '', ''), (10, 'Заявки в работе', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php?status=2', '', '', '', '', '', '', ''), (11, 'Завершенные заявки', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php?status=3', '', '', '', '', '', '', ''), (12, 'Заявки полные', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php?typ=caly', '', '', '', '', '', '', ''), (13, 'Заявки на звонок', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php?typ=krotki', '', '', '', '', '', '', ''), (14, 'Все заявки', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'zayavki.php', '', '', '', '', '', '', ''), (15, 'Отзывы', '2019-02-11 17:49:43', 'ru', 'item', 'catalog1', 'comments.php', '', '', '', '', '', '', ''), (16, 'Страницы', '2019-02-11 17:49:43', 'ru', 'item', 'catalog2', 'pages.php', '', '', '', '', '', '', ''), (17, 'Преимущества', '2019-02-11 17:49:43', 'ru', 'item', 'catalog2', 'triggers.php', '', '', '', '', '', '', ''), (18, 'Услуги', '2019-02-11 17:55:09', 'ru', 'item', 'catalog2', 'serwices.php', '', '', '', '', '', '', ''), (19, 'Компании', '2019-02-11 17:55:09', 'ru', 'item', 'catalog2', 'companies.php', '', '', '', '', '', '', ''), (20, 'Категории', '2019-02-11 17:55:09', 'ru', 'item', 'catalog3', 'categories.php', '', '', '', '', '', '', ''), (21, 'Подкатегории', '2019-02-11 17:55:09', 'ru', 'item', 'catalog3', 'podcategories.php', '', '', '', '', '', '', ''), (22, 'Настройки профиля', '2019-02-11 17:55:09', 'ru', 'item_nav_top', 'catalog9', 'adminsettings.php', 'user', '', '', '', '', '', ''), (23, 'Сотрудники', '2019-02-11 17:55:09', 'ru', 'item_nav_top', 'catalog9', 'users.php', 'users', '', '', '', '', '', ''), (24, 'Задачи', '2019-02-11 17:55:09', 'ru', 'item_nav_top', 'catalog9', 'zadaczi.php', 'list', '', '', '', '', '', ''), (25, 'Отчеты', '2019-02-11 17:55:09', 'ru', 'item_nav_top', 'catalog9', 'raports.php', 'check', '', '', '', '', '', ''), (26, 'Загрузки', '2019-02-11 17:55:09', 'ru', 'item_nav_top', 'catalog9', 'downloads.php', 'download', '', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `podcategories` -- CREATE TABLE `podcategories` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status_zapisu` varchar(255) 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, `categories_id` varchar(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `podcategories` -- INSERT INTO `podcategories` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`, `categories_id`) VALUES (1, '2019-02-15 11:48:04', '1', 'Podcat199', 'Sl199', 'TX199', 'TX199', 'FT199', 'ALT199', 'Cat ID199'); -- -------------------------------------------------------- -- -- 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; -- -- Zrzut danych tabeli `preimuszczestva` -- INSERT INTO `preimuszczestva` (`id`, `data`, `status_zapisu`, `block`, `name`, `slogan`, `text`, `image`, `alt`) VALUES (1, '2019-02-15 09:43:08', '1', 'Блок 1', 'Заглавие', 'Слоган', 'Текст блока текст блока текст блока', 'Изображение', 'Альт'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `settings` -- CREATE TABLE `settings` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `meta_title` longtext NOT NULL, `meta_keywords` longtext NOT NULL, `meta_description` longtext NOT NULL, `meta_favicon` varchar(255) NOT NULL, `status_strony` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `logo` varchar(255) NOT NULL, `alt_logo` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `telephone` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `settings` -- INSERT INTO `settings` (`id`, `data`, `meta_title`, `meta_keywords`, `meta_description`, `meta_favicon`, `status_strony`, `name`, `logo`, `alt_logo`, `email`, `telephone`) VALUES (1, '2019-02-15 12:59:21', 'TEST TITLE', 'TEST KEYWORDS', 'TEST DESCRIPTION', 'favicon', '1', 'name', 'logo', 'alt logo', 'mail@mail.com', '+48000000000'); -- -------------------------------------------------------- -- -- Struktura tabeli dla tabeli `social` -- CREATE TABLE `social` ( `id` int(11) NOT NULL, `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `status_zapisu` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `slogan` varchar(255) NOT NULL, `text` longtext NOT NULL, `text2` longtext NOT NULL, `foto` longtext NOT NULL, `alt` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Zrzut danych tabeli `social` -- INSERT INTO `social` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (2, '2019-02-15 12:10:54', '1', 'SC000', 'SC000', 'SC000', 'SC000', 'SC000', 'SC000'); -- -------------------------------------------------------- -- -- 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; -- -- Zrzut danych tabeli `uslugi` -- INSERT INTO `uslugi` (`id`, `data`, `status_zapisu`, `name`, `slogan`, `text`, `text2`, `foto`, `alt`) VALUES (1, '2019-02-15 10:15:20', '1', 'Название1', 'Слоган1', 'Текст1', 'Текст больше1', 'Фото1', 'Альт1'); -- -------------------------------------------------------- -- -- 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-12 15:19:27', '1', '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-12 15:18:30', '3', '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-15 15:12:35', '1', 'Krotki', '2', '+00000000000', 'mmm@mmm.com', 'mmm'), (26, '2019-02-15 15:12:35', '1', 'Krotki', '2', '+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 `formy` -- ALTER TABLE `formy` 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 `language_pack` -- ALTER TABLE `language_pack` ADD PRIMARY KEY (`id`); -- -- Indexes for table `language_pack_vocabulary` -- ALTER TABLE `language_pack_vocabulary` 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 `settings` -- ALTER TABLE `settings` 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=2; -- -- AUTO_INCREMENT dla tabeli `bylostalo` -- ALTER TABLE `bylostalo` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT dla tabeli `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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=3; -- -- AUTO_INCREMENT dla tabeli `formy` -- ALTER TABLE `formy` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- 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 `language_pack` -- ALTER TABLE `language_pack` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT dla tabeli `language_pack_vocabulary` -- ALTER TABLE `language_pack_vocabulary` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; -- -- AUTO_INCREMENT dla tabeli `podcategories` -- ALTER TABLE `podcategories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- 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=3; -- -- AUTO_INCREMENT dla tabeli `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT dla tabeli `social` -- ALTER TABLE `social` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT dla tabeli `uslugi` -- ALTER TABLE `uslugi` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT dla tabeli `zayavki` -- ALTER TABLE `zayavki` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27; /*!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 */;