text: # ************************************************************
  # Sequel Pro SQL dump
  # Version 4541
  #
  # http://www.sequelpro.com/
  # https://github.com/sequelpro/sequelpro
  #
  # Host: 127.0.0.1 (MySQL 5.6.39)
  # Database: craft
  # Generation Time: 2018-06-14 16:22:10 +0000
  # ************************************************************
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  
  # Dump of table assetindexdata
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `assetindexdata`;
  
  CREATE TABLE `assetindexdata` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sessionId` varchar(36) NOT NULL DEFAULT '',
    `volumeId` int(11) NOT NULL,
    `uri` text,
    `size` bigint(20) unsigned DEFAULT NULL,
    `timestamp` datetime DEFAULT NULL,
    `recordId` int(11) DEFAULT NULL,
    `inProgress` tinyint(1) DEFAULT '0',
    `completed` tinyint(1) DEFAULT '0',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `assetindexdata_sessionId_volumeId_idx` (`sessionId`,`volumeId`),
    KEY `assetindexdata_volumeId_idx` (`volumeId`),
    CONSTRAINT `assetindexdata_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table assets
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `assets`;
  
  CREATE TABLE `assets` (
    `id` int(11) NOT NULL,
    `volumeId` int(11) DEFAULT NULL,
    `folderId` int(11) NOT NULL,
    `filename` varchar(255) NOT NULL,
    `kind` varchar(50) NOT NULL DEFAULT 'unknown',
    `width` int(11) unsigned DEFAULT NULL,
    `height` int(11) unsigned DEFAULT NULL,
    `size` bigint(20) unsigned DEFAULT NULL,
    `focalPoint` varchar(13) DEFAULT NULL,
    `dateModified` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `assets_filename_folderId_unq_idx` (`filename`,`folderId`),
    KEY `assets_folderId_idx` (`folderId`),
    KEY `assets_volumeId_idx` (`volumeId`),
    CONSTRAINT `assets_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
    CONSTRAINT `assets_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `assets_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table assettransformindex
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `assettransformindex`;
  
  CREATE TABLE `assettransformindex` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `assetId` int(11) NOT NULL,
    `filename` varchar(255) DEFAULT NULL,
    `format` varchar(255) DEFAULT NULL,
    `location` varchar(255) NOT NULL,
    `volumeId` int(11) DEFAULT NULL,
    `fileExists` tinyint(1) NOT NULL DEFAULT '0',
    `inProgress` tinyint(1) NOT NULL DEFAULT '0',
    `dateIndexed` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `assettransformindex_volumeId_assetId_location_idx` (`volumeId`,`assetId`,`location`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table assettransforms
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `assettransforms`;
  
  CREATE TABLE `assettransforms` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `mode` enum('stretch','fit','crop') NOT NULL DEFAULT 'crop',
    `position` enum('top-left','top-center','top-right','center-left','center-center','center-right','bottom-left','bottom-center','bottom-right') NOT NULL DEFAULT 'center-center',
    `width` int(11) unsigned DEFAULT NULL,
    `height` int(11) unsigned DEFAULT NULL,
    `format` varchar(255) DEFAULT NULL,
    `quality` int(11) DEFAULT NULL,
    `interlace` enum('none','line','plane','partition') NOT NULL DEFAULT 'none',
    `dimensionChangeTime` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `assettransforms_name_unq_idx` (`name`),
    UNIQUE KEY `assettransforms_handle_unq_idx` (`handle`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table categories
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `categories`;
  
  CREATE TABLE `categories` (
    `id` int(11) NOT NULL,
    `groupId` int(11) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `categories_groupId_idx` (`groupId`),
    CONSTRAINT `categories_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE,
    CONSTRAINT `categories_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table categorygroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `categorygroups`;
  
  CREATE TABLE `categorygroups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `structureId` int(11) NOT NULL,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `categorygroups_name_unq_idx` (`name`),
    UNIQUE KEY `categorygroups_handle_unq_idx` (`handle`),
    KEY `categorygroups_structureId_idx` (`structureId`),
    KEY `categorygroups_fieldLayoutId_idx` (`fieldLayoutId`),
    CONSTRAINT `categorygroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
    CONSTRAINT `categorygroups_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table categorygroups_sites
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `categorygroups_sites`;
  
  CREATE TABLE `categorygroups_sites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `groupId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
    `uriFormat` text,
    `template` varchar(500) DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `categorygroups_sites_groupId_siteId_unq_idx` (`groupId`,`siteId`),
    KEY `categorygroups_sites_siteId_idx` (`siteId`),
    CONSTRAINT `categorygroups_sites_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE,
    CONSTRAINT `categorygroups_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table content
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `content`;
  
  CREATE TABLE `content` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `elementId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `title` varchar(255) DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `content_elementId_siteId_unq_idx` (`elementId`,`siteId`),
    KEY `content_siteId_idx` (`siteId`),
    KEY `content_title_idx` (`title`),
    CONSTRAINT `content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `content_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `content` WRITE;
  /*!40000 ALTER TABLE `content` DISABLE KEYS */;
  
  INSERT INTO `content` (`id`, `elementId`, `siteId`, `title`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,1,1,NULL,'2018-06-14 16:22:37','2018-06-14 16:22:37','28051f91-8b71-40e6-bdc6-65038a7cab72');
  
  /*!40000 ALTER TABLE `content` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table craftidtokens
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `craftidtokens`;
  
  CREATE TABLE `craftidtokens` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `accessToken` text NOT NULL,
    `expiryDate` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `craftidtokens_userId_fk` (`userId`),
    CONSTRAINT `craftidtokens_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table deprecationerrors
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `deprecationerrors`;
  
  CREATE TABLE `deprecationerrors` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `key` varchar(255) NOT NULL,
    `fingerprint` varchar(255) NOT NULL,
    `lastOccurrence` datetime NOT NULL,
    `file` varchar(255) NOT NULL,
    `line` smallint(6) unsigned DEFAULT NULL,
    `message` varchar(255) DEFAULT NULL,
    `traces` text,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `deprecationerrors_key_fingerprint_unq_idx` (`key`,`fingerprint`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table elementindexsettings
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `elementindexsettings`;
  
  CREATE TABLE `elementindexsettings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(255) NOT NULL,
    `settings` text,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `elementindexsettings_type_unq_idx` (`type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table elements
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `elements`;
  
  CREATE TABLE `elements` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `type` varchar(255) NOT NULL,
    `enabled` tinyint(1) NOT NULL DEFAULT '1',
    `archived` tinyint(1) NOT NULL DEFAULT '0',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `elements_fieldLayoutId_idx` (`fieldLayoutId`),
    KEY `elements_type_idx` (`type`),
    KEY `elements_enabled_idx` (`enabled`),
    KEY `elements_archived_dateCreated_idx` (`archived`,`dateCreated`),
    CONSTRAINT `elements_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `elements` WRITE;
  /*!40000 ALTER TABLE `elements` DISABLE KEYS */;
  
  INSERT INTO `elements` (`id`, `fieldLayoutId`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,NULL,'craft\\elements\\User',1,0,'2018-06-14 16:22:37','2018-06-14 16:22:37','9da736c5-cc04-46e6-a89a-d4eef32e2a62');
  
  /*!40000 ALTER TABLE `elements` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table elements_sites
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `elements_sites`;
  
  CREATE TABLE `elements_sites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `elementId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `slug` varchar(255) DEFAULT NULL,
    `uri` varchar(255) DEFAULT NULL,
    `enabled` tinyint(1) NOT NULL DEFAULT '1',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `elements_sites_elementId_siteId_unq_idx` (`elementId`,`siteId`),
    UNIQUE KEY `elements_sites_uri_siteId_unq_idx` (`uri`,`siteId`),
    KEY `elements_sites_siteId_idx` (`siteId`),
    KEY `elements_sites_slug_siteId_idx` (`slug`,`siteId`),
    KEY `elements_sites_enabled_idx` (`enabled`),
    CONSTRAINT `elements_sites_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `elements_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `elements_sites` WRITE;
  /*!40000 ALTER TABLE `elements_sites` DISABLE KEYS */;
  
  INSERT INTO `elements_sites` (`id`, `elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,1,1,NULL,NULL,1,'2018-06-14 16:22:37','2018-06-14 16:22:37','9c2c9ccd-fa82-4b55-863e-6024b719a51c');
  
  /*!40000 ALTER TABLE `elements_sites` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table entries
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `entries`;
  
  CREATE TABLE `entries` (
    `id` int(11) NOT NULL,
    `sectionId` int(11) NOT NULL,
    `typeId` int(11) NOT 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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `entries_postDate_idx` (`postDate`),
    KEY `entries_expiryDate_idx` (`expiryDate`),
    KEY `entries_authorId_idx` (`authorId`),
    KEY `entries_sectionId_idx` (`sectionId`),
    KEY `entries_typeId_idx` (`typeId`),
    CONSTRAINT `entries_authorId_fk` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entries_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entries_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entries_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table entrydrafts
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `entrydrafts`;
  
  CREATE TABLE `entrydrafts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `entryId` int(11) NOT NULL,
    `sectionId` int(11) NOT NULL,
    `creatorId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `notes` text,
    `data` mediumtext NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `entrydrafts_sectionId_idx` (`sectionId`),
    KEY `entrydrafts_entryId_siteId_idx` (`entryId`,`siteId`),
    KEY `entrydrafts_siteId_idx` (`siteId`),
    KEY `entrydrafts_creatorId_idx` (`creatorId`),
    CONSTRAINT `entrydrafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entrydrafts_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `entries` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entrydrafts_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entrydrafts_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table entrytypes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `entrytypes`;
  
  CREATE TABLE `entrytypes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sectionId` int(11) NOT NULL,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `hasTitleField` tinyint(1) NOT NULL DEFAULT '1',
    `titleLabel` varchar(255) DEFAULT 'Title',
    `titleFormat` varchar(255) DEFAULT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `entrytypes_name_sectionId_unq_idx` (`name`,`sectionId`),
    UNIQUE KEY `entrytypes_handle_sectionId_unq_idx` (`handle`,`sectionId`),
    KEY `entrytypes_sectionId_idx` (`sectionId`),
    KEY `entrytypes_fieldLayoutId_idx` (`fieldLayoutId`),
    CONSTRAINT `entrytypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
    CONSTRAINT `entrytypes_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table entryversions
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `entryversions`;
  
  CREATE TABLE `entryversions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `entryId` int(11) NOT NULL,
    `sectionId` int(11) NOT NULL,
    `creatorId` int(11) DEFAULT NULL,
    `siteId` int(11) NOT NULL,
    `num` smallint(6) unsigned NOT NULL,
    `notes` text,
    `data` mediumtext NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `entryversions_sectionId_idx` (`sectionId`),
    KEY `entryversions_entryId_siteId_idx` (`entryId`,`siteId`),
    KEY `entryversions_siteId_idx` (`siteId`),
    KEY `entryversions_creatorId_idx` (`creatorId`),
    CONSTRAINT `entryversions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
    CONSTRAINT `entryversions_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `entries` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entryversions_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
    CONSTRAINT `entryversions_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table fieldgroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `fieldgroups`;
  
  CREATE TABLE `fieldgroups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `fieldgroups_name_unq_idx` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `fieldgroups` WRITE;
  /*!40000 ALTER TABLE `fieldgroups` DISABLE KEYS */;
  
  INSERT INTO `fieldgroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,'Common','2018-06-14 16:22:37','2018-06-14 16:22:37','ba23725b-b739-4815-aa46-a18b78aa2b2f');
  
  /*!40000 ALTER TABLE `fieldgroups` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table fieldlayoutfields
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `fieldlayoutfields`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `fieldlayoutfields_layoutId_fieldId_unq_idx` (`layoutId`,`fieldId`),
    KEY `fieldlayoutfields_sortOrder_idx` (`sortOrder`),
    KEY `fieldlayoutfields_tabId_idx` (`tabId`),
    KEY `fieldlayoutfields_fieldId_idx` (`fieldId`),
    CONSTRAINT `fieldlayoutfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
    CONSTRAINT `fieldlayoutfields_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE,
    CONSTRAINT `fieldlayoutfields_tabId_fk` FOREIGN KEY (`tabId`) REFERENCES `fieldlayouttabs` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table fieldlayouts
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `fieldlayouts`;
  
  CREATE TABLE `fieldlayouts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `fieldlayouts_type_idx` (`type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table fieldlayouttabs
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `fieldlayouttabs`;
  
  CREATE TABLE `fieldlayouttabs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `layoutId` int(11) NOT NULL,
    `name` varchar(255) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `fieldlayouttabs_sortOrder_idx` (`sortOrder`),
    KEY `fieldlayouttabs_layoutId_idx` (`layoutId`),
    CONSTRAINT `fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table fields
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `fields`;
  
  CREATE TABLE `fields` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `groupId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(64) NOT NULL,
    `context` varchar(255) NOT NULL DEFAULT 'global',
    `instructions` text,
    `translationMethod` varchar(255) NOT NULL DEFAULT 'none',
    `translationKeyFormat` text,
    `type` varchar(255) NOT NULL,
    `settings` text,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `fields_handle_context_unq_idx` (`handle`,`context`),
    KEY `fields_groupId_idx` (`groupId`),
    KEY `fields_context_idx` (`context`),
    CONSTRAINT `fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `fieldgroups` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table globalsets
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `globalsets`;
  
  CREATE TABLE `globalsets` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `globalsets_name_unq_idx` (`name`),
    UNIQUE KEY `globalsets_handle_unq_idx` (`handle`),
    KEY `globalsets_fieldLayoutId_idx` (`fieldLayoutId`),
    CONSTRAINT `globalsets_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
    CONSTRAINT `globalsets_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table info
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `info`;
  
  CREATE TABLE `info` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `version` varchar(50) NOT NULL,
    `schemaVersion` varchar(15) NOT NULL,
    `edition` tinyint(3) unsigned NOT NULL,
    `timezone` varchar(30) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `on` tinyint(1) NOT NULL DEFAULT '0',
    `maintenance` tinyint(1) NOT NULL DEFAULT '0',
    `fieldVersion` char(12) NOT NULL DEFAULT '000000000000',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `info` WRITE;
  /*!40000 ALTER TABLE `info` DISABLE KEYS */;
  
  INSERT INTO `info` (`id`, `version`, `schemaVersion`, `edition`, `timezone`, `name`, `on`, `maintenance`, `fieldVersion`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,'3.0.11','3.0.91',0,'America/Los_Angeles','Test',1,0,'R74AhvPpsl0A','2018-06-14 16:22:37','2018-06-14 16:22:37','cac62dd5-4913-4012-96ce-81ec214ba8e5');
  
  /*!40000 ALTER TABLE `info` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table matrixblocks
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `matrixblocks`;
  
  CREATE TABLE `matrixblocks` (
    `id` int(11) NOT NULL,
    `ownerId` int(11) NOT NULL,
    `ownerSiteId` int(11) DEFAULT NULL,
    `fieldId` int(11) NOT NULL,
    `typeId` int(11) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `matrixblocks_ownerId_idx` (`ownerId`),
    KEY `matrixblocks_fieldId_idx` (`fieldId`),
    KEY `matrixblocks_typeId_idx` (`typeId`),
    KEY `matrixblocks_sortOrder_idx` (`sortOrder`),
    KEY `matrixblocks_ownerSiteId_idx` (`ownerSiteId`),
    CONSTRAINT `matrixblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
    CONSTRAINT `matrixblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `matrixblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `matrixblocks_ownerSiteId_fk` FOREIGN KEY (`ownerSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `matrixblocktypes` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table matrixblocktypes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `matrixblocktypes`;
  
  CREATE TABLE `matrixblocktypes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fieldId` int(11) NOT NULL,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `matrixblocktypes_name_fieldId_unq_idx` (`name`,`fieldId`),
    UNIQUE KEY `matrixblocktypes_handle_fieldId_unq_idx` (`handle`,`fieldId`),
    KEY `matrixblocktypes_fieldId_idx` (`fieldId`),
    KEY `matrixblocktypes_fieldLayoutId_idx` (`fieldLayoutId`),
    CONSTRAINT `matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
    CONSTRAINT `matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table migrations
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `migrations`;
  
  CREATE TABLE `migrations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `pluginId` int(11) DEFAULT NULL,
    `type` enum('app','plugin','content') NOT NULL DEFAULT 'app',
    `name` varchar(255) NOT NULL,
    `applyTime` datetime NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `migrations_pluginId_idx` (`pluginId`),
    KEY `migrations_type_pluginId_idx` (`type`,`pluginId`),
    CONSTRAINT `migrations_pluginId_fk` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  
  INSERT INTO `migrations` (`id`, `pluginId`, `type`, `name`, `applyTime`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,NULL,'app','Install','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9979bbc0-d30b-4998-b9b0-beb849ad57f3'),
  	(2,NULL,'app','m150403_183908_migrations_table_changes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','d710e96d-c696-458a-b313-1db6379a1366'),
  	(3,NULL,'app','m150403_184247_plugins_table_changes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','2e778e54-543b-4e64-b59e-6e4d24bb5424'),
  	(4,NULL,'app','m150403_184533_field_version','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','2894b221-020a-451f-b87e-1d9d20b048a4'),
  	(5,NULL,'app','m150403_184729_type_columns','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','19da2e86-4627-43a9-9a15-a9a78ff41095'),
  	(6,NULL,'app','m150403_185142_volumes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','cdadf5f3-6046-47a1-9773-90f4484b078e'),
  	(7,NULL,'app','m150428_231346_userpreferences','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','e363f9b2-3ead-4896-aaff-91ebcd9fe977'),
  	(8,NULL,'app','m150519_150900_fieldversion_conversion','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','adf636c1-69e6-454f-8b73-69d1578c9265'),
  	(9,NULL,'app','m150617_213829_update_email_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','1255d627-cf52-404a-8299-02308b3c53d4'),
  	(10,NULL,'app','m150721_124739_templatecachequeries','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','24c3658d-f636-45bb-ade5-e5ab194c5f0d'),
  	(11,NULL,'app','m150724_140822_adjust_quality_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','878662b1-f852-4ad9-9c47-54b937c23e18'),
  	(12,NULL,'app','m150815_133521_last_login_attempt_ip','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','46299614-14a9-43d7-ad88-8ae4b4d1e44c'),
  	(13,NULL,'app','m151002_095935_volume_cache_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','fb9f35bc-7075-4d3f-89ad-889b604613e8'),
  	(14,NULL,'app','m151005_142750_volume_s3_storage_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','92a46674-1676-4cf0-b7c3-eeef1001ad88'),
  	(15,NULL,'app','m151016_133600_delete_asset_thumbnails','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','d13aad9c-e707-4b62-9ffb-85cf96d30ea9'),
  	(16,NULL,'app','m151209_000000_move_logo','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9abefd97-0e48-4f7d-859d-81c056474991'),
  	(17,NULL,'app','m151211_000000_rename_fileId_to_assetId','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','78e58d5e-40a8-4dbc-940f-2923a1463e8a'),
  	(18,NULL,'app','m151215_000000_rename_asset_permissions','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','0a0c15e7-e9f1-4af3-8ca0-e36edfc8e068'),
  	(19,NULL,'app','m160707_000001_rename_richtext_assetsource_setting','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','4451e065-3bb5-4b8a-9c25-5ad4cba674b3'),
  	(20,NULL,'app','m160708_185142_volume_hasUrls_setting','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','08d78964-47bc-4652-bf05-d030f5c4f695'),
  	(21,NULL,'app','m160714_000000_increase_max_asset_filesize','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','d0d83142-bab9-4629-9685-d3ecad66cae9'),
  	(22,NULL,'app','m160727_194637_column_cleanup','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','01ae8a6e-94dc-45da-9ea5-bbc828c10152'),
  	(23,NULL,'app','m160804_110002_userphotos_to_assets','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','2ff59af7-f831-4d96-bbc1-2892b25f4708'),
  	(24,NULL,'app','m160807_144858_sites','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ea8b94f3-13ea-452d-844c-5f63aa7c54dc'),
  	(25,NULL,'app','m160829_000000_pending_user_content_cleanup','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','69bf1093-c791-4909-b4c9-d996189890e1'),
  	(26,NULL,'app','m160830_000000_asset_index_uri_increase','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','970879a8-567f-44da-8f05-9cb6c8b2ad8c'),
  	(27,NULL,'app','m160912_230520_require_entry_type_id','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ae6002de-393b-4c83-86d0-0763fb098151'),
  	(28,NULL,'app','m160913_134730_require_matrix_block_type_id','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','bdb42dfc-5a88-4ebd-9f61-fa94866984f2'),
  	(29,NULL,'app','m160920_174553_matrixblocks_owner_site_id_nullable','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','44765e13-5fea-4302-856d-fd4b5a3fe150'),
  	(30,NULL,'app','m160920_231045_usergroup_handle_title_unique','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','c63368bb-235f-48bc-a2ca-803db2c75560'),
  	(31,NULL,'app','m160925_113941_route_uri_parts','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','8265012f-b498-4e92-9d31-ef564866f169'),
  	(32,NULL,'app','m161006_205918_schemaVersion_not_null','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','52342407-1243-44dd-a12b-b6a7377da8fb'),
  	(33,NULL,'app','m161007_130653_update_email_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','a6777982-f6df-434c-bf66-596448c80bba'),
  	(34,NULL,'app','m161013_175052_newParentId','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','5319bc53-b5c4-4b7a-8201-6667442514cd'),
  	(35,NULL,'app','m161021_102916_fix_recent_entries_widgets','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','346e7bdc-07b1-49bb-a72c-fce4eca907fe'),
  	(36,NULL,'app','m161021_182140_rename_get_help_widget','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ab567686-b808-4b7a-bc1a-6ed53c5c6faf'),
  	(37,NULL,'app','m161025_000000_fix_char_columns','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','4962773b-754b-4e8c-8b27-4e25714470f8'),
  	(38,NULL,'app','m161029_124145_email_message_languages','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ee077cc4-0d57-4301-a07a-b16c567966f3'),
  	(39,NULL,'app','m161108_000000_new_version_format','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','3549faf8-8a57-46f2-99fb-ff4771afd739'),
  	(40,NULL,'app','m161109_000000_index_shuffle','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','20f70c72-f1a3-4c49-8a9b-4c5451dbad54'),
  	(41,NULL,'app','m161122_185500_no_craft_app','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','067f3783-2a94-4c17-b559-ec1a21ba0d80'),
  	(42,NULL,'app','m161125_150752_clear_urlmanager_cache','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','7cacd3e9-5898-47c8-a4d9-6aa0cc7eeb48'),
  	(43,NULL,'app','m161220_000000_volumes_hasurl_notnull','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ff975431-e33b-4c34-a533-5c1f7dd51672'),
  	(44,NULL,'app','m170114_161144_udates_permission','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','f1c82fa2-f8a9-4565-9bda-13fcaf3fab44'),
  	(45,NULL,'app','m170120_000000_schema_cleanup','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','7eecf84f-4a72-4b67-9ad5-929c2178bf1e'),
  	(46,NULL,'app','m170126_000000_assets_focal_point','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ad64a195-12ef-49f3-a47b-3937bf75eeb9'),
  	(47,NULL,'app','m170206_142126_system_name','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','48c79412-22b7-4133-a649-64ee3aa4fb89'),
  	(48,NULL,'app','m170217_044740_category_branch_limits','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','74d0932a-e21d-4cd2-b8c7-31176d9aac57'),
  	(49,NULL,'app','m170217_120224_asset_indexing_columns','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','c1ba71e6-cf5e-493a-9245-66423b982a96'),
  	(50,NULL,'app','m170223_224012_plain_text_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','512d4afb-154e-4df7-a25f-4dd827e7d5e6'),
  	(51,NULL,'app','m170227_120814_focal_point_percentage','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','e2a8c107-2021-4675-be96-7edaa36ef2f2'),
  	(52,NULL,'app','m170228_171113_system_messages','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','3532cb60-436e-4899-9a1e-530656db49cb'),
  	(53,NULL,'app','m170303_140500_asset_field_source_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9286d372-c2e0-47f4-8078-aa59d704faf5'),
  	(54,NULL,'app','m170306_150500_asset_temporary_uploads','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','7de3fa65-c3d3-4418-beff-1e38c77f357a'),
  	(55,NULL,'app','m170414_162429_rich_text_config_setting','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ea54b3ca-5483-45c3-8e2e-4c22a48fabe4'),
  	(56,NULL,'app','m170523_190652_element_field_layout_ids','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','f9c99bc2-2761-4567-a7ae-c3a0a7c43b0c'),
  	(57,NULL,'app','m170612_000000_route_index_shuffle','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9c8a5e20-596c-4f4a-825f-172c7bbed5c7'),
  	(58,NULL,'app','m170621_195237_format_plugin_handles','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','2027bc74-9ecb-4d11-b169-010f97d1bd4a'),
  	(59,NULL,'app','m170630_161028_deprecation_changes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ec8464a8-63d0-44e5-945d-37b460eb871f'),
  	(60,NULL,'app','m170703_181539_plugins_table_tweaks','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','57447e1a-086b-4c60-a5f6-f925c1ffe4d8'),
  	(61,NULL,'app','m170704_134916_sites_tables','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','b6208bf9-761f-4ebc-8577-3a4cf3de121b'),
  	(62,NULL,'app','m170706_183216_rename_sequences','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','c05bccd7-321b-4c17-8c5e-2c3a9fc86425'),
  	(63,NULL,'app','m170707_094758_delete_compiled_traits','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','6042b4a9-ca5b-430a-9745-115c5cefd9d7'),
  	(64,NULL,'app','m170731_190138_drop_asset_packagist','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','756c8e81-fc50-4e3d-9e73-ed68c80c40fd'),
  	(65,NULL,'app','m170810_201318_create_queue_table','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','09028341-6abe-44b0-894b-fb9e3ccd79d3'),
  	(66,NULL,'app','m170816_133741_delete_compiled_behaviors','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','f5a05964-0f48-40b7-906f-0a6248ca5e8c'),
  	(67,NULL,'app','m170821_180624_deprecation_line_nullable','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','cda8de5f-886c-462d-ae31-5a54eb784f95'),
  	(68,NULL,'app','m170903_192801_longblob_for_queue_jobs','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','6b5fef9d-6126-468c-bf55-7c37484343db'),
  	(69,NULL,'app','m170914_204621_asset_cache_shuffle','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','13206a24-6eb6-41f2-864a-d445bfd10594'),
  	(70,NULL,'app','m171011_214115_site_groups','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ebb2a4ba-d877-4615-b76d-a7135f8c2bd3'),
  	(71,NULL,'app','m171012_151440_primary_site','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9e7266fb-8703-48e0-a7d5-d098bb52bf29'),
  	(72,NULL,'app','m171013_142500_transform_interlace','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','50b37040-ab54-4e8a-b30c-980f53e70f51'),
  	(73,NULL,'app','m171016_092553_drop_position_select','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','a975699d-dacf-4915-a071-b2797cf3bed8'),
  	(74,NULL,'app','m171016_221244_less_strict_translation_method','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','c2959950-9860-4ac2-993d-5a086b489528'),
  	(75,NULL,'app','m171107_000000_assign_group_permissions','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','0e34349c-7be5-4095-90e8-17f9e9b2b5fb'),
  	(76,NULL,'app','m171117_000001_templatecache_index_tune','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','9b3b4e7e-dd9b-4b8b-9559-962292edfc0f'),
  	(77,NULL,'app','m171126_105927_disabled_plugins','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','82fcb0c2-fd88-4821-b225-6f9d07920704'),
  	(78,NULL,'app','m171130_214407_craftidtokens_table','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','5d42ca83-5c22-4d0d-9eb2-ab37443a32c6'),
  	(79,NULL,'app','m171202_004225_update_email_settings','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','11f8bcfe-df26-4932-825f-6a07a27658de'),
  	(80,NULL,'app','m171204_000001_templatecache_index_tune_deux','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','6d6ec0a0-8429-4b4f-91c5-f9346df587ba'),
  	(81,NULL,'app','m171205_130908_remove_craftidtokens_refreshtoken_column','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','dde0f9ac-4e64-4704-a244-1d253158f6b1'),
  	(82,NULL,'app','m171218_143135_longtext_query_column','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','3c64bdee-0dd9-4bdb-bbce-b5c5d4588afe'),
  	(83,NULL,'app','m171231_055546_environment_variables_to_aliases','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','bdcdc608-f2df-4145-b68c-db210b47ec75'),
  	(84,NULL,'app','m180113_153740_drop_users_archived_column','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','c92df96a-4f34-47b0-88d7-1ea136e583ba'),
  	(85,NULL,'app','m180122_213433_propagate_entries_setting','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','4237e5ee-d244-40da-9e96-fb20dc616aca'),
  	(86,NULL,'app','m180124_230459_fix_propagate_entries_values','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','6d9345f4-5d80-4e6c-a661-ccf78cf9ced3'),
  	(87,NULL,'app','m180128_235202_set_tag_slugs','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','3648248d-07a6-459d-b85e-b3cd6bb2227c'),
  	(88,NULL,'app','m180202_185551_fix_focal_points','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','f15ce021-47a6-447f-ba04-2f63f6cb5d6b'),
  	(89,NULL,'app','m180217_172123_tiny_ints','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','1b07ba5b-f2d6-4bee-961f-4cb75fd7c232'),
  	(90,NULL,'app','m180321_233505_small_ints','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','f777363f-b504-4868-8365-7754d52a2484'),
  	(91,NULL,'app','m180328_115523_new_license_key_statuses','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','ab4d68e1-2e81-4a0a-a4c1-3784756e5ce3'),
  	(92,NULL,'app','m180404_182320_edition_changes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','aa9acff4-7f84-4d4b-93ea-255d9b59a47b'),
  	(93,NULL,'app','m180411_102218_fix_db_routes','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','735346ac-26c7-4e1c-8f88-6743bae47151'),
  	(94,NULL,'app','m180416_205628_resourcepaths_table','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','d074d371-03f6-497e-8bbf-327741ab239c'),
  	(95,NULL,'app','m180418_205713_widget_cleanup','2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:38','3e536fe0-fb9e-49d9-856b-2b79a1953e73');
  
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table plugins
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `plugins`;
  
  CREATE TABLE `plugins` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `handle` varchar(255) NOT NULL,
    `version` varchar(255) NOT NULL,
    `schemaVersion` varchar(255) NOT NULL,
    `licenseKey` char(24) DEFAULT NULL,
    `licenseKeyStatus` enum('valid','invalid','mismatched','astray','unknown') NOT NULL DEFAULT 'unknown',
    `enabled` tinyint(1) NOT NULL DEFAULT '0',
    `settings` text,
    `installDate` datetime NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `plugins_handle_unq_idx` (`handle`),
    KEY `plugins_enabled_idx` (`enabled`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table queue
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `queue`;
  
  CREATE TABLE `queue` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `job` longblob NOT NULL,
    `description` text,
    `timePushed` int(11) NOT NULL,
    `ttr` int(11) NOT NULL,
    `delay` int(11) NOT NULL DEFAULT '0',
    `priority` int(11) unsigned NOT NULL DEFAULT '1024',
    `dateReserved` datetime DEFAULT NULL,
    `timeUpdated` int(11) DEFAULT NULL,
    `progress` smallint(6) NOT NULL DEFAULT '0',
    `attempt` int(11) DEFAULT NULL,
    `fail` tinyint(1) DEFAULT '0',
    `dateFailed` datetime DEFAULT NULL,
    `error` text,
    PRIMARY KEY (`id`),
    KEY `queue_fail_timeUpdated_timePushed_idx` (`fail`,`timeUpdated`,`timePushed`),
    KEY `queue_fail_timeUpdated_delay_idx` (`fail`,`timeUpdated`,`delay`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table relations
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `relations`;
  
  CREATE TABLE `relations` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fieldId` int(11) NOT NULL,
    `sourceId` int(11) NOT NULL,
    `sourceSiteId` int(11) DEFAULT NULL,
    `targetId` int(11) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `relations_fieldId_sourceId_sourceSiteId_targetId_unq_idx` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
    KEY `relations_sourceId_idx` (`sourceId`),
    KEY `relations_targetId_idx` (`targetId`),
    KEY `relations_sourceSiteId_idx` (`sourceSiteId`),
    CONSTRAINT `relations_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
    CONSTRAINT `relations_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `relations_sourceSiteId_fk` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table resourcepaths
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `resourcepaths`;
  
  CREATE TABLE `resourcepaths` (
    `hash` varchar(255) NOT NULL,
    `path` varchar(255) NOT NULL,
    PRIMARY KEY (`hash`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `resourcepaths` WRITE;
  /*!40000 ALTER TABLE `resourcepaths` DISABLE KEYS */;
  
  INSERT INTO `resourcepaths` (`hash`, `path`)
  VALUES
  	('105c6c02','@lib/fabric'),
  	('20ea8e15','@lib/fileupload'),
  	('36a7afba','@lib/d3'),
  	('38028feb','@lib/picturefill'),
  	('3fa6b329','@lib/jquery-touch-events'),
  	('4e971cd9','@craft/web/assets/recententries/dist'),
  	('51ab83c','@lib/garnishjs'),
  	('6610e6e5','@lib/xregexp'),
  	('6a538726','@craft/web/assets/cp/dist'),
  	('6c7ca26f','@lib/selectize'),
  	('702d5eb7','@craft/web/assets/updateswidget/dist'),
  	('91d7b331','@craft/web/assets/dashboard/dist'),
  	('9b381899','@lib/element-resize-detector'),
  	('a5274411','@lib/velocity'),
  	('b4a8b36c','@bower/jquery/dist'),
  	('b900ebf9','@lib/jquery.payment'),
  	('d781a8be','@craft/web/assets/craftsupport/dist'),
  	('e89495fa','@craft/web/assets/feed/dist'),
  	('eb8edfb4','@lib/jquery-ui');
  
  /*!40000 ALTER TABLE `resourcepaths` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table routes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `routes`;
  
  CREATE TABLE `routes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `siteId` int(11) DEFAULT NULL,
    `uriParts` varchar(255) NOT NULL,
    `uriPattern` varchar(255) NOT NULL,
    `template` varchar(500) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `routes_uriPattern_idx` (`uriPattern`),
    KEY `routes_siteId_idx` (`siteId`),
    CONSTRAINT `routes_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table searchindex
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `searchindex`;
  
  CREATE TABLE `searchindex` (
    `elementId` int(11) NOT NULL,
    `attribute` varchar(25) NOT NULL,
    `fieldId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `keywords` text NOT NULL,
    PRIMARY KEY (`elementId`,`attribute`,`fieldId`,`siteId`),
    FULLTEXT KEY `searchindex_keywords_idx` (`keywords`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  LOCK TABLES `searchindex` WRITE;
  /*!40000 ALTER TABLE `searchindex` DISABLE KEYS */;
  
  INSERT INTO `searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`)
  VALUES
  	(1,'username',0,1,' flipbox '),
  	(1,'firstname',0,1,''),
  	(1,'lastname',0,1,''),
  	(1,'fullname',0,1,''),
  	(1,'email',0,1,' craft flipboxdigital com '),
  	(1,'slug',0,1,'');
  
  /*!40000 ALTER TABLE `searchindex` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table sections
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `sections`;
  
  CREATE TABLE `sections` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `structureId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `type` enum('single','channel','structure') NOT NULL DEFAULT 'channel',
    `enableVersioning` tinyint(1) NOT NULL DEFAULT '0',
    `propagateEntries` tinyint(1) NOT NULL DEFAULT '1',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `sections_handle_unq_idx` (`handle`),
    UNIQUE KEY `sections_name_unq_idx` (`name`),
    KEY `sections_structureId_idx` (`structureId`),
    CONSTRAINT `sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table sections_sites
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `sections_sites`;
  
  CREATE TABLE `sections_sites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sectionId` int(11) NOT NULL,
    `siteId` int(11) NOT NULL,
    `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
    `uriFormat` text,
    `template` varchar(500) DEFAULT NULL,
    `enabledByDefault` tinyint(1) NOT NULL DEFAULT '1',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `sections_sites_sectionId_siteId_unq_idx` (`sectionId`,`siteId`),
    KEY `sections_sites_siteId_idx` (`siteId`),
    CONSTRAINT `sections_sites_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
    CONSTRAINT `sections_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table sessions
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `sessions`;
  
  CREATE TABLE `sessions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `token` char(100) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `sessions_uid_idx` (`uid`),
    KEY `sessions_token_idx` (`token`),
    KEY `sessions_dateUpdated_idx` (`dateUpdated`),
    KEY `sessions_userId_idx` (`userId`),
    CONSTRAINT `sessions_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table shunnedmessages
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `shunnedmessages`;
  
  CREATE TABLE `shunnedmessages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `message` varchar(255) NOT NULL,
    `expiryDate` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `shunnedmessages_userId_message_unq_idx` (`userId`,`message`),
    CONSTRAINT `shunnedmessages_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table sitegroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `sitegroups`;
  
  CREATE TABLE `sitegroups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `sitegroups_name_unq_idx` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `sitegroups` WRITE;
  /*!40000 ALTER TABLE `sitegroups` DISABLE KEYS */;
  
  INSERT INTO `sitegroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,'Test','2018-06-14 16:22:37','2018-06-14 16:22:37','945cd2f5-1a7d-48eb-920e-d39e773f675e');
  
  /*!40000 ALTER TABLE `sitegroups` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table sites
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `sites`;
  
  CREATE TABLE `sites` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `groupId` int(11) NOT NULL,
    `primary` tinyint(1) NOT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `language` varchar(12) NOT NULL,
    `hasUrls` tinyint(1) NOT NULL DEFAULT '0',
    `baseUrl` varchar(255) DEFAULT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `sites_handle_unq_idx` (`handle`),
    KEY `sites_sortOrder_idx` (`sortOrder`),
    KEY `sites_groupId_fk` (`groupId`),
    CONSTRAINT `sites_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `sitegroups` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `sites` WRITE;
  /*!40000 ALTER TABLE `sites` DISABLE KEYS */;
  
  INSERT INTO `sites` (`id`, `groupId`, `primary`, `name`, `handle`, `language`, `hasUrls`, `baseUrl`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,1,1,'Test','default','en-US',1,'@web/',1,'2018-06-14 16:22:37','2018-06-14 16:22:37','935ed4b4-6139-4d2b-88bc-6a4ad8da94dc');
  
  /*!40000 ALTER TABLE `sites` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table structureelements
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `structureelements`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `structureelements_structureId_elementId_unq_idx` (`structureId`,`elementId`),
    KEY `structureelements_root_idx` (`root`),
    KEY `structureelements_lft_idx` (`lft`),
    KEY `structureelements_rgt_idx` (`rgt`),
    KEY `structureelements_level_idx` (`level`),
    KEY `structureelements_elementId_idx` (`elementId`),
    CONSTRAINT `structureelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `structureelements_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table structures
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `structures`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table systemmessages
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `systemmessages`;
  
  CREATE TABLE `systemmessages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `language` varchar(255) NOT NULL,
    `key` varchar(255) NOT NULL,
    `subject` text NOT NULL,
    `body` text NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `systemmessages_key_language_unq_idx` (`key`,`language`),
    KEY `systemmessages_language_idx` (`language`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table systemsettings
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `systemsettings`;
  
  CREATE TABLE `systemsettings` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `category` varchar(15) NOT NULL,
    `settings` text,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `systemsettings_category_unq_idx` (`category`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `systemsettings` WRITE;
  /*!40000 ALTER TABLE `systemsettings` DISABLE KEYS */;
  
  INSERT INTO `systemsettings` (`id`, `category`, `settings`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,'email','{\"fromEmail\":\"craft@flipboxdigital.com\",\"fromName\":\"Test\",\"transportType\":\"craft\\\\mail\\\\transportadapters\\\\Sendmail\"}','2018-06-14 16:22:38','2018-06-14 16:22:38','2bf7be27-7c3a-415d-9f6a-b0493f5b81af');
  
  /*!40000 ALTER TABLE `systemsettings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table taggroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `taggroups`;
  
  CREATE TABLE `taggroups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `taggroups_name_unq_idx` (`name`),
    UNIQUE KEY `taggroups_handle_unq_idx` (`handle`),
    KEY `taggroups_fieldLayoutId_fk` (`fieldLayoutId`),
    CONSTRAINT `taggroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table tags
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `tags`;
  
  CREATE TABLE `tags` (
    `id` int(11) NOT NULL,
    `groupId` int(11) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `tags_groupId_idx` (`groupId`),
    CONSTRAINT `tags_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE,
    CONSTRAINT `tags_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table templatecacheelements
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `templatecacheelements`;
  
  CREATE TABLE `templatecacheelements` (
    `cacheId` int(11) NOT NULL,
    `elementId` int(11) NOT NULL,
    KEY `templatecacheelements_cacheId_idx` (`cacheId`),
    KEY `templatecacheelements_elementId_idx` (`elementId`),
    CONSTRAINT `templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE,
    CONSTRAINT `templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table templatecachequeries
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `templatecachequeries`;
  
  CREATE TABLE `templatecachequeries` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `cacheId` int(11) NOT NULL,
    `type` varchar(255) NOT NULL,
    `query` longtext NOT NULL,
    PRIMARY KEY (`id`),
    KEY `templatecachequeries_cacheId_idx` (`cacheId`),
    KEY `templatecachequeries_type_idx` (`type`),
    CONSTRAINT `templatecachequeries_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table templatecaches
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `templatecaches`;
  
  CREATE TABLE `templatecaches` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `siteId` int(11) NOT NULL,
    `cacheKey` varchar(255) NOT NULL,
    `path` varchar(255) DEFAULT NULL,
    `expiryDate` datetime NOT NULL,
    `body` mediumtext NOT NULL,
    PRIMARY KEY (`id`),
    KEY `templatecaches_cacheKey_siteId_expiryDate_path_idx` (`cacheKey`,`siteId`,`expiryDate`,`path`),
    KEY `templatecaches_cacheKey_siteId_expiryDate_idx` (`cacheKey`,`siteId`,`expiryDate`),
    KEY `templatecaches_siteId_idx` (`siteId`),
    CONSTRAINT `templatecaches_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table tokens
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `tokens`;
  
  CREATE TABLE `tokens` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `token` char(32) NOT NULL,
    `route` text,
    `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `tokens_token_unq_idx` (`token`),
    KEY `tokens_expiryDate_idx` (`expiryDate`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table usergroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `usergroups`;
  
  CREATE TABLE `usergroups` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `usergroups_handle_unq_idx` (`handle`),
    UNIQUE KEY `usergroups_name_unq_idx` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table usergroups_users
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `usergroups_users`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `usergroups_users_groupId_userId_unq_idx` (`groupId`,`userId`),
    KEY `usergroups_users_userId_idx` (`userId`),
    CONSTRAINT `usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
    CONSTRAINT `usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table userpermissions
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `userpermissions`;
  
  CREATE TABLE `userpermissions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `userpermissions_name_unq_idx` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table userpermissions_usergroups
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `userpermissions_usergroups`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `userpermissions_usergroups_permissionId_groupId_unq_idx` (`permissionId`,`groupId`),
    KEY `userpermissions_usergroups_groupId_idx` (`groupId`),
    CONSTRAINT `userpermissions_usergroups_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
    CONSTRAINT `userpermissions_usergroups_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table userpermissions_users
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `userpermissions_users`;
  
  CREATE TABLE `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) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `userpermissions_users_permissionId_userId_unq_idx` (`permissionId`,`userId`),
    KEY `userpermissions_users_userId_idx` (`userId`),
    CONSTRAINT `userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE,
    CONSTRAINT `userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table userpreferences
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `userpreferences`;
  
  CREATE TABLE `userpreferences` (
    `userId` int(11) NOT NULL AUTO_INCREMENT,
    `preferences` text,
    PRIMARY KEY (`userId`),
    CONSTRAINT `userpreferences_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `userpreferences` WRITE;
  /*!40000 ALTER TABLE `userpreferences` DISABLE KEYS */;
  
  INSERT INTO `userpreferences` (`userId`, `preferences`)
  VALUES
  	(1,'{\"language\":\"en-US\"}');
  
  /*!40000 ALTER TABLE `userpreferences` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table users
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL,
    `username` varchar(100) NOT NULL,
    `photoId` int(11) DEFAULT NULL,
    `firstName` varchar(100) DEFAULT NULL,
    `lastName` varchar(100) DEFAULT NULL,
    `email` varchar(255) NOT NULL,
    `password` varchar(255) DEFAULT NULL,
    `admin` tinyint(1) NOT NULL DEFAULT '0',
    `locked` tinyint(1) NOT NULL DEFAULT '0',
    `suspended` tinyint(1) NOT NULL DEFAULT '0',
    `pending` tinyint(1) NOT NULL DEFAULT '0',
    `lastLoginDate` datetime DEFAULT NULL,
    `lastLoginAttemptIp` varchar(45) DEFAULT NULL,
    `invalidLoginWindowStart` datetime DEFAULT NULL,
    `invalidLoginCount` tinyint(3) unsigned DEFAULT NULL,
    `lastInvalidLoginDate` datetime DEFAULT NULL,
    `lockoutDate` datetime DEFAULT NULL,
    `hasDashboard` tinyint(1) NOT NULL DEFAULT '0',
    `verificationCode` varchar(255) DEFAULT NULL,
    `verificationCodeIssuedDate` datetime DEFAULT NULL,
    `unverifiedEmail` varchar(255) DEFAULT NULL,
    `passwordResetRequired` tinyint(1) NOT NULL DEFAULT '0',
    `lastPasswordChangeDate` datetime DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_username_unq_idx` (`username`),
    UNIQUE KEY `users_email_unq_idx` (`email`),
    KEY `users_uid_idx` (`uid`),
    KEY `users_verificationCode_idx` (`verificationCode`),
    KEY `users_photoId_fk` (`photoId`),
    CONSTRAINT `users_id_fk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
    CONSTRAINT `users_photoId_fk` FOREIGN KEY (`photoId`) REFERENCES `assets` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  
  INSERT INTO `users` (`id`, `username`, `photoId`, `firstName`, `lastName`, `email`, `password`, `admin`, `locked`, `suspended`, `pending`, `lastLoginDate`, `lastLoginAttemptIp`, `invalidLoginWindowStart`, `invalidLoginCount`, `lastInvalidLoginDate`, `lockoutDate`, `hasDashboard`, `verificationCode`, `verificationCodeIssuedDate`, `unverifiedEmail`, `passwordResetRequired`, `lastPasswordChangeDate`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,'flipbox',NULL,NULL,NULL,'craft@flipboxdigital.com','$2y$13$KtP29szCrmqoF0JM4Dv0rO3Q.I1kLqPFABQ73QzMfBRZZ6XHWuleC',1,0,0,0,'2018-06-14 16:22:38','172.19.0.1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,'2018-06-14 16:22:38','2018-06-14 16:22:38','2018-06-14 16:22:41','5be4ab9b-799d-4ad8-9e0a-2e4af8173f8c');
  
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table volumefolders
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `volumefolders`;
  
  CREATE TABLE `volumefolders` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `parentId` int(11) DEFAULT NULL,
    `volumeId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `path` varchar(255) DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `volumefolders_name_parentId_volumeId_unq_idx` (`name`,`parentId`,`volumeId`),
    KEY `volumefolders_parentId_idx` (`parentId`),
    KEY `volumefolders_volumeId_idx` (`volumeId`),
    CONSTRAINT `volumefolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
    CONSTRAINT `volumefolders_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table volumes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `volumes`;
  
  CREATE TABLE `volumes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `fieldLayoutId` int(11) DEFAULT NULL,
    `name` varchar(255) NOT NULL,
    `handle` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
    `url` varchar(255) DEFAULT NULL,
    `settings` text,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    UNIQUE KEY `volumes_name_unq_idx` (`name`),
    UNIQUE KEY `volumes_handle_unq_idx` (`handle`),
    KEY `volumes_fieldLayoutId_idx` (`fieldLayoutId`),
    CONSTRAINT `volumes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  
  # Dump of table widgets
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `widgets`;
  
  CREATE TABLE `widgets` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL,
    `type` varchar(255) NOT NULL,
    `sortOrder` smallint(6) unsigned DEFAULT NULL,
    `colspan` tinyint(1) NOT NULL DEFAULT '0',
    `settings` text,
    `enabled` tinyint(1) NOT NULL DEFAULT '1',
    `dateCreated` datetime NOT NULL,
    `dateUpdated` datetime NOT NULL,
    `uid` char(36) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `widgets_userId_idx` (`userId`),
    CONSTRAINT `widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  LOCK TABLES `widgets` WRITE;
  /*!40000 ALTER TABLE `widgets` DISABLE KEYS */;
  
  INSERT INTO `widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
  VALUES
  	(1,1,'craft\\widgets\\RecentEntries',1,0,'{\"section\":\"*\",\"siteId\":\"1\",\"limit\":10}',1,'2018-06-14 16:22:41','2018-06-14 16:22:41','b303069d-ca92-4fcd-9ea1-dc4e408f5925'),
  	(2,1,'craft\\widgets\\CraftSupport',2,0,'[]',1,'2018-06-14 16:22:41','2018-06-14 16:22:41','27b067f8-1212-4e57-8b5f-541b5686941a'),
  	(3,1,'craft\\widgets\\Updates',3,0,'[]',1,'2018-06-14 16:22:41','2018-06-14 16:22:41','5bfd552b-5da7-401f-a33a-af0cff97b72f'),
  	(4,1,'craft\\widgets\\Feed',4,0,'{\"url\":\"https://craftcms.com/news.rss\",\"title\":\"Craft News\",\"limit\":5}',1,'2018-06-14 16:22:41','2018-06-14 16:22:41','f7419f5b-3d4d-4c5b-8a3e-0cb5e5d059b8');
  
  /*!40000 ALTER TABLE `widgets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  