text: -- Generated by Craft v2.6.3013 on 6 Apr 2018 14:04:40.
  
  --
  -- Disable foreign key checks and autocommit.
  --
  
  SET FOREIGN_KEY_CHECKS = 0;
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  SET NAMES utf8;
  
  
  DROP TABLE IF EXISTS `craft_assetfiles`;
  
  
  --
  -- Schema for table `craft_assetfiles`
  --
  CREATE TABLE `craft_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 `craft_assetfiles_filename_folderId_unq_idx` (`filename`,`folderId`),
    KEY `craft_assetfiles_sourceId_fk` (`sourceId`),
    KEY `craft_assetfiles_folderId_fk` (`folderId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_assetfolders`;
  
  
  --
  -- Schema for table `craft_assetfolders`
  --
  CREATE TABLE `craft_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 `craft_assetfolders_name_parentId_sourceId_unq_idx` (`name`,`parentId`,`sourceId`),
    KEY `craft_assetfolders_parentId_fk` (`parentId`),
    KEY `craft_assetfolders_sourceId_fk` (`sourceId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_assetindexdata`;
  
  
  --
  -- Schema for table `craft_assetindexdata`
  --
  CREATE TABLE `craft_assetindexdata` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sessionId` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    `sourceId` int(10) NOT NULL,
    `offset` int(10) NOT NULL,
    `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `recordId` 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 `craft_assetindexdata_sessionId_sourceId_offset_unq_idx` (`sessionId`,`sourceId`,`offset`),
    KEY `craft_assetindexdata_sourceId_fk` (`sourceId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_assetsources`;
  
  
  --
  -- Schema for table `craft_assetsources`
  --
  CREATE TABLE `craft_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 `craft_assetsources_name_unq_idx` (`name`),
    UNIQUE KEY `craft_assetsources_handle_unq_idx` (`handle`),
    KEY `craft_assetsources_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_assettransformindex`;
  
  
  --
  -- Schema for table `craft_assettransformindex`
  --
  CREATE TABLE `craft_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 `craft_assettransformindex_sourceId_fileId_location_idx` (`sourceId`,`fileId`,`location`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_assettransforms`;
  
  
  --
  -- Schema for table `craft_assettransforms`
  --
  CREATE TABLE `craft_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 `craft_assettransforms_name_unq_idx` (`name`),
    UNIQUE KEY `craft_assettransforms_handle_unq_idx` (`handle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_categories`;
  
  
  --
  -- Schema for table `craft_categories`
  --
  CREATE TABLE `craft_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 `craft_categories_groupId_fk` (`groupId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_categorygroups`;
  
  
  --
  -- Schema for table `craft_categorygroups`
  --
  CREATE TABLE `craft_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 `craft_categorygroups_name_unq_idx` (`name`),
    UNIQUE KEY `craft_categorygroups_handle_unq_idx` (`handle`),
    KEY `craft_categorygroups_structureId_fk` (`structureId`),
    KEY `craft_categorygroups_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_categorygroups_i18n`;
  
  
  --
  -- Schema for table `craft_categorygroups_i18n`
  --
  CREATE TABLE `craft_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 `craft_categorygroups_i18n_groupId_locale_unq_idx` (`groupId`,`locale`),
    KEY `craft_categorygroups_i18n_locale_fk` (`locale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_content`;
  
  
  --
  -- Schema for table `craft_content`
  --
  CREATE TABLE `craft_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,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `craft_content_elementId_locale_unq_idx` (`elementId`,`locale`),
    KEY `craft_content_title_idx` (`title`),
    KEY `craft_content_locale_fk` (`locale`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_content`
  --
  
  INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '1', 'en_gb', NULL, NULL, '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'a0783ed6-2d72-4a32-a4b1-4019f2c35c14'),
   ('2', '2', 'en_gb', 'Homepage', NULL, '2018-04-01 16:46:30', '2018-04-01 16:46:30', '0d86aede-73e1-4826-865b-c2e0d2bbc9be');
  
  
  
  DROP TABLE IF EXISTS `craft_deprecationerrors`;
  
  
  --
  -- Schema for table `craft_deprecationerrors`
  --
  CREATE TABLE `craft_deprecationerrors` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `fingerprint` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `lastOccurrence` datetime NOT NULL,
    `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `line` smallint(6) unsigned NOT NULL,
    `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `templateLine` smallint(6) unsigned DEFAULT NULL,
    `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `traces` 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 `craft_deprecationerrors_key_fingerprint_unq_idx` (`key`,`fingerprint`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_elementindexsettings`;
  
  
  --
  -- Schema for table `craft_elementindexsettings`
  --
  CREATE TABLE `craft_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 `craft_elementindexsettings_type_unq_idx` (`type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_elements`;
  
  
  --
  -- Schema for table `craft_elements`
  --
  CREATE TABLE `craft_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 `craft_elements_type_idx` (`type`),
    KEY `craft_elements_enabled_idx` (`enabled`),
    KEY `craft_elements_archived_dateCreated_idx` (`archived`,`dateCreated`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_elements`
  --
  
  INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'User', '1', '0', '2018-04-01 16:46:29', '2018-04-01 16:46:29', '0113e584-01d0-40c2-8627-5d1cc0a8e983'),
   ('2', 'Entry', '1', '0', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '72ef9541-4b80-42e8-9e54-98de3fbcaba0');
  
  
  
  DROP TABLE IF EXISTS `craft_elements_i18n`;
  
  
  --
  -- Schema for table `craft_elements_i18n`
  --
  CREATE TABLE `craft_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 `craft_elements_i18n_elementId_locale_unq_idx` (`elementId`,`locale`),
    UNIQUE KEY `craft_elements_i18n_uri_locale_unq_idx` (`uri`,`locale`),
    KEY `craft_elements_i18n_slug_locale_idx` (`slug`,`locale`),
    KEY `craft_elements_i18n_enabled_idx` (`enabled`),
    KEY `craft_elements_i18n_locale_fk` (`locale`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_elements_i18n`
  --
  
  INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '1', 'en_gb', '', NULL, '1', '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'd57620ae-adc2-4bb5-87c4-985b0f0f5206'),
   ('2', '2', 'en_gb', 'homepage', '__home__', '1', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '67b6a825-aad5-473d-9fe9-e3aa4f812634');
  
  
  
  DROP TABLE IF EXISTS `craft_emailmessages`;
  
  
  --
  -- Schema for table `craft_emailmessages`
  --
  CREATE TABLE `craft_emailmessages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key` char(150) COLLATE utf8_unicode_ci NOT NULL,
    `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
    `subject` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
    `body` text 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 `craft_emailmessages_key_locale_unq_idx` (`key`,`locale`),
    KEY `craft_emailmessages_locale_fk` (`locale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_entries`;
  
  
  --
  -- Schema for table `craft_entries`
  --
  CREATE TABLE `craft_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 `craft_entries_sectionId_idx` (`sectionId`),
    KEY `craft_entries_typeId_idx` (`typeId`),
    KEY `craft_entries_postDate_idx` (`postDate`),
    KEY `craft_entries_expiryDate_idx` (`expiryDate`),
    KEY `craft_entries_authorId_fk` (`authorId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_entries`
  --
  
  INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('2', '1', NULL, NULL, '2018-04-01 16:46:30', NULL, '2018-04-01 16:46:30', '2018-04-01 16:46:30', '4575548d-8ead-4e6c-b102-9c5106fd6e62');
  
  
  
  DROP TABLE IF EXISTS `craft_entrydrafts`;
  
  
  --
  -- Schema for table `craft_entrydrafts`
  --
  CREATE TABLE `craft_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 `craft_entrydrafts_entryId_locale_idx` (`entryId`,`locale`),
    KEY `craft_entrydrafts_sectionId_fk` (`sectionId`),
    KEY `craft_entrydrafts_creatorId_fk` (`creatorId`),
    KEY `craft_entrydrafts_locale_fk` (`locale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_entrytypes`;
  
  
  --
  -- Schema for table `craft_entrytypes`
  --
  CREATE TABLE `craft_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 `craft_entrytypes_name_sectionId_unq_idx` (`name`,`sectionId`),
    UNIQUE KEY `craft_entrytypes_handle_sectionId_unq_idx` (`handle`,`sectionId`),
    KEY `craft_entrytypes_sectionId_fk` (`sectionId`),
    KEY `craft_entrytypes_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_entrytypes`
  --
  
  INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '1', '3', 'Homepage', 'homepage', '1', 'Title', NULL, '1', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '74ddf15b-377e-465b-bb21-896dc6f38b2f');
  
  
  
  DROP TABLE IF EXISTS `craft_entryversions`;
  
  
  --
  -- Schema for table `craft_entryversions`
  --
  CREATE TABLE `craft_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 `craft_entryversions_entryId_locale_idx` (`entryId`,`locale`),
    KEY `craft_entryversions_sectionId_fk` (`sectionId`),
    KEY `craft_entryversions_creatorId_fk` (`creatorId`),
    KEY `craft_entryversions_locale_fk` (`locale`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_entryversions`
  --
  
  INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '2', '1', '1', 'en_gb', '1', NULL, '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1522601190,\"expiryDate\":null,\"enabled\":1,\"parentId\":null,\"fields\":[]}', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '8bda1af8-72a1-4db7-a69f-c948731809d6');
  
  
  
  DROP TABLE IF EXISTS `craft_fieldgroups`;
  
  
  --
  -- Schema for table `craft_fieldgroups`
  --
  CREATE TABLE `craft_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 `craft_fieldgroups_name_unq_idx` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_fieldgroups`
  --
  
  INSERT INTO `craft_fieldgroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'Default', '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'f035f57c-9afe-430e-9571-4396829c6f21');
  
  
  
  DROP TABLE IF EXISTS `craft_fieldlayoutfields`;
  
  
  --
  -- Schema for table `craft_fieldlayoutfields`
  --
  CREATE TABLE `craft_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 `craft_fieldlayoutfields_layoutId_fieldId_unq_idx` (`layoutId`,`fieldId`),
    KEY `craft_fieldlayoutfields_sortOrder_idx` (`sortOrder`),
    KEY `craft_fieldlayoutfields_tabId_fk` (`tabId`),
    KEY `craft_fieldlayoutfields_fieldId_fk` (`fieldId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_fieldlayoutfields`
  --
  
  INSERT INTO `craft_fieldlayoutfields` (`id`, `layoutId`, `tabId`, `fieldId`, `required`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '3', '1', '1', '1', '1', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '72265ce3-3b13-4931-bcf4-295b22fa8bd0');
  
  
  
  DROP TABLE IF EXISTS `craft_fieldlayouts`;
  
  
  --
  -- Schema for table `craft_fieldlayouts`
  --
  CREATE TABLE `craft_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 `craft_fieldlayouts_type_idx` (`type`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_fieldlayouts`
  --
  
  INSERT INTO `craft_fieldlayouts` (`id`, `type`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'Tag', '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'd67a485b-e53f-4e3c-857d-892e6823927d'),
   ('3', 'Entry', '2018-04-01 16:46:30', '2018-04-01 16:46:30', 'd319bb84-00b8-40af-866a-46f695c4d671');
  
  
  
  DROP TABLE IF EXISTS `craft_fieldlayouttabs`;
  
  
  --
  -- Schema for table `craft_fieldlayouttabs`
  --
  CREATE TABLE `craft_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 `craft_fieldlayouttabs_sortOrder_idx` (`sortOrder`),
    KEY `craft_fieldlayouttabs_layoutId_fk` (`layoutId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_fieldlayouttabs`
  --
  
  INSERT INTO `craft_fieldlayouttabs` (`id`, `layoutId`, `name`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '3', 'Content', '1', '2018-04-01 16:46:30', '2018-04-01 16:46:30', 'bb618315-3ae6-4c76-a4df-0ecd560c2c04');
  
  
  
  DROP TABLE IF EXISTS `craft_fields`;
  
  
  --
  -- Schema for table `craft_fields`
  --
  CREATE TABLE `craft_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 `craft_fields_handle_context_unq_idx` (`handle`,`context`),
    KEY `craft_fields_context_idx` (`context`),
    KEY `craft_fields_groupId_fk` (`groupId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_fields`
  --
  
  INSERT INTO `craft_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\"}', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '2386e2e0-d3e8-4677-9e9c-6f77c32a3985'),
   ('2', '1', 'Tags', 'tags', 'global', NULL, '0', 'Tags', '{\"source\":\"taggroup:1\"}', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '7b7df2d2-a569-4764-916f-029835bc32f9');
  
  
  
  DROP TABLE IF EXISTS `craft_globalsets`;
  
  
  --
  -- Schema for table `craft_globalsets`
  --
  CREATE TABLE `craft_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 `craft_globalsets_name_unq_idx` (`name`),
    UNIQUE KEY `craft_globalsets_handle_unq_idx` (`handle`),
    KEY `craft_globalsets_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_info`;
  
  
  --
  -- Schema for table `craft_info`
  --
  CREATE TABLE `craft_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_info`
  --
  
  INSERT INTO `craft_info` (`id`, `version`, `schemaVersion`, `edition`, `siteName`, `siteUrl`, `timezone`, `on`, `maintenance`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '2.6.3013', '2.6.13', '0', 'Craft', 'http://craft.test', 'UTC', '1', '1', '2018-04-01 16:46:28', '2018-04-06 14:04:39', 'df601fba-a06a-4d5f-9ca8-edfbcf9f2774');
  
  
  
  DROP TABLE IF EXISTS `craft_locales`;
  
  
  --
  -- Schema for table `craft_locales`
  --
  CREATE TABLE `craft_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 `craft_locales_sortOrder_idx` (`sortOrder`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_locales`
  --
  
  INSERT INTO `craft_locales` (`locale`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('en_gb', '1', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '224dee3b-cdec-459d-8932-ee1272a8fde0');
  
  
  
  DROP TABLE IF EXISTS `craft_matrixblocks`;
  
  
  --
  -- Schema for table `craft_matrixblocks`
  --
  CREATE TABLE `craft_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 `craft_matrixblocks_ownerId_idx` (`ownerId`),
    KEY `craft_matrixblocks_fieldId_idx` (`fieldId`),
    KEY `craft_matrixblocks_typeId_idx` (`typeId`),
    KEY `craft_matrixblocks_sortOrder_idx` (`sortOrder`),
    KEY `craft_matrixblocks_ownerLocale_fk` (`ownerLocale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_matrixblocktypes`;
  
  
  --
  -- Schema for table `craft_matrixblocktypes`
  --
  CREATE TABLE `craft_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 `craft_matrixblocktypes_name_fieldId_unq_idx` (`name`,`fieldId`),
    UNIQUE KEY `craft_matrixblocktypes_handle_fieldId_unq_idx` (`handle`,`fieldId`),
    KEY `craft_matrixblocktypes_fieldId_fk` (`fieldId`),
    KEY `craft_matrixblocktypes_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_migrations`;
  
  
  --
  -- Schema for table `craft_migrations`
  --
  CREATE TABLE `craft_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 `craft_migrations_version_unq_idx` (`version`),
    KEY `craft_migrations_pluginId_fk` (`pluginId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_migrations`
  --
  
  INSERT INTO `craft_migrations` (`id`, `pluginId`, `version`, `applyTime`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', NULL, 'm000000_000000_base', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '292052bf-c55d-4269-b425-33b5cd2cd9a1'),
   ('2', NULL, 'm140730_000001_add_filename_and_format_to_transformindex', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'a30a1589-5dc2-4069-8387-9fd56af0b4fa'),
   ('3', NULL, 'm140815_000001_add_format_to_transforms', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '11d25bba-7707-4039-a287-6895d948d4eb'),
   ('4', NULL, 'm140822_000001_allow_more_than_128_items_per_field', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '0cf3226f-ede7-4202-8b2a-af55d5481720'),
   ('5', NULL, 'm140829_000001_single_title_formats', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'b9025988-a736-4bf5-aaab-c0bdfb58a6c3'),
   ('6', NULL, 'm140831_000001_extended_cache_keys', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'b45164b5-4d05-4ae9-a9dd-f10ec5c3493e'),
   ('7', NULL, 'm140922_000001_delete_orphaned_matrix_blocks', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'a4ad0d43-1f5b-4cf3-b7dd-c1268b0bd9ea'),
   ('8', NULL, 'm141008_000001_elements_index_tune', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '3a3f5316-5255-4c9b-9039-a3d8b04905be'),
   ('9', NULL, 'm141009_000001_assets_source_handle', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '35b77ae8-6668-42b4-8cd0-b08639193b8f'),
   ('10', NULL, 'm141024_000001_field_layout_tabs', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2622600b-2b34-42fb-b541-99ceda4cc782'),
   ('11', NULL, 'm141030_000000_plugin_schema_versions', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '3f06b427-abb7-4db3-b152-e547d9aca6df'),
   ('12', NULL, 'm141030_000001_drop_structure_move_permission', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'f1a03e01-e547-45c1-a900-b036d0ac637b'),
   ('13', NULL, 'm141103_000001_tag_titles', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'addaf807-a15c-4c45-840d-3457a2463448'),
   ('14', NULL, 'm141109_000001_user_status_shuffle', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'bbe930ac-cf23-44c6-9eee-a2cd3d101777'),
   ('15', NULL, 'm141126_000001_user_week_start_day', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'ed2ed7e4-a944-408a-a67a-39e27183806e'),
   ('16', NULL, 'm150210_000001_adjust_user_photo_size', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'c038de1f-ce45-4d18-82d6-c2e4d1e66c76'),
   ('17', NULL, 'm150724_000001_adjust_quality_settings', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '1283becb-dec1-4bfc-966f-2212f8e4bf2a'),
   ('18', NULL, 'm150827_000000_element_index_settings', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '57bb9429-7a4b-4707-b737-211b9336a2c6'),
   ('19', NULL, 'm150918_000001_add_colspan_to_widgets', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '11441e5b-043d-4b86-acc6-83cdb292ef1d'),
   ('20', NULL, 'm151007_000000_clear_asset_caches', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'ef16fa26-f618-439e-be88-e6a20b17ec6e'),
   ('21', NULL, 'm151109_000000_text_url_formats', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '275ff99d-3f00-40c5-b0f0-a61f5fb939c2'),
   ('22', NULL, 'm151110_000000_move_logo', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '1d890ea4-d64c-4492-a78d-43132030fe74'),
   ('23', NULL, 'm151117_000000_adjust_image_widthheight', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '4189b6b7-5640-4fcf-bc0e-10e1386db4ff'),
   ('24', NULL, 'm151127_000000_clear_license_key_status', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '6ca61f56-dbe1-4460-8472-c008cd87b2b5'),
   ('25', NULL, 'm151127_000000_plugin_license_keys', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '489a241e-2b16-4116-b55f-87e1e9201a15'),
   ('26', NULL, 'm151130_000000_update_pt_widget_feeds', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '3fd2f314-229c-4821-a252-5dbb4b69cb14'),
   ('27', NULL, 'm160114_000000_asset_sources_public_url_default_true', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'e9dc9795-1b2e-4b78-b957-4ba2d80fcb50'),
   ('28', NULL, 'm160223_000000_sortorder_to_smallint', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '16b3b8a1-ed67-4b32-9e75-c940faf0fd31'),
   ('29', NULL, 'm160229_000000_set_default_entry_statuses', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '6b30e18f-f62d-42f4-849b-02485ba16435'),
   ('30', NULL, 'm160304_000000_client_permissions', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '3b528f15-f39e-46e9-9a12-08debf4aa8ab'),
   ('31', NULL, 'm160322_000000_asset_filesize', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '028840be-1440-470f-8486-b5ac5343dbf6'),
   ('32', NULL, 'm160503_000000_orphaned_fieldlayouts', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '99ef4231-a7e8-4a28-b182-319f55d4a583'),
   ('33', NULL, 'm160510_000000_tasksettings', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '309e2dd6-b374-41a0-a250-37a15e90f294'),
   ('34', NULL, 'm160829_000000_pending_user_content_cleanup', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '258f4182-837f-4393-a6c3-ce486b93043b'),
   ('35', NULL, 'm160830_000000_asset_index_uri_increase', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '011a7b56-529c-4791-b93f-66373c34797a'),
   ('36', NULL, 'm160919_000000_usergroup_handle_title_unique', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '1afe46e4-14e3-4790-ac58-dce719aeacae'),
   ('37', NULL, 'm161108_000000_new_version_format', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '15e3fac1-5d1a-4d14-9a56-4fd413f20f32'),
   ('38', NULL, 'm161109_000000_index_shuffle', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'f3a48f70-7ae2-4da0-a78b-7817b8055c72'),
   ('39', NULL, 'm170612_000000_route_index_shuffle', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', 'cdda03ee-5e66-45b7-8317-f58b7a77c0d1'),
   ('40', NULL, 'm171107_000000_assign_group_permissions', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '066ef8cc-9e6e-47a6-80c3-367d7d40004c'),
   ('41', NULL, 'm171117_000001_templatecache_index_tune', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '353c1862-a135-46a0-bbda-7eb9758e4755'),
   ('42', NULL, 'm171204_000001_templatecache_index_tune_deux', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '2018-04-01 16:46:28', '8d2b5be7-27c6-4d53-8b01-7256471e960c');
  
  
  
  DROP TABLE IF EXISTS `craft_plugins`;
  
  
  --
  -- Schema for table `craft_plugins`
  --
  CREATE TABLE `craft_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;
  
  DROP TABLE IF EXISTS `craft_rackspaceaccess`;
  
  
  --
  -- Schema for table `craft_rackspaceaccess`
  --
  CREATE TABLE `craft_rackspaceaccess` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `connectionKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `storageUrl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `cdnUrl` 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 `craft_rackspaceaccess_connectionKey_unq_idx` (`connectionKey`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_relations`;
  
  
  --
  -- Schema for table `craft_relations`
  --
  CREATE TABLE `craft_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 `craft_relations_fieldId_sourceId_sourceLocale_targetId_unq_idx` (`fieldId`,`sourceId`,`sourceLocale`,`targetId`),
    KEY `craft_relations_sourceId_fk` (`sourceId`),
    KEY `craft_relations_sourceLocale_fk` (`sourceLocale`),
    KEY `craft_relations_targetId_fk` (`targetId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_routes`;
  
  
  --
  -- Schema for table `craft_routes`
  --
  CREATE TABLE `craft_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`),
    KEY `craft_routes_locale_idx` (`locale`),
    KEY `craft_routes_urlPattern_idx` (`urlPattern`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_searchindex`;
  
  
  --
  -- Schema for table `craft_searchindex`
  --
  CREATE TABLE `craft_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 `craft_searchindex_keywords_idx` (`keywords`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_searchindex`
  --
  
  INSERT INTO `craft_searchindex` (`elementId`, `attribute`, `fieldId`, `locale`, `keywords`) VALUES
   ('1', 'username', '0', 'en_gb', ' glynnsmith '),
   ('1', 'firstname', '0', 'en_gb', ''),
   ('1', 'lastname', '0', 'en_gb', ''),
   ('1', 'fullname', '0', 'en_gb', ''),
   ('1', 'email', '0', 'en_gb', ' glynn smith gmail com '),
   ('1', 'slug', '0', 'en_gb', ''),
   ('2', 'slug', '0', 'en_gb', ' homepage '),
   ('2', 'title', '0', 'en_gb', ' homepage ');
  
  
  
  DROP TABLE IF EXISTS `craft_sections`;
  
  
  --
  -- Schema for table `craft_sections`
  --
  CREATE TABLE `craft_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 `craft_sections_name_unq_idx` (`name`),
    UNIQUE KEY `craft_sections_handle_unq_idx` (`handle`),
    KEY `craft_sections_structureId_fk` (`structureId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_sections`
  --
  
  INSERT INTO `craft_sections` (`id`, `structureId`, `name`, `handle`, `type`, `hasUrls`, `template`, `enableVersioning`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', NULL, 'Homepage', 'homepage', 'single', '1', 'index', '1', '2018-04-01 16:46:30', '2018-04-01 16:46:30', '41a3a1f2-918d-4ae1-8136-3268d80684ba');
  
  
  
  DROP TABLE IF EXISTS `craft_sections_i18n`;
  
  
  --
  -- Schema for table `craft_sections_i18n`
  --
  CREATE TABLE `craft_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 `craft_sections_i18n_sectionId_locale_unq_idx` (`sectionId`,`locale`),
    KEY `craft_sections_i18n_locale_fk` (`locale`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_sections_i18n`
  --
  
  INSERT INTO `craft_sections_i18n` (`id`, `sectionId`, `locale`, `enabledByDefault`, `urlFormat`, `nestedUrlFormat`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '1', 'en_gb', '1', '__home__', NULL, '2018-04-01 16:46:30', '2018-04-01 16:46:30', '1fbf0086-c0c4-4adb-b21a-d61cdf0bb9ed');
  
  
  
  DROP TABLE IF EXISTS `craft_sessions`;
  
  
  --
  -- Schema for table `craft_sessions`
  --
  CREATE TABLE `craft_sessions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `token` char(100) 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 `craft_sessions_uid_idx` (`uid`),
    KEY `craft_sessions_token_idx` (`token`),
    KEY `craft_sessions_dateUpdated_idx` (`dateUpdated`),
    KEY `craft_sessions_userId_fk` (`userId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_shunnedmessages`;
  
  
  --
  -- Schema for table `craft_shunnedmessages`
  --
  CREATE TABLE `craft_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 `craft_shunnedmessages_userId_message_unq_idx` (`userId`,`message`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_structureelements`;
  
  
  --
  -- Schema for table `craft_structureelements`
  --
  CREATE TABLE `craft_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 `craft_structureelements_structureId_elementId_unq_idx` (`structureId`,`elementId`),
    KEY `craft_structureelements_root_idx` (`root`),
    KEY `craft_structureelements_lft_idx` (`lft`),
    KEY `craft_structureelements_rgt_idx` (`rgt`),
    KEY `craft_structureelements_level_idx` (`level`),
    KEY `craft_structureelements_elementId_fk` (`elementId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_structures`;
  
  
  --
  -- Schema for table `craft_structures`
  --
  CREATE TABLE `craft_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;
  
  DROP TABLE IF EXISTS `craft_systemsettings`;
  
  
  --
  -- Schema for table `craft_systemsettings`
  --
  CREATE TABLE `craft_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 `craft_systemsettings_category_unq_idx` (`category`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_systemsettings`
  --
  
  INSERT INTO `craft_systemsettings` (`id`, `category`, `settings`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'email', '{\"protocol\":\"php\",\"emailAddress\":\"glynn.smith@gmail.com\",\"senderName\":\"Craft\"}', '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'e84fb20e-5e38-49e7-83f9-461a605e6076');
  
  
  
  DROP TABLE IF EXISTS `craft_taggroups`;
  
  
  --
  -- Schema for table `craft_taggroups`
  --
  CREATE TABLE `craft_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 `craft_taggroups_name_unq_idx` (`name`),
    UNIQUE KEY `craft_taggroups_handle_unq_idx` (`handle`),
    KEY `craft_taggroups_fieldLayoutId_fk` (`fieldLayoutId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_taggroups`
  --
  
  INSERT INTO `craft_taggroups` (`id`, `name`, `handle`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'Default', 'default', '1', '2018-04-01 16:46:29', '2018-04-01 16:46:29', 'baf72b42-6f1c-4c30-bc1a-862b860ed07d');
  
  
  
  DROP TABLE IF EXISTS `craft_tags`;
  
  
  --
  -- Schema for table `craft_tags`
  --
  CREATE TABLE `craft_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 `craft_tags_groupId_fk` (`groupId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_tasks`;
  
  
  --
  -- Schema for table `craft_tasks`
  --
  CREATE TABLE `craft_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 `craft_tasks_root_idx` (`root`),
    KEY `craft_tasks_lft_idx` (`lft`),
    KEY `craft_tasks_rgt_idx` (`rgt`),
    KEY `craft_tasks_level_idx` (`level`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_templatecachecriteria`;
  
  
  --
  -- Schema for table `craft_templatecachecriteria`
  --
  CREATE TABLE `craft_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 `craft_templatecachecriteria_cacheId_fk` (`cacheId`),
    KEY `craft_templatecachecriteria_type_idx` (`type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_templatecacheelements`;
  
  
  --
  -- Schema for table `craft_templatecacheelements`
  --
  CREATE TABLE `craft_templatecacheelements` (
    `cacheId` int(11) NOT NULL,
    `elementId` int(11) NOT NULL,
    KEY `craft_templatecacheelements_cacheId_fk` (`cacheId`),
    KEY `craft_templatecacheelements_elementId_fk` (`elementId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_templatecaches`;
  
  
  --
  -- Schema for table `craft_templatecaches`
  --
  CREATE TABLE `craft_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 `craft_templatecaches_cacheKey_locale_expiryDate_path_idx` (`cacheKey`,`locale`,`expiryDate`,`path`),
    KEY `craft_templatecaches_cacheKey_locale_expiryDate_idx` (`cacheKey`,`locale`,`expiryDate`),
    KEY `craft_templatecaches_locale_fk` (`locale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_tokens`;
  
  
  --
  -- Schema for table `craft_tokens`
  --
  CREATE TABLE `craft_tokens` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `token` char(32) COLLATE utf8_unicode_ci NOT NULL,
    `route` text COLLATE utf8_unicode_ci,
    `usageLimit` tinyint(3) unsigned DEFAULT NULL,
    `usageCount` tinyint(3) unsigned DEFAULT NULL,
    `expiryDate` 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 `craft_tokens_token_unq_idx` (`token`),
    KEY `craft_tokens_expiryDate_idx` (`expiryDate`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_usergroups`;
  
  
  --
  -- Schema for table `craft_usergroups`
  --
  CREATE TABLE `craft_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 `craft_usergroups_name_unq_idx` (`name`),
    UNIQUE KEY `craft_usergroups_handle_unq_idx` (`handle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_usergroups_users`;
  
  
  --
  -- Schema for table `craft_usergroups_users`
  --
  CREATE TABLE `craft_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 `craft_usergroups_users_groupId_userId_unq_idx` (`groupId`,`userId`),
    KEY `craft_usergroups_users_userId_fk` (`userId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_userpermissions`;
  
  
  --
  -- Schema for table `craft_userpermissions`
  --
  CREATE TABLE `craft_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 `craft_userpermissions_name_unq_idx` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_userpermissions_usergroups`;
  
  
  --
  -- Schema for table `craft_userpermissions_usergroups`
  --
  CREATE TABLE `craft_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 `craft_userpermissions_usergroups_permissionId_groupId_unq_idx` (`permissionId`,`groupId`),
    KEY `craft_userpermissions_usergroups_groupId_fk` (`groupId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_userpermissions_users`;
  
  
  --
  -- Schema for table `craft_userpermissions_users`
  --
  CREATE TABLE `craft_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 `craft_userpermissions_users_permissionId_userId_unq_idx` (`permissionId`,`userId`),
    KEY `craft_userpermissions_users_userId_fk` (`userId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  DROP TABLE IF EXISTS `craft_users`;
  
  
  --
  -- Schema for table `craft_users`
  --
  CREATE TABLE `craft_users` (
    `id` int(11) NOT NULL,
    `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `photo` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `firstName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `lastName` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` char(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `preferredLocale` char(12) COLLATE utf8_unicode_ci DEFAULT NULL,
    `weekStartDay` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `client` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `suspended` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `pending` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `archived` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `lastLoginDate` datetime DEFAULT NULL,
    `lastLoginAttemptIPAddress` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
    `invalidLoginWindowStart` datetime DEFAULT NULL,
    `invalidLoginCount` tinyint(4) unsigned DEFAULT NULL,
    `lastInvalidLoginDate` datetime DEFAULT NULL,
    `lockoutDate` datetime DEFAULT NULL,
    `verificationCode` char(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `verificationCodeIssuedDate` datetime DEFAULT NULL,
    `unverifiedEmail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `passwordResetRequired` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `lastPasswordChangeDate` 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 `craft_users_username_unq_idx` (`username`),
    UNIQUE KEY `craft_users_email_unq_idx` (`email`),
    KEY `craft_users_verificationCode_idx` (`verificationCode`),
    KEY `craft_users_uid_idx` (`uid`),
    KEY `craft_users_preferredLocale_fk` (`preferredLocale`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_users`
  --
  
  INSERT INTO `craft_users` (`id`, `username`, `photo`, `firstName`, `lastName`, `email`, `password`, `preferredLocale`, `weekStartDay`, `admin`, `client`, `locked`, `suspended`, `pending`, `archived`, `lastLoginDate`, `lastLoginAttemptIPAddress`, `invalidLoginWindowStart`, `invalidLoginCount`, `lastInvalidLoginDate`, `lockoutDate`, `verificationCode`, `verificationCodeIssuedDate`, `unverifiedEmail`, `passwordResetRequired`, `lastPasswordChangeDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', 'glynnsmith', NULL, NULL, NULL, 'glynn.smith@gmail.com', '$2y$13$l25aEHRT9HXWi3W1/263Pea8LSBAT6cFmQzvu.TaTAk5bj8vDh/bS', NULL, '0', '1', '0', '0', '0', '0', '0', '2018-04-02 16:20:43', '192.168.10.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '2018-04-01 16:46:28', '2018-04-01 16:46:29', '2018-04-02 16:20:43', '82d9ee15-16cc-4c16-bc99-506320da35f1');
  
  
  
  DROP TABLE IF EXISTS `craft_widgets`;
  
  
  --
  -- Schema for table `craft_widgets`
  --
  CREATE TABLE `craft_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 `craft_widgets_userId_fk` (`userId`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Data for table `craft_widgets`
  --
  
  INSERT INTO `craft_widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES
   ('1', '1', 'RecentEntries', '1', '1', NULL, '1', '2018-04-01 16:47:26', '2018-04-01 16:47:50', 'eba7a532-cc41-4d5b-a888-94c3283d2607'),
   ('2', '1', 'GetHelp', '2', NULL, NULL, '1', '2018-04-01 16:47:26', '2018-04-01 16:47:26', '6e2f7318-8586-4cf5-abf3-64ef41f9ced0'),
   ('3', '1', 'Updates', '3', NULL, NULL, '1', '2018-04-01 16:47:26', '2018-04-01 16:47:26', '77b0d8f8-73aa-4003-8c07-1a4817294dc3'),
   ('4', '1', 'Feed', '4', NULL, '{\"url\":\"https:\\/\\/craftcms.com\\/news.rss\",\"title\":\"Craft News\"}', '1', '2018-04-01 16:47:26', '2018-04-01 16:47:26', 'd6971f32-bf1b-424f-94ad-5cd61e370a65');
  
  
  --
  -- Constraints for tables
  --
  
  
  --
  -- Constraints for table `craft_assetfiles`
  --
  ALTER TABLE `craft_assetfiles`
  	ADD CONSTRAINT `craft_assetfiles_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `craft_assetfolders` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_assetfiles_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_assetfiles_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_assetsources` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_assetfolders`
  --
  ALTER TABLE `craft_assetfolders`
  	ADD CONSTRAINT `craft_assetfolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_assetfolders` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_assetfolders_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_assetsources` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_assetindexdata`
  --
  ALTER TABLE `craft_assetindexdata`
  	ADD CONSTRAINT `craft_assetindexdata_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_assetsources` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_assetsources`
  --
  ALTER TABLE `craft_assetsources`
  	ADD CONSTRAINT `craft_assetsources_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL;
  
  --
  -- Constraints for table `craft_categories`
  --
  ALTER TABLE `craft_categories`
  	ADD CONSTRAINT `craft_categories_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_categories_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_categorygroups`
  --
  ALTER TABLE `craft_categorygroups`
  	ADD CONSTRAINT `craft_categorygroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  	ADD CONSTRAINT `craft_categorygroups_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_categorygroups_i18n`
  --
  ALTER TABLE `craft_categorygroups_i18n`
  	ADD CONSTRAINT `craft_categorygroups_i18n_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_categorygroups_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_content`
  --
  ALTER TABLE `craft_content`
  	ADD CONSTRAINT `craft_content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_content_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_elements_i18n`
  --
  ALTER TABLE `craft_elements_i18n`
  	ADD CONSTRAINT `craft_elements_i18n_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_elements_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_emailmessages`
  --
  ALTER TABLE `craft_emailmessages`
  	ADD CONSTRAINT `craft_emailmessages_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_entries`
  --
  ALTER TABLE `craft_entries`
  	ADD CONSTRAINT `craft_entries_authorId_fk` FOREIGN KEY (`authorId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entries_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entries_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entries_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_entrytypes` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_entrydrafts`
  --
  ALTER TABLE `craft_entrydrafts`
  	ADD CONSTRAINT `craft_entrydrafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entrydrafts_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entrydrafts_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  	ADD CONSTRAINT `craft_entrydrafts_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_entrytypes`
  --
  ALTER TABLE `craft_entrytypes`
  	ADD CONSTRAINT `craft_entrytypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  	ADD CONSTRAINT `craft_entrytypes_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_entryversions`
  --
  ALTER TABLE `craft_entryversions`
  	ADD CONSTRAINT `craft_entryversions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  	ADD CONSTRAINT `craft_entryversions_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_entryversions_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  	ADD CONSTRAINT `craft_entryversions_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_fieldlayoutfields`
  --
  ALTER TABLE `craft_fieldlayoutfields`
  	ADD CONSTRAINT `craft_fieldlayoutfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_fieldlayoutfields_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_fieldlayoutfields_tabId_fk` FOREIGN KEY (`tabId`) REFERENCES `craft_fieldlayouttabs` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_fieldlayouttabs`
  --
  ALTER TABLE `craft_fieldlayouttabs`
  	ADD CONSTRAINT `craft_fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_fields`
  --
  ALTER TABLE `craft_fields`
  	ADD CONSTRAINT `craft_fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_fieldgroups` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_globalsets`
  --
  ALTER TABLE `craft_globalsets`
  	ADD CONSTRAINT `craft_globalsets_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  	ADD CONSTRAINT `craft_globalsets_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_matrixblocks`
  --
  ALTER TABLE `craft_matrixblocks`
  	ADD CONSTRAINT `craft_matrixblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_matrixblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_matrixblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_matrixblocks_ownerLocale_fk` FOREIGN KEY (`ownerLocale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  	ADD CONSTRAINT `craft_matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_matrixblocktypes` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_matrixblocktypes`
  --
  ALTER TABLE `craft_matrixblocktypes`
  	ADD CONSTRAINT `craft_matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL;
  
  --
  -- Constraints for table `craft_migrations`
  --
  ALTER TABLE `craft_migrations`
  	ADD CONSTRAINT `craft_migrations_pluginId_fk` FOREIGN KEY (`pluginId`) REFERENCES `craft_plugins` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_relations`
  --
  ALTER TABLE `craft_relations`
  	ADD CONSTRAINT `craft_relations_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_relations_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_relations_sourceLocale_fk` FOREIGN KEY (`sourceLocale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  	ADD CONSTRAINT `craft_relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_routes`
  --
  ALTER TABLE `craft_routes`
  	ADD CONSTRAINT `craft_routes_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_sections`
  --
  ALTER TABLE `craft_sections`
  	ADD CONSTRAINT `craft_sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE SET NULL;
  
  --
  -- Constraints for table `craft_sections_i18n`
  --
  ALTER TABLE `craft_sections_i18n`
  	ADD CONSTRAINT `craft_sections_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  	ADD CONSTRAINT `craft_sections_i18n_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_sessions`
  --
  ALTER TABLE `craft_sessions`
  	ADD CONSTRAINT `craft_sessions_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_shunnedmessages`
  --
  ALTER TABLE `craft_shunnedmessages`
  	ADD CONSTRAINT `craft_shunnedmessages_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_structureelements`
  --
  ALTER TABLE `craft_structureelements`
  	ADD CONSTRAINT `craft_structureelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_structureelements_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_taggroups`
  --
  ALTER TABLE `craft_taggroups`
  	ADD CONSTRAINT `craft_taggroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL;
  
  --
  -- Constraints for table `craft_tags`
  --
  ALTER TABLE `craft_tags`
  	ADD CONSTRAINT `craft_tags_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_taggroups` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_tags_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_templatecachecriteria`
  --
  ALTER TABLE `craft_templatecachecriteria`
  	ADD CONSTRAINT `craft_templatecachecriteria_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_templatecacheelements`
  --
  ALTER TABLE `craft_templatecacheelements`
  	ADD CONSTRAINT `craft_templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_templatecaches`
  --
  ALTER TABLE `craft_templatecaches`
  	ADD CONSTRAINT `craft_templatecaches_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_usergroups_users`
  --
  ALTER TABLE `craft_usergroups_users`
  	ADD CONSTRAINT `craft_usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_userpermissions_usergroups`
  --
  ALTER TABLE `craft_userpermissions_usergroups`
  	ADD CONSTRAINT `craft_userpermissions_usergroups_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_userpermissions_usergroups_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_userpermissions_users`
  --
  ALTER TABLE `craft_userpermissions_users`
  	ADD CONSTRAINT `craft_userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE;
  
  --
  -- Constraints for table `craft_users`
  --
  ALTER TABLE `craft_users`
  	ADD CONSTRAINT `craft_users_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  	ADD CONSTRAINT `craft_users_preferredLocale_fk` FOREIGN KEY (`preferredLocale`) REFERENCES `craft_locales` (`locale`) ON DELETE SET NULL ON UPDATE CASCADE;
  
  --
  -- Constraints for table `craft_widgets`
  --
  ALTER TABLE `craft_widgets`
  	ADD CONSTRAINT `craft_widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE;
  
  SET FOREIGN_KEY_CHECKS = 1;
  