--
-- Host: db    Database: db
-- ------------------------------------------------------


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int NOT NULL,
  `primaryOwnerId` int DEFAULT NULL,
  `fieldId` int DEFAULT NULL,
  `countryCode` varchar(255) NOT NULL,
  `administrativeArea` varchar(255) DEFAULT NULL,
  `locality` varchar(255) DEFAULT NULL,
  `dependentLocality` varchar(255) DEFAULT NULL,
  `postalCode` varchar(255) DEFAULT NULL,
  `sortingCode` varchar(255) DEFAULT NULL,
  `addressLine1` varchar(255) DEFAULT NULL,
  `addressLine2` varchar(255) DEFAULT NULL,
  `addressLine3` varchar(255) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `organizationTaxId` varchar(255) DEFAULT NULL,
  `fullName` varchar(255) DEFAULT NULL,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_hxlixacvjyruzlepgpupilsqwbxhlwrfzzqe` (`primaryOwnerId`),
  CONSTRAINT `fk_hxlixacvjyruzlepgpupilsqwbxhlwrfzzqe` FOREIGN KEY (`primaryOwnerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_kmhbgacsuxzmhurvgqtarbfbbsevnasxwtxa` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `announcements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `pluginId` int 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,
  PRIMARY KEY (`id`),
  KEY `idx_qtzzfqmvtxjihqyyywhiwmseagwbxnfuccro` (`userId`,`unread`,`dateRead`,`dateCreated`),
  KEY `idx_jnjoakvtgqzeymezbgomrwzwiaadnqgykygd` (`dateRead`),
  KEY `fk_ckfonvlczzranrxforsbkejrtyioeylppgbp` (`pluginId`),
  CONSTRAINT `fk_bwzafwdwfflzjrgivfrxwmxusmowiomycnkp` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ckfonvlczzranrxforsbkejrtyioeylppgbp` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `assetindexingsessions`
--

CREATE TABLE `assetindexingsessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `indexedVolumes` text,
  `totalEntries` int DEFAULT NULL,
  `processedEntries` int NOT NULL DEFAULT '0',
  `cacheRemoteImages` tinyint(1) DEFAULT NULL,
  `listEmptyFolders` tinyint(1) DEFAULT '0',
  `isCli` tinyint(1) DEFAULT '0',
  `actionRequired` tinyint(1) DEFAULT '0',
  `processIfRootEmpty` tinyint(1) DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `assets` (
  `id` int NOT NULL,
  `volumeId` int DEFAULT NULL,
  `folderId` int NOT NULL,
  `uploaderId` int DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `kind` varchar(50) NOT NULL DEFAULT 'unknown',
  `alt` text,
  `width` int unsigned DEFAULT NULL,
  `height` int unsigned DEFAULT NULL,
  `size` bigint 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,
  PRIMARY KEY (`id`),
  KEY `idx_bfntkqsebjbegsskhlrtzaecdkxgqanwgwmg` (`filename`,`folderId`),
  KEY `idx_fddktckuajdkxwsllzflbhdohlbxqgsabsdw` (`folderId`),
  KEY `idx_ehxzjqqnvhrnhjojjfabiwrghfuckeqyqicl` (`volumeId`),
  KEY `fk_oqtibwjatxthssycvqalsmwtkqjmiuasdkvt` (`uploaderId`),
  CONSTRAINT `fk_oqtibwjatxthssycvqalsmwtkqjmiuasdkvt` FOREIGN KEY (`uploaderId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_prdhnwdcbytypoxgavsebmbrhgyicvgqnkpm` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_uofwlaumizxjbsizavrlwmobfcxqsilgylvj` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_utzmyseojlhmzdjjmqucacdvnmfckctwuhgi` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `assets_sites`
--

CREATE TABLE `assets_sites` (
  `assetId` int NOT NULL,
  `siteId` int NOT NULL,
  `alt` text,
  PRIMARY KEY (`assetId`,`siteId`),
  KEY `fk_oednwgmrkcyecnjkhzcnmllkavmkxxiksezx` (`siteId`),
  CONSTRAINT `fk_hvyvhpxleoaihpmznbvxqjeatxnmlqxmvpfz` FOREIGN KEY (`assetId`) REFERENCES `assets` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_oednwgmrkcyecnjkhzcnmllkavmkxxiksezx` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `categories` (
  `id` int NOT NULL,
  `groupId` int NOT NULL,
  `parentId` int DEFAULT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_wbzswmmwaxcqowqwiwsuuuxjggegtiwigsem` (`groupId`),
  KEY `fk_asuekbuwybzjanoqoalbzlzceavpnxiwnuyt` (`parentId`),
  CONSTRAINT `fk_asuekbuwybzjanoqoalbzlzceavpnxiwnuyt` FOREIGN KEY (`parentId`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_wlvexmydivckkibwvcacrcgmvffmfismfink` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_yrpgbbnphprjchtkmavgfvdombaddwaividh` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `categorygroups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `structureId` int NOT NULL,
  `fieldLayoutId` int 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',
  PRIMARY KEY (`id`),
  KEY `idx_eudjnzwheepkjfqhubexxakgfzrlqlzyadcn` (`name`),
  KEY `idx_jxblepdarxikkmvnydwcedraaagjsjjokfcy` (`handle`),
  KEY `idx_rocmuyoyypmtinrvllrddgfcstpxdvtggeec` (`structureId`),
  KEY `idx_qwpfccbnmmgfhsohouekymphlgaecrykztvk` (`fieldLayoutId`),
  KEY `idx_tsplrwpbnmvhjnokndmioxheeoyacakhlqfk` (`dateDeleted`),
  CONSTRAINT `fk_ireoysnrwwhaehkeleqrlzwcwnahbnbccghg` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ltygnztldtkxvhrehsmpfednzqzsoderyfwo` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `categorygroups_sites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupId` int NOT NULL,
  `siteId` int NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
  `uriFormat` text,
  `template` varchar(500) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_kjygluougnmorrauoldatqpwkdfkxpvfsoqw` (`groupId`,`siteId`),
  KEY `idx_xursjumlvzyxxnayoiyqevnpyunuhiwqcekh` (`siteId`),
  CONSTRAINT `fk_lijsaaqqzpdnxsuaqivdvuuihfcrylcdajzo` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_puiqdbjtaaufafykkynwpmazjfgklfhqjhzb` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `changedattributes` (
  `elementId` int NOT NULL,
  `siteId` int NOT NULL,
  `attribute` varchar(255) NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int DEFAULT NULL,
  PRIMARY KEY (`elementId`,`siteId`,`attribute`),
  KEY `idx_wbgdsffadyaqaoqsaekcmdtwqkheaoemnkhg` (`elementId`,`siteId`,`dateUpdated`),
  KEY `fk_myxejodqosjehabaajmxupjpmdvvihmmryyc` (`siteId`),
  KEY `fk_wiifozehkvjlbioucwpttmgcrijgulcehdsq` (`userId`),
  CONSTRAINT `fk_myxejodqosjehabaajmxupjpmdvvihmmryyc` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_wiifozehkvjlbioucwpttmgcrijgulcehdsq` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_xuvswtisgatavcpfuvoybimdltipzzksyjhc` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `changedfields` (
  `elementId` int NOT NULL,
  `siteId` int NOT NULL,
  `fieldId` int NOT NULL,
  `layoutElementUid` char(36) NOT NULL DEFAULT '0',
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int DEFAULT NULL,
  PRIMARY KEY (`elementId`,`siteId`,`fieldId`,`layoutElementUid`),
  KEY `idx_ohznyhgqwdohzkajypwnukrkvpkpkmpkkcee` (`elementId`,`siteId`,`dateUpdated`),
  KEY `fk_tmlmmocczphexznrlftjywxyjbelgtqouwma` (`siteId`),
  KEY `fk_qejwqozuglnvfcsedguhhxubbhgcvpbnthdj` (`fieldId`),
  KEY `fk_dqplperyvffnftrkuaqerwsrwopqrmvzwahl` (`userId`),
  CONSTRAINT `fk_bhfghpjmqsffhicnfdyfzavjoklwpwbtrrpd` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_dqplperyvffnftrkuaqerwsrwopqrmvzwahl` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_qejwqozuglnvfcsedguhhxubbhgcvpbnthdj` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_tmlmmocczphexznrlftjywxyjbelgtqouwma` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `drafts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `canonicalId` int DEFAULT NULL,
  `creatorId` int DEFAULT NULL,
  `provisional` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `notes` text,
  `trackChanges` tinyint(1) NOT NULL DEFAULT '0',
  `dateLastMerged` datetime DEFAULT NULL,
  `saved` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_vlattdulrjahphyogznclipvmsrrsrkqnqqp` (`creatorId`,`provisional`),
  KEY `idx_tigewcosarezvogokotkjpbqwmuoiovzzqqa` (`saved`),
  KEY `fk_ruojlxhqyhdbmjcdswcftsdpuljaezbjpndk` (`canonicalId`),
  CONSTRAINT `fk_qifbqpkbqvmgzchavdygvajgygeufxjjrfrv` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_ruojlxhqyhdbmjcdswcftsdpuljaezbjpndk` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `elementactivity`
--

CREATE TABLE `elementactivity` (
  `elementId` int NOT NULL,
  `userId` int NOT NULL,
  `siteId` int NOT NULL,
  `draftId` int DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `timestamp` datetime DEFAULT NULL,
  PRIMARY KEY (`elementId`,`userId`,`type`),
  KEY `idx_sopbcokblfcqtvmxreyegkaupymrbwrfunek` (`elementId`,`timestamp`,`userId`),
  KEY `fk_ujissnhnuiqvluvqlhqcrjuoevusylepjbdt` (`userId`),
  KEY `fk_xeeoivwjdaybutwauojgbojqkwbmezeeavtj` (`siteId`),
  KEY `fk_cucpeumawctkqqaqaewjvloamilhgnjpmpvu` (`draftId`),
  CONSTRAINT `fk_cucpeumawctkqqaqaewjvloamilhgnjpmpvu` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_mirzpfqkxcihbgsbfidfugoasrirbrgojedx` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ujissnhnuiqvluvqlhqcrjuoevusylepjbdt` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xeeoivwjdaybutwauojgbojqkwbmezeeavtj` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `elements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `canonicalId` int DEFAULT NULL,
  `draftId` int DEFAULT NULL,
  `revisionId` int DEFAULT NULL,
  `fieldLayoutId` int 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,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_aesoqanbbefcifcnnorwgrdiscpnyjfyhrtr` (`dateDeleted`),
  KEY `idx_hmmtidnagajewsubpctegymznqolqixrruhl` (`fieldLayoutId`),
  KEY `idx_bofretbjshkjcpvzstchqbdnkllmdstgjsqy` (`type`),
  KEY `idx_rauxxqxcwymefpgjytpprcabuddfoezxqgid` (`enabled`),
  KEY `idx_allnyirugyysgfckxawfhtrsyhnbcpzhgcsq` (`canonicalId`),
  KEY `idx_udtntnbndzxcsqyjnenollugwvqsidumzcgo` (`archived`,`dateCreated`),
  KEY `idx_qnlokfvglvdtbxyvsaigcpgkjjvworkxfzjy` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  KEY `idx_ltpbkdetdcchjveblcqszknmbswxdhltfdpy` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`,`enabled`),
  KEY `fk_sulejcaufoeehzywpvribiuidrvysqrhasxk` (`draftId`),
  KEY `fk_oivnekjkzcimqitoheofrzlhcpihbzimxkie` (`revisionId`),
  CONSTRAINT `fk_kxyiojubgyfgnuqyqbumuzezvxptarwfrqpx` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_oivnekjkzcimqitoheofrzlhcpihbzimxkie` FOREIGN KEY (`revisionId`) REFERENCES `revisions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_sulejcaufoeehzywpvribiuidrvysqrhasxk` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_xovqabnciujxyvegfbqzbfondxcrrqznfnzf` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `elements_owners`
--

CREATE TABLE `elements_owners` (
  `elementId` int NOT NULL,
  `ownerId` int NOT NULL,
  `sortOrder` smallint unsigned NOT NULL,
  PRIMARY KEY (`elementId`,`ownerId`),
  KEY `fk_zoxsondzbluaxvgtffghajdvikcynxbgmoit` (`ownerId`),
  CONSTRAINT `fk_dkuaeqjufopfrmripollmzewljazjzwdfpar` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_zoxsondzbluaxvgtffghajdvikcynxbgmoit` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `elements_sites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `elementId` int NOT NULL,
  `siteId` int NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `content` json DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_wghhubfunhwduneqigakacbxmzenvqscjxxv` (`elementId`,`siteId`),
  KEY `idx_euvnupgvgxrpzcfxwjvzfngggfcgdkjmwzjr` (`siteId`),
  KEY `idx_pbxcdvmtvwnsjswbesablspzsptewvhlgrge` (`title`,`siteId`),
  KEY `idx_dpuslvxbrscrjzlsawmiqqujwvpinndwvudr` (`slug`,`siteId`),
  KEY `idx_ntuyjiigpbockjemywwebaihifzccpzfezrt` (`enabled`),
  KEY `idx_hfyindihurwhlihifnjbkeytbyrozvwktlam` (`uri`,`siteId`),
  CONSTRAINT `fk_cxdctalqrputmxznkxsqloerhtytvgbghlhx` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_fwzogvxzlxwcwcmvnplysouvwyxclbojqaeb` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `entries` (
  `id` int NOT NULL,
  `sectionId` int DEFAULT NULL,
  `parentId` int DEFAULT NULL,
  `primaryOwnerId` int DEFAULT NULL,
  `fieldId` int DEFAULT NULL,
  `typeId` int NOT NULL,
  `postDate` datetime DEFAULT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `deletedWithEntryType` tinyint(1) DEFAULT NULL,
  `deletedWithSection` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_lajzplifqcdvzmdsajjfffhrngadsnhfjmug` (`postDate`),
  KEY `idx_johqazcvnfhzyqacluxvmsndjsxnvazzxkbl` (`expiryDate`),
  KEY `idx_uvzqvthdzvfkyrafxxrfylxhtgarffrlinxg` (`sectionId`),
  KEY `idx_zzwpldbirxsnveamkmcicbnoaozthpmyyhpt` (`typeId`),
  KEY `idx_swliildgnqmeqllarycglnrynmsbexetqdhb` (`primaryOwnerId`),
  KEY `idx_kjneihnfhetszbjgincuhvdjkknhwxqwnblf` (`fieldId`),
  KEY `fk_clyrgbxfsoprdvhpbbyplqwgxpgbgxcovzff` (`parentId`),
  CONSTRAINT `fk_clyrgbxfsoprdvhpbbyplqwgxpgbgxcovzff` FOREIGN KEY (`parentId`) REFERENCES `entries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_dybivlfcoworuiermbjqumfmtgxswuifyipf` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_jjiwnadragihvdnecpmqsyehupoaqfkhumxy` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_mwtvtumkboeovrzolsmkwbwerihgpsyemjgh` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_simmmouolkkgonnqokgdnsqilqiekkxushyu` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_tkaddjrksywubsjpmpnaxnfcxibrzotvktwf` FOREIGN KEY (`primaryOwnerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `entries_authors`
--

CREATE TABLE `entries_authors` (
  `entryId` int NOT NULL,
  `authorId` int NOT NULL,
  `sortOrder` smallint unsigned NOT NULL,
  PRIMARY KEY (`entryId`,`authorId`),
  KEY `idx_ipfuszvhqotpvoxavkhndmmuhbjbvbcgftnb` (`authorId`),
  KEY `idx_rnglbucbbjkmctjsznestwugiugvbwtzppwu` (`entryId`,`sortOrder`),
  CONSTRAINT `fk_hojnflilkhudpqswwizepxksvdgpuojgalyp` FOREIGN KEY (`entryId`) REFERENCES `entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_jexnxxewyfmpopqebwlewdmhwiqiklgnqhip` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `entrytypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `hasTitleField` tinyint(1) NOT NULL DEFAULT '1',
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text,
  `titleFormat` varchar(255) DEFAULT NULL,
  `showSlugField` tinyint(1) DEFAULT '1',
  `slugTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `slugTranslationKeyFormat` text,
  `showStatusField` tinyint(1) DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_bbgktfaqfyawaqfdseymkafygvhsfterzusw` (`fieldLayoutId`),
  KEY `idx_kpbiqjyikvkbdbfhxwneidgzefrywnxgzqbs` (`dateDeleted`),
  CONSTRAINT `fk_tkoudeytenfilojybkhyonvxpyzhysimguul` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `fieldlayouts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `config` json DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_yvukaxfmpvaagtzisoljyhrxdcvqiiycjwor` (`dateDeleted`),
  KEY `idx_ssamtsksnlkalxgltzcjcdvfnfvyojhntpku` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `fields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `handle` varchar(64) NOT NULL,
  `context` varchar(255) NOT NULL DEFAULT 'global',
  `columnSuffix` char(8) DEFAULT NULL,
  `instructions` text,
  `searchable` tinyint(1) NOT NULL DEFAULT '1',
  `translationMethod` varchar(255) NOT NULL DEFAULT 'none',
  `translationKeyFormat` text,
  `type` varchar(255) NOT NULL,
  `settings` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_dwhutpdpucoglrknuzrlekkbiqguilyvjskg` (`handle`,`context`),
  KEY `idx_hielurbvlynwbdxxzirambqqshlyxdttrixe` (`context`),
  KEY `idx_okktretnnpcpqvzgumjwfucwjvzrvyffyjzl` (`dateDeleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `globalsets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int DEFAULT NULL,
  `sortOrder` smallint unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_wvsebgcgpwxmrbtqdsztfjuecomjynfgykaz` (`name`),
  KEY `idx_iwgfqdueylxwgpizymyvgzwkahwxvhpbyfor` (`handle`),
  KEY `idx_vlwinvofyjdkegmnwjpertstzskriuwyheto` (`fieldLayoutId`),
  KEY `idx_ewqywpjiinkgaevnqemnecjuynlcooqkgkyt` (`sortOrder`),
  CONSTRAINT `fk_fzndcasrbrivovuggdmghjkmqdkakcjpikqn` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_gbgaoodbcbuehkdlyffjzrnlodmffizmlhnw` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

--
-- Table structure for table `imagetransformindex`
--

CREATE TABLE `imagetransformindex` (
  `id` int NOT NULL AUTO_INCREMENT,
  `assetId` int NOT NULL,
  `transformer` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `transformString` varchar(255) NOT 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',
  PRIMARY KEY (`id`),
  KEY `idx_nbzxciwsosuxzgegnmfgrxoutyalrejunrtw` (`assetId`,`transformString`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `imagetransforms`
--

CREATE TABLE `imagetransforms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `mode` enum('stretch','fit','crop','letterbox') 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 unsigned DEFAULT NULL,
  `height` int unsigned DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `quality` int DEFAULT NULL,
  `interlace` enum('none','line','plane','partition') NOT NULL DEFAULT 'none',
  `fill` varchar(11) DEFAULT NULL,
  `upscale` tinyint(1) NOT NULL DEFAULT '1',
  `parameterChangeTime` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_vogexoxvfjacvqgmusiyedljglscxlcshple` (`name`),
  KEY `idx_nvznjfqfvprpshvvbzctjeasgtssgrbmtbvu` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `migrations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_uatdwkwqcwsoaoyzyucozoxaxbvcnhtewuya` (`track`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `plugins` (
  `id` int NOT NULL AUTO_INCREMENT,
  `handle` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL,
  `schemaVersion` varchar(255) NOT NULL,
  `installDate` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_syrtgyzfvhqebgaicjqjapaelrkpymzeqfim` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `queue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `channel` varchar(255) NOT NULL DEFAULT 'queue',
  `job` longblob NOT NULL,
  `description` text,
  `timePushed` int NOT NULL,
  `ttr` int NOT NULL,
  `delay` int NOT NULL DEFAULT '0',
  `priority` int unsigned NOT NULL DEFAULT '1024',
  `dateReserved` datetime DEFAULT NULL,
  `timeUpdated` int DEFAULT NULL,
  `progress` smallint NOT NULL DEFAULT '0',
  `progressLabel` varchar(255) DEFAULT NULL,
  `attempt` int DEFAULT NULL,
  `fail` tinyint(1) DEFAULT '0',
  `dateFailed` datetime DEFAULT NULL,
  `error` text,
  PRIMARY KEY (`id`),
  KEY `idx_neaduqtklyxesiretuezpwsqqsoiydtbntsd` (`channel`,`fail`,`timeUpdated`,`timePushed`),
  KEY `idx_wkqrqkwwaxhtrhkllfulxtvuqsjstfnuxyvx` (`channel`,`fail`,`timeUpdated`,`delay`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `relations` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldId` int NOT NULL,
  `sourceId` int NOT NULL,
  `sourceSiteId` int DEFAULT NULL,
  `targetId` int NOT NULL,
  `sortOrder` smallint unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ioonaafcwjbwkedrdzyafywggxxwgyytykla` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  KEY `idx_tsywlvhwaftbueskoljgsaezlbnmoyjenurj` (`sourceId`),
  KEY `idx_uxoangmpyuovwucruczooaudrojoovkpaqtu` (`targetId`),
  KEY `idx_bvhuuusdsusixzhutrflkxbczsmogmtpshpx` (`sourceSiteId`),
  CONSTRAINT `fk_emjciircrmvhvqkwhjjofszrjwfqwkozlwvs` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_eowkqyujvekwtaygnoojwtnmggwaqrmzxvvx` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_oqhoalgnfuoehcnmegkoepjngmrirebhjpdp` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `revisions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `canonicalId` int NOT NULL,
  `creatorId` int DEFAULT NULL,
  `num` int NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ktkdhfhdfvitbffgcyzaeyepakjsaonyqvng` (`canonicalId`,`num`),
  KEY `fk_rnsdidfpltcxgustdcmfhzplucwiokbzpzqs` (`creatorId`),
  CONSTRAINT `fk_phdulpclpjhkrpnyvkiljahxdsoibwvutswm` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_rnsdidfpltcxgustdcmfhzplucwiokbzpzqs` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `searchindex` (
  `elementId` int NOT NULL,
  `attribute` varchar(25) NOT NULL,
  `fieldId` int NOT NULL,
  `siteId` int NOT NULL,
  `keywords` text NOT NULL,
  PRIMARY KEY (`elementId`,`attribute`,`fieldId`,`siteId`),
  FULLTEXT KEY `idx_nrhcpwqkqtpvtinagoachyexygpxhbsbmfbo` (`keywords`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `sections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `structureId` int 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',
  `maxAuthors` smallint unsigned NOT NULL DEFAULT '1',
  `propagationMethod` varchar(255) NOT NULL DEFAULT 'all',
  `defaultPlacement` enum('beginning','end') NOT NULL DEFAULT 'end',
  `previewTargets` json DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_santywtzwclwutwxfrlesxeglrxsselmzyfb` (`handle`),
  KEY `idx_ktbncmptvjfegxymlyrqswsfqeygesdipmsq` (`name`),
  KEY `idx_zcsxibfwkouagvgqyyneahylwarctsfmtqoy` (`structureId`),
  KEY `idx_ohivvdobrlepojoykdclhoxkpeqazdjpfxrv` (`dateDeleted`),
  CONSTRAINT `fk_fehtlhuokxxtkguaehilfmeidctyevjhidfu` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `sections_entrytypes`
--

CREATE TABLE `sections_entrytypes` (
  `sectionId` int NOT NULL,
  `typeId` int NOT NULL,
  `sortOrder` smallint unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `handle` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sectionId`,`typeId`),
  KEY `fk_uxhreyhndluniizpjkwyycuqwtejfvvpxthm` (`typeId`),
  CONSTRAINT `fk_tvyuxyhojtdgoicvfhtrfwgplwyptucdhgko` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_uxhreyhndluniizpjkwyycuqwtejfvvpxthm` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `sections_sites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sectionId` int NOT NULL,
  `siteId` int NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
  `uriFormat` text,
  `template` varchar(500) DEFAULT NULL,
  `enabledByDefault` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_jcwflfatujthvsakvrjwfziwsfiwwzxippmp` (`sectionId`,`siteId`),
  KEY `idx_byxgabtsxxssrdazowjjrlzxfcfjddezniby` (`siteId`),
  CONSTRAINT `fk_dpgeolbnwouwsqzjacqgubpapdpzpolzjggy` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_sbactlejgwugjuyywksyupnhzgljbktlgxqb` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

CREATE TABLE `sites` (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupId` int NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `enabled` varchar(255) NOT NULL DEFAULT 'true',
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `language` varchar(255) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '0',
  `baseUrl` varchar(255) DEFAULT NULL,
  `sortOrder` smallint unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_psxhxyltxdrulernyipwgeuismsgxzpdwcqm` (`dateDeleted`),
  KEY `idx_kqfhclngecucugbyazxvwnkmxpzkprteoeqs` (`handle`),
  KEY `idx_cwcrmwiynhqpghjutedyzwmnlqoeuedzdswu` (`sortOrder`),
  KEY `fk_vsbbremqmnzsvtglbqacksipwmqibaqydkng` (`groupId`),
  CONSTRAINT `fk_vsbbremqmnzsvtglbqacksipwmqibaqydkng` FOREIGN KEY (`groupId`) REFERENCES `sitegroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Table structure for table `sso_identities`
--

CREATE TABLE `sso_identities` (
  `provider` varchar(255) NOT NULL,
  `identityId` varchar(255) NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`provider`,`identityId`,`userId`),
  KEY `fk_xtztoyuzcgslwbkppvevxycqaoqurwzpxwqf` (`userId`),
  CONSTRAINT `fk_xtztoyuzcgslwbkppvevxycqaoqurwzpxwqf` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `structureelements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `structureId` int NOT NULL,
  `elementId` int DEFAULT NULL,
  `root` int unsigned DEFAULT NULL,
  `lft` int unsigned NOT NULL,
  `rgt` int unsigned NOT NULL,
  `level` smallint unsigned NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_vhfdunhchclmtqacsvrlpicegqtitldjusrc` (`structureId`,`elementId`),
  KEY `idx_yvrgkawnbxovgqgahdkhsdzfvmirsmzrhvus` (`root`),
  KEY `idx_ixhiksjsvwycxoocpftikusjzqhtzjtdfvoe` (`lft`),
  KEY `idx_pqftvjbdoqcjcyyxyvrulskhnvjsumvgojef` (`rgt`),
  KEY `idx_kahznocgfkgbxjbnxpdsvpwdsdvvgpaeburf` (`level`),
  KEY `idx_tzceolcvuiflyhiqzlifkhhunyrwwqwafbws` (`elementId`),
  CONSTRAINT `fk_qjnkjewmntziqsztqioreymelrshhbwmrwoz` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `taggroups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_ujbxohgleonlvlacbntpdzdlckheivxexonn` (`name`),
  KEY `idx_tzzeibgczbqcvhqmoxnfvaycuautnttbogwv` (`handle`),
  KEY `idx_ikizdcqisdqkyzdqvuejilnfnrsmregcknmw` (`dateDeleted`),
  KEY `fk_igeliqaqzixifkzanmpjeewzraqvpadybitf` (`fieldLayoutId`),
  CONSTRAINT `fk_igeliqaqzixifkzanmpjeewzraqvpadybitf` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `tags` (
  `id` int NOT NULL,
  `groupId` int NOT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_oaaafautawnbieifkbujbiswjdiazqvxaghw` (`groupId`),
  CONSTRAINT `fk_bxbhmudvofhseyblvbxedcyynbwdvmlwwlfl` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_kwvebdaazjuquaoivuxsdwvyrfhmkwxsnxqb` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `usergroups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `description` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_amqpienrbnggflujhzlgvyiixaxeelpubqvu` (`handle`),
  KEY `idx_qdqhhmcdvtjehdvlnpivjfymjegknfwzhbll` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `usergroups_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `groupId` int NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_cahcolmcxnmrfclwwqzfzotlodsaznlmqoxe` (`groupId`,`userId`),
  KEY `idx_nilumxqendxkpelvrnjxlxpuxojpzmehejze` (`userId`),
  CONSTRAINT `fk_bspcrleuuevnlzikowmagvssboqohzvglwmb` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pjifedjgvkkvvvjglmzqnwfwlquhpptqsgjq` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `userpermissions_usergroups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `permissionId` int NOT NULL,
  `groupId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_qtbawmrxepvtprnwecylydqfliqhhjpqbgti` (`permissionId`,`groupId`),
  KEY `idx_mktvrjikqblreszuuutewwjqxcwtesauhfsd` (`groupId`),
  CONSTRAINT `fk_ylfsbdndptugetlznypbrvlkdtqfnuolrnfm` FOREIGN KEY (`groupId`) REFERENCES `usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_yptyquispgnuifqbwrltytixcubuianofhfx` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `userpermissions_users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `permissionId` int NOT NULL,
  `userId` int NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_dtekpbjwhypvxukwpzezqsrnzrxjtmczhhis` (`permissionId`,`userId`),
  KEY `idx_fxzrzsisdujjanzovlexnukzpijdkozkcxkm` (`userId`),
  CONSTRAINT `fk_tokpqluokcnfnvtlnmyxeyndwigdurwoxiyw` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_yxrxwipdajmikbkaxknrnnmfxhuukzhfmyvx` FOREIGN KEY (`permissionId`) REFERENCES `userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `userpreferences` (
  `userId` int NOT NULL AUTO_INCREMENT,
  `preferences` json DEFAULT NULL,
  PRIMARY KEY (`userId`),
  CONSTRAINT `fk_bedfapxorkywfrbqixugztftodyhdrjkasxn` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `volumefolders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parentId` int DEFAULT NULL,
  `volumeId` int DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ahdixsfuzmltpldpofylykaukfuyrohuvwmf` (`name`,`parentId`,`volumeId`),
  KEY `idx_neayeorogyhwdscagghoetpcwzurdketwrxe` (`parentId`),
  KEY `idx_zdmihbbrsfejqfxthypizccbnqnqkotdqkmq` (`volumeId`),
  CONSTRAINT `fk_gonjdlzhpqkfemgwwjxzxbswizeisakhvdud` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_qbhnpwwyfsyspszjiwiwcqjfvihjgztarlzi` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `volumes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fs` varchar(255) NOT NULL,
  `subpath` varchar(255) DEFAULT NULL,
  `transformFs` varchar(255) DEFAULT NULL,
  `transformSubpath` varchar(255) DEFAULT NULL,
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text,
  `altTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `altTranslationKeyFormat` text,
  `sortOrder` smallint unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_cjokbimtpopdbujxjiavcupwsepiknjoztqk` (`name`),
  KEY `idx_lebrramrkbbgkpifnguovyrrvenjmsbeysti` (`handle`),
  KEY `idx_mcwuzzgljlpehqmvljdzvxirywkaucjtprki` (`fieldLayoutId`),
  KEY `idx_obrlafjzoenscuyehiyksvcygnhcyfhdlrkb` (`dateDeleted`),
  CONSTRAINT `fk_gryonbzknffqyguxqbpqxuljrhvikhlgzfdh` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

CREATE TABLE `widgets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `type` varchar(255) NOT NULL,
  `sortOrder` smallint unsigned DEFAULT NULL,
  `colspan` tinyint DEFAULT NULL,
  `settings` json DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_zwfngpgbqbadeunolszlranvshvjukmztpui` (`userId`),
  CONSTRAINT `fk_yzuqdmxxyiyccrvdcxkjbdyhnaxafujcauxl` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping routines for database 'db'
--


--
-- Host: db    Database: db
-- ------------------------------------------------------


--
-- Dumping data for table `addresses`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `assetindexingsessions`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `assets_sites`
--

set autocommit=0;
commit;
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;
set autocommit=0;
commit;
set autocommit=0;
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `elementactivity`
--

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,'2025-06-12 14:48:54','2025-06-12 14:48:54',NULL,NULL,NULL,'7fa82464-ec30-4f6b-9339-f4135a393b9d');
commit;
set autocommit=0;
commit;

--
-- Dumping data for table `elements_owners`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `elements_sites` VALUES (1,1,1,NULL,NULL,NULL,NULL,1,'2025-06-12 14:48:54','2025-06-12 14:48:54','ce22484a-c77d-4e70-a8f0-2b208ee0a9d1');
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `entries_authors`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

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 `imagetransforms`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `info` VALUES (1,'5.6.10.1','5.6.0.2',1,'pczjehxwwvxm','3@tmaamjdzpd','2025-06-12 14:48:54','2025-06-12 14:51:10','b42de2b2-edec-4cf2-b50b-806934e82c4c');
commit;

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

set autocommit=0;
INSERT INTO `migrations` VALUES (1,'craft','Install','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','de5e5a99-e123-4e8a-9c0f-ed977ec1952c'),(2,'craft','m221101_115859_create_entries_authors_table','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','b87aff03-a130-4613-9e87-897378161781'),(3,'craft','m221107_112121_add_max_authors_to_sections','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','da3efa1f-e3f3-4ce5-ab8b-419c935f9157'),(4,'craft','m221205_082005_translatable_asset_alt_text','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','964f2938-e58c-493f-9ba7-aa6c3d330447'),(5,'craft','m230314_110309_add_authenticator_table','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','24ee9034-c61e-4a53-9bda-94f2b106c291'),(6,'craft','m230314_111234_add_webauthn_table','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','15fc0534-2b18-4929-b32a-233b39510013'),(7,'craft','m230503_120303_add_recoverycodes_table','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','3979d339-2c60-418c-a1cc-d7ed8d3cf6a4'),(8,'craft','m230511_000000_field_layout_configs','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','73d95a22-8767-4da6-a17e-42467b0fe839'),(9,'craft','m230511_215903_content_refactor','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','45e144d2-c63a-4481-9e04-d0ef79d989f8'),(10,'craft','m230524_000000_add_entry_type_show_slug_field','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','cdb22294-9d42-41a0-824e-66ce1c1a8487'),(11,'craft','m230524_000001_entry_type_icons','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','0da5f4ee-6377-4427-ba61-3110bb2dd86f'),(12,'craft','m230524_000002_entry_type_colors','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','836031ce-6912-43bc-a558-eb48fe566461'),(13,'craft','m230524_220029_global_entry_types','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','885f2ecd-d52e-4ad6-adcb-851a39258830'),(14,'craft','m230531_123004_add_entry_type_show_status_field','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','488ada06-a456-4a81-8c87-57c92a6dde1a'),(15,'craft','m230607_102049_add_entrytype_slug_translation_columns','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','74b87220-ba24-4ca1-8978-d472c6ea26d3'),(16,'craft','m230616_173810_kill_field_groups','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','b47b6e86-261d-4224-9188-108c6c58debb'),(17,'craft','m230616_183820_remove_field_name_limit','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','ed94a18d-3014-4d13-8a88-efe848214c9d'),(18,'craft','m230617_070415_entrify_matrix_blocks','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','d92ed310-61d2-43b7-a165-a9343da0ab30'),(19,'craft','m230710_162700_element_activity','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','75a90a7b-34cb-4e75-b370-431d0069a9d7'),(20,'craft','m230820_162023_fix_cache_id_type','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','a4135dd9-5315-4707-bd4c-fd59b1b5fd30'),(21,'craft','m230826_094050_fix_session_id_type','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','31bb85af-5cac-4196-acd0-da34798d21c2'),(22,'craft','m230904_190356_address_fields','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','ab6dfc7d-a97f-4fc3-841f-55d7d327bcac'),(23,'craft','m230928_144045_add_subpath_to_volumes','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','9580cca6-3529-403c-a0b2-2541a45dec20'),(24,'craft','m231013_185640_changedfields_amend_primary_key','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','1000d17e-7305-49bd-bb02-3228459235e7'),(25,'craft','m231213_030600_element_bulk_ops','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','f8d4c4cd-b250-4387-b751-10a68b7f04b6'),(26,'craft','m240129_150719_sites_language_amend_length','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','058ad819-13c0-4f3f-92c7-65b70f8fd7ba'),(27,'craft','m240206_035135_convert_json_columns','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','bfb1e13d-cb91-49b4-b6a1-260ae8403890'),(28,'craft','m240207_182452_address_line_3','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','1d8f552e-7ff8-4f05-8d63-4040770ecc8f'),(29,'craft','m240302_212719_solo_preview_targets','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','f598a282-351c-4113-a6a9-a350245bd3a9'),(30,'craft','m240619_091352_add_auth_2fa_timestamp','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','abfbd24d-b7da-4666-af9f-93ac21985355'),(31,'craft','m240723_214330_drop_bulkop_fk','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','873cb7c9-8c4d-47fc-92df-5cb2ec2b310b'),(32,'craft','m240731_053543_soft_delete_fields','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','e0db473b-db87-4fe5-9805-da6a0e779ac1'),(33,'craft','m240805_154041_sso_identities','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','d69b95b2-d95c-4201-a672-984713b358f6'),(34,'craft','m240926_202248_track_entries_deleted_with_section','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','df97f941-7424-4470-abce-e9825b6d422e'),(35,'craft','m241120_190905_user_affiliated_sites','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','fd2a9066-8fe0-46b9-9800-3fd840f44238'),(36,'craft','m241125_122914_add_viewUsers_permission','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','1d430207-0a0f-4dc1-99bf-86edaac224ce'),(37,'craft','m250119_135304_entry_type_overrides','2025-06-12 14:48:55','2025-06-12 14:48:55','2025-06-12 14:48:55','f5fbff35-019b-4f7d-af24-05d7597ae9b4');
commit;

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

set autocommit=0;
INSERT INTO `plugins` VALUES (1,'vite','5.0.1','1.0.0','2025-06-12 14:48:54','2025-06-12 14:48:54','2025-06-12 14:48:54','40f5fa47-de56-4f2e-8aa1-f87230b56d03');
commit;

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

set autocommit=0;
INSERT INTO `projectconfig` VALUES ('dateModified','1749739807'),('email.fromEmail','\"ryan@craftquest.io\"'),('email.fromName','\"Craft CMS Vite Tailwind\"'),('email.transportType','\"craft\\\\mail\\\\transportadapters\\\\Sendmail\"'),('meta.__names__.45a00e92-2550-47ce-b789-33064e5da296','\"Melina Luise\"'),('meta.__names__.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e','\"Melina Luise\"'),('plugins.vite.edition','\"standard\"'),('plugins.vite.enabled','true'),('plugins.vite.schemaVersion','\"1.0.0\"'),('siteGroups.45a00e92-2550-47ce-b789-33064e5da296.name','\"Melina Luise\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.baseUrl','\"$PRIMARY_SITE_URL\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.enabled','true'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.handle','\"default\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.hasUrls','true'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.language','\"en-US\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.name','\"Melina Luise\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.primary','true'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.siteGroup','\"45a00e92-2550-47ce-b789-33064e5da296\"'),('sites.88a82adb-74b9-4d14-b4bf-8e9a26d20d3e.sortOrder','1'),('system.edition','\"solo\"'),('system.live','true'),('system.name','\"Melina Luise\"'),('system.retryDuration','null'),('system.schemaVersion','\"5.6.0.2\"'),('system.timeZone','\"America/Los_Angeles\"'),('users.allowPublicRegistration','false'),('users.defaultGroup','null'),('users.photoSubpath','null'),('users.photoVolumeUid','null'),('users.require2fa','false'),('users.requireEmailVerification','true');
commit;

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

set autocommit=0;
commit;
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,'email',0,1,' melinaluise95 gmail com '),(1,'firstname',0,1,''),(1,'fullname',0,1,''),(1,'lastname',0,1,''),(1,'slug',0,1,''),(1,'username',0,1,' admin ');
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `sections_entrytypes`
--

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,'Melina Luise','2025-06-12 14:48:54','2025-06-12 14:50:07',NULL,'45a00e92-2550-47ce-b789-33064e5da296');
commit;

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

set autocommit=0;
INSERT INTO `sites` VALUES (1,1,1,'1','Melina Luise','default','en-US',1,'$PRIMARY_SITE_URL',1,'2025-06-12 14:48:54','2025-06-12 14:48:54',NULL,'88a82adb-74b9-4d14-b4bf-8e9a26d20d3e');
commit;

--
-- Dumping data for table `sso_identities`
--

set autocommit=0;
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;
set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `widgets` VALUES (1,1,'craft\\widgets\\RecentEntries',1,NULL,'{\"limit\": 10, \"siteId\": 1, \"section\": \"*\"}',1,'2025-06-12 14:49:39','2025-06-12 14:49:39','eea35fa5-3267-4084-ac0d-a4012a8b5ac7'),(2,1,'craft\\widgets\\CraftSupport',2,NULL,'[]',1,'2025-06-12 14:49:39','2025-06-12 14:49:39','a3082f47-ddca-4aed-9624-675db5cb151b'),(3,1,'craft\\widgets\\Updates',3,NULL,'[]',1,'2025-06-12 14:49:39','2025-06-12 14:49:39','456aa293-a0cf-4ab6-80a3-66eac764aa52'),(4,1,'craft\\widgets\\Feed',4,NULL,'{\"url\": \"https://craftcms.com/news.rss\", \"limit\": 5, \"title\": \"Craft News\"}',1,'2025-06-12 14:49:39','2025-06-12 14:49:39','47b700bf-4740-4769-ae70-7d043e480070');
commit;

--
-- Dumping routines for database 'db'
--


