# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Hôte: 127.0.0.1 (MySQL 5.7.18-0ubuntu0.16.04.1)
# Base de données: wanderbrief_guides
# Temps de génération: 2017-06-06 18:25:19 +0000
# ************************************************************




# Affichage de la table guide_assetfiles
# ------------------------------------------------------------


CREATE TABLE `guide_assetfiles` (
  `id` int(11) NOT NULL,
  `sourceId` int(11) DEFAULT NULL,
  `folderId` int(11) NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `kind` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown',
  `width` int(11) unsigned DEFAULT NULL,
  `height` int(11) unsigned DEFAULT NULL,
  `size` bigint(20) unsigned DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_assetfiles_filename_folderId_unq_idx` (`filename`,`folderId`),
  KEY `guide_assetfiles_sourceId_fk` (`sourceId`),
  KEY `guide_assetfiles_folderId_fk` (`folderId`),
  CONSTRAINT `guide_assetfiles_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `guide_assetfolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_assetfiles_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_assetfiles_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `guide_assetsources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(6,1,1,'1899.jpg','image',1920,1280,1446434,'2017-06-06 14:50:09','2017-06-06 14:50:09','2017-06-06 14:50:09','cafc8e0d-0c98-4d6b-95c1-760cae3bf601');



# Affichage de la table guide_assetfolders
# ------------------------------------------------------------


CREATE TABLE `guide_assetfolders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `sourceId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_assetfolders_name_parentId_sourceId_unq_idx` (`name`,`parentId`,`sourceId`),
  KEY `guide_assetfolders_parentId_fk` (`parentId`),
  KEY `guide_assetfolders_sourceId_fk` (`sourceId`),
  CONSTRAINT `guide_assetfolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `guide_assetfolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_assetfolders_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `guide_assetsources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,NULL,1,'Cities','','2017-06-05 17:58:34','2017-06-05 17:58:34','33252528-a55d-498d-935b-561de10780a4'),
	(2,NULL,2,'Gears','','2017-06-05 17:59:22','2017-06-05 17:59:22','204e447f-a9e8-4bcd-a919-a401e9c104e0'),
	(3,NULL,3,'Places','','2017-06-05 18:07:39','2017-06-05 18:07:39','b67aed75-94c1-4f6f-b146-ee1c3994fa6f'),
	(4,NULL,4,'Others','','2017-06-05 18:08:18','2017-06-05 18:08:18','a8475eee-308a-4c0e-9a34-ef337d32d793'),
	(5,NULL,5,'Promotions','','2017-06-06 16:58:12','2017-06-06 16:58:12','941c7d57-132a-4cba-b3a4-3b7709ab71ef');




# Affichage de la table guide_assetsources
# ------------------------------------------------------------


CREATE TABLE `guide_assetsources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `fieldLayoutId` int(10) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_assetsources_name_unq_idx` (`name`),
  UNIQUE KEY `guide_assetsources_handle_unq_idx` (`handle`),
  KEY `guide_assetsources_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_assetsources_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Cities','cities','Local','{\"path\":\"\\/var\\/www\\/wanderbrief-guides.local\\/public\\/storage\\/images\\/cities\\/\",\"publicURLs\":\"1\",\"url\":\"http:\\/\\/wanderbrief-guides.local\\/storage\\/images\\/cities\\/\"}',1,31,'2017-06-05 17:58:34','2017-06-05 18:50:32','b675aebe-2b4a-47d5-951b-9106f3df6a75'),
	(2,'Gears','gears','Local','{\"path\":\"\\/var\\/www\\/wanderbrief-guides.local\\/public\\/storage\\/images\\/gears\\/\",\"publicURLs\":\"1\",\"url\":\"http:\\/\\/wanderbrief-guides.local\\/storage\\/images\\/gears\\/\"}',2,33,'2017-06-05 17:59:22','2017-06-05 18:50:51','76f3b074-50eb-46d3-9a4b-f57b10474d46'),
	(3,'Places','places','Local','{\"path\":\"\\/var\\/www\\/wanderbrief-guides.local\\/public\\/storage\\/images\\/places\\/\",\"publicURLs\":\"1\",\"url\":\"http:\\/\\/wanderbrief-guides.local\\/storage\\/images\\/places\\/\"}',3,32,'2017-06-05 18:07:39','2017-06-05 18:50:43','b0409883-802e-4709-9647-c29c38cff572'),
	(4,'Others','others','Local','{\"path\":\"\\/var\\/www\\/wanderbrief-guides.local\\/public\\/storage\\/images\\/others\\/\",\"publicURLs\":\"1\",\"url\":\"http:\\/\\/wanderbrief-guides.local\\/storage\\/images\\/others\\/\"}',4,34,'2017-06-05 18:08:18','2017-06-05 18:51:04','60734df6-bc82-4d8c-ae21-2cb286b3727b'),
	(5,'Promotions','promotions','Local','{\"path\":\"\\/home\\/ubuntu\\/www\\/wanderbrief-guides.local\\/public\\/storage\\/images\\/promotions\\/\",\"publicURLs\":\"1\",\"url\":\"http:\\/\\/wanderbrief-guides.local\\/storage\\/images\\/promotions\\/\"}',5,64,'2017-06-06 16:58:12','2017-06-06 16:58:12','5430d38f-800b-4471-863a-33a5895223d5');



# Affichage de la table guide_assettransformindex
# ------------------------------------------------------------


CREATE TABLE `guide_assettransformindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fileId` int(11) NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sourceId` int(11) DEFAULT NULL,
  `fileExists` tinyint(1) DEFAULT NULL,
  `inProgress` tinyint(1) DEFAULT NULL,
  `dateIndexed` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_assettransformindex_sourceId_fileId_location_idx` (`sourceId`,`fileId`,`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_assettransformindex` (`id`, `fileId`, `filename`, `format`, `location`, `sourceId`, `fileExists`, `inProgress`, `dateIndexed`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,6,'1899.jpg','jpg','_cover',1,1,0,'2017-06-06 14:55:11','2017-06-06 14:55:11','2017-06-06 14:55:12','9431c82b-d518-49a7-bdf6-a66148ada261');



# Affichage de la table guide_assettransforms
# ------------------------------------------------------------


CREATE TABLE `guide_assettransforms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mode` enum('stretch','fit','crop') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'crop',
  `position` enum('top-left','top-center','top-right','center-left','center-center','center-right','bottom-left','bottom-center','bottom-right') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'center-center',
  `height` int(10) DEFAULT NULL,
  `width` int(10) DEFAULT NULL,
  `format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `quality` int(10) DEFAULT NULL,
  `dimensionChangeTime` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_assettransforms_name_unq_idx` (`name`),
  UNIQUE KEY `guide_assettransforms_handle_unq_idx` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_assettransforms` (`id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Cover','cover','crop','center-center',600,1920,'jpg',82,'2017-06-06 14:40:20','2017-06-06 14:40:20','2017-06-06 14:40:20','f9ffb9e2-eaf8-421d-ac9c-831f4fb9d5f2'),
	(2,'Square','square','crop','center-center',1280,1280,'jpg',82,'2017-06-06 14:40:45','2017-06-06 14:40:45','2017-06-06 14:40:45','091fcfe6-a652-43a9-9d24-23a19f7f071c');



# Affichage de la table guide_categories
# ------------------------------------------------------------


CREATE TABLE `guide_categories` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_categories_groupId_fk` (`groupId`),
  CONSTRAINT `guide_categories_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_categories_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_categorygroups
# ------------------------------------------------------------


CREATE TABLE `guide_categorygroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hasUrls` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `template` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_categorygroups_name_unq_idx` (`name`),
  UNIQUE KEY `guide_categorygroups_handle_unq_idx` (`handle`),
  KEY `guide_categorygroups_structureId_fk` (`structureId`),
  KEY `guide_categorygroups_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_categorygroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `guide_categorygroups_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `guide_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_categorygroups` (`id`, `structureId`, `fieldLayoutId`, `name`, `handle`, `hasUrls`, `template`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,37,'Gears','gears',0,NULL,'2017-06-05 18:56:37','2017-06-05 18:56:37','d919b6d3-f9f8-4f4c-b547-82040c7f346e');



# Affichage de la table guide_categorygroups_i18n
# ------------------------------------------------------------


CREATE TABLE `guide_categorygroups_i18n` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `urlFormat` text COLLATE utf8_unicode_ci,
  `nestedUrlFormat` text COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_categorygroups_i18n_groupId_locale_unq_idx` (`groupId`,`locale`),
  KEY `guide_categorygroups_i18n_locale_fk` (`locale`),
  CONSTRAINT `guide_categorygroups_i18n_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_categorygroups_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_categorygroups_i18n` (`id`, `groupId`, `locale`, `urlFormat`, `nestedUrlFormat`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'en',NULL,NULL,'2017-06-05 18:56:37','2017-06-05 18:56:37','fda1f70d-50d4-44a2-bfc8-972878a01d78');



# Affichage de la table guide_content
# ------------------------------------------------------------


CREATE TABLE `guide_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_body` text COLLATE utf8_unicode_ci,
  `field_shortDescription` text COLLATE utf8_unicode_ci,
  `field_metaTitle` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_metaDescription` varchar(220) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_internetSpeed` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_funFactor` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'medium',
  `field_safetyFactor` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'medium',
  `field_polutionFactor` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'medium',
  `field_nomadFriendly` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `field_uberAvailable` text COLLATE utf8_unicode_ci,
  `field_airbnbAvailable` text COLLATE utf8_unicode_ci,
  `field_pricingMonthlyBudget` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingWeeklyBudget` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingMeal` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingBeer` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingCoffee` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingUnitLocalTransport` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingMonthlyLocalTransport` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingTaxi` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingAccomodation1Bedroom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingAccomodation3Bedroom` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingFitnessClub` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingCoworkingSpace` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_pricingSimCard` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_author` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_updateLog` text COLLATE utf8_unicode_ci,
  `field_pros` text COLLATE utf8_unicode_ci,
  `field_cons` text COLLATE utf8_unicode_ci,
  `field_specifications` text COLLATE utf8_unicode_ci,
  `field_shopLink` text COLLATE utf8_unicode_ci,
  `field_speciality` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_vibe` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_placeType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_veganOptions` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `field_fullAddress` text COLLATE utf8_unicode_ci,
  `field_googleMapLink` text COLLATE utf8_unicode_ci,
  `field_phone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_website` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_openingHours` text COLLATE utf8_unicode_ci,
  `field_rating` decimal(2,1) unsigned DEFAULT '0.0',
  `field_position` smallint(4) unsigned DEFAULT '0',
  `field_announcerName` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `field_promotionLink` text COLLATE utf8_unicode_ci,
  `field_promotionText` text COLLATE utf8_unicode_ci,
  `field_promotionStartAt` datetime DEFAULT NULL,
  `field_promotionEndAt` datetime DEFAULT NULL,
  `field_promotionActive` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_content_elementId_locale_unq_idx` (`elementId`,`locale`),
  KEY `guide_content_title_idx` (`title`),
  KEY `guide_content_locale_fk` (`locale`),
  CONSTRAINT `guide_content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_content_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_shortDescription`, `field_metaTitle`, `field_metaDescription`, `field_internetSpeed`, `field_funFactor`, `field_safetyFactor`, `field_polutionFactor`, `field_nomadFriendly`, `field_uberAvailable`, `field_airbnbAvailable`, `field_pricingMonthlyBudget`, `field_pricingWeeklyBudget`, `field_pricingMeal`, `field_pricingBeer`, `field_pricingCoffee`, `field_pricingUnitLocalTransport`, `field_pricingMonthlyLocalTransport`, `field_pricingTaxi`, `field_pricingAccomodation1Bedroom`, `field_pricingAccomodation3Bedroom`, `field_pricingFitnessClub`, `field_pricingCoworkingSpace`, `field_pricingSimCard`, `field_author`, `field_updateLog`, `field_pros`, `field_cons`, `field_specifications`, `field_shopLink`, `field_speciality`, `field_vibe`, `field_placeType`, `field_veganOptions`, `field_fullAddress`, `field_googleMapLink`, `field_phone`, `field_website`, `field_openingHours`, `field_rating`, `field_position`, `field_announcerName`, `field_promotionLink`, `field_promotionText`, `field_promotionStartAt`, `field_promotionEndAt`, `field_promotionActive`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'en',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0.0,0,NULL,NULL,NULL,NULL,NULL,0,'2017-06-05 15:46:29','2017-06-05 15:46:29','45577930-6daa-4d56-ae08-e0dd4fbd39d3'),
	(2,2,'en','Home','<p>It’s true, this site doesn’t have a whole lot of content yet, but don’t worry. Our web developers have just installed the CMS, and they’re setting things up for the content editors this very moment. Soon Wanderbrief-guides.local will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.</p>',NULL,'Wanderbrief CityGuides — Curated by local nomads.','Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0.0,0,NULL,NULL,NULL,NULL,NULL,0,'2017-06-05 15:46:31','2017-06-06 15:03:13','25d7fb9f-d833-44de-a5d1-da89af0840c2'),
	(4,4,'en','Amsterdam',NULL,'<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!</p>','','','','high','medium','low',1,'','','','','','','','','','','','','','','',NULL,'[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}]','','',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0.0,0,'iamsterdam','http://www.iamsterdam.com/fr/visiter','','2017-06-04 00:00:00','2017-06-18 00:00:00',1,'2017-06-05 19:31:18','2017-06-06 18:06:42','91112744-d0a4-4d26-9196-a97653f82656'),
	(5,5,'en','Noord',NULL,'','','',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0.0,0,NULL,NULL,NULL,NULL,NULL,0,'2017-06-05 19:40:41','2017-06-05 19:40:41','7e0700f0-978d-4f4c-a400-29f9ccab3eab'),
	(6,6,'en','1899',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0.0,0,NULL,NULL,NULL,NULL,NULL,0,'2017-06-06 14:50:09','2017-06-06 14:50:09','7c8b1c26-4522-4bcd-953e-1049354c8292');




# Affichage de la table guide_elementindexsettings
# ------------------------------------------------------------


CREATE TABLE `guide_elementindexsettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_elementindexsettings_type_unq_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_elementindexsettings` (`id`, `type`, `settings`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Entry','{\"sourceOrder\":[[\"heading\",\"Guides\"],[\"key\",\"section:4\"],[\"key\",\"section:5\"],[\"heading\",\"Places\"],[\"key\",\"section:6\"],[\"key\",\"section:7\"],[\"key\",\"section:8\"],[\"key\",\"section:9\"],[\"heading\",\"Gear\"],[\"key\",\"section:3\"],[\"heading\",\"Pages\"],[\"key\",\"singles\"],[\"heading\",\"\"],[\"key\",\"*\"]],\"sources\":{\"*\":{\"tableAttributes\":{\"1\":\"section\",\"2\":\"postDate\",\"3\":\"expiryDate\",\"4\":\"link\"}},\"section:3\":{\"tableAttributes\":{\"1\":\"postDate\",\"2\":\"expiryDate\",\"3\":\"link\"}},\"section:4\":{\"tableAttributes\":{\"1\":\"postDate\",\"2\":\"expiryDate\",\"3\":\"link\"}}}}','2017-06-05 15:53:03','2017-06-05 16:50:27','983b092f-86ac-4c1e-883d-830d372fc7f0');



# Affichage de la table guide_elements
# ------------------------------------------------------------


CREATE TABLE `guide_elements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `archived` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_elements_type_idx` (`type`),
  KEY `guide_elements_enabled_idx` (`enabled`),
  KEY `guide_elements_archived_dateCreated_idx` (`archived`,`dateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'User',1,0,'2017-06-05 15:46:29','2017-06-05 15:46:29','54b7b6a6-f70b-4a37-bd7d-3c5d6b5860f4'),
	(2,'Entry',1,0,'2017-06-05 15:46:30','2017-06-06 15:03:13','cbeaa1cb-0280-445a-bdf3-1dbb02f8a2e3'),
	(4,'Entry',1,0,'2017-06-05 19:31:18','2017-06-06 18:06:42','d47b8baa-2dca-4d64-80a6-0cda525df0f4'),
	(5,'Entry',1,0,'2017-06-05 19:40:41','2017-06-05 19:40:41','1350bc0a-9dd7-44c5-9bde-9975ead76b3c'),
	(6,'Asset',1,0,'2017-06-06 14:50:09','2017-06-06 14:50:09','9bfa79c9-70e9-4ab0-a854-0cf3af1c9f15');



# Affichage de la table guide_elements_i18n
# ------------------------------------------------------------


CREATE TABLE `guide_elements_i18n` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_elements_i18n_elementId_locale_unq_idx` (`elementId`,`locale`),
  UNIQUE KEY `guide_elements_i18n_uri_locale_unq_idx` (`uri`,`locale`),
  KEY `guide_elements_i18n_slug_locale_idx` (`slug`,`locale`),
  KEY `guide_elements_i18n_enabled_idx` (`enabled`),
  KEY `guide_elements_i18n_locale_fk` (`locale`),
  CONSTRAINT `guide_elements_i18n_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_elements_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'en','',NULL,1,'2017-06-05 15:46:29','2017-06-05 15:46:29','d29d3fd3-3d45-46c7-9257-169cae44308f'),
	(2,2,'en','homepage','__home__',1,'2017-06-05 15:46:31','2017-06-06 15:03:13','b93b12ec-a321-4845-b50a-0df7bca448a7'),
	(4,4,'en','amsterdam','cities/amsterdam',1,'2017-06-05 19:31:19','2017-06-06 18:06:43','65085697-108a-4d7b-80df-899272b5b9c7'),
	(5,5,'en','noord','neighborhoods/noord',1,'2017-06-05 19:40:41','2017-06-05 19:40:41','cac60e1f-b842-4877-8a5f-562108e89a70'),
	(6,6,'en','1899',NULL,1,'2017-06-06 14:50:09','2017-06-06 14:50:09','1dadd3b5-ea76-4e0d-8ca0-3d85c69317b1');




# Affichage de la table guide_entries
# ------------------------------------------------------------


CREATE TABLE `guide_entries` (
  `id` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `typeId` int(11) DEFAULT NULL,
  `authorId` int(11) DEFAULT NULL,
  `postDate` datetime DEFAULT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_entries_sectionId_idx` (`sectionId`),
  KEY `guide_entries_typeId_idx` (`typeId`),
  KEY `guide_entries_postDate_idx` (`postDate`),
  KEY `guide_entries_expiryDate_idx` (`expiryDate`),
  KEY `guide_entries_authorId_fk` (`authorId`),
  CONSTRAINT `guide_entries_authorId_fk` FOREIGN KEY (`authorId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entries_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entries_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `guide_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entries_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `guide_entrytypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(2,1,NULL,NULL,'2017-06-05 15:46:30',NULL,'2017-06-05 15:46:31','2017-06-06 15:03:13','53916099-5e82-4044-877d-dba569fe380c'),
	(4,4,4,1,'2017-06-05 19:31:00',NULL,'2017-06-05 19:31:19','2017-06-06 18:06:43','f49feb0b-90c7-4b96-87a2-fca0fc34d47a'),
	(5,5,5,1,'2017-06-05 19:40:41',NULL,'2017-06-05 19:40:41','2017-06-05 19:40:41','bb63ef92-c3a8-46e5-b237-7aa3a0daa6b6');



# Affichage de la table guide_entrydrafts
# ------------------------------------------------------------


CREATE TABLE `guide_entrydrafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entryId` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `creatorId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `notes` tinytext COLLATE utf8_unicode_ci,
  `data` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_entrydrafts_entryId_locale_idx` (`entryId`,`locale`),
  KEY `guide_entrydrafts_sectionId_fk` (`sectionId`),
  KEY `guide_entrydrafts_creatorId_fk` (`creatorId`),
  KEY `guide_entrydrafts_locale_fk` (`locale`),
  CONSTRAINT `guide_entrydrafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entrydrafts_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `guide_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entrydrafts_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `guide_entrydrafts_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `guide_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_entrytypes
# ------------------------------------------------------------


CREATE TABLE `guide_entrytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hasTitleField` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `titleLabel` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'Title',
  `titleFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_entrytypes_name_sectionId_unq_idx` (`name`,`sectionId`),
  UNIQUE KEY `guide_entrytypes_handle_sectionId_unq_idx` (`handle`,`sectionId`),
  KEY `guide_entrytypes_sectionId_fk` (`sectionId`),
  KEY `guide_entrytypes_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_entrytypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `guide_entrytypes_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `guide_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,63,'Homepage','homepage',1,'Title',NULL,1,'2017-06-05 15:46:30','2017-06-06 16:50:53','1593af02-3142-424b-9823-81bafda6fcd3'),
	(3,3,95,'Gears','gears',1,'Title',NULL,1,'2017-06-05 15:47:44','2017-06-06 18:14:23','74f5b4b1-f187-4b83-9148-5d70588c358a'),
	(4,4,92,'Cities','cities',1,'City Name',NULL,1,'2017-06-05 15:48:17','2017-06-06 18:12:49','317d2629-c992-44e0-b45b-25563e7ba434'),
	(5,5,97,'Neighborhoods','neighborhoods',1,'Title',NULL,1,'2017-06-05 15:48:51','2017-06-06 18:15:02','15b0c54d-9461-4b56-b741-3cde5fd41af8'),
	(6,6,94,'Food places','foodPlaces',1,'Title',NULL,1,'2017-06-05 16:45:52','2017-06-06 18:13:49','70b3dead-e6cb-44f1-b2f8-362f558d7f23'),
	(7,7,93,'Drink places','drinkPlaces',1,'Title',NULL,1,'2017-06-05 16:46:19','2017-06-06 18:13:27','80df6abe-9951-485b-b05d-53352015a45c'),
	(8,8,98,'Working places','workingPlaces',1,'Title',NULL,1,'2017-06-05 16:47:19','2017-06-06 18:15:19','a2f6103a-38ff-43e7-acff-4a2c70544f5e'),
	(9,9,96,'Living places','livingPlaces',1,'Title',NULL,1,'2017-06-05 16:47:56','2017-06-06 18:14:42','07e42a4f-06a6-4b8e-9c5c-40558158f701');



# Affichage de la table guide_entryversions
# ------------------------------------------------------------


CREATE TABLE `guide_entryversions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entryId` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `num` smallint(6) unsigned NOT NULL,
  `notes` tinytext COLLATE utf8_unicode_ci,
  `data` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_entryversions_entryId_locale_idx` (`entryId`,`locale`),
  KEY `guide_entryversions_sectionId_fk` (`sectionId`),
  KEY `guide_entryversions_creatorId_fk` (`creatorId`),
  KEY `guide_entryversions_locale_fk` (`locale`),
  CONSTRAINT `guide_entryversions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `guide_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `guide_entryversions_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `guide_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_entryversions_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `guide_entryversions_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `guide_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,2,1,1,'en',1,NULL,'{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":[]}','2017-06-05 15:46:31','2017-06-05 15:46:31','50cd044a-c732-43e6-a463-f5b5d9250e76'),
	(2,2,1,1,'en',2,NULL,'{\"typeId\":null,\"authorId\":null,\"title\":\"Welcome to Wanderbrief-guides.local!\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":\"1\",\"parentId\":null,\"fields\":{\"1\":\"<p>It\\u2019s true, this site doesn\\u2019t have a whole lot of content yet, but don\\u2019t worry. Our web developers have just installed the CMS, and they\\u2019re setting things up for the content editors this very moment. Soon Wanderbrief-guides.local will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\"}}','2017-06-05 15:46:31','2017-06-05 15:46:31','b244cfd3-0bd7-4266-9f4f-e451ae6a43f3'),
	(4,4,4,1,'en',1,'','{\"typeId\":null,\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691078,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"38\":\"\",\"35\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"1\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":\"\",\"18\":\"1\",\"17\":\"1\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"16\":\"1\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-05 19:31:19','2017-06-05 19:31:19','b3fb9cef-bd89-426c-8f63-0c988667768a'),
	(5,5,5,1,'en',1,'','{\"typeId\":null,\"authorId\":\"1\",\"title\":\"Noord\",\"slug\":\"noord\",\"postDate\":1496691641,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"40\":[\"4\"],\"35\":\"\",\"8\":\"\",\"6\":\"\",\"12\":\"\",\"11\":\"\",\"39\":\"\",\"4\":\"\",\"41\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-05 19:40:41','2017-06-05 19:40:41','66b20616-591d-4764-a1a4-60fb3673ca36'),
	(6,4,4,1,'en',2,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"38\":\"\",\"35\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"1\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"1\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"16\":\"1\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-05 19:41:37','2017-06-05 19:41:37','e1e7bc78-ca94-4962-97e3-14a7e3c6bc09'),
	(7,2,1,1,'en',3,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":\"\",\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"\",\"11\":\"Wanderbrief CityGuides | Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 14:38:38','2017-06-06 14:38:38','3de33b94-1357-42f7-8c32-3045f5434bb9'),
	(8,2,1,1,'en',4,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":\"\",\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.\",\"11\":\"Wanderbrief CityGuides | Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 14:39:01','2017-06-06 14:39:01','8cbe3db9-6b8d-4c4b-a6fc-a1698eefd9bd'),
	(9,2,1,1,'en',5,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":[\"6\"],\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.\",\"11\":\"Wanderbrief CityGuides | Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 14:50:20','2017-06-06 14:50:20','f6956b1f-1078-444d-a25b-1aad8b9b01f9'),
	(10,2,1,1,'en',6,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":[\"6\"],\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.\",\"11\":\"Wanderbrief CityGuides \\u2014 Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 14:57:34','2017-06-06 14:57:34','0a1951dc-dc0f-4949-ada7-43c104d4098a'),
	(11,2,1,1,'en',7,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":[\"6\"],\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.\",\"11\":\"Wanderbrief CityGuides  \\u2014  Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 15:02:54','2017-06-06 15:02:54','6e95d7f6-d625-4667-b96a-e63140cd2261'),
	(12,2,1,1,'en',8,'','{\"typeId\":null,\"authorId\":null,\"title\":\"Home\",\"slug\":\"homepage\",\"postDate\":1496677590,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"59\":[\"4\"],\"35\":[\"6\"],\"8\":\"\",\"6\":\"\",\"60\":\"\",\"12\":\"Wanderbrief City Guides help you plan the perfect remote working trip with information on the best coffee, internet speed, co-working spaces, local adventures and meetups with like-minded nomads across the city.\",\"11\":\"Wanderbrief CityGuides \\u2014 Curated by local nomads.\",\"39\":\"\",\"7\":\"\"}}','2017-06-06 15:03:13','2017-06-06 15:03:13','895f7927-b125-465d-a261-7eba8ac48db2'),
	(13,4,4,1,'en',3,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"\",\"73\":\"\",\"71\":\"\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"76\":{\"date\":\"\",\"time\":\"\"},\"75\":{\"date\":\"\",\"time\":\"\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 17:40:34','2017-06-06 17:40:34','c129a1aa-4de5-4e38-b696-5690a12eea04'),
	(14,4,4,1,'en',4,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"76\":{\"date\":\"\",\"time\":\"\"},\"75\":{\"date\":\"\",\"time\":\"\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 17:59:03','2017-06-06 17:59:03','a073a2a2-8b2d-496d-8f32-93e32cb0f82f'),
	(15,4,4,1,'en',5,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"77\":\"1\",\"76\":{\"date\":\"\",\"time\":\"\"},\"75\":{\"date\":\"\",\"time\":\"\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 18:01:58','2017-06-06 18:01:58','a475a7da-9a52-4aed-ac7d-a33a0856bd9a'),
	(16,4,4,1,'en',6,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"77\":\"1\",\"76\":{\"date\":\"6\\/14\\/2017\",\"time\":\"12:00 AM\"},\"75\":{\"date\":\"6\\/7\\/2017\",\"time\":\"12:00 AM\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 18:05:43','2017-06-06 18:05:43','74ae4105-f842-4fc2-9895-3a6e069dd35d'),
	(17,4,4,1,'en',7,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"77\":\"1\",\"76\":{\"date\":\"6\\/18\\/2017\",\"time\":\"12:00 AM\"},\"75\":{\"date\":\"6\\/4\\/2017\",\"time\":\"12:00 AM\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 18:06:05','2017-06-06 18:06:05','77f2449c-d418-4e1a-9e96-37acb8944be0'),
	(18,4,4,1,'en',8,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"77\":\"\",\"76\":{\"date\":\"6\\/18\\/2017\",\"time\":\"12:00 AM\"},\"75\":{\"date\":\"6\\/4\\/2017\",\"time\":\"12:00 AM\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 18:06:19','2017-06-06 18:06:19','35d1e575-43f5-4b0f-b658-53cffd39d180'),
	(19,4,4,1,'en',9,'','{\"typeId\":\"4\",\"authorId\":\"1\",\"title\":\"Amsterdam\",\"slug\":\"amsterdam\",\"postDate\":1496691060,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":{\"20\":\"\",\"72\":\"http:\\/\\/www.iamsterdam.com\\/fr\\/visiter\",\"73\":\"\",\"71\":\"iamsterdam\",\"74\":\"\",\"38\":\"\",\"62\":\"\",\"8\":\"\",\"6\":\"\",\"15\":\"high\",\"14\":\"\",\"12\":\"\",\"11\":\"\",\"10\":[\"5\"],\"18\":\"1\",\"17\":\"low\",\"64\":\"0\",\"29\":\"\",\"30\":\"\",\"24\":\"\",\"25\":\"\",\"32\":\"\",\"31\":\"\",\"23\":\"\",\"21\":\"\",\"27\":\"\",\"33\":\"\",\"28\":\"\",\"26\":\"\",\"22\":\"\",\"37\":\"\",\"77\":\"1\",\"76\":{\"date\":\"6\\/18\\/2017\",\"time\":\"12:00 AM\"},\"75\":{\"date\":\"6\\/4\\/2017\",\"time\":\"12:00 AM\"},\"16\":\"medium\",\"4\":\"<p>With world-class museums, quirky festivals, theatre, live music, laid-back bars and delightful restaurants, there\'s never a shortage of things to do in Amsterdam!<\\/p>\",\"42\":\"\",\"19\":\"\",\"36\":[{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}],\"7\":\"\"}}','2017-06-06 18:06:43','2017-06-06 18:06:43','347f76f8-9bfa-4c68-ac53-9fe1a158e6c0');



# Affichage de la table guide_fieldgroups
# ------------------------------------------------------------


CREATE TABLE `guide_fieldgroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_fieldgroups_name_unq_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_fieldgroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Default','2017-06-05 15:46:30','2017-06-05 15:46:30','6ab17dd5-ff1a-4115-921e-c603db8acd04'),
	(2,'Places','2017-06-05 16:51:39','2017-06-05 16:51:39','6f3e4a68-c977-4eee-ba2c-556a570ac365'),
	(3,'Gears','2017-06-05 16:51:43','2017-06-05 16:51:43','832e52c3-9c53-4926-ae34-019e3c120240'),
	(4,'Cities','2017-06-05 16:51:47','2017-06-05 16:51:47','f1085199-0e72-4447-ac35-c6b73bd7e6b8'),
	(5,'SEO','2017-06-05 16:51:53','2017-06-05 16:51:53','bf00813e-cd01-4d9b-83e1-84cfba787e68'),
	(6,'Neighborhoods','2017-06-05 18:46:18','2017-06-05 18:46:18','64c139e5-68b2-4ceb-88a5-a9581007e94a'),
	(7,'Promoting','2017-06-06 16:55:04','2017-06-06 16:55:04','07135597-b728-406a-a399-eba35feb1a3c');



# Affichage de la table guide_fieldlayoutfields
# ------------------------------------------------------------


CREATE TABLE `guide_fieldlayoutfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `tabId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `required` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_fieldlayoutfields_layoutId_fieldId_unq_idx` (`layoutId`,`fieldId`),
  KEY `guide_fieldlayoutfields_sortOrder_idx` (`sortOrder`),
  KEY `guide_fieldlayoutfields_tabId_fk` (`tabId`),
  KEY `guide_fieldlayoutfields_fieldId_fk` (`fieldId`),
  CONSTRAINT `guide_fieldlayoutfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `guide_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_fieldlayoutfields_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_fieldlayoutfields_tabId_fk` FOREIGN KEY (`tabId`) REFERENCES `guide_fieldlayouttabs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_fieldlayoutfields` (`id`, `layoutId`, `tabId`, `fieldId`, `required`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(232,31,59,1,0,1,'2017-06-05 18:50:32','2017-06-05 18:50:32','98f67543-0084-4632-bfea-441f7347cfbf'),
	(233,31,59,34,0,2,'2017-06-05 18:50:32','2017-06-05 18:50:32','c930efb3-381f-40e7-8a87-cbf1c74fcd22'),
	(234,31,59,43,0,3,'2017-06-05 18:50:32','2017-06-05 18:50:32','c6d6bb12-9f0e-44d3-bf89-a34d8d4ce6f0'),
	(235,32,60,1,0,1,'2017-06-05 18:50:43','2017-06-05 18:50:43','4924b93c-7a84-4fe3-9a67-678d26f74fde'),
	(236,32,60,34,0,2,'2017-06-05 18:50:43','2017-06-05 18:50:43','12bc27ca-4e53-43cf-ac5f-ce5d778366dd'),
	(237,32,60,43,0,3,'2017-06-05 18:50:43','2017-06-05 18:50:43','bd24d5ef-f8a5-4a1f-ae77-c7e7e452f02e'),
	(238,33,61,1,0,1,'2017-06-05 18:50:51','2017-06-05 18:50:51','b4921805-5c38-471b-9cff-63ca8a28318f'),
	(239,33,61,34,0,2,'2017-06-05 18:50:51','2017-06-05 18:50:51','a87516b1-a5dc-47f2-95c9-4294868b0a88'),
	(240,33,61,43,0,3,'2017-06-05 18:50:51','2017-06-05 18:50:51','9064311c-f3d6-482f-a49e-f40fcd42e10e'),
	(241,34,62,1,0,1,'2017-06-05 18:51:04','2017-06-05 18:51:04','b4755bf4-7201-4dd3-a1ce-0c87a4d5b8ae'),
	(242,34,62,34,0,2,'2017-06-05 18:51:04','2017-06-05 18:51:04','0a881afe-919a-456e-9ce7-55e8c7fdeba4'),
	(243,34,62,43,0,3,'2017-06-05 18:51:04','2017-06-05 18:51:04','177aa7e6-6b5a-44e9-8a87-a525a511ef6c'),
	(662,63,197,65,0,1,'2017-06-06 16:50:53','2017-06-06 16:50:53','3c246bef-bd5e-499e-8dad-f61795799e74'),
	(663,63,197,59,0,2,'2017-06-06 16:50:53','2017-06-06 16:50:53','c4394290-92b7-4951-8605-191d865daf3f'),
	(664,63,198,6,0,1,'2017-06-06 16:50:53','2017-06-06 16:50:53','f2032b99-29c7-4cbb-b42c-be40f72d6423'),
	(665,63,198,8,0,2,'2017-06-06 16:50:53','2017-06-06 16:50:53','53da07df-e8cf-415c-8f62-c842ca373573'),
	(666,63,198,7,0,3,'2017-06-06 16:50:53','2017-06-06 16:50:53','f4c23152-c630-40b3-aefd-e3b878d2463f'),
	(667,63,199,60,0,1,'2017-06-06 16:50:53','2017-06-06 16:50:53','545af6bf-22a6-46d3-a76c-8029a1c6cae3'),
	(668,63,200,67,0,1,'2017-06-06 16:50:53','2017-06-06 16:50:53','788124e1-0ae3-4775-9d17-e1ca5929acad'),
	(669,63,200,68,0,2,'2017-06-06 16:50:53','2017-06-06 16:50:53','c8407b5f-7272-4d3a-8457-02d7432303af'),
	(670,63,200,69,0,3,'2017-06-06 16:50:53','2017-06-06 16:50:53','96c01a42-e6e0-4385-9e94-ac48bc501f01'),
	(671,63,201,11,0,1,'2017-06-06 16:50:53','2017-06-06 16:50:53','ff82e8e8-73fb-45ce-b104-74e223d1234f'),
	(672,63,201,12,0,2,'2017-06-06 16:50:53','2017-06-06 16:50:53','70334b1b-1604-435e-8c95-d93c88b32c32'),
	(673,63,201,39,0,3,'2017-06-06 16:50:53','2017-06-06 16:50:53','1f253b42-d828-4f17-8e17-b33f147ce3df'),
	(1332,92,377,62,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','92e701fb-4127-48d4-9e6f-7e1c13f5eece'),
	(1333,92,377,4,1,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','666f98c4-3eff-47d2-b9d7-4091ee961f37'),
	(1334,92,377,37,0,3,'2017-06-06 18:12:49','2017-06-06 18:12:49','9c11f82c-4366-4273-9fb0-7299b7c10ddd'),
	(1335,92,377,38,0,4,'2017-06-06 18:12:49','2017-06-06 18:12:49','3df9f566-0e06-4a87-ba6b-775af18cb763'),
	(1336,92,377,10,0,5,'2017-06-06 18:12:49','2017-06-06 18:12:49','fc46d6b2-683c-4adf-b8f9-6061246909fc'),
	(1337,92,377,64,0,6,'2017-06-06 18:12:49','2017-06-06 18:12:49','ad158306-8014-43fe-8106-437054c4aa70'),
	(1338,92,378,14,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','d4659944-3cc9-4ecb-842e-aaa25e404760'),
	(1339,92,378,18,0,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','bd89e862-282f-4742-b913-1c4c057f2558'),
	(1340,92,378,15,0,3,'2017-06-06 18:12:49','2017-06-06 18:12:49','62e7d085-e28f-4d17-a396-b1fff845f046'),
	(1341,92,378,16,0,4,'2017-06-06 18:12:49','2017-06-06 18:12:49','b689afc1-dbb2-4221-bc1e-d4e06b653383'),
	(1342,92,378,17,0,5,'2017-06-06 18:12:49','2017-06-06 18:12:49','a3c23c3b-8a68-4fd3-bed5-3da5ec471976'),
	(1343,92,379,22,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','d86a1e68-7f3a-4d50-a2cf-126c30d9deae'),
	(1344,92,379,21,0,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','bafd221e-7d3e-45b7-89ff-a470ef9753a2'),
	(1345,92,379,23,0,3,'2017-06-06 18:12:49','2017-06-06 18:12:49','581292e9-534b-4758-807c-10cfd1f91f69'),
	(1346,92,379,24,0,4,'2017-06-06 18:12:49','2017-06-06 18:12:49','c850b1fe-2df6-4949-8e7d-0af277321ee6'),
	(1347,92,379,25,0,5,'2017-06-06 18:12:49','2017-06-06 18:12:49','c8f4859b-d80e-42c6-b385-b46305d40ace'),
	(1348,92,379,26,0,6,'2017-06-06 18:12:49','2017-06-06 18:12:49','0576134c-69ca-4daa-b357-a632f7bf0af4'),
	(1349,92,379,27,0,7,'2017-06-06 18:12:49','2017-06-06 18:12:49','19b54a66-f6c4-45bc-95e9-dc966c19cb47'),
	(1350,92,379,28,0,8,'2017-06-06 18:12:49','2017-06-06 18:12:49','55f481aa-ba09-4d73-b3a9-23d3c73a9714'),
	(1351,92,379,19,0,9,'2017-06-06 18:12:49','2017-06-06 18:12:49','c85c8137-7e27-42b9-96d8-db396731f80e'),
	(1352,92,379,29,0,10,'2017-06-06 18:12:49','2017-06-06 18:12:49','d3bd67b2-749d-4d72-a7bc-e3c26dd09805'),
	(1353,92,379,30,0,11,'2017-06-06 18:12:49','2017-06-06 18:12:49','f92ce1f1-7cde-4b73-a83f-66410309ae8b'),
	(1354,92,379,20,0,12,'2017-06-06 18:12:49','2017-06-06 18:12:49','f1b8e0f2-c354-48cb-a3f0-723ea9ee3060'),
	(1355,92,379,32,0,13,'2017-06-06 18:12:49','2017-06-06 18:12:49','3189cca8-4266-4b72-9cda-05b2cbad7d5f'),
	(1356,92,379,31,0,14,'2017-06-06 18:12:49','2017-06-06 18:12:49','7ab83927-70cf-4b15-8069-a96d407ecb39'),
	(1357,92,379,33,0,15,'2017-06-06 18:12:49','2017-06-06 18:12:49','32313a93-8701-4a96-a7a7-ae2a6bc3a159'),
	(1358,92,380,6,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','3a0ed05a-c851-4d11-b5dc-c2029b9f86b7'),
	(1359,92,380,8,0,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','9faf64ed-2016-44ce-b29b-e19831037c34'),
	(1360,92,380,7,0,3,'2017-06-06 18:12:49','2017-06-06 18:12:49','db684c02-9dee-4394-bf9a-05e5ed105bfa'),
	(1361,92,381,42,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','4dc6e6d9-d936-4a3c-a0a3-667a0ec1d7cc'),
	(1362,92,382,77,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','e935047e-6882-43db-a30f-0d8eebf4a413'),
	(1363,92,382,71,0,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','436edc0e-9d1e-4b2c-a34f-bb5e7ca3717d'),
	(1364,92,382,73,0,3,'2017-06-06 18:12:49','2017-06-06 18:12:49','952f4674-c030-465f-af99-737f17702f0b'),
	(1365,92,382,78,0,4,'2017-06-06 18:12:49','2017-06-06 18:12:49','21276e2c-99ea-4c3d-89bd-626aef0e3589'),
	(1366,92,382,74,0,5,'2017-06-06 18:12:49','2017-06-06 18:12:49','4a98ec44-787b-4aa1-9bd8-2a016d090aae'),
	(1367,92,382,72,0,6,'2017-06-06 18:12:49','2017-06-06 18:12:49','a8df6b31-7357-4f2c-aebf-69b88e085d4b'),
	(1368,92,382,75,0,7,'2017-06-06 18:12:49','2017-06-06 18:12:49','f03b2084-ee15-4cf5-92f1-59468b0f94cd'),
	(1369,92,382,76,0,8,'2017-06-06 18:12:49','2017-06-06 18:12:49','547e59ed-cfa4-4ee5-ba47-ef11122a699c'),
	(1370,92,383,36,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','c2ebfb8e-c0e2-4a94-baf7-1bc85199648a'),
	(1371,92,384,11,0,1,'2017-06-06 18:12:49','2017-06-06 18:12:49','9f4f18fe-7d7a-4cb0-bcac-f7e8026dcd87'),
	(1372,92,384,12,0,2,'2017-06-06 18:12:49','2017-06-06 18:12:49','850a2721-062e-45c2-a152-835f26622134'),
	(1373,93,385,4,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','55215d03-2b5d-4b23-88b2-cbc3a7cd6e8e'),
	(1374,93,385,49,0,2,'2017-06-06 18:13:27','2017-06-06 18:13:27','958ca819-c3a2-43b2-94ff-3b51023ba3a7'),
	(1375,93,385,61,0,3,'2017-06-06 18:13:27','2017-06-06 18:13:27','29b32f4e-d584-4c8f-9d85-7ff54dca4d20'),
	(1376,93,385,57,0,4,'2017-06-06 18:13:27','2017-06-06 18:13:27','b6c4953b-831e-418c-b10a-fff2c88ce80f'),
	(1377,93,385,34,0,5,'2017-06-06 18:13:27','2017-06-06 18:13:27','883b072e-dc7f-43f0-8c6f-65597ea661ea'),
	(1378,93,386,50,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','633c636f-6dab-4b3a-962c-d4cfdce3b242'),
	(1379,93,386,47,0,2,'2017-06-06 18:13:27','2017-06-06 18:13:27','67be4b39-b0e9-4956-88e8-645c9a7378f4'),
	(1380,93,386,48,0,3,'2017-06-06 18:13:27','2017-06-06 18:13:27','da4f78a3-4320-4071-8818-9bcb89bd7841'),
	(1381,93,387,56,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','02eb132b-2d2e-42a7-9c7a-e8d8f2fc1330'),
	(1382,93,387,52,0,2,'2017-06-06 18:13:27','2017-06-06 18:13:27','09f7d97f-9292-4651-8a10-10e0e708a43e'),
	(1383,93,387,53,0,3,'2017-06-06 18:13:27','2017-06-06 18:13:27','5c7410cf-4619-402f-8a74-a9a059d90c38'),
	(1384,93,387,54,0,4,'2017-06-06 18:13:27','2017-06-06 18:13:27','c7beae78-6ea1-404d-a2aa-e3edf8583a0b'),
	(1385,93,387,55,0,5,'2017-06-06 18:13:27','2017-06-06 18:13:27','827e1b57-27b9-4ab0-8c3b-bcb897f9ce74'),
	(1386,93,388,58,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','70d1edb0-d66f-4b09-9f32-17c254db7415'),
	(1387,93,389,77,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','4bf03993-3f39-4e89-a6fe-87f616bcd2a3'),
	(1388,93,389,71,0,2,'2017-06-06 18:13:27','2017-06-06 18:13:27','984746d7-9807-4fc9-b825-661e379e1c1d'),
	(1389,93,389,73,0,3,'2017-06-06 18:13:27','2017-06-06 18:13:27','c8f6e37e-e43a-44de-874a-c6ae83023320'),
	(1390,93,389,78,0,4,'2017-06-06 18:13:27','2017-06-06 18:13:27','7acb6075-2957-4156-b191-11e8a044a209'),
	(1391,93,389,74,0,5,'2017-06-06 18:13:27','2017-06-06 18:13:27','eb5d4837-2e35-47e4-83b4-99a790cdf096'),
	(1392,93,389,72,0,6,'2017-06-06 18:13:27','2017-06-06 18:13:27','716a59cf-dc60-4157-a72d-665ec13c5b2d'),
	(1393,93,389,75,0,7,'2017-06-06 18:13:27','2017-06-06 18:13:27','a6305861-0836-41a1-b317-67f192511c97'),
	(1394,93,389,76,0,8,'2017-06-06 18:13:27','2017-06-06 18:13:27','a6a2b52f-5bc7-4547-b768-cfbd221e01e0'),
	(1395,93,390,36,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','9551b782-9432-444e-9c18-3fd704640b1a'),
	(1396,93,391,11,0,1,'2017-06-06 18:13:27','2017-06-06 18:13:27','5fa601e2-27ab-4ec8-95c3-e9a6d82e8afe'),
	(1397,93,391,12,0,2,'2017-06-06 18:13:27','2017-06-06 18:13:27','8adbefdd-6456-4906-8902-d5c4af08ad73'),
	(1398,93,391,39,0,3,'2017-06-06 18:13:27','2017-06-06 18:13:27','693a2d62-5e13-438f-b542-9aa45b6ffbbd'),
	(1399,94,392,4,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','bc157b9d-a077-4095-8f05-911aa89eedae'),
	(1400,94,392,49,0,2,'2017-06-06 18:13:49','2017-06-06 18:13:49','54fc31c8-70bf-4925-892e-c49abafe6dbf'),
	(1401,94,392,61,0,3,'2017-06-06 18:13:49','2017-06-06 18:13:49','d6016f93-ee25-4dab-a8bb-57187c75d232'),
	(1402,94,392,57,0,4,'2017-06-06 18:13:49','2017-06-06 18:13:49','c3467584-45f0-43be-8fdf-4e55a92e7e9b'),
	(1403,94,392,34,0,5,'2017-06-06 18:13:49','2017-06-06 18:13:49','7c5e9684-d369-42b4-b888-ee8b5f390a60'),
	(1404,94,393,50,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','5640c21a-be91-4443-8ae3-45efff29d8c9'),
	(1405,94,393,48,0,2,'2017-06-06 18:13:49','2017-06-06 18:13:49','049a0a9e-5f77-4e3e-b6be-c8ec26c41f15'),
	(1406,94,393,47,0,3,'2017-06-06 18:13:49','2017-06-06 18:13:49','4d3305a0-92aa-4bf6-97e5-a134d888cef5'),
	(1407,94,393,51,0,4,'2017-06-06 18:13:49','2017-06-06 18:13:49','4df8f05e-e629-4e1e-a3e0-083be0cf5c7e'),
	(1408,94,394,56,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','347879c5-2a4f-4ed1-b1a1-03018b9aa2c9'),
	(1409,94,394,52,0,2,'2017-06-06 18:13:49','2017-06-06 18:13:49','43d9be7c-9fab-4aa0-8b07-adaf0b8fd448'),
	(1410,94,394,53,0,3,'2017-06-06 18:13:49','2017-06-06 18:13:49','81a7e7e9-4d08-40a2-ba54-ee06e7952cde'),
	(1411,94,394,54,0,4,'2017-06-06 18:13:49','2017-06-06 18:13:49','0387b3c6-f995-4764-8fc8-ec4c853bbf61'),
	(1412,94,394,55,0,5,'2017-06-06 18:13:49','2017-06-06 18:13:49','ab4333eb-762b-4d8e-8d45-4585edda987b'),
	(1413,94,395,58,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','7e06e4a2-1642-4f00-9697-83a2d22b775e'),
	(1414,94,396,77,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','17440209-34ec-4013-9fe3-b4f5899fb5a5'),
	(1415,94,396,71,0,2,'2017-06-06 18:13:49','2017-06-06 18:13:49','8603cebb-7056-42d9-9902-258dace3fd3a'),
	(1416,94,396,73,0,3,'2017-06-06 18:13:49','2017-06-06 18:13:49','d0f04033-9a24-4129-8e97-80d6c184aed1'),
	(1417,94,396,78,0,4,'2017-06-06 18:13:49','2017-06-06 18:13:49','666888ac-baa2-4c49-aaa8-42471fa1954a'),
	(1418,94,396,74,0,5,'2017-06-06 18:13:49','2017-06-06 18:13:49','7669a8ab-e225-4128-be71-04a413de8e8d'),
	(1419,94,396,72,0,6,'2017-06-06 18:13:49','2017-06-06 18:13:49','37844843-40ab-4fb3-8619-6775c4890a6c'),
	(1420,94,396,75,0,7,'2017-06-06 18:13:49','2017-06-06 18:13:49','75ad11a0-e2f5-4101-b9f3-4037923668ef'),
	(1421,94,396,76,0,8,'2017-06-06 18:13:49','2017-06-06 18:13:49','04aab53f-e107-4db4-8105-714daa374035'),
	(1422,94,397,36,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','5255dfb3-a1bb-4f69-996b-9bf8ef916ba1'),
	(1423,94,398,11,0,1,'2017-06-06 18:13:49','2017-06-06 18:13:49','712c2808-39d6-40f3-bcdc-6ee3db6e1f82'),
	(1424,94,398,12,0,2,'2017-06-06 18:13:49','2017-06-06 18:13:49','eccea09b-b38e-4bc5-b976-82b385198384'),
	(1425,94,398,39,0,3,'2017-06-06 18:13:49','2017-06-06 18:13:49','b630ae4f-6e12-44e4-afb2-94ed7d60633e'),
	(1426,95,399,4,0,1,'2017-06-06 18:14:23','2017-06-06 18:14:23','cfa4699f-44bf-4711-a4df-62fff454b670'),
	(1427,95,399,46,0,2,'2017-06-06 18:14:23','2017-06-06 18:14:23','98808db5-4242-48d7-bf8c-6c85f8239577'),
	(1428,95,399,45,0,3,'2017-06-06 18:14:23','2017-06-06 18:14:23','fb4fa73b-8e1e-4596-99f4-3c4f00cd208d'),
	(1429,95,399,44,0,4,'2017-06-06 18:14:23','2017-06-06 18:14:23','a1ab64aa-98d4-4fa7-b3aa-a6189fc6240d'),
	(1430,95,399,63,0,5,'2017-06-06 18:14:23','2017-06-06 18:14:23','3e202b9c-5020-455f-b813-5be905dd8c92'),
	(1431,95,399,64,0,6,'2017-06-06 18:14:23','2017-06-06 18:14:23','7955fe64-d4cc-4e8f-8864-74b35fddf73f'),
	(1432,95,400,77,0,1,'2017-06-06 18:14:23','2017-06-06 18:14:23','e8dd4872-706d-4359-8aad-d1637c0d4ee3'),
	(1433,95,400,71,0,2,'2017-06-06 18:14:23','2017-06-06 18:14:23','8161d6c7-369e-4c2e-8fa7-9869177fe851'),
	(1434,95,400,73,0,3,'2017-06-06 18:14:23','2017-06-06 18:14:23','3d7183f0-1779-4aa4-8bdf-0bc4aff629f2'),
	(1435,95,400,78,0,4,'2017-06-06 18:14:23','2017-06-06 18:14:23','d763f07b-5e81-43e2-83c7-d9bde0cd531a'),
	(1436,95,400,74,0,5,'2017-06-06 18:14:23','2017-06-06 18:14:23','bcbab08d-b1a3-4619-b4fa-116a34a9b6b2'),
	(1437,95,400,72,0,6,'2017-06-06 18:14:23','2017-06-06 18:14:23','86c723ab-fc31-47d3-aa92-507cea36c888'),
	(1438,95,400,75,0,7,'2017-06-06 18:14:23','2017-06-06 18:14:23','49fff0a8-3a07-4856-8013-f80dccdd0dc3'),
	(1439,95,400,76,0,8,'2017-06-06 18:14:23','2017-06-06 18:14:23','c74a1e80-11bd-418f-bdf9-04275f8eb333'),
	(1440,96,401,4,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','b002086c-b8ff-4dde-a77d-3d1fa0d37de6'),
	(1441,96,401,49,0,2,'2017-06-06 18:14:42','2017-06-06 18:14:42','1173afa3-b093-4621-97fa-db6cf4b1a8b0'),
	(1442,96,401,61,0,3,'2017-06-06 18:14:42','2017-06-06 18:14:42','1cf0eaa6-2578-45d5-8ee0-957ed97ab2d1'),
	(1443,96,401,57,0,4,'2017-06-06 18:14:42','2017-06-06 18:14:42','143f3a19-e791-44d4-aa2f-b796d822548e'),
	(1444,96,401,34,0,5,'2017-06-06 18:14:42','2017-06-06 18:14:42','4027ec1f-5d4d-4f71-b449-f3a0dba1f5da'),
	(1445,96,402,50,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','dcf50a82-201c-4cfd-bb59-379754467930'),
	(1446,96,402,47,0,2,'2017-06-06 18:14:42','2017-06-06 18:14:42','83f87bbd-0236-4d5c-ba47-051f451af3b2'),
	(1447,96,402,48,0,3,'2017-06-06 18:14:42','2017-06-06 18:14:42','9c037cd3-99c2-40a7-8ab7-ce419c50c2e3'),
	(1448,96,402,14,0,4,'2017-06-06 18:14:42','2017-06-06 18:14:42','f3acfc32-7223-4d21-9d6f-b2d415f9975b'),
	(1449,96,403,56,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','65cdf7c8-b34f-43ad-9f6e-95627bf2bed2'),
	(1450,96,403,52,0,2,'2017-06-06 18:14:42','2017-06-06 18:14:42','62682226-d8fe-4047-9474-79fd4e0a7437'),
	(1451,96,403,53,0,3,'2017-06-06 18:14:42','2017-06-06 18:14:42','e7b4c358-d234-4151-ae74-e16b70b92bc2'),
	(1452,96,403,54,0,4,'2017-06-06 18:14:42','2017-06-06 18:14:42','9ec55b98-cd97-4fc3-ac42-1c43ec9599f0'),
	(1453,96,403,55,0,5,'2017-06-06 18:14:42','2017-06-06 18:14:42','97805ad6-74d4-469f-8648-d16688032645'),
	(1454,96,404,58,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','9dbf0abe-666b-4904-bedc-08bdf31ddf41'),
	(1455,96,405,77,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','37d63f29-7656-4585-a40d-60f9291fc2c8'),
	(1456,96,405,71,0,2,'2017-06-06 18:14:42','2017-06-06 18:14:42','1a4559ef-c975-4e39-9f4a-b19931965841'),
	(1457,96,405,73,0,3,'2017-06-06 18:14:42','2017-06-06 18:14:42','7f73e0a7-5627-4344-9cda-d60561cdbac9'),
	(1458,96,405,78,0,4,'2017-06-06 18:14:42','2017-06-06 18:14:42','f1653463-adf6-46cf-8f19-d80fcb33b5d7'),
	(1459,96,405,74,0,5,'2017-06-06 18:14:42','2017-06-06 18:14:42','92fe6405-ec64-4dd6-90d4-a0a7e8a67c03'),
	(1460,96,405,72,0,6,'2017-06-06 18:14:42','2017-06-06 18:14:42','0abe3266-e373-42e6-a1af-3185039fa589'),
	(1461,96,405,75,0,7,'2017-06-06 18:14:42','2017-06-06 18:14:42','3bee65c4-7fb8-4763-aac2-b3b892d8b922'),
	(1462,96,405,76,0,8,'2017-06-06 18:14:42','2017-06-06 18:14:42','8d06b37b-2197-4e95-9104-a43a9aee3c36'),
	(1463,96,406,36,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','7149af75-6682-406b-bbd1-ef1d057cabd0'),
	(1464,96,407,11,0,1,'2017-06-06 18:14:42','2017-06-06 18:14:42','ee154698-0823-43c9-aae2-09cfaf13e579'),
	(1465,96,407,12,0,2,'2017-06-06 18:14:42','2017-06-06 18:14:42','19ce8976-eb66-4e49-8147-e8e584d222f8'),
	(1466,96,407,39,0,3,'2017-06-06 18:14:42','2017-06-06 18:14:42','c4ff2d07-4707-45d7-bd60-9c74f45694c0'),
	(1467,97,408,35,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','332635d6-d69f-46b6-931e-36f0342bc50d'),
	(1468,97,408,4,0,2,'2017-06-06 18:15:02','2017-06-06 18:15:02','7788ed75-2d3c-4344-9e6c-8296d5b98ad0'),
	(1469,97,408,40,1,3,'2017-06-06 18:15:02','2017-06-06 18:15:02','d2107ce7-00d0-4303-97f5-548cacb01dd5'),
	(1470,97,409,6,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','609fca30-9a42-49c5-82bb-30206785da70'),
	(1471,97,409,8,0,2,'2017-06-06 18:15:02','2017-06-06 18:15:02','7d5713cb-c5ac-4dec-9be6-8882a20d52a7'),
	(1472,97,409,7,0,3,'2017-06-06 18:15:02','2017-06-06 18:15:02','3442758b-e0f5-4535-a646-8128d5223997'),
	(1473,97,410,41,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','bb6eba5e-b101-4eb8-9c47-8fd866ad390c'),
	(1474,97,411,77,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','b793574f-c20a-4b17-af60-09edda953fa7'),
	(1475,97,411,71,0,2,'2017-06-06 18:15:02','2017-06-06 18:15:02','eb0cc64b-8a0f-447a-aa4e-e6ca853a033e'),
	(1476,97,411,73,0,3,'2017-06-06 18:15:02','2017-06-06 18:15:02','cffe0419-5803-44b9-a6ff-cfe86894dbf5'),
	(1477,97,411,78,0,4,'2017-06-06 18:15:02','2017-06-06 18:15:02','aee3aa4d-417d-424e-ba0b-f1b83d0098aa'),
	(1478,97,411,74,0,5,'2017-06-06 18:15:02','2017-06-06 18:15:02','51589616-5690-4793-8fb3-979a4a79a462'),
	(1479,97,411,72,0,6,'2017-06-06 18:15:02','2017-06-06 18:15:02','dd9b8077-20ec-4062-9172-e82057594e86'),
	(1480,97,411,75,0,7,'2017-06-06 18:15:02','2017-06-06 18:15:02','c33e0c1b-dcad-4127-88e0-c91fc30bfc7c'),
	(1481,97,411,76,0,8,'2017-06-06 18:15:02','2017-06-06 18:15:02','92a76e6b-0a23-48c3-b67e-9806e54bd49b'),
	(1482,97,412,36,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','77c20e53-2782-4a21-a682-ed2a08d42d1d'),
	(1483,97,413,11,0,1,'2017-06-06 18:15:02','2017-06-06 18:15:02','f16db7a4-89f6-4696-912e-bfc636ee815b'),
	(1484,97,413,12,0,2,'2017-06-06 18:15:02','2017-06-06 18:15:02','6abf5f64-69bd-4a2a-b649-0a62b66968b6'),
	(1485,97,413,39,0,3,'2017-06-06 18:15:02','2017-06-06 18:15:02','c67eca29-4c86-443a-aa73-a0aa312885a1'),
	(1486,98,414,4,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','241964e1-0a39-43d4-9aa2-f54b3144ec40'),
	(1487,98,414,49,0,2,'2017-06-06 18:15:19','2017-06-06 18:15:19','6cf1247b-b63b-4fc6-8fc7-f45497844e76'),
	(1488,98,414,61,0,3,'2017-06-06 18:15:19','2017-06-06 18:15:19','9364ff53-81f0-4a98-b5fc-6b5a69ce40e9'),
	(1489,98,414,57,0,4,'2017-06-06 18:15:19','2017-06-06 18:15:19','d9aed854-89c6-4943-9f5d-d90d70059a0c'),
	(1490,98,414,34,0,5,'2017-06-06 18:15:19','2017-06-06 18:15:19','971f0478-b85d-42e3-8fbf-a04297cd200b'),
	(1491,98,415,50,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','919a7804-dd61-449e-a7c7-bfcd9a4ba1fc'),
	(1492,98,415,47,0,2,'2017-06-06 18:15:19','2017-06-06 18:15:19','caba0be1-d3a3-428d-824c-c40734a3eac6'),
	(1493,98,415,48,0,3,'2017-06-06 18:15:19','2017-06-06 18:15:19','be675109-ca14-4205-9c20-744bf9facf46'),
	(1494,98,415,14,0,4,'2017-06-06 18:15:19','2017-06-06 18:15:19','e248f1e2-2873-4c63-be77-a20fc0415014'),
	(1495,98,416,56,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','84016b38-2b61-44b4-aa72-1e5e6ee746a9'),
	(1496,98,416,52,0,2,'2017-06-06 18:15:19','2017-06-06 18:15:19','bfc8b02b-2447-4836-9c09-c0a4f59534f9'),
	(1497,98,416,53,0,3,'2017-06-06 18:15:19','2017-06-06 18:15:19','e0da42a1-a121-4dca-b9c0-24511219583d'),
	(1498,98,416,54,0,4,'2017-06-06 18:15:19','2017-06-06 18:15:19','3cb77843-0d19-4b52-8201-9ce9aebd6b20'),
	(1499,98,416,55,0,5,'2017-06-06 18:15:19','2017-06-06 18:15:19','040426c2-8617-4903-a5a6-cfbc0f0cb217'),
	(1500,98,417,58,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','06cdf9b3-f864-4bc1-8018-e37a10cecf47'),
	(1501,98,418,77,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','f73f474e-1e36-4f8c-aa61-a0299f460736'),
	(1502,98,418,71,0,2,'2017-06-06 18:15:19','2017-06-06 18:15:19','68ee0a25-a32b-46fa-9e9a-709d5df354f8'),
	(1503,98,418,73,0,3,'2017-06-06 18:15:19','2017-06-06 18:15:19','322452f8-bdec-4558-b144-b5ae1ec54f65'),
	(1504,98,418,78,0,4,'2017-06-06 18:15:19','2017-06-06 18:15:19','c293472f-ed98-4e91-8e63-3841463b4112'),
	(1505,98,418,74,0,5,'2017-06-06 18:15:19','2017-06-06 18:15:19','1e85e26c-7f25-485d-9a2c-1be9db3dae7f'),
	(1506,98,418,72,0,6,'2017-06-06 18:15:19','2017-06-06 18:15:19','199e4a66-097e-46a4-9374-1333b6ea1c56'),
	(1507,98,418,75,0,7,'2017-06-06 18:15:19','2017-06-06 18:15:19','33dc3f9e-3a58-4bb4-9ba6-3a69d1317772'),
	(1508,98,418,76,0,8,'2017-06-06 18:15:19','2017-06-06 18:15:19','6f212a67-72bc-4b6a-a3bc-59d36c23db58'),
	(1509,98,419,36,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','b1659cbc-21ec-4861-8d41-b7db83398580'),
	(1510,98,420,11,0,1,'2017-06-06 18:15:19','2017-06-06 18:15:19','a28e9b97-c8af-4f56-9cbc-4c76fa24b86c'),
	(1511,98,420,12,0,2,'2017-06-06 18:15:19','2017-06-06 18:15:19','3122825c-892e-486b-8948-89b832256de7'),
	(1512,98,420,39,0,3,'2017-06-06 18:15:19','2017-06-06 18:15:19','d9b73384-333b-4c64-ab73-db5d824c6eda');



# Affichage de la table guide_fieldlayouts
# ------------------------------------------------------------


CREATE TABLE `guide_fieldlayouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_fieldlayouts_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_fieldlayouts` (`id`, `type`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Tag','2017-06-05 15:46:30','2017-06-05 15:46:30','79710fd3-3c3c-47f3-81ad-872088889657'),
	(28,'Tag','2017-06-05 18:47:55','2017-06-05 18:47:55','25a8ab44-5689-4e07-9b61-b24b3c592ae9'),
	(29,'Tag','2017-06-05 18:48:02','2017-06-05 18:48:02','b86652f1-3b2b-495a-b58a-08268cd9d2cd'),
	(30,'Tag','2017-06-05 18:49:48','2017-06-05 18:49:48','5f259e06-78a2-4bff-99d8-e3b8bf984b06'),
	(31,'Asset','2017-06-05 18:50:32','2017-06-05 18:50:32','677af9b6-04b5-418c-b40a-04aa71b4b4c4'),
	(32,'Asset','2017-06-05 18:50:43','2017-06-05 18:50:43','36fdefc7-d7d2-4390-bcec-818645e796fa'),
	(33,'Asset','2017-06-05 18:50:51','2017-06-05 18:50:51','d614664a-c7bc-4c95-8ee9-4653b3af6d79'),
	(34,'Asset','2017-06-05 18:51:04','2017-06-05 18:51:04','9ef7ed94-7a0e-4e60-806a-8c840073db9f'),
	(37,'Category','2017-06-05 18:56:37','2017-06-05 18:56:37','080a2780-a0c4-47ed-8432-f2d1c6ea743d'),
	(40,'Tag','2017-06-05 19:11:01','2017-06-05 19:11:01','dc5623ce-da57-49d4-83a5-d24263ee0ad8'),
	(63,'Entry','2017-06-06 16:50:53','2017-06-06 16:50:53','527b8393-4406-4fec-b3a0-d6af29c8b876'),
	(64,'Asset','2017-06-06 16:58:12','2017-06-06 16:58:12','0b330daa-60ea-4da5-9f88-0871713e2444'),
	(92,'Entry','2017-06-06 18:12:49','2017-06-06 18:12:49','5f30adcf-1e20-4492-9086-49097e9a38e7'),
	(93,'Entry','2017-06-06 18:13:27','2017-06-06 18:13:27','0b2bdd56-5b04-4623-b125-ca4e47703dbc'),
	(94,'Entry','2017-06-06 18:13:49','2017-06-06 18:13:49','ba82ad40-1f7a-46af-9991-46a748077dff'),
	(95,'Entry','2017-06-06 18:14:23','2017-06-06 18:14:23','fb5f880a-3f5b-4569-ab6d-7e59dc378e3b'),
	(96,'Entry','2017-06-06 18:14:42','2017-06-06 18:14:42','9a77778c-0ac3-4af8-8f46-9e290cf48916'),
	(97,'Entry','2017-06-06 18:15:02','2017-06-06 18:15:02','f0963655-c1aa-4a52-8374-44bd6f1c287a'),
	(98,'Entry','2017-06-06 18:15:19','2017-06-06 18:15:19','4ccd6274-f319-4811-8b89-a3f452915b01');



# Affichage de la table guide_fieldlayouttabs
# ------------------------------------------------------------


CREATE TABLE `guide_fieldlayouttabs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_fieldlayouttabs_sortOrder_idx` (`sortOrder`),
  KEY `guide_fieldlayouttabs_layoutId_fk` (`layoutId`),
  CONSTRAINT `guide_fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_fieldlayouttabs` (`id`, `layoutId`, `name`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(59,31,'Content',1,'2017-06-05 18:50:32','2017-06-05 18:50:32','e03e4a8b-fa61-42f7-b60b-71119a99703e'),
	(60,32,'Content',1,'2017-06-05 18:50:43','2017-06-05 18:50:43','831c33cd-4db8-49f0-8758-433376f8e0a2'),
	(61,33,'Content',1,'2017-06-05 18:50:51','2017-06-05 18:50:51','6ed11aa1-2e69-4f8d-aee1-245e9667139d'),
	(62,34,'Content',1,'2017-06-05 18:51:04','2017-06-05 18:51:04','7fe5a4b0-8e9a-4bd5-a6a2-6160ba67549a'),
	(197,63,'Cities',1,'2017-06-06 16:50:53','2017-06-06 16:50:53','4cf4d235-d898-4aa2-a630-fa69f6e1ebb1'),
	(198,63,'Places',2,'2017-06-06 16:50:53','2017-06-06 16:50:53','2bbbed60-8e56-4b64-b743-2196e627226d'),
	(199,63,'Gears',3,'2017-06-06 16:50:53','2017-06-06 16:50:53','e6726f53-1cf8-4b24-8876-f8d7c814fb39'),
	(200,63,'Promote',4,'2017-06-06 16:50:53','2017-06-06 16:50:53','f32ba6e8-1319-4a24-9cae-3f01e7d2895b'),
	(201,63,'SEO',5,'2017-06-06 16:50:53','2017-06-06 16:50:53','82825d2c-080c-4afa-81a0-c37dbe93c467'),
	(377,92,'General',1,'2017-06-06 18:12:49','2017-06-06 18:12:49','3fb481bb-caa6-4a8b-8e91-6daa7e25d894'),
	(378,92,'Informations',2,'2017-06-06 18:12:49','2017-06-06 18:12:49','e4a341e9-c3ad-4ed5-ba00-2cbe5f826091'),
	(379,92,'Pricing',3,'2017-06-06 18:12:49','2017-06-06 18:12:49','65ba0df0-cebf-48d3-a203-4b8f8154fbc6'),
	(380,92,'Places',4,'2017-06-06 18:12:49','2017-06-06 18:12:49','952b1598-a5fc-4e86-b294-04b3e6b7ea3b'),
	(381,92,'Search',5,'2017-06-06 18:12:49','2017-06-06 18:12:49','3953a07f-a199-4d7a-a0f8-fd689b484a1e'),
	(382,92,'Promoting',6,'2017-06-06 18:12:49','2017-06-06 18:12:49','ef4f75e3-8300-4801-9f7c-8a969e2e84a7'),
	(383,92,'Log',7,'2017-06-06 18:12:49','2017-06-06 18:12:49','8908eb15-3478-449c-87d1-e35cb4aa3c88'),
	(384,92,'SEO',8,'2017-06-06 18:12:49','2017-06-06 18:12:49','cf261d71-f58a-484e-a5d0-c64b1f2cfbc0'),
	(385,93,'General',1,'2017-06-06 18:13:27','2017-06-06 18:13:27','13cf2aa5-328c-409c-a9b9-72cd3c408843'),
	(386,93,'Details',2,'2017-06-06 18:13:27','2017-06-06 18:13:27','7d4cfff7-7d13-47f3-a634-0d837565548c'),
	(387,93,'Contact',3,'2017-06-06 18:13:27','2017-06-06 18:13:27','6c56e65a-19ee-4dbf-9093-b74bce6b0385'),
	(388,93,'Search',4,'2017-06-06 18:13:27','2017-06-06 18:13:27','a3dae374-4f4e-42b0-8ff6-73c3fd77f5b4'),
	(389,93,'Promoting',5,'2017-06-06 18:13:27','2017-06-06 18:13:27','323ca472-539b-4150-9d76-06cf601c7f04'),
	(390,93,'Log',6,'2017-06-06 18:13:27','2017-06-06 18:13:27','b918b056-638b-442d-8bc5-c7a62258cf95'),
	(391,93,'SEO',7,'2017-06-06 18:13:27','2017-06-06 18:13:27','d138117c-94dc-4660-a9f9-491241e5fd4f'),
	(392,94,'General',1,'2017-06-06 18:13:49','2017-06-06 18:13:49','2c867366-ea10-4fb6-9351-b7c29024b23a'),
	(393,94,'Details',2,'2017-06-06 18:13:49','2017-06-06 18:13:49','1fc2bd31-bf1f-4f24-ab36-664b4d2f29a6'),
	(394,94,'Contact',3,'2017-06-06 18:13:49','2017-06-06 18:13:49','5b316304-79e1-47eb-8a5b-5d0fed910a0c'),
	(395,94,'Search',4,'2017-06-06 18:13:49','2017-06-06 18:13:49','7cf3dc46-945a-451e-92cd-5a919d30ebdd'),
	(396,94,'Promoting',5,'2017-06-06 18:13:49','2017-06-06 18:13:49','3c34e30f-d9a8-4342-8d95-b52f1778a989'),
	(397,94,'Log',6,'2017-06-06 18:13:49','2017-06-06 18:13:49','5cce2e88-b60c-466c-9bc8-a3f39958da17'),
	(398,94,'SEO',7,'2017-06-06 18:13:49','2017-06-06 18:13:49','e5531d2c-5947-49da-9451-dbe3b42c8ef7'),
	(399,95,'General',1,'2017-06-06 18:14:23','2017-06-06 18:14:23','92d0d34b-8fbf-40cf-86b7-140834f50bb1'),
	(400,95,'Promoting',2,'2017-06-06 18:14:23','2017-06-06 18:14:23','f521a896-f5d4-46a0-b207-d3727b1b0258'),
	(401,96,'General',1,'2017-06-06 18:14:42','2017-06-06 18:14:42','42013e85-b645-43fe-89d3-c65bea1a6d17'),
	(402,96,'Details',2,'2017-06-06 18:14:42','2017-06-06 18:14:42','6dcd1dbd-9b54-49bb-9047-388f0f408776'),
	(403,96,'Contact',3,'2017-06-06 18:14:42','2017-06-06 18:14:42','1489d695-1654-4621-9537-c68bf82019bd'),
	(404,96,'Search',4,'2017-06-06 18:14:42','2017-06-06 18:14:42','5e2cdbd6-0c48-411f-8061-b7f457e2c9e3'),
	(405,96,'Promoting',5,'2017-06-06 18:14:42','2017-06-06 18:14:42','eb2f9455-82ef-42e0-91f8-89d8ffc21fd9'),
	(406,96,'Log',6,'2017-06-06 18:14:42','2017-06-06 18:14:42','369562dd-5c43-4217-98cd-8feda02dcb5b'),
	(407,96,'SEO',7,'2017-06-06 18:14:42','2017-06-06 18:14:42','b25ab3b2-f633-4231-95a7-c2581ee4e8fa'),
	(408,97,'General',1,'2017-06-06 18:15:02','2017-06-06 18:15:02','032560f8-8016-46d4-a102-e4632f1a4402'),
	(409,97,'Places',2,'2017-06-06 18:15:02','2017-06-06 18:15:02','7134b102-5721-4760-afeb-2e0578c91813'),
	(410,97,'Search',3,'2017-06-06 18:15:02','2017-06-06 18:15:02','8661ad71-8930-48a7-a20a-740a9a38d157'),
	(411,97,'Promoting',4,'2017-06-06 18:15:02','2017-06-06 18:15:02','01906ba5-4196-404e-a0a0-a583fde820a4'),
	(412,97,'Log',5,'2017-06-06 18:15:02','2017-06-06 18:15:02','6441c0ae-68a2-4ecb-942c-eba6990c4d36'),
	(413,97,'SEO',6,'2017-06-06 18:15:02','2017-06-06 18:15:02','4eba9423-b4d6-4eb6-a4e8-d38fb958546c'),
	(414,98,'General',1,'2017-06-06 18:15:19','2017-06-06 18:15:19','abd63082-8ca9-4d1f-bb8b-ea45870d1f68'),
	(415,98,'Details',2,'2017-06-06 18:15:19','2017-06-06 18:15:19','71c5f887-62cb-43f9-b2a2-62c420746db8'),
	(416,98,'Contact',3,'2017-06-06 18:15:19','2017-06-06 18:15:19','46938466-398e-4401-881d-f0226c9843ee'),
	(417,98,'Search',4,'2017-06-06 18:15:19','2017-06-06 18:15:19','ab71ce67-ebca-4069-ad5e-90983126be1e'),
	(418,98,'Promoting',5,'2017-06-06 18:15:19','2017-06-06 18:15:19','2bee7e5e-3e30-4499-a187-63efd0b53937'),
	(419,98,'Log',6,'2017-06-06 18:15:19','2017-06-06 18:15:19','786334ff-9b77-4c73-b1b9-81f68e7c8527'),
	(420,98,'SEO',7,'2017-06-06 18:15:19','2017-06-06 18:15:19','b24fe047-6ea7-467e-a114-2a617e4c2f86');



# Affichage de la table guide_fields
# ------------------------------------------------------------


CREATE TABLE `guide_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(58) COLLATE utf8_unicode_ci NOT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'global',
  `instructions` text COLLATE utf8_unicode_ci,
  `translatable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_fields_handle_context_unq_idx` (`handle`,`context`),
  KEY `guide_fields_context_idx` (`context`),
  KEY `guide_fields_groupId_fk` (`groupId`),
  CONSTRAINT `guide_fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_fields` (`id`, `groupId`, `name`, `handle`, `context`, `instructions`, `translatable`, `type`, `settings`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'Body','body','global',NULL,1,'RichText','{\"configFile\":\"Standard.json\",\"columnType\":\"text\"}','2017-06-05 15:46:30','2017-06-05 15:46:30','953f54ad-7757-43c7-bf0a-18e8d4ba2640'),
	(2,1,'Tags','tags','global',NULL,0,'Tags','{\"source\":\"taggroup:1\"}','2017-06-05 15:46:30','2017-06-05 15:46:30','5e109da0-bfca-4067-98c9-f238bfa73abf'),
	(4,1,'Short Description','shortDescription','global','',0,'RichText','{\"configFile\":\"Simple.json\",\"availableAssetSources\":\"*\",\"availableTransforms\":\"*\",\"cleanupHtml\":\"1\",\"purifyHtml\":\"1\",\"purifierConfig\":\"\",\"columnType\":\"text\"}','2017-06-05 16:55:14','2017-06-05 18:57:37','691eec00-fe82-4218-8900-02bf9a1c4e71'),
	(6,4,'Food places','foodPlaces','global','',0,'Entries','{\"sources\":[\"section:6\"],\"limit\":\"30\",\"selectionLabel\":\"\"}','2017-06-05 16:58:55','2017-06-05 17:14:41','33b5fa03-8e72-4fc2-ba42-b5f299de20b8'),
	(7,4,'Working/Living places','workingLivingPlaces','global','',0,'Entries','{\"sources\":[\"section:9\",\"section:8\"],\"limit\":\"30\",\"selectionLabel\":\"\"}','2017-06-05 16:59:47','2017-06-05 17:14:31','63b2f94b-879b-49f3-8a6b-ab47bd0de84c'),
	(8,4,'Drink places','drinkPlaces','global','',0,'Entries','{\"sources\":[\"section:7\"],\"limit\":\"30\",\"selectionLabel\":\"\"}','2017-06-05 17:00:34','2017-06-05 17:14:20','3f92f93d-fe3f-4e3e-a5d9-2d74ca054eab'),
	(10,4,'Neighborhoods','neighborhoods','global','',0,'Entries','{\"sources\":[\"section:5\"],\"limit\":\"30\",\"selectionLabel\":\"\"}','2017-06-05 17:07:18','2017-06-05 17:15:24','225be49b-a160-4f85-bcbb-de5a0b00679f'),
	(11,5,'Meta Title','metaTitle','global','',0,'PlainText','{\"placeholder\":\"Maximum of 60 caracters (SEO best practice)\",\"maxLength\":\"70\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:19:44','2017-06-06 14:38:30','13f459bf-0567-4dea-ac19-434ee782fa6b'),
	(12,5,'Meta Description','metaDescription','global','',0,'PlainText','{\"placeholder\":\"Maximum of 160 caracters (SEO best practice)\",\"maxLength\":\"220\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:22:05','2017-06-06 14:38:17','95c72f77-5a3e-4b39-bb0a-15fdd972b4a6'),
	(14,4,'Internet Speed','internetSpeed','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:33:58','2017-06-05 17:50:02','ed7221ef-675c-4ae6-9fed-cb42645d37a5'),
	(15,4,'Fun Factor','funFactor','global','',0,'Dropdown','{\"options\":[{\"label\":\"Low\",\"value\":\"low\",\"default\":\"\"},{\"label\":\"Medium\",\"value\":\"medium\",\"default\":\"1\"},{\"label\":\"High\",\"value\":\"high\",\"default\":\"\"}]}','2017-06-05 17:35:44','2017-06-06 17:39:47','a4a5776f-d686-41a5-bbe9-add8bb15c22e'),
	(16,4,'Safety Factor','safetyFactor','global','',0,'Dropdown','{\"options\":[{\"label\":\"Low\",\"value\":\"low\",\"default\":\"\"},{\"label\":\"Medium\",\"value\":\"medium\",\"default\":\"1\"},{\"label\":\"High\",\"value\":\"high\",\"default\":\"\"}]}','2017-06-05 17:36:15','2017-06-06 17:39:56','94f6385e-b590-4b53-ad97-25061da4ae7b'),
	(17,4,'Polution Factor','polutionFactor','global','',0,'Dropdown','{\"options\":[{\"label\":\"Low\",\"value\":\"low\",\"default\":\"\"},{\"label\":\"Medium\",\"value\":\"medium\",\"default\":\"1\"},{\"label\":\"High\",\"value\":\"high\",\"default\":\"\"}]}','2017-06-05 17:36:44','2017-06-06 17:40:08','9295e7a0-72c0-4296-9841-d0e90f43fe84'),
	(18,4,'Nomad Friendly','nomadFriendly','global','',0,'Lightswitch','{\"default\":\"1\"}','2017-06-05 17:37:10','2017-06-05 17:37:10','0c0a1042-ce79-4a9b-9b55-aff495a09c68'),
	(19,4,'Uber Available','uberAvailable','global','',0,'PlainText','{\"placeholder\":\"Paste our referal link here.\",\"maxLength\":\"300\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:38:00','2017-06-05 17:38:00','31f55733-9c75-41c9-a33e-bc18bea7d2f7'),
	(20,4,'Airbnb Available','airbnbAvailable','global','',0,'PlainText','{\"placeholder\":\"Paste our referal link here.\",\"maxLength\":\"300\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:38:28','2017-06-05 17:38:28','9ebbf316-c612-49bd-9637-05377aa0b901'),
	(21,4,'Pricing: Monthly Budget','pricingMonthlyBudget','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:41:56','2017-06-05 17:42:14','cd62034f-ac34-4de1-9652-e2fb7c599e38'),
	(22,4,'Pricing: Weekly Budget','pricingWeeklyBudget','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:42:32','2017-06-05 17:42:32','7be140d1-3cc6-43f9-8602-ae6cd257fd52'),
	(23,4,'Pricing: Meal','pricingMeal','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:42:47','2017-06-05 17:42:47','e76a041b-74ca-47df-a788-3f45a67b82e0'),
	(24,4,'Pricing: Beer','pricingBeer','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:42:57','2017-06-05 17:42:57','4b245133-ec28-40ca-8c8e-e916a63eda77'),
	(25,4,'Pricing: Coffee','pricingCoffee','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:44:45','2017-06-05 17:44:45','355f7a0b-13cd-405d-98ac-526cab5b0267'),
	(26,4,'Pricing: Unit Local Transport','pricingUnitLocalTransport','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:45:18','2017-06-05 17:45:18','6dd2a763-38d1-42dd-a1dd-7a320c73bcd4'),
	(27,4,'Pricing: Monthly Local Transport','pricingMonthlyLocalTransport','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:45:33','2017-06-05 17:45:33','239289c2-001f-430b-bca5-f858e1e27ce8'),
	(28,4,'Pricing: Taxi','pricingTaxi','global','1km normal tarif.',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:46:12','2017-06-05 17:46:20','40849348-f29b-4a52-9dd0-394364f24797'),
	(29,4,'Pricing: Accomodation 1 bedroom','pricingAccomodation1Bedroom','global','City center area, one bedroom appartment.',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:47:22','2017-06-05 17:47:22','e93d8eab-9ccd-4b6e-8684-bfa2f14a7f88'),
	(30,4,'Pricing: Accomodation 3 bedroom','pricingAccomodation3Bedroom','global','City center 3 bedrooms appartement.',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:47:42','2017-06-05 17:47:42','d1ffa5b1-a067-4735-8ea4-6d4251b4a5ba'),
	(31,4,'Pricing: Fitness Club','pricingFitnessClub','global','Fitness Club, Monthly Fee for 1 Adult',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:48:19','2017-06-05 17:48:36','8de129a4-eca6-4cc8-a97c-b70d0bfff475'),
	(32,4,'Pricing: Coworking Space','pricingCoworkingSpace','global','Monthly subscription',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:49:17','2017-06-05 17:49:17','b4681e2c-89ea-4e9b-a328-38e8792a356d'),
	(33,4,'Pricing: Sim Card','pricingSimCard','global','4G Sim card for a month',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:49:42','2017-06-05 17:49:42','19fe637e-2ed1-4ce3-9150-8cf238a000c2'),
	(34,1,'Author','author','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"120\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 17:55:54','2017-06-05 17:55:54','bbc3db39-3360-4e96-8abd-916f495fe7c6'),
	(35,1,'Cover Image','coverImage','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:4\"],\"defaultUploadLocationSource\":\"4\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"1\",\"allowedKinds\":[\"image\"],\"limit\":\"1\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-05 18:09:33','2017-06-06 15:17:39','7c0b44a6-5ff3-4019-9094-174c86f6a9d2'),
	(36,4,'Update Log','updateLog','global','',0,'Table','{\"columns\":{\"col1\":{\"heading\":\"Date\",\"handle\":\"date\",\"width\":\"\",\"type\":\"singleline\"},\"col2\":{\"heading\":\"Author\",\"handle\":\"author\",\"width\":\"\",\"type\":\"singleline\"},\"col3\":{\"heading\":\"Link\",\"handle\":\"link\",\"width\":\"\",\"type\":\"singleline\"}},\"defaults\":{\"row1\":{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"}}}','2017-06-05 18:11:54','2017-06-05 18:11:54','07a54dce-6626-48c3-bced-801d8e9cbb7f'),
	(37,4,'Pro’s','pros','global','',0,'RichText','{\"configFile\":\"Simple.json\",\"availableAssetSources\":\"\",\"availableTransforms\":\"\",\"cleanupHtml\":\"1\",\"purifyHtml\":\"1\",\"purifierConfig\":\"\",\"columnType\":\"text\"}','2017-06-05 18:17:08','2017-06-05 18:17:08','23803087-6733-40c5-93e6-4ef6c3677b61'),
	(38,4,'Con’s','cons','global','',0,'RichText','{\"configFile\":\"Simple.json\",\"availableAssetSources\":\"\",\"availableTransforms\":\"\",\"cleanupHtml\":\"1\",\"purifyHtml\":\"1\",\"purifierConfig\":\"\",\"columnType\":\"text\"}','2017-06-05 18:18:09','2017-06-05 18:18:09','c982de2b-5f72-416c-be6d-f19702a7f268'),
	(39,5,'OG Image','ogImage','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:4\"],\"defaultUploadLocationSource\":\"4\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"4\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"1\",\"allowedKinds\":[\"image\"],\"limit\":\"1\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-05 18:26:31','2017-06-06 15:16:49','930fa553-ca59-485e-a18e-c2a6884408cb'),
	(40,6,'City','city','global','',0,'Entries','{\"sources\":[\"section:4\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-05 18:46:34','2017-06-05 18:46:34','98e586ef-307a-416e-acbd-0ec95d962bee'),
	(41,6,'Tags','neighborhoodsTags','global','',0,'Tags','{\"source\":\"taggroup:2\",\"selectionLabel\":\"\"}','2017-06-05 18:48:44','2017-06-05 18:48:55','110b0ec4-3cb4-49ea-bfee-b58b4ce1eac8'),
	(42,4,'Tags','citiesTags','global','',0,'Tags','{\"source\":\"taggroup:3\",\"selectionLabel\":\"\"}','2017-06-05 18:49:15','2017-06-05 18:49:24','58f32a7d-e7d6-4c33-bebc-f09c2602fcb2'),
	(43,1,'Medias Tags','mediasTags','global','',0,'Tags','{\"source\":\"taggroup:4\",\"selectionLabel\":\"\"}','2017-06-05 18:50:17','2017-06-05 18:50:17','b9709a90-f90e-4c5f-8738-b7b385ac06e4'),
	(44,3,'Specifications','specifications','global','',0,'Table','{\"columns\":{\"col1\":{\"heading\":\"specification\",\"handle\":\"specification\",\"width\":\"\",\"type\":\"singleline\"}},\"defaults\":{\"row1\":{\"col1\":\"\"}}}','2017-06-05 18:54:36','2017-06-05 18:54:36','731c1d98-6652-4296-b1ea-a0f29ec5a1d2'),
	(45,3,'Shop Link','shopLink','global','Referal or basic link to shop the product',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"500\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 18:55:17','2017-06-05 18:55:17','ea7ccdbf-636f-41b0-837b-c98751ac05b7'),
	(46,3,'Categories','gearsCategories','global','',0,'Categories','{\"source\":\"group:1\",\"limit\":\"5\",\"selectionLabel\":\"\"}','2017-06-05 18:57:09','2017-06-05 18:58:46','adf6e065-e274-42dd-aef2-4142efaf2f4e'),
	(47,2,'Speciality','speciality','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"120\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 19:00:13','2017-06-05 19:00:13','8622b1fb-db33-42bb-b950-bd0501a19f98'),
	(48,2,'Vibe/Style','vibe','global','',0,'Dropdown','{\"options\":[{\"label\":\"Hipster\",\"value\":\"hipster\",\"default\":\"\"},{\"label\":\"Industial\",\"value\":\"industial\",\"default\":\"\"},{\"label\":\"Vintage\",\"value\":\"vintage\",\"default\":\"\"},{\"label\":\"Modern\",\"value\":\"modern\",\"default\":\"\"},{\"label\":\"Design\",\"value\":\"design\",\"default\":\"\"},{\"label\":\"Hippie\",\"value\":\"hippie\",\"default\":\"\"},{\"label\":\"Destroy\",\"value\":\"destroy\",\"default\":\"\"}]}','2017-06-05 19:01:42','2017-06-05 19:01:42','ca27c39f-0805-488e-9831-a08748ff6190'),
	(49,2,'Neighborhood','neighborhood','global','',0,'Entries','{\"sources\":[\"section:5\"],\"limit\":\"6\",\"selectionLabel\":\"\"}','2017-06-05 19:02:46','2017-06-05 19:02:46','a8eb2f6b-18e4-448e-8498-f9af91713ed5'),
	(50,2,'Place Type','placeType','global','',0,'Dropdown','{\"options\":[{\"label\":\"Fast Food\",\"value\":\"fastFood\",\"default\":\"\"},{\"label\":\"Gastronomic\",\"value\":\"gastronomic\",\"default\":\"\"},{\"label\":\"Bar\",\"value\":\"bar\",\"default\":\"\"},{\"label\":\"Pub\",\"value\":\"pub\",\"default\":\"\"},{\"label\":\"Caterer\",\"value\":\"caterer\",\"default\":\"\"}]}','2017-06-05 19:04:16','2017-06-05 19:04:16','dd373f86-675c-4290-a9ca-5deb8566f86e'),
	(51,2,'Vegetarian/Vegan Options','veganOptions','global','',0,'Lightswitch','{\"default\":\"\"}','2017-06-05 19:04:49','2017-06-05 19:04:49','5e54ae37-ce06-49dc-a058-3b3ba09fdcf4'),
	(52,2,'Full Address','fullAddress','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"600\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 19:05:28','2017-06-05 19:05:28','b9960962-342e-43cc-a531-0775399442d2'),
	(53,2,'Google Map Link','googleMapLink','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"600\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 19:05:44','2017-06-05 19:05:44','74ee2070-7b2f-4600-8375-18cbdd051d62'),
	(54,2,'Phone','phone','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"30\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 19:06:01','2017-06-05 19:06:01','2528e317-0298-45b4-8c8e-d6b8c36a1458'),
	(55,2,'Website','website','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"120\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-05 19:06:13','2017-06-05 19:08:08','ea70835c-073b-4d89-909d-ba7ce59d4236'),
	(56,2,'Opening Hours','openingHours','global','',0,'Table','{\"columns\":{\"col1\":{\"heading\":\"Monday\",\"handle\":\"monday\",\"width\":\"\",\"type\":\"singleline\"},\"col2\":{\"heading\":\"Tuesday\",\"handle\":\"tuesday\",\"width\":\"\",\"type\":\"singleline\"},\"col3\":{\"heading\":\"Wednesday\",\"handle\":\"wednesday\",\"width\":\"\",\"type\":\"singleline\"},\"col4\":{\"heading\":\"Thursday\",\"handle\":\"thursday\",\"width\":\"\",\"type\":\"singleline\"},\"col5\":{\"heading\":\"Friday\",\"handle\":\"friday\",\"width\":\"\",\"type\":\"singleline\"},\"col6\":{\"heading\":\"Saturday\",\"handle\":\"saturday\",\"width\":\"\",\"type\":\"singleline\"},\"col7\":{\"heading\":\"Sunday\",\"handle\":\"sunday\",\"width\":\"\",\"type\":\"singleline\"}},\"defaults\":{\"row1\":{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\",\"col4\":\"\",\"col5\":\"\",\"col6\":\"\",\"col7\":\"\"}}}','2017-06-05 19:07:21','2017-06-05 19:07:21','246684f9-8e5c-4823-98c6-606bf34b40c4'),
	(57,2,'Rating','rating','global','',0,'Number','{\"min\":\"0\",\"max\":\"5\",\"decimals\":\"1\"}','2017-06-05 19:07:56','2017-06-05 19:08:14','c66b3dc0-62c8-416a-a3a6-119be7cb6285'),
	(58,2,'Tags','placesTags','global','',0,'Tags','{\"source\":\"taggroup:5\",\"selectionLabel\":\"\"}','2017-06-05 19:11:21','2017-06-05 19:11:28','53ebacdf-0a15-40f9-a699-129759998020'),
	(59,1,'Cities','cities','global','',0,'Entries','{\"sources\":[\"section:4\"],\"limit\":\"18\",\"selectionLabel\":\"\"}','2017-06-05 21:10:43','2017-06-05 21:10:43','5c9a3f5f-cde1-4a1a-a19f-d30f765f3f0b'),
	(60,1,'Gears','gears','global','',0,'Entries','{\"sources\":[\"section:3\"],\"limit\":\"18\",\"selectionLabel\":\"\"}','2017-06-05 21:10:59','2017-06-05 21:10:59','15b24b47-d0eb-4b61-be69-d33ba97593ae'),
	(61,2,'Place Images','placeImages','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:3\"],\"defaultUploadLocationSource\":\"3\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"1\",\"allowedKinds\":[\"image\"],\"limit\":\"6\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-06 15:13:27','2017-06-06 15:13:27','fb722dcd-ac3e-4ff7-af55-18ab14e12336'),
	(62,4,'Cover Image','cityCoverImage','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:1\"],\"defaultUploadLocationSource\":\"1\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"1\",\"allowedKinds\":[\"image\"],\"limit\":\"1\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-06 15:18:10','2017-06-06 15:18:19','8993d50d-aeb0-4964-85ba-9f253dc3d70e'),
	(63,3,'Gear Images','gearImages','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:2\"],\"defaultUploadLocationSource\":\"2\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"\",\"limit\":\"6\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-06 15:48:56','2017-06-06 15:48:56','b5b9964d-0f71-4b10-9cec-c29143d95dfb'),
	(64,1,'Position','position','global','',0,'Number','{\"min\":\"0\",\"max\":\"1000\",\"decimals\":\"0\"}','2017-06-06 16:11:57','2017-06-06 16:11:57','a5ab40ba-117a-488c-86a0-2baecdff84f8'),
	(65,1,'Featured City','featuredCity','global','',0,'Entries','{\"sources\":[\"section:4\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-06 16:40:04','2017-06-06 16:40:04','02ac71d6-48b0-4a89-96aa-b9f5fc35e3b6'),
	(66,1,'Featured Gear','featuredGear','global','',0,'Entries','{\"sources\":[\"section:3\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-06 16:40:21','2017-06-06 16:40:21','7d4500c3-aa07-45e4-81a4-8ca450358bdb'),
	(67,1,'Featured Food Place','featuredFoodPlace','global','',0,'Entries','{\"sources\":[\"section:6\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-06 16:40:38','2017-06-06 16:40:38','17bb1e1a-2454-4870-b298-73684f08a638'),
	(68,1,'Featured Drink Place','featuredDrinkPlace','global','',0,'Entries','{\"sources\":[\"section:7\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-06 16:40:54','2017-06-06 16:40:54','9ab1df22-fbb5-4a4d-83d0-62c7b54ca8bf'),
	(69,1,'Featured Working/Living Place','featuredWorkingLivingPlace','global','',0,'Entries','{\"sources\":[\"section:8\"],\"limit\":\"1\",\"selectionLabel\":\"\"}','2017-06-06 16:41:10','2017-06-06 16:44:05','fd0f9fa4-63b4-451e-9caa-4a5b5b8db0bc'),
	(71,7,'Announcer Name','announcerName','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"120\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-06 16:56:52','2017-06-06 16:56:52','0b8e0a04-f090-4beb-97ee-3ddddc009f72'),
	(72,7,'Promotion Link','promotionLink','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"\",\"multiline\":\"\",\"initialRows\":\"4\"}','2017-06-06 16:57:08','2017-06-06 18:10:44','647d9d2a-c5d0-485c-963f-4e46b89c9296'),
	(73,7,'Announcer Logo','announcerLogo','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:5\"],\"defaultUploadLocationSource\":\"5\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"\",\"limit\":\"1\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-06 16:58:55','2017-06-06 16:58:55','42f1ffef-0b2e-4c23-9c4d-b2540def3136'),
	(74,7,'Promotion Text','promotionText','global','',0,'RichText','{\"configFile\":\"Simple.json\",\"availableAssetSources\":\"\",\"availableTransforms\":\"\",\"cleanupHtml\":\"1\",\"purifyHtml\":\"1\",\"purifierConfig\":\"\",\"columnType\":\"text\"}','2017-06-06 16:59:36','2017-06-06 18:10:03','d7ab0722-fa9b-464e-a373-2f1ea9d87754'),
	(75,7,'Promotion Start At','promotionStartAt','global','',0,'Date','{\"minuteIncrement\":\"60\",\"showTime\":1,\"showDate\":1}','2017-06-06 17:20:48','2017-06-06 17:20:48','97f011cc-2558-4cb9-8a53-3cc908eddf88'),
	(76,7,'Promotion End At','promotionEndAt','global','',0,'Date','{\"minuteIncrement\":\"60\",\"showTime\":1,\"showDate\":1}','2017-06-06 17:22:31','2017-06-06 17:22:31','d15012ef-6515-4c78-85d1-198b737f16a5'),
	(77,7,'Promotion Active','promotionActive','global','',0,'Lightswitch','{\"default\":\"\"}','2017-06-06 17:54:04','2017-06-06 17:54:04','48cdd1bf-175b-4958-960f-e41caff0ff1a'),
	(78,7,'Promotion Image','promotionImage','global','',0,'Assets','{\"useSingleFolder\":\"\",\"sources\":[\"folder:5\"],\"defaultUploadLocationSource\":\"5\",\"defaultUploadLocationSubpath\":\"\",\"singleUploadLocationSource\":\"1\",\"singleUploadLocationSubpath\":\"\",\"restrictFiles\":\"1\",\"allowedKinds\":[\"image\"],\"limit\":\"1\",\"viewMode\":\"large\",\"selectionLabel\":\"\"}','2017-06-06 18:11:11','2017-06-06 18:11:11','34087774-4cfe-4d93-add3-e5580bc24491');



# Affichage de la table guide_globalsets
# ------------------------------------------------------------


CREATE TABLE `guide_globalsets` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fieldLayoutId` int(10) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_globalsets_name_unq_idx` (`name`),
  UNIQUE KEY `guide_globalsets_handle_unq_idx` (`handle`),
  KEY `guide_globalsets_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_globalsets_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `guide_globalsets_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_info
# ------------------------------------------------------------


CREATE TABLE `guide_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `schemaVersion` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `edition` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `siteName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `siteUrl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timezone` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `on` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `maintenance` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_info` (`id`, `version`, `schemaVersion`, `edition`, `siteName`, `siteUrl`, `timezone`, `on`, `maintenance`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'2.6.2981','2.6.9',0,'Wanderbrief CityGuides','http://wanderbrief-guides.local','UTC',1,0,'2017-06-05 15:46:29','2017-06-06 14:57:56','c1441219-9235-46d0-b943-821077c08b42');



# Affichage de la table guide_locales
# ------------------------------------------------------------


CREATE TABLE `guide_locales` (
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`locale`),
  KEY `guide_locales_sortOrder_idx` (`sortOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_locales` (`locale`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	('en',1,'2017-06-05 15:46:29','2017-06-05 15:46:29','b58f0511-cb5e-4670-80f9-36cfcc13a7d4');



# Affichage de la table guide_matrixblocks
# ------------------------------------------------------------


CREATE TABLE `guide_matrixblocks` (
  `id` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `typeId` int(11) DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `ownerLocale` char(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_matrixblocks_ownerId_idx` (`ownerId`),
  KEY `guide_matrixblocks_fieldId_idx` (`fieldId`),
  KEY `guide_matrixblocks_typeId_idx` (`typeId`),
  KEY `guide_matrixblocks_sortOrder_idx` (`sortOrder`),
  KEY `guide_matrixblocks_ownerLocale_fk` (`ownerLocale`),
  CONSTRAINT `guide_matrixblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `guide_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_matrixblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_matrixblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_matrixblocks_ownerLocale_fk` FOREIGN KEY (`ownerLocale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `guide_matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `guide_matrixblocktypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_matrixblocktypes
# ------------------------------------------------------------


CREATE TABLE `guide_matrixblocktypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_matrixblocktypes_name_fieldId_unq_idx` (`name`,`fieldId`),
  UNIQUE KEY `guide_matrixblocktypes_handle_fieldId_unq_idx` (`handle`,`fieldId`),
  KEY `guide_matrixblocktypes_fieldId_fk` (`fieldId`),
  KEY `guide_matrixblocktypes_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `guide_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_migrations
# ------------------------------------------------------------


CREATE TABLE `guide_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pluginId` int(11) DEFAULT NULL,
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `applyTime` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_migrations_version_unq_idx` (`version`),
  KEY `guide_migrations_pluginId_fk` (`pluginId`),
  CONSTRAINT `guide_migrations_pluginId_fk` FOREIGN KEY (`pluginId`) REFERENCES `guide_plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_migrations` (`id`, `pluginId`, `version`, `applyTime`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,NULL,'m000000_000000_base','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','33825cb5-1a83-4349-96ed-0a279385d56b'),
	(2,NULL,'m140730_000001_add_filename_and_format_to_transformindex','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','42cc0175-cabc-484f-9f23-f68360577053'),
	(3,NULL,'m140815_000001_add_format_to_transforms','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','8557ea09-fd94-49b2-bed8-8401d6e7c495'),
	(4,NULL,'m140822_000001_allow_more_than_128_items_per_field','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','1da9f8af-2574-46b8-a373-2fc769e7c45c'),
	(5,NULL,'m140829_000001_single_title_formats','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','69f496d5-824d-46eb-a2ad-a84da5fe0c0e'),
	(6,NULL,'m140831_000001_extended_cache_keys','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','9f2c3606-039a-4183-962b-cf576b5da925'),
	(7,NULL,'m140922_000001_delete_orphaned_matrix_blocks','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','318295da-6c2d-43db-a1d0-5db68938f16d'),
	(8,NULL,'m141008_000001_elements_index_tune','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','e5939256-1ece-4f9e-b9d4-bd863ad78c37'),
	(9,NULL,'m141009_000001_assets_source_handle','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','019b6426-54a0-4e2f-aa79-23510db21b56'),
	(10,NULL,'m141024_000001_field_layout_tabs','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','c133692a-73d4-4cd2-baa6-96fb65335ddf'),
	(11,NULL,'m141030_000000_plugin_schema_versions','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','a3d38a79-c7d0-4c69-951b-18ebae507100'),
	(12,NULL,'m141030_000001_drop_structure_move_permission','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','b7619915-f64b-45b9-bd1c-ff29885a8e57'),
	(13,NULL,'m141103_000001_tag_titles','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','7cbe261a-7a39-471e-982b-f9c53d5d93e2'),
	(14,NULL,'m141109_000001_user_status_shuffle','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','afdefe1e-e010-4e9b-aa5a-034a2910c4c5'),
	(15,NULL,'m141126_000001_user_week_start_day','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','3959cdfe-a232-49e8-86ee-16934d1d553a'),
	(16,NULL,'m150210_000001_adjust_user_photo_size','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','bbe7c9be-e399-47ea-9040-117ddde7e2f8'),
	(17,NULL,'m150724_000001_adjust_quality_settings','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','bbd728aa-17b0-407e-938f-b0a5b0c39c42'),
	(18,NULL,'m150827_000000_element_index_settings','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','fa60e2ec-71e3-40f1-9cba-008b8b1e058f'),
	(19,NULL,'m150918_000001_add_colspan_to_widgets','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','ad807f5f-0b30-4de5-95a3-8cbceb702757'),
	(20,NULL,'m151007_000000_clear_asset_caches','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','71a0b622-8fe5-4809-8473-895cecc63b2a'),
	(21,NULL,'m151109_000000_text_url_formats','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','582fae71-b67b-4900-8be0-c56cb84ea1aa'),
	(22,NULL,'m151110_000000_move_logo','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','2d3fb3e4-5e90-4487-aaf6-bf7f6c37408e'),
	(23,NULL,'m151117_000000_adjust_image_widthheight','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','edcd3013-bfb3-434d-8475-9dbf540b37f8'),
	(24,NULL,'m151127_000000_clear_license_key_status','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','d2b72154-07f3-47ee-9ea9-d2f596e5ed60'),
	(25,NULL,'m151127_000000_plugin_license_keys','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','e6ee0ecf-fa2f-4034-8237-1535329aa69c'),
	(26,NULL,'m151130_000000_update_pt_widget_feeds','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','fe6b0ed5-6154-4285-bbca-04ba1f31bd44'),
	(27,NULL,'m160114_000000_asset_sources_public_url_default_true','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','49673837-49f3-44f2-8f75-e521d8d0c71f'),
	(28,NULL,'m160223_000000_sortorder_to_smallint','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','095d016f-be0b-4dee-8062-b43529bc07e2'),
	(29,NULL,'m160229_000000_set_default_entry_statuses','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','3bbb5a7a-cdf6-4183-abb1-226591d2e507'),
	(30,NULL,'m160304_000000_client_permissions','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','d69814ac-3a93-481f-99ae-8951aadac08e'),
	(31,NULL,'m160322_000000_asset_filesize','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','19738905-e5dd-4adf-89cd-7776aadf5601'),
	(32,NULL,'m160503_000000_orphaned_fieldlayouts','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','e7ab8d0d-8edd-4078-9e9c-4b637caa759d'),
	(33,NULL,'m160510_000000_tasksettings','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','5337f968-f15d-4a7f-8f22-3c3d16e5042e'),
	(34,NULL,'m160829_000000_pending_user_content_cleanup','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','5d435000-2bc5-4dbb-8529-275fee1c7907'),
	(35,NULL,'m160830_000000_asset_index_uri_increase','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','2af6d3bc-04ca-497e-8620-dac696334337'),
	(36,NULL,'m160919_000000_usergroup_handle_title_unique','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','277beaaa-fb71-4327-8194-15c5d831e016'),
	(37,NULL,'m161108_000000_new_version_format','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','46ae7ff6-3e23-471f-9dbc-a40dfc99b00f'),
	(38,NULL,'m161109_000000_index_shuffle','2017-06-05 15:46:29','2017-06-05 15:46:29','2017-06-05 15:46:29','26830652-01a3-4fee-8399-0b633c23ccde');



# Affichage de la table guide_plugins
# ------------------------------------------------------------


CREATE TABLE `guide_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `version` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `schemaVersion` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `licenseKey` char(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `licenseKeyStatus` enum('valid','invalid','mismatched','unknown') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown',
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `settings` text COLLATE utf8_unicode_ci,
  `installDate` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_plugins` (`id`, `class`, `version`, `schemaVersion`, `licenseKey`, `licenseKeyStatus`, `enabled`, `settings`, `installDate`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'ElementApi','1.6.0','1.0.0',NULL,'unknown',1,NULL,'2017-06-05 19:27:44','2017-06-05 19:27:44','2017-06-06 15:32:23','0fbf9c27-1ae3-4a8d-be3c-d7613acfc383');




# Affichage de la table guide_relations
# ------------------------------------------------------------


CREATE TABLE `guide_relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `sourceLocale` char(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `targetId` int(11) NOT NULL,
  `sortOrder` smallint(6) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_relations_fieldId_sourceId_sourceLocale_targetId_unq_idx` (`fieldId`,`sourceId`,`sourceLocale`,`targetId`),
  KEY `guide_relations_sourceId_fk` (`sourceId`),
  KEY `guide_relations_sourceLocale_fk` (`sourceLocale`),
  KEY `guide_relations_targetId_fk` (`targetId`),
  CONSTRAINT `guide_relations_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `guide_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_relations_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_relations_sourceLocale_fk` FOREIGN KEY (`sourceLocale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `guide_relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_relations` (`id`, `fieldId`, `sourceId`, `sourceLocale`, `targetId`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,40,5,NULL,4,1,'2017-06-05 19:40:41','2017-06-05 19:40:41','a7805296-303a-4f7a-b7e5-f2ac5f4519b9'),
	(11,35,2,NULL,6,1,'2017-06-06 15:03:13','2017-06-06 15:03:13','f756c5f6-16b9-4c9d-baeb-aaa32cf7925b'),
	(12,59,2,NULL,4,1,'2017-06-06 15:03:13','2017-06-06 15:03:13','ce1029bf-e03c-4a5e-bca8-335b9cb43ff9'),
	(19,10,4,NULL,5,1,'2017-06-06 18:06:43','2017-06-06 18:06:43','b32551f5-a35d-4857-8651-5ae15c8885ad');



# Affichage de la table guide_routes
# ------------------------------------------------------------


CREATE TABLE `guide_routes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `locale` char(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `urlParts` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `urlPattern` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_routes_urlPattern_unq_idx` (`urlPattern`),
  KEY `guide_routes_locale_idx` (`locale`),
  CONSTRAINT `guide_routes_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_searchindex
# ------------------------------------------------------------


CREATE TABLE `guide_searchindex` (
  `elementId` int(11) NOT NULL,
  `attribute` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `fieldId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`elementId`,`attribute`,`fieldId`,`locale`),
  FULLTEXT KEY `guide_searchindex_keywords_idx` (`keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_searchindex` (`elementId`, `attribute`, `fieldId`, `locale`, `keywords`)
VALUES
	(1,'username',0,'en',' wanderbrief '),
	(1,'firstname',0,'en',''),
	(1,'lastname',0,'en',''),
	(1,'fullname',0,'en',''),
	(1,'email',0,'en',' cguillou wanderbrief com '),
	(1,'slug',0,'en',''),
	(2,'slug',0,'en',' homepage '),
	(2,'title',0,'en',' home '),
	(2,'field',1,'en',' it s true this site doesn t have a whole lot of content yet but don t worry our web developers have just installed the cms and they re setting things up for the content editors this very moment soon wanderbrief guides local will be an oasis of fresh perspectives sharp analyses and astute opinions that will keep you coming back again and again '),
	(4,'field',37,'en',''),
	(4,'field',38,'en',''),
	(4,'field',10,'en',' noord '),
	(4,'field',14,'en',''),
	(4,'field',18,'en',' 1 '),
	(4,'field',15,'en',' high '),
	(4,'field',16,'en',' medium '),
	(4,'field',17,'en',' low '),
	(4,'field',22,'en',''),
	(4,'field',35,'en',''),
	(4,'field',4,'en',' with world class museums quirky festivals theatre live music laid back bars and delightful restaurants there s never a shortage of things to do in amsterdam '),
	(4,'field',21,'en',''),
	(4,'field',23,'en',''),
	(4,'field',24,'en',''),
	(4,'field',25,'en',''),
	(4,'field',26,'en',''),
	(4,'field',27,'en',''),
	(4,'field',28,'en',''),
	(4,'field',19,'en',''),
	(4,'field',29,'en',''),
	(4,'field',30,'en',''),
	(4,'field',20,'en',''),
	(4,'field',32,'en',''),
	(4,'field',31,'en',''),
	(4,'field',33,'en',''),
	(4,'field',6,'en',''),
	(4,'field',8,'en',''),
	(4,'field',7,'en',''),
	(4,'field',42,'en',''),
	(4,'field',36,'en',''),
	(4,'field',11,'en',''),
	(4,'field',12,'en',''),
	(4,'slug',0,'en',' amsterdam '),
	(4,'title',0,'en',' amsterdam '),
	(5,'field',35,'en',''),
	(5,'field',4,'en',''),
	(5,'field',40,'en',' amsterdam '),
	(5,'field',6,'en',''),
	(5,'field',8,'en',''),
	(5,'field',7,'en',''),
	(5,'field',41,'en',''),
	(5,'field',36,'en',''),
	(5,'field',11,'en',''),
	(5,'field',12,'en',''),
	(5,'field',39,'en',''),
	(5,'slug',0,'en',' noord '),
	(5,'title',0,'en',' noord '),
	(2,'field',35,'en',' 1899 '),
	(2,'field',59,'en',' amsterdam '),
	(2,'field',6,'en',''),
	(2,'field',8,'en',''),
	(2,'field',7,'en',''),
	(2,'field',60,'en',''),
	(2,'field',11,'en',' wanderbrief cityguides curated by local nomads '),
	(2,'field',12,'en',' wanderbrief city guides help you plan the perfect remote working trip with information on the best coffee internet speed co working spaces local adventures and meetups with like minded nomads across the city '),
	(2,'field',39,'en',''),
	(6,'field',1,'en',''),
	(6,'field',34,'en',''),
	(6,'field',43,'en',''),
	(6,'filename',0,'en',' 1899 jpg '),
	(6,'extension',0,'en',' jpg '),
	(6,'kind',0,'en',' image '),
	(6,'slug',0,'en',' 1899 '),
	(6,'title',0,'en',' 1899 '),
	(4,'field',62,'en',''),
	(4,'field',64,'en',' 0 '),
	(4,'field',71,'en',' iamsterdam '),
	(4,'field',73,'en',''),
	(4,'field',72,'en',' http www iamsterdam com fr visiter '),
	(4,'field',74,'en',''),
	(4,'field',75,'en',' 2017 06 04 '),
	(4,'field',76,'en',' 2017 06 18 '),
	(4,'field',77,'en',' 1 ');



# Affichage de la table guide_sections
# ------------------------------------------------------------


CREATE TABLE `guide_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('single','channel','structure') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'channel',
  `hasUrls` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `template` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enableVersioning` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_sections_name_unq_idx` (`name`),
  UNIQUE KEY `guide_sections_handle_unq_idx` (`handle`),
  KEY `guide_sections_structureId_fk` (`structureId`),
  CONSTRAINT `guide_sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `guide_structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_sections` (`id`, `structureId`, `name`, `handle`, `type`, `hasUrls`, `template`, `enableVersioning`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,NULL,'Homepage','homepage','single',1,'index',1,'2017-06-05 15:46:30','2017-06-05 15:46:30','1550d8ed-4cea-41a0-850a-351bcba7de14'),
	(3,NULL,'Gears','gears','channel',1,'gears/_entry',1,'2017-06-05 15:47:44','2017-06-05 15:47:44','b18d3387-88b8-4671-8c76-7021b0b281eb'),
	(4,NULL,'Cities','cities','channel',1,'cities/_entry',1,'2017-06-05 15:48:17','2017-06-05 15:48:17','8fff3934-df58-4bf1-b419-f91870ccb45b'),
	(5,NULL,'Neighborhoods','neighborhoods','channel',1,'neighborhoods/_entry',1,'2017-06-05 15:48:51','2017-06-05 15:48:51','d57b85c4-c38d-48bc-9219-d667e6b2b6cf'),
	(6,NULL,'Food places','foodPlaces','channel',1,'places/_entry',1,'2017-06-05 16:45:52','2017-06-05 16:45:52','e802250c-a72d-4b26-8515-153746e14935'),
	(7,NULL,'Drink places','drinkPlaces','channel',1,'places/_entry',1,'2017-06-05 16:46:19','2017-06-05 16:46:19','61d7550d-e4f5-4f7a-8bb2-c878b89b35fe'),
	(8,NULL,'Working places','workingPlaces','channel',1,'places/_entry',1,'2017-06-05 16:47:18','2017-06-05 16:48:06','53c8236e-818a-4db8-8283-4abb7ad5d1b1'),
	(9,NULL,'Living places','livingPlaces','channel',1,'places/_entry',1,'2017-06-05 16:47:56','2017-06-05 16:47:56','3ef41bfc-cb33-40fb-83c4-816db58c4cdc');



# Affichage de la table guide_sections_i18n
# ------------------------------------------------------------


CREATE TABLE `guide_sections_i18n` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `enabledByDefault` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `urlFormat` text COLLATE utf8_unicode_ci,
  `nestedUrlFormat` text COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_sections_i18n_sectionId_locale_unq_idx` (`sectionId`,`locale`),
  KEY `guide_sections_i18n_locale_fk` (`locale`),
  CONSTRAINT `guide_sections_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `guide_sections_i18n_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `guide_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_sections_i18n` (`id`, `sectionId`, `locale`, `enabledByDefault`, `urlFormat`, `nestedUrlFormat`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'en',1,'__home__',NULL,'2017-06-05 15:46:30','2017-06-05 15:46:30','ec328f81-4719-4d9d-9b3f-cfc93ca8da83'),
	(3,3,'en',0,'gears/{slug}',NULL,'2017-06-05 15:47:44','2017-06-05 15:47:44','8ef56370-80da-41ca-9875-6a35b75e580c'),
	(4,4,'en',0,'cities/{slug}',NULL,'2017-06-05 15:48:17','2017-06-05 15:48:17','d7b86bcc-2105-46b5-886f-83177410ba40'),
	(5,5,'en',0,'neighborhoods/{slug}',NULL,'2017-06-05 15:48:51','2017-06-05 15:48:51','a1c13ab8-fecc-4b80-a2a1-ec0637887263'),
	(6,6,'en',1,'places/food/{slug}',NULL,'2017-06-05 16:45:52','2017-06-05 16:45:52','71ea6380-6517-42f6-a48f-d855002ce723'),
	(7,7,'en',0,'places/drink/{slug}',NULL,'2017-06-05 16:46:19','2017-06-05 16:46:19','4bff8845-f9f4-4140-9f40-bdf5a2270561'),
	(8,8,'en',0,'places/working/{slug}',NULL,'2017-06-05 16:47:18','2017-06-05 16:48:06','a1a9149c-9bca-48bd-aabb-e5e5aa29972e'),
	(9,9,'en',0,'places/living/{slug}',NULL,'2017-06-05 16:47:56','2017-06-05 16:47:56','9b11a4b3-06ad-4cba-ab65-602a23ed12f9');



# Affichage de la table guide_shunnedmessages
# ------------------------------------------------------------


CREATE TABLE `guide_shunnedmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_shunnedmessages_userId_message_unq_idx` (`userId`,`message`),
  CONSTRAINT `guide_shunnedmessages_userId_fk` FOREIGN KEY (`userId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_structureelements
# ------------------------------------------------------------


CREATE TABLE `guide_structureelements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `elementId` int(11) DEFAULT NULL,
  `root` int(11) unsigned DEFAULT NULL,
  `lft` int(11) unsigned NOT NULL,
  `rgt` int(11) unsigned NOT NULL,
  `level` smallint(6) unsigned NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_structureelements_structureId_elementId_unq_idx` (`structureId`,`elementId`),
  KEY `guide_structureelements_root_idx` (`root`),
  KEY `guide_structureelements_lft_idx` (`lft`),
  KEY `guide_structureelements_rgt_idx` (`rgt`),
  KEY `guide_structureelements_level_idx` (`level`),
  KEY `guide_structureelements_elementId_fk` (`elementId`),
  CONSTRAINT `guide_structureelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_structureelements_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `guide_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_structures
# ------------------------------------------------------------


CREATE TABLE `guide_structures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maxLevels` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_structures` (`id`, `maxLevels`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'2017-06-05 18:56:37','2017-06-05 18:56:37','0e13c8c5-e39a-4ac6-a8af-42451a4e36a6');



# Affichage de la table guide_systemsettings
# ------------------------------------------------------------


CREATE TABLE `guide_systemsettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_systemsettings_category_unq_idx` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_systemsettings` (`id`, `category`, `settings`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'email','{\"protocol\":\"php\",\"emailAddress\":\"cguillou@wanderbrief.com\",\"senderName\":\"Wanderbrief Guides\"}','2017-06-05 15:46:30','2017-06-05 15:46:30','1fc1811f-87f8-43a7-97ae-6c45c3f9a146');



# Affichage de la table guide_taggroups
# ------------------------------------------------------------


CREATE TABLE `guide_taggroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fieldLayoutId` int(10) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_taggroups_name_unq_idx` (`name`),
  UNIQUE KEY `guide_taggroups_handle_unq_idx` (`handle`),
  KEY `guide_taggroups_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `guide_taggroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `guide_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_taggroups` (`id`, `name`, `handle`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,'Default','default',1,'2017-06-05 15:46:30','2017-06-05 15:46:30','cf01fa5d-4085-45d6-b503-f87fb69e038e'),
	(2,'Neighborhoods','neighborhoods',28,'2017-06-05 18:47:55','2017-06-05 18:47:55','161840e0-e254-4e0c-84a5-911a2ea12a3c'),
	(3,'Cities','cities',29,'2017-06-05 18:48:02','2017-06-05 18:48:02','d51fad02-b570-4acb-bbef-9233d063f3f5'),
	(4,'Medias','medias',30,'2017-06-05 18:49:48','2017-06-05 18:49:48','373030e8-0508-4aa5-bc53-9a503ec0dbdd'),
	(5,'Places','places',40,'2017-06-05 19:11:01','2017-06-05 19:11:01','18e81320-4ee7-4e49-979b-2df090f6a76f');



# Affichage de la table guide_tags
# ------------------------------------------------------------


CREATE TABLE `guide_tags` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_tags_groupId_fk` (`groupId`),
  CONSTRAINT `guide_tags_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_taggroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_tags_id_fk` FOREIGN KEY (`id`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_tasks
# ------------------------------------------------------------


CREATE TABLE `guide_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `root` int(11) unsigned DEFAULT NULL,
  `lft` int(11) unsigned NOT NULL,
  `rgt` int(11) unsigned NOT NULL,
  `level` smallint(6) unsigned NOT NULL,
  `currentStep` int(11) unsigned DEFAULT NULL,
  `totalSteps` int(11) unsigned DEFAULT NULL,
  `status` enum('pending','error','running') COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `settings` mediumtext COLLATE utf8_unicode_ci,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_tasks_root_idx` (`root`),
  KEY `guide_tasks_lft_idx` (`lft`),
  KEY `guide_tasks_rgt_idx` (`rgt`),
  KEY `guide_tasks_level_idx` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_templatecachecriteria
# ------------------------------------------------------------


CREATE TABLE `guide_templatecachecriteria` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheId` int(11) NOT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `criteria` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `guide_templatecachecriteria_cacheId_fk` (`cacheId`),
  KEY `guide_templatecachecriteria_type_idx` (`type`),
  CONSTRAINT `guide_templatecachecriteria_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `guide_templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_templatecacheelements
# ------------------------------------------------------------


CREATE TABLE `guide_templatecacheelements` (
  `cacheId` int(11) NOT NULL,
  `elementId` int(11) NOT NULL,
  KEY `guide_templatecacheelements_cacheId_fk` (`cacheId`),
  KEY `guide_templatecacheelements_elementId_fk` (`elementId`),
  CONSTRAINT `guide_templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `guide_templatecaches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `guide_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_templatecaches
# ------------------------------------------------------------


CREATE TABLE `guide_templatecaches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expiryDate` datetime NOT NULL,
  `body` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `guide_templatecaches_expiryDate_cacheKey_locale_path_idx` (`expiryDate`,`cacheKey`,`locale`,`path`),
  KEY `guide_templatecaches_locale_fk` (`locale`),
  CONSTRAINT `guide_templatecaches_locale_fk` FOREIGN KEY (`locale`) REFERENCES `guide_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_usergroups
# ------------------------------------------------------------


CREATE TABLE `guide_usergroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_usergroups_name_unq_idx` (`name`),
  UNIQUE KEY `guide_usergroups_handle_unq_idx` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_usergroups_users
# ------------------------------------------------------------


CREATE TABLE `guide_usergroups_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_usergroups_users_groupId_userId_unq_idx` (`groupId`,`userId`),
  KEY `guide_usergroups_users_userId_fk` (`userId`),
  CONSTRAINT `guide_usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_userpermissions
# ------------------------------------------------------------


CREATE TABLE `guide_userpermissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_userpermissions_name_unq_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_userpermissions_usergroups
# ------------------------------------------------------------


CREATE TABLE `guide_userpermissions_usergroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_userpermissions_usergroups_permissionId_groupId_unq_idx` (`permissionId`,`groupId`),
  KEY `guide_userpermissions_usergroups_groupId_fk` (`groupId`),
  CONSTRAINT `guide_userpermissions_usergroups_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `guide_usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_userpermissions_usergroups_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `guide_userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Affichage de la table guide_userpermissions_users
# ------------------------------------------------------------


CREATE TABLE `guide_userpermissions_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `guide_userpermissions_users_permissionId_userId_unq_idx` (`permissionId`,`userId`),
  KEY `guide_userpermissions_users_userId_fk` (`userId`),
  CONSTRAINT `guide_userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `guide_userpermissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `guide_userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


# Affichage de la table guide_widgets
# ------------------------------------------------------------


CREATE TABLE `guide_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `colspan` tinyint(4) unsigned DEFAULT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guide_widgets_userId_fk` (`userId`),
  CONSTRAINT `guide_widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `guide_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `guide_widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
	(1,1,'RecentEntries',2,4,NULL,1,'2017-06-05 15:46:34','2017-06-05 19:39:16','6adbe497-fe2f-4b08-aca6-73a8c7b1b8cb'),
	(2,1,'GetHelp',3,4,NULL,1,'2017-06-05 15:46:34','2017-06-05 19:39:16','c051b884-2e81-4cda-89cb-06189d5615bf'),
	(3,1,'Updates',1,4,NULL,1,'2017-06-05 15:46:34','2017-06-05 19:39:16','82331f73-298c-4523-8ec8-5ceebbfd12fa'),
	(4,1,'Feed',4,NULL,'{\"url\":\"https:\\/\\/craftcms.com\\/news.rss\",\"title\":\"Craft News\"}',0,'2017-06-05 15:46:34','2017-06-05 19:38:53','851e38d2-e071-414d-86f3-d36a480543b1');




