File: /home/accemeff/vendor/craftcms/cms/tests/_data/dump.sql
# ************************************************************
# Sequel Pro SQL dump
# Version 4749
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: localhost (MySQL 5.6.33)
# Database: craft3
# Generation Time: 2016-11-02 22:04:14 +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 */;
SET NAMES utf8mb4;
/*!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 craft_assetindexdata
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_assetindexdata`;
CREATE TABLE `craft_assetindexdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sessionId` varchar(36) NOT NULL DEFAULT '',
`volumeId` int(11) NOT NULL,
`offset` int(11) NOT NULL,
`uri` text,
`size` bigint(20) unsigned DEFAULT NULL,
`timestamp` datetime DEFAULT NULL,
`recordId` int(11) DEFAULT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_assetindexdata_sessionId_volumeId_offset_unq_idx` (`sessionId`,`volumeId`,`offset`),
KEY `craft_assetindexdata_volumeId_idx` (`volumeId`),
CONSTRAINT `craft_assetindexdata_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_assets
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_assets`;
CREATE TABLE `craft_assets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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,
`dateModified` datetime DEFAULT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_assets_filename_folderId_unq_idx` (`filename`,`folderId`),
KEY `craft_assets_folderId_idx` (`folderId`),
KEY `craft_assets_volumeId_idx` (`volumeId`),
CONSTRAINT `craft_assets_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `craft_volumefolders` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_assets_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_assets_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_assettransformindex
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_assettransformindex`;
CREATE TABLE `craft_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 `craft_assettransformindex_volumeId_assetId_location_idx` (`volumeId`,`assetId`,`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_assettransforms
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_assettransforms`;
CREATE TABLE `craft_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,
`dimensionChangeTime` datetime DEFAULT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) 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;
# Dump of table craft_categories
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_categories`;
CREATE TABLE `craft_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupId` int(11) NOT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `craft_categories_groupId_idx` (`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;
# Dump of table craft_categorygroups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) 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 `craft_categorygroups_name_unq_idx` (`name`),
UNIQUE KEY `craft_categorygroups_handle_unq_idx` (`handle`),
KEY `craft_categorygroups_structureId_idx` (`structureId`),
KEY `craft_categorygroups_fieldLayoutId_idx` (`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;
# Dump of table craft_categorygroups_i18n
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_categorygroups_sites`;
CREATE TABLE `craft_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 `craft_categorygroups_i18n_groupId_siteId_unq_idx` (`groupId`,`siteId`),
KEY `craft_categorygroups_i18n_siteId_idx` (`siteId`),
CONSTRAINT `craft_categorygroups_i18n_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_categorygroups_i18n_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_content
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_content`;
CREATE TABLE `craft_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 `craft_content_elementId_siteId_unq_idx` (`elementId`,`siteId`),
KEY `craft_content_siteId_idx` (`siteId`),
KEY `craft_content_title_idx` (`title`),
CONSTRAINT `craft_content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_content_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_content` WRITE;
/*!40000 ALTER TABLE `craft_content` DISABLE KEYS */;
INSERT INTO `craft_content` (`id`, `elementId`, `siteId`, `title`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,1,1,NULL,'2016-11-02 22:03:41','2016-11-02 22:03:41','6057b12f-c10e-4ac0-b6d2-b14619e75247');
/*!40000 ALTER TABLE `craft_content` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_deprecationerrors
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_deprecationerrors`;
CREATE TABLE `craft_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 NOT NULL,
`class` varchar(255) DEFAULT NULL,
`method` varchar(255) DEFAULT NULL,
`template` varchar(500) DEFAULT NULL,
`templateLine` 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 `craft_deprecationerrors_key_fingerprint_unq_idx` (`key`,`fingerprint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_elementindexsettings
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_elementindexsettings`;
CREATE TABLE `craft_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 `craft_elementindexsettings_type_unq_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_elements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_elements`;
CREATE TABLE `craft_elements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 `craft_elements_type_idx` (`type`),
KEY `craft_elements_enabled_idx` (`enabled`),
KEY `craft_elements_archived_dateCreated_idx` (`archived`,`dateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_elements` WRITE;
/*!40000 ALTER TABLE `craft_elements` DISABLE KEYS */;
INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,'craft\\app\\elements\\User',1,0,'2016-11-02 22:03:41','2016-11-02 22:03:41','1551d11c-4f09-4ef7-aab7-1504087b079e');
/*!40000 ALTER TABLE `craft_elements` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_elements_i18n
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_elements_sites`;
CREATE TABLE `craft_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 `craft_elements_i18n_elementId_siteId_unq_idx` (`elementId`,`siteId`),
UNIQUE KEY `craft_elements_i18n_uri_siteId_unq_idx` (`uri`,`siteId`),
KEY `craft_elements_i18n_siteId_idx` (`siteId`),
KEY `craft_elements_i18n_slug_siteId_idx` (`slug`,`siteId`),
KEY `craft_elements_i18n_enabled_idx` (`enabled`),
CONSTRAINT `craft_elements_i18n_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_elements_i18n_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_elements_sites` WRITE;
/*!40000 ALTER TABLE `craft_elements_sites` DISABLE KEYS */;
INSERT INTO `craft_elements_sites` (`id`, `elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,1,1,'',NULL,1,'2016-11-02 22:03:41','2016-11-02 22:03:41','87e9e57c-5586-4fc6-8ffe-fa5dc453fd55');
/*!40000 ALTER TABLE `craft_elements_sites` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_emailmessages
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_emailmessages`;
CREATE TABLE `craft_emailmessages` (
`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 `craft_emailmessages_key_language_unq_idx` (`key`,`language`),
KEY `craft_emailmessages_language_idx` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_entries
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_entries`;
CREATE TABLE `craft_entries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 `craft_entries_postDate_idx` (`postDate`),
KEY `craft_entries_expiryDate_idx` (`expiryDate`),
KEY `craft_entries_authorId_idx` (`authorId`),
KEY `craft_entries_sectionId_idx` (`sectionId`),
KEY `craft_entries_typeId_idx` (`typeId`),
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;
# Dump of table craft_entrydrafts
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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,
`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 `craft_entrydrafts_sectionId_idx` (`sectionId`),
KEY `craft_entrydrafts_entryId_siteId_idx` (`entryId`,`siteId`),
KEY `craft_entrydrafts_siteId_idx` (`siteId`),
KEY `craft_entrydrafts_creatorId_idx` (`creatorId`),
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,
CONSTRAINT `craft_entrydrafts_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_entrytypes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) NOT NULL,
`handle` varchar(255) NOT NULL,
`hasTitleField` tinyint(1) NOT NULL DEFAULT '1',
`titleLabel` varchar(255) DEFAULT NULL,
`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 `craft_entrytypes_name_sectionId_unq_idx` (`name`,`sectionId`),
UNIQUE KEY `craft_entrytypes_handle_sectionId_unq_idx` (`handle`,`sectionId`),
KEY `craft_entrytypes_sectionId_idx` (`sectionId`),
KEY `craft_entrytypes_fieldLayoutId_idx` (`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 DEFAULT CHARSET=utf8;
# Dump of table craft_entryversions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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,
`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 `craft_entryversions_sectionId_idx` (`sectionId`),
KEY `craft_entryversions_entryId_siteId_idx` (`entryId`,`siteId`),
KEY `craft_entryversions_siteId_idx` (`siteId`),
KEY `craft_entryversions_creatorId_idx` (`creatorId`),
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,
CONSTRAINT `craft_entryversions_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_fieldgroups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_fieldgroups`;
CREATE TABLE `craft_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 `craft_fieldgroups_name_unq_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_fieldlayoutfields
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_fieldlayoutfields`;
CREATE TABLE `craft_fieldlayoutfields` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`layoutId` int(11) NOT NULL,
`tabId` int(11) NOT NULL,
`fieldId` int(11) NOT NULL,
`required` tinyint(1) 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 `craft_fieldlayoutfields_layoutId_fieldId_unq_idx` (`layoutId`,`fieldId`),
KEY `craft_fieldlayoutfields_sortOrder_idx` (`sortOrder`),
KEY `craft_fieldlayoutfields_tabId_idx` (`tabId`),
KEY `craft_fieldlayoutfields_fieldId_idx` (`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 DEFAULT CHARSET=utf8;
# Dump of table craft_fieldlayouts
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_fieldlayouts`;
CREATE TABLE `craft_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 `craft_fieldlayouts_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_fieldlayouttabs
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_fieldlayouttabs`;
CREATE TABLE `craft_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 `craft_fieldlayouttabs_sortOrder_idx` (`sortOrder`),
KEY `craft_fieldlayouttabs_layoutId_idx` (`layoutId`),
CONSTRAINT `craft_fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_fields
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_fields`;
CREATE TABLE `craft_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` enum('none','language','site','custom') 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 `craft_fields_handle_context_unq_idx` (`handle`,`context`),
KEY `craft_fields_groupId_idx` (`groupId`),
KEY `craft_fields_context_idx` (`context`),
CONSTRAINT `craft_fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_globalsets
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_globalsets`;
CREATE TABLE `craft_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 `craft_globalsets_name_unq_idx` (`name`),
UNIQUE KEY `craft_globalsets_handle_unq_idx` (`handle`),
KEY `craft_globalsets_fieldLayoutId_idx` (`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;
# Dump of table craft_info
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_info`;
CREATE TABLE `craft_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`version` varchar(15) NOT NULL,
`build` int(11) unsigned NOT NULL,
`schemaVersion` varchar(15) NOT NULL,
`releaseDate` datetime NOT NULL,
`edition` smallint(6) unsigned NOT NULL,
`timezone` varchar(30) DEFAULT NULL,
`on` tinyint(1) NOT NULL DEFAULT '0',
`maintenance` tinyint(1) NOT NULL DEFAULT '0',
`track` varchar(40) NOT NULL,
`fieldVersion` char(12) NOT NULL DEFAULT '1',
`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 `craft_info` WRITE;
/*!40000 ALTER TABLE `craft_info` DISABLE KEYS */;
INSERT INTO `craft_info` (`id`, `version`, `build`, `schemaVersion`, `releaseDate`, `edition`, `timezone`, `on`, `maintenance`, `track`, `fieldVersion`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,'3.0',9999,'3.0.22','2015-04-15 10:00:00',0,'America/Los_Angeles',1,0,'stable','S7xX09TXtGxm','2016-11-02 22:03:40','2016-11-02 22:03:40','077a0f13-180c-4064-8219-33cda1173bbc');
/*!40000 ALTER TABLE `craft_info` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_matrixblocks
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_matrixblocks`;
CREATE TABLE `craft_matrixblocks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 `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_ownerSiteId_idx` (`ownerSiteId`),
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_ownerSiteId_fk` FOREIGN KEY (`ownerSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `craft_matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_matrixblocktypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_matrixblocktypes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) 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 `craft_matrixblocktypes_name_fieldId_unq_idx` (`name`,`fieldId`),
UNIQUE KEY `craft_matrixblocktypes_handle_fieldId_unq_idx` (`handle`,`fieldId`),
KEY `craft_matrixblocktypes_fieldId_idx` (`fieldId`),
KEY `craft_matrixblocktypes_fieldLayoutId_idx` (`fieldLayoutId`),
CONSTRAINT `craft_matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_migrations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_migrations`;
CREATE TABLE `craft_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 `craft_migrations_pluginId_idx` (`pluginId`),
KEY `craft_migrations_type_pluginId_idx` (`type`,`pluginId`),
CONSTRAINT `craft_migrations_pluginId_fk` FOREIGN KEY (`pluginId`) REFERENCES `craft_plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_migrations` WRITE;
/*!40000 ALTER TABLE `craft_migrations` DISABLE KEYS */;
INSERT INTO `craft_migrations` (`id`, `pluginId`, `type`, `name`, `applyTime`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,NULL,'app','Install','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','4a6e6854-6d6d-4315-a38b-d3bfeca8f829'),
(2,NULL,'app','m150403_183908_migrations_table_changes','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','6352a20e-991f-44d6-bbd8-2c4215433485'),
(3,NULL,'app','m150403_184247_plugins_table_changes','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','24f21970-27e8-4b31-be59-cb533cc2b166'),
(4,NULL,'app','m150403_184533_field_version','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','a5b786c4-1fad-4fa4-bb2c-21494560b84b'),
(5,NULL,'app','m150403_184729_type_columns','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','8878c08b-7916-44c2-b5b2-02a3e3cba711'),
(6,NULL,'app','m150403_185142_volumes','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','3e9fa418-3ae4-4ca6-adab-1348ad9d8d1a'),
(7,NULL,'app','m150428_231346_userpreferences','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','7fc3b350-acea-4c77-a3d9-637328cf1c8d'),
(8,NULL,'app','m150519_150900_fieldversion_conversion','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','a5dba2c3-19b1-4ea0-aa5e-304b3c2fa24a'),
(9,NULL,'app','m150617_213829_update_email_settings','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','d72cbd20-5c97-4de2-8d54-291cb444490d'),
(10,NULL,'app','m150721_124739_templatecachequeries','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','73c8778f-e151-407c-99d9-d71aa9e485db'),
(11,NULL,'app','m150724_140822_adjust_quality_settings','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','f31aa485-4822-4394-9437-2e7a8bd30a6e'),
(12,NULL,'app','m150815_133521_last_login_attempt_ip','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','5fa8c624-c7e8-4161-a925-5802c25fa1c2'),
(13,NULL,'app','m151002_095935_volume_cache_settings','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','6e614cda-70f0-45ec-aaa5-865794618c44'),
(14,NULL,'app','m151005_142750_volume_s3_storage_settings','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','09192d74-8465-4364-972b-1121d599e1ee'),
(15,NULL,'app','m151016_133600_delete_asset_thumbnails','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','268e5e1d-a0db-4d0e-b4ba-44a60290c188'),
(16,NULL,'app','m151209_000000_move_logo','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','9692fc9a-1dd0-4459-9ee6-c746dc1847f4'),
(17,NULL,'app','m151211_000000_rename_fileId_to_assetId','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','1793b313-b173-44c9-824f-f44fd03c9bd0'),
(18,NULL,'app','m151215_000000_rename_asset_permissions','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','7b96860c-06be-4e87-89fc-48263e62653b'),
(19,NULL,'app','m160707_000000_rename_richtext_assetsource_setting','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','f094de75-3f43-4bd7-855b-6692767cf929'),
(20,NULL,'app','m160708_185142_volume_hasUrls_setting','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','9ed8613b-3287-4e8d-a82a-64d984fae1eb'),
(21,NULL,'app','m160714_000000_increase_max_asset_filesize','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','2310e00d-ba0a-41a1-a90d-c3d09770f9d5'),
(22,NULL,'app','m160727_194637_column_cleanup','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','0f71f088-f9de-4048-a088-64f26ca5686a'),
(23,NULL,'app','m160804_110002_userphotos_to_assets','2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','3fcef4b7-4831-4e1e-89d8-3072edb266b4'),
(24,NULL,'app','m160807_144858_sites','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','f731cdd3-1d70-4ff4-b265-68f45ea42230'),
(25,NULL,'app','m160817_161600_move_assets_cache','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','1a902756-2393-4ac4-b661-9b4e89e577ce'),
(26,NULL,'app','m160829_000000_pending_user_content_cleanup','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','64b75a66-be72-434d-a69b-4778bd40feea'),
(27,NULL,'app','m160830_000000_asset_index_uri_increase','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','252dc74f-ec15-4dd2-b519-d8f021eb5550'),
(28,NULL,'app','m160912_230520_require_entry_type_id','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','edc9fd2f-85ac-4fce-82cb-2d04af431e1e'),
(29,NULL,'app','m160913_134730_require_matrix_block_type_id','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','27481e1d-2da1-4b22-9daa-b63dc52969b7'),
(30,NULL,'app','m160920_174553_matrixblocks_owner_site_id_nullable','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','662b53ee-8ab8-400a-a4a0-d2f2fc560eaa'),
(31,NULL,'app','m160920_231045_usergroup_handle_title_unique','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','9c987447-78e7-4192-b176-dfaeb53f7feb'),
(32,NULL,'app','m160925_113941_route_uri_parts','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','92912e55-425d-4bcb-8202-16a62af74a12'),
(33,NULL,'app','m161006_205918_schemaVersion_not_null','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','9633518e-d388-402e-bf9b-819a6c20e360'),
(34,NULL,'app','m161007_130653_update_email_settings','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','5803cbbc-e203-4705-8bf2-3f8cf0ad5dcf'),
(35,NULL,'app','m161013_175052_newParentId','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','fd9fee85-2427-464f-b352-8a40e79d1c54'),
(36,NULL,'app','m161021_102916_fix_recent_entries_widgets','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','148c106a-be69-44d8-bbea-9572f432e911'),
(37,NULL,'app','m161021_182140_rename_get_help_widget','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','6168b42f-c98c-4c0f-af14-ed6cd1ceb32a'),
(38,NULL,'app','m161025_000000_fix_char_columns','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','6075d20d-89fe-4dc8-8e3d-42178452b852'),
(39,NULL,'app','m161029_124145_email_message_languages','2016-11-02 22:03:44','2016-11-02 22:03:44','2016-11-02 22:03:44','98a3c699-af46-4dfb-8723-669bbca5b2d7');
/*!40000 ALTER TABLE `craft_migrations` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_plugins
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_plugins`;
CREATE TABLE `craft_plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`handle` varchar(150) NOT NULL,
`version` varchar(15) NOT NULL,
`schemaVersion` varchar(15) NOT NULL,
`licenseKey` char(24) DEFAULT NULL,
`licenseKeyStatus` enum('valid','invalid','mismatched','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 `craft_plugins_handle_unq_idx` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_rackspaceaccess
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_rackspaceaccess`;
CREATE TABLE `craft_rackspaceaccess` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`connectionKey` varchar(255) NOT NULL,
`token` varchar(255) NOT NULL,
`storageUrl` varchar(255) NOT NULL,
`cdnUrl` varchar(255) NOT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_rackspaceaccess_connectionKey_unq_idx` (`connectionKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_relations
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_relations`;
CREATE TABLE `craft_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 `craft_relations_fieldId_sourceId_sourceSiteId_targetId_unq_idx` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
KEY `craft_relations_sourceId_idx` (`sourceId`),
KEY `craft_relations_targetId_idx` (`targetId`),
KEY `craft_relations_sourceSiteId_idx` (`sourceSiteId`),
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_sourceSiteId_fk` FOREIGN KEY (`sourceSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `craft_relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_routes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_routes`;
CREATE TABLE `craft_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`),
UNIQUE KEY `craft_routes_uriPattern_unq_idx` (`uriPattern`),
KEY `craft_routes_siteId_idx` (`siteId`),
CONSTRAINT `craft_routes_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_searchindex
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_searchindex`;
CREATE TABLE `craft_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 `craft_searchindex_keywords_idx` (`keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
LOCK TABLES `craft_searchindex` WRITE;
/*!40000 ALTER TABLE `craft_searchindex` DISABLE KEYS */;
INSERT INTO `craft_searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`)
VALUES
(1,'username',0,1,' test '),
(1,'firstname',0,1,''),
(1,'lastname',0,1,''),
(1,'fullname',0,1,''),
(1,'email',0,1,' test test com '),
(1,'slug',0,1,'');
/*!40000 ALTER TABLE `craft_searchindex` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_sections
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_sections`;
CREATE TABLE `craft_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',
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_sections_handle_unq_idx` (`handle`),
UNIQUE KEY `craft_sections_name_unq_idx` (`name`),
KEY `craft_sections_structureId_idx` (`structureId`),
CONSTRAINT `craft_sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_sections_i18n
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_sections_sites`;
CREATE TABLE `craft_sections_sites` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sectionId` int(11) NOT NULL,
`siteId` int(11) NOT NULL,
`enabledByDefault` tinyint(1) NOT NULL DEFAULT '1',
`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 `craft_sections_i18n_sectionId_siteId_unq_idx` (`sectionId`,`siteId`),
KEY `craft_sections_i18n_siteId_idx` (`siteId`),
CONSTRAINT `craft_sections_i18n_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_sections_i18n_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_sessions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_sessions`;
CREATE TABLE `craft_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 `craft_sessions_uid_idx` (`uid`),
KEY `craft_sessions_token_idx` (`token`),
KEY `craft_sessions_dateUpdated_idx` (`dateUpdated`),
KEY `craft_sessions_userId_idx` (`userId`),
CONSTRAINT `craft_sessions_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_shunnedmessages
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_shunnedmessages`;
CREATE TABLE `craft_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 `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;
# Dump of table craft_sites
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_sites`;
CREATE TABLE `craft_sites` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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 `craft_sites_handle_unq_idx` (`handle`),
KEY `craft_sites_sortOrder_idx` (`sortOrder`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_sites` WRITE;
/*!40000 ALTER TABLE `craft_sites` DISABLE KEYS */;
INSERT INTO `craft_sites` (`id`, `name`, `handle`, `language`, `hasUrls`, `baseUrl`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,'Craft3 Test','default','en-US',1,'http://craft3.craft.dev/',1,'2016-11-02 22:03:40','2016-11-02 22:03:40','8eaffa30-a254-4e20-8a60-f4146dba7b14');
/*!40000 ALTER TABLE `craft_sites` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_structureelements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) 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_idx` (`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 DEFAULT CHARSET=utf8;
# Dump of table craft_structures
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_structures`;
CREATE TABLE `craft_structures` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`maxLevels` smallint(6) unsigned DEFAULT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_systemsettings
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_systemsettings`;
CREATE TABLE `craft_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 `craft_systemsettings_category_unq_idx` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_systemsettings` WRITE;
/*!40000 ALTER TABLE `craft_systemsettings` DISABLE KEYS */;
INSERT INTO `craft_systemsettings` (`id`, `category`, `settings`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,'email','{\"fromEmail\":\"test@test.com\",\"fromName\":\"Craft3 Test\",\"transportType\":\"craft\\\\app\\\\mail\\\\transportadapters\\\\Php\"}','2016-11-02 22:03:43','2016-11-02 22:03:43','9c8d5dc0-64de-4d68-8a8b-f87ee7d24dd2'),
(2,'mailer','{\"class\":\"craft\\\\app\\\\mail\\\\Mailer\",\"from\":{\"test@test.com\":\"Craft3 Test\"},\"transport\":{\"class\":\"Swift_MailTransport\"}}','2016-11-02 22:03:43','2016-11-02 22:03:43','c93f87e2-bf92-4604-9333-fe4170b3893c');
/*!40000 ALTER TABLE `craft_systemsettings` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_taggroups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_taggroups`;
CREATE TABLE `craft_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 `craft_taggroups_name_unq_idx` (`name`),
UNIQUE KEY `craft_taggroups_handle_unq_idx` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_tags
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_tags`;
CREATE TABLE `craft_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupId` int(11) NOT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `craft_tags_groupId_idx` (`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;
# Dump of table craft_tasks
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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') DEFAULT NULL,
`type` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`settings` mediumtext NOT NULL,
`dateCreated` datetime NOT NULL,
`dateUpdated` datetime NOT NULL,
`uid` char(36) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `craft_tasks_root_idx` (`root`),
KEY `craft_tasks_lft_idx` (`lft`),
KEY `craft_tasks_rgt_idx` (`rgt`),
KEY `craft_tasks_level_idx` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_templatecacheelements
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_templatecacheelements`;
CREATE TABLE `craft_templatecacheelements` (
`cacheId` int(11) NOT NULL,
`elementId` int(11) NOT NULL,
KEY `craft_templatecacheelements_cacheId_idx` (`cacheId`),
KEY `craft_templatecacheelements_elementId_idx` (`elementId`),
CONSTRAINT `craft_templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_templatecachequeries
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_templatecachequeries`;
CREATE TABLE `craft_templatecachequeries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cacheId` int(11) NOT NULL,
`type` varchar(255) NOT NULL,
`query` text NOT NULL,
PRIMARY KEY (`id`),
KEY `craft_templatecachequeries_cacheId_idx` (`cacheId`),
KEY `craft_templatecachequeries_type_idx` (`type`),
CONSTRAINT `craft_templatecachequeries_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_templatecaches
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_templatecaches`;
CREATE TABLE `craft_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 `craft_templatecaches_expiryDate_cacheKey_siteId_path_idx` (`expiryDate`,`cacheKey`,`siteId`,`path`),
KEY `craft_templatecaches_siteId_idx` (`siteId`),
CONSTRAINT `craft_templatecaches_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_tokens
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_tokens`;
CREATE TABLE `craft_tokens` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`token` char(32) NOT NULL,
`route` text,
`usageLimit` smallint(6) unsigned DEFAULT NULL,
`usageCount` smallint(6) 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 `craft_tokens_token_unq_idx` (`token`),
KEY `craft_tokens_expiryDate_idx` (`expiryDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_usergroups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_usergroups`;
CREATE TABLE `craft_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 `craft_usergroups_handle_unq_idx` (`handle`),
UNIQUE KEY `craft_usergroups_name_unq_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_usergroups_users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_usergroups_users_groupId_userId_unq_idx` (`groupId`,`userId`),
KEY `craft_usergroups_users_userId_idx` (`userId`),
CONSTRAINT `craft_usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_userpermissions
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_userpermissions`;
CREATE TABLE `craft_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 `craft_userpermissions_name_unq_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_userpermissions_usergroups
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_userpermissions_usergroups_permissionId_groupId_unq_idx` (`permissionId`,`groupId`),
KEY `craft_userpermissions_usergroups_groupId_idx` (`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;
# Dump of table craft_userpermissions_users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `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) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `craft_userpermissions_users_permissionId_userId_unq_idx` (`permissionId`,`userId`),
KEY `craft_userpermissions_users_userId_idx` (`userId`),
CONSTRAINT `craft_userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_userpreferences
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_userpreferences`;
CREATE TABLE `craft_userpreferences` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`preferences` text,
PRIMARY KEY (`userId`),
CONSTRAINT `craft_userpreferences_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_users
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_users`;
CREATE TABLE `craft_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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',
`client` 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',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`lastLoginDate` datetime DEFAULT NULL,
`lastLoginAttemptIp` varchar(45) DEFAULT NULL,
`invalidLoginWindowStart` datetime DEFAULT NULL,
`invalidLoginCount` smallint(6) unsigned DEFAULT NULL,
`lastInvalidLoginDate` datetime DEFAULT NULL,
`lockoutDate` datetime DEFAULT NULL,
`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 `craft_users_username_unq_idx` (`username`),
UNIQUE KEY `craft_users_email_unq_idx` (`email`),
KEY `craft_users_uid_idx` (`uid`),
KEY `craft_users_verificationCode_idx` (`verificationCode`),
KEY `craft_users_photoId_fk` (`photoId`),
CONSTRAINT `craft_users_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_users_photoId_fk` FOREIGN KEY (`photoId`) REFERENCES `craft_assets` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_users` WRITE;
/*!40000 ALTER TABLE `craft_users` DISABLE KEYS */;
INSERT INTO `craft_users` (`id`, `username`, `photoId`, `firstName`, `lastName`, `email`, `password`, `admin`, `client`, `locked`, `suspended`, `pending`, `archived`, `lastLoginDate`, `lastLoginAttemptIp`, `invalidLoginWindowStart`, `invalidLoginCount`, `lastInvalidLoginDate`, `lockoutDate`, `verificationCode`, `verificationCodeIssuedDate`, `unverifiedEmail`, `passwordResetRequired`, `lastPasswordChangeDate`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,'test',NULL,NULL,NULL,'test@test.com','$2y$13$xg4hbdntTAk/uamJkZbxPOKaivuK5vHIKYXAah6Cu4lvWP5omPSuO',1,0,0,0,0,0,'2016-11-02 22:03:43','::1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'2016-11-02 22:03:43','2016-11-02 22:03:43','2016-11-02 22:03:43','e1bc4259-830a-4b85-a3ac-77b6a3f84df6');
/*!40000 ALTER TABLE `craft_users` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table craft_volumefolders
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_volumefolders`;
CREATE TABLE `craft_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 `craft_volumefolders_name_parentId_volumeId_unq_idx` (`name`,`parentId`,`volumeId`),
KEY `craft_volumefolders_parentId_idx` (`parentId`),
KEY `craft_volumefolders_volumeId_idx` (`volumeId`),
CONSTRAINT `craft_volumefolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_volumefolders` (`id`) ON DELETE CASCADE,
CONSTRAINT `craft_volumefolders_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_volumes
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_volumes`;
CREATE TABLE `craft_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 `craft_volumes_name_unq_idx` (`name`),
UNIQUE KEY `craft_volumes_handle_unq_idx` (`handle`),
KEY `craft_volumes_fieldLayoutId_idx` (`fieldLayoutId`),
CONSTRAINT `craft_volumes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Dump of table craft_widgets
# ------------------------------------------------------------
DROP TABLE IF EXISTS `craft_widgets`;
CREATE TABLE `craft_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 `craft_widgets_userId_idx` (`userId`),
CONSTRAINT `craft_widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `craft_widgets` WRITE;
/*!40000 ALTER TABLE `craft_widgets` DISABLE KEYS */;
INSERT INTO `craft_widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`)
VALUES
(1,1,'craft\\app\\widgets\\RecentEntries',NULL,0,'{\"section\":\"*\",\"siteId\":\"1\",\"limit\":10}',1,'2016-11-02 22:03:53','2016-11-02 22:03:53','4a3fb1c3-abf5-4c77-81c8-5249526d42ca'),
(2,1,'craft\\app\\widgets\\CraftSupport',NULL,0,'[]',1,'2016-11-02 22:03:53','2016-11-02 22:03:53','a21c22dc-695a-4d40-bae3-65273abf87b7'),
(3,1,'craft\\app\\widgets\\Updates',NULL,0,'[]',1,'2016-11-02 22:03:53','2016-11-02 22:03:53','3dfccf57-9b87-4c3b-8387-9a23d65523cd'),
(4,1,'craft\\app\\widgets\\Feed',NULL,0,'{\"url\":\"https://craftcms.com/news.rss\",\"title\":\"Craft News\",\"limit\":5}',1,'2016-11-02 22:03:53','2016-11-02 22:03:53','72197572-3212-459d-876a-4c117ba84e53');
/*!40000 ALTER TABLE `craft_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 */;