--
-- Host: localhost    Database: defaultsite_dev
-- ------------------------------------------------------


--
-- Table structure 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` smallint(6) unsigned DEFAULT NULL,
  `height` smallint(6) unsigned DEFAULT NULL,
  `size` int(11) 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`),
  CONSTRAINT `craft_assetfiles_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `craft_assetfolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_assetfiles_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_assetfiles_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_assetsources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_assetfiles`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_assetfolders_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_assetsources` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_assetfolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_assetfolders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_assetfolders`
--

INSERT INTO `craft_assetfolders` VALUES (1,NULL,1,'Image','','2014-05-02 21:01:01','2014-05-02 21:01:01','de8d59b1-bd7e-4be4-a5b4-48c1dde2547c');

--
-- Table structure for table `craft_assetsources`
--

CREATE TABLE `craft_assetsources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci,
  `sortOrder` tinyint(4) 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`),
  KEY `craft_assetsources_fieldLayoutId_fk` (`fieldLayoutId`),
  CONSTRAINT `craft_assetsources_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_assetsources`
--

INSERT INTO `craft_assetsources` VALUES (1,'Image','Local','{\"path\":\"{fileSystemPath}images\\/\",\"url\":\"\\/images\\/\"}',1,15,'2014-05-02 21:01:01','2014-05-02 21:01:01','d6e7ab73-8fbe-44d7-a808-bf15753a4c5c');

--
-- Table structure for table `craft_assettransformindex`
--

CREATE TABLE `craft_assettransformindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fileId` int(11) NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sourceId` int(11) NOT 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;

--
-- Dumping data for table `craft_assettransformindex`
--


--
-- Table structure 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,
  `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;

--
-- Dumping data for table `craft_assettransforms`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_categories_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_categories_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_categories`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_categorygroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_categorygroups_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_categorygroups`
--


--
-- Table structure 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` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nestedUrlFormat` 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_categorygroups_i18n_groupId_locale_unq_idx` (`groupId`,`locale`),
  KEY `craft_categorygroups_i18n_locale_fk` (`locale`),
  CONSTRAINT `craft_categorygroups_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_categorygroups_i18n_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_categorygroups_i18n`
--


--
-- Table structure 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_heading` text COLLATE utf8_unicode_ci,
  `field_body` text COLLATE utf8_unicode_ci,
  `field_metaTitle` text COLLATE utf8_unicode_ci,
  `field_metaDescription` text COLLATE utf8_unicode_ci,
  `field_className` 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`),
  CONSTRAINT `craft_content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_content_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_content`
--

INSERT INTO `craft_content` VALUES (1,1,'en_us',NULL,NULL,NULL,NULL,NULL,NULL,'2014-05-02 20:46:19','2014-05-02 20:46:19','8256f8c4-39a9-4d68-8378-71c2eb039ac4');
INSERT INTO `craft_content` VALUES (2,2,'en_us','Homepage','','','','',NULL,'2014-05-02 20:46:20','2014-05-02 21:02:31','d4ca6933-07a1-4363-9160-0b556db9de61');
INSERT INTO `craft_content` VALUES (4,4,'en_us',NULL,NULL,NULL,'Default Meta Title','Default Meta Description',NULL,'2014-05-02 20:51:59','2014-05-02 21:06:08','1c1540dc-2258-4f60-834d-11388f1ac3fc');
INSERT INTO `craft_content` VALUES (6,7,'en_us','First-level Page',NULL,NULL,NULL,NULL,NULL,'2014-05-02 21:03:15','2014-05-02 21:03:15','d1887a6f-0ddc-49f8-8e94-687eb9958a6a');
INSERT INTO `craft_content` VALUES (7,9,'en_us','Second-Level Page',NULL,NULL,NULL,NULL,NULL,'2014-05-02 21:04:12','2014-05-02 21:04:12','a7460bd1-44c3-4a40-aee8-fbb90da9fce9');

--
-- Table structure 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_idx` (`archived`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_elements`
--

INSERT INTO `craft_elements` VALUES (1,'User',1,0,'2014-05-02 20:46:18','2014-05-02 20:46:18','918fc590-96ea-4133-86e2-7fef84758e28');
INSERT INTO `craft_elements` VALUES (2,'Entry',1,0,'2014-05-02 20:46:20','2014-05-02 21:02:31','eabea0e8-820b-460f-b3ba-8140a68f6cb8');
INSERT INTO `craft_elements` VALUES (4,'GlobalSet',1,0,'2014-05-02 20:51:59','2014-05-02 21:06:08','957cacb9-d628-4f5e-a31c-90d80aa0394b');
INSERT INTO `craft_elements` VALUES (5,'Asset',1,0,'2014-05-02 21:01:12','2014-05-02 21:01:12','2fde94c3-5bf9-41c2-b6e0-371a596cf59f');
INSERT INTO `craft_elements` VALUES (6,'MatrixBlock',1,0,'2014-05-02 21:02:31','2014-05-02 21:02:31','91185243-1c40-4a76-8eaf-8f5bcd221b02');
INSERT INTO `craft_elements` VALUES (7,'Entry',1,0,'2014-05-02 21:03:15','2014-05-02 21:03:15','8ccb0eb8-6723-4b46-802c-d3b177db133b');
INSERT INTO `craft_elements` VALUES (8,'MatrixBlock',1,0,'2014-05-02 21:03:16','2014-05-02 21:03:16','63c27f0d-17b2-4fb7-83b6-8b5f73fac989');
INSERT INTO `craft_elements` VALUES (9,'Entry',1,0,'2014-05-02 21:04:12','2014-05-02 21:04:12','dd2ca1d3-02dc-4acf-b077-01b0cd80d9cd');
INSERT INTO `craft_elements` VALUES (10,'MatrixBlock',1,0,'2014-05-02 21:04:12','2014-05-02 21:04:12','9c66eedc-cc67-477a-94a5-a9a2e6f130f3');

--
-- Table structure 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`),
  CONSTRAINT `craft_elements_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_elements_i18n_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_elements_i18n`
--

INSERT INTO `craft_elements_i18n` VALUES (1,1,'en_us','',NULL,1,'2014-05-02 20:46:19','2014-05-02 20:46:19','f8d593ea-7854-4ade-a101-9c0645b50e28');
INSERT INTO `craft_elements_i18n` VALUES (2,2,'en_us','homepage','__home__',1,'2014-05-02 20:46:20','2014-05-02 21:02:31','e1ae557e-bd41-484e-9fc6-010782cae60b');
INSERT INTO `craft_elements_i18n` VALUES (4,4,'en_us','',NULL,1,'2014-05-02 20:51:59','2014-05-02 21:06:08','a15ee514-9008-4fba-a850-24689d3f1dd9');
INSERT INTO `craft_elements_i18n` VALUES (5,5,'en_us','keith-headshot',NULL,1,'2014-05-02 21:01:12','2014-05-02 21:01:12','6804bfa0-aa64-43ac-824c-2b790a2e347c');
INSERT INTO `craft_elements_i18n` VALUES (6,6,'en_us','',NULL,1,'2014-05-02 21:02:31','2014-05-02 21:02:31','98d16df3-27c2-4967-8805-23ef7f4e0d26');
INSERT INTO `craft_elements_i18n` VALUES (7,7,'en_us','first-level-page','first-level-page',1,'2014-05-02 21:03:16','2014-05-02 21:03:16','4986dfd9-8c16-4177-9fe8-edcbd7d5227d');
INSERT INTO `craft_elements_i18n` VALUES (8,8,'en_us','',NULL,1,'2014-05-02 21:03:16','2014-05-02 21:03:16','117b3d4b-8e58-48a1-8db5-b104f380cc24');
INSERT INTO `craft_elements_i18n` VALUES (9,9,'en_us','second-level-page','first-level-page/second-level-page',1,'2014-05-02 21:04:12','2014-05-02 21:04:12','dc9d4bd4-9e55-4b1f-be70-fbcbab6dd776');
INSERT INTO `craft_elements_i18n` VALUES (10,10,'en_us','',NULL,1,'2014-05-02 21:04:12','2014-05-02 21:04:12','34af6964-4148-43d3-9549-acf49d2deed9');

--
-- Table structure 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`),
  CONSTRAINT `craft_entries_authorId_fk` FOREIGN KEY (`authorId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entries_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entries_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entries_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_entrytypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_entries`
--

INSERT INTO `craft_entries` VALUES (2,1,1,NULL,'2014-05-02 20:46:20',NULL,'2014-05-02 20:46:20','2014-05-02 21:02:31','1efffd85-6192-42e4-8566-e684b15d38db');
INSERT INTO `craft_entries` VALUES (7,3,3,1,'2014-05-02 21:03:15',NULL,'2014-05-02 21:03:16','2014-05-02 21:03:16','1caeba24-ba86-4fe1-9119-99541cb81ea3');
INSERT INTO `craft_entries` VALUES (9,3,3,1,'2014-05-02 21:04:12',NULL,'2014-05-02 21:04:12','2014-05-02 21:04:12','089da01b-3ab7-4524-b411-dea78d28eaba');

--
-- Table structure 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 DEFAULT NULL,
  `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`),
  CONSTRAINT `craft_entrydrafts_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_entrydrafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entrydrafts_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entrydrafts_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_entrydrafts`
--


--
-- Table structure 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` tinyint(4) 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`),
  CONSTRAINT `craft_entrytypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_entrytypes_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_entrytypes`
--

INSERT INTO `craft_entrytypes` VALUES (1,1,14,'Homepage','homepage',1,NULL,NULL,NULL,'2014-05-02 20:46:20','2014-05-02 21:00:23','f58ef941-c895-4eca-9235-387e4adf4fb1');
INSERT INTO `craft_entrytypes` VALUES (3,3,16,'Pages','pages',1,'Title',NULL,NULL,'2014-05-02 20:49:19','2014-05-02 21:05:55','6fd6b3ed-7d5c-4017-a638-88b0c016e295');
INSERT INTO `craft_entrytypes` VALUES (4,4,12,'Section Modifiers','sectionModifiers',1,'Title',NULL,NULL,'2014-05-02 20:58:44','2014-05-02 20:59:07','53e78ec6-98ae-4091-8a0c-e3664eef32b7');

--
-- Table structure 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,
  `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`),
  CONSTRAINT `craft_entryversions_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_entryversions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_entryversions_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entryversions_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_entryversions`
--


--
-- Table structure 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=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_fieldgroups`
--

INSERT INTO `craft_fieldgroups` VALUES (1,'Default','2014-05-02 20:46:20','2014-05-02 20:46:20','8768585f-9850-4b18-9ccb-aedd6f20af71');
INSERT INTO `craft_fieldgroups` VALUES (2,'SEO','2014-05-02 20:55:11','2014-05-02 20:55:11','550af7f5-2608-4211-a041-bd645986f4e3');
INSERT INTO `craft_fieldgroups` VALUES (3,'Modifiers','2014-05-02 20:57:28','2014-05-02 20:57:32','84356ff9-7167-4818-a363-a6e20eb7b848');

--
-- Table structure for table `craft_fieldlayoutfields`
--

CREATE TABLE `craft_fieldlayoutfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `tabId` int(11) DEFAULT NULL,
  `fieldId` int(11) NOT NULL,
  `required` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sortOrder` tinyint(4) 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`),
  CONSTRAINT `craft_fieldlayoutfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fieldlayoutfields_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fieldlayoutfields_tabId_fk` FOREIGN KEY (`tabId`) REFERENCES `craft_fieldlayouttabs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_fieldlayoutfields`
--

INSERT INTO `craft_fieldlayoutfields` VALUES (3,5,2,2,1,1,'2014-05-02 20:46:20','2014-05-02 20:46:20','74644ef7-2a95-4258-b72e-4a26cecd4d73');
INSERT INTO `craft_fieldlayoutfields` VALUES (4,5,2,3,0,2,'2014-05-02 20:46:20','2014-05-02 20:46:20','f01bf147-5c12-4252-990c-2545f1c84629');
INSERT INTO `craft_fieldlayoutfields` VALUES (12,10,NULL,9,0,1,'2014-05-02 20:58:15','2014-05-02 20:58:15','886af530-d4c4-482d-ab44-841e807e5bf9');
INSERT INTO `craft_fieldlayoutfields` VALUES (13,10,NULL,10,0,2,'2014-05-02 20:58:15','2014-05-02 20:58:15','15149fd8-5d52-4938-912e-7b607e1f8e0a');
INSERT INTO `craft_fieldlayoutfields` VALUES (14,12,5,11,0,1,'2014-05-02 20:59:07','2014-05-02 20:59:07','0c10466a-8e9e-488b-9b03-b29144b82a0a');
INSERT INTO `craft_fieldlayoutfields` VALUES (15,13,NULL,5,0,1,'2014-05-02 20:59:40','2014-05-02 20:59:40','79118499-b1af-4565-aff4-dc6fa140914c');
INSERT INTO `craft_fieldlayoutfields` VALUES (16,13,NULL,6,0,2,'2014-05-02 20:59:40','2014-05-02 20:59:40','ca54db95-4faf-4aca-80ff-8f0f21496191');
INSERT INTO `craft_fieldlayoutfields` VALUES (17,13,NULL,12,0,3,'2014-05-02 20:59:40','2014-05-02 20:59:40','9c6584ef-98b1-4cac-a4e6-ad400ccd9dd4');
INSERT INTO `craft_fieldlayoutfields` VALUES (18,14,6,4,0,1,'2014-05-02 21:00:23','2014-05-02 21:00:23','494b6ea7-8a5a-4bbb-82f4-8d01cb2bbd3e');
INSERT INTO `craft_fieldlayoutfields` VALUES (19,14,7,9,0,1,'2014-05-02 21:00:23','2014-05-02 21:00:23','9ae1adbd-c564-44b2-bfbf-c750d0cd6941');
INSERT INTO `craft_fieldlayoutfields` VALUES (20,14,7,10,0,2,'2014-05-02 21:00:23','2014-05-02 21:00:23','eb46f561-6da6-4416-893b-6716d067db21');
INSERT INTO `craft_fieldlayoutfields` VALUES (21,16,8,4,0,1,'2014-05-02 21:05:55','2014-05-02 21:05:55','a314c1f4-1ccb-46d5-a141-a3038ac585dc');
INSERT INTO `craft_fieldlayoutfields` VALUES (22,16,9,9,0,1,'2014-05-02 21:05:55','2014-05-02 21:05:55','1d140f70-329c-49bb-81d8-eb4b4a482cdb');
INSERT INTO `craft_fieldlayoutfields` VALUES (23,16,9,10,0,2,'2014-05-02 21:05:55','2014-05-02 21:05:55','0528eea9-2e90-41f9-8a05-968dab3178ae');

--
-- Table structure 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=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_fieldlayouts`
--

INSERT INTO `craft_fieldlayouts` VALUES (1,'Tag','2014-05-02 20:46:20','2014-05-02 20:46:20','1bc8f84f-a5d6-4ddc-9a0d-b9ed44e32c66');
INSERT INTO `craft_fieldlayouts` VALUES (5,'Entry','2014-05-02 20:46:20','2014-05-02 20:46:20','e6f0af07-fdc2-4a43-96f2-a87ff86baa0f');
INSERT INTO `craft_fieldlayouts` VALUES (10,'GlobalSet','2014-05-02 20:58:15','2014-05-02 20:58:15','5d07ab18-1251-42ef-b7d7-1d41aaa871cb');
INSERT INTO `craft_fieldlayouts` VALUES (12,'Entry','2014-05-02 20:59:07','2014-05-02 20:59:07','9d4f37f8-fc1c-4290-9b7b-5c376b7f0d3a');
INSERT INTO `craft_fieldlayouts` VALUES (13,'MatrixBlock','2014-05-02 20:59:40','2014-05-02 20:59:40','782daea6-5a1a-415c-9d85-22a068f04651');
INSERT INTO `craft_fieldlayouts` VALUES (14,'Entry','2014-05-02 21:00:23','2014-05-02 21:00:23','20fb4df4-4211-471c-b030-987b1b546643');
INSERT INTO `craft_fieldlayouts` VALUES (15,'Asset','2014-05-02 21:01:01','2014-05-02 21:01:01','158fd48c-a068-4534-ada1-601319b2fa58');
INSERT INTO `craft_fieldlayouts` VALUES (16,'Entry','2014-05-02 21:05:55','2014-05-02 21:05:55','23a872ae-85a7-455b-80ca-1c12359b03d0');

--
-- Table structure 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` tinyint(4) 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`),
  CONSTRAINT `craft_fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_fieldlayouttabs`
--

INSERT INTO `craft_fieldlayouttabs` VALUES (2,5,'Content',1,'2014-05-02 20:46:20','2014-05-02 20:46:20','f80129a8-f175-4b54-b166-59db76a0ae3d');
INSERT INTO `craft_fieldlayouttabs` VALUES (5,12,'Modifier',1,'2014-05-02 20:59:07','2014-05-02 20:59:07','bf3711cf-98fe-4601-b5e4-e659b3057846');
INSERT INTO `craft_fieldlayouttabs` VALUES (6,14,'Content',1,'2014-05-02 21:00:23','2014-05-02 21:00:23','1e1e86a8-e553-403e-923e-ad86f377b568');
INSERT INTO `craft_fieldlayouttabs` VALUES (7,14,'SEO',2,'2014-05-02 21:00:23','2014-05-02 21:00:23','6c3f9753-1adc-4d50-a9d7-60175d769219');
INSERT INTO `craft_fieldlayouttabs` VALUES (8,16,'Content',1,'2014-05-02 21:05:55','2014-05-02 21:05:55','313c4166-52ea-4cb0-a234-2d3e9c63ade8');
INSERT INTO `craft_fieldlayouttabs` VALUES (9,16,'SEO',2,'2014-05-02 21:05:55','2014-05-02 21:05:55','9d9c05fd-a2b9-4f8e-b010-3d0c26006de7');

--
-- Table structure 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`),
  CONSTRAINT `craft_fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_fields`
--

INSERT INTO `craft_fields` VALUES (1,1,'Heading','heading','global',NULL,1,'PlainText',NULL,'2014-05-02 20:46:20','2014-05-02 20:46:20','d2d1020e-bf34-47ce-824f-827022d4c5b6');
INSERT INTO `craft_fields` VALUES (2,1,'Body','body','global',NULL,1,'RichText','{\"configFile\":\"Standard.json\"}','2014-05-02 20:46:20','2014-05-02 20:46:20','d114f0e2-e72b-49c3-978c-978932931a99');
INSERT INTO `craft_fields` VALUES (3,1,'Tags','tags','global',NULL,0,'Tags','{\"source\":\"taggroup:1\"}','2014-05-02 20:46:20','2014-05-02 20:46:20','cd8f2afd-ed50-4aa0-9a59-5fa6d31b0ab8');
INSERT INTO `craft_fields` VALUES (4,1,'Sections','sections','global','',0,'Matrix','{\"maxBlocks\":null}','2014-05-02 20:50:50','2014-05-02 20:59:40','e8685570-e090-48cf-ac14-418877b80a6e');
INSERT INTO `craft_fields` VALUES (5,NULL,'Header','header','matrixBlockType:1',NULL,0,'RichText','{\"configFile\":\"Standard.json\",\"cleanupHtml\":\"1\"}','2014-05-02 20:50:51','2014-05-02 20:59:40','b3e398f4-d0c4-4d83-baa5-6ea13883955e');
INSERT INTO `craft_fields` VALUES (6,NULL,'Body','body','matrixBlockType:1',NULL,0,'RichText','{\"configFile\":\"Standard.json\",\"cleanupHtml\":\"1\"}','2014-05-02 20:50:51','2014-05-02 20:59:40','88beb73a-0af3-4221-9dbd-5eb5117c058d');
INSERT INTO `craft_fields` VALUES (9,2,'Meta Title','metaTitle','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"\",\"multiline\":\"\",\"initialRows\":\"4\"}','2014-05-02 20:56:48','2014-05-02 20:56:48','e1c7c09b-8815-4bee-97f2-d31b081948bc');
INSERT INTO `craft_fields` VALUES (10,2,'Meta Description','metaDescription','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"\",\"multiline\":\"\",\"initialRows\":\"4\"}','2014-05-02 20:57:11','2014-05-02 20:57:11','3ef128aa-aec5-48a1-8745-a9f301d6ab25');
INSERT INTO `craft_fields` VALUES (11,3,'Class Name','className','global','',0,'PlainText','{\"placeholder\":\"\",\"maxLength\":\"\",\"multiline\":\"\",\"initialRows\":\"4\"}','2014-05-02 20:57:57','2014-05-02 20:57:57','afc5739d-da90-4277-8d9e-af853bc56a04');
INSERT INTO `craft_fields` VALUES (12,NULL,'Modifiers','modifiers','matrixBlockType:1',NULL,0,'Entries','{\"sources\":[\"section:4\"],\"limit\":\"\"}','2014-05-02 20:59:40','2014-05-02 20:59:40','f01ecaac-43c0-4868-b13c-b1d3b9f7628c');

--
-- Table structure 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`),
  CONSTRAINT `craft_globalsets_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_globalsets_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_globalsets`
--

INSERT INTO `craft_globalsets` VALUES (4,'SEO','seo',10,'2014-05-02 20:51:59','2014-05-02 20:58:15','3a1f1b2c-132a-4c59-ad38-cee486fe5956');

--
-- Table structure for table `craft_info`
--

CREATE TABLE `craft_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `build` int(11) unsigned NOT NULL,
  `schemaVersion` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `releaseDate` datetime 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',
  `track` varchar(40) 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_info`
--

INSERT INTO `craft_info` VALUES (1,'2.0',2538,'2.0.0','2014-05-01 19:25:14',1,'Craft','/','UTC',1,0,'stable','2014-05-02 20:46:17','2014-05-02 21:05:10','e289104d-11a5-4981-8e58-5efc6050058f');

--
-- Table structure for table `craft_locales`
--

CREATE TABLE `craft_locales` (
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` tinyint(4) 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;

--
-- Dumping data for table `craft_locales`
--

INSERT INTO `craft_locales` VALUES ('en_us',1,'2014-05-02 20:46:17','2014-05-02 20:46:17','dd1cdaf3-74e4-481e-83be-cd3768fe291e');

--
-- Table structure 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,
  `ownerLocale` char(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` tinyint(4) 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`),
  CONSTRAINT `craft_matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_matrixblocktypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_ownerLocale_fk` FOREIGN KEY (`ownerLocale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_matrixblocks`
--

INSERT INTO `craft_matrixblocks` VALUES (6,2,4,1,NULL,1,'2014-05-02 21:02:31','2014-05-02 21:02:31','94c90d02-f9de-4c11-a186-31464555a5cf');
INSERT INTO `craft_matrixblocks` VALUES (8,7,4,1,NULL,1,'2014-05-02 21:03:16','2014-05-02 21:03:16','d0f97267-a07d-48dc-ad42-4c87b90b980b');
INSERT INTO `craft_matrixblocks` VALUES (10,9,4,1,NULL,1,'2014-05-02 21:04:12','2014-05-02 21:04:12','f077b9d9-9d10-41e3-89b3-cdf9c00eef90');

--
-- Table structure 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` tinyint(4) 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`),
  CONSTRAINT `craft_matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_matrixblocktypes`
--

INSERT INTO `craft_matrixblocktypes` VALUES (1,4,13,'Generic','generic',1,'2014-05-02 20:50:50','2014-05-02 20:59:40','c2644c6a-b2d7-4e9f-9e93-4ab24d0e87f5');

--
-- Table structure for table `craft_matrixcontent_sections`
--

CREATE TABLE `craft_matrixcontent_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `locale` char(12) COLLATE utf8_unicode_ci NOT NULL,
  `field_generic_header` text COLLATE utf8_unicode_ci,
  `field_generic_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_matrixcontent_sections_elementId_locale_unq_idx` (`elementId`,`locale`),
  KEY `craft_matrixcontent_sections_locale_fk` (`locale`),
  CONSTRAINT `craft_matrixcontent_sections_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixcontent_sections_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_matrixcontent_sections`
--

INSERT INTO `craft_matrixcontent_sections` VALUES (1,6,'en_us','<h1>This is a generic section on the home page.</h1>','','2014-05-02 21:02:31','2014-05-02 21:02:31','ded33cb7-ba4a-4886-8665-bf058a928a51');
INSERT INTO `craft_matrixcontent_sections` VALUES (2,8,'en_us','<h1>This is a generic section on a first-level page.</h1>','','2014-05-02 21:03:16','2014-05-02 21:03:16','08384771-21e5-4e05-b3ec-5cb05069697a');
INSERT INTO `craft_matrixcontent_sections` VALUES (3,10,'en_us','<h1>This is a generic section on a second-level page.</h1>','','2014-05-02 21:04:12','2014-05-02 21:04:12','09ea341c-a5d2-4f61-a5b1-e9c2df54ebf6');

--
-- Table structure 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`),
  CONSTRAINT `craft_migrations_pluginId_fk` FOREIGN KEY (`pluginId`) REFERENCES `craft_plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_migrations`
--

INSERT INTO `craft_migrations` VALUES (1,NULL,'m000000_000000_base','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','edaa84d8-b680-4827-9206-0c1456a758ea');
INSERT INTO `craft_migrations` VALUES (2,NULL,'m131203_000000_allow_orphan_assets','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','7a82b8af-4801-41f7-8c23-50b0682a4199');
INSERT INTO `craft_migrations` VALUES (3,NULL,'m131212_000001_add_missing_fk_to_emailmessages','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','b5b7b814-66a7-4543-9e7c-4ac3c595ae16');
INSERT INTO `craft_migrations` VALUES (4,NULL,'m140123_000000_update_widget_sort_orders','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','56b48172-7c0d-417a-9f8a-42be1807e5e1');
INSERT INTO `craft_migrations` VALUES (5,NULL,'m140212_000000_clean_up_structures','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','985e96cc-5c65-44c1-914e-b1eaddb0d7fd');
INSERT INTO `craft_migrations` VALUES (6,NULL,'m140217_000000_add_missing_indexes','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','503a3b2e-5805-41a6-ade1-ec55d84a418b');
INSERT INTO `craft_migrations` VALUES (7,NULL,'m140223_000000_add_missing_element_rows','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','d4d90559-676f-4d77-9967-e54ded3ff4cd');
INSERT INTO `craft_migrations` VALUES (8,NULL,'m140325_000000_fix_matrix_settings','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','3db74c9c-6fe5-46f6-845c-3092f74aba3f');
INSERT INTO `craft_migrations` VALUES (9,NULL,'m140401_000000_assignUserPermissions_permission','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','ee279a61-272c-438f-8997-af1a135fb04e');
INSERT INTO `craft_migrations` VALUES (10,NULL,'m140401_000000_delete_the_deleted_files','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','833992f2-e337-45db-ae9b-f9fca3ba72ec');
INSERT INTO `craft_migrations` VALUES (11,NULL,'m140401_000001_structures','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','c763896a-4ca3-497c-a394-935b965189a3');
INSERT INTO `craft_migrations` VALUES (12,NULL,'m140401_000002_elements_i18n_tweaks','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','888c0b78-30b1-4851-979c-b22032131271');
INSERT INTO `craft_migrations` VALUES (13,NULL,'m140401_000003_tag_groups','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','3f53c652-e017-49b0-9f94-3c47c0f7bc67');
INSERT INTO `craft_migrations` VALUES (14,NULL,'m140401_000004_add_unverifiedemail_column_to_users','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','b8cddb33-e3a5-444f-8575-5327030d3dea');
INSERT INTO `craft_migrations` VALUES (15,NULL,'m140401_000005_translatable_matrix_fields','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','3e919a50-fe8d-480e-a918-34807a4cb2c0');
INSERT INTO `craft_migrations` VALUES (16,NULL,'m140401_000006_translatable_relation_fields','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','b26905e0-df19-4d01-bad3-1d4ece150275');
INSERT INTO `craft_migrations` VALUES (17,NULL,'m140401_000007_add_enabledbydefault_column_to_sections_i18n','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','20881a53-bf19-419d-9ed7-898362532115');
INSERT INTO `craft_migrations` VALUES (18,NULL,'m140401_000008_fullpath_to_path','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','04fc7bbd-8a64-4380-8b5e-9dd0a148296f');
INSERT INTO `craft_migrations` VALUES (19,NULL,'m140401_000009_asset_field_layouts','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','c1de18a7-0147-4b8b-9514-f62f1eb00363');
INSERT INTO `craft_migrations` VALUES (20,NULL,'m140401_000010_no_section_default_author','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','7a7d2967-50bd-4447-9f2d-96a6fc8a2a61');
INSERT INTO `craft_migrations` VALUES (21,NULL,'m140401_000011_categories','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','e23eac42-c2c3-4f88-a1f4-8621f8fdddc4');
INSERT INTO `craft_migrations` VALUES (22,NULL,'m140401_000012_templatecaches','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','681b826e-9be0-4458-8db1-d5ed8df77cb4');
INSERT INTO `craft_migrations` VALUES (23,NULL,'m140401_000013_allow_temp_source_transforms','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','55abf09d-1b96-43bd-88a2-c615085a8e18');
INSERT INTO `craft_migrations` VALUES (24,NULL,'m140401_000014_entry_title_formats','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','b6dbfd59-1753-4116-aea4-83c48257b058');
INSERT INTO `craft_migrations` VALUES (25,NULL,'m140401_000015_tasks','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','c05b9a37-d7bc-48d2-84d9-a228bf9c0838');
INSERT INTO `craft_migrations` VALUES (26,NULL,'m140401_000016_varchar_classes','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','ef306ebe-706e-4b0f-afa8-3b1e0225d024');
INSERT INTO `craft_migrations` VALUES (27,NULL,'m140401_000017_add_transform_quality','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','bc945151-773e-405e-8016-800c664778e8');
INSERT INTO `craft_migrations` VALUES (28,NULL,'m140401_000018_locale_routes','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','476b7528-44a6-4816-bbf9-5ace2acb93ea');
INSERT INTO `craft_migrations` VALUES (29,NULL,'m140401_000019_editions','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','32107c18-a69d-4751-8d00-1ca50b6619ca');
INSERT INTO `craft_migrations` VALUES (30,NULL,'m140401_000019_rackspace_auth_api','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','f227a208-1360-404f-9034-cd54fe7002a1');
INSERT INTO `craft_migrations` VALUES (31,NULL,'m140401_000020_deprecationerrors_table','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','609606fc-3c96-4efa-84ee-d69d450538b5');
INSERT INTO `craft_migrations` VALUES (32,NULL,'m140401_000021_client_user','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','b167d974-a437-4299-b073-6ea276d0d637');
INSERT INTO `craft_migrations` VALUES (33,NULL,'m140401_100000_resave_elements','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','27046021-781e-4327-8e66-d4369b5e1d72');
INSERT INTO `craft_migrations` VALUES (34,NULL,'m140401_100002_delete_compiled_templates','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','bb01b0ea-fbf0-48f7-910a-cddf4b1712f0');
INSERT INTO `craft_migrations` VALUES (35,NULL,'m140403_000000_allow_orphan_assets_again','2014-05-02 20:46:17','2014-05-02 20:46:17','2014-05-02 20:46:17','1bc6fd3d-d859-44c5-9103-d26437aad369');

--
-- Table structure 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` char(15) COLLATE utf8_unicode_ci NOT NULL,
  `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;

--
-- Dumping data for table `craft_plugins`
--


--
-- Table structure 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` tinyint(4) 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`),
  CONSTRAINT `craft_relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_relations_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_relations_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_relations_sourceLocale_fk` FOREIGN KEY (`sourceLocale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_relations`
--


--
-- Table structure 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` tinyint(4) 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_routes_urlPattern_unq_idx` (`urlPattern`),
  KEY `craft_routes_locale_idx` (`locale`),
  CONSTRAINT `craft_routes_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_routes`
--


--
-- Table structure 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;

--
-- Dumping data for table `craft_searchindex`
--

INSERT INTO `craft_searchindex` VALUES (1,'username',0,'en_us',' admin ');
INSERT INTO `craft_searchindex` VALUES (1,'firstname',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (1,'lastname',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (1,'fullname',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (1,'email',0,'en_us',' admin localhost local ');
INSERT INTO `craft_searchindex` VALUES (1,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (2,'field',1,'en_us',' welcome to craft dev ');
INSERT INTO `craft_searchindex` VALUES (2,'field',2,'en_us',' it s true this site doesn t have a whole lot of content yet but don t worry our web developers have just installed the cms and they re setting things up for the content editors this very moment soon craft dev will be an oasis of fresh perspectives sharp analyses and astute opinions that will keep you coming back again and again ');
INSERT INTO `craft_searchindex` VALUES (2,'slug',0,'en_us',' homepage ');
INSERT INTO `craft_searchindex` VALUES (2,'title',0,'en_us',' homepage ');
INSERT INTO `craft_searchindex` VALUES (3,'field',2,'en_us',' craft is the cms that s powering craft dev it s beautiful powerful flexible and easy to use and it s made by pixel tonic we can t wait to dive in and see what it s capable of this is even more captivating content which you couldn t see on the news index page because it was entered after a page break and the news index template only likes to show the content on the first page craft a nice alternative to word if you re making a website ');
INSERT INTO `craft_searchindex` VALUES (3,'field',3,'en_us','');
INSERT INTO `craft_searchindex` VALUES (3,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (3,'title',0,'en_us',' we just installed craft ');
INSERT INTO `craft_searchindex` VALUES (4,'field',7,'en_us',' default meta title ');
INSERT INTO `craft_searchindex` VALUES (4,'field',8,'en_us',' default meta description ');
INSERT INTO `craft_searchindex` VALUES (4,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (4,'field',9,'en_us',' default meta title ');
INSERT INTO `craft_searchindex` VALUES (4,'field',10,'en_us',' default meta description ');
INSERT INTO `craft_searchindex` VALUES (5,'filename',0,'en_us',' keith headshot jpg ');
INSERT INTO `craft_searchindex` VALUES (5,'extension',0,'en_us',' jpg ');
INSERT INTO `craft_searchindex` VALUES (5,'kind',0,'en_us',' image ');
INSERT INTO `craft_searchindex` VALUES (5,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (5,'title',0,'en_us',' keith headshot ');
INSERT INTO `craft_searchindex` VALUES (2,'field',4,'en_us','');
INSERT INTO `craft_searchindex` VALUES (2,'field',9,'en_us','');
INSERT INTO `craft_searchindex` VALUES (2,'field',10,'en_us','');
INSERT INTO `craft_searchindex` VALUES (6,'field',5,'en_us',' this is a generic section on the home page ');
INSERT INTO `craft_searchindex` VALUES (6,'field',6,'en_us','');
INSERT INTO `craft_searchindex` VALUES (6,'field',12,'en_us','');
INSERT INTO `craft_searchindex` VALUES (6,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (7,'field',4,'en_us','');
INSERT INTO `craft_searchindex` VALUES (7,'slug',0,'en_us',' first level page ');
INSERT INTO `craft_searchindex` VALUES (7,'title',0,'en_us',' first level page ');
INSERT INTO `craft_searchindex` VALUES (8,'field',5,'en_us',' this is a generic section on a first level page ');
INSERT INTO `craft_searchindex` VALUES (8,'field',6,'en_us','');
INSERT INTO `craft_searchindex` VALUES (8,'field',12,'en_us','');
INSERT INTO `craft_searchindex` VALUES (8,'slug',0,'en_us','');
INSERT INTO `craft_searchindex` VALUES (9,'field',4,'en_us','');
INSERT INTO `craft_searchindex` VALUES (9,'slug',0,'en_us',' second level page ');
INSERT INTO `craft_searchindex` VALUES (9,'title',0,'en_us',' second level page ');
INSERT INTO `craft_searchindex` VALUES (10,'field',5,'en_us',' this is a generic section on a second level page ');
INSERT INTO `craft_searchindex` VALUES (10,'field',6,'en_us','');
INSERT INTO `craft_searchindex` VALUES (10,'field',12,'en_us','');
INSERT INTO `craft_searchindex` VALUES (10,'slug',0,'en_us','');

--
-- Table structure 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,
  `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`),
  CONSTRAINT `craft_sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_sections`
--

INSERT INTO `craft_sections` VALUES (1,NULL,'Homepage','homepage','single',1,'index','2014-05-02 20:46:20','2014-05-02 20:46:20','9d718cdf-51e6-49f9-b1da-4db824dc1718');
INSERT INTO `craft_sections` VALUES (3,1,'Pages','pages','structure',1,'index','2014-05-02 20:49:19','2014-05-02 20:49:19','2b10bc0d-5689-42b4-acb7-d2ca61b3d3a8');
INSERT INTO `craft_sections` VALUES (4,NULL,'Section Modifiers','sectionModifiers','channel',0,NULL,'2014-05-02 20:58:44','2014-05-02 20:58:44','1b21637f-bdae-40eb-adfc-00372e93bd7b');

--
-- Table structure 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` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nestedUrlFormat` 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_sections_i18n_sectionId_locale_unq_idx` (`sectionId`,`locale`),
  KEY `craft_sections_i18n_locale_fk` (`locale`),
  CONSTRAINT `craft_sections_i18n_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_sections_i18n_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_sections_i18n`
--

INSERT INTO `craft_sections_i18n` VALUES (1,1,'en_us',1,'__home__',NULL,'2014-05-02 20:46:20','2014-05-02 20:46:20','91720e1b-e2f8-4afd-9ad7-3af7c9368e22');
INSERT INTO `craft_sections_i18n` VALUES (3,3,'en_us',0,'{slug}','{parent.uri}/{slug}','2014-05-02 20:49:19','2014-05-02 20:49:19','f71f214c-2a64-4d10-b9b3-662745453101');
INSERT INTO `craft_sections_i18n` VALUES (4,4,'en_us',0,NULL,NULL,'2014-05-02 20:58:44','2014-05-02 20:58:44','4aa047ae-b62c-420b-b45d-37cc5ce5c647');

--
-- Table structure 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`),
  CONSTRAINT `craft_shunnedmessages_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_shunnedmessages`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_structureelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_structureelements_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_structureelements`
--

INSERT INTO `craft_structureelements` VALUES (1,1,NULL,1,1,6,0,'2014-05-02 21:03:16','2014-05-02 21:03:16','e908b0e9-99a9-4a5d-bb1d-45c6463516b2');
INSERT INTO `craft_structureelements` VALUES (2,1,7,1,2,5,1,'2014-05-02 21:03:16','2014-05-02 21:03:16','417cb1dd-f9fb-454f-8139-1897eba4e4c1');
INSERT INTO `craft_structureelements` VALUES (3,1,9,1,3,4,2,'2014-05-02 21:04:12','2014-05-02 21:04:12','bb9e4f21-7c7d-4445-b06b-cece5618770c');

--
-- Table structure for table `craft_structures`
--

CREATE TABLE `craft_structures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maxLevels` smallint(6) unsigned DEFAULT NULL,
  `movePermission` 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_structures`
--

INSERT INTO `craft_structures` VALUES (1,NULL,NULL,'2014-05-02 20:49:19','2014-05-02 20:49:19','29d17dd8-33bc-40f5-84a8-d061655efac5');

--
-- Table structure 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;

--
-- Dumping data for table `craft_systemsettings`
--

INSERT INTO `craft_systemsettings` VALUES (1,'email','{\"protocol\":\"php\",\"emailAddress\":\"admin@localhost.local\",\"senderName\":\"Craft\"}','2014-05-02 20:46:20','2014-05-02 20:46:20','1b4247df-df6a-453b-bdab-9548aac8b16c');

--
-- Table structure 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`),
  CONSTRAINT `craft_taggroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_taggroups`
--

INSERT INTO `craft_taggroups` VALUES (1,'Default','default',1,'2014-05-02 20:46:20','2014-05-02 20:46:20','ecff35fd-e4bd-4d98-99d9-f9a70fd24172');

--
-- Table structure for table `craft_tags`
--

CREATE TABLE `craft_tags` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `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_tags_name_groupId_unq_idx` (`name`,`groupId`),
  KEY `craft_tags_groupId_fk` (`groupId`),
  CONSTRAINT `craft_tags_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_taggroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_tags_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_tags`
--


--
-- Table structure 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` 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`),
  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 AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_tasks`
--


--
-- Table structure for table `craft_templatecachecriteria`
--

CREATE TABLE `craft_templatecachecriteria` (
  `cacheId` int(11) NOT NULL,
  `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `criteria` text COLLATE utf8_unicode_ci NOT NULL,
  KEY `craft_templatecachecriteria_cacheId_fk` (`cacheId`),
  CONSTRAINT `craft_templatecachecriteria_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_templatecachecriteria`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_templatecacheelements`
--


--
-- Table structure for table `craft_templatecaches`
--

CREATE TABLE `craft_templatecaches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheKey` varchar(36) 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_expiryDate_cacheKey_locale_path_idx` (`expiryDate`,`cacheKey`,`locale`,`path`),
  KEY `craft_templatecaches_locale_fk` (`locale`),
  CONSTRAINT `craft_templatecaches_locale_fk` FOREIGN KEY (`locale`) REFERENCES `craft_locales` (`locale`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_templatecaches`
--


--
-- Table structure 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_usergroups`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_usergroups_users`
--


--
-- Table structure 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;

--
-- Dumping data for table `craft_userpermissions`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_userpermissions_usergroups_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_userpermissions_usergroups_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_userpermissions_usergroups`
--


--
-- Table structure 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`),
  CONSTRAINT `craft_userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_userpermissions_users`
--


--
-- Table structure 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` tinyint(4) 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`),
  CONSTRAINT `craft_widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `craft_widgets`
--

INSERT INTO `craft_widgets` VALUES (1,1,'QuickPost',1,'{\"section\":\"2\"}',1,'2014-05-02 20:47:13','2014-05-02 20:47:13','941d2821-de11-4122-9e2b-f7313a74ab22');
INSERT INTO `craft_widgets` VALUES (2,1,'RecentEntries',2,NULL,1,'2014-05-02 20:47:13','2014-05-02 20:47:13','23d2072e-bea8-43f7-b72a-56d7a584635d');
INSERT INTO `craft_widgets` VALUES (3,1,'GetHelp',3,NULL,1,'2014-05-02 20:47:13','2014-05-02 20:47:13','8269c1dc-ce70-4457-a03d-7d6d34ddd037');
INSERT INTO `craft_widgets` VALUES (4,1,'Updates',4,NULL,1,'2014-05-02 20:47:13','2014-05-02 20:47:13','531311bc-0473-4f8f-aa5f-902789268e15');
INSERT INTO `craft_widgets` VALUES (5,1,'Feed',5,'{\"url\":\"http:\\/\\/feeds.feedburner.com\\/blogandtonic\",\"title\":\"Blog & Tonic\"}',1,'2014-05-02 20:47:13','2014-05-02 20:47:13','943b9d9a-0c07-417e-b09f-2ffa3c9a5bae');


