text: -- phpMyAdmin SQL Dump
  -- version 4.7.3
  -- https://www.phpmyadmin.net/
  --
  -- Хост: 127.0.0.1:3306
  -- Время создания: Фев 01 2018 г., 17:53
  -- Версия сервера: 5.7.19
  -- Версия PHP: 7.0.21
  
  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 */;
  
  --
  -- База данных: `land`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) 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, '2018_01_20_212558_create_table_pages', 1),
  (4, '2018_01_20_212655_create_table_services', 1),
  (5, '2018_01_20_212739_create_table_portfolios', 1),
  (6, '2018_01_20_212833_create_table_people', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `pages`
  --
  
  CREATE TABLE `pages` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alias` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `images` varchar(100) 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;
  
  --
  -- Дамп данных таблицы `pages`
  --
  
  INSERT INTO `pages` (`id`, `name`, `alias`, `text`, `images`, `created_at`, `updated_at`) VALUES
  (1, 'home', 'home', '<h2>We create <strong>awesome</strong> web templates</h2>\r\n                  <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text  printer took a galley of type and scrambled it to make a type specimen.</p>', 'main_device_image.png', '2018-01-20 22:00:00', NULL),
  (2, 'about us', 'aboutUs', '<h3>Lore Ipsum has been the industry\'s standard dummy text ever..</h3><br/> \r\n                  <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.PageMaker including versions of Lorem Ipsum.</p> <br/>\r\n      <p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged like Aldus PageMaker including versions of Lorem Ipsum.</p>', 'about-img.jpg', '2018-01-21 02:00:00', NULL),
  (4, 'new content', 'newcontent', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec dapibus, ex a dictum ornare, ligula arcu scelerisque eros, lacinia tincidunt ex nisl sit amet dolor. Integer laoreet suscipit dictum. Praesent consectetur, turpis aliquam egestas vehicula, est urna accumsan tellus, sit amet suscipit eros odio at urna. Donec sed nulla tristique, accumsan tortor sed, interdum dui. Curabitur varius lacus ligula, vel ullamcorper lorem bibendum et. Donec tristique, enim id vestibulum eleifend, metus lectus varius elit, non sodales purus lorem quis odio. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque est enim, euismod vitae mi in, porta aliquet sem. Integer maximus tortor ipsum, sollicitudin viverra elit tempus a.</p>', 'priroda..jpg', '2018-02-01 11:52:34', '2018-02-01 11:57:29');
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `people`
  --
  
  CREATE TABLE `people` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `position` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `images` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
    `text` text 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;
  
  --
  -- Дамп данных таблицы `people`
  --
  
  INSERT INTO `people` (`id`, `name`, `position`, `images`, `text`, `created_at`, `updated_at`) VALUES
  (1, 'Tom Rensed', 'Chief Officer', 'team_pic1.jpg', 'Lorem', '2018-01-21 04:00:00', NULL),
  (2, 'Kathren Mory', 'Vice President', 'team_pic2.jpg', 'Lorem', '2018-01-21 02:00:00', NULL),
  (3, 'Lancer Jack', 'Senior Manager', 'team_pic3.jpg', 'Lorem', '2018-01-03 21:00:00', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `portfolios`
  --
  
  CREATE TABLE `portfolios` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
    `images` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
    `filter` varchar(100) 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;
  
  --
  -- Дамп данных таблицы `portfolios`
  --
  
  INSERT INTO `portfolios` (`id`, `name`, `images`, `filter`, `created_at`, `updated_at`) VALUES
  (1, 'SMS Mobile App', 'portfolio_pic1.jpg', 'appleIOS', '2018-01-10 21:00:00', NULL),
  (2, 'Finance App', 'portfolio_pic2.jpg', 'design', '2018-01-02 21:00:00', NULL),
  (3, 'GPS COncept', 'portfolio_pic3.jpg', 'design', '2018-01-08 21:00:00', NULL),
  (4, 'Shopping', 'portfolio_pic4.jpg', 'android', '2018-01-17 21:00:00', NULL),
  (5, 'Managment', 'portfolio_pic5.jpg', 'design', '2018-01-10 21:00:00', NULL),
  (6, 'iPhone', 'portfolio_pic6.jpg', 'web', '2018-01-16 21:00:00', NULL),
  (7, 'Nexus Phone', 'portfolio_pic7.jpg', 'web', '2018-01-03 21:00:00', NULL),
  (8, 'Android', 'portfolio_pic8.jpg', 'android', '2018-01-17 21:00:00', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `services`
  --
  
  CREATE TABLE `services` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `text` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `icon` varchar(100) 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;
  
  --
  -- Дамп данных таблицы `services`
  --
  
  INSERT INTO `services` (`id`, `name`, `text`, `icon`, `created_at`, `updated_at`) VALUES
  (1, 'Android', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-android', '2018-01-10 21:00:00', NULL),
  (2, 'AppleIOS', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-apple', '2018-01-16 21:00:00', NULL),
  (3, 'Design', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-dropbox', '2018-01-10 21:00:00', NULL),
  (4, 'Concept', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-html5', '2018-01-16 21:00:00', NULL),
  (5, 'User Research', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-slack', '2018-01-17 21:00:00', NULL),
  (6, 'User Experience', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. Donec pede justo, fringilla vel, aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. Vivamus elementum semper nisi.', 'fa-users', '2018-01-23 21:00:00', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Структура таблицы `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) 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;
  
  --
  -- Дамп данных таблицы `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'User', 'user@ukr.net', '$2y$10$Znkg53gFH1oiRDifIfGIeeFy3AorttkFc7wGOcQFoARFsP4mkIFR.', 'sBf9c4AgIsXRq6do8gtgg5Dm8JXTjKkWAdFnvzBk3mxCojWT3GYt600qM6iT', '2018-01-23 18:01:36', '2018-01-23 18:01:36');
  
  --
  -- Индексы сохранённых таблиц
  --
  
  --
  -- Индексы таблицы `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Индексы таблицы `pages`
  --
  ALTER TABLE `pages`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Индексы таблицы `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Индексы таблицы `people`
  --
  ALTER TABLE `people`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Индексы таблицы `portfolios`
  --
  ALTER TABLE `portfolios`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Индексы таблицы `services`
  --
  ALTER TABLE `services`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Индексы таблицы `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT для сохранённых таблиц
  --
  
  --
  -- AUTO_INCREMENT для таблицы `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT для таблицы `pages`
  --
  ALTER TABLE `pages`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT для таблицы `people`
  --
  ALTER TABLE `people`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  --
  -- AUTO_INCREMENT для таблицы `portfolios`
  --
  ALTER TABLE `portfolios`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  --
  -- AUTO_INCREMENT для таблицы `services`
  --
  ALTER TABLE `services`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  --
  -- AUTO_INCREMENT для таблицы `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;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 */;
  