403WebShell

403Webshell
Server IP : 45.32.152.128 / Your IP : 216.73.216.91
Web Server : nginx/1.24.0
System : Linux stage-vultr 5.4.0-216-generic #236-Ubuntu SMP Fri Apr 11 19:53:21 UTC 2025 x86_64
User : forge ( 1000)
PHP Version : 8.2.14
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON
Directory : /proc/14643/cwd/database/dumps/
Upload File :
[ Back ]
Current File : /proc/14643/cwd/database/dumps/voyager_sql_dump.sql
# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.19)
# Database: baranekresorts
# Generation Time: 2017-09-19 12:10:43 +0000
# ************************************************************


/*!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 utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table data_rows
# ------------------------------------------------------------

DROP TABLE IF EXISTS `data_rows`;

CREATE TABLE `data_rows` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_type_id` int(10) unsigned NOT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) 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 COLLATE utf8mb4_unicode_ci,
  `order` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `data_rows_data_type_id_foreign` (`data_type_id`),
  CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `data_rows` WRITE;
/*!40000 ALTER TABLE `data_rows` DISABLE KEYS */;

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,'',1),
	(2,1,'author_id','text','Author',1,0,1,1,0,1,'',2),
	(3,1,'category_id','text','Category',1,0,1,1,1,0,'',3),
	(4,1,'title','text','Title',1,1,1,1,1,1,'',4),
	(5,1,'excerpt','text_area','excerpt',1,0,1,1,1,1,'',5),
	(6,1,'body','rich_text_box','Body',1,0,1,1,1,1,'',6),
	(7,1,'image','image','Post Image',0,1,1,1,1,1,'\n{\n\"resize\": {\n\"width\": \"1000\",\n\"height\": \"null\"\n},\n\"quality\": \"70%\",\n\"upsize\": true,\n\"thumbnails\": [\n{\n\"name\": \"medium\",\n\"scale\": \"50%\"\n},\n{\n\"name\": \"small\",\n\"scale\": \"25%\"\n},\n{\n\"name\": \"cropped\",\n\"crop\": {\n\"width\": \"300\",\n\"height\": \"250\"\n}\n}\n]\n}',7),
	(8,1,'slug','text','slug',1,0,1,1,1,1,'\n{\n\"slugify\": {\n\"origin\": \"title\",\n\"forceUpdate\": true\n}\n}',8),
	(9,1,'meta_description','text_area','meta_description',1,0,1,1,1,1,'',9),
	(10,1,'meta_keywords','text_area','meta_keywords',1,0,1,1,1,1,'',10),
	(11,1,'status','select_dropdown','status',1,1,1,1,1,1,'\n{\n\"default\": \"DRAFT\",\n\"options\": {\n\"PUBLISHED\": \"published\",\n\"DRAFT\": \"draft\",\n\"PENDING\": \"pending\"\n}\n}',11),
	(12,1,'created_at','timestamp','created_at',0,1,1,0,0,0,'',12),
	(13,1,'updated_at','timestamp','updated_at',0,0,0,0,0,0,'',13),
	(14,2,'id','number','id',1,0,0,0,0,0,'',1),
	(15,2,'author_id','text','author_id',1,0,0,0,0,0,'',2),
	(16,2,'title','text','title',1,1,1,1,1,1,'',3),
	(17,2,'excerpt','text_area','excerpt',1,0,1,1,1,1,'',4),
	(18,2,'body','rich_text_box','body',1,0,1,1,1,1,'',5),
	(19,2,'slug','text','slug',1,0,1,1,1,1,'{\"slugify\":{\"origin\":\"title\"}}',6),
	(20,2,'meta_description','text','meta_description',1,0,1,1,1,1,'',7),
	(21,2,'meta_keywords','text','meta_keywords',1,0,1,1,1,1,'',8),
	(22,2,'status','select_dropdown','status',1,1,1,1,1,1,'{\"default\":\"INACTIVE\",\"options\":{\"INACTIVE\":\"INACTIVE\",\"ACTIVE\":\"ACTIVE\"}}',9),
	(23,2,'created_at','timestamp','created_at',1,1,1,0,0,0,'',10),
	(24,2,'updated_at','timestamp','updated_at',1,0,0,0,0,0,'',11),
	(25,2,'image','image','image',0,1,1,1,1,1,'',12),
	(26,3,'id','number','id',1,0,0,0,0,0,'',1),
	(27,3,'name','text','name',1,1,1,1,1,1,'',2),
	(28,3,'email','text','email',1,1,1,1,1,1,'',3),
	(29,3,'password','password','password',1,0,0,1,1,0,'',4),
	(30,3,'remember_token','text','remember_token',0,0,0,0,0,0,'',5),
	(31,3,'created_at','timestamp','created_at',0,1,1,0,0,0,'',6),
	(32,3,'updated_at','timestamp','updated_at',0,0,0,0,0,0,'',7),
	(33,3,'avatar','image','avatar',0,1,1,1,1,1,'',8),
	(34,5,'id','number','id',1,0,0,0,0,0,'',1),
	(35,5,'name','text','name',1,1,1,1,1,1,'',2),
	(36,5,'created_at','timestamp','created_at',0,0,0,0,0,0,'',3),
	(37,5,'updated_at','timestamp','updated_at',0,0,0,0,0,0,'',4),
	(38,4,'id','number','id',1,0,0,0,0,0,'',1),
	(39,4,'parent_id','select_dropdown','parent_id',0,0,1,1,1,1,'{\"default\":\"\",\"null\":\"\",\"options\":{\"\":\"-- None --\"},\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}',2),
	(40,4,'order','text','order',1,1,1,1,1,1,'{\"default\":1}',3),
	(41,4,'name','text','name',1,1,1,1,1,1,'',4),
	(42,4,'slug','text','slug',1,1,1,1,1,1,'',5),
	(43,4,'created_at','timestamp','created_at',0,0,1,0,0,0,'',6),
	(44,4,'updated_at','timestamp','updated_at',0,0,0,0,0,0,'',7),
	(45,6,'id','number','id',1,0,0,0,0,0,'',1),
	(46,6,'name','text','Name',1,1,1,1,1,1,'',2),
	(47,6,'created_at','timestamp','created_at',0,0,0,0,0,0,'',3),
	(48,6,'updated_at','timestamp','updated_at',0,0,0,0,0,0,'',4),
	(49,6,'display_name','text','Display Name',1,1,1,1,1,1,'',5),
	(50,1,'seo_title','text','seo_title',0,1,1,1,1,1,'',14),
	(51,1,'featured','checkbox','featured',1,1,1,1,1,1,'',15),
	(52,3,'role_id','text','role_id',1,1,1,1,1,1,'',9),
	(53,7,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(54,7,'house_id','select_dropdown','Dům',1,0,0,1,1,1,'{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}',2),
	(55,7,'name_cs','text','Název CZ',1,1,1,1,1,1,NULL,3),
	(56,7,'name_en','text','Název',1,1,1,1,1,1,NULL,4),
	(57,7,'beds','number','Postelí',1,1,1,1,1,1,NULL,5),
	(58,7,'sub_beds','number','Přistýlek',1,1,1,1,1,1,NULL,6),
	(59,7,'min_people','number','Min People',1,0,1,1,1,1,NULL,7),
	(60,7,'max_people','number','Max People',1,0,1,1,1,1,NULL,8),
	(61,7,'price_range','checkbox','Price Range',1,0,0,0,0,0,NULL,9),
	(62,7,'breakfast','checkbox','Breakfast',1,0,1,1,1,1,NULL,10),
	(63,7,'order','number','Order',1,0,0,0,0,0,NULL,11),
	(64,7,'visible','checkbox','Visible',1,0,1,1,1,1,NULL,12),
	(65,7,'created_at','timestamp','Created At',0,0,0,0,0,0,NULL,13),
	(66,7,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,14),
	(67,7,'images','multiple_images','Images',0,0,0,1,1,1,'{\"resize\":{\"width\":\"1600\",\"height\":\"null\"},\"quality\":\"90%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"}]}',16),
	(68,7,'main_image','image','Main Image',1,0,0,1,1,1,'{\"resize\":{\"width\":\"1600\",\"height\":\"null\"},\"quality\":\"90%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"}]}',15),
	(69,8,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(70,8,'name','text','Name',1,1,1,1,1,1,NULL,2),
	(71,8,'slug','text','Slug',1,1,1,1,1,1,NULL,3),
	(73,8,'desc_en','text','Desc En',0,0,1,1,1,1,NULL,5),
	(74,8,'desc_de','text','Desc De',0,0,1,1,1,1,NULL,6),
	(75,8,'main_image','image','Main Image',1,0,1,1,1,1,'{\"resize\":{\"width\":\"1600\",\"height\":\"null\"},\"quality\":\"90%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"}]}',7),
	(76,8,'images','multiple_images','Images',0,0,1,1,1,1,'{\"resize\":{\"width\":\"1600\",\"height\":\"null\"},\"quality\":\"90%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"}]}',8),
	(77,8,'address','text','Address',1,0,1,1,1,1,NULL,9),
	(78,8,'psc','text','Psc',1,0,1,1,1,1,NULL,10),
	(79,8,'city','text','City',1,0,1,1,1,1,NULL,11),
	(80,8,'phone','text','Phone',1,0,1,1,1,1,NULL,12),
	(82,8,'order','number','Order',1,0,0,0,0,0,NULL,13),
	(83,8,'created_at','timestamp','Created At',0,0,0,0,0,0,NULL,19),
	(84,8,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,20),
	(85,9,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(86,9,'headline','text','Nadpis',0,1,1,1,1,1,NULL,2),
	(87,9,'slug','text','url',0,1,1,1,1,1,'{\"slugify\":{\"origin\":\"headline\",\"forceUpdate\":true}}',3),
	(88,9,'excerpt','text','Krátký text',0,0,1,1,1,1,NULL,4),
	(89,9,'body','checkbox','Dlouhý text',0,0,1,1,1,1,NULL,5),
	(90,9,'lang','select_dropdown','Jazyk',0,1,1,1,1,1,'{\"default\":\"cs\",\"options\":{\"cs\":\"Česky\",\"en\":\"Anglicky\",\"de\":\"Německy\"}}',6),
	(91,9,'created_at','timestamp','Vytvořeno',0,0,1,1,0,1,NULL,7),
	(92,9,'updated_at','timestamp','Upraveno',0,0,0,0,0,0,NULL,8),
	(93,10,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(94,10,'headline','text','Nadpis',0,1,1,1,1,1,NULL,2),
	(95,10,'slug','text','url',0,1,1,1,1,1,'{\"slugify\":{\"origin\":\"headline\",\"forceUpdate\":true}}',3),
	(96,10,'excerpt','text','Krátký text',0,0,1,1,1,1,NULL,4),
	(97,10,'body','rich_text_box','Dlouhý text',0,0,1,1,1,1,NULL,5),
	(98,10,'lang','select_dropdown','Jazyk',0,1,1,1,1,1,'{\"default\":\"cs\",\"options\":{\"cs\":\"Česky\",\"en\":\"Anglicky\",\"de\":\"Německy\"}}',6),
	(99,10,'category','select_dropdown','Kategorie',0,1,1,1,1,1,'{\"default\":\"0\",\"options\":{\"0\":\"Nezařazeno\",\"1\":\"TURISTIKA\",\"2\":\"CYKLOTURISTIKA\",\"3\":\"LYŽOVÁNÍ\",\"4\":\"KOUPÁNÍ\",\"5\":\"PRO RODINY S DĚTMI\",\"6\":\"VODOPÁDY A JESKYNĚ\",\"7\":\"SPORTOVNÍ AKTIVITY\",\"8\":\"MUZEA A SKANZENY\",\"9\":\"MĚSTA A VESNICE\"}}',7),
	(100,10,'nearby','select_dropdown','Poblíž',0,0,1,1,1,1,'{\"default\":\"1\",\"options\":{\"1\":\"Kaprun\",\"2\":\"Leogang\"}}',8),
	(101,10,'season','select_dropdown','Sezóna',0,1,1,1,1,1,'{\"default\":\"0\",\"options\":{\"0\":\"Celoročně\",\"1\":\"Léto\",\"2\":\"Zima\"}}',9),
	(102,10,'minutes_from_kaprun','number','Minut od Kaprunu',0,0,1,1,1,1,NULL,10),
	(103,10,'minutes_from_leogang','number','Minut od Leogangu',0,0,1,1,1,1,NULL,11),
	(104,10,'created_at','timestamp','Created At',0,0,0,0,0,0,NULL,12),
	(105,10,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,13),
	(106,7,'floor_id','number','Floor Id',0,0,1,1,1,1,NULL,18),
	(107,7,'slug','text','Url',1,0,0,0,0,0,'{\"slugify\":{\"origin\":\"name_en\",\"forceUpdate\":true}}',19),
	(108,7,'desc_cz','text','Desc Cz',0,0,1,1,1,1,NULL,20),
	(109,7,'desc_en','text','Desc En',0,0,1,1,1,1,NULL,22),
	(110,7,'desc_de','text','Desc De',0,0,1,1,1,1,NULL,23),
	(111,7,'wifi','checkbox','Wifi',1,0,1,1,1,1,NULL,33),
	(112,7,'washing_machine','text','Washing Machine',1,0,1,1,1,1,NULL,46),
	(113,7,'hair_dryer','checkbox','Hair Dryer',1,0,1,1,1,1,NULL,45),
	(114,7,'kitchen','checkbox','Kitchen',1,0,1,1,1,1,NULL,44),
	(115,7,'fridge','checkbox','Fridge',1,0,1,1,1,1,NULL,43),
	(116,7,'air_conditioning','checkbox','Air Conditioning',1,0,1,1,1,1,NULL,42),
	(117,7,'ventilator','checkbox','Ventilator',1,0,1,1,1,1,NULL,41),
	(118,7,'free_parking','checkbox','Free Parking',1,0,1,1,1,1,NULL,40),
	(119,7,'bathroom_wc','number','Bathroom Wc',0,0,1,1,1,1,NULL,47),
	(120,7,'seperate_wc','checkbox','Seperate Wc',1,0,1,1,1,1,NULL,39),
	(121,7,'seperate_bathroom','checkbox','Seperate Bathroom',1,0,1,1,1,1,NULL,38),
	(122,7,'wc','number','Wc',0,0,1,1,1,1,NULL,37),
	(123,7,'showers','number','Showers',0,0,1,1,1,1,NULL,36),
	(124,7,'shower','checkbox','Shower',1,0,1,1,1,1,NULL,35),
	(125,7,'bathtub','checkbox','Bathtub',1,0,1,1,1,1,NULL,34),
	(126,7,'bidet','checkbox','Bidet',1,0,1,1,1,1,NULL,31),
	(127,7,'shower_gel','checkbox','Shower Gel',1,0,1,1,1,1,NULL,32),
	(128,7,'key_safe','checkbox','Key Safe',1,0,1,1,1,1,NULL,17),
	(129,7,'electronic_safe','checkbox','Electronic Safe',1,0,1,1,1,1,NULL,30),
	(130,7,'no_smoking','checkbox','No Smoking',1,0,1,1,1,1,NULL,29),
	(131,7,'balcony','checkbox','Balcony',1,0,1,1,1,1,NULL,28),
	(132,7,'bedrooms','number','Bedrooms',0,0,1,1,1,1,NULL,27),
	(133,7,'iron_rent','text','Iron Rent',1,0,1,1,1,1,NULL,26),
	(134,7,'wheelchair_access','checkbox','Wheelchair Access',1,0,1,1,1,1,NULL,25),
	(135,7,'area_m2','number','Area M2',1,0,1,1,1,1,NULL,24),
	(136,7,'animals','checkbox','Animals',1,0,1,1,1,1,NULL,21),
	(137,11,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(138,11,'name_cs','text','Název CZ',0,1,1,1,1,1,NULL,2),
	(139,11,'name_en','text','Název EN',0,0,1,1,1,1,NULL,3),
	(140,11,'name_de','text','Název DE',0,0,1,1,1,1,NULL,4),
	(141,11,'image','image','Fotka',0,0,1,1,1,1,'{\"resize\":{\"width\":\"1000\",\"height\":\"null\"},\"quality\":\"90%\",\"upsize\":true,\"thumbnails\":[{\"name\":\"medium\",\"scale\":\"50%\"}]}',5),
	(142,11,'house_id','select_dropdown','Dům',1,1,1,1,1,1,'{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}',6),
	(143,11,'created_at','timestamp','Vytvořeno',0,0,0,0,0,0,NULL,7),
	(144,11,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,8),
	(145,8,'desc_cs','text','Desc Cs',0,0,1,1,1,1,NULL,4),
	(146,8,'body_cs','rich_text_box','Body Cs',0,0,1,1,1,1,NULL,16),
	(147,8,'body_en','rich_text_box','Body En',0,0,1,1,1,1,NULL,17),
	(148,8,'body_de','rich_text_box','Body De',0,0,1,1,1,1,NULL,18),
	(149,12,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(156,12,'created_at','timestamp','Vytvořeno',0,1,1,1,0,1,NULL,8),
	(157,12,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,9),
	(158,13,'id','checkbox','Id',1,0,0,0,0,0,NULL,1),
	(159,13,'name','text','Name',1,1,1,1,1,1,NULL,2),
	(160,13,'url','text','Url',1,0,1,1,1,1,NULL,3),
	(161,13,'image','image','Image',0,1,1,1,1,1,NULL,4),
	(162,13,'created_at','timestamp','Created At',0,1,1,1,0,1,NULL,5),
	(163,13,'updated_at','timestamp','Updated At',0,0,0,0,0,0,NULL,6),
	(164,13,'order','number','Order',0,1,1,1,1,1,NULL,5),
	(165,12,'author','text','Author',0,1,1,1,1,1,NULL,2),
	(166,12,'body','text_area','Body',0,1,1,1,1,1,NULL,3),
	(167,12,'lang','text','Lang',1,1,1,1,1,1,NULL,4),
	(168,12,'show','checkbox','Show',1,1,1,1,1,1,NULL,5),
	(169,8,'lat','text','Lat',1,0,1,1,1,1,NULL,14),
	(170,8,'lng','text','Lng',1,0,1,1,1,1,NULL,15);

/*!40000 ALTER TABLE `data_rows` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table data_types
# ------------------------------------------------------------

DROP TABLE IF EXISTS `data_types`;

CREATE TABLE `data_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_types_name_unique` (`name`),
  UNIQUE KEY `data_types_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `data_types` WRITE;
/*!40000 ALTER TABLE `data_types` DISABLE KEYS */;

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `created_at`, `updated_at`)
VALUES
	(1,'posts','posts','Post','Posts','voyager-news','TCG\\Voyager\\Models\\Post',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(2,'pages','pages','Page','Pages','voyager-file-text','TCG\\Voyager\\Models\\Page',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(3,'users','users','User','Users','voyager-person','TCG\\Voyager\\Models\\User',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(4,'categories','categories','Category','Categories','voyager-categories','TCG\\Voyager\\Models\\Category',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(5,'menus','menus','Menu','Menus','voyager-list','TCG\\Voyager\\Models\\Menu',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(6,'roles','roles','Role','Roles','voyager-lock','TCG\\Voyager\\Models\\Role',NULL,'','',1,0,'2017-05-30 12:10:58','2017-05-30 12:10:58'),
	(7,'rooms','rooms','Room','Rooms','voyager-categories','App\\Models\\Room',NULL,NULL,NULL,1,0,'2017-06-05 08:02:20','2017-06-23 13:27:49'),
	(8,'houses','houses','Dům','Domy','voyager-home','App\\Models\\House',NULL,NULL,NULL,1,0,'2017-06-13 16:27:34','2017-08-30 13:45:52'),
	(9,'news','news','Novinka','Novinky',NULL,'App\\Models\\News',NULL,NULL,NULL,1,0,'2017-06-13 16:30:45','2017-06-13 16:30:45'),
	(10,'vacations','vacations','Dovolená','Dovolené',NULL,'App\\Models\\Vacation',NULL,NULL,NULL,1,0,'2017-06-13 16:35:50','2017-06-13 16:35:50'),
	(11,'floors','floors','Floor','Floors','voyager-book','App\\Models\\Floor',NULL,NULL,NULL,1,0,'2017-06-21 08:29:54','2017-06-23 13:28:27'),
	(12,'testemonials','testemonials','Testemonial','Testemonials','voyager-bubble-hear','App\\Models\\Testemonial',NULL,NULL,NULL,1,0,'2017-06-23 13:11:16','2017-06-23 13:25:38'),
	(13,'webcams','webcams','Webcam','Webcams','voyager-tv','App\\Models\\Webcam',NULL,NULL,NULL,1,0,'2017-09-12 12:56:01','2017-09-12 12:56:01');

/*!40000 ALTER TABLE `data_types` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table permission_groups
# ------------------------------------------------------------

DROP TABLE IF EXISTS `permission_groups`;

CREATE TABLE `permission_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permission_groups_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table permission_role
# ------------------------------------------------------------

DROP TABLE IF EXISTS `permission_role`;

CREATE TABLE `permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_permission_id_index` (`permission_id`),
  KEY `permission_role_role_id_index` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `permission_role` WRITE;
/*!40000 ALTER TABLE `permission_role` DISABLE KEYS */;

INSERT INTO `permission_role` (`permission_id`, `role_id`)
VALUES
	(1,1),
	(1,2),
	(2,1),
	(2,2),
	(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),
	(20,2),
	(21,1),
	(21,2),
	(22,1),
	(22,2),
	(23,1),
	(24,1),
	(25,1),
	(26,1),
	(27,1),
	(28,1),
	(29,1),
	(30,1),
	(31,1),
	(32,1),
	(33,1),
	(34,1),
	(35,1),
	(35,2),
	(36,1),
	(36,2),
	(37,1),
	(37,2),
	(38,1),
	(38,2),
	(39,1),
	(40,1),
	(40,2),
	(41,1),
	(42,1),
	(43,1),
	(44,1),
	(45,1),
	(45,2),
	(46,1),
	(46,2),
	(47,1),
	(47,2),
	(48,1),
	(48,2),
	(49,1),
	(49,2),
	(50,1),
	(50,2),
	(51,1),
	(51,2),
	(52,1),
	(52,2),
	(53,1),
	(53,2),
	(54,1),
	(54,2),
	(55,1),
	(55,2),
	(56,1),
	(57,1),
	(57,2),
	(58,1),
	(59,1),
	(60,1),
	(60,2),
	(61,1),
	(61,2),
	(62,1),
	(62,2),
	(63,1),
	(63,2),
	(64,1),
	(64,2),
	(65,1),
	(66,1),
	(67,1),
	(68,1),
	(69,1),
	(70,1),
	(71,1);

/*!40000 ALTER TABLE `permission_role` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table permissions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `permissions`;

CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `permission_group_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_key_index` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`, `permission_group_id`)
VALUES
	(1,'browse_admin',NULL,'2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(2,'browse_database',NULL,'2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(3,'browse_media',NULL,'2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(4,'browse_settings',NULL,'2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(5,'browse_menus','menus','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(6,'read_menus','menus','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(7,'edit_menus','menus','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(8,'add_menus','menus','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(9,'delete_menus','menus','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(10,'browse_pages','pages','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(11,'read_pages','pages','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(12,'edit_pages','pages','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(13,'add_pages','pages','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(14,'delete_pages','pages','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(15,'browse_roles','roles','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(16,'read_roles','roles','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(17,'edit_roles','roles','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(18,'add_roles','roles','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(19,'delete_roles','roles','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(20,'browse_users','users','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(21,'read_users','users','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(22,'edit_users','users','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(23,'add_users','users','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(24,'delete_users','users','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(25,'browse_posts','posts','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(26,'read_posts','posts','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(27,'edit_posts','posts','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(28,'add_posts','posts','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(29,'delete_posts','posts','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(30,'browse_categories','categories','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(31,'read_categories','categories','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(32,'edit_categories','categories','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(33,'add_categories','categories','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(34,'delete_categories','categories','2017-05-30 12:10:58','2017-05-30 12:10:58',NULL),
	(35,'browse_rooms','rooms','2017-06-05 08:02:20','2017-06-05 08:02:20',NULL),
	(36,'read_rooms','rooms','2017-06-05 08:02:20','2017-06-05 08:02:20',NULL),
	(37,'edit_rooms','rooms','2017-06-05 08:02:20','2017-06-05 08:02:20',NULL),
	(38,'add_rooms','rooms','2017-06-05 08:02:20','2017-06-05 08:02:20',NULL),
	(39,'delete_rooms','rooms','2017-06-05 08:02:20','2017-06-05 08:02:20',NULL),
	(40,'browse_houses','houses','2017-06-13 16:27:34','2017-06-13 16:27:34',NULL),
	(41,'read_houses','houses','2017-06-13 16:27:34','2017-06-13 16:27:34',NULL),
	(42,'edit_houses','houses','2017-06-13 16:27:34','2017-06-13 16:27:34',NULL),
	(43,'add_houses','houses','2017-06-13 16:27:34','2017-06-13 16:27:34',NULL),
	(44,'delete_houses','houses','2017-06-13 16:27:34','2017-06-13 16:27:34',NULL),
	(45,'browse_news','news','2017-06-13 16:30:45','2017-06-13 16:30:45',NULL),
	(46,'read_news','news','2017-06-13 16:30:45','2017-06-13 16:30:45',NULL),
	(47,'edit_news','news','2017-06-13 16:30:45','2017-06-13 16:30:45',NULL),
	(48,'add_news','news','2017-06-13 16:30:45','2017-06-13 16:30:45',NULL),
	(49,'delete_news','news','2017-06-13 16:30:45','2017-06-13 16:30:45',NULL),
	(50,'browse_vacations','vacations','2017-06-13 16:35:51','2017-06-13 16:35:51',NULL),
	(51,'read_vacations','vacations','2017-06-13 16:35:51','2017-06-13 16:35:51',NULL),
	(52,'edit_vacations','vacations','2017-06-13 16:35:51','2017-06-13 16:35:51',NULL),
	(53,'add_vacations','vacations','2017-06-13 16:35:51','2017-06-13 16:35:51',NULL),
	(54,'delete_vacations','vacations','2017-06-13 16:35:51','2017-06-13 16:35:51',NULL),
	(55,'browse_floors','floors','2017-06-21 08:29:54','2017-06-21 08:29:54',NULL),
	(56,'read_floors','floors','2017-06-21 08:29:54','2017-06-21 08:29:54',NULL),
	(57,'edit_floors','floors','2017-06-21 08:29:54','2017-06-21 08:29:54',NULL),
	(58,'add_floors','floors','2017-06-21 08:29:54','2017-06-21 08:29:54',NULL),
	(59,'delete_floors','floors','2017-06-21 08:29:54','2017-06-21 08:29:54',NULL),
	(60,'browse_testemonials','testemonials','2017-06-23 13:11:16','2017-06-23 13:11:16',NULL),
	(61,'read_testemonials','testemonials','2017-06-23 13:11:16','2017-06-23 13:11:16',NULL),
	(62,'edit_testemonials','testemonials','2017-06-23 13:11:16','2017-06-23 13:11:16',NULL),
	(63,'add_testemonials','testemonials','2017-06-23 13:11:16','2017-06-23 13:11:16',NULL),
	(64,'delete_testemonials','testemonials','2017-06-23 13:11:16','2017-06-23 13:11:16',NULL),
	(65,'browse_hooks','admin','2017-09-12 12:34:39','2017-09-12 12:34:39',NULL),
	(66,'browse_compass',NULL,'2017-09-12 14:42:27','2017-09-12 14:42:27',NULL),
	(67,'browse_webcams','webcams','2017-09-12 12:56:01','2017-09-12 12:56:01',NULL),
	(68,'read_webcams','webcams','2017-09-12 12:56:01','2017-09-12 12:56:01',NULL),
	(69,'edit_webcams','webcams','2017-09-12 12:56:01','2017-09-12 12:56:01',NULL),
	(70,'add_webcams','webcams','2017-09-12 12:56:01','2017-09-12 12:56:01',NULL),
	(71,'delete_webcams','webcams','2017-09-12 12:56:01','2017-09-12 12:56:01',NULL);

/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table settings
# ------------------------------------------------------------

DROP TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT '1',
  `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`)
VALUES
	(3,'logo','Site Logo','logo.png','','image',3,NULL),
	(4,'admin_bg_image','Admin Background Image','hero.jpg','','image',9,NULL),
	(5,'admin_title','Admin Title','Baranek Resorts','','text',4,NULL),
	(6,'admin_description','Admin Description','Administrace webu','','text',5,NULL),
	(7,'admin_loader','Admin Loader','logo.png','','image',6,NULL),
	(8,'admin_icon_image','Admin Icon Image','logo.png','','image',7,NULL),
	(9,'google_analytics_client_id','Google Analytics Client ID','','','text',9,NULL);

/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table translations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `translations`;

CREATE TABLE `translations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int(10) unsigned NOT NULL,
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `street` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `psc` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invoice` tinyint(1) NOT NULL DEFAULT '0',
  `company` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_street` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_psc` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_city` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ico` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dic` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `discount` int(11) NOT NULL DEFAULT '0',
  `newsletter` tinyint(1) NOT NULL DEFAULT '0',
  `recovery_code` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `confirmed` tinyint(1) NOT NULL DEFAULT '0',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `password`, `title`, `first_name`, `last_name`, `street`, `psc`, `city`, `country`, `language`, `phone`, `invoice`, `company`, `company_street`, `company_psc`, `company_city`, `ico`, `dic`, `note`, `discount`, `newsletter`, `recovery_code`, `confirmed`, `remember_token`, `created_at`, `updated_at`)
VALUES
	(1,1,'Madnest','hello@madnest.co','logo.png','$2y$10$0ce0QM9pajFKyEwPspNM8uq9pzD8.Xcn04/OM6/KkpVyv9ktrsDEu','','Mad','Nester','Blažejské náměstí 13','12345','Olomouc','cz','cz','123456789',1,'Mad Nest studios s.r.o.','Bartošova 9','73501','Přerov','3434256','CZ25826158',NULL,0,0,'',0,'EeDoFdjInCNOOflizQjm7gUKj6ZcCzkrUTkAuEOvdtMniLRScyK5DICR8fQo','2017-06-13 10:51:03','2017-06-13 10:51:03'),
	(2,2,'BWB','info@baranekresorts.com','logo.png','$2y$10$op2qkvU0aZGF1gusYploFepSs9uWfI2b6tBFxE74qN4MYV5g9c9MW','','Martin','Baránek','','12345','','','','',0,'','','','','','',NULL,0,0,'',0,'5Bgwv2Ml4GOPb7xM0REYNBQKws2U91QbBQGPYNQns9lTIlxgLn0gsz02hPzp','2017-06-13 10:51:03','2017-06-13 10:51:03'),
	(3,3,'','theimer96@gmail.com',NULL,'$2y$10$L4/euBgMwc6tPV9M5QF8EOu.XWRZexGD4ttbrykbt7z4fgrEbObOO','Dickheados','Jakub','Theimer','Teplice nad Bečvou','12345','Hranice','cz','cz','731118493',1,'Mad Nest studios s.r.o.','Bartošova 9','73501','Přerov','3434256','CZ25826158','',9,1,'code_583f4d0e612674.42112264',1,NULL,'2016-11-08 22:43:38','2016-11-08 22:43:38'),
	(4,3,'','vecera@madnest.co',NULL,'$2y$10$bLSkK5Zz3n/LY/neytx9xe2lsYHT1RsNrnA1S4UIpYTQ6Q/JJPKnC','MUDr.','Jakub','Večeřa','Horní','12345','Dolní','cz','cz','666 666 777',1,'Madnest','','','','','','',0,1,'code_5841bdc8224611.68411992',1,NULL,'2016-12-02 18:30:32','2016-12-02 18:30:32'),
	(5,3,'','dwalter@seznam.cz',NULL,'$2y$10$4slA86RVF2Z101172H89a.r/L.vNZ8QYEVHXTnHSyPcpDJ4XH4N8a','','David','Walter','Voskovcova','12345','Olomouc','cz','en','773565256',0,'','','','','','','',0,1,'code_58403a08e5e1f2.71890347',1,NULL,'2016-12-01 14:56:08','2016-12-01 14:56:08'),
	(6,3,'','walter@madnest.co',NULL,'$2y$10$S5/W7uAgi3AAzOOzJbGXQu1q.OBmlbLDRUEMLkEG/A8inaDLiKbR.','Bc.','David','Walter','Voskovcova 722/6','12345','Olomouc','cz','cz','773565256',1,'Madnest','Blažejské náměstí 13','77900','Olomouc','3456666','CZ76767766','',3,1,'code_58908cab87f3a7.15760542',1,NULL,'2017-01-31 14:10:03','2017-01-31 14:10:03'),
	(7,3,'','bilek@em-zet.cz',NULL,'$2y$10$.ij6Hbm94gC0HERl.p1r1u2MVbC1yjsPw/MlhTJZwpVPpVDookidy','','Václav','Bílek','Bartošova 9','12345','Přerov','cz','cz','777705430',1,'','','','','','','',0,1,'code_58b4304b1ce164.89134016',1,NULL,'2017-02-27 14:57:31','2017-02-27 14:57:31');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users_changelog
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_changelog`;

CREATE TABLE `users_changelog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `index` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `old` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `new` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `users_changelog` WRITE;
/*!40000 ALTER TABLE `users_changelog` DISABLE KEYS */;

INSERT INTO `users_changelog` (`id`, `user_id`, `admin_id`, `index`, `old`, `new`, `created_at`)
VALUES
	(9,2,1,'first_name','Jakub','Jakubian','2016-12-02 23:05:11'),
	(10,2,1,'first_name','Jakubian','Jakub','2016-12-02 23:05:18'),
	(11,2,NULL,'title','MUDr.','Ing.','2016-12-02 23:21:54'),
	(12,2,NULL,'company_street1','Bartošova 9','Bartošova ','2016-12-02 23:21:54'),
	(13,2,NULL,'company_street2','','9','2016-12-02 23:21:54'),
	(14,3,1,'phone','666 666 666','666 666 777','2016-12-02 23:26:18'),
	(16,2,1,'last_name','Theimer','Theimerr','2016-12-07 09:45:56'),
	(17,2,1,'title','Kokot','Dickhead','2016-12-07 09:46:27'),
	(18,2,NULL,'title','Dickhead','Dickheados','2016-12-07 09:46:51'),
	(19,5,1,'country','','at','2017-01-10 12:57:00'),
	(20,5,1,'invoice','0','1','2017-01-10 12:57:00'),
	(21,5,1,'discount','0','','2017-01-10 12:57:00'),
	(22,2,1,'last_name','Theimerr','Theimer','2017-01-23 15:39:36'),
	(23,2,1,'discount','0','','2017-01-23 15:39:36'),
	(37,15,1,'city','','Cock','2017-01-23 18:20:44'),
	(38,15,1,'discount','0','','2017-01-23 18:20:44'),
	(39,2,1,'discount','0','10','2017-01-26 10:50:38'),
	(40,2,3,'dic','','CZ25826158','2017-01-31 10:30:22'),
	(41,2,3,'ico','','3434256','2017-01-31 10:36:18'),
	(42,18,3,'discount','0','3','2017-01-31 14:10:35'),
	(43,18,3,'dic','Cz76767766','CZ76767766','2017-01-31 14:10:49'),
	(44,18,3,'ico','656546465','3456666','2017-01-31 14:11:29'),
	(45,2,3,'discount','10','9','2017-02-08 10:42:00'),
	(46,2,1,'birth_date','0000-00-00','1996-10-06','2017-02-24 11:15:07'),
	(47,6,1,'country','','at','2017-02-24 13:05:12'),
	(48,6,1,'invoice','0','1','2017-02-24 13:05:12'),
	(49,2,1,'birth_date','2000-01-01','1996-10-06','2017-02-24 13:05:27'),
	(50,19,3,'birth_date',NULL,'2017-02-27','2017-02-27 14:57:39'),
	(51,19,3,'birth_date',NULL,'2002-06-22','2017-02-27 14:59:37'),
	(52,5,3,'email','','dwalter@seznam.cz','2017-03-29 14:48:04'),
	(53,5,3,'email','','dwalter@seznam.cz','2017-03-29 14:51:17'),
	(54,5,3,'title','','Mc','2017-03-29 14:51:17'),
	(55,5,3,'email','','dwalter@seznam.cz','2017-03-29 14:51:44'),
	(56,5,3,'email','','dwalter@seznam.cz','2017-03-29 14:54:28'),
	(57,19,1,'street1','','Bartošova 9','2017-04-05 14:52:04'),
	(58,19,1,'street2','','1729','2017-04-05 14:52:04'),
	(59,19,1,'psc','','75002','2017-04-05 14:52:04'),
	(60,19,1,'city','','Přerov','2017-04-05 14:52:04'),
	(61,19,1,'phone','','777705430','2017-04-05 14:52:04'),
	(62,20,1,'first_name','Bookong','Booking','2017-04-05 14:53:50'),
	(63,20,1,'last_name','Booking','.','2017-04-06 13:16:17'),
	(64,20,1,'first_name','Booking','Václav','2017-04-06 13:16:36'),
	(65,20,1,'last_name','.','Booking','2017-04-06 13:16:36'),
	(66,20,1,'street1','','Kozlovska 23','2017-04-06 13:16:36'),
	(67,20,1,'psc','','75002','2017-04-06 13:16:36'),
	(68,20,1,'city','','Přerov','2017-04-06 13:16:36'),
	(69,20,1,'phone','','777705430','2017-04-06 13:16:36'),
	(70,20,1,'first_name','Václav','.','2017-04-06 13:17:01');

/*!40000 ALTER TABLE `users_changelog` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;
Youez - 2016 - github.com/yon3zu
LinuXploit