-- phpMyAdmin SQL Dump -- version 4.8.3 -- https://www.phpmyadmin.net/ -- -- Хост: 127.0.0.1:3306 -- Время создания: Авг 15 2019 г., 23:23 -- Версия сервера: 8.0.12 -- Версия PHP: 7.2.10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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 */; -- -- База данных: `rozkom` -- -- -------------------------------------------------------- -- -- Структура таблицы `callback_forms` -- CREATE TABLE `callback_forms` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `theme` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Структура таблицы `categories` -- CREATE TABLE `categories` ( `id` int(10) UNSIGNED NOT NULL, `parent_id` int(10) UNSIGNED DEFAULT NULL, `order` int(11) NOT NULL DEFAULT '1', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `categories` -- INSERT INTO `categories` (`id`, `parent_id`, `order`, `name`, `slug`, `created_at`, `updated_at`) VALUES (1, NULL, 1, 'Category 1', 'category-1', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (2, NULL, 1, 'Category 2', 'category-2', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (3, 1, 1, 'Catregory 1 1', 'catregory-1-1', '2019-07-27 06:21:28', '2019-07-27 06:21:28'), (4, 3, 1, 'Category 1 1 1', 'category-1-1-1', '2019-07-27 06:21:00', '2019-08-15 17:01:42'); -- -------------------------------------------------------- -- -- Структура таблицы `data_rows` -- CREATE TABLE `data_rows` ( `id` int(10) UNSIGNED NOT NULL, `data_type_id` int(10) UNSIGNED NOT NULL, `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `required` tinyint(1) NOT NULL DEFAULT '0', `browse` tinyint(1) NOT NULL DEFAULT '1', `read` tinyint(1) NOT NULL DEFAULT '1', `edit` tinyint(1) NOT NULL DEFAULT '1', `add` tinyint(1) NOT NULL DEFAULT '1', `delete` tinyint(1) NOT NULL DEFAULT '1', `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `order` int(11) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `data_rows` -- INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES (1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1), (2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2), (3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, NULL, 3), (4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, NULL, 4), (5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, NULL, 5), (6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 6), (7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7), (8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, NULL, 8), (9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}', 10), (10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11), (11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, NULL, 12), (12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1), (13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2), (14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3), (15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4), (16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1), (17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2), (18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3), (19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4), (20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5), (21, 1, 'role_id', 'text', 'Role', 1, 1, 1, 1, 1, 1, NULL, 9), (29, 5, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1), (30, 5, 'author_id', 'text', 'Author', 1, 0, 1, 1, 0, 1, NULL, 2), (31, 5, 'category_id', 'text', 'Category', 1, 0, 1, 1, 1, 0, NULL, 3), (32, 5, 'title', 'text', 'Title', 1, 1, 1, 1, 1, 1, NULL, 4), (33, 5, 'excerpt', 'text_area', 'Excerpt', 1, 0, 1, 1, 1, 1, NULL, 5), (34, 5, 'body', 'rich_text_box', 'Body', 1, 0, 1, 1, 1, 1, NULL, 6), (35, 5, 'image', 'image', 'Post Image', 0, 1, 1, 1, 1, 1, '{\"resize\":{\"width\":\"1000\",\"height\":\"null\"},\"quality\":\"70%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"},{\"name\":\"small\",\"scale\":\"25%\"},{\"name\":\"cropped\",\"crop\":{\"width\":\"300\",\"height\":\"250\"}}]}', 7), (36, 5, 'slug', 'text', 'Slug', 1, 0, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"title\",\"forceUpdate\":true},\"validation\":{\"rule\":\"unique:posts,slug\"}}', 8), (37, 5, 'meta_description', 'text_area', 'Meta Description', 1, 0, 1, 1, 1, 1, NULL, 9), (38, 5, 'meta_keywords', 'text_area', 'Meta Keywords', 1, 0, 1, 1, 1, 1, NULL, 10), (39, 5, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"DRAFT\",\"options\":{\"PUBLISHED\":\"published\",\"DRAFT\":\"draft\",\"PENDING\":\"pending\"}}', 11), (40, 5, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 12), (41, 5, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 13), (42, 5, 'seo_title', 'text', 'SEO Title', 0, 1, 1, 1, 1, 1, NULL, 14), (43, 5, 'featured', 'checkbox', 'Featured', 1, 1, 1, 1, 1, 1, NULL, 15), (44, 6, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1), (45, 6, 'author_id', 'text', 'Author', 1, 0, 0, 0, 0, 0, NULL, 2), (46, 6, 'title', 'text', 'Title', 1, 1, 1, 1, 1, 1, NULL, 3), (47, 6, 'excerpt', 'text_area', 'Excerpt', 1, 0, 1, 1, 1, 1, NULL, 4), (48, 6, 'body', 'rich_text_box', 'Body', 1, 0, 1, 1, 1, 1, NULL, 5), (49, 6, 'slug', 'text', 'Slug', 1, 0, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"title\"},\"validation\":{\"rule\":\"unique:pages,slug\"}}', 6), (50, 6, 'meta_description', 'text', 'Meta Description', 1, 0, 1, 1, 1, 1, NULL, 7), (51, 6, 'meta_keywords', 'text', 'Meta Keywords', 1, 0, 1, 1, 1, 1, NULL, 8), (52, 6, 'status', 'select_dropdown', 'Status', 1, 1, 1, 1, 1, 1, '{\"default\":\"INACTIVE\",\"options\":{\"INACTIVE\":\"INACTIVE\",\"ACTIVE\":\"ACTIVE\"}}', 9), (53, 6, 'created_at', 'timestamp', 'Created At', 1, 1, 1, 0, 0, 0, NULL, 10), (54, 6, 'updated_at', 'timestamp', 'Updated At', 1, 0, 0, 0, 0, 0, NULL, 11), (55, 6, 'image', 'image', 'Page Image', 0, 1, 1, 1, 1, 1, NULL, 12), (56, 7, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (57, 7, 'img', 'image', 'Картинка', 1, 1, 1, 1, 1, 1, '{}', 2), (58, 7, 'label', 'text', 'Текст', 0, 1, 1, 1, 1, 1, '{}', 3), (59, 7, 'url', 'text', 'Ссылка', 0, 1, 1, 1, 1, 1, '{}', 4), (60, 7, 'order', 'text', 'Позиция', 0, 1, 1, 1, 1, 1, '{}', 5), (61, 7, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 6), (62, 7, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7), (63, 8, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (64, 8, 'name', 'text', 'Имя', 1, 1, 1, 1, 1, 1, '{}', 2), (65, 8, 'photo', 'image', 'Фото', 1, 1, 1, 1, 1, 1, '{}', 3), (66, 8, 'gallery', 'multiple_images', 'Галлерея', 1, 1, 1, 1, 1, 1, '{}', 4), (67, 8, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 6), (68, 8, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7), (69, 8, 'slug', 'text', 'Ссылка', 1, 1, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"name\"}}', 5), (70, 9, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (71, 9, 'name', 'text', 'Название', 1, 1, 1, 1, 1, 1, '{}', 2), (72, 9, 'title', 'text', 'Тайтл', 1, 1, 1, 1, 1, 1, '{}', 3), (73, 9, 'h1', 'text', 'H1', 1, 1, 1, 1, 1, 1, '{}', 4), (74, 9, 'breadcrumbs_label', 'text_area', 'Хлебные крошки', 0, 1, 1, 1, 1, 1, '{}', 5), (75, 9, 'meta_keywords', 'text_area', 'Мета ключи', 0, 1, 1, 1, 1, 1, '{}', 6), (76, 9, 'meta_description', 'text_area', 'Мета описание', 0, 1, 1, 1, 1, 1, '{}', 7), (77, 9, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 8), (78, 9, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 9), (79, 10, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (80, 10, 'name', 'text', 'Имя', 1, 1, 1, 1, 1, 1, '{}', 2), (81, 10, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, '{}', 3), (82, 10, 'phone', 'text', 'Телефон', 1, 1, 1, 1, 1, 1, '{}', 4), (83, 10, 'theme', 'text', 'Тема', 1, 1, 1, 1, 1, 1, '{}', 5), (84, 10, 'message', 'text_area', 'Сообщение', 1, 1, 1, 1, 1, 1, '{}', 6), (85, 10, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 7), (86, 10, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8), (87, 11, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (88, 11, 'name', 'text', 'Название', 1, 1, 1, 1, 1, 1, '{}', 2), (89, 11, 'title', 'text', 'Тайтл', 1, 0, 1, 1, 1, 1, '{}', 3), (90, 11, 'h1', 'text', 'H1', 1, 0, 1, 1, 1, 1, '{}', 4), (91, 11, 'slug', 'text', 'Ссылка', 1, 1, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"name\"}}', 5), (92, 11, 'breadcrumbs_label', 'text_area', 'Хлебные крошки', 0, 0, 1, 1, 1, 1, '{}', 6), (93, 11, 'meta_keywords', 'text_area', 'Мета ключи', 0, 0, 1, 1, 1, 1, '{}', 7), (94, 11, 'meta_description', 'text_area', 'Мета описание', 0, 0, 1, 1, 1, 1, '{}', 8), (95, 11, 'photo', 'image', 'Телефон', 1, 1, 1, 1, 1, 1, '{}', 9), (96, 11, 'sku', 'text', 'Артикул', 1, 1, 1, 1, 1, 1, '{}', 10), (97, 11, 'price_uah', 'number', 'Цена грн', 1, 1, 1, 1, 1, 1, '{}', 12), (98, 11, 'price_eur', 'number', 'Цена евро', 1, 1, 1, 1, 1, 1, '{}', 13), (99, 11, 'price_usd', 'number', 'Цена доллары', 1, 1, 1, 1, 1, 1, '{}', 14), (100, 11, 'price_rub', 'number', 'Цена рубли', 1, 1, 1, 1, 1, 1, '{}', 15), (101, 11, 'content', 'rich_text_box', 'Контент', 0, 0, 1, 1, 1, 1, '{}', 16), (102, 11, 'in_stock', 'checkbox', 'На складе', 0, 1, 1, 1, 1, 1, '{}', 17), (103, 11, 'news', 'checkbox', 'Новинка', 0, 1, 1, 1, 1, 1, '{}', 18), (104, 11, 'hit', 'checkbox', 'Хит', 0, 1, 1, 1, 1, 1, '{}', 19), (105, 11, 'sale', 'checkbox', 'Распродажа', 0, 1, 1, 1, 1, 1, '{}', 20), (106, 11, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 21), (107, 11, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 22), (109, 11, 'category_id', 'select_dropdown', 'Категория', 1, 1, 1, 1, 1, 1, '{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}', 11), (110, 12, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1), (111, 12, 'parent_id', 'select_dropdown', 'Parent Id', 0, 1, 1, 1, 1, 1, '{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}', 2), (112, 12, 'order', 'text', 'Order', 1, 1, 1, 1, 1, 1, '{}', 3), (113, 12, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, '{}', 4), (114, 12, 'slug', 'text', 'Slug', 1, 1, 1, 1, 1, 1, '{\"slugify\":{\"origin\":\"name\"}}', 5), (115, 12, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 6), (116, 12, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7); -- -------------------------------------------------------- -- -- Структура таблицы `data_types` -- CREATE TABLE `data_types` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name_singular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name_plural` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `model_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `policy_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `controller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `generate_permissions` tinyint(1) NOT NULL DEFAULT '0', `server_side` tinyint(4) NOT NULL DEFAULT '0', `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `data_types` -- INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES (1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2019-07-21 14:26:50', '2019-07-21 14:26:50'), (2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2019-07-21 14:26:50', '2019-07-21 14:26:50'), (3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, '', '', 1, 0, NULL, '2019-07-21 14:26:50', '2019-07-21 14:26:50'), (5, 'posts', 'posts', 'Post', 'Posts', 'voyager-news', 'TCG\\Voyager\\Models\\Post', 'TCG\\Voyager\\Policies\\PostPolicy', '', '', 1, 0, NULL, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (6, 'pages', 'pages', 'Page', 'Pages', 'voyager-file-text', 'TCG\\Voyager\\Models\\Page', NULL, '', '', 1, 0, NULL, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (7, 'sliders', 'sliders', 'Слайд', 'Слайды', 'voyager-double-right', 'App\\Slider', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":\"order\",\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-07-27 06:26:52', '2019-08-15 17:07:37'), (8, 'portfolio', 'portfolio', 'Портфолио', 'Портфолио', NULL, 'App\\Portfolio', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-07-27 09:13:32', '2019-08-15 17:05:02'), (9, 'seo_module', 'seo-module', 'Сео модуль', 'Сео модуль', NULL, 'App\\SeoModule', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-07-27 10:25:44', '2019-08-15 17:10:57'), (10, 'callback_forms', 'callback-forms', 'Форма обрататной связи', 'Форма обрататной связи', NULL, 'App\\CallbackForm', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-08-10 19:09:15', '2019-08-15 17:13:49'), (11, 'products', 'products', 'Товар', 'Товары', NULL, 'App\\Product', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-08-10 19:36:45', '2019-08-15 17:18:10'), (12, 'categories', 'categories', 'Категория', 'Категории', NULL, 'App\\Category', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2019-08-15 16:44:44', '2019-08-15 17:19:17'); -- -------------------------------------------------------- -- -- Структура таблицы `menus` -- CREATE TABLE `menus` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `menus` -- INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'admin', '2019-07-21 14:26:50', '2019-07-21 14:26:50'); -- -------------------------------------------------------- -- -- Структура таблицы `menu_items` -- CREATE TABLE `menu_items` ( `id` int(10) UNSIGNED NOT NULL, `menu_id` int(10) UNSIGNED DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self', `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `order` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `menu_items` -- INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES (1, 1, 'Главная', '', '_self', 'voyager-boat', '#000000', NULL, 1, '2019-07-21 14:26:50', '2019-08-15 16:57:18', 'voyager.dashboard', 'null'), (3, 1, 'Пользователи', '', '_self', 'Users', '#000000', NULL, 4, '2019-07-21 14:26:50', '2019-08-15 16:54:40', NULL, ''), (4, 1, 'Роли', '', '_self', 'voyager-lock', '#000000', NULL, 2, '2019-07-21 14:26:50', '2019-08-15 16:57:55', 'voyager.roles.index', 'null'), (5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 10, '2019-07-21 14:26:50', '2019-08-15 16:45:33', NULL, NULL), (6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 1, '2019-07-21 14:26:50', '2019-08-15 16:40:11', 'voyager.menus.index', NULL), (7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 2, '2019-07-21 14:26:50', '2019-08-15 16:40:11', 'voyager.database.index', NULL), (8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 3, '2019-07-21 14:26:50', '2019-08-15 16:40:11', 'voyager.compass.index', NULL), (9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 4, '2019-07-21 14:26:50', '2019-08-15 16:40:11', 'voyager.bread.index', NULL), (10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 11, '2019-07-21 14:26:50', '2019-08-15 16:45:33', 'voyager.settings.index', NULL), (14, 1, 'Hooks', '', '_self', 'voyager-hook', NULL, 5, 5, '2019-07-21 14:26:56', '2019-08-15 16:40:11', 'voyager.hooks', NULL), (15, 1, 'Слайдер', '', '_self', 'voyager-photos', '#000000', NULL, 5, '2019-07-27 06:26:52', '2019-08-15 17:06:18', 'voyager.sliders.index', 'null'), (16, 1, 'Портфолио', '', '_self', 'voyager-images', '#000000', NULL, 6, '2019-07-27 09:13:33', '2019-08-15 16:59:09', 'voyager.portfolio.index', 'null'), (17, 1, 'Сео модуль', '', '_self', 'voyager-rocket', '#000000', NULL, 7, '2019-07-27 10:25:44', '2019-08-15 17:22:00', 'voyager.seo-module.index', 'null'), (18, 1, 'Форма обратной связи', '', '_self', 'voyager-bubble', '#000000', NULL, 8, '2019-08-10 19:09:16', '2019-08-15 17:12:24', 'voyager.callback-forms.index', 'null'), (19, 1, 'Товары', '', '_self', 'voyager-window-list', '#000000', NULL, 9, '2019-08-10 19:36:45', '2019-08-15 17:15:13', 'voyager.products.index', 'null'), (20, 1, 'Категории', '', '_self', 'voyager-list-add', '#000000', NULL, 3, '2019-08-15 16:44:44', '2019-08-15 16:55:12', 'voyager.categories.index', 'null'); -- -------------------------------------------------------- -- -- Структура таблицы `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2016_01_01_000000_add_voyager_user_fields', 1), (4, '2016_01_01_000000_create_data_types_table', 1), (5, '2016_05_19_173453_create_menu_table', 1), (6, '2016_10_21_190000_create_roles_table', 1), (7, '2016_10_21_190000_create_settings_table', 1), (8, '2016_11_30_135954_create_permission_table', 1), (9, '2016_11_30_141208_create_permission_role_table', 1), (10, '2016_12_26_201236_data_types__add__server_side', 1), (11, '2017_01_13_000000_add_route_to_menu_items_table', 1), (12, '2017_01_14_005015_create_translations_table', 1), (13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1), (14, '2017_03_06_000000_add_controller_to_data_types_table', 1), (15, '2017_04_21_000000_add_order_to_data_rows_table', 1), (16, '2017_07_05_210000_add_policyname_to_data_types_table', 1), (17, '2017_08_05_000000_add_group_to_settings_table', 1), (18, '2017_11_26_013050_add_user_role_relationship', 1), (19, '2017_11_26_015000_create_user_roles_table', 1), (20, '2018_03_11_000000_add_user_settings', 1), (21, '2018_03_14_000000_add_details_to_data_types_table', 1), (22, '2018_03_16_000000_make_settings_value_nullable', 1), (24, '2016_01_01_000000_create_pages_table', 2), (25, '2016_01_01_000000_create_posts_table', 2), (26, '2016_02_15_204651_create_categories_table', 2), (27, '2017_04_11_000000_alter_post_nullable_fields_table', 2), (28, '2019_07_21_163033_create_sliders_table', 3), (29, '2019_07_27_120742_create_portfolio_table', 4), (30, '2019_07_27_125637_add_slug_to_portfolio_table', 5), (32, '2019_07_27_131338_create_seo_module_table', 6), (33, '2019_08_10_130934_create_callback_forms_table', 7), (37, '2019_08_10_221445_create_products_table', 8), (39, '2019_08_11_103316_add_category_id_to_products_table', 9); -- -------------------------------------------------------- -- -- Структура таблицы `pages` -- CREATE TABLE `pages` ( `id` int(10) UNSIGNED NOT NULL, `author_id` int(11) NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` enum('ACTIVE','INACTIVE') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INACTIVE', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `pages` -- INSERT INTO `pages` (`id`, `author_id`, `title`, `excerpt`, `body`, `image`, `slug`, `meta_description`, `meta_keywords`, `status`, `created_at`, `updated_at`) VALUES (1, 0, 'Hello World', 'Hang the jib grog grog blossom grapple dance the hempen jig gangway pressgang bilge rat to go on account lugger. Nelsons folly gabion line draught scallywag fire ship gaff fluke fathom case shot. Sea Legs bilge rat sloop matey gabion long clothes run a shot across the bow Gold Road cog league.', '
Hello World. Scallywag grog swab Cat o\'nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.
\nBallast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.
', 'pages/page1.jpg', 'hello-world', 'Yar Meta Description', 'Keyword1, Keyword2', 'ACTIVE', '2019-07-21 14:26:56', '2019-07-21 14:26:56'); -- -------------------------------------------------------- -- -- Структура таблицы `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Структура таблицы `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `permissions` -- INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES (1, 'browse_admin', NULL, '2019-07-21 14:26:50', '2019-07-21 14:26:50'), (2, 'browse_bread', NULL, '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (3, 'browse_database', NULL, '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (4, 'browse_media', NULL, '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (5, 'browse_compass', NULL, '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (6, 'browse_menus', 'menus', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (7, 'read_menus', 'menus', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (8, 'edit_menus', 'menus', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (9, 'add_menus', 'menus', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (10, 'delete_menus', 'menus', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (11, 'browse_roles', 'roles', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (12, 'read_roles', 'roles', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (13, 'edit_roles', 'roles', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (14, 'add_roles', 'roles', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (15, 'delete_roles', 'roles', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (16, 'browse_users', 'users', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (17, 'read_users', 'users', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (18, 'edit_users', 'users', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (19, 'add_users', 'users', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (20, 'delete_users', 'users', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (21, 'browse_settings', 'settings', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (22, 'read_settings', 'settings', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (23, 'edit_settings', 'settings', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (24, 'add_settings', 'settings', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (25, 'delete_settings', 'settings', '2019-07-21 14:26:51', '2019-07-21 14:26:51'), (31, 'browse_posts', 'posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (32, 'read_posts', 'posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (33, 'edit_posts', 'posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (34, 'add_posts', 'posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (35, 'delete_posts', 'posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (36, 'browse_pages', 'pages', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (37, 'read_pages', 'pages', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (38, 'edit_pages', 'pages', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (39, 'add_pages', 'pages', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (40, 'delete_pages', 'pages', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (41, 'browse_hooks', NULL, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (42, 'browse_sliders', 'sliders', '2019-07-27 06:26:52', '2019-07-27 06:26:52'), (43, 'read_sliders', 'sliders', '2019-07-27 06:26:52', '2019-07-27 06:26:52'), (44, 'edit_sliders', 'sliders', '2019-07-27 06:26:52', '2019-07-27 06:26:52'), (45, 'add_sliders', 'sliders', '2019-07-27 06:26:52', '2019-07-27 06:26:52'), (46, 'delete_sliders', 'sliders', '2019-07-27 06:26:52', '2019-07-27 06:26:52'), (47, 'browse_portfolio', 'portfolio', '2019-07-27 09:13:32', '2019-07-27 09:13:32'), (48, 'read_portfolio', 'portfolio', '2019-07-27 09:13:32', '2019-07-27 09:13:32'), (49, 'edit_portfolio', 'portfolio', '2019-07-27 09:13:33', '2019-07-27 09:13:33'), (50, 'add_portfolio', 'portfolio', '2019-07-27 09:13:33', '2019-07-27 09:13:33'), (51, 'delete_portfolio', 'portfolio', '2019-07-27 09:13:33', '2019-07-27 09:13:33'), (52, 'browse_seo_module', 'seo_module', '2019-07-27 10:25:44', '2019-07-27 10:25:44'), (53, 'read_seo_module', 'seo_module', '2019-07-27 10:25:44', '2019-07-27 10:25:44'), (54, 'edit_seo_module', 'seo_module', '2019-07-27 10:25:44', '2019-07-27 10:25:44'), (55, 'add_seo_module', 'seo_module', '2019-07-27 10:25:44', '2019-07-27 10:25:44'), (56, 'delete_seo_module', 'seo_module', '2019-07-27 10:25:44', '2019-07-27 10:25:44'), (57, 'browse_callback_forms', 'callback_forms', '2019-08-10 19:09:15', '2019-08-10 19:09:15'), (58, 'read_callback_forms', 'callback_forms', '2019-08-10 19:09:15', '2019-08-10 19:09:15'), (59, 'edit_callback_forms', 'callback_forms', '2019-08-10 19:09:15', '2019-08-10 19:09:15'), (60, 'add_callback_forms', 'callback_forms', '2019-08-10 19:09:15', '2019-08-10 19:09:15'), (61, 'delete_callback_forms', 'callback_forms', '2019-08-10 19:09:15', '2019-08-10 19:09:15'), (62, 'browse_products', 'products', '2019-08-10 19:36:45', '2019-08-10 19:36:45'), (63, 'read_products', 'products', '2019-08-10 19:36:45', '2019-08-10 19:36:45'), (64, 'edit_products', 'products', '2019-08-10 19:36:45', '2019-08-10 19:36:45'), (65, 'add_products', 'products', '2019-08-10 19:36:45', '2019-08-10 19:36:45'), (66, 'delete_products', 'products', '2019-08-10 19:36:45', '2019-08-10 19:36:45'), (67, 'browse_categories', 'categories', '2019-08-15 16:44:44', '2019-08-15 16:44:44'), (68, 'read_categories', 'categories', '2019-08-15 16:44:44', '2019-08-15 16:44:44'), (69, 'edit_categories', 'categories', '2019-08-15 16:44:44', '2019-08-15 16:44:44'), (70, 'add_categories', 'categories', '2019-08-15 16:44:44', '2019-08-15 16:44:44'), (71, 'delete_categories', 'categories', '2019-08-15 16:44:44', '2019-08-15 16:44:44'); -- -------------------------------------------------------- -- -- Структура таблицы `permission_role` -- CREATE TABLE `permission_role` ( `permission_id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `permission_role` -- INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES (1, 1), (2, 1), (3, 1), (4, 1), (5, 1), (6, 1), (7, 1), (8, 1), (9, 1), (10, 1), (11, 1), (12, 1), (13, 1), (14, 1), (15, 1), (16, 1), (17, 1), (18, 1), (19, 1), (20, 1), (21, 1), (22, 1), (23, 1), (24, 1), (25, 1), (31, 1), (32, 1), (33, 1), (34, 1), (35, 1), (36, 1), (37, 1), (38, 1), (39, 1), (40, 1), (42, 1), (43, 1), (44, 1), (45, 1), (46, 1), (47, 1), (48, 1), (49, 1), (50, 1), (51, 1), (52, 1), (53, 1), (54, 1), (55, 1), (56, 1), (57, 1), (58, 1), (59, 1), (60, 1), (61, 1), (62, 1), (63, 1), (64, 1), (65, 1), (66, 1), (67, 1), (68, 1), (69, 1), (70, 1), (71, 1); -- -------------------------------------------------------- -- -- Структура таблицы `portfolio` -- CREATE TABLE `portfolio` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `gallery` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `portfolio` -- INSERT INTO `portfolio` (`id`, `name`, `photo`, `gallery`, `created_at`, `updated_at`, `slug`) VALUES (1, 'Portfolio1', 'portfolio\\July2019\\pUTWcFCP1QDmJgSf45EN.jpg', '[\"portfolio\\\\July2019\\\\033aOiFB9HUsTrrU23RH.jpg\",\"portfolio\\\\July2019\\\\5lLN2wgA6iyKGDPUOiTs.jpg\",\"portfolio\\\\July2019\\\\EJ5rwPQlEb1DwQC1CI0n.jpg\",\"portfolio\\\\July2019\\\\qCPEQv7zPPGwNlVuTUvt.jpg\",\"portfolio\\\\July2019\\\\zaZoafqAQyDKGjoFIp2Y.png\",\"portfolio\\\\July2019\\\\R8uPW9YpF34XvSumh2p9.jpg\",\"portfolio\\\\July2019\\\\nDYirDEFblR8Gj2qrnEi.png\",\"portfolio\\\\July2019\\\\kJSp5N23cf5Atrj9Ypoo.jpg\",\"portfolio\\\\July2019\\\\78wMH4iEOiGJ4cHezWMs.png\"]', '2019-07-27 09:15:14', '2019-07-27 09:15:14', 'portfolio-1'); -- -------------------------------------------------------- -- -- Структура таблицы `posts` -- CREATE TABLE `posts` ( `id` int(10) UNSIGNED NOT NULL, `author_id` int(11) NOT NULL, `category_id` int(11) DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` enum('PUBLISHED','DRAFT','PENDING') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT', `featured` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `posts` -- INSERT INTO `posts` (`id`, `author_id`, `category_id`, `title`, `seo_title`, `excerpt`, `body`, `image`, `slug`, `meta_description`, `meta_keywords`, `status`, `featured`, `created_at`, `updated_at`) VALUES (1, 0, NULL, 'Lorem Ipsum Post', NULL, 'This is the excerpt for the Lorem Ipsum Post', 'This is the body of the lorem ipsum post
', 'posts/post1.jpg', 'lorem-ipsum-post', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (2, 0, NULL, 'My Sample Post', NULL, 'This is the excerpt for the sample Post', 'This is the body for the sample post, which includes the body.
\nAnd include a bunch of other stuff.
', 'posts/post2.jpg', 'my-sample-post', 'Meta Description for sample post', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (3, 0, NULL, 'Latest Post', NULL, 'This is the excerpt for the latest post', 'This is the body for the latest post
', 'posts/post3.jpg', 'latest-post', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (4, 0, NULL, 'Yarr Post', NULL, 'Reef sails nipperkin bring a spring upon her cable coffer jury mast spike marooned Pieces of Eight poop deck pillage. Clipper driver coxswain galleon hempen halter come about pressgang gangplank boatswain swing the lead. Nipperkin yard skysail swab lanyard Blimey bilge water ho quarter Buccaneer.', 'Swab deadlights Buccaneer fire ship square-rigged dance the hempen jig weigh anchor cackle fruit grog furl. Crack Jennys tea cup chase guns pressgang hearties spirits hogshead Gold Road six pounders fathom measured fer yer chains. Main sheet provost come about trysail barkadeer crimp scuttle mizzenmast brig plunder.
\nMizzen league keelhaul galleon tender cog chase Barbary Coast doubloon crack Jennys tea cup. Blow the man down lugsail fire ship pinnace cackle fruit line warp Admiral of the Black strike colors doubloon. Tackle Jack Ketch come about crimp rum draft scuppers run a shot across the bow haul wind maroon.
\nInterloper heave down list driver pressgang holystone scuppers tackle scallywag bilged on her anchor. Jack Tar interloper draught grapple mizzenmast hulk knave cable transom hogshead. Gaff pillage to go on account grog aft chase guns piracy yardarm knave clap of thunder.
', 'posts/post4.jpg', 'yarr-post', 'this be a meta descript', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2019-07-21 14:26:56', '2019-07-21 14:26:56'); -- -------------------------------------------------------- -- -- Структура таблицы `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `h1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `breadcrumbs_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` int(11) NOT NULL, `price_uah` double(8,2) NOT NULL, `price_eur` double(8,2) NOT NULL, `price_usd` double(8,2) NOT NULL, `price_rub` double(8,2) NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `in_stock` tinyint(1) DEFAULT '0', `news` tinyint(1) DEFAULT '0', `hit` tinyint(1) DEFAULT '0', `sale` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `products` -- INSERT INTO `products` (`id`, `name`, `title`, `h1`, `slug`, `breadcrumbs_label`, `meta_keywords`, `meta_description`, `photo`, `sku`, `category_id`, `price_uah`, `price_eur`, `price_usd`, `price_rub`, `content`, `in_stock`, `news`, `hit`, `sale`, `created_at`, `updated_at`) VALUES (1, 'Name ru', 'Name ru', 'Name ru', 'name-ru', 'Name ru', 'Name ru', 'Name ru', 'products\\August2019\\yQSlZICJ9CExhjKaXgoK.jpg', '12312', 4, 1.00, 2.00, 3.00, 4.00, '123123123123123
', 1, 1, 1, 1, '2019-08-11 08:08:00', '2019-08-11 08:10:33'); -- -------------------------------------------------------- -- -- Структура таблицы `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `roles` -- INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES (1, 'admin', 'Administrator', '2019-07-21 14:26:50', '2019-07-21 14:26:50'), (2, 'user', 'Normal User', '2019-07-21 14:26:50', '2019-07-21 14:26:50'); -- -------------------------------------------------------- -- -- Структура таблицы `seo_module` -- CREATE TABLE `seo_module` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `h1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `breadcrumbs_label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `seo_module` -- INSERT INTO `seo_module` (`id`, `name`, `title`, `h1`, `breadcrumbs_label`, `meta_keywords`, `meta_description`, `created_at`, `updated_at`) VALUES (1, 'Главная', 'Главная', 'Главная', 'Breadcrumbs Label', 'Meta Keywords', 'Meta Description', '2019-07-27 10:26:10', '2019-07-27 10:26:10'); -- -------------------------------------------------------- -- -- Структура таблицы `settings` -- CREATE TABLE `settings` ( `id` int(10) UNSIGNED NOT NULL, `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `order` int(11) NOT NULL DEFAULT '1', `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `settings` -- INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES (1, 'site.title', 'Site Title', 'Site Title', '', 'text', 1, 'Site'), (2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'), (3, 'site.logo', 'Site Logo', '', '', 'image', 3, 'Site'), (4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', '', '', 'text', 4, 'Site'), (5, 'admin.bg_image', 'Admin Background Image', '', '', 'image', 5, 'Admin'), (6, 'admin.title', 'Admin Title', 'Voyager', '', 'text', 1, 'Admin'), (7, 'admin.description', 'Admin Description', 'Welcome to Voyager. The Missing Admin for Laravel', '', 'text', 2, 'Admin'), (8, 'admin.loader', 'Admin Loader', '', '', 'image', 3, 'Admin'), (9, 'admin.icon_image', 'Admin Icon Image', '', '', 'image', 4, 'Admin'), (10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', '', '', 'text', 1, 'Admin'); -- -------------------------------------------------------- -- -- Структура таблицы `sliders` -- CREATE TABLE `sliders` ( `id` bigint(20) UNSIGNED NOT NULL, `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `sliders` -- INSERT INTO `sliders` (`id`, `img`, `label`, `url`, `order`, `created_at`, `updated_at`) VALUES (1, 'sliders\\July2019\\qKrCZ7hsVTl5U2VcVsKU.png', 'Slide 1', 'google.com', 1, '2019-07-27 06:29:25', '2019-07-27 06:29:25'), (2, 'sliders\\July2019\\CTKUZUVxCHvECDyDMfOk.jpg', 'Slide 2', 'google.com', 2, '2019-07-27 06:31:04', '2019-07-27 06:31:04'); -- -------------------------------------------------------- -- -- Структура таблицы `translations` -- CREATE TABLE `translations` ( `id` int(10) UNSIGNED NOT NULL, `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `foreign_key` int(10) UNSIGNED NOT NULL, `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `translations` -- INSERT INTO `translations` (`id`, `table_name`, `column_name`, `foreign_key`, `locale`, `value`, `created_at`, `updated_at`) VALUES (1, 'data_types', 'display_name_singular', 5, 'pt', 'Post', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (2, 'data_types', 'display_name_singular', 6, 'pt', 'Página', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (3, 'data_types', 'display_name_singular', 1, 'pt', 'Utilizador', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (4, 'data_types', 'display_name_singular', 4, 'pt', 'Categoria', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (5, 'data_types', 'display_name_singular', 2, 'pt', 'Menu', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (6, 'data_types', 'display_name_singular', 3, 'pt', 'Função', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (7, 'data_types', 'display_name_plural', 5, 'pt', 'Posts', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (8, 'data_types', 'display_name_plural', 6, 'pt', 'Páginas', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (9, 'data_types', 'display_name_plural', 1, 'pt', 'Utilizadores', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (10, 'data_types', 'display_name_plural', 4, 'pt', 'Categorias', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (11, 'data_types', 'display_name_plural', 2, 'pt', 'Menus', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (12, 'data_types', 'display_name_plural', 3, 'pt', 'Funções', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (13, 'categories', 'slug', 1, 'pt', 'categoria-1', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (14, 'categories', 'name', 1, 'pt', 'Categoria 1', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (15, 'categories', 'slug', 2, 'pt', 'categoria-2', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (16, 'categories', 'name', 2, 'pt', 'Categoria 2', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (17, 'pages', 'title', 1, 'pt', 'Olá Mundo', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (18, 'pages', 'slug', 1, 'pt', 'ola-mundo', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (19, 'pages', 'body', 1, 'pt', 'Olá Mundo. Scallywag grog swab Cat o\'nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.
\r\nBallast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.
', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (20, 'menu_items', 'title', 1, 'pt', 'Painel de Controle', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (21, 'menu_items', 'title', 2, 'pt', 'Media', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (22, 'menu_items', 'title', 12, 'pt', 'Publicações', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (23, 'menu_items', 'title', 3, 'pt', 'Utilizadores', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (24, 'menu_items', 'title', 11, 'pt', 'Categorias', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (25, 'menu_items', 'title', 13, 'pt', 'Páginas', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (26, 'menu_items', 'title', 4, 'pt', 'Funções', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (27, 'menu_items', 'title', 5, 'pt', 'Ferramentas', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (28, 'menu_items', 'title', 6, 'pt', 'Menus', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (29, 'menu_items', 'title', 7, 'pt', 'Base de dados', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (30, 'menu_items', 'title', 10, 'pt', 'Configurações', '2019-07-21 14:26:56', '2019-07-21 14:26:56'), (31, 'data_types', 'display_name_singular', 11, 'en', 'Product', '2019-08-11 07:48:35', '2019-08-11 07:48:35'), (32, 'data_types', 'display_name_plural', 11, 'en', 'Products', '2019-08-11 07:48:35', '2019-08-11 07:48:35'), (33, 'data_types', 'display_name_singular', 11, 'ua', 'Product', '2019-08-11 07:49:28', '2019-08-11 07:49:28'), (34, 'data_types', 'display_name_plural', 11, 'ua', 'Products', '2019-08-11 07:49:28', '2019-08-11 07:49:28'), (35, 'products', 'name', 1, 'en', 'Name ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (36, 'products', 'title', 1, 'en', 'Name ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (37, 'products', 'slug', 1, 'en', 'name-ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (38, 'products', 'breadcrumbs_label', 1, 'en', 'Name ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (39, 'products', 'meta_keywords', 1, 'en', 'Name ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (40, 'products', 'meta_description', 1, 'en', 'Name ru', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (41, 'products', 'content', 1, 'en', '123123123123123
', '2019-08-11 08:08:45', '2019-08-11 08:08:45'), (42, 'products', 'name', 1, 'ua', 'Name ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (43, 'products', 'title', 1, 'ua', 'Name ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (44, 'products', 'slug', 1, 'ua', 'name-ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (45, 'products', 'breadcrumbs_label', 1, 'ua', 'Name ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (46, 'products', 'meta_keywords', 1, 'ua', 'Name ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (47, 'products', 'meta_description', 1, 'ua', 'Name ru', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (48, 'products', 'content', 1, 'ua', '123123123123123
', '2019-08-11 08:10:33', '2019-08-11 08:10:33'), (49, 'menu_items', 'title', 1, 'en', 'Dashboard', '2019-08-15 16:35:49', '2019-08-15 16:35:49'), (50, 'menu_items', 'title', 4, 'en', 'Roles', '2019-08-15 16:36:00', '2019-08-15 16:36:00'), (51, 'menu_items', 'title', 3, 'en', 'Users', '2019-08-15 16:36:10', '2019-08-15 16:36:10'), (53, 'menu_items', 'title', 15, 'en', 'Sliders', '2019-08-15 16:36:41', '2019-08-15 16:36:41'), (54, 'menu_items', 'title', 4, 'ua', 'Roles', '2019-08-15 16:37:12', '2019-08-15 16:37:12'), (61, 'data_types', 'display_name_singular', 12, 'ua', 'Категория', '2019-08-15 16:51:56', '2019-08-15 16:51:56'), (62, 'data_types', 'display_name_singular', 12, 'en', 'Категория', '2019-08-15 16:51:56', '2019-08-15 16:51:56'), (63, 'data_types', 'display_name_plural', 12, 'ua', 'Категории', '2019-08-15 16:51:56', '2019-08-15 16:51:56'), (64, 'data_types', 'display_name_plural', 12, 'en', 'Категории', '2019-08-15 16:51:56', '2019-08-15 16:51:56'), (65, 'menu_items', 'title', 20, 'ua', 'Категории', '2019-08-15 16:55:12', '2019-08-15 16:55:12'), (66, 'menu_items', 'title', 20, 'en', 'Категории', '2019-08-15 16:55:12', '2019-08-15 16:55:12'), (67, 'menu_items', 'title', 1, 'ua', 'Главная', '2019-08-15 16:56:15', '2019-08-15 16:56:15'), (68, 'menu_items', 'title', 16, 'ua', 'Portfolios', '2019-08-15 16:59:09', '2019-08-15 16:59:09'), (69, 'menu_items', 'title', 16, 'en', 'Portfolios', '2019-08-15 16:59:09', '2019-08-15 16:59:09'), (70, 'categories', 'name', 4, 'ua', '11111111', '2019-08-15 17:01:42', '2019-08-15 17:01:42'), (71, 'categories', 'name', 4, 'en', 'Category 1 1 1', '2019-08-15 17:01:42', '2019-08-15 17:01:42'), (72, 'categories', 'slug', 4, 'ua', '1111111', '2019-08-15 17:01:42', '2019-08-15 17:01:42'), (73, 'categories', 'slug', 4, 'en', 'category-1-1-1', '2019-08-15 17:01:42', '2019-08-15 17:01:42'), (74, 'data_types', 'display_name_singular', 8, 'ua', 'Portfolio', '2019-08-15 17:05:02', '2019-08-15 17:05:02'), (75, 'data_types', 'display_name_singular', 8, 'en', 'Portfolio', '2019-08-15 17:05:02', '2019-08-15 17:05:02'), (76, 'data_types', 'display_name_plural', 8, 'ua', 'Portfolios', '2019-08-15 17:05:02', '2019-08-15 17:05:02'), (77, 'data_types', 'display_name_plural', 8, 'en', 'Portfolios', '2019-08-15 17:05:02', '2019-08-15 17:05:02'), (78, 'menu_items', 'title', 15, 'ua', 'Слайдер', '2019-08-15 17:06:18', '2019-08-15 17:06:18'), (79, 'data_types', 'display_name_singular', 7, 'ua', 'Slider', '2019-08-15 17:07:38', '2019-08-15 17:07:38'), (80, 'data_types', 'display_name_singular', 7, 'en', 'Slider', '2019-08-15 17:07:38', '2019-08-15 17:07:38'), (81, 'data_types', 'display_name_plural', 7, 'ua', 'Sliders', '2019-08-15 17:07:38', '2019-08-15 17:07:38'), (82, 'data_types', 'display_name_plural', 7, 'en', 'Sliders', '2019-08-15 17:07:38', '2019-08-15 17:07:38'), (83, 'menu_items', 'title', 17, 'ua', 'Seo Modules', '2019-08-15 17:09:35', '2019-08-15 17:09:35'), (84, 'menu_items', 'title', 17, 'en', 'Seo Modules', '2019-08-15 17:09:35', '2019-08-15 17:09:35'), (85, 'data_types', 'display_name_singular', 9, 'ua', 'Seo Module', '2019-08-15 17:10:57', '2019-08-15 17:10:57'), (86, 'data_types', 'display_name_singular', 9, 'en', 'Seo Module', '2019-08-15 17:10:57', '2019-08-15 17:10:57'), (87, 'data_types', 'display_name_plural', 9, 'ua', 'Seo Modules', '2019-08-15 17:10:57', '2019-08-15 17:10:57'), (88, 'data_types', 'display_name_plural', 9, 'en', 'Seo Modules', '2019-08-15 17:10:57', '2019-08-15 17:10:57'), (89, 'menu_items', 'title', 18, 'ua', 'Callback Forms', '2019-08-15 17:12:24', '2019-08-15 17:12:24'), (90, 'menu_items', 'title', 18, 'en', 'Callback Forms', '2019-08-15 17:12:24', '2019-08-15 17:12:24'), (91, 'data_types', 'display_name_singular', 10, 'ua', 'Callback Form', '2019-08-15 17:13:49', '2019-08-15 17:13:49'), (92, 'data_types', 'display_name_singular', 10, 'en', 'Callback Form', '2019-08-15 17:13:49', '2019-08-15 17:13:49'), (93, 'data_types', 'display_name_plural', 10, 'ua', 'Callback Forms', '2019-08-15 17:13:49', '2019-08-15 17:13:49'), (94, 'data_types', 'display_name_plural', 10, 'en', 'Callback Forms', '2019-08-15 17:13:49', '2019-08-15 17:13:49'), (95, 'menu_items', 'title', 19, 'ua', 'Products', '2019-08-15 17:15:13', '2019-08-15 17:15:13'), (96, 'menu_items', 'title', 19, 'en', 'Products', '2019-08-15 17:15:13', '2019-08-15 17:15:13'); -- -------------------------------------------------------- -- -- Структура таблицы `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png', `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Дамп данных таблицы `users` -- INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`) VALUES (1, 1, 'Admin', 'admin@admin.com', 'users/default.png', NULL, '$2y$10$0NuUyt.qj9MFuPTBRrpo.efrxF2.gNsWBNKjtmhngRRiLuef4GiKG', 'EfT3dHSwwJhoNkEgInhzp7T0gCGwal0JZ1EgprxG1WPAsBN5rLALsP2jfvOn', NULL, '2019-07-21 14:26:56', '2019-07-21 14:26:56'); -- -------------------------------------------------------- -- -- Структура таблицы `user_roles` -- CREATE TABLE `user_roles` ( `user_id` bigint(20) UNSIGNED NOT NULL, `role_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Индексы сохранённых таблиц -- -- -- Индексы таблицы `callback_forms` -- ALTER TABLE `callback_forms` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `categories_slug_unique` (`slug`), ADD KEY `categories_parent_id_foreign` (`parent_id`); -- -- Индексы таблицы `data_rows` -- ALTER TABLE `data_rows` ADD PRIMARY KEY (`id`), ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`); -- -- Индексы таблицы `data_types` -- ALTER TABLE `data_types` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `data_types_name_unique` (`name`), ADD UNIQUE KEY `data_types_slug_unique` (`slug`); -- -- Индексы таблицы `menus` -- ALTER TABLE `menus` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `menus_name_unique` (`name`); -- -- Индексы таблицы `menu_items` -- ALTER TABLE `menu_items` ADD PRIMARY KEY (`id`), ADD KEY `menu_items_menu_id_foreign` (`menu_id`); -- -- Индексы таблицы `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `pages_slug_unique` (`slug`); -- -- Индексы таблицы `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Индексы таблицы `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD KEY `permissions_key_index` (`key`); -- -- Индексы таблицы `permission_role` -- ALTER TABLE `permission_role` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `permission_role_permission_id_index` (`permission_id`), ADD KEY `permission_role_role_id_index` (`role_id`); -- -- Индексы таблицы `portfolio` -- ALTER TABLE `portfolio` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `posts_slug_unique` (`slug`); -- -- Индексы таблицы `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_unique` (`name`); -- -- Индексы таблицы `seo_module` -- ALTER TABLE `seo_module` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `settings_key_unique` (`key`); -- -- Индексы таблицы `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Индексы таблицы `translations` -- ALTER TABLE `translations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`); -- -- Индексы таблицы `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_role_id_foreign` (`role_id`); -- -- Индексы таблицы `user_roles` -- ALTER TABLE `user_roles` ADD PRIMARY KEY (`user_id`,`role_id`), ADD KEY `user_roles_user_id_index` (`user_id`), ADD KEY `user_roles_role_id_index` (`role_id`); -- -- AUTO_INCREMENT для сохранённых таблиц -- -- -- AUTO_INCREMENT для таблицы `callback_forms` -- ALTER TABLE `callback_forms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT для таблицы `categories` -- ALTER TABLE `categories` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT для таблицы `data_rows` -- ALTER TABLE `data_rows` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117; -- -- AUTO_INCREMENT для таблицы `data_types` -- ALTER TABLE `data_types` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT для таблицы `menus` -- ALTER TABLE `menus` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT для таблицы `menu_items` -- ALTER TABLE `menu_items` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT для таблицы `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40; -- -- AUTO_INCREMENT для таблицы `pages` -- ALTER TABLE `pages` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT для таблицы `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72; -- -- AUTO_INCREMENT для таблицы `portfolio` -- ALTER TABLE `portfolio` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT для таблицы `posts` -- ALTER TABLE `posts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT для таблицы `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT для таблицы `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT для таблицы `seo_module` -- ALTER TABLE `seo_module` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT для таблицы `settings` -- ALTER TABLE `settings` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT для таблицы `sliders` -- ALTER TABLE `sliders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT для таблицы `translations` -- ALTER TABLE `translations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97; -- -- AUTO_INCREMENT для таблицы `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Ограничения внешнего ключа сохраненных таблиц -- -- -- Ограничения внешнего ключа таблицы `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Ограничения внешнего ключа таблицы `data_rows` -- ALTER TABLE `data_rows` ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Ограничения внешнего ключа таблицы `menu_items` -- ALTER TABLE `menu_items` ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE; -- -- Ограничения внешнего ключа таблицы `permission_role` -- ALTER TABLE `permission_role` ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Ограничения внешнего ключа таблицы `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`); -- -- Ограничения внешнего ключа таблицы `user_roles` -- ALTER TABLE `user_roles` ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; 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 */;