--
-- Host: 127.0.0.1    Database: gfh2022_CraftCMS
-- ------------------------------------------------------


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

CREATE TABLE `announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `pluginId` int(11) DEFAULT NULL,
  `heading` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `unread` tinyint(1) NOT NULL DEFAULT 1,
  `dateRead` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_mcjmvaaycujvdpznycsacrhoakyijsptebtw` (`userId`,`unread`,`dateRead`,`dateCreated`),
  KEY `idx_gwikqthdviztfztzrlrtxsackgszsslvdnwr` (`dateRead`),
  KEY `fk_oxlstonwixgoyioflzpiarhgigaszvohsszx` (`pluginId`),
  CONSTRAINT `fk_oxlstonwixgoyioflzpiarhgigaszvohsszx` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ptoullsezaiglzamcuaaguowgvqdxyguopvu` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL,
  `kind` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown',
  `width` int(11) unsigned DEFAULT NULL,
  `height` int(11) unsigned DEFAULT NULL,
  `size` bigint(20) unsigned DEFAULT NULL,
  `focalPoint` varchar(13) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_rsmumyhaogzfjgwnvawjuoiegbpfbspmskys` (`filename`,`folderId`),
  KEY `idx_nxpihswjbkbkjniuyyqlqqfnsfgbibkvaivt` (`folderId`),
  KEY `idx_ngccoknzuljtrryivkfbzwhknwtzlurdvfux` (`volumeId`),
  KEY `fk_clqhxikebzjujnupxyzbwriktvwdrhgrdvcy` (`uploaderId`),
  CONSTRAINT `fk_clqhxikebzjujnupxyzbwriktvwdrhgrdvcy` FOREIGN KEY (`uploaderId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_elvgssdgwpvfraswwmzfcvhjylintweimlyn` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ttvrmtscaxvszpepxmmojeksdvkieknwcags` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_vqzvovgycvmmcufkajranoybphqqqoyjwgyu` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `assettransformindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assetId` int(11) NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_zsdtciiofgsemlnjifhtwbylablcqhywgjzu` (`volumeId`,`assetId`,`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_fgigsauxnbcnhdrronbntselieuwzyqtbsoc` (`groupId`),
  KEY `fk_hivirlhbwcgxskufcuyslaitbshafpvyvydj` (`parentId`),
  CONSTRAINT `fk_fhmdmqqybxxtoakmirkdedkwtfyoluuaiaja` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_hivirlhbwcgxskufcuyslaitbshafpvyvydj` FOREIGN KEY (`parentId`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_xlazrwzuicxoqcmbeqmlidhlegzleafaozfl` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `categorygroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultPlacement` enum('beginning','end') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'end',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_bsiquwdwshtxjlalqmvelscavyvwjqczgkmt` (`name`),
  KEY `idx_qsvajfjohqrtjmhiekwegrlizfnaxaqodbmi` (`handle`),
  KEY `idx_rwqgnbecokxhbawlgyiyckztuurmgwulpxwd` (`structureId`),
  KEY `idx_kmenqcrhbtwllvjtsbumehwgpjkfvqsfmotj` (`fieldLayoutId`),
  KEY `idx_ewymkyptuuovpiwdonjvwchctbdrkqdffver` (`dateDeleted`),
  CONSTRAINT `fk_cdywvnowmpnsnktjhtypukqqftejavfwleji` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_mxlmlrmgggkzkiudjwjtahmlhpapskwthbhj` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `categorygroups_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 1,
  `uriFormat` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_tqtatjtaundpanxpwjtknrcoownmxfrlqxas` (`groupId`,`siteId`),
  KEY `idx_xsjodwbgqwbqwwgwdslnkiwyjxuafkzfevxd` (`siteId`),
  CONSTRAINT `fk_bsivbbfhmirhbezigaufcazznvyuhcnuucog` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_kixpawswsjgtfltqbgakvnwhbyvnndfnbglx` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `changedattributes` (
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `attribute` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int(11) DEFAULT NULL,
  PRIMARY KEY (`elementId`,`siteId`,`attribute`),
  KEY `idx_ldolfhbsoibmjyqcxrvssxtejusczvdbfwfm` (`elementId`,`siteId`,`dateUpdated`),
  KEY `fk_egtgymtkwjtjbrersvqryhnduckitqhtscyp` (`siteId`),
  KEY `fk_hmrjvfuegojhfrmuwkslblqpyilzxwerlmju` (`userId`),
  CONSTRAINT `fk_egtgymtkwjtjbrersvqryhnduckitqhtscyp` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_hmrjvfuegojhfrmuwkslblqpyilzxwerlmju` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_ufqoclxnzyalvzfqlkjmcstctutcexwspwyb` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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,
  PRIMARY KEY (`elementId`,`siteId`,`fieldId`),
  KEY `idx_crupjifyswnadcskavyqlmcalkjzcpzmmbno` (`elementId`,`siteId`,`dateUpdated`),
  KEY `fk_dovrovuarbyocpfeisoxcyschumcxzxayhoo` (`siteId`),
  KEY `fk_tlwhjuyrlecjbzuttcnfylaxamhpxszazneg` (`fieldId`),
  KEY `fk_eqaknpdvxkrwxugjsogrvlojlfplycflhjfc` (`userId`),
  CONSTRAINT `fk_dovrovuarbyocpfeisoxcyschumcxzxayhoo` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_eqaknpdvxkrwxugjsogrvlojlfplycflhjfc` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_prultuomemcryhcptmdcmvepgzggeajnanbh` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_tlwhjuyrlecjbzuttcnfylaxamhpxszazneg` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_jmexvcwxgmvpfynybdaigrqxmwbqmbsuvlqg` (`elementId`,`siteId`),
  KEY `idx_hfvpzaowvbmxckpmpsyytflwzgoygjwvalmt` (`siteId`),
  KEY `idx_xcaqiokcvuciwiquwodlstbyycllycxvchhr` (`title`),
  CONSTRAINT `fk_iazsfsnytaanqgrmnqdahvodbbyikcvkhcbc` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_sjixjmffenzplehunxektunnjashhwoyqqkl` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `drafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceId` int(11) DEFAULT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `provisional` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `notes` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `trackChanges` tinyint(1) NOT NULL DEFAULT 0,
  `dateLastMerged` datetime DEFAULT NULL,
  `saved` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_zxklruoipfrlioopxckexjegfplsfqpyvuwx` (`creatorId`,`provisional`),
  KEY `idx_lmudcuknfpkindmbndlcowclcqaicbsoniyl` (`saved`),
  KEY `fk_cobbbyssmjmsayjpyppwgkfttxnkqhleydgj` (`sourceId`),
  CONSTRAINT `fk_cieczapyveynlcdpkwwqedvdotffjnmjqges` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_cobbbyssmjmsayjpyppwgkfttxnkqhleydgj` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `elements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `canonicalId` int(11) DEFAULT NULL,
  `draftId` int(11) DEFAULT NULL,
  `revisionId` int(11) DEFAULT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_iadoeuzwmpgqwkqmzftbxsiakgiurbygtfzi` (`dateDeleted`),
  KEY `idx_daepxgiipndchjuevaupxgntzofabkyabwkz` (`fieldLayoutId`),
  KEY `idx_leauuekwoadwyquiupcojdcyknlcbqzxztnw` (`type`),
  KEY `idx_ealznszwqzxznautbufvmrkpfxscwrvkwwtt` (`enabled`),
  KEY `idx_bzkzkjazonhmcffefynngzvtymrwmjvnbors` (`archived`,`dateCreated`),
  KEY `idx_zursgblxaiudwsfsxslboduafoycomyducbw` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  KEY `fk_nrdkuhjoaihamgzumucffdbhfdtfenozrfnt` (`canonicalId`),
  KEY `fk_vxpqrngdbfvnpdxiilhzkdbgvutzssnouibf` (`draftId`),
  KEY `fk_irikulbajomtjwxnvxfyhibiybrphmitmese` (`revisionId`),
  CONSTRAINT `fk_cxnfbknjxijfekqsavbyhvceimmzhvhcfsel` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_irikulbajomtjwxnvxfyhibiybrphmitmese` FOREIGN KEY (`revisionId`) REFERENCES `revisions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_nrdkuhjoaihamgzumucffdbhfdtfenozrfnt` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_vxpqrngdbfvnpdxiilhzkdbgvutzssnouibf` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `elements_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_rbtyujhytejsljztnaurerdlvvizpzqaoozw` (`elementId`,`siteId`),
  KEY `idx_dnbrfjbjrlfmgayevoozlcojiceedujnxpnt` (`siteId`),
  KEY `idx_rrhufxgpkurhyekhtkwzzykqwvxmljnilhja` (`slug`,`siteId`),
  KEY `idx_ijnbvwpsaftcrsknawdispwasdkyjiunujyc` (`enabled`),
  KEY `idx_nunklaypiiblrdclnmhhlikntinpaqaujlvl` (`uri`,`siteId`),
  CONSTRAINT `fk_cjdrenivyctfvmpdckvrbuoyjqwvhaddygjv` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_mduopwsqogtjrdktutwianxvryifubtkhstv` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_tvzdrragptchwgugmegcnjqzfgxbdohvocfx` (`postDate`),
  KEY `idx_ijtptaahalchkiemmjakyuyeifzxqbwngegv` (`expiryDate`),
  KEY `idx_qkjdjolqatykgasvkdkwgbmhqpgnwsqgyeuz` (`authorId`),
  KEY `idx_pgmsdwsndvyfrcoccfgigzztnllwywolxdiv` (`sectionId`),
  KEY `idx_dydrixplpukwfymfbfsjuzjhvimqoncxnnkb` (`typeId`),
  KEY `fk_rzblktpujuepcglqtsepeecjrpmqmkpwtrzj` (`parentId`),
  CONSTRAINT `fk_cxvcrqvqgmpmyyzpqwcojmlmcdxgozxanrqv` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_jidchyusdqycfmirjwksgzuiedmlvlajrgmf` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_ltyllvcqrudymnthdbliecrkwjhjftkiuojp` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_qbinknlrmzihojpbfyufwtctaoiiihnceuta` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_rzblktpujuepcglqtsepeecjrpmqmkpwtrzj` FOREIGN KEY (`parentId`) REFERENCES `entries` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `entrytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hasTitleField` tinyint(1) NOT NULL DEFAULT 1,
  `titleTranslationMethod` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `titleFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_dtkgrwuvvbkysdemvcrxfpewnofrydfeuzjy` (`name`,`sectionId`),
  KEY `idx_plnkqdqqgmtyozikggbxppozweynjnqhexve` (`handle`,`sectionId`),
  KEY `idx_pzdtfydtnzrgvmibvrlprbhkqqqjocfzgivy` (`sectionId`),
  KEY `idx_detynulgxhcsavyuludyfvtesbczitcohrca` (`fieldLayoutId`),
  KEY `idx_vjjjxsiuxxnstcemfccjkebgqeimybkmdkqv` (`dateDeleted`),
  CONSTRAINT `fk_rwdbkkxskyuvjlojwbmhdjvhtbjnlvrzhcbh` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_xnlzaslxjvxxkdlprmmqowpwgvnugljtqody` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `fieldgroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_kcebkbnwasgjhapcunoghrlgzggegxhpoovy` (`name`),
  KEY `idx_uxuzmfddsdsdvcoqolmscjcgswbapbvasrde` (`dateDeleted`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `fieldlayoutfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `tabId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_nffngxrzvnzhaowsbdrevvbeclptrtawgpum` (`layoutId`,`fieldId`),
  KEY `idx_bfcsyuyfppwkfredvizxvdcmyqkbtxbigjds` (`sortOrder`),
  KEY `idx_avkqcohjxtltdebcerbhicqhulkfcqtboinw` (`tabId`),
  KEY `idx_stspbnwyiqlakdevlvxulqjgtmzolktqrdyr` (`fieldId`),
  CONSTRAINT `fk_fqxpbhsexnkrxtfkqbjwlydamrlgimnsbied` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_rtfypmmphnjbswwmwhubfdsrxzzddflbjalv` FOREIGN KEY (`tabId`) REFERENCES `fieldlayouttabs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xgcdxnljwmadpfvnokurzbbbeglxugqglmxs` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `fieldlayouttabs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `elements` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_ijqnyzextivdyjnjqqtijigtbufkmvfxylye` (`sortOrder`),
  KEY `idx_bosgkbkixywlugvclpactzbbcplyxnyyyadt` (`layoutId`),
  CONSTRAINT `fk_ezoaocqikfluzmujsouqycuenqsiinrklmsg` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'global',
  `columnSuffix` char(8) COLLATE utf8_unicode_ci DEFAULT NULL,
  `instructions` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `searchable` tinyint(1) NOT NULL DEFAULT 1,
  `translationMethod` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
  `translationKeyFormat` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_ruyysxdunswihnkcwraddwpylnfjtyicpzon` (`handle`,`context`),
  KEY `idx_dvtehlegajvhqhajirqoulfcmcwtmglnlkmo` (`groupId`),
  KEY `idx_iwbmjrbmjvshaypqarruljshpaibnganwafj` (`context`),
  CONSTRAINT `fk_iggnztexbugrpzxvdphzmuieqcnzihmptnba` FOREIGN KEY (`groupId`) REFERENCES `fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `globalsets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_psnpldxsrojvoiavpmmdciisskakwanyetzk` (`name`),
  KEY `idx_snhmcovxzuzrwwngjwbhnatchtrjvmlhllzv` (`handle`),
  KEY `idx_xulwpvrlsdenshrwnemmtbgtntwyrhxrxdwq` (`fieldLayoutId`),
  KEY `idx_tdrsbljjkrsjknoejjtervotcxcjvybpldtc` (`sortOrder`),
  CONSTRAINT `fk_funasakwmkvqffrfymdrsatafzvazrkksvpv` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_fuqdmatihkozlyixqngiibegrsfguurjmtoo` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_bbrjmjldacyvwduvwikaueaijinsabtlkbdd` (`ownerId`),
  KEY `idx_xrafzhjqjcmdymnylrvovhvkwtvosbqljiko` (`fieldId`),
  KEY `idx_unfgyjhaovrslzhaojllwvwyavwrmglsroul` (`typeId`),
  KEY `idx_ellppnmekhpuffrynumqadasqaqmbhzmpmvx` (`sortOrder`),
  CONSTRAINT `fk_iriyfuopdvncydoolxoawaohfvdiusyitfuv` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_neervmizswppfpwqsesqnrtrsmfhnvhbrisf` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pdlamtddvrdmyjytuwnqmaeqedqpfifbstue` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_revxdhfaptfyvvapmmvbepdkhuhupgvxotsk` FOREIGN KEY (`typeId`) REFERENCES `matrixblocktypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `matrixblocktypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_ntvqdphyvndqbdavqhophwjyptfykwyigjjm` (`name`,`fieldId`),
  KEY `idx_kbnepryvsyzxtfstwhodjttselkurjxggnhs` (`handle`,`fieldId`),
  KEY `idx_celwdvjzkqbblchlknzwecvmdpjrgixpiess` (`fieldId`),
  KEY `idx_dwzqxoauldugijtfpqcroqiyznksvmcvrohu` (`fieldLayoutId`),
  CONSTRAINT `fk_hzaugvtcrejdqrlpdgwggtjbhpmjcrbndbft` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_mexnaqupbzwffqcovpalxdmzgtywxijcaedb` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

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

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

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

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

CREATE TABLE `queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `channel` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'queue',
  `job` longblob NOT NULL,
  `description` text COLLATE utf8_unicode_ci 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) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `fail` tinyint(1) DEFAULT 0,
  `dateFailed` datetime DEFAULT NULL,
  `error` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_llgrewbrvhxhftldmdktqnhovckagctrkfxv` (`channel`,`fail`,`timeUpdated`,`timePushed`),
  KEY `idx_tybvgxcmhdxkczmjvibmiyxcaaabxfwqfukf` (`channel`,`fail`,`timeUpdated`,`delay`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `sourceSiteId` int(11) DEFAULT NULL,
  `targetId` int(11) NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_trzlttygcjnkfhtodkiafqknjttduxsgafgh` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  KEY `idx_dfonydoxrharledrsuombpftkjjkrahtgusn` (`sourceId`),
  KEY `idx_pzthuihrfocfgdhaavzicgzxkrxivstzaudq` (`targetId`),
  KEY `idx_kkuncqcqojmbcrerouwneyukfmmigqqodwfv` (`sourceSiteId`),
  CONSTRAINT `fk_rsecivmdcvulimoyvukvktihjgdjxivtliex` FOREIGN KEY (`targetId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_uhhtfvvzaydhaliiuxqdctklkeitzccghhyo` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xmxzyzqbitczhfwsnrraeeddzfmwqegnjmej` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xrfzuaftojcfehmsrxihqnhggbgkqfvqsjwk` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `revisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sourceId` int(11) NOT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `num` int(11) NOT NULL,
  `notes` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_aeiczxnoduqgzrafnwgxjifeemmwmphpvqhg` (`sourceId`,`num`),
  KEY `fk_puohtpxxdpibfddvljmiiidbbyunvoktmkke` (`creatorId`),
  CONSTRAINT `fk_puohtpxxdpibfddvljmiiidbbyunvoktmkke` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_ynbqyvwycmhzfbrvpgmsddvfsosocuisrzlg` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('single','channel','structure') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'channel',
  `enableVersioning` tinyint(1) NOT NULL DEFAULT 0,
  `propagationMethod` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all',
  `defaultPlacement` enum('beginning','end') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'end',
  `previewTargets` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_wgzwivqemwivanranixtanqzvdckcstjhwol` (`handle`),
  KEY `idx_wfvzoggqephxylelertvuhqpguzminuzvxou` (`name`),
  KEY `idx_zvinijffrtqrveombaffqucdvkqiwiaazywc` (`structureId`),
  KEY `idx_jkbdkqgrfocghaflblzdynxuyqdihlujvzys` (`dateDeleted`),
  CONSTRAINT `fk_ttwpqxzknsyqwmmmjfahuaxgwcrldfyptkjh` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `sections_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 1,
  `uriFormat` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `template` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabledByDefault` tinyint(1) NOT NULL DEFAULT 1,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_njuojkqnwmhgvakungwnximradgoyubwiwqt` (`sectionId`,`siteId`),
  KEY `idx_peeumwqlklohydqlhrmdmcuoksndtracdsdr` (`siteId`),
  CONSTRAINT `fk_thfznllplsqwqermgyaosvqpdkqczsqkeqda` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_xzlqztqniebgqaymjknfmarirkjwmegurqif` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `sequences` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `next` int(11) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `shunnedmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_icmwbwucgmemhtauyzpllgosywhpahoiyqrw` (`userId`,`message`),
  CONSTRAINT `fk_vzqyrvbzgruymvegixtjeqdgwlpgoxijjlct` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `language` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 0,
  `baseUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_spjuymxckqazfwvwvkyomkebacdmacbbrssc` (`dateDeleted`),
  KEY `idx_jjomcrbpozskwxzhvwabzkxxhzobrmhhbkjm` (`handle`),
  KEY `idx_zsvdryssxniwgawmorkwdmcnlirxrzvotvdq` (`sortOrder`),
  KEY `fk_atbwllhfoeugqpocjvdoooztqmclqtvdgwpe` (`groupId`),
  CONSTRAINT `fk_atbwllhfoeugqpocjvdoooztqmclqtvdgwpe` FOREIGN KEY (`groupId`) REFERENCES `sitegroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `structureelements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `elementId` int(11) DEFAULT NULL,
  `root` int(11) unsigned DEFAULT NULL,
  `lft` int(11) unsigned NOT NULL,
  `rgt` int(11) unsigned NOT NULL,
  `level` smallint(6) unsigned NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_avtskeajmgibwsfmqrhbihclukiejxgdhcit` (`structureId`,`elementId`),
  KEY `idx_tjzjjgpxngimxaloayaxrwkuezwvxfjiwdgx` (`root`),
  KEY `idx_ubrxdwtlhlvgtddbuguunjbsonkuhjzrncnf` (`lft`),
  KEY `idx_vqeggitegijvbvwvkmgxnebdylsitgyjytek` (`rgt`),
  KEY `idx_nouwulqsblkcksrytvwytugjkwlrnvgiettr` (`level`),
  KEY `idx_zwolfdoompsjzresahyrldbjesfjpkkxvvhh` (`elementId`),
  CONSTRAINT `fk_ktbjypcidnepfuqqpsjwyyfbkplvxlkiqzgy` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_rymryelpdjxsdvaehmeeiyzhnljflmsnycsg` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `structures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maxLevels` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_modqwxnxjnfwlkexoqjoxwydnxzjrnosnbub` (`dateDeleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `taggroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_nhtrtosennxilmadeodcuvoylnretkqfqtuf` (`name`),
  KEY `idx_ggndrwgkjzvkoiwmtbmdtxmpdajuhipoxuvg` (`handle`),
  KEY `idx_nfnxcastufbihibrivkhqgrumujiwnyphztf` (`dateDeleted`),
  KEY `fk_iulkqyushywccatfvlpbmhmwcurunqnqvgcu` (`fieldLayoutId`),
  CONSTRAINT `fk_iulkqyushywccatfvlpbmhmwcurunqnqvgcu` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- 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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_poqlnkcsfvcepkdudcnrzhjajgzbagyqnnax` (`groupId`),
  CONSTRAINT `fk_tqxryxfjcakuxfypnicruqvqduyswzrkraly` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_zkztbazigoqbwzjjgsdmvxyodicbdamlvgvh` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `templatecacheelements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheId` int(11) NOT NULL,
  `elementId` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_wpiviihoziozkepxzwtwjejnrazjnjuwxbmn` (`cacheId`),
  KEY `idx_sgkxprwzxhfspohpnzqkcsmhhjqaenkgjshy` (`elementId`),
  CONSTRAINT `fk_esnijunnahsahtsutkrbxhxfcqtjkxfppqzh` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_mazjvprrtscafenwyzkirfcwvkeieayutexp` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `templatecachequeries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheId` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `query` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_vcknxefihunqnihhayawvtyxelkkvjwdjyuv` (`cacheId`),
  KEY `idx_yezxjuoetppyczcwohwvjerxsevcbddsqbls` (`type`),
  CONSTRAINT `fk_mrivzvqeqtljdxvpyxzdumjdqgztljcpvbqr` FOREIGN KEY (`cacheId`) REFERENCES `templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `templatecaches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `siteId` int(11) NOT NULL,
  `cacheKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expiryDate` datetime NOT NULL,
  `body` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_wkgguqlosipudqiwahmvbfolzvmzlkcoesdw` (`cacheKey`,`siteId`,`expiryDate`,`path`),
  KEY `idx_zapssaonduxurwgctkwfptnfwuqsqweziqtn` (`cacheKey`,`siteId`,`expiryDate`),
  KEY `idx_dhsqmqbwezngfdhrlbsgshtyiqmgopbmvfgi` (`siteId`),
  CONSTRAINT `fk_bijsaoihsfoekfohaqwnyzikqdyvirenyyeh` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `usergroups_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_xcompgeqmzrnijhphbivplvdslykkcmclpok` (`groupId`,`userId`),
  KEY `idx_khkqztpmlkjtvoqmfocmvhrljoypyhovuppk` (`userId`),
  CONSTRAINT `fk_edhwzomynfcsybdaxfrsbdwtvbzfpnadbxpu` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_hrmysrrscigrpucyduoaxqggofffgaiqzxft` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

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

CREATE TABLE `userpermissions_usergroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_wpqwmqgwrlngeiimsuihvljfwojdinvxyeeu` (`permissionId`,`groupId`),
  KEY `idx_grutwcvssztepcusxcgevwrmpckumotcapcl` (`groupId`),
  CONSTRAINT `fk_lpwfevctoxfscdomiqwuhhonegfhhikgfonr` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_zlusrlaohbpuqgnqovrwbiheokyykxvfujon` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `userpermissions_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_vabqddlgzphjiacjnmiscveickeaehvwtjfj` (`permissionId`,`userId`),
  KEY `idx_pwpldxbwambvksaqsxwbshtqpvwtvlsfqzrs` (`userId`),
  CONSTRAINT `fk_vfcyojcojgfymeopkluqphagusgwlbgjslkj` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_wpxgcmwopcygvaieyoxcdgimynqoeipyqfgq` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `userpreferences` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `preferences` text COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`userId`),
  CONSTRAINT `fk_uufyuanvyieulvlgqominfmuuuvljatbyivh` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `volumefolders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ikwqkfphgwogclpavqavjssxtxahmvzylzqz` (`name`,`parentId`,`volumeId`),
  KEY `idx_rymrvwetyagvzrrabcvxpduoztwledcoavjn` (`parentId`),
  KEY `idx_lxvfkmdejgelylveilgszbwodvhjanpegdfy` (`volumeId`),
  CONSTRAINT `fk_sszoeymcuhodiujqkompsajkzfvjffsffyeo` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xuhygiqxmvdtsmusttbgjjhbsaadneibhgto` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `volumes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT 1,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `titleTranslationMethod` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `settings` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_subtyktbtllqkeduwpyjcauimrsiesvbkmkw` (`name`),
  KEY `idx_lhksrfpqussonajqzvbbauckskymshufgyzx` (`handle`),
  KEY `idx_flpdrnrzuljohgohlrfiqnmxtxjjfvyjcfao` (`fieldLayoutId`),
  KEY `idx_weqxsnnpbhgrfrckjnnqsrorzzndlidssonf` (`dateDeleted`),
  CONSTRAINT `fk_hqveopkwcrekonuckfwucyhzpwgvreximqcm` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

CREATE TABLE `widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `colspan` tinyint(3) DEFAULT NULL,
  `settings` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_yzjihyneskbovvvdklwfjetlvgsyplpnpheb` (`userId`),
  CONSTRAINT `fk_tgikxapgyosprgzfdqldujludhnugxejvfse` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping routines for database 'gfh2022_CraftCMS'
--


--
-- Host: 127.0.0.1    Database: gfh2022_CraftCMS
-- ------------------------------------------------------


--
-- Dumping data for table `announcements`
--

set autocommit=0;
commit;

--
-- Dumping data for table `assets`
--

set autocommit=0;
commit;

--
-- Dumping data for table `assettransforms`
--

set autocommit=0;
commit;

--
-- Dumping data for table `categories`
--

set autocommit=0;
commit;

--
-- Dumping data for table `categorygroups`
--

set autocommit=0;
commit;

--
-- Dumping data for table `categorygroups_sites`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `changedfields`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `content` VALUES (1,1,1,NULL,'2022-04-08 20:37:41','2022-04-08 20:37:41','63552dcb-0636-4a5f-b5ed-0ceb01a67354');
commit;
set autocommit=0;
commit;
set autocommit=0;
commit;

--
-- Dumping data for table `drafts`
--

set autocommit=0;
commit;

--
-- Dumping data for table `elementindexsettings`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `elements` VALUES (1,NULL,NULL,NULL,NULL,'craft\\elements\\User',1,0,'2022-04-08 20:37:41','2022-04-08 20:37:41',NULL,NULL,'f007082e-6e7e-4a45-b168-49fee4633380');
commit;

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

set autocommit=0;
INSERT INTO `elements_sites` VALUES (1,1,1,NULL,NULL,1,'2022-04-08 20:37:41','2022-04-08 20:37:41','6de43cbf-a5b3-42c1-af40-798ecaef0bb0');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `fieldgroups` VALUES (1,'Common','2022-04-08 20:37:41','2022-04-08 20:37:41',NULL,'c6bf52f5-b83e-4c91-be01-6aa4ad09ad0a');
commit;

--
-- Dumping data for table `fieldlayoutfields`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `fields`
--

set autocommit=0;
commit;

--
-- Dumping data for table `globalsets`
--

set autocommit=0;
commit;

--
-- Dumping data for table `gqlschemas`
--

set autocommit=0;
commit;
set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `info` VALUES (1,'3.7.27.2','3.7.8',1,'pvrlmljhpmty','3@hjyitopsxk','2022-04-08 20:37:41','2022-04-08 22:27:03','9bf2b41b-f3f7-4317-afd4-0242e833306f');
commit;

--
-- Dumping data for table `matrixblocks`
--

set autocommit=0;
commit;

--
-- Dumping data for table `matrixblocktypes`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `migrations` VALUES (1,'craft','Install','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','4fc7eeff-b33f-4ec0-a268-e72d7097da84'),(2,'craft','m150403_183908_migrations_table_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8e103d64-833d-45d4-bc07-cd61d5355ecb'),(3,'craft','m150403_184247_plugins_table_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b80fb8b9-e8c3-4a16-a263-92daf3b419f3'),(4,'craft','m150403_184533_field_version','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','51ea6166-4777-406f-8db6-e060ef50d85f'),(5,'craft','m150403_184729_type_columns','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5ed82399-23ac-4152-aea4-734b9a2b7744'),(6,'craft','m150403_185142_volumes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c8337c80-93c9-445f-aff8-1856006dfdbb'),(7,'craft','m150428_231346_userpreferences','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','27911dd0-a258-4357-9ed7-fea808648853'),(8,'craft','m150519_150900_fieldversion_conversion','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9eaa4009-31df-4bf6-91b7-3e04f9548206'),(9,'craft','m150617_213829_update_email_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','51d9257b-66c4-4bdc-b162-092bc955829c'),(10,'craft','m150721_124739_templatecachequeries','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','72d852ae-a432-4d8a-8077-685b435e2ec4'),(11,'craft','m150724_140822_adjust_quality_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f79b23c9-266e-4710-aa80-a47bec8f483b'),(12,'craft','m150815_133521_last_login_attempt_ip','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6d8b595a-87e6-45d4-9536-6d4740a0b5a3'),(13,'craft','m151002_095935_volume_cache_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','36a859a8-f8b5-4e37-ae5e-49c138d6c348'),(14,'craft','m151005_142750_volume_s3_storage_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','05f1556c-2cbd-4afb-9b3e-2fff98fa4019'),(15,'craft','m151016_133600_delete_asset_thumbnails','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8b4c0214-52dd-4eec-a54a-83b39ff423f2'),(16,'craft','m151209_000000_move_logo','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','42e6d98a-e499-4794-9691-3a0b319ca2ec'),(17,'craft','m151211_000000_rename_fileId_to_assetId','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','92120bcc-6a5a-427f-9695-db41a12637c0'),(18,'craft','m151215_000000_rename_asset_permissions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','67eb186e-22a0-40a2-92c4-10d58a5c89f7'),(19,'craft','m160707_000001_rename_richtext_assetsource_setting','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','44b8c944-4fc0-4496-b85e-67eb3e60b9bd'),(20,'craft','m160708_185142_volume_hasUrls_setting','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','7d7c039a-ce5a-4a77-ac79-65d12d2df721'),(21,'craft','m160714_000000_increase_max_asset_filesize','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','db367fd6-997f-481b-8bd0-19faadb9670c'),(22,'craft','m160727_194637_column_cleanup','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c0b13b84-2eec-417e-8711-fd49482491bb'),(23,'craft','m160804_110002_userphotos_to_assets','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f0a119a7-4718-48b1-9f32-672bca839433'),(24,'craft','m160807_144858_sites','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','3141cc24-a096-4f5e-a0b0-980ebd28cbbe'),(25,'craft','m160829_000000_pending_user_content_cleanup','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ba4fa519-336f-4b48-9b9a-5b714222a1c1'),(26,'craft','m160830_000000_asset_index_uri_increase','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','cc786388-6c91-448b-a396-cce653f5dbb5'),(27,'craft','m160912_230520_require_entry_type_id','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1f148129-eb8c-4f5f-91e1-c16319cea49c'),(28,'craft','m160913_134730_require_matrix_block_type_id','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2cb99c7c-b3e4-4a27-8850-3e8b4715a5b1'),(29,'craft','m160920_174553_matrixblocks_owner_site_id_nullable','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','abc28a0b-99ba-425e-b986-cd7b3ec37354'),(30,'craft','m160920_231045_usergroup_handle_title_unique','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6a3fc64d-3cb9-469f-a714-d71bbb661d3c'),(31,'craft','m160925_113941_route_uri_parts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','826b8a06-25b2-4d40-b97e-9a9eb668d8fc'),(32,'craft','m161006_205918_schemaVersion_not_null','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','0f2d9bdb-eb54-4a26-a74b-01ef2762060a'),(33,'craft','m161007_130653_update_email_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','84869ae2-612c-4465-bb89-4266688005ee'),(34,'craft','m161013_175052_newParentId','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','93371ec8-7dab-4be9-8423-557b48ec0f15'),(35,'craft','m161021_102916_fix_recent_entries_widgets','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b29d70fa-7aa7-4a27-8814-1953283c5a33'),(36,'craft','m161021_182140_rename_get_help_widget','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','fde650bd-a5fa-4b7d-9a88-978c0286bf97'),(37,'craft','m161025_000000_fix_char_columns','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c97c35f9-c8ab-43ce-87c3-51d29382e6d1'),(38,'craft','m161029_124145_email_message_languages','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9ce6aa0d-f0c4-43e6-baa4-897334170b10'),(39,'craft','m161108_000000_new_version_format','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','42fedce8-5bc7-4df1-8698-7898bb95e888'),(40,'craft','m161109_000000_index_shuffle','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','49922a26-612c-4778-b5a7-7f605b9d6b84'),(41,'craft','m161122_185500_no_craft_app','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ee7a7a80-b24d-414b-b51b-43d2fd76ae5c'),(42,'craft','m161125_150752_clear_urlmanager_cache','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','56fded3e-ae84-4b77-aee3-d8f36c221f51'),(43,'craft','m161220_000000_volumes_hasurl_notnull','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6d768f6c-099e-4425-bb5f-2f7d01cd941f'),(44,'craft','m170114_161144_udates_permission','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b91f9858-bc6a-43c4-8de0-83cea6aa0201'),(45,'craft','m170120_000000_schema_cleanup','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','369247fa-8980-4684-9350-7e0bb369f87e'),(46,'craft','m170126_000000_assets_focal_point','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f7759f47-71f5-4302-aa8e-7026c43a98b6'),(47,'craft','m170206_142126_system_name','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','283bff82-60a4-423e-83fa-a649772e00a0'),(48,'craft','m170217_044740_category_branch_limits','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5ce79705-9cfc-4a98-ac98-c36386435368'),(49,'craft','m170217_120224_asset_indexing_columns','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2bedc567-1cf4-4c7f-bfd3-4f9add5982e8'),(50,'craft','m170223_224012_plain_text_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','cd9579a7-de0e-4aee-94dd-e9edd5c171a0'),(51,'craft','m170227_120814_focal_point_percentage','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','97ace15e-029e-488a-acd4-6d1beb8f45db'),(52,'craft','m170228_171113_system_messages','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','57bdec2b-29cf-45b5-940e-4e4859aac375'),(53,'craft','m170303_140500_asset_field_source_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8b42e502-78e7-44c4-b273-e4fd822efd7b'),(54,'craft','m170306_150500_asset_temporary_uploads','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2af86cd5-1219-4649-b3ea-365670a43dde'),(55,'craft','m170523_190652_element_field_layout_ids','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','54fb0918-f3cf-4f09-943f-aeb6b828ec37'),(56,'craft','m170621_195237_format_plugin_handles','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8ece7e7f-9f9c-4994-aeee-cf66e41e1fa5'),(57,'craft','m170630_161027_deprecation_line_nullable','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','83227f5f-ac58-4129-899c-15ae8d93231b'),(58,'craft','m170630_161028_deprecation_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2ae70cd3-2bf4-42d9-a787-28919239604e'),(59,'craft','m170703_181539_plugins_table_tweaks','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','fe0e9017-8516-4b35-9a7e-875368835b73'),(60,'craft','m170704_134916_sites_tables','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','47327fa4-013e-47a6-a015-2fb6927b1278'),(61,'craft','m170706_183216_rename_sequences','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','01833624-152a-480c-a079-f32f714475e7'),(62,'craft','m170707_094758_delete_compiled_traits','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','610c5aaa-969d-42f6-aac2-d64a819599ea'),(63,'craft','m170731_190138_drop_asset_packagist','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','acd2c84d-25f7-4534-bdd8-c38324c2488e'),(64,'craft','m170810_201318_create_queue_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d39eb025-eecd-42fc-ad0e-40cafdf9ed09'),(65,'craft','m170903_192801_longblob_for_queue_jobs','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','da95720b-05a4-4766-b993-d58bad4f1a50'),(66,'craft','m170914_204621_asset_cache_shuffle','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','84cdc7df-9d94-4a69-a6dc-1a383f665afc'),(67,'craft','m171011_214115_site_groups','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1e6801ac-ad30-4f8e-a028-363108e6a21b'),(68,'craft','m171012_151440_primary_site','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','20e322d4-e2dd-4ac6-84e5-54575f2d3b90'),(69,'craft','m171013_142500_transform_interlace','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f1b85664-420a-4013-b0c3-70d23c64207a'),(70,'craft','m171016_092553_drop_position_select','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d78b428c-21d5-479b-894f-9fdcc1f04dec'),(71,'craft','m171016_221244_less_strict_translation_method','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2472171a-4b22-42b3-80c8-4f3d0b2e25a1'),(72,'craft','m171107_000000_assign_group_permissions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','737d29e8-fbb8-4b82-80a5-42c5bd163155'),(73,'craft','m171117_000001_templatecache_index_tune','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','de0d8227-9b9d-49b4-a34d-f178f08e9a5a'),(74,'craft','m171126_105927_disabled_plugins','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','a936e091-58ea-4da2-affb-7c30584f639f'),(75,'craft','m171130_214407_craftidtokens_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','bf88ec49-03e8-4e87-9231-52891fced6fa'),(76,'craft','m171202_004225_update_email_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','07eb2b75-7d85-4219-a0e3-d05a1643b415'),(77,'craft','m171204_000001_templatecache_index_tune_deux','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c6490278-ce54-4b98-ad6b-eebc8d7400f9'),(78,'craft','m171205_130908_remove_craftidtokens_refreshtoken_column','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e894c400-6e98-4dda-a048-7af2475c2e85'),(79,'craft','m171218_143135_longtext_query_column','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','a64f60d8-cf43-45de-99eb-441325280bae'),(80,'craft','m171231_055546_environment_variables_to_aliases','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f7803251-b0b6-44e7-8032-5885521cf726'),(81,'craft','m180113_153740_drop_users_archived_column','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','7f072ae6-2c4e-4eaa-a002-b49c8264ad95'),(82,'craft','m180122_213433_propagate_entries_setting','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','42cadcd7-6ece-471c-a9b8-25f6efbbd425'),(83,'craft','m180124_230459_fix_propagate_entries_values','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','70f47888-2b4c-4323-baa0-76dcff06d917'),(84,'craft','m180128_235202_set_tag_slugs','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5f011897-0e16-41f0-bc9b-00d452c29472'),(85,'craft','m180202_185551_fix_focal_points','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','32038603-1058-45bd-912b-2b6d96cac19c'),(86,'craft','m180217_172123_tiny_ints','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e30e48a2-667d-48ea-a48c-83c0f15acf09'),(87,'craft','m180321_233505_small_ints','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5207e1e7-0ea8-4a52-a9af-a4096bc1e8b9'),(88,'craft','m180404_182320_edition_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8498e6e1-9a06-4463-9df4-e2322c230247'),(89,'craft','m180411_102218_fix_db_routes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5e56bc35-80ea-4dc6-ac1d-6319d7e4d56a'),(90,'craft','m180416_205628_resourcepaths_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','8eb88889-8826-4c10-a446-acb679a3cb1d'),(91,'craft','m180418_205713_widget_cleanup','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','3f512972-0f3d-49fc-b6f3-b37b0ef337ba'),(92,'craft','m180425_203349_searchable_fields','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','799e164b-9a37-4730-8701-ed4807e8e6ef'),(93,'craft','m180516_153000_uids_in_field_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','682c601d-8f70-4980-b96a-647884ed6569'),(94,'craft','m180517_173000_user_photo_volume_to_uid','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e53be738-9fba-4057-9b09-503229f6bf79'),(95,'craft','m180518_173000_permissions_to_uid','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','96a8a1bf-a8cf-4673-8418-64570badf1d7'),(96,'craft','m180520_173000_matrix_context_to_uids','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1848fc04-fdb6-4259-8ea1-44c52b742d7e'),(97,'craft','m180521_172900_project_config_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','30251a52-768f-4b40-b2a8-d5d46aba04c8'),(98,'craft','m180521_173000_initial_yml_and_snapshot','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','64f664b9-207c-41d2-b7ac-2e46243bf6b2'),(99,'craft','m180731_162030_soft_delete_sites','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','0eb16959-f26b-479e-8159-cf8851efa9fc'),(100,'craft','m180810_214427_soft_delete_field_layouts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6664eb3c-aff2-41a1-84e5-6d843083b580'),(101,'craft','m180810_214439_soft_delete_elements','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d0e48fb6-f530-485b-a84c-5cd5e05d84e3'),(102,'craft','m180824_193422_case_sensitivity_fixes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','750150fd-e3b4-4b70-b4f8-872048d8f472'),(103,'craft','m180901_151639_fix_matrixcontent_tables','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','308a5fb6-87f6-4597-858b-acf84dd39838'),(104,'craft','m180904_112109_permission_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d82730fd-e6c0-433d-931c-f9f9d1a62af6'),(105,'craft','m180910_142030_soft_delete_sitegroups','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','84ffb6d3-082e-448c-b6a1-0accd32ae292'),(106,'craft','m181011_160000_soft_delete_asset_support','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f176a25a-c2e6-48a5-8558-d38705d90af6'),(107,'craft','m181016_183648_set_default_user_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c19c3d7d-c02a-4013-84a4-7f22aea9fe91'),(108,'craft','m181017_225222_system_config_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9fc8e639-eee6-4404-8f77-1c95893c1fd4'),(109,'craft','m181018_222343_drop_userpermissions_from_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','034861b9-50cd-40fb-bba1-d5450650b613'),(110,'craft','m181029_130000_add_transforms_routes_to_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','7ea520b9-0e09-4f13-aee8-83d54c3c8aa7'),(111,'craft','m181112_203955_sequences_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','096fd1a0-a919-46ba-b1c8-f4214b91683c'),(112,'craft','m181121_001712_cleanup_field_configs','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ccfd742e-2602-40de-944d-d53bc1f392b8'),(113,'craft','m181128_193942_fix_project_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5b43672f-b85a-4372-af27-90ff871dbcd4'),(114,'craft','m181130_143040_fix_schema_version','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1e3f9dec-3ad4-4344-8b1c-edadacd7ffc1'),(115,'craft','m181211_143040_fix_entry_type_uids','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','04bd3ca0-79b9-4b07-bae9-0cdaf57539d1'),(116,'craft','m181217_153000_fix_structure_uids','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','25fcb35b-cd84-4e5d-a41c-240c164fca7d'),(117,'craft','m190104_152725_store_licensed_plugin_editions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1685295f-ff1a-4ccf-abb2-94ee77bcca4c'),(118,'craft','m190108_110000_cleanup_project_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','33475907-4168-49b5-8d2c-7f00d4d0e953'),(119,'craft','m190108_113000_asset_field_setting_change','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1e551851-5f53-47a3-937b-02a66659b4d0'),(120,'craft','m190109_172845_fix_colspan','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','cd1b87cb-00d2-4b3d-9a87-88db6a078354'),(121,'craft','m190110_150000_prune_nonexisting_sites','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','4573dcef-3003-4409-b984-4146c22baf5e'),(122,'craft','m190110_214819_soft_delete_volumes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','dccbaab0-2913-4cd1-9d9e-ac93a727eb81'),(123,'craft','m190112_124737_fix_user_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6f6df1ab-f023-4bca-b862-c77f4db8e1da'),(124,'craft','m190112_131225_fix_field_layouts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ff975a8f-6781-42fb-a923-9b1a2ae441b2'),(125,'craft','m190112_201010_more_soft_deletes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','261bd97b-7f28-448d-8dcb-f39dd98faac1'),(126,'craft','m190114_143000_more_asset_field_setting_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','14a458ef-4139-43b8-be77-aa376d2c5ef3'),(127,'craft','m190121_120000_rich_text_config_setting','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','52d21e93-632c-460e-bf22-6015987c12d5'),(128,'craft','m190125_191628_fix_email_transport_password','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','687cd6ac-bc4f-4865-8d13-3f379117009b'),(129,'craft','m190128_181422_cleanup_volume_folders','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d5370a98-2400-4f0a-9d29-2fc78262913e'),(130,'craft','m190205_140000_fix_asset_soft_delete_index','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','62354e71-b8ae-4506-a163-a48df69b1e15'),(131,'craft','m190218_143000_element_index_settings_uid','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','3654575c-e2f0-4ebd-b2ab-0d3c265fa7d7'),(132,'craft','m190312_152740_element_revisions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','0ce8704e-e62c-4cb7-b23c-01ed199d0663'),(133,'craft','m190327_235137_propagation_method','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d895a89e-58a3-4b06-b71e-6deb019f580b'),(134,'craft','m190401_223843_drop_old_indexes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f23439e8-f75a-45c4-90ae-fa27c4c72c47'),(135,'craft','m190416_014525_drop_unique_global_indexes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','188b5f46-23b5-47cb-8a56-ef4f89c930e4'),(136,'craft','m190417_085010_add_image_editor_permissions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','93c904a5-7f78-475b-b9e4-3c4c27595b61'),(137,'craft','m190502_122019_store_default_user_group_uid','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','7479a4bf-250e-45ad-9978-c00ad97bca60'),(138,'craft','m190504_150349_preview_targets','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e1609c22-c0b2-4efc-94e6-cea2b0c96c9e'),(139,'craft','m190516_184711_job_progress_label','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','942a511b-ac4c-4d94-a702-4eef1801c403'),(140,'craft','m190523_190303_optional_revision_creators','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f75eaa6b-721e-4832-99d6-784561c863e0'),(141,'craft','m190529_204501_fix_duplicate_uids','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c491ab90-8bc2-4ba8-a20e-60521c8b23de'),(142,'craft','m190605_223807_unsaved_drafts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','3bfd2b86-7a91-439a-b549-a0a8b09f3340'),(143,'craft','m190607_230042_entry_revision_error_tables','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5e54eddb-71c9-4a0c-9b25-9f8a73b4c749'),(144,'craft','m190608_033429_drop_elements_uid_idx','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d56c55cb-6e3d-43e2-802e-a52bd12bf306'),(145,'craft','m190617_164400_add_gqlschemas_table','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e266f3cf-f97a-40df-8bdf-b7e8ed4b2881'),(146,'craft','m190624_234204_matrix_propagation_method','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','fe9fd459-7da9-43ec-b30e-13bef15236a7'),(147,'craft','m190711_153020_drop_snapshots','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','a3fb7644-81df-4cb8-87be-3c07c6509539'),(148,'craft','m190712_195914_no_draft_revisions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','d8f836d3-eb74-4c41-8381-9437cc1988a4'),(149,'craft','m190723_140314_fix_preview_targets_column','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ceb9e1d5-d882-4d62-b187-7f12d07078b3'),(150,'craft','m190820_003519_flush_compiled_templates','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','2fe422e2-ded5-4372-9aa6-ca07190c6831'),(151,'craft','m190823_020339_optional_draft_creators','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','33a3c3d2-3c96-48a6-9139-eac38bf908ff'),(152,'craft','m190913_152146_update_preview_targets','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','430aa99c-6546-426e-a74e-c00e90f24723'),(153,'craft','m191107_122000_add_gql_project_config_support','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9bf43b5f-4d35-4e18-8f00-dbe8569683a3'),(154,'craft','m191204_085100_pack_savable_component_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9d541747-0b1e-405f-b5a8-e3b6b73a8301'),(155,'craft','m191206_001148_change_tracking','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b807b8bc-1043-40d6-9328-10f8e61c87a6'),(156,'craft','m191216_191635_asset_upload_tracking','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','fd1a44c0-5dda-40f3-b8f8-2b49e7a28d80'),(157,'craft','m191222_002848_peer_asset_permissions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c0159da3-534e-4853-9f81-ff95849d6d84'),(158,'craft','m200127_172522_queue_channels','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','665e7e29-a9ee-400d-83b9-fd3836d8b156'),(159,'craft','m200211_175048_truncate_element_query_cache','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','7f4c2f34-9387-456d-bf05-b28e8d765d8a'),(160,'craft','m200213_172522_new_elements_index','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','047a859e-17b9-43a6-a16f-1a119fca5fcd'),(161,'craft','m200228_195211_long_deprecation_messages','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','34911bfb-ca83-434e-87c0-b61905372469'),(162,'craft','m200306_054652_disabled_sites','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','0fc5682b-50ca-4f86-a514-b1079928f6b4'),(163,'craft','m200522_191453_clear_template_caches','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1c47d591-05cf-4f9c-ba93-fe04a095058c'),(164,'craft','m200606_231117_migration_tracks','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1153505c-fae2-49e3-97ab-de24369c2f6b'),(165,'craft','m200619_215137_title_translation_method','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','a7792b59-cfb1-402c-8727-206b4a4e76da'),(166,'craft','m200620_005028_user_group_descriptions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6deadf09-0af0-4ed9-bcc5-3a9b3036e0ab'),(167,'craft','m200620_230205_field_layout_changes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','c56803cf-b64e-470a-9b2a-a22543ca0012'),(168,'craft','m200625_131100_move_entrytypes_to_top_project_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ef2e75c0-44e1-43f5-8471-353857dbc654'),(169,'craft','m200629_112700_remove_project_config_legacy_files','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','6a3d97e8-6cce-4a28-bddf-dbe54c05a209'),(170,'craft','m200630_183000_drop_configmap','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','33f2af17-ed7b-4225-a984-a11a526dcc3d'),(171,'craft','m200715_113400_transform_index_error_flag','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','ca3448a9-ee85-4d3b-abd4-ba4b4664907e'),(172,'craft','m200716_110900_replace_file_asset_permissions','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e84258a0-f44b-4238-b2f9-3106f9da48ef'),(173,'craft','m200716_153800_public_token_settings_in_project_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f9b33422-d246-4157-b1ba-e0f481b6b017'),(174,'craft','m200720_175543_drop_unique_constraints','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','9a4feff8-83ad-42aa-973f-ea589c134451'),(175,'craft','m200825_051217_project_config_version','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','48502f1f-b4d1-4a93-b389-f27c7fa46d34'),(176,'craft','m201116_190500_asset_title_translation_method','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','cdbeb7be-350d-414d-a92c-362fab30ac3d'),(177,'craft','m201124_003555_plugin_trials','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','378c5a9a-3739-4f91-a66a-48f308df5b74'),(178,'craft','m210209_135503_soft_delete_field_groups','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','e650a64a-91d7-4ece-945a-1af21ec3c354'),(179,'craft','m210212_223539_delete_invalid_drafts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','864f75b1-b610-46da-9b9d-975d094aa772'),(180,'craft','m210214_202731_track_saved_drafts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','07fc8eec-bacd-454d-af78-c5b2048ad56a'),(181,'craft','m210223_150900_add_new_element_gql_schema_components','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','263f0bba-6855-4042-b988-e43d40976183'),(182,'craft','m210302_212318_canonical_elements','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','1431541a-7f6f-47b9-a192-1c3dfa45b12f'),(183,'craft','m210326_132000_invalidate_projectconfig_cache','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','5f6324b6-3a4d-4bcc-8426-d382375d7962'),(184,'craft','m210329_214847_field_column_suffixes','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f724bc65-5701-4089-b5b6-5afb93f6dbbf'),(185,'craft','m210331_220322_null_author','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','33247f89-2157-400a-9fdb-bf7f71910c5a'),(186,'craft','m210405_231315_provisional_drafts','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','21ec3dd7-37a5-4999-a459-4e59563955cf'),(187,'craft','m210602_111300_project_config_names_in_config','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b657c6d6-55ef-40a7-b611-1f795920771b'),(188,'craft','m210611_233510_default_placement_settings','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f11e69e1-cc75-4bc3-bf1c-99fd1990a60a'),(189,'craft','m210613_145522_sortable_global_sets','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','f48326ea-97b1-4017-9521-3511f43132a4'),(190,'craft','m210613_184103_announcements','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','562c0a77-ab63-478b-8b16-63f219a9ee2d'),(191,'craft','m210829_000000_element_index_tweak','2022-04-08 20:37:41','2022-04-08 20:37:41','2022-04-08 20:37:41','b616b54b-4295-4a11-9bbd-9da42685c22d');
commit;

--
-- Dumping data for table `plugins`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `projectconfig` VALUES ('dateModified','1649450261'),('email.fromEmail','\"alex@geniusesforhire.com\"'),('email.fromName','\"Growthintegral\"'),('email.transportType','\"craft\\\\mail\\\\transportadapters\\\\Sendmail\"'),('fieldGroups.c6bf52f5-b83e-4c91-be01-6aa4ad09ad0a.name','\"Common\"'),('meta.__names__.21a1bac2-c185-44d9-94e3-4726317fc0ce','\"Growthintegral\"'),('meta.__names__.c6bf52f5-b83e-4c91-be01-6aa4ad09ad0a','\"Common\"'),('meta.__names__.dc8d84fe-f0db-4ef0-a191-09b29840e174','\"Growthintegral\"'),('siteGroups.dc8d84fe-f0db-4ef0-a191-09b29840e174.name','\"Growthintegral\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.baseUrl','\"$PRIMARY_SITE_URL\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.handle','\"default\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.hasUrls','true'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.language','\"en-US\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.name','\"Growthintegral\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.primary','true'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.siteGroup','\"dc8d84fe-f0db-4ef0-a191-09b29840e174\"'),('sites.21a1bac2-c185-44d9-94e3-4726317fc0ce.sortOrder','1'),('system.edition','\"solo\"'),('system.live','true'),('system.name','\"Growthintegral\"'),('system.schemaVersion','\"3.7.8\"'),('system.timeZone','\"America/Los_Angeles\"'),('users.allowPublicRegistration','false'),('users.defaultGroup','null'),('users.photoSubpath','null'),('users.photoVolumeUid','null'),('users.requireEmailVerification','true');
commit;

--
-- Dumping data for table `queue`
--

set autocommit=0;
commit;

--
-- Dumping data for table `relations`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `searchindex` VALUES (1,'username',0,1,' accarpenter '),(1,'firstname',0,1,''),(1,'lastname',0,1,''),(1,'fullname',0,1,''),(1,'email',0,1,' alex geniusesforhire com '),(1,'slug',0,1,'');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `sequences`
--

set autocommit=0;
commit;

--
-- Dumping data for table `shunnedmessages`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `sitegroups` VALUES (1,'Growthintegral','2022-04-08 20:37:41','2022-04-08 20:37:41',NULL,'dc8d84fe-f0db-4ef0-a191-09b29840e174');
commit;

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

set autocommit=0;
INSERT INTO `sites` VALUES (1,1,1,1,'Growthintegral','default','en-US',1,'$PRIMARY_SITE_URL',1,'2022-04-08 20:37:41','2022-04-08 20:37:41',NULL,'21a1bac2-c185-44d9-94e3-4726317fc0ce');
commit;

--
-- Dumping data for table `structureelements`
--

set autocommit=0;
commit;

--
-- Dumping data for table `structures`
--

set autocommit=0;
commit;
set autocommit=0;
commit;

--
-- Dumping data for table `taggroups`
--

set autocommit=0;
commit;

--
-- Dumping data for table `tags`
--

set autocommit=0;
commit;
set autocommit=0;
commit;

--
-- Dumping data for table `usergroups`
--

set autocommit=0;
commit;

--
-- Dumping data for table `usergroups_users`
--

set autocommit=0;
commit;

--
-- Dumping data for table `userpermissions`
--

set autocommit=0;
commit;

--
-- Dumping data for table `userpermissions_usergroups`
--

set autocommit=0;
commit;

--
-- Dumping data for table `userpermissions_users`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `userpreferences` VALUES (1,'{\"language\":\"en-US\"}');
commit;
set autocommit=0;
commit;

--
-- Dumping data for table `volumefolders`
--

set autocommit=0;
commit;

--
-- Dumping data for table `volumes`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `widgets` VALUES (1,1,'craft\\widgets\\RecentEntries',1,NULL,'{\"siteId\":1,\"section\":\"*\",\"limit\":10}',1,'2022-04-08 20:37:43','2022-04-08 20:37:43','ef2d96ba-aaf4-4d53-bfd4-7867c56720e0'),(2,1,'craft\\widgets\\CraftSupport',2,NULL,'[]',1,'2022-04-08 20:37:43','2022-04-08 20:37:43','003b09c7-94dd-4d68-a188-d707eeff51e0'),(3,1,'craft\\widgets\\Updates',3,NULL,'[]',1,'2022-04-08 20:37:43','2022-04-08 20:37:43','3a93b161-858b-458f-b8ea-f0bcd6c1766a'),(4,1,'craft\\widgets\\Feed',4,NULL,'{\"url\":\"https://craftcms.com/news.rss\",\"title\":\"Craft News\",\"limit\":5}',1,'2022-04-08 20:37:43','2022-04-08 20:37:43','6e83f047-e289-40b5-9d0d-84fa964aa0b8');
commit;

--
-- Dumping routines for database 'gfh2022_CraftCMS'
--


