-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `camperswa`
--

-- --------------------------------------------------------

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `pluginId` int(11) DEFAULT NULL,
  `heading` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `unread` tinyint(1) NOT NULL DEFAULT 1,
  `dateRead` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int(11) NOT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `folderId` int(11) NOT NULL,
  `uploaderId` int(11) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `kind` varchar(50) NOT NULL DEFAULT 'unknown',
  `width` int(11) UNSIGNED DEFAULT NULL,
  `height` int(11) UNSIGNED DEFAULT NULL,
  `size` bigint(20) UNSIGNED DEFAULT NULL,
  `focalPoint` varchar(13) DEFAULT NULL,
  `deletedWithVolume` tinyint(1) DEFAULT NULL,
  `keptFile` tinyint(1) DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `assettransformindex`
--

CREATE TABLE `assettransformindex` (
  `id` int(11) NOT NULL,
  `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,
  `error` 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `assettransforms`
--

CREATE TABLE `assettransforms` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `mode` enum('stretch','fit','crop') NOT NULL DEFAULT 'crop',
  `position` enum('top-left','top-center','top-right','center-left','center-center','center-right','bottom-left','bottom-center','bottom-right') NOT NULL DEFAULT 'center-center',
  `width` int(11) UNSIGNED DEFAULT NULL,
  `height` int(11) UNSIGNED DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `quality` int(11) DEFAULT NULL,
  `interlace` enum('none','line','plane','partition') NOT NULL DEFAULT 'none',
  `dimensionChangeTime` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `categorygroups`
--

CREATE TABLE `categorygroups` (
  `id` int(11) NOT NULL,
  `structureId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `defaultPlacement` enum('beginning','end') NOT NULL DEFAULT 'end',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `categorygroups_sites`
--

CREATE TABLE `categorygroups_sites` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 1,
  `uriFormat` text DEFAULT NULL,
  `template` varchar(500) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `changedattributes`
--

CREATE TABLE `changedattributes` (
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `attribute` varchar(255) NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `changedattributes`
--

INSERT INTO `changedattributes` (`elementId`, `siteId`, `attribute`, `dateUpdated`, `propagated`, `userId`) VALUES
(1, 1, 'firstName', '2022-08-30 11:24:18', 0, 1),
(1, 1, 'lastName', '2022-08-30 11:24:18', 0, 1),
(2, 1, 'slug', '2022-08-31 10:43:03', 0, 1),
(2, 1, 'title', '2022-08-31 10:43:03', 0, 1),
(2, 1, 'uri', '2022-08-31 10:43:03', 0, 1);

-- --------------------------------------------------------

--
-- Table structure for table `changedfields`
--

CREATE TABLE `changedfields` (
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`id`, `elementId`, `siteId`, `title`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 1, NULL, '2022-08-30 11:11:48', '2022-08-30 11:24:18', '90505cb2-f5ed-4f5d-ab88-4b5a2d154fdd'),
(2, 2, 1, 'test', '2022-08-31 10:42:57', '2022-08-31 10:43:05', 'f3a37754-4c45-4cf6-a832-3a24bb1c99a3'),
(3, 3, 1, 'test', '2022-08-31 10:43:06', '2022-08-31 10:43:06', '16d6fb55-9d23-4057-949d-fe98459463a3');

-- --------------------------------------------------------

--
-- Table structure for table `drafts`
--

CREATE TABLE `drafts` (
  `id` int(11) NOT NULL,
  `sourceId` int(11) DEFAULT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `provisional` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `notes` text DEFAULT NULL,
  `trackChanges` tinyint(1) NOT NULL DEFAULT 0,
  `dateLastMerged` datetime DEFAULT NULL,
  `saved` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `elementindexsettings`
--

CREATE TABLE `elementindexsettings` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `settings` text DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `elements`
--

CREATE TABLE `elements` (
  `id` int(11) NOT NULL,
  `canonicalId` int(11) DEFAULT NULL,
  `draftId` int(11) DEFAULT NULL,
  `revisionId` int(11) DEFAULT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `archived` tinyint(1) NOT NULL DEFAULT 0,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateLastMerged` datetime DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `elements`
--

INSERT INTO `elements` (`id`, `canonicalId`, `draftId`, `revisionId`, `fieldLayoutId`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `dateLastMerged`, `dateDeleted`, `uid`) VALUES
(1, NULL, NULL, NULL, NULL, 'craft\\elements\\User', 1, 0, '2022-08-30 11:11:48', '2022-08-30 11:24:18', NULL, NULL, '88b8fb76-c282-4ddd-b889-2a86f7500de6'),
(2, NULL, NULL, NULL, 1, 'craft\\elements\\Entry', 1, 0, '2022-08-31 10:42:57', '2022-08-31 10:43:05', NULL, '2022-09-05 11:19:54', '2e2d9a85-80cf-4d65-9d12-c6984d1401bb'),
(3, 2, NULL, 1, 1, 'craft\\elements\\Entry', 1, 0, '2022-08-31 10:43:05', '2022-08-31 10:43:06', NULL, '2022-09-05 11:19:54', '03756982-f78d-432f-97f1-b1772c2b9c08');

-- --------------------------------------------------------

--
-- Table structure for table `elements_sites`
--

CREATE TABLE `elements_sites` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `elements_sites`
--

INSERT INTO `elements_sites` (`id`, `elementId`, `siteId`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 1, NULL, NULL, 1, '2022-08-30 11:11:48', '2022-08-30 11:11:48', '61e906e7-8fac-448b-b8ab-c6109d8f42bb'),
(2, 2, 1, 'test', 'home/test', 1, '2022-08-31 10:42:57', '2022-08-31 10:43:03', '2ab1e552-6afa-489a-9293-513bee69596b'),
(3, 3, 1, 'test', 'home/test', 1, '2022-08-31 10:43:06', '2022-08-31 10:43:06', 'dfccde3a-4c93-4987-9dce-a5d2a7928c4e');

-- --------------------------------------------------------

--
-- Table structure for table `entries`
--

CREATE TABLE `entries` (
  `id` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `typeId` int(11) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `postDate` datetime DEFAULT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `deletedWithEntryType` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entries`
--

INSERT INTO `entries` (`id`, `sectionId`, `parentId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `deletedWithEntryType`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(2, 1, NULL, 1, 1, '2022-08-31 10:42:00', NULL, 1, '2022-08-31 10:42:57', '2022-08-31 10:42:57', 'e91bd133-13d0-4c21-8968-af5ac690e4b4'),
(3, 1, NULL, 1, 1, '2022-08-31 10:42:00', NULL, NULL, '2022-08-31 10:43:06', '2022-08-31 10:43:06', 'fba8b860-5bdf-4c40-8131-96f47e7a19a0');

-- --------------------------------------------------------

--
-- Table structure for table `entrytypes`
--

CREATE TABLE `entrytypes` (
  `id` int(11) NOT NULL,
  `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,
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text DEFAULT NULL,
  `titleFormat` varchar(255) DEFAULT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entrytypes`
--

INSERT INTO `entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleTranslationMethod`, `titleTranslationKeyFormat`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 1, 1, 'Default', 'default', 1, 'site', NULL, NULL, 1, '2022-08-30 12:02:17', '2022-08-30 12:02:17', '2022-09-05 11:19:54', 'c8520463-a06b-432e-8100-d393dc082e81');

-- --------------------------------------------------------

--
-- Table structure for table `fieldgroups`
--

CREATE TABLE `fieldgroups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fieldgroups`
--

INSERT INTO `fieldgroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 'Common', '2022-08-30 11:11:48', '2022-08-30 11:11:48', NULL, '93dc3b1f-6b3b-4e58-b3f3-7ea55ca1845f');

-- --------------------------------------------------------

--
-- Table structure for table `fieldlayoutfields`
--

CREATE TABLE `fieldlayoutfields` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `fieldlayouts`
--

CREATE TABLE `fieldlayouts` (
  `id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fieldlayouts`
--

INSERT INTO `fieldlayouts` (`id`, `type`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 'craft\\elements\\Entry', '2022-08-30 12:02:17', '2022-08-30 12:02:17', '2022-09-05 11:19:54', '39d5b7ca-ee07-49f2-81e3-58d836a8aca4');

-- --------------------------------------------------------

--
-- Table structure for table `fieldlayouttabs`
--

CREATE TABLE `fieldlayouttabs` (
  `id` int(11) NOT NULL,
  `layoutId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `elements` text DEFAULT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fieldlayouttabs`
--

INSERT INTO `fieldlayouttabs` (`id`, `layoutId`, `name`, `elements`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 'Content', '[{\"type\":\"craft\\\\fieldlayoutelements\\\\EntryTitleField\",\"autocomplete\":false,\"class\":null,\"size\":null,\"name\":null,\"autocorrect\":true,\"autocapitalize\":true,\"disabled\":false,\"readonly\":false,\"title\":null,\"placeholder\":null,\"step\":null,\"min\":null,\"max\":null,\"requirable\":false,\"id\":null,\"containerAttributes\":[],\"inputContainerAttributes\":[],\"labelAttributes\":[],\"orientation\":null,\"label\":null,\"instructions\":null,\"tip\":null,\"warning\":null,\"width\":100}]', 1, '2022-08-30 12:02:17', '2022-08-30 12:02:17', '2eba1740-5413-4337-a8c7-b2e1ae6a762e');

-- --------------------------------------------------------

--
-- Table structure for table `fields`
--

CREATE TABLE `fields` (
  `id` int(11) NOT NULL,
  `groupId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `context` varchar(255) NOT NULL DEFAULT 'global',
  `columnSuffix` char(8) DEFAULT NULL,
  `instructions` text DEFAULT NULL,
  `searchable` tinyint(1) NOT NULL DEFAULT 1,
  `translationMethod` varchar(255) NOT NULL DEFAULT 'none',
  `translationKeyFormat` text DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `settings` text DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `globalsets`
--

CREATE TABLE `globalsets` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `gqlschemas`
--

CREATE TABLE `gqlschemas` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `scope` text DEFAULT NULL,
  `isPublic` tinyint(1) NOT NULL DEFAULT 0,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `info`
--

CREATE TABLE `info` (
  `id` int(11) NOT NULL,
  `version` varchar(50) NOT NULL,
  `schemaVersion` varchar(15) NOT NULL,
  `maintenance` tinyint(1) NOT NULL DEFAULT 0,
  `configVersion` char(12) NOT NULL DEFAULT '000000000000',
  `fieldVersion` char(12) NOT NULL DEFAULT '000000000000',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `info`
--

INSERT INTO `info` (`id`, `version`, `schemaVersion`, `maintenance`, `configVersion`, `fieldVersion`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, '3.7.53.1', '3.7.33', 0, 'hkjixkmddzif', '3@mjkxqaolyq', '2022-08-30 11:11:48', '2022-09-05 11:19:54', 'a9f14337-a88e-4277-a237-761e4d9f6cab');

-- --------------------------------------------------------

--
-- Table structure for table `matrixblocks`
--

CREATE TABLE `matrixblocks` (
  `id` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `typeId` int(11) NOT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `matrixblocktypes`
--

CREATE TABLE `matrixblocktypes` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(11) NOT NULL,
  `track` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applyTime` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `track`, `name`, `applyTime`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 'craft', 'Install', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '62572d46-4576-44d5-8df7-a4b16bcd43e8'),
(2, 'craft', 'm150403_183908_migrations_table_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5466f201-96f8-4ac6-a90b-5bb18caae2bf'),
(3, 'craft', 'm150403_184247_plugins_table_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '4168aa17-149d-4e45-9c5c-a940493cf47c'),
(4, 'craft', 'm150403_184533_field_version', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '465688ce-35f0-44ea-b697-db7433b705b9'),
(5, 'craft', 'm150403_184729_type_columns', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5d5a6dad-eb59-4b34-9b0d-d5e57f5eb808'),
(6, 'craft', 'm150403_185142_volumes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9341b1be-ab08-4eec-8368-a89d8a15c072'),
(7, 'craft', 'm150428_231346_userpreferences', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '46b383c9-0503-4247-8ea0-244a2783436b'),
(8, 'craft', 'm150519_150900_fieldversion_conversion', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e5edd536-444b-4356-9001-743c03f7b26a'),
(9, 'craft', 'm150617_213829_update_email_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e6f9448a-8180-4926-9948-ad3cf779e6ec'),
(10, 'craft', 'm150721_124739_templatecachequeries', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'eee93d71-72d1-411a-86f5-2b9a36f7a6c7'),
(11, 'craft', 'm150724_140822_adjust_quality_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'fbeaac1e-6c70-44e1-9141-ac5ed8f5747b'),
(12, 'craft', 'm150815_133521_last_login_attempt_ip', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3afa94ac-0a2a-40db-aa33-b417089418bd'),
(13, 'craft', 'm151002_095935_volume_cache_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '530d5173-2086-4f90-a927-dcc3329e1a08'),
(14, 'craft', 'm151005_142750_volume_s3_storage_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '05ea9a99-a5c2-4ef1-b83e-3aab283592bf'),
(15, 'craft', 'm151016_133600_delete_asset_thumbnails', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '168aab8b-0ffe-48a6-9a98-ac3d3c206744'),
(16, 'craft', 'm151209_000000_move_logo', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '18706b19-ae11-407f-8be8-a0552c9e2314'),
(17, 'craft', 'm151211_000000_rename_fileId_to_assetId', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '972a8828-427e-434f-b532-0027f056f5f9'),
(18, 'craft', 'm151215_000000_rename_asset_permissions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'a5558b9a-67d6-467c-8a89-b500b2f2d002'),
(19, 'craft', 'm160707_000001_rename_richtext_assetsource_setting', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd6798e95-0971-4016-9bab-118e378923af'),
(20, 'craft', 'm160708_185142_volume_hasUrls_setting', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '01595f4a-a7ee-464f-8210-5b75fe700f7a'),
(21, 'craft', 'm160714_000000_increase_max_asset_filesize', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0c50adc6-b81d-4071-b3ba-222063c8e6a0'),
(22, 'craft', 'm160727_194637_column_cleanup', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2785cc71-8baf-4dd9-a55d-e266e85e3ee0'),
(23, 'craft', 'm160804_110002_userphotos_to_assets', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '81b48326-a26b-4367-a38a-3eb6fa1ff42f'),
(24, 'craft', 'm160807_144858_sites', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'c7b46e67-3315-4cb1-b76e-d38d876288e4'),
(25, 'craft', 'm160829_000000_pending_user_content_cleanup', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '7d1787bf-1fdb-464f-8826-0a06aa9e6a24'),
(26, 'craft', 'm160830_000000_asset_index_uri_increase', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2cb742dc-9512-4bad-9dd5-1dcbf0a5d886'),
(27, 'craft', 'm160912_230520_require_entry_type_id', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f975721b-4ebf-4b4c-8f99-d49c388d2c0b'),
(28, 'craft', 'm160913_134730_require_matrix_block_type_id', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '84a2355d-d0b2-40c6-9b80-0129f87990ee'),
(29, 'craft', 'm160920_174553_matrixblocks_owner_site_id_nullable', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '4d366bf1-460c-4d8e-8863-98bdafa749fb'),
(30, 'craft', 'm160920_231045_usergroup_handle_title_unique', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ba5f3f68-7f10-486d-a178-7ed4d81f497a'),
(31, 'craft', 'm160925_113941_route_uri_parts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '904289ee-bf01-43e7-a128-5522325ff8e1'),
(32, 'craft', 'm161006_205918_schemaVersion_not_null', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '64cbbbd9-ce70-4e43-b796-aa76cddc305d'),
(33, 'craft', 'm161007_130653_update_email_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '02f9b447-cc34-4141-b87f-af61835331c2'),
(34, 'craft', 'm161013_175052_newParentId', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '12cd92a7-925f-4f25-a74c-fb89208001fb'),
(35, 'craft', 'm161021_102916_fix_recent_entries_widgets', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd33cfec6-6378-4df5-9fc8-2aa6f8364070'),
(36, 'craft', 'm161021_182140_rename_get_help_widget', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd5212312-4ae7-4ca2-a579-296526a3ed5c'),
(37, 'craft', 'm161025_000000_fix_char_columns', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '748ba2af-8201-4afd-a1e1-f127b0dcf5be'),
(38, 'craft', 'm161029_124145_email_message_languages', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '613c671c-3f78-4dd0-b42c-9a8d3368dea9'),
(39, 'craft', 'm161108_000000_new_version_format', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '95635cac-3c21-47b2-87e5-6111af6f57a7'),
(40, 'craft', 'm161109_000000_index_shuffle', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '654a1997-3aef-4328-806b-2d1fffa9d2a1'),
(41, 'craft', 'm161122_185500_no_craft_app', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '32459ff7-56c7-41ea-81a1-3a83365dc068'),
(42, 'craft', 'm161125_150752_clear_urlmanager_cache', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'fa77bfd9-e408-46b6-9e17-617967db442e'),
(43, 'craft', 'm161220_000000_volumes_hasurl_notnull', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '7b6b539a-53d4-409c-9cd4-4e039a63c2ca'),
(44, 'craft', 'm170114_161144_udates_permission', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5b1146e1-fadc-48f0-a66b-f5d5aaf18a6c'),
(45, 'craft', 'm170120_000000_schema_cleanup', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f7f51174-d4c2-4e5f-9fea-7e603e707458'),
(46, 'craft', 'm170126_000000_assets_focal_point', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'c0a38057-0c1a-4455-8c49-d9fec3503c20'),
(47, 'craft', 'm170206_142126_system_name', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '115984e1-0c47-4f03-912d-7a67cc2e3054'),
(48, 'craft', 'm170217_044740_category_branch_limits', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '34310c02-7593-43c2-a987-cd3c5ef60852'),
(49, 'craft', 'm170217_120224_asset_indexing_columns', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd5470586-b4fe-41a8-bec5-33e4de3a6e44'),
(50, 'craft', 'm170223_224012_plain_text_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '01c4bba9-54f1-4cf1-8d39-7e3392eda907'),
(51, 'craft', 'm170227_120814_focal_point_percentage', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6016a238-97a5-448f-ade8-198f21d496c2'),
(52, 'craft', 'm170228_171113_system_messages', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f8ea3dcb-317e-4bea-a5ed-99911985e198'),
(53, 'craft', 'm170303_140500_asset_field_source_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3a43e90a-0052-4a66-ad81-e9a5043989b8'),
(54, 'craft', 'm170306_150500_asset_temporary_uploads', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '20bce530-764c-4bb4-9b62-09b3e038c873'),
(55, 'craft', 'm170523_190652_element_field_layout_ids', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '527a1dc1-68ed-4e57-886e-b7f9d05fb81b'),
(56, 'craft', 'm170621_195237_format_plugin_handles', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '15f96bb9-a38f-4983-932a-0f0be7932830'),
(57, 'craft', 'm170630_161027_deprecation_line_nullable', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ea00efd3-a929-4550-87f7-a66d70fa32f3'),
(58, 'craft', 'm170630_161028_deprecation_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '85ff6e22-37b8-4c41-90f9-0ba99aac5a8c'),
(59, 'craft', 'm170703_181539_plugins_table_tweaks', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '42963963-16f2-423f-9d90-15dce7401c82'),
(60, 'craft', 'm170704_134916_sites_tables', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '720bbd6b-618d-49e2-97c8-69aedc145a9c'),
(61, 'craft', 'm170706_183216_rename_sequences', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ef34ed15-2d6c-476f-877b-ef5071c8fbe4'),
(62, 'craft', 'm170707_094758_delete_compiled_traits', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ba65b59b-b39c-4648-9d9d-b329c7065e9b'),
(63, 'craft', 'm170731_190138_drop_asset_packagist', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f43919b2-25fc-40f7-9abe-17ebe5644149'),
(64, 'craft', 'm170810_201318_create_queue_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9565a485-664f-473b-95ff-2aced8b4a44b'),
(65, 'craft', 'm170903_192801_longblob_for_queue_jobs', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'c88aa608-9055-4d05-ad1b-a715c40c2998'),
(66, 'craft', 'm170914_204621_asset_cache_shuffle', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'aa3ab2fa-81f4-4260-ae35-520433768738'),
(67, 'craft', 'm171011_214115_site_groups', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '7fc96db6-69a0-4fd3-9b58-028e36bf9da4'),
(68, 'craft', 'm171012_151440_primary_site', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'dc920ef3-4a21-4694-a543-b43e3a0856ff'),
(69, 'craft', 'm171013_142500_transform_interlace', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3415797f-04aa-4962-b88d-1c78e77c8874'),
(70, 'craft', 'm171016_092553_drop_position_select', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '069b0500-df84-4c07-b7de-fc91b7ce8d4f'),
(71, 'craft', 'm171016_221244_less_strict_translation_method', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '7dad2e27-ab0e-4090-a0f6-e935f37922d7'),
(72, 'craft', 'm171107_000000_assign_group_permissions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '185ab873-ca11-4117-9ce7-f6bbda36e34c'),
(73, 'craft', 'm171117_000001_templatecache_index_tune', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'c72efe69-d8c4-409d-b015-ff74433cda85'),
(74, 'craft', 'm171126_105927_disabled_plugins', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2f19a07e-5dd1-42ec-b4ed-23c00fabb084'),
(75, 'craft', 'm171130_214407_craftidtokens_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3eea6ca5-b8a9-4f04-b052-beda4ac2035a'),
(76, 'craft', 'm171202_004225_update_email_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '844316ad-02e3-4ab8-8151-0ac69b236e8c'),
(77, 'craft', 'm171204_000001_templatecache_index_tune_deux', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6954d0f1-1f17-4fdd-a52b-36850804dcd1'),
(78, 'craft', 'm171205_130908_remove_craftidtokens_refreshtoken_column', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '008ab06b-cfbc-4709-add8-f684b6d3a961'),
(79, 'craft', 'm171218_143135_longtext_query_column', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '19853eae-cbf6-4547-b18e-f7fceb26fedc'),
(80, 'craft', 'm171231_055546_environment_variables_to_aliases', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6b6bb54f-09b7-4b7a-ac88-b26ba32208da'),
(81, 'craft', 'm180113_153740_drop_users_archived_column', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd16e6894-c42f-4cc3-94fd-e368afd4cb32'),
(82, 'craft', 'm180122_213433_propagate_entries_setting', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f0cfb983-76b5-496a-b30d-305c795bd7c5'),
(83, 'craft', 'm180124_230459_fix_propagate_entries_values', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'bf6f30cd-7921-431f-8422-6cf7d0166b13'),
(84, 'craft', 'm180128_235202_set_tag_slugs', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '4eb18107-7d91-4d32-9ca8-89721c2d1c20'),
(85, 'craft', 'm180202_185551_fix_focal_points', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '72ba8f99-10ba-4ad5-8b3e-3b0a5a5c49a6'),
(86, 'craft', 'm180217_172123_tiny_ints', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '006626ae-4283-4764-a3c5-2accc8ed3046'),
(87, 'craft', 'm180321_233505_small_ints', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8ae1c40d-1338-472d-b4ac-4f90a97a187c'),
(88, 'craft', 'm180404_182320_edition_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '96145043-a51e-4f47-ae95-4af4792d68b6'),
(89, 'craft', 'm180411_102218_fix_db_routes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'efb795c2-3528-4121-98b9-f798c32b1031'),
(90, 'craft', 'm180416_205628_resourcepaths_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'b2d6c015-4a4c-494d-a313-d2fe7729f0db'),
(91, 'craft', 'm180418_205713_widget_cleanup', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9a1cfcc6-cdff-4dd1-8972-3039652b4047'),
(92, 'craft', 'm180425_203349_searchable_fields', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '20f436b6-29d5-4fda-8fd1-92a21c81e177'),
(93, 'craft', 'm180516_153000_uids_in_field_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'aab74fd4-5033-4735-be4f-2ed8f6bb8264'),
(94, 'craft', 'm180517_173000_user_photo_volume_to_uid', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f42e7654-217c-44fd-877b-5b7d1e9d222e'),
(95, 'craft', 'm180518_173000_permissions_to_uid', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6a233813-f2bc-49a8-94d2-122d64fc1e7d'),
(96, 'craft', 'm180520_173000_matrix_context_to_uids', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0ece598f-146e-4489-bc21-c973c98a8994'),
(97, 'craft', 'm180521_172900_project_config_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9845f8ac-63ee-4b1b-b31e-2cefbb93c910'),
(98, 'craft', 'm180521_173000_initial_yml_and_snapshot', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0639cbf5-be60-48d7-9fb2-d517f58b4a5d'),
(99, 'craft', 'm180731_162030_soft_delete_sites', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'cf825cb7-cb34-4f9f-a7b7-c48798e583cc'),
(100, 'craft', 'm180810_214427_soft_delete_field_layouts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'b9c957ae-c4c7-4055-8797-a12133bd1892'),
(101, 'craft', 'm180810_214439_soft_delete_elements', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'bf4833af-bd4e-4936-8161-05111813dde4'),
(102, 'craft', 'm180824_193422_case_sensitivity_fixes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '4c641554-685f-4055-9d6a-402bc8f266aa'),
(103, 'craft', 'm180901_151639_fix_matrixcontent_tables', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '60b319e0-fdb3-42af-bff0-56983b7ebb71'),
(104, 'craft', 'm180904_112109_permission_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'bcc73347-32c8-4e2d-ba6c-db03a9f6a8a7'),
(105, 'craft', 'm180910_142030_soft_delete_sitegroups', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'f2481ec6-4f0f-419e-9182-adf58e2234e8'),
(106, 'craft', 'm181011_160000_soft_delete_asset_support', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '60bdc2ed-a54b-4c89-a3f8-121177344e30'),
(107, 'craft', 'm181016_183648_set_default_user_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e78e875e-48b6-4246-957f-070902e81796'),
(108, 'craft', 'm181017_225222_system_config_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '4b56a41e-69f5-47f4-8abc-ecdbaa2f74cf'),
(109, 'craft', 'm181018_222343_drop_userpermissions_from_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '80a01891-df19-4175-b4b2-567b9b4e09cd'),
(110, 'craft', 'm181029_130000_add_transforms_routes_to_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9e9ce300-838a-4bfe-a038-2236e0a0efed'),
(111, 'craft', 'm181112_203955_sequences_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '077f501a-3eb2-4b8b-8ce4-a35f93302fb1'),
(112, 'craft', 'm181121_001712_cleanup_field_configs', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'b982b701-e263-49cc-bdc0-8fc051489b3c'),
(113, 'craft', 'm181128_193942_fix_project_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3009097d-5aa2-4430-8750-a7eac82bb608'),
(114, 'craft', 'm181130_143040_fix_schema_version', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '487e6078-6ea6-4c3c-9f86-817f68b49c33'),
(115, 'craft', 'm181211_143040_fix_entry_type_uids', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'df63e936-3cf5-494d-a16d-004c90fd3128'),
(116, 'craft', 'm181217_153000_fix_structure_uids', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e65d610f-6180-4bad-b2a5-a391432f692e'),
(117, 'craft', 'm190104_152725_store_licensed_plugin_editions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0935347b-3ea8-44b6-bfcb-20d791abf026'),
(118, 'craft', 'm190108_110000_cleanup_project_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '463a558c-5875-4caa-9024-c4f1f5de28f1'),
(119, 'craft', 'm190108_113000_asset_field_setting_change', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '605a8139-0bd1-4323-b002-e81a2d104ada'),
(120, 'craft', 'm190109_172845_fix_colspan', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '808fd259-c8b2-4b1b-9cc5-42643de655b7'),
(121, 'craft', 'm190110_150000_prune_nonexisting_sites', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '510169af-d83e-4764-8876-3b553ade960a'),
(122, 'craft', 'm190110_214819_soft_delete_volumes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '906bde76-a0e9-4e77-b407-c75069095832'),
(123, 'craft', 'm190112_124737_fix_user_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8e568a9b-7d23-4ebc-9dd7-41f5b7cc6198'),
(124, 'craft', 'm190112_131225_fix_field_layouts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'a1201a13-1f78-411d-8179-9403a4ed8e19'),
(125, 'craft', 'm190112_201010_more_soft_deletes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '289d47d6-8720-4a1c-857b-c9face5ffb7b'),
(126, 'craft', 'm190114_143000_more_asset_field_setting_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '68804889-a034-4d8f-9751-c696d5a0ab42'),
(127, 'craft', 'm190121_120000_rich_text_config_setting', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8ef187cc-19a6-4a28-9fdf-61b1352a9efb'),
(128, 'craft', 'm190125_191628_fix_email_transport_password', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3d4a994b-ae06-4dd1-a7eb-e6161e6f770b'),
(129, 'craft', 'm190128_181422_cleanup_volume_folders', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'b926c28d-f6ad-468b-9138-447f4d89e987'),
(130, 'craft', 'm190205_140000_fix_asset_soft_delete_index', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'fda014e3-81dc-4663-97e1-ae86724750b8'),
(131, 'craft', 'm190218_143000_element_index_settings_uid', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '56ccbf12-5920-4fea-9d45-7e2690d486b2'),
(132, 'craft', 'm190312_152740_element_revisions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '1d47db45-190b-42d5-84f8-af5f0f0c1088'),
(133, 'craft', 'm190327_235137_propagation_method', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '77225c85-9056-4618-8e6e-fc1ce31a4445'),
(134, 'craft', 'm190401_223843_drop_old_indexes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '868396ad-261c-4924-98e0-5c7a76c3772d'),
(135, 'craft', 'm190416_014525_drop_unique_global_indexes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '90ef2bc7-7c86-4874-8e24-e6aaf9749a7f'),
(136, 'craft', 'm190417_085010_add_image_editor_permissions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd374841e-a177-42ff-b6c6-ef2a7af423c3'),
(137, 'craft', 'm190502_122019_store_default_user_group_uid', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ba3aa2e9-7c33-49ae-8cba-293922cf4f11'),
(138, 'craft', 'm190504_150349_preview_targets', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '3477d400-5336-49de-89dc-0e4f0539dc69'),
(139, 'craft', 'm190516_184711_job_progress_label', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '9d8b4fa5-29ec-45d9-9c84-3d353bb9704e'),
(140, 'craft', 'm190523_190303_optional_revision_creators', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd51133cd-71bd-4e55-a4a0-4877de26ddca'),
(141, 'craft', 'm190529_204501_fix_duplicate_uids', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5421e4bc-b7d7-4bee-a3f7-6f16600fdbf3'),
(142, 'craft', 'm190605_223807_unsaved_drafts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '43d01a4c-2ba2-4655-8d08-24b97b356d4c'),
(143, 'craft', 'm190607_230042_entry_revision_error_tables', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '76af7d6c-de4d-4374-9ecc-13f586f9cb7f'),
(144, 'craft', 'm190608_033429_drop_elements_uid_idx', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6fec5b27-399c-4fed-bf9b-af10e8c23419'),
(145, 'craft', 'm190617_164400_add_gqlschemas_table', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2f2cb541-7fcd-4afa-b146-624e3531e3c7'),
(146, 'craft', 'm190624_234204_matrix_propagation_method', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'a6faa216-735a-4934-ac3c-bf7a8cc0573e'),
(147, 'craft', 'm190711_153020_drop_snapshots', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '27b9f460-0c04-47c7-9aee-190dce73ac6d'),
(148, 'craft', 'm190712_195914_no_draft_revisions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5fca33ff-66e1-4975-9c35-559d695ba47e'),
(149, 'craft', 'm190723_140314_fix_preview_targets_column', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'a7ac760f-cb6a-4df8-b7f3-544e46ff36b1'),
(150, 'craft', 'm190820_003519_flush_compiled_templates', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5e45154c-f06f-43dd-a4b1-e77daf4534f8'),
(151, 'craft', 'm190823_020339_optional_draft_creators', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '03e34d8f-9bf9-45ab-bf50-1e57f1ed164c'),
(152, 'craft', 'm190913_152146_update_preview_targets', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'ec4a31ae-e64e-45e0-b79b-a0e37c2afda8'),
(153, 'craft', 'm191107_122000_add_gql_project_config_support', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0bb13818-2a52-4fde-b28f-a119fb293eb7'),
(154, 'craft', 'm191204_085100_pack_savable_component_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'c580bdcb-3f3d-4a04-8067-79c0bd2356fb'),
(155, 'craft', 'm191206_001148_change_tracking', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '0422dc36-4ea8-42b3-a3ee-67a2c12335ee'),
(156, 'craft', 'm191216_191635_asset_upload_tracking', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '85126c75-8932-4d9b-8f77-ec77c050eccd'),
(157, 'craft', 'm191222_002848_peer_asset_permissions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6418fac2-2ff5-4e7d-8fa4-b7e3aad0d4f5'),
(158, 'craft', 'm200127_172522_queue_channels', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2052c91d-ef1f-48ae-8e5e-001ed7e7fecb'),
(159, 'craft', 'm200211_175048_truncate_element_query_cache', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2d2d8131-e7c6-4f26-9cc2-6004b13a3846'),
(160, 'craft', 'm200213_172522_new_elements_index', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'b04c622b-dc01-4080-88c2-322b6dcd9c33'),
(161, 'craft', 'm200228_195211_long_deprecation_messages', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '19806af9-7e89-4d87-90f7-e167065f51e4'),
(162, 'craft', 'm200306_054652_disabled_sites', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '50001e3c-d490-4d88-b43a-13c4454004cd'),
(163, 'craft', 'm200522_191453_clear_template_caches', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '56a8ec0e-8243-42cc-9dcc-93a9ce9b608f'),
(164, 'craft', 'm200606_231117_migration_tracks', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8ffd601b-6f0b-425f-b632-5681801d30c7'),
(165, 'craft', 'm200619_215137_title_translation_method', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '28f6e9d2-43b7-4d15-a181-32c7cf63f602'),
(166, 'craft', 'm200620_005028_user_group_descriptions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd23e34f3-0c0b-4d08-89ce-d0c2a9ab6303'),
(167, 'craft', 'm200620_230205_field_layout_changes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '19f997d1-7c76-4d35-954e-0dbe2900baa8'),
(168, 'craft', 'm200625_131100_move_entrytypes_to_top_project_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '22624264-b301-461e-89f1-b081978c95e0'),
(169, 'craft', 'm200629_112700_remove_project_config_legacy_files', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '09eeff62-944a-4aa4-9588-06366c67be72'),
(170, 'craft', 'm200630_183000_drop_configmap', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'a48b9be3-0617-4c2d-a147-575365a0b853'),
(171, 'craft', 'm200715_113400_transform_index_error_flag', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '07eff231-9a7c-4fe9-8135-05cbc448f7f7'),
(172, 'craft', 'm200716_110900_replace_file_asset_permissions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2301c13f-7b2d-46b4-a9fb-cf7d29fdc39a'),
(173, 'craft', 'm200716_153800_public_token_settings_in_project_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'eaeb06c3-d3ba-4f8d-bdfc-0facd77adb3e'),
(174, 'craft', 'm200720_175543_drop_unique_constraints', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6eb97348-0f23-42f6-a51e-18a22d167ce4'),
(175, 'craft', 'm200825_051217_project_config_version', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '53728834-7ea8-48c0-8a2c-429a72ac2032'),
(176, 'craft', 'm201116_190500_asset_title_translation_method', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'd4a0bef3-d89c-4b11-a966-275578abdd6e'),
(177, 'craft', 'm201124_003555_plugin_trials', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '1e9333f3-56e7-45e0-8d98-c5c1dd223523'),
(178, 'craft', 'm210209_135503_soft_delete_field_groups', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '57c15397-301d-4163-8616-82d6b6b4a66c'),
(179, 'craft', 'm210212_223539_delete_invalid_drafts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8ce075fc-49e0-4b33-9cc0-7a53789efe36'),
(180, 'craft', 'm210214_202731_track_saved_drafts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '83334493-248c-4c51-858d-a54108f54d98'),
(181, 'craft', 'm210223_150900_add_new_element_gql_schema_components', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '8b709d40-2d15-474f-940a-e30ff02bbbe3'),
(182, 'craft', 'm210302_212318_canonical_elements', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '7dd077f3-e35d-4124-b4e4-9bbb78246a9d'),
(183, 'craft', 'm210326_132000_invalidate_projectconfig_cache', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e77b64a9-e407-4d25-894e-fc61ea879e9d'),
(184, 'craft', 'm210329_214847_field_column_suffixes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '95fd99e6-1489-403d-9899-c4cccb4527c5'),
(185, 'craft', 'm210331_220322_null_author', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'bdeb42f1-46f3-4c3e-a599-66c8d4650a0a'),
(186, 'craft', 'm210405_231315_provisional_drafts', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '668dc588-84de-49d0-9f0f-ed2d14dd840f'),
(187, 'craft', 'm210602_111300_project_config_names_in_config', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e88f94f2-6fd6-43e9-ae8a-9986309c6fbe'),
(188, 'craft', 'm210611_233510_default_placement_settings', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2287c93f-7289-4a02-81b9-298dbbc1f718'),
(189, 'craft', 'm210613_145522_sortable_global_sets', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '54dfdc60-db22-4503-91d3-e894aff63a31'),
(190, 'craft', 'm210613_184103_announcements', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '5a60079c-dde7-4d64-a4ff-0020a4ced6cc'),
(191, 'craft', 'm210829_000000_element_index_tweak', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'e84e30c3-2f07-4725-8804-5b3eefb0cbf7'),
(192, 'craft', 'm220209_095604_add_indexes', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '6055cb05-9286-442a-9d0c-a6dc08dfb82d'),
(193, 'craft', 'm220214_000000_truncate_sessions', '2022-08-30 11:11:49', '2022-08-30 11:11:49', '2022-08-30 11:11:49', 'dae63a85-2b3f-44a9-8525-0c64c4b2b917');

-- --------------------------------------------------------

--
-- Table structure for table `plugins`
--

CREATE TABLE `plugins` (
  `id` int(11) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `schemaVersion` varchar(255) NOT NULL,
  `licenseKeyStatus` enum('valid','trial','invalid','mismatched','astray','unknown') NOT NULL DEFAULT 'unknown',
  `licensedEdition` varchar(255) DEFAULT NULL,
  `installDate` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `projectconfig`
--

CREATE TABLE `projectconfig` (
  `path` varchar(255) NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `projectconfig`
--

INSERT INTO `projectconfig` (`path`, `value`) VALUES
('dateModified', '1662376793'),
('email.fromEmail', '\"billy.charto@wesvault.com\"'),
('email.fromName', '\"Adventure Campers WA\"'),
('email.transportType', '\"craft\\\\mail\\\\transportadapters\\\\Sendmail\"'),
('fieldGroups.93dc3b1f-6b3b-4e58-b3f3-7ea55ca1845f.name', '\"Common\"'),
('meta.__names__.93dc3b1f-6b3b-4e58-b3f3-7ea55ca1845f', '\"Common\"'),
('meta.__names__.beeb9679-8ddc-4abe-9e48-61a7f465626f', '\"Adventure Campers WA\"'),
('meta.__names__.cae070c6-db10-4fc6-80ca-8fe1c7ab380d', '\"Adventure Campers WA\"'),
('siteGroups.cae070c6-db10-4fc6-80ca-8fe1c7ab380d.name', '\"Adventure Campers WA\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.baseUrl', '\"@web\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.enabled', 'true'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.handle', '\"default\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.hasUrls', 'true'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.language', '\"en-US\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.name', '\"Adventure Campers WA\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.primary', 'true'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.siteGroup', '\"cae070c6-db10-4fc6-80ca-8fe1c7ab380d\"'),
('sites.beeb9679-8ddc-4abe-9e48-61a7f465626f.sortOrder', '1'),
('system.edition', '\"solo\"'),
('system.live', 'true'),
('system.name', '\"Adventure Campers WA\"'),
('system.schemaVersion', '\"3.7.33\"'),
('system.timeZone', '\"America/Los_Angeles\"'),
('users.allowPublicRegistration', 'false'),
('users.defaultGroup', 'null'),
('users.photoSubpath', 'null'),
('users.photoVolumeUid', 'null'),
('users.requireEmailVerification', 'true');

-- --------------------------------------------------------

--
-- Table structure for table `queue`
--

CREATE TABLE `queue` (
  `id` int(11) NOT NULL,
  `channel` varchar(255) NOT NULL DEFAULT 'queue',
  `job` longblob NOT NULL,
  `description` text DEFAULT NULL,
  `timePushed` int(11) NOT NULL,
  `ttr` int(11) NOT NULL,
  `delay` int(11) NOT NULL DEFAULT 0,
  `priority` int(11) UNSIGNED NOT NULL DEFAULT 1024,
  `dateReserved` datetime DEFAULT NULL,
  `timeUpdated` int(11) DEFAULT NULL,
  `progress` smallint(6) NOT NULL DEFAULT 0,
  `progressLabel` varchar(255) DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `fail` tinyint(1) DEFAULT 0,
  `dateFailed` datetime DEFAULT NULL,
  `error` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `relations`
--

CREATE TABLE `relations` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `revisions`
--

CREATE TABLE `revisions` (
  `id` int(11) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `num` int(11) NOT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `revisions`
--

INSERT INTO `revisions` (`id`, `sourceId`, `creatorId`, `num`, `notes`) VALUES
(1, 2, 1, 1, '');

-- --------------------------------------------------------

--
-- Table structure for table `searchindex`
--

CREATE TABLE `searchindex` (
  `elementId` int(11) NOT NULL,
  `attribute` varchar(25) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `keywords` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `searchindex`
--

INSERT INTO `searchindex` (`elementId`, `attribute`, `fieldId`, `siteId`, `keywords`) VALUES
(1, 'email', 0, 1, ' billy charto wesvault com '),
(1, 'fullname', 0, 1, ''),
(1, 'lastname', 0, 1, ''),
(1, 'firstname', 0, 1, ''),
(1, 'username', 0, 1, ' admin '),
(1, 'slug', 0, 1, ''),
(2, 'slug', 0, 1, ' test '),
(2, 'title', 0, 1, ' test ');

-- --------------------------------------------------------

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int(11) NOT NULL,
  `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,
  `propagationMethod` varchar(255) NOT NULL DEFAULT 'all',
  `defaultPlacement` enum('beginning','end') NOT NULL DEFAULT 'end',
  `previewTargets` text DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `structureId`, `name`, `handle`, `type`, `enableVersioning`, `propagationMethod`, `defaultPlacement`, `previewTargets`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, NULL, 'Home', 'home', 'channel', 1, 'all', 'end', NULL, '2022-08-30 12:02:17', '2022-08-30 12:02:17', '2022-09-05 11:19:54', 'b00fea9e-2435-4fe8-9179-7f73a65b8d08');

-- --------------------------------------------------------

--
-- Table structure for table `sections_sites`
--

CREATE TABLE `sections_sites` (
  `id` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 1,
  `uriFormat` text DEFAULT NULL,
  `template` varchar(500) DEFAULT NULL,
  `enabledByDefault` tinyint(1) NOT NULL DEFAULT 1,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sections_sites`
--

INSERT INTO `sections_sites` (`id`, `sectionId`, `siteId`, `hasUrls`, `uriFormat`, `template`, `enabledByDefault`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 1, 1, 'home/{slug}', 'home/_entry', 1, '2022-08-30 12:02:17', '2022-08-30 12:02:17', 'd7566470-45dc-4d02-a110-4cd6c8808823');

-- --------------------------------------------------------

--
-- Table structure for table `sequences`
--

CREATE TABLE `sequences` (
  `name` varchar(255) NOT NULL,
  `next` int(11) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `shunnedmessages`
--

CREATE TABLE `shunnedmessages` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `sitegroups`
--

CREATE TABLE `sitegroups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sitegroups`
--

INSERT INTO `sitegroups` (`id`, `name`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 'Adventure Campers WA', '2022-08-30 11:11:48', '2022-08-30 11:11:48', NULL, 'cae070c6-db10-4fc6-80ca-8fe1c7ab380d');

-- --------------------------------------------------------

--
-- Table structure for table `sites`
--

CREATE TABLE `sites` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `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,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` (`id`, `groupId`, `primary`, `enabled`, `name`, `handle`, `language`, `hasUrls`, `baseUrl`, `sortOrder`, `dateCreated`, `dateUpdated`, `dateDeleted`, `uid`) VALUES
(1, 1, 1, 1, 'Adventure Campers WA', 'default', 'en-US', 1, '@web', 1, '2022-08-30 11:11:48', '2022-08-30 11:47:46', NULL, 'beeb9679-8ddc-4abe-9e48-61a7f465626f');

-- --------------------------------------------------------

--
-- Table structure for table `structureelements`
--

CREATE TABLE `structureelements` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `structures`
--

CREATE TABLE `structures` (
  `id` int(11) NOT NULL,
  `maxLevels` smallint(6) UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `taggroups`
--

CREATE TABLE `taggroups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `templatecacheelements`
--

CREATE TABLE `templatecacheelements` (
  `id` int(11) NOT NULL,
  `cacheId` int(11) NOT NULL,
  `elementId` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `templatecachequeries`
--

CREATE TABLE `templatecachequeries` (
  `id` int(11) NOT NULL,
  `cacheId` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `query` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `templatecaches`
--

CREATE TABLE `templatecaches` (
  `id` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `cacheKey` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `expiryDate` datetime NOT NULL,
  `body` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `usergroups`
--

CREATE TABLE `usergroups` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `usergroups_users`
--

CREATE TABLE `usergroups_users` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `userpermissions`
--

CREATE TABLE `userpermissions` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `userpermissions_usergroups`
--

CREATE TABLE `userpermissions_usergroups` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `userpermissions_users`
--

CREATE TABLE `userpermissions_users` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `userpreferences`
--

CREATE TABLE `userpreferences` (
  `userId` int(11) NOT NULL,
  `preferences` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `userpreferences`
--

INSERT INTO `userpreferences` (`userId`, `preferences`) VALUES
(1, '{\"language\":\"en-US\",\"locale\":null,\"weekStartDay\":\"0\",\"alwaysShowFocusRings\":false,\"useShapes\":false,\"underlineLinks\":false,\"showFieldHandles\":false,\"enableDebugToolbarForSite\":true,\"enableDebugToolbarForCp\":true,\"showExceptionView\":false,\"profileTemplates\":false}');

-- --------------------------------------------------------

--
-- Table structure for table `volumefolders`
--

CREATE TABLE `volumefolders` (
  `id` int(11) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `volumes`
--

CREATE TABLE `volumes` (
  `id` int(11) NOT NULL,
  `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,
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `widgets`
--

CREATE TABLE `widgets` (
  `id` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `sortOrder` smallint(6) UNSIGNED DEFAULT NULL,
  `colspan` tinyint(3) DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `widgets`
--

INSERT INTO `widgets` (`id`, `userId`, `type`, `sortOrder`, `colspan`, `settings`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES
(1, 1, 'craft\\widgets\\RecentEntries', 1, NULL, '{\"siteId\":1,\"section\":\"*\",\"limit\":\"10\"}', 1, '2022-08-30 11:12:33', '2022-08-30 11:14:29', '3725d658-2dcb-40ab-a1bb-564e28b71a00'),
(2, 1, 'craft\\widgets\\CraftSupport', 2, NULL, '[]', 1, '2022-08-30 11:12:33', '2022-08-30 11:12:33', '1d23b0a1-9d23-491a-8448-cc4a7efc927e'),
(3, 1, 'craft\\widgets\\Updates', 3, NULL, '[]', 1, '2022-08-30 11:12:33', '2022-08-30 11:12:33', '856fe217-a866-4cfa-afb2-36a5604a71cf'),
(4, 1, 'craft\\widgets\\Feed', 4, NULL, '{\"url\":\"https://craftcms.com/news.rss\",\"title\":\"Craft News\",\"limit\":5}', 1, '2022-08-30 11:12:33', '2022-08-30 11:12:33', 'df5fe900-4911-4f22-90e1-8f286f881d07');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `announcements`
--
ALTER TABLE `announcements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_clrrenggyfnazejnvieuovsffbjegxxmkyon` (`userId`,`unread`,`dateRead`,`dateCreated`),
  ADD KEY `idx_flidtfhxnnqtsplehkqmtawmihcwqldrydnk` (`dateRead`),
  ADD KEY `fk_fdbfnleulyipxqxygzfyhkbzwpwrmgrgnygr` (`pluginId`);

--
-- Indexes for table `assets`
--
ALTER TABLE `assets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ocpzewxvpccnycjqhkxwocnvbixhtzdcyxnh` (`filename`,`folderId`),
  ADD KEY `idx_myvsxzrommdvsioevzgevisjlustrlprawhh` (`folderId`),
  ADD KEY `idx_xpzhgqzdjdbsrqgnonjtghswezuxhmtlvodk` (`volumeId`),
  ADD KEY `fk_znbogphaxuqxnppoixlwkhunbpabphbqywyy` (`uploaderId`);

--
-- Indexes for table `assettransformindex`
--
ALTER TABLE `assettransformindex`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_upczskqpjbsttqigvcaicbzpdhapxnullzhm` (`volumeId`,`assetId`,`location`),
  ADD KEY `idx_kdcbpsbikcyueencibocqaegnkzftmtkitmm` (`assetId`,`format`,`location`);

--
-- Indexes for table `assettransforms`
--
ALTER TABLE `assettransforms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tptuuaeedhnvoadqaxhorvpdtpqotbigofmw` (`name`),
  ADD KEY `idx_mvgbkwcdebxwufwxyhiarrvyejemcblvihhi` (`handle`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_dmsvzttqdmvwferpaayqeiqtotklizmwgssc` (`groupId`),
  ADD KEY `fk_dihsjzdgjxeemqnodekohjttbtlessvguyjn` (`parentId`);

--
-- Indexes for table `categorygroups`
--
ALTER TABLE `categorygroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_xiaifrmdrkyamiopjkftdukfrvnvebchdoge` (`name`),
  ADD KEY `idx_lzijzpkhpatddjkpqinzmcfkcpqirymiyzfr` (`handle`),
  ADD KEY `idx_tnpldnmcdsywpcqhwbmukzjktdmxtzqimvgv` (`structureId`),
  ADD KEY `idx_zfkfzdtwaojitmhjpnbutnzyyjlezxnrkict` (`fieldLayoutId`),
  ADD KEY `idx_gmhgxxidsgzcsmmsezpqqitrqmjadzksbodg` (`dateDeleted`);

--
-- Indexes for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_riyfrlzvpcbbqddeyrzlkvplrtiipbbyjubn` (`groupId`,`siteId`),
  ADD KEY `idx_mwqylvhmouaxvsnmvkaiywmbdukfmbmmfiki` (`siteId`);

--
-- Indexes for table `changedattributes`
--
ALTER TABLE `changedattributes`
  ADD PRIMARY KEY (`elementId`,`siteId`,`attribute`),
  ADD KEY `idx_athbmufusnhvtqlvbwofcibnvryasjfeuyzq` (`elementId`,`siteId`,`dateUpdated`),
  ADD KEY `fk_nwbyinearbthnssknxlnxolxddtrmeguatrz` (`siteId`),
  ADD KEY `fk_mecgpgolgatxbrfntbcnnqbfnhubazlkdduu` (`userId`);

--
-- Indexes for table `changedfields`
--
ALTER TABLE `changedfields`
  ADD PRIMARY KEY (`elementId`,`siteId`,`fieldId`),
  ADD KEY `idx_kzotyxvjhcqgyuupnlhkyuwtfrzxzbyoqobk` (`elementId`,`siteId`,`dateUpdated`),
  ADD KEY `fk_hzoqbzmfkfvrtoifanjeldmscouakrbilmxa` (`siteId`),
  ADD KEY `fk_fcsocolwvhugxwvpgmuorioojsluqnsmfoym` (`fieldId`),
  ADD KEY `fk_imkemmjacmuapigcefjkatzkfekourgplkie` (`userId`);

--
-- Indexes for table `content`
--
ALTER TABLE `content`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_kagpeinlritqhyzreaahfiouiwcickefnsas` (`elementId`,`siteId`),
  ADD KEY `idx_cgopvkwacjhgtvncwjxejbxoodxsrwsbxtzo` (`siteId`),
  ADD KEY `idx_cnzgpczmxpoegptulychwatfxjmfofiitpnf` (`title`);

--
-- Indexes for table `drafts`
--
ALTER TABLE `drafts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_xomouxqrygjzdyeeifqwmueijmkbtpeiwhbz` (`creatorId`,`provisional`),
  ADD KEY `idx_ehonzkttrksxkghtjjvfmsujrhgnwuummqjj` (`saved`),
  ADD KEY `fk_lltwikqqwpclgorllgxbxadmyzdvaorlnnlb` (`sourceId`);

--
-- Indexes for table `elementindexsettings`
--
ALTER TABLE `elementindexsettings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_reancahrdsvskmgibxzzdqbxutpudoqnrsub` (`type`);

--
-- Indexes for table `elements`
--
ALTER TABLE `elements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ljepibrnovfnixaohqwivgzxiebtzkezvqwf` (`dateDeleted`),
  ADD KEY `idx_frycaorfurwmvjmhjfjlktilciavppjdrudh` (`fieldLayoutId`),
  ADD KEY `idx_hruyargeizsqpsotyfcxxvwwmgduxkzbzxvq` (`type`),
  ADD KEY `idx_oxmnpqbnbryaheusvhskwcsceoxjahibuinh` (`enabled`),
  ADD KEY `idx_gvthrukmboldiotjtzhzavzkbihiwugnyovo` (`archived`,`dateCreated`),
  ADD KEY `idx_mlfesbwaflwclvdzchyhqydrutjsaiveyhgm` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  ADD KEY `idx_omydaejavgeekdcrcgwiabwtqyemutbpomif` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`,`enabled`),
  ADD KEY `fk_nskgbadmwfhlwqrvngzcjpscywkuzgmquili` (`canonicalId`),
  ADD KEY `fk_mdwjbtgjawkwefuteceqbtmgqvcazhbgrylh` (`draftId`),
  ADD KEY `fk_zeeyitlagodrtwqhujygxzwczjeiouvtzwyj` (`revisionId`);

--
-- Indexes for table `elements_sites`
--
ALTER TABLE `elements_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_ttusleeycfcgzcbwjpxrdcxwkcgayjqplrpn` (`elementId`,`siteId`),
  ADD KEY `idx_lgsbnzdxqforpxeumbkgqhumdfmduephqxfg` (`siteId`),
  ADD KEY `idx_sxtezgrvsfmmxqtoxtqsyvprzhaxqnpvhrrl` (`slug`,`siteId`),
  ADD KEY `idx_hfkdxyyxxpfdsdwalaegagkziwuqxffltlrk` (`enabled`),
  ADD KEY `idx_ouxjicsqvmigcpxnobvrkthszwcihqgdnkmg` (`uri`,`siteId`);

--
-- Indexes for table `entries`
--
ALTER TABLE `entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_riuvweamanwlmcmvhixwfhnufnnlppeyhgdw` (`postDate`),
  ADD KEY `idx_zndjghywtrvlsqrqxgavxwfqsgeveqiqrsni` (`expiryDate`),
  ADD KEY `idx_leichurkogzbrgtobtiuglafvovwonstprkn` (`authorId`),
  ADD KEY `idx_jvncrfpxuxktvvqmgmpcnsaiakowjzwzkdeu` (`sectionId`),
  ADD KEY `idx_qqucsetfthkyhfbyxifkfzksjdqrkuiocajo` (`typeId`),
  ADD KEY `fk_bpkmboxygdyfarnntnbxrnutottlcxfmtqfj` (`parentId`);

--
-- Indexes for table `entrytypes`
--
ALTER TABLE `entrytypes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tiztoekpskwczvmjhdxecufooylxfzmfbhvr` (`name`,`sectionId`),
  ADD KEY `idx_tmllfqoulioqsbbzauhuqrqowjscjihuitbp` (`handle`,`sectionId`),
  ADD KEY `idx_hgxgbmwcavtdwxllakwnrwgjjryrafglwwvc` (`sectionId`),
  ADD KEY `idx_exwrrlprnbxdmlymzciphlhfgihnpedphxfu` (`fieldLayoutId`),
  ADD KEY `idx_tdcgtzmyurdjsdifopwydhzwjmftwuwaniko` (`dateDeleted`);

--
-- Indexes for table `fieldgroups`
--
ALTER TABLE `fieldgroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_hgbvbnurpxswdepyyhheuochcrkqihbqdvok` (`name`),
  ADD KEY `idx_yqadjoyufphkzkiudqukdoyszpsowqglorjq` (`dateDeleted`,`name`);

--
-- Indexes for table `fieldlayoutfields`
--
ALTER TABLE `fieldlayoutfields`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_mprfzrcowofpnqazekiwpfhlquiqrrcajwuc` (`layoutId`,`fieldId`),
  ADD KEY `idx_gljekafmqmttbkmgeaqpkeaiqdndfwzmwsrf` (`sortOrder`),
  ADD KEY `idx_dkdcaczvkxcpzxojtznsmshbanufefwnmfzo` (`tabId`),
  ADD KEY `idx_hennaarqcrnmvpnzpwkjgyujakuxmdtequkl` (`fieldId`);

--
-- Indexes for table `fieldlayouts`
--
ALTER TABLE `fieldlayouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ofshxarltpjyimghdigpefelanvvfidbscio` (`dateDeleted`),
  ADD KEY `idx_tvqdstrmcxgewknhgicoamtqqtcbieaueqkp` (`type`);

--
-- Indexes for table `fieldlayouttabs`
--
ALTER TABLE `fieldlayouttabs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_hhucnalfwfahpebxvzogtmcurhwszvqjambn` (`sortOrder`),
  ADD KEY `idx_qegqwkdfnxwdsrdfvxewdogvppoxwopyquxr` (`layoutId`);

--
-- Indexes for table `fields`
--
ALTER TABLE `fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_oowxjzvzibuloiewjoasfuiocpqmdzlrlgfq` (`handle`,`context`),
  ADD KEY `idx_wqvbrhmidckkxmvrvzyjidcwyhyzddbfjxkr` (`groupId`),
  ADD KEY `idx_orlymwmfxblfuwysigzobumsplshbciclkmq` (`context`);

--
-- Indexes for table `globalsets`
--
ALTER TABLE `globalsets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_wstnjiynoyiceabredsaggrgwjxqdgnnucpl` (`name`),
  ADD KEY `idx_aalyeqawsduxkxpaujnuiixzfxutmggnombv` (`handle`),
  ADD KEY `idx_sdqubkmofibabrmqihdrkhuvcdqhvrejbxoc` (`fieldLayoutId`),
  ADD KEY `idx_vhbuxzxjvubxhscvbfftibmvpqzortdvldhc` (`sortOrder`);

--
-- Indexes for table `gqlschemas`
--
ALTER TABLE `gqlschemas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `info`
--
ALTER TABLE `info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `matrixblocks`
--
ALTER TABLE `matrixblocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tdhngphggiaqpdzpmzxydzcrmgmlknzafkcj` (`ownerId`),
  ADD KEY `idx_hpenpcvwzgorcutylpymukxuxlozuvdlunpc` (`fieldId`),
  ADD KEY `idx_rmmsldqqlebbplfjknwxyjczjgokgenmdusw` (`typeId`),
  ADD KEY `idx_qtowtvmcwfbkaajespusiibnorfpvzbfyfro` (`sortOrder`);

--
-- Indexes for table `matrixblocktypes`
--
ALTER TABLE `matrixblocktypes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_jegzmmhuhczendjwpcvulaidwftcatassgyo` (`name`,`fieldId`),
  ADD KEY `idx_uqyznkootgoonkstrnfclgbqdwznkzxniyfu` (`handle`,`fieldId`),
  ADD KEY `idx_cspugblrcfraghgrocgybvetcstmyxurorok` (`fieldId`),
  ADD KEY `idx_tvbsvlribbltheyfpjegkoprldyfkqyfxvlw` (`fieldLayoutId`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_bcyiossskuqthcdgqvmcohfvymxkvqzivxhr` (`track`,`name`);

--
-- Indexes for table `plugins`
--
ALTER TABLE `plugins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_pgnnqnjgelncdfzmkaaxarabbsdjtiohyggm` (`handle`);

--
-- Indexes for table `projectconfig`
--
ALTER TABLE `projectconfig`
  ADD PRIMARY KEY (`path`);

--
-- Indexes for table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tdgaxncgxbbdoirbyokgmftaxbulbfrvdvvj` (`channel`,`fail`,`timeUpdated`,`timePushed`),
  ADD KEY `idx_zwpovcnlygovzlaqfrbdchdzspnuqnjlhazv` (`channel`,`fail`,`timeUpdated`,`delay`);

--
-- Indexes for table `relations`
--
ALTER TABLE `relations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_xroxgcffcfdxhigpvxwsuhyravyzdaonrirs` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  ADD KEY `idx_xtyydimsaovvxdwusitgqrfueubgaoxjjzzd` (`sourceId`),
  ADD KEY `idx_xfbwgqomfkbztdbkketgcivdxlwbymjkuodu` (`targetId`),
  ADD KEY `idx_xoexonxjkweiwgsxydpfxsvfgqpwicydlslj` (`sourceSiteId`);

--
-- Indexes for table `revisions`
--
ALTER TABLE `revisions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_tjeexjopsbtkfqmcezqjiexzamhouizlhzdr` (`sourceId`,`num`),
  ADD KEY `fk_otxyainnuaerjigfsomhbbgbrkaegjxmmquj` (`creatorId`);

--
-- Indexes for table `searchindex`
--
ALTER TABLE `searchindex`
  ADD PRIMARY KEY (`elementId`,`attribute`,`fieldId`,`siteId`);
ALTER TABLE `searchindex` ADD FULLTEXT KEY `idx_nqequcknzszewgzdzzvqihumjblaezhxggnt` (`keywords`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_kuwedsgzntjunxxiisgjlnadiqgtkvcyjxbd` (`handle`),
  ADD KEY `idx_ebluzhirxovadupjdzyixxpgvzsrrdixfhbo` (`name`),
  ADD KEY `idx_qrcnvjvyvibkekjpqvepkmrkbdwjomozwszz` (`structureId`),
  ADD KEY `idx_brzugleysagvkjfvnnlfrcglhznzedkbjoup` (`dateDeleted`);

--
-- Indexes for table `sections_sites`
--
ALTER TABLE `sections_sites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_qsylrzophcfefltzxjekbxaajxhceqooyzos` (`sectionId`,`siteId`),
  ADD KEY `idx_imolpammvnihazzplrbelcpqfpwgrnaxpvtg` (`siteId`);

--
-- Indexes for table `sequences`
--
ALTER TABLE `sequences`
  ADD PRIMARY KEY (`name`);

--
-- Indexes for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_vilkpvwbffzvgnvsmrrucrdkemxfhamsneux` (`userId`,`message`);

--
-- Indexes for table `sitegroups`
--
ALTER TABLE `sitegroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_avuyqyqjjbtfqshcmedjxaccswjjpfqtixze` (`name`);

--
-- Indexes for table `sites`
--
ALTER TABLE `sites`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rpzhqpxqjloysxcyxflrunbboumziclqizcb` (`dateDeleted`),
  ADD KEY `idx_chwhkcaefskubvzvxwisrsrsvklouegollsu` (`handle`),
  ADD KEY `idx_vldvawaifxmatpixiwvlvhjejrcrcnttlyvf` (`sortOrder`),
  ADD KEY `fk_zubqvdxujwvpiurimrxgggzqpocqxesplhuh` (`groupId`);

--
-- Indexes for table `structureelements`
--
ALTER TABLE `structureelements`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_buxrasqyevdjgtqnyqzoohrlgyffbcdvehlu` (`structureId`,`elementId`),
  ADD KEY `idx_xqpweplmqeyjmrjrvhsognrwnxqrtkxuaclf` (`root`),
  ADD KEY `idx_mmsihsosffoufouhnamnfqkfhjnfhiosehha` (`lft`),
  ADD KEY `idx_maeesuzwmlrfbhblyowjwjsykqsxrdnmxtcl` (`rgt`),
  ADD KEY `idx_caiotjcnbzytzdcguldnwzwpacqslwmxetfm` (`level`),
  ADD KEY `idx_ifjrbdtomnopzeyqlsvmoefnccmcvenymkxu` (`elementId`);

--
-- Indexes for table `structures`
--
ALTER TABLE `structures`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tgdmifdsvrvijwoqlnftpdlqfgoazcrijkxg` (`dateDeleted`);

--
-- Indexes for table `taggroups`
--
ALTER TABLE `taggroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_yauqmltcavlycrcqbnpvkiedyarxlcxrapqw` (`name`),
  ADD KEY `idx_lmbeprgvgccxigaciictaygppskqsmddnarx` (`handle`),
  ADD KEY `idx_stkcuizfcabunxzzukbizpfqwbqfypofqpkf` (`dateDeleted`),
  ADD KEY `fk_hkvmiwlkjipdsppyoexlimkygtyxsqsulegf` (`fieldLayoutId`);

--
-- Indexes for table `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rpsdppkebonkorddmqmmwbduscvgyyxwblds` (`groupId`);

--
-- Indexes for table `templatecacheelements`
--
ALTER TABLE `templatecacheelements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_nslwpwskhlaxsiaccymtxdsbdazljbibkajx` (`cacheId`),
  ADD KEY `idx_bmirdqsytazfjmnechcvnpkncrlvsdrzuqif` (`elementId`);

--
-- Indexes for table `templatecachequeries`
--
ALTER TABLE `templatecachequeries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qmczutpwsdvoxccaftbszdujeupgniufoebb` (`cacheId`),
  ADD KEY `idx_swoqhzptllusdslukcbohttyugpsbbgkjhsl` (`type`);

--
-- Indexes for table `templatecaches`
--
ALTER TABLE `templatecaches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ybkquxibkgvokpbtiddfoqizusrwxatzlljd` (`cacheKey`,`siteId`,`expiryDate`,`path`),
  ADD KEY `idx_srqrrdnuyidbarqhdfhrrccpznctjkknziwi` (`cacheKey`,`siteId`,`expiryDate`),
  ADD KEY `idx_apcuqrhwtzmmgknvqhrhutfypmjbbezuccgl` (`siteId`);

--
-- Indexes for table `usergroups`
--
ALTER TABLE `usergroups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qpbyowcztvgnoiiugfilxpsbyhwkeqzpdzgj` (`handle`),
  ADD KEY `idx_pviavdlojysrwcguygwdjtxaogbspeoojgfj` (`name`);

--
-- Indexes for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_hvpdfvbdcclqjghpiowbsbrpapafytfzhbta` (`groupId`,`userId`),
  ADD KEY `idx_ovhofsygjitntkgbvsapbggrgsgqxpdqghaf` (`userId`);

--
-- Indexes for table `userpermissions`
--
ALTER TABLE `userpermissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_yzwhdkcnsqumnjoocjuciwtnzqrtyzhjbluq` (`name`);

--
-- Indexes for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_japowpnhmjqkihzocpnfnhyaxonlxxpqqjfl` (`permissionId`,`groupId`),
  ADD KEY `idx_xqauextiqbdhqftrguglglcuwuebfannaqdk` (`groupId`);

--
-- Indexes for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_mpurtcgivloonyeewbpounhjaxlxlexxrqmq` (`permissionId`,`userId`),
  ADD KEY `idx_tmaqellwduisxxmqmtxcymlxfbomxkqxmocz` (`userId`);

--
-- Indexes for table `userpreferences`
--
ALTER TABLE `userpreferences`
  ADD PRIMARY KEY (`userId`);

--
-- Indexes for table `volumefolders`
--
ALTER TABLE `volumefolders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_jlvbjzklixuypbabbsfdwgmhzlkhdubgijjv` (`name`,`parentId`,`volumeId`),
  ADD KEY `idx_eqkthkbqtrolyqmfkfuelgnjsrgsoxfwello` (`parentId`),
  ADD KEY `idx_tixjwaklitvhecgxzmaqfprfukrhqgtnjpit` (`volumeId`);

--
-- Indexes for table `volumes`
--
ALTER TABLE `volumes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ymryptlzvriztwdjqewouoeieieooswaoemj` (`name`),
  ADD KEY `idx_fxiildfphrikfbgvomwzqgblergdepsoinvh` (`handle`),
  ADD KEY `idx_qnioooabitnrgmnbtardwpivurvvtnfwisjb` (`fieldLayoutId`),
  ADD KEY `idx_lsovpeechibnxshjxrgtlnbwwlkrevbyeitn` (`dateDeleted`);

--
-- Indexes for table `widgets`
--
ALTER TABLE `widgets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_qaqgyignfflhzmrqbcohnmbtpshdpjklfkvz` (`userId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `announcements`
--
ALTER TABLE `announcements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assettransformindex`
--
ALTER TABLE `assettransformindex`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `assettransforms`
--
ALTER TABLE `assettransforms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categorygroups`
--
ALTER TABLE `categorygroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `content`
--
ALTER TABLE `content`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `drafts`
--
ALTER TABLE `drafts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `elementindexsettings`
--
ALTER TABLE `elementindexsettings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `elements`
--
ALTER TABLE `elements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `elements_sites`
--
ALTER TABLE `elements_sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `entrytypes`
--
ALTER TABLE `entrytypes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fieldgroups`
--
ALTER TABLE `fieldgroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fieldlayoutfields`
--
ALTER TABLE `fieldlayoutfields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fieldlayouts`
--
ALTER TABLE `fieldlayouts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fieldlayouttabs`
--
ALTER TABLE `fieldlayouttabs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `fields`
--
ALTER TABLE `fields`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `globalsets`
--
ALTER TABLE `globalsets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `gqlschemas`
--
ALTER TABLE `gqlschemas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `info`
--
ALTER TABLE `info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `matrixblocktypes`
--
ALTER TABLE `matrixblocktypes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;

--
-- AUTO_INCREMENT for table `plugins`
--
ALTER TABLE `plugins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `queue`
--
ALTER TABLE `queue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `relations`
--
ALTER TABLE `relations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `revisions`
--
ALTER TABLE `revisions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sections_sites`
--
ALTER TABLE `sections_sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sitegroups`
--
ALTER TABLE `sitegroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sites`
--
ALTER TABLE `sites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `structureelements`
--
ALTER TABLE `structureelements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `structures`
--
ALTER TABLE `structures`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `taggroups`
--
ALTER TABLE `taggroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templatecacheelements`
--
ALTER TABLE `templatecacheelements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templatecachequeries`
--
ALTER TABLE `templatecachequeries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templatecaches`
--
ALTER TABLE `templatecaches`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usergroups`
--
ALTER TABLE `usergroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions`
--
ALTER TABLE `userpermissions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `userpreferences`
--
ALTER TABLE `userpreferences`
  MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `volumefolders`
--
ALTER TABLE `volumefolders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `volumes`
--
ALTER TABLE `volumes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `widgets`
--
ALTER TABLE `widgets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `announcements`
--
ALTER TABLE `announcements`
  ADD CONSTRAINT `fk_fdbfnleulyipxqxygzfyhkbzwpwrmgrgnygr` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_tzwmfvulrdtnqsrdntzvjqsvuulspbhwbnrw` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `assets`
--
ALTER TABLE `assets`
  ADD CONSTRAINT `fk_libjaeszwlsmnfpxtlqkniorgymhcsqljvnm` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_trgutippdmacoxseikevlgqbqgkogppfsvwg` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_wkwhotfbkiffeekyitlrxkzauzkpbukkibew` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_znbogphaxuqxnppoixlwkhunbpabphbqywyy` FOREIGN KEY (`uploaderId`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `fk_dihsjzdgjxeemqnodekohjttbtlessvguyjn` FOREIGN KEY (`parentId`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_kkhhusmgwkjdwxzhjsyzdinaqgadbavfoqeg` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_nqpxkuzgekhouqvxlrltbbtjwcackmdlqpwp` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categorygroups`
--
ALTER TABLE `categorygroups`
  ADD CONSTRAINT `fk_oueeewgbrhwjoaaxpvlcxfrrygbcoqppejhx` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_scpfarfywpeeclthspylfeolkgatkweehkcp` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `categorygroups_sites`
--
ALTER TABLE `categorygroups_sites`
  ADD CONSTRAINT `fk_fokmjwekahlwgigqmkdrygceyuhmeiovxacp` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_rgjrfjvrmahtvwizibmuphvbchqzvsbmyegz` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `changedattributes`
--
ALTER TABLE `changedattributes`
  ADD CONSTRAINT `fk_hjlkbfulzzjqegotddgevelplujaczckplvo` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_mecgpgolgatxbrfntbcnnqbfnhubazlkdduu` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_nwbyinearbthnssknxlnxolxddtrmeguatrz` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `changedfields`
--
ALTER TABLE `changedfields`
  ADD CONSTRAINT `fk_fcsocolwvhugxwvpgmuorioojsluqnsmfoym` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_hzoqbzmfkfvrtoifanjeldmscouakrbilmxa` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_imkemmjacmuapigcefjkatzkfekourgplkie` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_qsrxvbkmrtamgabredsipwtndpvogthvxhgq` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `content`
--
ALTER TABLE `content`
  ADD CONSTRAINT `fk_opuanacgjdfkewqmpxoqyajrzbhusmrqjmgn` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_pkhlmgzhswjxtvwjmnjmzvgmmlkbtuxfenro` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `drafts`
--
ALTER TABLE `drafts`
  ADD CONSTRAINT `fk_hhbrlbhwgqwxwfiwxdspehnadzsswtekiers` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_lltwikqqwpclgorllgxbxadmyzdvaorlnnlb` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `elements`
--
ALTER TABLE `elements`
  ADD CONSTRAINT `fk_kfuaxeytroxlgsotgmkdvjbhnttfihqimseo` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_mdwjbtgjawkwefuteceqbtmgqvcazhbgrylh` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_nskgbadmwfhlwqrvngzcjpscywkuzgmquili` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_zeeyitlagodrtwqhujygxzwczjeiouvtzwyj` FOREIGN KEY (`revisionId`) REFERENCES `revisions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `elements_sites`
--
ALTER TABLE `elements_sites`
  ADD CONSTRAINT `fk_jtrafwvosbulvlhrlkhoqdhhqjgbxvspzwpb` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_ldrdhqmcbzusewvokkeynnjrawshezyvlvdj` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `entries`
--
ALTER TABLE `entries`
  ADD CONSTRAINT `fk_bpkmboxygdyfarnntnbxrnutottlcxfmtqfj` FOREIGN KEY (`parentId`) REFERENCES `entries` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_hrwhhnyidevhwnemfrxmdgkwatkbfwygtzmi` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_iqjmqnthmesfgdjfvmivkgsuglixysmhftmk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_jdragncgvyzwaeaicockkgxctninkwurinia` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_oegpsemfjqjoidsxgauufjgqcpdzqqvasuxp` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `entrytypes`
--
ALTER TABLE `entrytypes`
  ADD CONSTRAINT `fk_exzwqyvukspxeqiasqqnrwlafueiakwrrqqz` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_hlgrjtkgscxuzmtnpuydfcjfewutdsyscqck` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `fieldlayoutfields`
--
ALTER TABLE `fieldlayoutfields`
  ADD CONSTRAINT `fk_kzxtqpayixoqgstfxagdyjdokpdylmcjgrbq` FOREIGN KEY (`tabId`) REFERENCES `fieldlayouttabs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_mogsjsjcsffyleiyemoswwiqyjahycasmytc` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_vqtkpxlbvxlmxbwrstuzlmdywmjperadmwsx` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `fieldlayouttabs`
--
ALTER TABLE `fieldlayouttabs`
  ADD CONSTRAINT `fk_uqbqabalkowhszfhtgzvincusvgaubndsnex` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `fields`
--
ALTER TABLE `fields`
  ADD CONSTRAINT `fk_jyqhhreuibyzhdcksbhwlziwokawvkcsmsya` FOREIGN KEY (`groupId`) REFERENCES `fieldgroups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `globalsets`
--
ALTER TABLE `globalsets`
  ADD CONSTRAINT `fk_puqpqfnycfelcdsgxjmaysouzjmgdorjduvu` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_uhuxejasnvlgupoecqdwstdkuhgpswmqbtxm` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `matrixblocks`
--
ALTER TABLE `matrixblocks`
  ADD CONSTRAINT `fk_jzmtbeakguxsgkldthwbmvdnagunqjcrjwzl` FOREIGN KEY (`typeId`) REFERENCES `matrixblocktypes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_mvwgbfauftxjthvbzgnrdaftyehqcjaokxka` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_shjjohqmlwablvuhkgheihalylwogmagazfw` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_xgbfvrcqaclunzfkyjehriinfmefccbetter` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `matrixblocktypes`
--
ALTER TABLE `matrixblocktypes`
  ADD CONSTRAINT `fk_egefmfffgmdeeihsgftmfhimzgvcxncianty` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_zlcypjoqinygiweihwruezciqvfrwdriiocd` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `relations`
--
ALTER TABLE `relations`
  ADD CONSTRAINT `fk_spjmwldzceguaopmwprffsnoxncqgeupuyxl` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_upbwzegvwohjudljsxnqcgogwfqbdoxmnsip` FOREIGN KEY (`targetId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_wgzclnlanxcowozczodkmbvqvtgpbzjctzbk` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_zjnrpbqshqysolwfyxqgkhdiydnjlnpmteny` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `revisions`
--
ALTER TABLE `revisions`
  ADD CONSTRAINT `fk_ansiqkhykrwaiejvyhzixzsuqteutowlrfyc` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_otxyainnuaerjigfsomhbbgbrkaegjxmmquj` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `fk_ekcyvguauuilsajdguxhkkihyyiqjvguxrfn` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `sections_sites`
--
ALTER TABLE `sections_sites`
  ADD CONSTRAINT `fk_tgpvlnrpvwaatxsxxjjmecwjrnqaecbllufl` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_xojlxkgwgfottieplvhrpbhmqkjvghdyyzlj` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `shunnedmessages`
--
ALTER TABLE `shunnedmessages`
  ADD CONSTRAINT `fk_tawehwbbwgxpxlvjhchescqylbrczsimxald` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sites`
--
ALTER TABLE `sites`
  ADD CONSTRAINT `fk_zubqvdxujwvpiurimrxgggzqpocqxesplhuh` FOREIGN KEY (`groupId`) REFERENCES `sitegroups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `structureelements`
--
ALTER TABLE `structureelements`
  ADD CONSTRAINT `fk_gpuutgixfnsamitmlqndjybbmgpfgfkpynbe` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_keuiofyirsaastkytacocljmynegahsrwcny` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `taggroups`
--
ALTER TABLE `taggroups`
  ADD CONSTRAINT `fk_hkvmiwlkjipdsppyoexlimkygtyxsqsulegf` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `tags`
--
ALTER TABLE `tags`
  ADD CONSTRAINT `fk_vtldjsyagacgplkcawipzyzqpdosuaelbcty` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_wzqdxnbuivzdjravjumdvzkqdqebwznbotfw` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `templatecacheelements`
--
ALTER TABLE `templatecacheelements`
  ADD CONSTRAINT `fk_lmtbcqgesoslpaakstnfhkqatlzggwbophyp` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_yzxlfevbibzclytvjgiujfkjxeheyvicvfww` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `templatecachequeries`
--
ALTER TABLE `templatecachequeries`
  ADD CONSTRAINT `fk_qsmvznvmyyjbfyxrsddgsfcetgzxhhpezctn` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `templatecaches`
--
ALTER TABLE `templatecaches`
  ADD CONSTRAINT `fk_rkaxoggaicpbxnbkqfhpltntrypfbpupmdcm` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `usergroups_users`
--
ALTER TABLE `usergroups_users`
  ADD CONSTRAINT `fk_fmkohtjxsmfyccjdnsesvjtezxmtweyvsrez` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ioqqzjpbtbpyxoiyvusykeexguwuqrjbqoix` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `userpermissions_usergroups`
--
ALTER TABLE `userpermissions_usergroups`
  ADD CONSTRAINT `fk_ozhzubknemmymlbowjkeyjyylvtibxsizvnl` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ynmjygkyzuslvnukoxnwxnfqblxmomasmanl` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `userpermissions_users`
--
ALTER TABLE `userpermissions_users`
  ADD CONSTRAINT `fk_awdbxnjjslwuzylvbhdbrtcplerwvqbmmhtz` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_bvhgipqtxnnruohjhsxjghjibxuexeuojjuh` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `userpreferences`
--
ALTER TABLE `userpreferences`
  ADD CONSTRAINT `fk_xjbqcpiqpcjqyfaxhehvsacddpatlukzrzxk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `volumefolders`
--
ALTER TABLE `volumefolders`
  ADD CONSTRAINT `fk_dmvgmbwsdtzoqpcaxuzmiyplrdlxacdofgvl` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_qiggrqwiltaxwpycfonrbghztqrnkvmlcrjo` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `volumes`
--
ALTER TABLE `volumes`
  ADD CONSTRAINT `fk_kvrdikyjixvvriezomqywsftcfhqhwiitygd` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `widgets`
--
ALTER TABLE `widgets`
  ADD CONSTRAINT `fk_zvzroeslumpssilfijocuaigehlwafikxmxa` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

