--
-- Host: localhost    Database: mscraftstagingth_db
-- ------------------------------------------------------


--
-- Table structure for table `craft_announcements`
--

CREATE TABLE `craft_announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `pluginId` int(11) DEFAULT NULL,
  `heading` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `unread` tinyint(1) NOT NULL DEFAULT '1',
  `dateRead` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `craft_idx_wppscetwzedgvufsvnuitxqjvklohyxqcwje` (`userId`,`unread`,`dateRead`,`dateCreated`),
  KEY `craft_idx_ezmrhssnjyfgdjmmvjuwmtmnzfkrliodsydq` (`dateRead`),
  KEY `craft_fk_fbwautpifecnjjworewaegyeyjshhrgsdmrj` (`pluginId`),
  CONSTRAINT `craft_fk_fbwautpifecnjjworewaegyeyjshhrgsdmrj` FOREIGN KEY (`pluginId`) REFERENCES `craft_plugins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_zrqbxclidvikxwkzxhbcpsgapzcvvokxmaoy` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_assetindexdata`
--

CREATE TABLE `craft_assetindexdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sessionId` varchar(36) NOT NULL DEFAULT '',
  `volumeId` int(11) NOT NULL,
  `uri` text,
  `size` bigint(20) unsigned DEFAULT NULL,
  `timestamp` datetime DEFAULT NULL,
  `recordId` int(11) DEFAULT NULL,
  `inProgress` tinyint(1) DEFAULT '0',
  `completed` tinyint(1) DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_assetindexdata_sessionId_volumeId_idx` (`sessionId`,`volumeId`),
  KEY `craft_assetindexdata_volumeId_idx` (`volumeId`),
  CONSTRAINT `craft_assetindexdata_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_assets`
--

CREATE TABLE `craft_assets` (
  `id` int(11) NOT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `folderId` int(11) NOT NULL,
  `uploaderId` int(11) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `kind` varchar(50) NOT NULL DEFAULT 'unknown',
  `width` int(10) unsigned DEFAULT NULL,
  `height` int(10) unsigned DEFAULT NULL,
  `size` bigint(20) unsigned DEFAULT NULL,
  `focalPoint` varchar(13) DEFAULT NULL,
  `deletedWithVolume` tinyint(1) DEFAULT NULL,
  `keptFile` tinyint(1) DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_assets_folderId_idx` (`folderId`),
  KEY `craft_assets_volumeId_idx` (`volumeId`),
  KEY `craft_assets_volumeId_keptFile_idx` (`volumeId`,`keptFile`),
  KEY `craft_assets_uploaderId_fk` (`uploaderId`),
  CONSTRAINT `craft_assets_folderId_fk` FOREIGN KEY (`folderId`) REFERENCES `craft_volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_assets_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_assets_uploaderId_fk` FOREIGN KEY (`uploaderId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_assets_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_assettransformindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assetId` int(11) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `location` varchar(255) NOT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `fileExists` tinyint(1) NOT NULL DEFAULT '0',
  `inProgress` tinyint(1) NOT NULL DEFAULT '0',
  `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 `craft_assettransformindex_volumeId_assetId_location_idx` (`volumeId`,`assetId`,`location`),
  KEY `craft_idx_akiqifrevbeaxqgjduiaeybaplauvqwzpfnq` (`assetId`,`format`,`location`)
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_assettransforms`
--

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

--
-- Table structure for table `craft_blitz_recommendations`
--

CREATE TABLE `craft_blitz_recommendations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `template` varchar(255) DEFAULT NULL,
  `message` text,
  `info` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_hgxtkxpicugwjkqncvfpwmhpuzxbqcgvaetj` (`key`,`template`)
) ENGINE=InnoDB AUTO_INCREMENT=45089 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_categories`
--

CREATE TABLE `craft_categories` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_categories_groupId_idx` (`groupId`),
  KEY `craft_categories_parentId_fk` (`parentId`),
  CONSTRAINT `craft_categories_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_categories_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_categories_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_categorygroups`
--

CREATE TABLE `craft_categorygroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) 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 `craft_categorygroups_structureId_idx` (`structureId`),
  KEY `craft_categorygroups_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_categorygroups_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_categorygroups_name_idx` (`name`),
  KEY `craft_categorygroups_handle_idx` (`handle`),
  CONSTRAINT `craft_categorygroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_categorygroups_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_categorygroups_sites`
--

CREATE TABLE `craft_categorygroups_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
  `uriFormat` text,
  `template` varchar(500) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_categorygroups_sites_groupId_siteId_unq_idx` (`groupId`,`siteId`),
  KEY `craft_categorygroups_sites_siteId_idx` (`siteId`),
  CONSTRAINT `craft_categorygroups_sites_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_categorygroups_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_changedattributes`
--

CREATE TABLE `craft_changedattributes` (
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `attribute` varchar(255) NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int(11) DEFAULT NULL,
  PRIMARY KEY (`elementId`,`siteId`,`attribute`),
  KEY `craft_changedattributes_elementId_siteId_dateUpdated_idx` (`elementId`,`siteId`,`dateUpdated`),
  KEY `craft_changedattributes_siteId_fk` (`siteId`),
  KEY `craft_changedattributes_userId_fk` (`userId`),
  CONSTRAINT `craft_changedattributes_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_changedattributes_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_changedattributes_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_changedfields`
--

CREATE TABLE `craft_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 `craft_changedfields_elementId_siteId_dateUpdated_idx` (`elementId`,`siteId`,`dateUpdated`),
  KEY `craft_changedfields_siteId_fk` (`siteId`),
  KEY `craft_changedfields_fieldId_fk` (`fieldId`),
  KEY `craft_changedfields_userId_fk` (`userId`),
  CONSTRAINT `craft_changedfields_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_changedfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_changedfields_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_changedfields_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_content`
--

CREATE TABLE `craft_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_suburb` text,
  `field_postcode` text,
  `field_city` varchar(200) DEFAULT NULL,
  `field_phoneNumber` text,
  `field_faxNumber` text,
  `field_assetsCaption` text,
  `field_peopleFirstName` text,
  `field_peopleLastName` text,
  `field_peopleTitle` text,
  `field_peoplePhoneNumber` text,
  `field_peopleMobileNumber` text,
  `field_peoplePosition` text,
  `field_peopleEmailAddress` varchar(255) DEFAULT NULL,
  `field_geolocation` text,
  `field_summary` varchar(1024) DEFAULT NULL,
  `field_peopleShortBiography` text,
  `field_businessDescription` varchar(2048) DEFAULT NULL,
  `field_facebookUsername` text,
  `field_fullBusinessName` text,
  `field_instagramUsername` text,
  `field_linkedinPage` text,
  `field_twitterHandle` text,
  `field_altText` text,
  `field_emailAddress` varchar(255) DEFAULT NULL,
  `field_tagline` varchar(192) DEFAULT NULL,
  `field_seo` text,
  `field_youtubeChannel` text,
  `field_description_pcuyqdkd` text,
  `field_richText_edmjjyyg` text,
  `field_pageTitle_egpwvxpp` text,
  `field_heading_iparvvyb` text,
  `field_addressLineOne_hdybypzq` text,
  `field_addressLineTwo_hgufeome` text,
  `field_country_hduyprrn` text,
  `field_valuesArticleTitle_wtwojsbg` text,
  `field_valuesArticleText_zppzxgxa` text,
  `field_subheading_iyjklhgr` text,
  `field_paragraph_izscucyg` text,
  `field_bathrooms_awcprhxs` int(11) DEFAULT NULL,
  `field_bedrooms_vhshiiul` int(11) DEFAULT NULL,
  `field_livingRooms_jnbesymf` int(11) DEFAULT NULL,
  `field_garage_ntjjacfr` int(11) DEFAULT NULL,
  `field_dining_eawfrnnj` int(11) DEFAULT NULL,
  `field_propertySize_wystfguj` int(11) DEFAULT NULL,
  `field_customerQuote_pypscznh` text,
  `field_faqHeading_ocyyhpfr` text,
  `field_buildTitle_lfbyszts` text,
  `field_typology_tftjlgbg` text,
  `field_buildDescription_zjgmcecf` text,
  `field_floorPlanTitle_yvtemqme` text,
  `field_articleTitle_lefsvhbp` text,
  `field_sectionTitle_inxvsztb` text,
  `field_articleText_icwjpltf` text,
  `field_buildsArticleTitle_yovxlakw` text,
  `field_buildsArticleText_urtqpsem` text,
  `field_articleBody_jnzvmrws` text,
  `field_catalogueSectionHeading_cwzzkrse` text,
  `field_catalogueSectionText_opavislr` text,
  `field_contactBannerHeading_jruiqcgi` text,
  `field_contactBannerText_szeklmbv` text,
  `field_totalArea_dqlnuyrm` int(11) DEFAULT NULL,
  `field_categoryDisplay_qlvkblor` varchar(255) DEFAULT NULL,
  `field_footerText_gqrkdkhu` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_content_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_content_siteId_idx` (`siteId`),
  KEY `craft_content_title_idx` (`title`),
  CONSTRAINT `craft_content_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_content_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=615 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_craftidtokens`
--

CREATE TABLE `craft_craftidtokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `accessToken` text NOT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_craftidtokens_userId_fk` (`userId`),
  CONSTRAINT `craft_craftidtokens_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_deprecationerrors`
--

CREATE TABLE `craft_deprecationerrors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `fingerprint` varchar(255) NOT NULL,
  `lastOccurrence` datetime NOT NULL,
  `file` varchar(255) NOT NULL,
  `line` smallint(5) unsigned DEFAULT NULL,
  `message` text,
  `traces` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_deprecationerrors_key_fingerprint_unq_idx` (`key`,`fingerprint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_drafts`
--

CREATE TABLE `craft_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) 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 `craft_drafts_sourceId_fk` (`sourceId`),
  KEY `craft_drafts_creatorId_fk` (`creatorId`),
  KEY `craft_idx_oeemnefwiqnjawayqxbcjelnegvrakryyojs` (`saved`),
  KEY `craft_idx_khhrvutivmvknaewxrilapeljsaybeydkoqv` (`creatorId`,`provisional`),
  CONSTRAINT `craft_drafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_drafts_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_elementindexsettings`
--

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

--
-- Table structure for table `craft_elements`
--

CREATE TABLE `craft_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) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `archived` tinyint(1) NOT NULL DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateLastMerged` datetime DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_elements_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_elements_type_idx` (`type`),
  KEY `craft_elements_enabled_idx` (`enabled`),
  KEY `craft_elements_archived_dateCreated_idx` (`archived`,`dateCreated`),
  KEY `craft_elements_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_elements_draftId_fk` (`draftId`),
  KEY `craft_elements_revisionId_fk` (`revisionId`),
  KEY `craft_fk_vqdbsewwkmyxrvxfecjbkdzqlmwipdcwzjca` (`canonicalId`),
  KEY `craft_idx_llbenkseycyccplfroxxftbdsswcbqamidln` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  KEY `craft_idx_icfjciutaoyszuhupavacyvzezgskxeeyqml` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`,`enabled`),
  CONSTRAINT `craft_elements_draftId_fk` FOREIGN KEY (`draftId`) REFERENCES `craft_drafts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_elements_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_elements_revisionId_fk` FOREIGN KEY (`revisionId`) REFERENCES `craft_revisions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_vqdbsewwkmyxrvxfecjbkdzqlmwipdcwzjca` FOREIGN KEY (`canonicalId`) REFERENCES `craft_elements` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2637 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_elements_sites`
--

CREATE TABLE `craft_elements_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_elements_sites_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_elements_sites_siteId_idx` (`siteId`),
  KEY `craft_elements_sites_slug_siteId_idx` (`slug`,`siteId`),
  KEY `craft_elements_sites_enabled_idx` (`enabled`),
  KEY `craft_elements_sites_uri_siteId_idx` (`uri`,`siteId`),
  CONSTRAINT `craft_elements_sites_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_elements_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2637 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entries`
--

CREATE TABLE `craft_entries` (
  `id` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `typeId` int(11) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `postDate` datetime DEFAULT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `deletedWithEntryType` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_entries_postDate_idx` (`postDate`),
  KEY `craft_entries_expiryDate_idx` (`expiryDate`),
  KEY `craft_entries_authorId_idx` (`authorId`),
  KEY `craft_entries_sectionId_idx` (`sectionId`),
  KEY `craft_entries_typeId_idx` (`typeId`),
  KEY `craft_entries_parentId_fk` (`parentId`),
  CONSTRAINT `craft_entries_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entries_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_entries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_entries_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entries_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_entrytypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_erecysmllmwbtnyvhkkhmjokdrbgvgnwjsgn` FOREIGN KEY (`authorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entrydrafterrors`
--

CREATE TABLE `craft_entrydrafterrors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `draftId` int(11) DEFAULT NULL,
  `error` text,
  PRIMARY KEY (`id`),
  KEY `craft_entrydrafterrors_draftId_fk` (`draftId`),
  CONSTRAINT `craft_entrydrafterrors_draftId_fk` FOREIGN KEY (`draftId`) REFERENCES `craft_entrydrafts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entrydrafts`
--

CREATE TABLE `craft_entrydrafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entryId` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `creatorId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `notes` text,
  `data` mediumtext NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_entrydrafts_sectionId_idx` (`sectionId`),
  KEY `craft_entrydrafts_entryId_siteId_idx` (`entryId`,`siteId`),
  KEY `craft_entrydrafts_siteId_idx` (`siteId`),
  KEY `craft_entrydrafts_creatorId_idx` (`creatorId`),
  CONSTRAINT `craft_entrydrafts_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entrydrafts_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entrydrafts_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entrydrafts_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entrytypes`
--

CREATE TABLE `craft_entrytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `hasTitleField` tinyint(1) NOT NULL DEFAULT '1',
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text,
  `titleFormat` varchar(255) DEFAULT NULL,
  `sortOrder` smallint(5) 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 `craft_entrytypes_sectionId_idx` (`sectionId`),
  KEY `craft_entrytypes_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_entrytypes_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_entrytypes_name_sectionId_idx` (`name`,`sectionId`),
  KEY `craft_entrytypes_handle_sectionId_idx` (`handle`,`sectionId`),
  CONSTRAINT `craft_entrytypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_entrytypes_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entryversionerrors`
--

CREATE TABLE `craft_entryversionerrors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `versionId` int(11) DEFAULT NULL,
  `error` text,
  PRIMARY KEY (`id`),
  KEY `craft_entryversionerrors_versionId_fk` (`versionId`),
  CONSTRAINT `craft_entryversionerrors_versionId_fk` FOREIGN KEY (`versionId`) REFERENCES `craft_entryversions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_entryversions`
--

CREATE TABLE `craft_entryversions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entryId` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `siteId` int(11) NOT NULL,
  `num` smallint(5) unsigned NOT NULL,
  `notes` text,
  `data` mediumtext NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_entryversions_sectionId_idx` (`sectionId`),
  KEY `craft_entryversions_entryId_siteId_idx` (`entryId`,`siteId`),
  KEY `craft_entryversions_siteId_idx` (`siteId`),
  KEY `craft_entryversions_creatorId_idx` (`creatorId`),
  CONSTRAINT `craft_entryversions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_entryversions_entryId_fk` FOREIGN KEY (`entryId`) REFERENCES `craft_entries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entryversions_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_entryversions_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fieldgroups`
--

CREATE TABLE `craft_fieldgroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_fieldgroups_name_idx` (`name`),
  KEY `craft_idx_eulnwhanfokvypyrmgkahjackndeyjhnzocc` (`dateDeleted`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_fieldlayoutfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `tabId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_fieldlayoutfields_layoutId_fieldId_unq_idx` (`layoutId`,`fieldId`),
  KEY `craft_fieldlayoutfields_sortOrder_idx` (`sortOrder`),
  KEY `craft_fieldlayoutfields_tabId_idx` (`tabId`),
  KEY `craft_fieldlayoutfields_fieldId_idx` (`fieldId`),
  CONSTRAINT `craft_fieldlayoutfields_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fieldlayoutfields_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fieldlayoutfields_tabId_fk` FOREIGN KEY (`tabId`) REFERENCES `craft_fieldlayouttabs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1503 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fieldlayouts`
--

CREATE TABLE `craft_fieldlayouts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_fieldlayouts_type_idx` (`type`),
  KEY `craft_fieldlayouts_dateDeleted_idx` (`dateDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fieldlayouttabs`
--

CREATE TABLE `craft_fieldlayouttabs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `elements` text,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_fieldlayouttabs_sortOrder_idx` (`sortOrder`),
  KEY `craft_fieldlayouttabs_layoutId_idx` (`layoutId`),
  CONSTRAINT `craft_fieldlayouttabs_layoutId_fk` FOREIGN KEY (`layoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=765 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fields`
--

CREATE TABLE `craft_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) DEFAULT NULL,
  `name` varchar(255) 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,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_fields_groupId_idx` (`groupId`),
  KEY `craft_fields_context_idx` (`context`),
  KEY `craft_fields_handle_context_idx` (`handle`,`context`),
  CONSTRAINT `craft_fields_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fmc_contactform`
--

CREATE TABLE `craft_fmc_contactform` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_yourName` text,
  `field_emailAddress` varchar(255) DEFAULT NULL,
  `field_message` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_wdcufkqxcflkhmzmnviuavgovngmtwkdkkvn` (`elementId`,`siteId`),
  KEY `craft_fk_kwskztkqnuaevgcpdeqpfnnwomfzkmzewpxl` (`siteId`),
  CONSTRAINT `craft_fk_fhowvcjvbtgdzeynfehyjbbklmgjgjnzfcvx` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_kwskztkqnuaevgcpdeqpfnnwomfzkmzewpxl` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_fmc_newsletter`
--

CREATE TABLE `craft_fmc_newsletter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_oveshniqodookhplhrsyyfvzveunugqeefok` (`elementId`,`siteId`),
  KEY `craft_fk_kufouwnkbmvsfanejosbkbjddqtdohajbdvx` (`siteId`),
  CONSTRAINT `craft_fk_kufouwnkbmvsfanejosbkbjddqtdohajbdvx` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_qgonajuwakkklvqhbkgmskoabgrntopqefpu` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_emailtemplates`
--

CREATE TABLE `craft_formie_emailtemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `template` varchar(255) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_forms`
--

CREATE TABLE `craft_formie_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `handle` varchar(64) NOT NULL,
  `fieldContentTable` varchar(74) NOT NULL,
  `settings` mediumtext,
  `templateId` int(11) DEFAULT NULL,
  `submitActionEntryId` int(11) DEFAULT NULL,
  `requireUser` tinyint(1) DEFAULT NULL,
  `availability` enum('always','date','submissions') NOT NULL DEFAULT 'always',
  `availabilityFrom` datetime DEFAULT NULL,
  `availabilityTo` datetime DEFAULT NULL,
  `availabilitySubmissions` int(11) DEFAULT NULL,
  `defaultStatusId` int(11) DEFAULT NULL,
  `dataRetention` enum('forever','minutes','hours','days','weeks','months','years') NOT NULL DEFAULT 'forever',
  `dataRetentionValue` int(11) DEFAULT NULL,
  `userDeletedAction` enum('retain','delete') NOT NULL DEFAULT 'retain',
  `fileUploadsAction` enum('retain','delete') NOT NULL DEFAULT 'retain',
  `fieldLayoutId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_pzpygykboulicmiwrcvtosutbdrxwojyrejv` (`templateId`),
  KEY `craft_idx_cpuqvivicsmlvwelwtlzmjsrzxofebswkpoj` (`defaultStatusId`),
  KEY `craft_idx_skxffmvweuycdptiomujrjvxxhnnwouejktr` (`submitActionEntryId`),
  KEY `craft_idx_bmvyvwkjoifneytfuzkjmezivdguetlhpfqk` (`fieldLayoutId`),
  CONSTRAINT `craft_fk_ejewodqpprjlgvzhovwvdrqeifsgtytapoob` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_hhczfowcawocswezdakvmpvqclvaxhdjwrpl` FOREIGN KEY (`templateId`) REFERENCES `craft_formie_formtemplates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_hvvmznjylslwkkobethfxaaehzaqwpbhprhl` FOREIGN KEY (`defaultStatusId`) REFERENCES `craft_formie_statuses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_oklfpdihtslmiiuqlsofnxufyndecktfqvwd` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_oxopzqlkubvxriqbabqbpettovfpfnbzfmmt` FOREIGN KEY (`submitActionEntryId`) REFERENCES `craft_entries` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=626 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_formtemplates`
--

CREATE TABLE `craft_formie_formtemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `template` varchar(255) DEFAULT NULL,
  `useCustomTemplates` tinyint(1) DEFAULT '1',
  `outputCssLayout` tinyint(1) DEFAULT '1',
  `outputCssTheme` tinyint(1) DEFAULT '1',
  `outputJsBase` tinyint(1) DEFAULT '1',
  `outputJsTheme` tinyint(1) DEFAULT '1',
  `outputCssLocation` varchar(255) DEFAULT NULL,
  `outputJsLocation` varchar(255) DEFAULT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_fcvpatlgpppahqznrzdzoonzewoudzyzafmg` (`fieldLayoutId`),
  CONSTRAINT `craft_fk_meooghzdpgfwbmnwucgathlcwvbemtcyvabb` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_integrations`
--

CREATE TABLE `craft_formie_integrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `type` varchar(255) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `settings` text,
  `cache` longtext,
  `tokenId` int(11) DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `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=utf8;

--
-- Table structure for table `craft_formie_nested`
--

CREATE TABLE `craft_formie_nested` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_bqfwkbdtxwtzrscadurpyemvggavowosjtgc` (`fieldId`),
  KEY `craft_idx_xpomlfqunrpuviedxllvanxonfhufvvxceup` (`fieldLayoutId`),
  CONSTRAINT `craft_fk_qaefftqypzqmauctiygzoxchsmuzsiwhjsrl` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_sfkwtczdynjwqvnyddexdxfwlxjljjbnnaqa` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_nestedfieldrows`
--

CREATE TABLE `craft_formie_nestedfieldrows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ownerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_nnldbgsslwdpcjedkbqjgldtgmaafhssoxle` (`ownerId`),
  KEY `craft_idx_lpnmytvyqrumtogployljxpupaoaipfnqzdj` (`fieldId`),
  KEY `craft_idx_chiyyooenkrpkzjpkecajjzdnlnyvjhjliet` (`sortOrder`),
  CONSTRAINT `craft_fk_peqfrpxhvfcvwsyayhjrzhsoryzpscdflmfk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_uxlojohkcujmcvxunomncaqytthociydzlpw` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_vcbpkqbdyntfcipvxcjooavotutyvzyqshhi` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_notifications`
--

CREATE TABLE `craft_formie_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formId` int(11) NOT NULL,
  `templateId` int(11) DEFAULT NULL,
  `pdfTemplateId` int(11) DEFAULT NULL,
  `name` text NOT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  `subject` text,
  `recipients` enum('email','conditions') NOT NULL DEFAULT 'email',
  `to` text,
  `toConditions` text,
  `cc` text,
  `bcc` text,
  `replyTo` text,
  `replyToName` text,
  `from` text,
  `fromName` text,
  `content` text,
  `attachFiles` tinyint(1) DEFAULT '1',
  `attachPdf` tinyint(1) DEFAULT '0',
  `attachAssets` text,
  `enableConditions` tinyint(1) DEFAULT '0',
  `conditions` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_wldyrqcavawndruabmpmpusaunlqoxwrjlsv` (`formId`),
  KEY `craft_idx_baaautlcvryfchxiliangalkrcsuiujmgwtn` (`templateId`),
  KEY `craft_fk_ahwhqbkpzauulupfuzmaqfwwgdesiffqojeg` (`pdfTemplateId`),
  CONSTRAINT `craft_fk_ahwhqbkpzauulupfuzmaqfwwgdesiffqojeg` FOREIGN KEY (`pdfTemplateId`) REFERENCES `craft_formie_pdftemplates` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_vjdgpnkbvfoxaoiyodwiqvzotkkmqtipawqc` FOREIGN KEY (`formId`) REFERENCES `craft_formie_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_wholywfttuvhwjieiiwygtrzhzkursmynmyj` FOREIGN KEY (`templateId`) REFERENCES `craft_formie_emailtemplates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_pagesettings`
--

CREATE TABLE `craft_formie_pagesettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int(11) NOT NULL,
  `fieldLayoutTabId` int(11) NOT NULL,
  `settings` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_wxmtmvyolqgvdqfymwrluswtsxskcwpioxtu` (`fieldLayoutTabId`),
  KEY `craft_idx_kobtzjsumtblkogxxowknzxxewgpawuotuta` (`fieldLayoutId`),
  CONSTRAINT `craft_fk_cgtwprykkrmqgvhaoazjeicusrpyfoogqqck` FOREIGN KEY (`fieldLayoutTabId`) REFERENCES `craft_fieldlayouttabs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_orlcxwcfljxsghcrhdmsovibuotvxosqwttz` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_pdftemplates`
--

CREATE TABLE `craft_formie_pdftemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `template` varchar(255) NOT NULL,
  `filenameFormat` varchar(255) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_relations`
--

CREATE TABLE `craft_formie_relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `sourceSiteId` int(11) DEFAULT NULL,
  `targetId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_rjwgjnxbgxgwebflljajeipsgieblbllicdw` (`sourceId`,`sourceSiteId`,`targetId`),
  KEY `craft_idx_ijblnpdbfjfirumjqjmewslagqcruspytjpk` (`sourceId`),
  KEY `craft_idx_ereensmebhlvwllfpfuqjbavamszhcavmseu` (`targetId`),
  KEY `craft_idx_lqnescttlqagdpikrydtdfretddwdqplalkl` (`sourceSiteId`),
  CONSTRAINT `craft_fk_kttgafklkmalpmbzvfynipnzmpqyuwqddvdh` FOREIGN KEY (`sourceSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_lyuvsutvmyjtqbgiuivvjqurinwfqgaixady` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_zxeyirjjfphjzbqmgftsqvnzsczctrpjkanz` FOREIGN KEY (`targetId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_rows`
--

CREATE TABLE `craft_formie_rows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int(11) NOT NULL,
  `fieldLayoutFieldId` int(11) NOT NULL,
  `row` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_azkaohiuukigncpwvjynmkkwgbpbszrtzcpw` (`fieldLayoutFieldId`),
  KEY `craft_idx_razcenngncglaurzvormwunbbtlornyzdsdc` (`fieldLayoutId`),
  CONSTRAINT `craft_fk_tdcdkxxqgnfdvbddwcvgplfzmfgpclwskuhd` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_vqrybumvbsxyvfufpwyjxtlcgvufbtnhcuxc` FOREIGN KEY (`fieldLayoutFieldId`) REFERENCES `craft_fieldlayoutfields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_sentnotifications`
--

CREATE TABLE `craft_formie_sentnotifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `formId` int(11) DEFAULT NULL,
  `submissionId` int(11) DEFAULT NULL,
  `notificationId` int(11) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `to` varchar(255) DEFAULT NULL,
  `cc` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `replyTo` varchar(255) DEFAULT NULL,
  `replyToName` varchar(255) DEFAULT NULL,
  `from` varchar(255) DEFAULT NULL,
  `fromName` varchar(255) DEFAULT NULL,
  `body` mediumtext,
  `htmlBody` mediumtext,
  `info` text,
  `success` tinyint(1) DEFAULT NULL,
  `message` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_fk_mmrvlajhmqskyarrwlnapmhqeicqxnrzcozy` (`formId`),
  KEY `craft_fk_oidwyjshwlkeexkzclkpfdfwdhbdtwonlkmu` (`submissionId`),
  KEY `craft_fk_tlpwmtcryfjtujgkavlbsyvexrwfgwlzqrfe` (`notificationId`),
  CONSTRAINT `craft_fk_itpyoffnwipfoiovhwcfovxhkndltebdgjmf` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_mmrvlajhmqskyarrwlnapmhqeicqxnrzcozy` FOREIGN KEY (`formId`) REFERENCES `craft_formie_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_oidwyjshwlkeexkzclkpfdfwdhbdtwonlkmu` FOREIGN KEY (`submissionId`) REFERENCES `craft_formie_submissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_tlpwmtcryfjtujgkavlbsyvexrwfgwlzqrfe` FOREIGN KEY (`notificationId`) REFERENCES `craft_formie_notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2637 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_statuses`
--

CREATE TABLE `craft_formie_statuses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `color` enum('green','orange','red','blue','yellow','pink','purple','turquoise','light','grey','black') NOT NULL DEFAULT 'green',
  `description` varchar(255) DEFAULT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `isDefault` tinyint(1) DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `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=utf8;

--
-- Table structure for table `craft_formie_stencils`
--

CREATE TABLE `craft_formie_stencils` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(64) NOT NULL,
  `data` mediumtext,
  `templateId` int(11) DEFAULT NULL,
  `submitActionEntryId` int(11) DEFAULT NULL,
  `defaultStatusId` int(11) DEFAULT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_fftnlrrpnuwqbennloorvkklcmtazfvofhqy` (`templateId`),
  KEY `craft_idx_oawcpqtiuddapqoqnwxqdsrthdzynrtbgafl` (`defaultStatusId`),
  CONSTRAINT `craft_fk_cbvuhavtxtzseoylsqdbwdrbphktwvpwuicg` FOREIGN KEY (`defaultStatusId`) REFERENCES `craft_formie_statuses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_mgbiuraudpotjyqwbaxhickhrlvltnpgqrro` FOREIGN KEY (`templateId`) REFERENCES `craft_formie_formtemplates` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_submissions`
--

CREATE TABLE `craft_formie_submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `formId` int(11) NOT NULL,
  `statusId` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `isIncomplete` tinyint(1) DEFAULT '0',
  `isSpam` tinyint(1) DEFAULT '0',
  `spamReason` text,
  `snapshot` text,
  `ipAddress` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_fhwpdcyhbjfamhofivbngmkwwvlbjhfxdmbg` (`formId`),
  KEY `craft_idx_ohxjhbiqhzpnbbpwgnwhznvgzxreoconvfvz` (`statusId`),
  KEY `craft_idx_nkdtprluxfqhbenxnoironakruarxbbohzyb` (`userId`),
  CONSTRAINT `craft_fk_bdcvpdwqhtdbmnqvncdjhlekujecsojvescb` FOREIGN KEY (`statusId`) REFERENCES `craft_formie_statuses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_ckgerexfeuwvlcsbhgotpelkvwmglsxybldq` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_nmpbcegoyxhblwxfdwmpjfjucsvpadyecbpw` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_fk_umbxlzzzjbndahukuxjnkmqoscfycuxurtkj` FOREIGN KEY (`formId`) REFERENCES `craft_formie_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2635 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_syncfields`
--

CREATE TABLE `craft_formie_syncfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `syncId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_slpgtojjwjbncqipdgvnefatnsqmzdynygjx` (`syncId`,`fieldId`),
  KEY `craft_fk_oxgbjvoiyjisseumakapsjqmxuiyzvzlnjtj` (`fieldId`),
  CONSTRAINT `craft_fk_oxgbjvoiyjisseumakapsjqmxuiyzvzlnjtj` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_xatwwhprzptmprkmoffbmjftnirogzkxogjw` FOREIGN KEY (`syncId`) REFERENCES `craft_formie_syncs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_syncs`
--

CREATE TABLE `craft_formie_syncs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_formie_tokens`
--

CREATE TABLE `craft_formie_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `accessToken` text,
  `secret` text,
  `endOfLife` varchar(255) DEFAULT NULL,
  `refreshToken` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_crm_fields`
--

CREATE TABLE `craft_freeform_crm_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `label` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `required` tinyint(1) DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_crm_fields_integrationId_fk` (`integrationId`),
  KEY `craft_freeform_crm_fields_type_idx` (`type`),
  CONSTRAINT `freeform_crm_fields_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_export_profiles`
--

CREATE TABLE `craft_freeform_export_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formId` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `limit` int(11) DEFAULT NULL,
  `dateRange` varchar(255) DEFAULT NULL,
  `fields` text NOT NULL,
  `filters` text,
  `statuses` text NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `rangeStart` varchar(255) DEFAULT NULL,
  `rangeEnd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `freeform_export_profiles_formId_fk` (`formId`),
  CONSTRAINT `freeform_export_profiles_formId_fk` FOREIGN KEY (`formId`) REFERENCES `craft_freeform_forms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_export_settings`
--

CREATE TABLE `craft_freeform_export_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `setting` mediumtext,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_export_settings_userId_fk` (`userId`),
  CONSTRAINT `freeform_export_settings_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_feed_messages`
--

CREATE TABLE `craft_freeform_feed_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feedId` int(11) NOT NULL,
  `message` text NOT NULL,
  `conditions` text NOT NULL,
  `type` varchar(255) NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0',
  `issueDate` datetime NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_feed_messages_feedId_fk` (`feedId`),
  CONSTRAINT `freeform_feed_messages_feedId_fk` FOREIGN KEY (`feedId`) REFERENCES `craft_freeform_feeds` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_feeds`
--

CREATE TABLE `craft_freeform_feeds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hash` varchar(255) NOT NULL,
  `min` varchar(255) DEFAULT NULL,
  `max` varchar(255) DEFAULT NULL,
  `issueDate` datetime NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_tpbcxkepdawtyjbyrlgoethgclowavlcixul` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_fields`
--

CREATE TABLE `craft_freeform_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `required` tinyint(1) DEFAULT '0',
  `instructions` text,
  `metaProperties` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `handle` (`handle`),
  KEY `craft_freeform_fields_type_idx` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_forms`
--

CREATE TABLE `craft_freeform_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `handle` varchar(100) NOT NULL,
  `spamBlockCount` int(10) unsigned NOT NULL DEFAULT '0',
  `submissionTitleFormat` varchar(255) NOT NULL,
  `description` text,
  `layoutJson` mediumtext,
  `returnUrl` varchar(255) DEFAULT NULL,
  `defaultStatus` int(10) unsigned DEFAULT NULL,
  `formTemplateId` int(10) unsigned DEFAULT NULL,
  `color` varchar(10) DEFAULT NULL,
  `optInDataStorageTargetHash` varchar(20) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `limitFormSubmissions` varchar(20) DEFAULT NULL,
  `extraPostUrl` varchar(255) DEFAULT NULL,
  `extraPostTriggerPhrase` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `gtmEnabled` tinyint(1) DEFAULT '0',
  `gtmId` varchar(255) DEFAULT NULL,
  `gtmEventName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `handle` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_integrations`
--

CREATE TABLE `craft_freeform_integrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `class` varchar(255) DEFAULT NULL,
  `accessToken` varchar(255) DEFAULT NULL,
  `settings` text,
  `forceUpdate` tinyint(1) DEFAULT '0',
  `lastUpdate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `handle` (`handle`),
  KEY `craft_freeform_integrations_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_integrations_queue`
--

CREATE TABLE `craft_freeform_integrations_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submissionId` int(11) NOT NULL,
  `integrationType` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `fieldHash` varchar(20) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_integrations_queue_submissionId_fk` (`submissionId`),
  KEY `craft_freeform_integrations_queue_status_idx` (`status`),
  CONSTRAINT `freeform_integrations_queue_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_freeform_mailing_list_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_integrations_queue_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `craft_freeform_submissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_lock`
--

CREATE TABLE `craft_freeform_lock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_axmewliedtyzrhefggbwurojmiawoxpwfhwd` (`key`,`dateCreated`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_mailing_list_fields`
--

CREATE TABLE `craft_freeform_mailing_list_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mailingListId` int(11) NOT NULL,
  `label` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `required` tinyint(1) DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_mailing_list_fields_mailingListId_fk` (`mailingListId`),
  KEY `craft_freeform_mailing_list_fields_type_idx` (`type`),
  CONSTRAINT `freeform_mailing_list_fields_mailingListId_fk` FOREIGN KEY (`mailingListId`) REFERENCES `craft_freeform_mailing_lists` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_mailing_lists`
--

CREATE TABLE `craft_freeform_mailing_lists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `resourceId` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `memberCount` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `freeform_mailing_lists_integrationId_resourceId_unq_idx` (`integrationId`,`resourceId`),
  CONSTRAINT `freeform_mailing_lists_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_notification_log`
--

CREATE TABLE `craft_freeform_notification_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_idx_vyfklofhdsepbiwgieiakmfuixnupccuqose` (`type`,`dateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_notifications`
--

CREATE TABLE `craft_freeform_notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `description` text,
  `fromName` varchar(255) NOT NULL,
  `fromEmail` varchar(255) NOT NULL,
  `replyToEmail` varchar(255) DEFAULT NULL,
  `bodyHtml` text,
  `bodyText` text,
  `includeAttachments` tinyint(1) DEFAULT '1',
  `sortOrder` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `cc` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `presetAssets` varchar(255) DEFAULT NULL,
  `replyToName` varchar(255) DEFAULT NULL,
  `autoText` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `handle` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_payment_gateway_fields`
--

CREATE TABLE `craft_freeform_payment_gateway_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `label` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `required` tinyint(1) DEFAULT '0',
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_freeform_payment_gateway_fields_integrationId_fk` (`integrationId`),
  KEY `craft_freeform_payment_gateway_fields_type_idx` (`type`),
  CONSTRAINT `craft_freeform_payment_gateway_fields_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_payments_payments`
--

CREATE TABLE `craft_freeform_payments_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `submissionId` int(11) NOT NULL,
  `subscriptionId` int(11) DEFAULT NULL,
  `resourceId` varchar(50) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `last4` smallint(6) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `metadata` mediumtext,
  `errorCode` varchar(20) DEFAULT NULL,
  `errorMessage` varchar(255) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `freeform_payments_payments_integrationId_resourceId_unq_idx` (`integrationId`,`resourceId`),
  KEY `freeform_payments_payments_submissionId_fk` (`submissionId`),
  KEY `freeform_payments_payments_subscriptionId_fk` (`subscriptionId`),
  CONSTRAINT `freeform_payments_payments_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_payments_payments_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `craft_freeform_submissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_payments_payments_subscriptionId_fk` FOREIGN KEY (`subscriptionId`) REFERENCES `craft_freeform_payments_subscriptions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_payments_subscription_plans`
--

CREATE TABLE `craft_freeform_payments_subscription_plans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `resourceId` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `freeform_payments_subscription_plans_integrationId_fk` (`integrationId`),
  CONSTRAINT `freeform_payments_subscription_plans_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_payments_subscriptions`
--

CREATE TABLE `craft_freeform_payments_subscriptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `integrationId` int(11) NOT NULL,
  `submissionId` int(11) NOT NULL,
  `planId` int(11) NOT NULL,
  `resourceId` varchar(50) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `interval` varchar(20) DEFAULT NULL,
  `intervalCount` smallint(6) DEFAULT NULL,
  `last4` smallint(6) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `metadata` mediumtext,
  `errorCode` varchar(20) DEFAULT NULL,
  `errorMessage` varchar(255) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `freeform_payments_subscriptions_integrationId_resourceId_unq_idx` (`integrationId`,`resourceId`),
  KEY `freeform_payments_subscriptions_submissionId_fk` (`submissionId`),
  KEY `freeform_payments_subscriptions_planId_fk` (`planId`),
  CONSTRAINT `freeform_payments_subscriptions_integrationId_fk` FOREIGN KEY (`integrationId`) REFERENCES `craft_freeform_integrations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_payments_subscriptions_planId_fk` FOREIGN KEY (`planId`) REFERENCES `craft_freeform_payments_subscription_plans` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_payments_subscriptions_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `craft_freeform_submissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_spam_reason`
--

CREATE TABLE `craft_freeform_spam_reason` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submissionId` int(11) NOT NULL,
  `reasonType` varchar(100) NOT NULL,
  `reasonMessage` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_freeform_spam_reason_submissionId_reasonType_idx` (`submissionId`,`reasonType`),
  CONSTRAINT `freeform_spam_reason_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `craft_freeform_submissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_statuses`
--

CREATE TABLE `craft_freeform_statuses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `color` varchar(30) DEFAULT NULL,
  `isDefault` tinyint(1) DEFAULT NULL,
  `sortOrder` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `handle` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_submission_notes`
--

CREATE TABLE `craft_freeform_submission_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submissionId` int(11) NOT NULL,
  `note` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_freeform_submission_notes_submissionId_fk` (`submissionId`),
  CONSTRAINT `craft_freeform_submission_notes_submissionId_fk` FOREIGN KEY (`submissionId`) REFERENCES `craft_freeform_submissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_submissions`
--

CREATE TABLE `craft_freeform_submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incrementalId` int(11) NOT NULL,
  `statusId` int(11) DEFAULT NULL,
  `formId` int(11) NOT NULL,
  `token` varchar(100) NOT NULL,
  `ip` varchar(46) DEFAULT NULL,
  `isSpam` tinyint(1) DEFAULT '0',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_1` varchar(100) DEFAULT NULL,
  `field_2` varchar(100) DEFAULT NULL,
  `field_3` text,
  `field_7` varchar(100) DEFAULT NULL,
  `field_8` text,
  `field_9` varchar(100) DEFAULT NULL,
  `field_12` text,
  `field_13` varchar(100) DEFAULT NULL,
  `field_15` varchar(100) DEFAULT NULL,
  `field_16` varchar(100) DEFAULT NULL,
  `field_17` varchar(100) DEFAULT NULL,
  `field_18` text,
  `field_19` varchar(100) DEFAULT NULL,
  `field_20` varchar(100) DEFAULT NULL,
  `field_21` varchar(100) DEFAULT NULL,
  `field_22` varchar(100) DEFAULT NULL,
  `field_23` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `freeform_submissions_incrementalId_unq_idx` (`incrementalId`),
  UNIQUE KEY `freeform_submissions_token_unq_idx` (`token`),
  KEY `freeform_submissions_formId_fk` (`formId`),
  KEY `freeform_submissions_statusId_fk` (`statusId`),
  CONSTRAINT `freeform_submissions_formId_fk` FOREIGN KEY (`formId`) REFERENCES `craft_freeform_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_submissions_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `freeform_submissions_statusId_fk` FOREIGN KEY (`statusId`) REFERENCES `craft_freeform_statuses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=479 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_unfinalized_files`
--

CREATE TABLE `craft_freeform_unfinalized_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assetId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_webhooks`
--

CREATE TABLE `craft_freeform_webhooks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `webhook` varchar(255) NOT NULL,
  `settings` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_freeform_webhooks_type_idx` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_freeform_webhooks_form_relations`
--

CREATE TABLE `craft_freeform_webhooks_form_relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `webhookId` int(11) NOT NULL,
  `formId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_freeform_webhooks_form_relations_webhookId_idx` (`webhookId`),
  KEY `craft_freeform_webhooks_form_relations_formId_idx` (`formId`),
  CONSTRAINT `craft_freeform_webhooks_form_relations_formId_fk` FOREIGN KEY (`formId`) REFERENCES `craft_freeform_forms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_freeform_webhooks_form_relations_webhookId_fk` FOREIGN KEY (`webhookId`) REFERENCES `craft_freeform_webhooks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_globalsets`
--

CREATE TABLE `craft_globalsets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_globalsets_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_globalsets_name_idx` (`name`),
  KEY `craft_globalsets_handle_idx` (`handle`),
  KEY `craft_idx_ehakxzdofaorjbdnvdckzrizkqhtrmqteqyl` (`sortOrder`),
  CONSTRAINT `craft_globalsets_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_globalsets_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=627 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_gqlschemas`
--

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

--
-- Table structure for table `craft_gqltokens`
--

CREATE TABLE `craft_gqltokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `accessToken` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `expiryDate` datetime DEFAULT NULL,
  `lastUsed` datetime DEFAULT NULL,
  `schemaId` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_gqltokens_schemaId_fk` (`schemaId`),
  CONSTRAINT `craft_gqltokens_schemaId_fk` FOREIGN KEY (`schemaId`) REFERENCES `craft_gqlschemas` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_info` (
  `id` int(11) 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=utf8;

--
-- Table structure for table `craft_maps`
--

CREATE TABLE `craft_maps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ownerId` int(11) NOT NULL,
  `ownerSiteId` int(11) DEFAULT NULL,
  `fieldId` int(11) NOT NULL,
  `lat` decimal(11,9) DEFAULT NULL,
  `lng` decimal(12,9) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_maps_ownerId_ownerSiteId_fieldId_unq_idx` (`ownerId`,`ownerSiteId`,`fieldId`),
  KEY `craft_maps_lat_idx` (`lat`),
  KEY `craft_maps_lng_idx` (`lng`),
  KEY `craft_maps_ownerSiteId_fk` (`ownerSiteId`),
  KEY `craft_maps_fieldId_fk` (`fieldId`),
  CONSTRAINT `craft_maps_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_maps_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_maps_ownerSiteId_fk` FOREIGN KEY (`ownerSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixblocks`
--

CREATE TABLE `craft_matrixblocks` (
  `id` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `typeId` int(11) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_matrixblocks_ownerId_idx` (`ownerId`),
  KEY `craft_matrixblocks_fieldId_idx` (`fieldId`),
  KEY `craft_matrixblocks_typeId_idx` (`typeId`),
  KEY `craft_matrixblocks_sortOrder_idx` (`sortOrder`),
  CONSTRAINT `craft_matrixblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_matrixblocktypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixblocktypes`
--

CREATE TABLE `craft_matrixblocktypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_matrixblocktypes_fieldId_idx` (`fieldId`),
  KEY `craft_matrixblocktypes_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_matrixblocktypes_name_fieldId_idx` (`name`,`fieldId`),
  KEY `craft_matrixblocktypes_handle_fieldId_idx` (`handle`,`fieldId`),
  CONSTRAINT `craft_matrixblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_contentblocks`
--

CREATE TABLE `craft_matrixcontent_contentblocks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_richText_richText` text,
  `field_accordion_accordionTitle` text,
  `field_accordion_accordionBody` text,
  `field_fullwidthImage_caption` text,
  `field_heading_heading` text,
  `field_heading_headingLevel` text,
  `field_blockquote_quote` text,
  `field_blockquote_attribution` text,
  `field_table_table` text,
  `field_map_map` text,
  `field_callToAction_ctaHeading` varchar(512) DEFAULT NULL,
  `field_callToAction_ctaBody` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_matrixcontent_contentblocks_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_matrixcontent_contentblocks_siteId_fk` (`siteId`),
  CONSTRAINT `craft_matrixcontent_contentblocks_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixcontent_contentblocks_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=543 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_customformnotificationtext`
--

CREATE TABLE `craft_matrixcontent_customformnotificationtext` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_notification_form` int(11) DEFAULT NULL,
  `field_notification_text` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craf_matrixconten_customformnotificationt_elementI_siteI_unq_idx` (`elementId`,`siteId`),
  KEY `craft_matrixcontent_customformnotificationtext_siteId_fk` (`siteId`),
  CONSTRAINT `craft_matrixcontent_customformnotificationtext_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixcontent_customformnotificationtext_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_floorplandetails`
--

CREATE TABLE `craft_matrixcontent_floorplandetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_housingArea_livingZone_hzldvxlr` text,
  `field_housingArea_area_pxryiidn` int(11) DEFAULT NULL,
  `field_basic_body_gtzdrryw` text,
  `field_premium_body_yzyevssa` text,
  `field_flexible_body_xxibyvjm` text,
  `field_housingArea_verandah_tihgjlzy` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_zrfkrvfvdwclztkfskyxnuofrgezwaveawxj` (`elementId`,`siteId`),
  KEY `craft_fk_xagsteclfxnhiyowhgesitbgdobdudtyzjew` (`siteId`),
  CONSTRAINT `craft_fk_qrntxzvgghfttwpnnbyvhuukcnnvyxabsruw` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_xagsteclfxnhiyowhgesitbgdobdudtyzjew` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=372 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_formsuccessmessages`
--

CREATE TABLE `craft_matrixcontent_formsuccessmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_item_form` int(11) DEFAULT NULL,
  `field_item_successMessage` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_matrixcontent_formsuccessmessages_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_matrixcontent_formsuccessmessages_siteId_fk` (`siteId`),
  CONSTRAINT `craft_matrixcontent_formsuccessmessages_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_matrixcontent_formsuccessmessages_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_introarticle`
--

CREATE TABLE `craft_matrixcontent_introarticle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_text_leftAlignText_ldvgetzz` text,
  `field_text_rightAlignText_kxgwchfl` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_twnnenhtyynunpaxpcvoedqfkbphenycuosm` (`elementId`,`siteId`),
  KEY `craft_idx_wttjmzvmkjjonpymohfizapjvnvmtnybwbnt` (`siteId`),
  CONSTRAINT `craft_fk_izygkmwfpulyjgcfzskndllerwlkvcfcgayl` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_zesfyawmvfqwomdhvaidvvqnjjaqqmvayrwc` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_mainarticle`
--

CREATE TABLE `craft_matrixcontent_mainarticle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_twoColumnText_leftAlignText_hwxtfxdx` text,
  `field_twoColumnText_rightAlignText_unztplud` text,
  `field_heading_heading_dguzrkqh` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_gzlhtyqwrcixeuegattxkxjfftwmupzxekvc` (`elementId`,`siteId`),
  KEY `craft_idx_sbnckexcjbdpdlslscnhkdqwnledosfpaekz` (`siteId`),
  CONSTRAINT `craft_fk_gpmhilruojbcskryufdmgugrisccnnrkecuk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_saozprgprpnmxqnzebgbdrqdgnphyrnhcbeu` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_openinghours`
--

CREATE TABLE `craft_matrixcontent_openinghours` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_openingHours_days_mewlxztn` text,
  `field_openingHours_hours_mocyfrdr` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_ptupjhgtvwxyurfzfkrpmwytwzmwwqwbyxdv` (`elementId`,`siteId`),
  KEY `craft_fk_oznigshmgrvrokgygxfyonqxtdykurphgmhu` (`siteId`),
  CONSTRAINT `craft_fk_oznigshmgrvrokgygxfyonqxtdykurphgmhu` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_wqaccxzjocdrsxclpiuyynmkfqwrydcqsqqg` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_ourprocessslides`
--

CREATE TABLE `craft_matrixcontent_ourprocessslides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_slides_heading_gsmagdef` text,
  `field_slides_description_kqgikcye` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_jologinvvffhcmybdgjveljgevgtgdjryxxz` (`elementId`,`siteId`),
  KEY `craft_fk_vcmdethysatgklvdoocjmrlfdempcunjwiwd` (`siteId`),
  CONSTRAINT `craft_fk_qwtazdurixcdqlikfwgnjtkbilfhzdwercnh` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_vcmdethysatgklvdoocjmrlfdempcunjwiwd` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_subcategory`
--

CREATE TABLE `craft_matrixcontent_subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_subcategory_heading_dmwgxznw` text,
  `field_subcategory_text_vgadyirk` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_vptdmbrqyxfyugzrrovwywtakcwadgxhnldp` (`elementId`,`siteId`),
  KEY `craft_fk_syzatcmrvsfuvublwmyzeaodxtthskbeyxds` (`siteId`),
  CONSTRAINT `craft_fk_cdftwsqmaltihrhfrsiyenhzacbzufoommlg` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_syzatcmrvsfuvublwmyzeaodxtthskbeyxds` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_twocolumnarticle`
--

CREATE TABLE `craft_matrixcontent_twocolumnarticle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_text_leftAlignText_ldvgetzz` text,
  `field_text_rightAlignText_kxgwchfl` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_jjczfwdumgtavlupzlwuhnxxlmbwjopelrps` (`elementId`,`siteId`),
  KEY `craft_idx_ivlriewozsedmiovazhjmkaqknejtcwgiqli` (`siteId`),
  CONSTRAINT `craft_fk_bvxrzgdgigsjhmhwuojoycwzjkgrlcacyrue` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_ywbluyjlehekvuiwjryfkuxpugfeeuzsjygp` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_matrixcontent_whymopanuislides`
--

CREATE TABLE `craft_matrixcontent_whymopanuislides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_slides_description_jyxppmad` text,
  `field_slides_heading_lmuwtqyq` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_wsqjahqlzntivhkdwjnlfpdvclfpunakarsw` (`elementId`,`siteId`),
  KEY `craft_idx_pyplnmnmuyxnomoexfiyxqzvidqevrwrqhqb` (`siteId`),
  CONSTRAINT `craft_fk_mzstkdtxewclbktmdyficgcfmaffhxgiiias` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_ptsioklhwjkopuvlgnpqwegomivlqbvmxjzn` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_migrations`
--

CREATE TABLE `craft_migrations` (
  `id` int(11) 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 `craft_migrations_track_name_unq_idx` (`track`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_plugins`
--

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

--
-- Table structure for table `craft_projectconfig`
--

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

--
-- Table structure for table `craft_queue`
--

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

--
-- Table structure for table `craft_relations`
--

CREATE TABLE `craft_relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `sourceSiteId` int(11) DEFAULT NULL,
  `targetId` int(11) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_relations_fieldId_sourceId_sourceSiteId_targetId_unq_idx` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  KEY `craft_relations_sourceId_idx` (`sourceId`),
  KEY `craft_relations_targetId_idx` (`targetId`),
  KEY `craft_relations_sourceSiteId_idx` (`sourceSiteId`),
  CONSTRAINT `craft_relations_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_relations_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_relations_sourceSiteId_fk` FOREIGN KEY (`sourceSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_relations_targetId_fk` FOREIGN KEY (`targetId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2081 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_resourcepaths`
--

CREATE TABLE `craft_resourcepaths` (
  `hash` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  PRIMARY KEY (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_revisions`
--

CREATE TABLE `craft_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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_revisions_sourceId_num_unq_idx` (`sourceId`,`num`),
  KEY `craft_revisions_creatorId_fk` (`creatorId`),
  CONSTRAINT `craft_revisions_creatorId_fk` FOREIGN KEY (`creatorId`) REFERENCES `craft_users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `craft_revisions_sourceId_fk` FOREIGN KEY (`sourceId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_searchindex`
--

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

--
-- Table structure for table `craft_sections`
--

CREATE TABLE `craft_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` enum('single','channel','structure') NOT NULL DEFAULT 'channel',
  `enableVersioning` tinyint(1) NOT NULL DEFAULT '0',
  `propagationMethod` varchar(255) NOT NULL DEFAULT 'all',
  `defaultPlacement` enum('beginning','end') NOT NULL DEFAULT 'end',
  `previewTargets` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_sections_structureId_idx` (`structureId`),
  KEY `craft_sections_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_sections_name_idx` (`name`),
  KEY `craft_sections_handle_idx` (`handle`),
  CONSTRAINT `craft_sections_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_sections_sites`
--

CREATE TABLE `craft_sections_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `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 `craft_sections_sites_sectionId_siteId_unq_idx` (`sectionId`,`siteId`),
  KEY `craft_sections_sites_siteId_idx` (`siteId`),
  CONSTRAINT `craft_sections_sites_sectionId_fk` FOREIGN KEY (`sectionId`) REFERENCES `craft_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_sections_sites_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_seomatic_metabundles`
--

CREATE TABLE `craft_seomatic_metabundles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `bundleVersion` varchar(255) NOT NULL DEFAULT '',
  `sourceBundleType` varchar(255) NOT NULL DEFAULT '',
  `sourceId` int(11) DEFAULT NULL,
  `sourceName` varchar(255) NOT NULL DEFAULT '',
  `sourceHandle` varchar(255) DEFAULT '',
  `sourceType` varchar(64) NOT NULL DEFAULT '',
  `typeId` int(11) DEFAULT NULL,
  `sourceTemplate` varchar(500) DEFAULT '',
  `sourceSiteId` int(11) DEFAULT NULL,
  `sourceAltSiteSettings` text,
  `sourceDateUpdated` datetime NOT NULL,
  `metaGlobalVars` text,
  `metaSiteVars` text,
  `metaSitemapVars` text,
  `metaContainers` text,
  `redirectsContainer` text,
  `frontendTemplatesContainer` text,
  `metaBundleSettings` text,
  PRIMARY KEY (`id`),
  KEY `craft_seomatic_metabundles_sourceBundleType_idx` (`sourceBundleType`),
  KEY `craft_seomatic_metabundles_sourceId_idx` (`sourceId`),
  KEY `craft_seomatic_metabundles_sourceSiteId_idx` (`sourceSiteId`),
  KEY `craft_seomatic_metabundles_sourceHandle_idx` (`sourceHandle`),
  CONSTRAINT `craft_seomatic_metabundles_sourceSiteId_fk` FOREIGN KEY (`sourceSiteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_sequences`
--

CREATE TABLE `craft_sequences` (
  `name` varchar(255) NOT NULL,
  `next` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_sessions`
--

CREATE TABLE `craft_sessions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `token` char(100) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_sessions_uid_idx` (`uid`),
  KEY `craft_sessions_token_idx` (`token`),
  KEY `craft_sessions_dateUpdated_idx` (`dateUpdated`),
  KEY `craft_sessions_userId_idx` (`userId`),
  CONSTRAINT `craft_sessions_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_shunnedmessages`
--

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

--
-- Table structure for table `craft_sitegroups`
--

CREATE TABLE `craft_sitegroups` (
  `id` int(11) 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 `craft_sitegroups_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_sitegroups_name_idx` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_sites`
--

CREATE TABLE `craft_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) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `language` varchar(12) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '0',
  `baseUrl` varchar(255) DEFAULT NULL,
  `sortOrder` smallint(5) 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 `craft_sites_sortOrder_idx` (`sortOrder`),
  KEY `craft_sites_groupId_fk` (`groupId`),
  KEY `craft_sites_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_sites_handle_idx` (`handle`),
  CONSTRAINT `craft_sites_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_sitegroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_17_ctalinks`
--

CREATE TABLE `craft_stc_17_ctalinks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_linkField` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_buefcmfqfmpzmtlpxvmtxfwnjqcamwcahtlm` (`elementId`,`siteId`),
  KEY `craft_idx_fpsvunkcvmxjiabydxwqmczbrqfyjnapreje` (`siteId`),
  CONSTRAINT `craft_fk_dwibuzhjowvdjmdodvidaaynqibjuzdryyex` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_hammzqlxodtufusqyjukvmflfxavxlcveqco` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_6_links`
--

CREATE TABLE `craft_stc_6_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_linkField` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_stc_6_links_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_stc_6_links_siteId_fk` (`siteId`),
  CONSTRAINT `craft_stc_6_links_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_stc_6_links_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_faq`
--

CREATE TABLE `craft_stc_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_question` text,
  `field_answer` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_ccgzvuhyzsvukyyovkqcudsvjinnklxifzve` (`elementId`,`siteId`),
  KEY `craft_fk_dgfqdfpifvnomeotrcabpaennbnrbrvfyuig` (`siteId`),
  CONSTRAINT `craft_fk_dgfqdfpifvnomeotrcabpaennbnrbrvfyuig` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_hgosxcbgcyuwqadvjdodhkxzdbfitjzdhjhv` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_footerlinks`
--

CREATE TABLE `craft_stc_footerlinks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_linkField` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_stc_footerlinks_elementId_siteId_unq_idx` (`elementId`,`siteId`),
  KEY `craft_stc_footerlinks_siteId_fk` (`siteId`),
  CONSTRAINT `craft_stc_footerlinks_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_stc_footerlinks_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_footerlinks_1`
--

CREATE TABLE `craft_stc_footerlinks_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_linkField` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_ghvaigrlrnoakibaccesgscmssbgpftqfmmw` (`elementId`,`siteId`),
  KEY `craft_fk_dhakydvfloeutgcjpbuywyycmgfdqwvlhpwa` (`siteId`),
  CONSTRAINT `craft_fk_dhakydvfloeutgcjpbuywyycmgfdqwvlhpwa` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_fnjwudxmqgdiypofutkcazaqzuqrwutrruxq` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_ourprocessslides`
--

CREATE TABLE `craft_stc_ourprocessslides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_slides_heading_gsmagdef` text,
  `field_slides_description_kqgikcye` text,
  `field_heading` varchar(120) DEFAULT NULL,
  `field_description` varchar(1280) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_bqowmoismbcqvknnllksnyevjcjplmtqmnfa` (`elementId`,`siteId`),
  KEY `craft_idx_piuwjozrrqxthnrxuybayardzhduvpgzygen` (`siteId`),
  CONSTRAINT `craft_fk_hawsrfevhcjqrqanipkdzrftzofexuvrtfzx` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_ufnimgttwbtosxgnhxddvucwkxyjiwwdxxms` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_subarticles`
--

CREATE TABLE `craft_stc_subarticles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_body` text,
  `field_heading` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_enkjvqndgxsorjecdcgsfjbfgxqahcoyxzih` (`elementId`,`siteId`),
  KEY `craft_idx_olhcgijvrqpyvryljukgrxydrnhqsxgfbigs` (`siteId`),
  CONSTRAINT `craft_fk_gdjowbzvbijggmkifnxzjanadbuqskyaywpi` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_ifbgbuibaelvlwyhjvmsorwtjjkhcuabhkgf` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_values`
--

CREATE TABLE `craft_stc_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_text_heading_sciuupea` text,
  `field_icon_label_tlvyrcbe` text,
  `field_label` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_zssqzcphmsgupjtqzwjokvvszgseasmtwwhh` (`elementId`,`siteId`),
  KEY `craft_idx_xtfjgmilekcgneidfncwarrlclhorvhrmwjs` (`siteId`),
  CONSTRAINT `craft_fk_gjxllkpjijpsowfjyfmkhtryjddhphgjmulx` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_wsppjlcnhuxqnhhakdkcertbmeomuszxegiy` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_whymopanuicategories`
--

CREATE TABLE `craft_stc_whymopanuicategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_categoryName` text,
  `field_text` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_adkcpkhmkrgpfvnqfvxvqhmarxufacstbpvz` (`elementId`,`siteId`),
  KEY `craft_idx_uomratsrsuhzjtijgqyjcwijdrfvgubwtang` (`siteId`),
  CONSTRAINT `craft_fk_axcmurovwgezdoazrxcrlmmgmahmeaxtrvjn` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_fk_eqkejbueiydjcgareendojvugilxmwnddybf` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_whymopanuislides`
--

CREATE TABLE `craft_stc_whymopanuislides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_slides_description_jyxppmad` varchar(1200) DEFAULT NULL,
  `field_slides_heading_lmuwtqyq` varchar(120) DEFAULT NULL,
  `field_heading` varchar(120) DEFAULT NULL,
  `field_description` varchar(1280) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_xwkfxczrtlrsgtnzsgiifuokwqrxquwoknak` (`elementId`,`siteId`),
  KEY `craft_idx_qctobemimiwtkdpsssberjoiqvpvwatgflzk` (`siteId`),
  CONSTRAINT `craft_fk_nhdjcuztxubqtuxaxjxorqlzfyecehktdfxz` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_tqsvtksyfcqxrrppyoportwbttltzchuklrr` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_whymopanuistatements`
--

CREATE TABLE `craft_stc_whymopanuistatements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_categoryName` text,
  `field_text` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_vopjlomhqwauqlhresufpeotddrizfbsuoum` (`elementId`,`siteId`),
  KEY `craft_idx_iwoeeqyneyudzsskmlvyaorzbjgarhiahkzd` (`siteId`),
  CONSTRAINT `craft_fk_kgfqjzjseaytsbxqewltbqzyzggioqfozcxh` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_oobalgkknfrlvijvriwteyesstqtrnkvojvg` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_stc_whymopanuivalues`
--

CREATE TABLE `craft_stc_whymopanuivalues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  `field_heading_qqjadgat` text,
  `field_icon_maysltbz` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_idx_cwijxnbqjcazymxopnyqvlswynpkwcnmdond` (`elementId`,`siteId`),
  KEY `craft_fk_gdkazbhhxoqjdtxeaoypraiaqtwzrireoees` (`siteId`),
  CONSTRAINT `craft_fk_gdkazbhhxoqjdtxeaoypraiaqtwzrireoees` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `craft_fk_nhoyiyoszpptqbajsqmyactddbjevjxqiytz` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_structureelements`
--

CREATE TABLE `craft_structureelements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `elementId` int(11) DEFAULT NULL,
  `root` int(10) unsigned DEFAULT NULL,
  `lft` int(10) unsigned NOT NULL,
  `rgt` int(10) unsigned NOT NULL,
  `level` smallint(5) unsigned NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_structureelements_structureId_elementId_unq_idx` (`structureId`,`elementId`),
  KEY `craft_structureelements_root_idx` (`root`),
  KEY `craft_structureelements_lft_idx` (`lft`),
  KEY `craft_structureelements_rgt_idx` (`rgt`),
  KEY `craft_structureelements_level_idx` (`level`),
  KEY `craft_structureelements_elementId_idx` (`elementId`),
  CONSTRAINT `craft_structureelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_structureelements_structureId_fk` FOREIGN KEY (`structureId`) REFERENCES `craft_structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_structures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `maxLevels` smallint(5) 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 `craft_structures_dateDeleted_idx` (`dateDeleted`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_supertableblocks`
--

CREATE TABLE `craft_supertableblocks` (
  `id` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `typeId` int(11) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_supertableblocks_ownerId_idx` (`ownerId`),
  KEY `craft_supertableblocks_fieldId_idx` (`fieldId`),
  KEY `craft_supertableblocks_typeId_idx` (`typeId`),
  CONSTRAINT `craft_supertableblocks_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_supertableblocks_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_supertableblocks_ownerId_fk` FOREIGN KEY (`ownerId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_supertableblocks_typeId_fk` FOREIGN KEY (`typeId`) REFERENCES `craft_supertableblocktypes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_supertableblocktypes`
--

CREATE TABLE `craft_supertableblocktypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_supertableblocktypes_fieldId_idx` (`fieldId`),
  KEY `craft_supertableblocktypes_fieldLayoutId_idx` (`fieldLayoutId`),
  CONSTRAINT `craft_supertableblocktypes_fieldId_fk` FOREIGN KEY (`fieldId`) REFERENCES `craft_fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_supertableblocktypes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_systemmessages`
--

CREATE TABLE `craft_systemmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `language` varchar(255) NOT NULL,
  `key` varchar(255) NOT NULL,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_systemmessages_key_language_unq_idx` (`key`,`language`),
  KEY `craft_systemmessages_language_idx` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_taggroups`
--

CREATE TABLE `craft_taggroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_taggroups_fieldLayoutId_fk` (`fieldLayoutId`),
  KEY `craft_taggroups_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_taggroups_name_idx` (`name`),
  KEY `craft_taggroups_handle_idx` (`handle`),
  CONSTRAINT `craft_taggroups_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_tags` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_tags_groupId_idx` (`groupId`),
  CONSTRAINT `craft_tags_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_taggroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_tags_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_templatecacheelements`
--

CREATE TABLE `craft_templatecacheelements` (
  `cacheId` int(11) NOT NULL,
  `elementId` int(11) NOT NULL,
  KEY `craft_templatecacheelements_cacheId_idx` (`cacheId`),
  KEY `craft_templatecacheelements_elementId_idx` (`elementId`),
  CONSTRAINT `craft_templatecacheelements_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_templatecacheelements_elementId_fk` FOREIGN KEY (`elementId`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_templatecachequeries`
--

CREATE TABLE `craft_templatecachequeries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cacheId` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `query` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `craft_templatecachequeries_cacheId_idx` (`cacheId`),
  KEY `craft_templatecachequeries_type_idx` (`type`),
  CONSTRAINT `craft_templatecachequeries_cacheId_fk` FOREIGN KEY (`cacheId`) REFERENCES `craft_templatecaches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `craft_templatecaches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `siteId` int(11) NOT NULL,
  `cacheKey` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `expiryDate` datetime NOT NULL,
  `body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `craft_templatecaches_cacheKey_siteId_expiryDate_path_idx` (`cacheKey`,`siteId`,`expiryDate`,`path`),
  KEY `craft_templatecaches_cacheKey_siteId_expiryDate_idx` (`cacheKey`,`siteId`,`expiryDate`),
  KEY `craft_templatecaches_siteId_idx` (`siteId`),
  CONSTRAINT `craft_templatecaches_siteId_fk` FOREIGN KEY (`siteId`) REFERENCES `craft_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_tokens`
--

CREATE TABLE `craft_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` char(32) NOT NULL,
  `route` text,
  `usageLimit` tinyint(3) unsigned DEFAULT NULL,
  `usageCount` tinyint(3) unsigned DEFAULT NULL,
  `expiryDate` datetime NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_tokens_token_unq_idx` (`token`),
  KEY `craft_tokens_expiryDate_idx` (`expiryDate`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_usergroups`
--

CREATE TABLE `craft_usergroups` (
  `id` int(11) 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 `craft_usergroups_handle_idx` (`handle`),
  KEY `craft_usergroups_name_idx` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_usergroups_users`
--

CREATE TABLE `craft_usergroups_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_usergroups_users_groupId_userId_unq_idx` (`groupId`,`userId`),
  KEY `craft_usergroups_users_userId_idx` (`userId`),
  CONSTRAINT `craft_usergroups_users_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_usergroups_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_userpermissions`
--

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

--
-- Table structure for table `craft_userpermissions_usergroups`
--

CREATE TABLE `craft_userpermissions_usergroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_userpermissions_usergroups_permissionId_groupId_unq_idx` (`permissionId`,`groupId`),
  KEY `craft_userpermissions_usergroups_groupId_idx` (`groupId`),
  CONSTRAINT `craft_userpermissions_usergroups_groupId_fk` FOREIGN KEY (`groupId`) REFERENCES `craft_usergroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_userpermissions_usergroups_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_userpermissions_users`
--

CREATE TABLE `craft_userpermissions_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permissionId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_userpermissions_users_permissionId_userId_unq_idx` (`permissionId`,`userId`),
  KEY `craft_userpermissions_users_userId_idx` (`userId`),
  CONSTRAINT `craft_userpermissions_users_permissionId_fk` FOREIGN KEY (`permissionId`) REFERENCES `craft_userpermissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_userpermissions_users_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_userpreferences`
--

CREATE TABLE `craft_userpreferences` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `preferences` text,
  PRIMARY KEY (`userId`),
  CONSTRAINT `craft_userpreferences_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=806 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_users`
--

CREATE TABLE `craft_users` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `photoId` int(11) DEFAULT NULL,
  `firstName` varchar(100) DEFAULT NULL,
  `lastName` varchar(100) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `locked` tinyint(1) NOT NULL DEFAULT '0',
  `suspended` tinyint(1) NOT NULL DEFAULT '0',
  `pending` tinyint(1) NOT NULL DEFAULT '0',
  `lastLoginDate` datetime DEFAULT NULL,
  `lastLoginAttemptIp` varchar(45) DEFAULT NULL,
  `invalidLoginWindowStart` datetime DEFAULT NULL,
  `invalidLoginCount` tinyint(3) unsigned DEFAULT NULL,
  `lastInvalidLoginDate` datetime DEFAULT NULL,
  `lockoutDate` datetime DEFAULT NULL,
  `hasDashboard` tinyint(1) NOT NULL DEFAULT '0',
  `verificationCode` varchar(255) DEFAULT NULL,
  `verificationCodeIssuedDate` datetime DEFAULT NULL,
  `unverifiedEmail` varchar(255) DEFAULT NULL,
  `passwordResetRequired` tinyint(1) NOT NULL DEFAULT '0',
  `lastPasswordChangeDate` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_users_uid_idx` (`uid`),
  KEY `craft_users_verificationCode_idx` (`verificationCode`),
  KEY `craft_users_photoId_fk` (`photoId`),
  KEY `craft_users_email_idx` (`email`),
  KEY `craft_users_username_idx` (`username`),
  CONSTRAINT `craft_users_id_fk` FOREIGN KEY (`id`) REFERENCES `craft_elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_users_photoId_fk` FOREIGN KEY (`photoId`) REFERENCES `craft_assets` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_volumefolders`
--

CREATE TABLE `craft_volumefolders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `craft_volumefolders_name_parentId_volumeId_unq_idx` (`name`,`parentId`,`volumeId`),
  KEY `craft_volumefolders_parentId_idx` (`parentId`),
  KEY `craft_volumefolders_volumeId_idx` (`volumeId`),
  CONSTRAINT `craft_volumefolders_parentId_fk` FOREIGN KEY (`parentId`) REFERENCES `craft_volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `craft_volumefolders_volumeId_fk` FOREIGN KEY (`volumeId`) REFERENCES `craft_volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_volumes`
--

CREATE TABLE `craft_volumes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `hasUrls` tinyint(1) NOT NULL DEFAULT '1',
  `url` varchar(255) DEFAULT NULL,
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text,
  `settings` text,
  `sortOrder` smallint(5) 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 `craft_volumes_fieldLayoutId_idx` (`fieldLayoutId`),
  KEY `craft_volumes_dateDeleted_idx` (`dateDeleted`),
  KEY `craft_volumes_name_idx` (`name`),
  KEY `craft_volumes_handle_idx` (`handle`),
  CONSTRAINT `craft_volumes_fieldLayoutId_fk` FOREIGN KEY (`fieldLayoutId`) REFERENCES `craft_fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Table structure for table `craft_widgets`
--

CREATE TABLE `craft_widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `sortOrder` smallint(5) unsigned DEFAULT NULL,
  `colspan` tinyint(4) DEFAULT NULL,
  `settings` text,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `craft_widgets_userId_idx` (`userId`),
  CONSTRAINT `craft_widgets_userId_fk` FOREIGN KEY (`userId`) REFERENCES `craft_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping routines for database 'mscraftstagingth_db'
--


--
-- Host: localhost    Database: mscraftstagingth_db
-- ------------------------------------------------------


--
-- Dumping data for table `craft_announcements`
--

set autocommit=0;
INSERT INTO `craft_announcements` VALUES (1,1,NULL,'Editor Slideouts','Double-click entries and other editable elements to try the new editor slideout interface.',1,NULL,'2021-08-29 23:55:18'),(2,1,NULL,'Streamlined Entry Publishing Flow','The entry publishing workflow is now [simpler and more intuitive](https://craftcms.com/knowledge-base/editing-entries).',1,NULL,'2021-08-29 23:55:18'),(3,1,13,'SEO Settings fields','The [SEO Settings](https://nystudio107.com/docs/seomatic/fields.html) fields now feature **Override** lightswitches next to each setting, letting you explicitly override SEO settings on a per-entry basis.',1,NULL,'2021-08-29 23:55:18');
commit;

--
-- Dumping data for table `craft_assets`
--

set autocommit=0;
INSERT INTO `craft_assets` VALUES (14,2,4,NULL,'Test-Document.docx','word',NULL,NULL,12155,NULL,NULL,NULL,'2018-06-28 01:16:34','2018-02-09 04:13:13','2018-07-30 02:38:36','3ef78978-69b0-4b44-8c62-96a3e99289bf'),(15,2,4,NULL,'Test-PDF.pdf','pdf',NULL,NULL,141239,NULL,NULL,NULL,'2018-06-28 01:16:34','2018-02-09 04:13:15','2018-07-30 02:38:36','4dc0898f-1c47-45c2-a6dc-c14ad874e087'),(16,2,4,NULL,'Test-Spreadsheet.xlsx','excel',NULL,NULL,9152,NULL,NULL,NULL,'2018-06-28 01:16:34','2018-02-09 04:13:16','2018-07-30 02:38:36','a21c8f29-e443-4ee1-bd1a-5cf056898abf'),(26,3,5,NULL,'Simple-Showreel.json','json',NULL,NULL,2325,NULL,NULL,NULL,'2018-06-28 01:16:34','2018-05-10 04:02:31','2018-07-30 02:38:36','f18754a4-e939-45c8-9c2c-f1819b608953'),(590,4,6,NULL,'simple-user-photo.png','image',2048,2048,47429,NULL,NULL,NULL,'2020-10-15 07:27:53','2020-10-15 07:27:53','2020-10-15 07:27:53','d56bcfba-8e33-4edd-a5ca-3ccad0ca988a'),(806,4,6,NULL,'thehustle.png','image',299,289,29410,NULL,NULL,NULL,'2022-07-08 10:03:39','2022-07-08 10:03:39','2022-07-08 10:03:39','c9c87f9c-4dcf-465e-8b80-40e216221d3e'),(807,1,1,805,'02.jpg','image',905,1280,88989,NULL,0,0,'2022-07-13 04:29:05','2022-07-13 04:29:05','2022-07-13 04:29:05','30cbb238-54ee-4a2b-a966-a52be4eeaf2a'),(808,6,10,805,'logo.svg','image',310,52,15354,NULL,NULL,NULL,'2022-07-13 22:09:12','2022-07-13 22:09:12','2022-07-13 22:10:15','6a2be833-0ffa-40ed-87f2-5e320cee7ab0'),(809,6,10,805,'search-icon.svg','image',30,30,595,NULL,0,0,'2022-08-09 02:08:47','2022-07-13 23:33:28','2022-08-09 02:09:17','7d86c6e7-e13a-43a3-8cca-1dbd03e00867'),(810,1,17,805,'home-top-banner.jpg','image',672,801,388551,NULL,NULL,NULL,'2022-07-14 00:01:05','2022-07-14 00:01:05','2022-07-21 21:10:00','c01f9576-8ea2-43ab-89dc-921e19f3821a'),(811,6,10,805,'large-background-logo.svg','image',821,665,1051,NULL,NULL,NULL,'2022-07-14 00:18:56','2022-07-14 00:18:56','2022-07-14 00:19:25','160de2ec-97cc-459f-86c6-fd86d741525b'),(813,1,24,805,'process-01.jpg','image',960,1001,691146,NULL,NULL,NULL,'2022-07-14 02:52:18','2022-07-14 02:52:18','2022-07-27 01:36:18','c75179d6-31f8-49b7-b713-4cd31ff0b79c'),(819,6,10,805,'chevron-right-solid.svg','image',320,512,347,NULL,NULL,NULL,'2022-08-09 03:17:13','2022-07-14 04:35:30','2022-08-09 03:17:35','b302f7bf-a3ae-47d4-91b5-4469197176df'),(820,6,10,805,'arrow-left.svg','image',11,19,663,NULL,0,0,'2022-07-14 05:10:41','2022-07-14 04:35:34','2022-07-17 21:56:15','2653018c-9f26-465c-8dc8-7ee76eabc281'),(821,6,10,805,'facebook.svg','image',9,17,432,NULL,NULL,NULL,'2022-07-15 01:16:44','2022-07-15 01:16:44','2022-07-15 01:17:17','91a5c68d-031f-4c56-90b3-f735cc93ca22'),(822,6,10,805,'instagram.svg','image',21,21,753,NULL,NULL,NULL,'2022-07-15 01:16:47','2022-07-15 01:16:47','2022-07-15 01:17:11','1c5b0e74-2382-4566-8b3c-d6a1a7b14e6c'),(823,1,29,805,'featured-build-01.jpg','image',673,789,385990,NULL,NULL,NULL,'2022-07-15 02:52:35','2022-07-15 02:52:36','2022-08-04 01:56:00','4ac2f52e-d8d7-45e3-9845-97eb2445706c'),(824,1,29,805,'featured-build-02.jpg','image',671,789,356152,NULL,NULL,NULL,'2022-07-15 02:52:36','2022-07-15 02:52:36','2022-08-04 01:56:02','91ad6958-3057-43b8-a2ee-ffd19d4f1d73'),(825,6,10,805,'chevron-left-solid.svg','image',320,512,348,NULL,NULL,NULL,'2022-08-09 03:16:34','2022-07-17 21:56:34','2022-08-09 03:17:25','724163ec-a252-45f8-8fbe-880730c4753b'),(826,6,10,805,'arrow-right-spicymix.svg','image',11,19,652,NULL,0,0,'2022-07-17 21:56:37','2022-07-17 21:56:37','2022-07-17 21:56:54','211518ce-f3cd-4624-a963-ff25cefd5c18'),(828,1,19,805,'why-mopanui-01.jpg','image',960,990,607725,NULL,NULL,NULL,'2022-07-17 22:22:05','2022-07-17 22:22:05','2022-07-21 21:09:55','ed2da173-9f95-48fc-8187-77434f4eb6ec'),(831,6,10,805,'right-arrow-philippinegrey.svg','image',35,19,805,NULL,0,0,'2022-07-18 01:06:35','2022-07-18 01:06:35','2022-07-18 01:09:59','c394cd1b-bb2f-4b03-8f61-5d786dfbf302'),(832,6,10,805,'right-arrow-white.svg','image',35,19,805,NULL,0,0,'2022-07-18 01:08:02','2022-07-18 01:08:02','2022-07-18 01:09:01','c2b8b81f-a810-4b7d-b39d-9ae6568407ae'),(833,6,10,805,'square-waves.svg','image',1217,223,1367,NULL,NULL,NULL,'2022-07-18 01:11:21','2022-07-18 01:11:21','2022-07-18 01:12:00','49102d4f-e3a2-48a4-967c-88e93f1e8dc1'),(835,1,14,805,'Michael-Jannet-01.jpg','image',667,626,208462,NULL,NULL,NULL,'2022-07-18 01:31:04','2022-07-18 01:31:04','2022-07-18 01:32:31','f71891e4-2fdd-447d-98fe-004c81f4d2c1'),(883,NULL,9,805,'process-01.jpg','image',960,1001,687377,NULL,NULL,NULL,'2022-07-21 21:49:12','2022-07-21 21:49:12','2022-07-21 21:49:15','9b34e925-7b69-4af9-84d4-53dc05be01a4'),(894,1,20,805,'why-mopanui-banner.jpg','image',1551,865,1041404,NULL,NULL,NULL,'2022-07-22 01:05:14','2022-07-22 01:05:14','2022-07-22 01:06:50','0376c62d-b7f5-4ff8-9976-082eb586d2b6'),(895,1,20,805,'why-mopanui-featured-01.jpg','image',627,626,292239,NULL,NULL,NULL,'2022-07-22 01:39:24','2022-07-22 01:39:24','2022-07-22 01:40:19','4cdb8cd6-afae-4368-b56f-aded2a18e72f'),(896,1,20,805,'why-mopanui-featured-02.jpg','image',627,626,290340,NULL,NULL,NULL,'2022-07-22 01:39:26','2022-07-22 01:39:26','2022-07-22 01:40:01','fafc3d9b-eb22-4e79-88d8-b42a9b5dbd6e'),(949,6,21,805,'cost-effective.svg','image',69,63,3313,NULL,NULL,NULL,'2022-07-22 03:26:03','2022-07-22 03:26:03','2022-07-22 03:26:57','4cca6a9a-6394-4f85-b83d-0ce91d9fb1ee'),(950,6,21,805,'ease-of-process.svg','image',58,58,8076,NULL,NULL,NULL,'2022-07-22 03:26:04','2022-07-22 03:26:04','2022-07-22 03:27:43','c7e5099b-8d13-4a1d-b5e1-e8e58262351f'),(951,6,21,805,'quality-of-life.svg','image',57,56,1033,NULL,NULL,NULL,'2022-07-22 03:26:04','2022-07-22 03:26:04','2022-07-22 03:28:21','619d478b-1553-4abb-aeee-70f839ef0090'),(952,6,21,805,'speed-of-implementation.svg','image',55,53,1455,NULL,NULL,NULL,'2022-07-22 03:26:04','2022-07-22 03:26:04','2022-07-22 03:27:10','db9695f0-ebe9-4591-9cfb-d56a13bcd72e'),(953,6,21,805,'sustainability.svg','image',55,57,2120,NULL,NULL,NULL,'2022-07-22 03:26:05','2022-07-22 03:26:05','2022-07-22 03:26:46','f96dba05-53c2-4cbe-9de9-872078dae582'),(1236,1,14,805,'case-studies-listing-banner.jpg','image',1551,865,471518,NULL,NULL,NULL,'2022-07-25 22:33:13','2022-07-25 22:33:13','2022-07-25 22:35:00','765488e5-ff8e-4550-b956-dcef4bfdeb74'),(1266,1,22,805,'michael-and-jannet-preview.jpg','image',667,626,208462,NULL,NULL,NULL,'2022-07-26 02:04:13','2022-07-26 02:04:13','2022-07-26 02:05:11','549d2a61-810a-4e8b-86b2-70834c418ea9'),(1268,1,23,805,'john-and-florence-preview.jpg','image',466,619,231327,NULL,NULL,NULL,'2022-07-26 04:16:57','2022-07-26 04:16:57','2022-07-26 04:17:54','273b395f-a7d4-4eec-9d51-b12c871f5f84'),(1271,1,22,805,'michael-and-jannet-featured-image.jpg','image',667,626,208462,NULL,NULL,NULL,'2022-07-26 22:32:45','2022-07-26 22:32:45','2022-07-26 22:33:15','9faeb25f-1603-4708-81e9-3d5cecff32ee'),(1329,1,26,805,'oak-cabin-01.jpg','image',1920,939,1420899,NULL,NULL,NULL,'2022-07-27 03:33:48','2022-07-27 03:33:48','2022-07-27 03:37:06','09217b0b-e50f-4cfe-a492-e847e4f58fb5'),(1330,1,26,805,'oak-cabin-floorplan.jpg','image',694,530,143791,NULL,NULL,NULL,'2022-07-27 03:37:20','2022-07-27 03:37:20','2022-07-27 03:37:44','3c99f0b8-3f3f-4a3e-b1c5-01400958dab4'),(1335,6,10,805,'search-icon-white.svg','image',23,22,713,NULL,0,0,'2022-07-28 01:46:22','2022-07-28 01:46:22','2022-07-28 01:48:13','8f001384-6769-47f1-b8d5-099669bcb2f0'),(1336,6,10,805,'logo-white.svg','image',310,52,15411,NULL,NULL,NULL,'2022-07-28 01:46:22','2022-07-28 01:46:22','2022-07-28 01:47:02','14463d22-4c88-42d4-82b1-233906fb4149'),(1362,1,22,805,'michael-jannet-gallery-03.jpg','image',655,709,336264,NULL,0,0,'2022-07-28 23:44:34','2022-07-28 23:44:34','2022-07-28 23:44:34','5a1e8439-fcac-41c6-961e-079493d299fc'),(1363,1,22,805,'michael-jannet-gallery-05.jpg','image',655,709,336264,NULL,0,0,'2022-07-28 23:44:34','2022-07-28 23:44:34','2022-07-28 23:44:34','c00707ce-6724-4bb5-ab1d-6d230030228b'),(1364,1,22,805,'michael-jannet-gallery-02.jpg','image',653,350,143589,NULL,0,0,'2022-07-28 23:44:34','2022-07-28 23:44:34','2022-07-28 23:44:34','bb8c952e-0d1d-4645-8076-344c4cae45c1'),(1365,1,22,805,'michael-jannet-gallery-04.jpg','image',653,350,143589,NULL,0,0,'2022-07-28 23:44:34','2022-07-28 23:44:34','2022-07-28 23:44:34','7033329a-4659-40f9-8c7d-45932240f9b2'),(1366,1,22,805,'michael-jannet-gallery-01.jpg','image',1355,626,513135,NULL,0,0,'2022-07-28 23:44:35','2022-07-28 23:44:35','2022-07-28 23:44:35','d020390f-565a-4a35-bffe-6ca67cc7a402'),(1367,1,22,805,'michael-jannet-gallery-01.jpg','image',1355,626,513135,NULL,NULL,NULL,'2022-07-28 23:44:59','2022-07-28 23:44:59','2022-07-28 23:45:24','b615b29b-a2fb-4d09-9fc7-6689b0be3221'),(1368,1,22,805,'michael-jannet-gallery-02.jpg','image',653,350,143589,NULL,NULL,NULL,'2022-07-28 23:45:01','2022-07-28 23:45:01','2022-07-28 23:45:34','07b5d230-38a5-4b4b-b885-6510bb92e365'),(1369,1,22,805,'michael-jannet-gallery-03.jpg','image',655,709,336264,NULL,NULL,NULL,'2022-07-28 23:45:03','2022-07-28 23:45:04','2022-07-28 23:45:47','9de511f0-1461-42c6-834e-729c87ab3986'),(1370,1,22,805,'michael-jannet-gallery-04.jpg','image',653,350,143589,NULL,NULL,NULL,'2022-07-28 23:45:06','2022-07-28 23:45:06','2022-07-28 23:45:53','be3100af-dda6-42b6-9727-41fea6d9dd82'),(1371,1,22,805,'michael-jannet-gallery-05.jpg','image',655,709,336264,NULL,NULL,NULL,'2022-07-28 23:45:07','2022-07-28 23:45:07','2022-07-28 23:46:00','d054b4f4-6fc3-44bc-91b3-513fbf94b702'),(1454,1,1,805,'404.png','image',2356,2459,1677423,NULL,0,0,'2022-08-12 03:13:56','2022-08-12 03:13:56','2022-08-12 03:13:56','c21b0371-1c01-4e4e-8477-37ac0e712ca1'),(1455,6,10,805,'404.png','image',2356,2459,1677423,NULL,NULL,NULL,'2022-08-12 03:17:57','2022-08-12 03:17:57','2022-08-12 03:18:30','63b5965f-9ed2-4466-bc2c-80706c1e6695'),(1456,6,10,805,'minus-solid.svg','image',448,512,239,NULL,NULL,NULL,'2022-08-12 04:01:00','2022-08-12 04:01:00','2022-08-12 04:03:16','c09f17ed-9bd0-454b-9b4b-363867d3c2e0'),(1457,6,10,805,'plus-solid.svg','image',448,512,371,NULL,0,0,'2022-08-12 04:01:02','2022-08-12 04:01:02','2022-08-12 04:01:02','94b2a6db-07a8-4df7-b5f7-8b6297a63775'),(1458,6,10,805,'arrow-right-long-solid.svg','image',512,512,383,NULL,0,0,'2022-08-12 04:01:58','2022-08-12 04:01:58','2022-08-12 04:01:58','7221af44-ae9e-486f-961f-ea5c3a53bec5'),(1459,6,10,805,'plus-solid.svg','image',448,512,371,NULL,NULL,NULL,'2022-08-12 04:02:09','2022-08-12 04:02:09','2022-08-12 04:03:08','412c29a7-0692-496e-8bcf-f877fceec610'),(1460,6,10,805,'arrow-right-long-solid.svg','image',512,512,383,NULL,NULL,NULL,'2022-08-12 04:02:20','2022-08-12 04:02:20','2022-08-12 04:02:57','9ed3c272-a46b-48f8-aa29-1114ef5bc3ef'),(1461,6,10,805,'bars-solid.svg','image',448,512,483,NULL,NULL,NULL,'2022-08-12 04:09:42','2022-08-12 04:09:42','2022-08-12 04:09:42','40252049-f81a-4236-aeb1-e110824f9949'),(1462,6,10,805,'arrow-up-solid.svg','image',384,512,408,NULL,NULL,NULL,'2022-08-15 04:07:13','2022-08-15 04:07:13','2022-08-15 04:07:31','d015cb8d-7c65-4f78-b3c8-86a4a6a37f3b'),(1463,6,10,805,'chevron-up-solid.svg','image',448,512,349,NULL,NULL,NULL,'2022-08-15 04:21:12','2022-08-15 04:21:12','2022-08-15 04:21:31','e1d1e706-5f0d-4e97-8116-65ab6de42d5f'),(1468,1,26,805,'2-Area-cropped-min.jpg','image',2048,1278,1001404,NULL,NULL,NULL,'2022-09-04 21:23:07','2022-09-04 21:23:07','2022-09-04 21:23:07','a3192069-0e1e-48ce-9c38-db5ce72baa9e'),(1469,1,26,805,'4-Bedroom-min.jpg','image',2048,1536,278102,NULL,NULL,NULL,'2022-09-04 21:23:35','2022-09-04 21:23:35','2022-09-04 21:23:35','8865e294-6e6c-43f8-9cf3-9519f6e07ac7'),(1470,1,26,805,'beauty-salon-min.jpg','image',2048,1536,294452,NULL,NULL,NULL,'2022-09-04 21:23:38','2022-09-04 21:23:38','2022-09-04 21:23:38','b747982a-b9d5-4040-b09c-467c276afc33'),(1471,1,26,805,'FB_IMG_1513335200674-min.jpg','image',2048,1536,577853,NULL,NULL,NULL,'2022-09-04 21:23:41','2022-09-04 21:23:41','2022-09-04 21:23:41','eac3eb98-5792-4182-a30d-9cf5a977d2b1'),(1472,1,26,805,'FB_IMG_1513335213652-min.jpg','image',2048,1536,342876,NULL,NULL,NULL,'2022-09-04 21:23:44','2022-09-04 21:23:44','2022-09-04 21:23:44','eb95a371-8240-4f6c-bd4d-88b96b836ebc'),(1473,1,26,805,'received_1826772273999682-min.jpg','image',2048,1536,539268,NULL,NULL,NULL,'2022-09-04 21:23:46','2022-09-04 21:23:47','2022-09-04 21:23:47','e18bd352-047e-487e-893a-0701f0d9823d'),(1474,1,26,805,'backyard-cabin-Corsica-floor-plan.jpg','image',810,850,53629,NULL,NULL,NULL,'2022-09-04 22:38:22','2022-09-04 22:38:22','2022-09-04 22:38:22','d584aa0e-9196-44e0-a329-dbacf6bea94a'),(1697,1,30,805,'corsiaV0.png','image',3508,2480,260697,NULL,NULL,NULL,'2022-09-12 22:14:13','2022-09-12 22:14:13','2022-09-12 22:14:13','6107dbce-8128-4c3e-8d19-ce4e45ac916b'),(1702,1,30,805,'corsiaV0_2022-09-12-221727_bebi.png','image',3508,2480,715110,NULL,NULL,NULL,'2022-09-12 22:18:03','2022-09-12 22:18:04','2022-09-12 22:18:04','1c064a12-8e84-4345-90af-5a881e614545'),(1707,1,30,805,'Untitled-1.png','image',595,595,148135,NULL,NULL,NULL,'2022-09-12 22:44:22','2022-09-12 22:44:22','2022-09-12 22:44:22','3d972ff4-affc-4a58-a1bd-452b0ef546c4'),(1708,1,31,805,'20200922_150118-edit.jpg','image',2048,1152,1718315,NULL,NULL,NULL,'2022-09-12 22:50:04','2022-09-12 22:50:05','2022-09-12 22:50:05','cb4c49fc-18b2-400f-a666-b9342b4f5c9f'),(1709,1,31,805,'20210113_123907-edit.jpg','image',2048,1315,1788121,NULL,NULL,NULL,'2022-09-12 22:50:17','2022-09-12 22:50:17','2022-09-12 22:50:17','1b6e01d1-05b3-4366-92cf-5dbdf621b804'),(1710,1,31,805,'20210114_134933-edit-no-poeple.jpg','image',2048,1536,2152299,NULL,NULL,NULL,'2022-09-12 22:50:30','2022-09-12 22:50:30','2022-09-12 22:50:30','4fe9b02e-6175-4368-9f8b-a6cbb041dc58'),(1711,1,31,805,'Armidale-2022-Corsica-30-front.jpg','image',2048,970,1180543,NULL,NULL,NULL,'2022-09-12 22:50:38','2022-09-12 22:50:38','2022-09-12 22:50:38','868317d2-0e21-4707-a075-9670b5979bfa'),(1716,1,31,805,'CorsiaV1.png','image',595,595,96685,NULL,NULL,NULL,'2022-09-12 22:52:02','2022-09-12 22:52:02','2022-09-12 22:52:02','22501dc9-5ee4-4ce2-8e46-a7b6604677b6'),(1729,1,32,805,'crete.png','image',595,595,149129,NULL,NULL,NULL,'2022-09-12 22:58:40','2022-09-12 22:58:40','2022-09-12 22:58:40','d615363a-bf41-44ea-bf7a-c2d5e4726057'),(1730,1,32,805,'20200727_175529.jpg','image',2048,1536,1364404,NULL,NULL,NULL,'2022-09-12 23:03:22','2022-09-12 23:03:22','2022-09-12 23:03:22','24adcede-b6b4-404c-b3ac-e91a0971f2ac'),(1731,1,32,805,'20201105_172537.jpg','image',2048,1391,1676961,NULL,NULL,NULL,'2022-09-12 23:03:30','2022-09-12 23:03:31','2022-09-12 23:03:31','60892e66-286e-4477-8abd-84510500a675'),(1732,1,32,805,'20201206_111637.jpg','image',2048,1152,1103392,NULL,NULL,NULL,'2022-09-12 23:03:40','2022-09-12 23:03:41','2022-09-12 23:03:41','87c92752-5dce-4527-9773-14ceb661dcbd'),(1733,1,32,805,'20201206_111746.jpg','image',2048,1152,639847,NULL,NULL,NULL,'2022-09-12 23:03:45','2022-09-12 23:03:45','2022-09-12 23:03:45','a99f00e7-bed8-46da-9b63-8d5cf11c1837'),(1734,1,32,805,'20210302_170659-2.jpg','image',2048,1152,1546704,NULL,NULL,NULL,'2022-09-12 23:03:54','2022-09-12 23:03:55','2022-09-12 23:03:55','698e25b7-6124-4c95-a25e-a452fe8ce6c4'),(1735,1,32,805,'IMG_3715.jpg','image',2048,1536,1969031,NULL,NULL,NULL,'2022-09-12 23:04:06','2022-09-12 23:04:06','2022-09-12 23:04:06','67ce6565-20dc-408b-872c-0a6e5362c568'),(1736,1,32,805,'Resized_20210921_113324.jpg','image',2048,1536,949201,NULL,NULL,NULL,'2022-09-12 23:04:13','2022-09-12 23:04:13','2022-09-12 23:04:13','39b28963-4bc5-430f-9062-a28a554aa708'),(1745,1,33,805,'majorca.png','image',595,595,167111,NULL,NULL,NULL,'2022-09-12 23:10:09','2022-09-12 23:10:09','2022-09-12 23:10:09','f2261a38-b9fe-46c6-b88c-8b32cd45e15e'),(1746,1,33,805,'1948176_988029814550741_5805124931224365524_n.jpg','image',2048,2048,1126065,NULL,NULL,NULL,'2022-09-12 23:14:27','2022-09-12 23:14:27','2022-09-12 23:14:27','cbaa36a7-6c10-40d4-8314-d0d338963cec'),(1747,1,33,805,'20150727_103528.jpg','image',2048,1152,2233517,NULL,NULL,NULL,'2022-09-12 23:14:38','2022-09-12 23:14:38','2022-09-12 23:14:38','fec5b2f4-bb46-44d0-81bb-ea1ed5045b58'),(1748,1,33,805,'20150827_150411.jpg','image',2048,1152,1099433,NULL,NULL,NULL,'2022-09-12 23:14:46','2022-09-12 23:14:46','2022-09-12 23:14:46','6e930b8e-25d7-47f8-bd33-20e1814fb52e'),(1749,1,33,805,'backyard-cabin-Majorca1.jpg','image',2048,1415,1172750,NULL,NULL,NULL,'2022-09-12 23:14:54','2022-09-12 23:14:54','2022-09-12 23:14:54','ce335bed-3f3c-4b75-9687-f9f044008789'),(1750,1,33,805,'backyard-cabin-Majorca2.jpg','image',2048,1445,1050180,NULL,NULL,NULL,'2022-09-12 23:14:59','2022-09-12 23:14:59','2022-09-12 23:14:59','3068364d-b47f-487a-a02a-15f29af91117'),(1751,1,33,805,'backyard-cabin-Majorca-inside.jpg','image',2048,1365,1303245,NULL,NULL,NULL,'2022-09-12 23:15:10','2022-09-12 23:15:10','2022-09-12 23:15:10','ca47f4a8-b333-4933-a99d-244876c16a3b'),(1752,1,33,805,'image3.jpg','image',1536,2048,1002505,NULL,NULL,NULL,'2022-09-12 23:15:14','2022-09-12 23:15:15','2022-09-12 23:15:15','dde2f652-8847-48ff-b4b0-626c9674a799'),(1761,1,34,805,'sicilia.png','image',595,595,62394,NULL,NULL,NULL,'2022-09-12 23:22:47','2022-09-12 23:22:47','2022-09-12 23:22:47','2d2800a2-1552-4f90-bfec-fe3cb55f3e49'),(1762,1,34,805,'DSC8585.jpg','image',2048,1427,1019385,NULL,NULL,NULL,'2022-09-12 23:33:21','2022-09-12 23:33:22','2022-09-12 23:33:22','ed7a51c7-9fc6-4b27-89bf-078eb53cbfaf'),(1763,1,34,805,'20151111_100821.jpg','image',2048,1152,1019676,NULL,NULL,NULL,'2022-09-12 23:33:29','2022-09-12 23:33:29','2022-09-12 23:33:29','30ff0fe3-b84a-40e5-90e9-fa6f6ed97568'),(1764,1,34,805,'20151111_100933.jpg','image',2048,1152,1279199,NULL,NULL,NULL,'2022-09-12 23:33:38','2022-09-12 23:33:39','2022-09-12 23:33:39','0191213f-791d-4a6e-9f27-bb174b99b71c'),(1765,1,34,805,'20170815_173721.jpg','image',2048,1152,1135981,NULL,NULL,NULL,'2022-09-12 23:33:45','2022-09-12 23:33:45','2022-09-12 23:33:45','db25ff47-f2ee-46a9-a436-d7e941bf6891'),(1766,1,34,805,'backyard-cabin-Sicilia3.jpg','image',2048,1152,1451074,NULL,NULL,NULL,'2022-09-12 23:33:55','2022-09-12 23:33:55','2022-09-12 23:33:55','9f3b7d8e-c938-4f07-ba42-b896940f4a93'),(1767,1,34,805,'image00001.jpg','image',2048,1650,2003282,NULL,NULL,NULL,'2022-09-12 23:34:07','2022-09-12 23:34:07','2022-09-12 23:34:07','6964b7bd-9ea9-4238-82a9-f6a8761ef404'),(1768,1,34,805,'Photo-15-2-17-11-04-21-am.jpg','image',2048,1365,758697,NULL,NULL,NULL,'2022-09-12 23:34:12','2022-09-12 23:34:12','2022-09-12 23:34:12','097282cd-e1cc-4ef9-99c0-54af9953b771'),(1769,1,34,805,'Photo-15-2-17-11-05-15-am.jpg','image',2048,1388,684973,NULL,NULL,NULL,'2022-09-12 23:34:17','2022-09-12 23:34:17','2022-09-12 23:34:17','47a8803a-9da5-44fd-bde4-b49e9294e344'),(1770,1,34,805,'Sicilia-backyard-cabin-IKEA-shared-dining-experience.jpg','image',2048,1346,988310,NULL,NULL,NULL,'2022-09-12 23:34:28','2022-09-12 23:34:28','2022-09-12 23:34:28','78e618d7-4f61-4397-9142-c883a609231d'),(1779,1,35,805,'sicilia2.png','image',595,595,66867,NULL,NULL,NULL,'2022-09-12 23:44:34','2022-09-12 23:44:34','2022-09-12 23:44:34','34b8ca24-bd15-4f88-8e44-748059d0ef97'),(1780,1,35,805,'20201112_123733-4.jpg','image',2048,1536,1350777,NULL,NULL,NULL,'2022-09-12 23:47:30','2022-09-12 23:47:30','2022-09-12 23:47:30','91854dc9-4629-42da-8f05-8f9c66ba3982'),(1781,1,35,805,'SICILIA-20-Home-Office-at-Chapel-Hill-1-persp-2.jpg','image',2048,1536,967359,NULL,NULL,NULL,'2022-09-12 23:47:35','2022-09-12 23:47:36','2022-09-12 23:47:36','84e4f281-4991-48ea-80b3-720df6a263ad'),(1782,1,35,805,'SICILIA-20-Home-Office-at-Chapel-Hill-2-persp-2.jpg','image',2048,1536,889676,NULL,NULL,NULL,'2022-09-12 23:47:41','2022-09-12 23:47:41','2022-09-12 23:47:41','23b89671-867d-4280-b0c0-037d84447d08'),(1783,1,35,805,'Sicilia-Panorama-20-Armidale.jpg','image',2048,1152,914715,NULL,NULL,NULL,'2022-09-12 23:47:45','2022-09-12 23:47:45','2022-09-12 23:47:45','74ba4053-1e56-472a-a716-adff48a1ab6a'),(1784,1,35,805,'Ulladulla.jpg','image',2048,1537,1201643,NULL,NULL,NULL,'2022-09-12 23:47:52','2022-09-12 23:47:52','2022-09-12 23:47:52','4e0e291c-bd31-48ff-8e7e-4432b02b7446'),(1785,1,35,805,'20200902_Sicilia-30-Terrigal.jpg','image',2048,1024,1933546,NULL,NULL,NULL,'2022-09-12 23:52:47','2022-09-12 23:52:48','2022-09-12 23:52:48','f52568a2-19d9-4ed8-a7f1-162fd8578a6b'),(1786,1,35,805,'20201206_112919.jpg','image',2048,1109,1044071,NULL,NULL,NULL,'2022-09-12 23:52:56','2022-09-12 23:52:57','2022-09-12 23:52:57','3b18ff7b-3f83-4f0b-8b9f-dc7fb2182bd1'),(1787,1,35,805,'20201206_113020.jpg','image',2048,1152,1084782,NULL,NULL,NULL,'2022-09-12 23:53:03','2022-09-12 23:53:04','2022-09-12 23:53:04','3c9841a6-ba42-410c-9346-be2bf902996e'),(1788,1,35,805,'20201206_113244.jpg','image',2048,1152,1191584,NULL,NULL,NULL,'2022-09-12 23:53:10','2022-09-12 23:53:10','2022-09-12 23:53:10','5f09ecd5-e30f-4e1d-a06f-2d93bebb0ab2'),(1789,1,35,805,'20201206_113858.jpg','image',2048,1450,1242529,NULL,NULL,NULL,'2022-09-12 23:53:16','2022-09-12 23:53:16','2022-09-12 23:53:16','dbc4b35f-9586-474f-b56a-6d9a6c8da76b'),(1790,1,35,805,'Image-3-edit.jpg','image',2048,1619,2010882,NULL,NULL,NULL,'2022-09-12 23:53:28','2022-09-12 23:53:28','2022-09-12 23:53:28','f7ded376-24fc-4b79-93b6-33234a0fa72f'),(1791,1,35,805,'20201027_190950-edit-min.jpg','image',2048,1536,991342,NULL,NULL,NULL,'2022-09-12 23:54:48','2022-09-12 23:54:48','2022-09-12 23:54:48','412f750d-ff33-48c4-b7e0-dbf3331dda00'),(1792,1,35,805,'Image-1-edit-min.jpg','image',2048,1536,1093828,NULL,NULL,NULL,'2022-09-12 23:54:54','2022-09-12 23:54:54','2022-09-12 23:54:54','63ac6135-cc7d-41a5-a61d-82b8362134cf'),(1793,1,35,805,'Image-4-edit-min.jpg','image',2048,1439,872036,NULL,NULL,NULL,'2022-09-12 23:55:00','2022-09-12 23:55:01','2022-09-12 23:55:01','d60513b5-8a66-47fa-84ce-7fefa7740be5'),(1794,1,35,805,'IMG_3603-min.jpg','image',2048,1536,799048,NULL,NULL,NULL,'2022-09-12 23:55:07','2022-09-12 23:55:07','2022-09-12 23:55:07','257bb5f5-6261-4ed6-8473-a36796de7a2d'),(1827,1,36,805,'rhodes.png','image',595,595,94039,NULL,NULL,NULL,'2022-09-13 01:26:10','2022-09-13 01:26:10','2022-09-13 01:26:10','a157f7fe-23f6-4fb0-8f44-269f53f90f2e'),(1828,1,36,805,'Arial-view-Rhodes.-Sydney.jpg','image',1606,2048,977941,NULL,NULL,NULL,'2022-09-13 01:31:27','2022-09-13 01:31:28','2022-09-13 01:31:28','121968e2-8000-40be-a3a1-f382ec6d75c0'),(1829,1,36,805,'Kitchen-and-dining-Rhodes-Sydney.jpg','image',2048,1152,626983,NULL,NULL,NULL,'2022-09-13 01:31:33','2022-09-13 01:31:33','2022-09-13 01:31:33','e85f66a7-c3fd-4885-b2c4-0a451322433e'),(1830,1,36,805,'Rhodes-added-independent-space-for-teenagers-Sydney.jpg','image',2048,1536,985906,NULL,NULL,NULL,'2022-09-13 01:31:38','2022-09-13 01:31:39','2022-09-13 01:31:39','cdf5d68c-ac5a-458a-915c-c56260c70d90'),(1831,1,36,805,'View-from-main-house-verandah.jpg','image',2048,1536,777718,NULL,NULL,NULL,'2022-09-13 01:31:43','2022-09-13 01:31:43','2022-09-13 01:31:43','d67debe8-9b26-4964-b9c8-08ed3ebc0bc3'),(1832,1,36,805,'View-from-pool-area.jpg','image',2048,1152,873511,NULL,NULL,NULL,'2022-09-13 01:31:48','2022-09-13 01:31:49','2022-09-13 01:31:49','e726191b-36ce-4be3-9621-5c0448e32134'),(1833,1,36,805,'20201206_105428.jpg','image',2048,1152,1078032,NULL,NULL,NULL,'2022-09-13 01:33:29','2022-09-13 01:33:30','2022-09-13 01:33:30','66a9c538-8c3b-4fc7-8f5b-8784093bb64a'),(1834,1,36,805,'20201206_120135.jpg','image',2048,1152,949776,NULL,NULL,NULL,'2022-09-13 01:33:37','2022-09-13 01:33:37','2022-09-13 01:33:37','b4abf33a-f1e4-409a-87a7-53c4ef2a4f70'),(1835,1,36,805,'20201206_120219.jpg','image',2048,1327,792751,NULL,NULL,NULL,'2022-09-13 01:33:41','2022-09-13 01:33:42','2022-09-13 01:33:42','d7943592-d14c-4cbf-91d4-f54695fb6d0e'),(1836,1,36,805,'20201206_120257.jpg','image',2048,1152,1341394,NULL,NULL,NULL,'2022-09-13 01:33:49','2022-09-13 01:33:49','2022-09-13 01:33:49','d65fb67b-0831-4cb5-9a41-7b611be1b909'),(1837,1,36,805,'20201206_120322.jpg','image',2048,1170,1355608,NULL,NULL,NULL,'2022-09-13 01:33:56','2022-09-13 01:33:57','2022-09-13 01:33:57','da9f19ad-9eed-45bc-ae80-d5e679398558'),(1838,1,36,805,'20201206_120349.jpg','image',2048,1152,1481929,NULL,NULL,NULL,'2022-09-13 01:34:05','2022-09-13 01:34:05','2022-09-13 01:34:05','0c4ec307-c9ee-4533-80d2-00440beaf601'),(1839,1,36,805,'20201206_120421.jpg','image',2048,1152,1556634,NULL,NULL,NULL,'2022-09-13 01:34:13','2022-09-13 01:34:13','2022-09-13 01:34:13','52ec1bce-55e9-4661-8005-76cb3bc229ab'),(1840,1,36,805,'20201206_120621.jpg','image',2048,1208,1068007,NULL,NULL,NULL,'2022-09-13 01:34:18','2022-09-13 01:34:19','2022-09-13 01:34:19','77c822a3-cb4a-4e32-b53f-f98979c5dece'),(1841,1,36,805,'20201206_120826.jpg','image',2048,1251,1212993,NULL,NULL,NULL,'2022-09-13 01:34:26','2022-09-13 01:34:26','2022-09-13 01:34:26','7a56d426-8bcf-4289-bf25-85fb7ec81d20'),(1873,1,37,805,'20200215_134925.jpg','image',2048,1152,1401745,NULL,NULL,NULL,'2022-09-13 01:52:38','2022-09-13 01:52:38','2022-09-13 01:52:38','766b66e9-06cc-473e-a07a-32cfeb0b20b5'),(1874,1,37,805,'IMG_20210107_101447-persp-2.jpg','image',2048,1536,1420867,NULL,NULL,NULL,'2022-09-13 01:52:43','2022-09-13 01:52:44','2022-09-13 01:52:44','6e2d29f5-b8b5-4f69-8f95-06d5a0928565'),(1875,1,37,805,'Original39576236.jpg','image',2048,1365,1424614,NULL,NULL,NULL,'2022-09-13 01:52:55','2022-09-13 01:52:55','2022-09-13 01:52:55','a2e2e6db-40ee-4936-bf68-8b626b5d14a1'),(1876,1,37,805,'Original39576238.jpg','image',2048,1365,792222,NULL,NULL,NULL,'2022-09-13 01:53:00','2022-09-13 01:53:02','2022-09-13 01:53:02','030e2a1d-7c76-4551-aa78-506796492a51'),(1877,1,37,805,'Original39576240-1.jpg','image',2048,1365,702771,NULL,NULL,NULL,'2022-09-13 01:53:07','2022-09-13 01:53:08','2022-09-13 01:53:08','ee3af65c-667f-4969-9402-a3b7c8988192'),(1878,1,37,805,'Original39576241.jpg','image',2048,1365,720091,NULL,NULL,NULL,'2022-09-13 01:53:14','2022-09-13 01:53:14','2022-09-13 01:53:14','3c73b85a-d348-455e-b640-c87abb49a1c3'),(1879,1,37,805,'Original39576259.jpg','image',2048,1366,1023061,NULL,NULL,NULL,'2022-09-13 01:53:23','2022-09-13 01:53:23','2022-09-13 01:53:23','af43e525-09c1-4079-8a5c-84b706e8728a'),(1880,1,37,805,'Original39576262-1.jpg','image',2048,1365,1041150,NULL,NULL,NULL,'2022-09-13 01:53:29','2022-09-13 01:53:29','2022-09-13 01:53:29','3217f726-f12f-45be-be22-90db28349034'),(1881,1,37,805,'Original39576377.jpg','image',2048,1365,953298,NULL,NULL,NULL,'2022-09-13 01:53:33','2022-09-13 01:53:34','2022-09-13 01:53:34','d9d5a8c7-06f6-409b-b236-ce317d53b86b'),(1882,1,37,805,'Original39576385.jpg','image',2048,1366,883037,NULL,NULL,NULL,'2022-09-13 01:53:39','2022-09-13 01:53:40','2022-09-13 01:53:40','b084d6cc-722c-4115-bf9e-911af4614b43'),(1883,1,37,805,'Original39576395.jpg','image',2048,1365,968839,NULL,NULL,NULL,'2022-09-13 01:53:47','2022-09-13 01:53:48','2022-09-13 01:53:48','c5072057-806e-406f-8a59-8b195c698245'),(1884,1,37,805,'Original39576398.jpg','image',2048,1365,682885,NULL,NULL,NULL,'2022-09-13 01:53:51','2022-09-13 01:53:52','2022-09-13 01:53:52','12d3a042-89c1-4dd4-b505-82d17341e89e'),(1885,1,37,805,'Original39576400.jpg','image',2048,1368,1715424,NULL,NULL,NULL,'2022-09-13 01:54:03','2022-09-13 01:54:03','2022-09-13 01:54:03','4f4b5909-199a-43e6-a437-f6cd3664c79e'),(1886,1,37,805,'Original39576401-1.jpg','image',2048,1366,882487,NULL,NULL,NULL,'2022-09-13 01:54:08','2022-09-13 01:54:08','2022-09-13 01:54:08','b7c2355c-ab18-4a68-99fc-25437411c30a'),(1887,1,37,805,'ibiza.png','image',595,595,89744,NULL,NULL,NULL,'2022-09-13 01:54:16','2022-09-13 01:54:16','2022-09-13 01:54:16','805a289d-308a-46af-bf9b-c9af3c8c80ea'),(1903,1,38,805,'greenland.png','image',595,595,86304,NULL,NULL,NULL,'2022-09-13 02:03:21','2022-09-13 02:03:21','2022-09-13 02:03:21','dc498607-b73c-49c3-a1a7-3719d60faf42'),(1904,1,38,805,'20190220_162155.jpg','image',2048,996,1382437,NULL,NULL,NULL,'2022-09-13 02:06:18','2022-09-13 02:06:19','2022-09-13 02:06:19','d0e111c7-be98-477c-a222-f139547fb5d5'),(1905,1,38,805,'20190220_162357.jpg','image',2048,996,1704581,NULL,NULL,NULL,'2022-09-13 02:06:27','2022-09-13 02:06:27','2022-09-13 02:06:27','53080e45-22b0-4182-9233-f413168f3c4d'),(1906,1,38,805,'20190220_162415.jpg','image',2048,996,1586480,NULL,NULL,NULL,'2022-09-13 02:06:35','2022-09-13 02:06:36','2022-09-13 02:06:36','7904eaff-e2a0-45c6-9fe9-e7965678b240'),(1907,1,38,805,'20190220_162449.jpg','image',2048,996,1537261,NULL,NULL,NULL,'2022-09-13 02:06:44','2022-09-13 02:06:44','2022-09-13 02:06:44','60dacba9-9243-4ccb-85e0-74a8d89545b8'),(1908,1,38,805,'20190220_162722.jpg','image',2048,996,1796187,NULL,NULL,NULL,'2022-09-13 02:06:54','2022-09-13 02:06:54','2022-09-13 02:06:54','8b85db32-7745-4591-99a6-82af5123d33f'),(1919,1,39,805,'iceland.png','image',595,595,89654,NULL,NULL,NULL,'2022-09-13 02:11:38','2022-09-13 02:11:38','2022-09-13 02:11:38','68c2bbcc-1331-408b-8c48-a3177c46ab00'),(1920,1,39,805,'20201206_114045.jpg','image',2048,1152,1206242,NULL,NULL,NULL,'2022-09-13 02:15:05','2022-09-13 02:15:06','2022-09-13 02:15:06','8cf4f461-6902-4719-9b17-a3c2bcf99eee'),(1921,1,39,805,'20201206_114124.jpg','image',2048,1152,1472226,NULL,NULL,NULL,'2022-09-13 02:15:13','2022-09-13 02:15:13','2022-09-13 02:15:13','8e7b5acb-8d1a-4b74-9a49-7c241bf72ebf'),(1922,1,39,805,'20201206_114229.jpg','image',2048,1152,1108983,NULL,NULL,NULL,'2022-09-13 02:15:22','2022-09-13 02:15:23','2022-09-13 02:15:23','4e8596fe-76ad-4a94-9bfb-2d81f344e315'),(1923,1,39,805,'20201206_114635.jpg','image',2048,1303,996336,NULL,NULL,NULL,'2022-09-13 02:15:27','2022-09-13 02:15:29','2022-09-13 02:15:29','e07ef358-4e9b-4ae6-8c62-2325e0e3c20a'),(1924,1,39,805,'20201206_114738.jpg','image',2048,1152,1179607,NULL,NULL,NULL,'2022-09-13 02:15:35','2022-09-13 02:15:35','2022-09-13 02:15:35','f8b2504d-c851-4ce6-b918-bad4c86422a4'),(1925,1,39,805,'20201206_114835.jpg','image',2048,1152,941641,NULL,NULL,NULL,'2022-09-13 02:15:42','2022-09-13 02:15:42','2022-09-13 02:15:42','d059d2d9-210b-4696-aa66-da19b24bea1a'),(1926,1,39,805,'Iceland-granny-flat-8.jpg','image',2048,1536,1786309,NULL,NULL,NULL,'2022-09-13 02:15:51','2022-09-13 02:15:51','2022-09-13 02:15:51','92c8844f-28c6-4de0-8292-06d585df5220'),(1927,1,39,805,'Iceland-granny-flat-completed-0.jpg','image',2048,1365,799325,NULL,NULL,NULL,'2022-09-13 02:15:56','2022-09-13 02:15:58','2022-09-13 02:15:58','185922b7-0112-4302-a87b-de56aea24c02'),(1928,1,39,805,'Iceland-granny-flat-completed-1.jpg','image',2048,1365,670002,NULL,NULL,NULL,'2022-09-13 02:16:02','2022-09-13 02:16:02','2022-09-13 02:16:02','29181611-6124-4522-8d0b-c6b238193406'),(1929,1,39,805,'Iceland-granny-flat-completed-2.jpg','image',2048,1365,914757,NULL,NULL,NULL,'2022-09-13 02:16:06','2022-09-13 02:16:07','2022-09-13 02:16:07','5834022b-a26c-489b-984d-2dcf392e2837'),(1930,1,39,805,'Iceland-granny-flat-completed-4.jpg','image',2048,1365,940363,NULL,NULL,NULL,'2022-09-13 02:16:12','2022-09-13 02:16:12','2022-09-13 02:16:12','716f0ea7-820e-4a7f-bd88-38cbdfb82b52'),(1931,1,39,805,'Iceland-granny-flat-completed-5.jpg','image',2048,1365,1116123,NULL,NULL,NULL,'2022-09-13 02:16:19','2022-09-13 02:16:19','2022-09-13 02:16:19','64d8530c-89d7-4598-af9f-c788dfe87fa2'),(1932,1,39,805,'Iceland-granny-flat-completed-6.jpg','image',2048,1365,1242345,NULL,NULL,NULL,'2022-09-13 02:16:25','2022-09-13 02:16:26','2022-09-13 02:16:26','eb69f1a7-64b6-4f07-a72f-dcd320f6d1ba'),(1933,1,39,805,'Iceland-granny-flat-completed-7.jpg','image',2048,1365,806994,NULL,NULL,NULL,'2022-09-13 02:16:31','2022-09-13 02:16:31','2022-09-13 02:16:31','0fa8371f-4971-489e-beeb-b544171afa21'),(1934,1,39,805,'Iceland-granny-flat-completed-8.jpg','image',2048,1365,689952,NULL,NULL,NULL,'2022-09-13 02:16:34','2022-09-13 02:16:36','2022-09-13 02:16:36','59c370b9-b01b-4046-95f5-9ac572cd8bd8'),(1945,1,39,805,'20190222_120835-2.jpg','image',2048,1152,1222304,NULL,NULL,NULL,'2022-09-13 02:35:27','2022-09-13 02:35:28','2022-09-13 02:35:28','0b7f92de-88ab-4f3e-aca3-20b930ab78a8'),(1946,1,39,805,'20190222_121036-suzie.jpg','image',2048,1152,1023526,NULL,NULL,NULL,'2022-09-13 02:35:37','2022-09-13 02:35:37','2022-09-13 02:35:37','1e011853-52a6-4a41-b874-6145f89ab5b2'),(1947,1,39,805,'20190222_124346-suzie.jpg','image',2048,1152,1188859,NULL,NULL,NULL,'2022-09-13 02:35:45','2022-09-13 02:35:45','2022-09-13 02:35:45','9ab27add-9496-46e0-97dc-d74f3dff089d'),(1948,1,39,805,'Madeira-1B-living-room-edit.jpg','image',2048,1536,903633,NULL,NULL,NULL,'2022-09-13 02:35:49','2022-09-13 02:35:50','2022-09-13 02:35:50','7f18672c-1677-4c03-b68f-a179670842a1'),(1949,1,39,805,'madirav0.png','image',595,595,52070,NULL,NULL,NULL,'2022-09-13 02:35:52','2022-09-13 02:35:52','2022-09-13 02:35:52','b5f7d474-a6d4-4485-bfcd-605cb3714559'),(1950,1,39,805,'Madeira-1B-outdoor-area-edit.jpg','image',2048,1536,1255502,NULL,NULL,NULL,'2022-09-13 02:35:59','2022-09-13 02:35:59','2022-09-13 02:35:59','cf78bc16-cf8d-4000-b260-b98c90d149de'),(1966,1,40,805,'madirav1.png','image',595,595,56020,NULL,NULL,NULL,'2022-09-13 02:43:58','2022-09-13 02:43:58','2022-09-13 02:43:58','159613aa-ff41-4b72-8ca9-cb9928ab9e70'),(1967,1,40,805,'20191203_161437.jpg','image',2048,1152,1280232,NULL,NULL,NULL,'2022-09-13 02:46:52','2022-09-13 02:46:53','2022-09-13 02:46:53','be1bb5f2-6829-4318-ae70-9d9385aa3ec8'),(1968,1,40,805,'20191205_082853.jpg','image',2048,1152,1175167,NULL,NULL,NULL,'2022-09-13 02:47:01','2022-09-13 02:47:01','2022-09-13 02:47:01','52b303c3-a427-46ae-821d-6c9a0da89679'),(1969,1,40,805,'20191205_082933.jpg','image',2048,1152,1263144,NULL,NULL,NULL,'2022-09-13 02:47:09','2022-09-13 02:47:09','2022-09-13 02:47:09','9aac0e67-5d2e-47a5-8390-dd73333ed96c'),(1970,1,40,805,'20200316_162312-bedroom.jpg','image',2048,1227,1009258,NULL,NULL,NULL,'2022-09-13 02:47:15','2022-09-13 02:47:15','2022-09-13 02:47:15','4c015932-dd98-4e76-b38b-119098129688'),(1971,1,40,805,'20220224_111352-persp.jpg','image',2048,1152,1162186,NULL,NULL,NULL,'2022-09-13 02:47:22','2022-09-13 02:47:22','2022-09-13 02:47:22','07efc286-7ba8-4998-a7dc-0b9def766009'),(1972,1,40,805,'20220224_111422-persp.jpg','image',2048,1152,1363333,NULL,NULL,NULL,'2022-09-13 02:47:29','2022-09-13 02:47:30','2022-09-13 02:47:30','21d0c7ee-3f8a-4391-b7e7-c4d4634ebd96'),(1973,1,40,805,'Madeira-2-bedroom-front-Canberra.jpg','image',2048,1152,1005098,NULL,NULL,NULL,'2022-09-13 02:47:35','2022-09-13 02:47:36','2022-09-13 02:47:36','f64b0f56-2f76-47d5-90ba-036457989c02'),(1974,1,40,805,'Madeira-2-bedroom-verandah-Canberra.jpg','image',2048,1152,806928,NULL,NULL,NULL,'2022-09-13 02:47:43','2022-09-13 02:47:43','2022-09-13 02:47:43','b6d20394-a233-417c-9a55-1c9f31e6d231'),(1985,1,41,805,'madirav2.png','image',595,595,43461,NULL,NULL,NULL,'2022-09-13 02:57:16','2022-09-13 02:57:16','2022-09-13 02:57:16','02054ad6-3fb0-4ba7-8eb6-05a2f08dade1'),(1986,1,41,805,'Asset-1@3x.png','image',1826,1028,1188866,NULL,NULL,NULL,'2022-09-13 02:58:18','2022-09-13 02:58:18','2022-09-13 02:58:18','6a894454-c2c4-426d-82d1-14912c074f0a'),(1987,1,41,805,'b@3x.png','image',857,482,296834,NULL,NULL,NULL,'2022-09-13 02:58:20','2022-09-13 02:58:20','2022-09-13 02:58:20','d12fdc07-4fa6-4a7e-b842-10a6822094bc'),(1988,1,41,805,'g@3x.png','image',857,483,358826,NULL,NULL,NULL,'2022-09-13 02:59:02','2022-09-13 02:59:02','2022-09-13 02:59:02','1ffde3b8-7e94-47d9-bd98-53fedccf9471'),(1999,1,42,805,'MALTA.png','image',595,595,74153,NULL,NULL,NULL,'2022-09-13 03:08:44','2022-09-13 03:08:44','2022-09-13 03:08:44','c505dbe1-3505-4c1e-bff7-01d06167be6b'),(2000,1,42,805,'Asset-1@3x.jpg','image',2048,1155,2073903,NULL,NULL,NULL,'2022-09-13 03:13:02','2022-09-13 03:13:02','2022-09-13 03:13:02','ab97c61b-3027-4153-a08d-138e217aa014'),(2011,1,43,805,'Asset-1@3x.jpg','image',2048,1153,1693903,NULL,NULL,NULL,'2022-09-13 03:20:14','2022-09-13 03:20:14','2022-09-13 03:20:14','7a6a8d30-14e1-4b82-91ac-e7fd38cd9850'),(2012,1,43,805,'capri.png','image',595,595,82344,NULL,NULL,NULL,'2022-09-13 03:20:22','2022-09-13 03:20:22','2022-09-13 03:20:22','e45342c5-a93c-4c30-88f4-c261895ed1ea'),(2023,1,44,805,'cyprus.png','image',595,595,88974,NULL,NULL,NULL,'2022-09-13 03:26:22','2022-09-13 03:26:22','2022-09-13 03:26:22','d066e842-72d0-4bf5-9e40-530fc908436e'),(2024,1,44,805,'20170212_105733_2-1.jpg','image',2048,1152,1185161,NULL,NULL,NULL,'2022-09-13 03:31:32','2022-09-13 03:31:33','2022-09-13 03:31:33','5ace1033-5e58-4884-8224-b63205e54af7'),(2025,1,44,805,'20170710_092132.jpg','image',2048,1152,1547516,NULL,NULL,NULL,'2022-09-13 03:31:42','2022-09-13 03:31:42','2022-09-13 03:31:42','3ceebf6a-9ab5-4109-b5cf-3f6820c25618'),(2026,1,44,805,'20170710_094334.jpg','image',2048,1152,2099598,NULL,NULL,NULL,'2022-09-13 03:31:53','2022-09-13 03:31:53','2022-09-13 03:31:53','e8f25791-d9cc-4abb-9bcc-193870d73535'),(2027,1,44,805,'20171111_204944.jpg','image',2048,1152,1006484,NULL,NULL,NULL,'2022-09-13 03:31:59','2022-09-13 03:32:01','2022-09-13 03:32:01','6e9516df-5dca-4598-a798-d6bc985b79b5'),(2028,1,44,805,'20171111_205853.jpg','image',2048,1152,1349587,NULL,NULL,NULL,'2022-09-13 03:32:06','2022-09-13 03:32:07','2022-09-13 03:32:07','33297ce7-7202-4883-9951-b1b0255efdc6'),(2029,1,44,805,'20190411_123728.jpg','image',2048,1152,1441909,NULL,NULL,NULL,'2022-09-13 03:32:16','2022-09-13 03:32:17','2022-09-13 03:32:17','77206446-65c4-449a-aa57-4dc0eb86e166'),(2030,1,44,805,'cyprus-canberra.jpg','image',2048,1360,1353229,NULL,NULL,NULL,'2022-09-13 03:32:29','2022-09-13 03:32:30','2022-09-13 03:32:30','fe138210-63c3-4af3-b9cb-3f3179db3636'),(2036,1,1,805,'20200215_134925.jpg','image',2048,1152,1401745,NULL,NULL,NULL,'2022-09-13 03:35:54','2022-09-13 03:35:54','2022-09-13 03:35:54','d9ab6188-b6fa-47d9-aa75-919e6a18d5f9'),(2067,1,24,805,'P4110053-R.jpg','image',2048,2048,790491,NULL,NULL,NULL,'2022-09-13 03:46:58','2022-09-13 03:46:58','2022-09-13 03:46:58','28dad169-13bf-45c1-abdc-f33f56b7e6e4'),(2068,1,24,805,'granny-flat-Cyprus-building-day-4.jpg','image',2048,2048,1294166,NULL,NULL,NULL,'2022-09-13 03:47:04','2022-09-13 03:47:05','2022-09-13 03:47:05','77cde2a9-ddb1-4d98-8830-36b4094922d9'),(2069,1,24,805,'granny-flat-Cyprus-building-day-2.jpg','image',2048,2048,1293502,NULL,NULL,NULL,'2022-09-13 03:47:10','2022-09-13 03:47:11','2022-09-13 03:47:11','d41d8a56-cb8e-430d-907c-a3e5054b3072'),(2078,1,24,805,'Iceland-granny-flat-completed-1.jpg','image',2048,2048,1218521,NULL,NULL,NULL,'2022-09-13 03:48:31','2022-09-13 03:48:31','2022-09-13 03:48:31','7b9ac1a5-b82e-4368-b512-9b4c292bdd67'),(2083,1,24,805,'Photo-15-2-17-11-05-15-am-2.jpg','image',2048,2048,902711,NULL,NULL,NULL,'2022-09-13 03:49:51','2022-09-13 03:49:52','2022-09-13 03:49:52','2d24231d-6254-4624-ab92-69078da98f85'),(2084,1,24,805,'P4110053-R_2022-09-13-035033_ibiz.jpg','image',2048,2048,790491,NULL,NULL,NULL,'2022-09-13 03:50:37','2022-09-13 03:50:37','2022-09-13 03:50:37','d7050560-b943-48d6-bb5b-8861e117291a'),(2089,1,24,805,'Sicilia-backyard-cabin-IKEA-shared-dining-experience.jpg','image',2048,2048,1124888,NULL,NULL,NULL,'2022-09-13 03:50:47','2022-09-13 03:50:47','2022-09-13 03:50:47','f97e918c-13b5-4ce6-a58a-53c8fe39a220'),(2094,1,1,805,'DSC01769-2-min.jpg','image',2048,1536,971284,NULL,NULL,NULL,'2022-09-13 03:56:54','2022-09-13 03:56:54','2022-09-13 03:56:54','984746ca-a9ae-45cf-8ed8-c37603916672'),(2095,1,29,805,'2-Area-cropped.jpg','image',1738,2048,1751905,NULL,NULL,NULL,'2022-09-13 04:00:44','2022-09-13 04:00:45','2022-09-13 04:00:45','8cee4b3f-e7c6-48b0-9437-926eef00b40d'),(2096,1,29,805,'Original39576262-1.jpg','image',2021,2048,1538303,NULL,NULL,NULL,'2022-09-13 04:00:54','2022-09-13 04:00:55','2022-09-13 04:00:55','e22b815b-a218-486c-bc54-e69dee5c9286'),(2097,1,29,805,'2-Area-cropped_2022-09-13-040059_bqgw.jpg','image',1738,2048,1751905,NULL,NULL,NULL,'2022-09-13 04:01:05','2022-09-13 04:01:05','2022-09-13 04:01:05','4f9f394d-3c6e-4e94-a6cc-2e9b4271e8a2'),(2098,1,29,805,'Original39576262-1-2.jpg','image',1854,2048,1419197,NULL,NULL,NULL,'2022-09-13 04:01:49','2022-09-13 04:01:50','2022-09-13 04:01:50','676eae2f-c023-46b0-9f64-2d2d623e244f'),(2099,1,45,805,'20201206_114229.jpg','image',1989,2048,1608696,NULL,NULL,NULL,'2022-09-13 04:04:35','2022-09-13 04:04:36','2022-09-13 04:04:36','c6fee32c-a456-4f4b-b9b9-cbcd9ed5d1a7'),(2112,1,1,805,'DSC01769-3-min.jpg','image',1851,2048,863997,NULL,NULL,NULL,'2022-09-13 04:08:10','2022-09-13 04:08:11','2022-09-13 04:08:11','e4683eaf-eac1-41ac-ac20-f07d4cc0afdc'),(2143,1,1,805,'Original39576240-1.jpg','image',2048,1365,714312,NULL,NULL,NULL,'2022-09-15 21:55:51','2022-09-15 21:55:51','2022-09-15 21:55:51','04d48526-f486-4ec7-9de7-9f7354ba3ab6'),(2157,1,45,805,'20151111_100933.jpg','image',2048,2048,2016772,NULL,NULL,NULL,'2022-09-15 22:08:46','2022-09-15 22:08:46','2022-09-15 22:08:46','ade8a9e0-7127-4774-be61-bb1bb4d5b183'),(2187,1,45,805,'Asset-1@3x.jpg','image',2048,2048,1483424,NULL,NULL,NULL,'2022-09-15 22:21:36','2022-09-15 22:21:37','2022-09-15 22:21:37','4cc91b61-196c-40c2-a6d0-ea4c04aa477f'),(2206,1,20,805,'Original39576385.jpg','image',2048,2048,1194001,NULL,NULL,NULL,'2022-09-15 22:26:05','2022-09-15 22:26:05','2022-09-15 22:26:05','2220c203-52b9-4b57-b693-75a1a95c0976'),(2207,1,20,805,'20190220_162722-min.jpg','image',2048,2048,801658,NULL,NULL,NULL,'2022-09-15 22:26:32','2022-09-15 22:26:33','2022-09-15 22:26:33','851a27f2-f0bf-4226-9fbd-91b0b79214b1'),(2208,1,1,805,'20190222_121036-suzie.jpg','image',2048,1152,1399633,NULL,NULL,NULL,'2022-09-15 22:28:48','2022-09-15 22:28:49','2022-09-15 22:28:49','b61f3210-5fc2-4282-bf4a-c8508c0471b2'),(2376,1,45,805,'Untitled-design-7.png','image',940,788,745373,NULL,NULL,NULL,'2022-09-29 02:24:36','2022-09-29 02:24:36','2022-09-29 02:24:36','c72aa2e2-d66b-454c-a18d-516d465b55ce'),(2402,1,45,805,'Untitled-1238-×-1223-px.png','image',1238,1223,1488639,NULL,NULL,NULL,'2022-09-29 03:16:47','2022-09-29 03:16:47','2022-09-29 03:16:47','126349e1-ce11-4bab-b13f-b831549c0171'),(2425,1,45,805,'received_1826772273999682.jpg','image',2048,2048,1623902,NULL,NULL,NULL,'2022-10-18 01:24:57','2022-10-18 01:24:58','2022-10-18 01:24:58','58b23b94-167a-466c-8160-68980c2e9993'),(2562,2,53,805,'Catalogue-Image.png','image',1001,1334,1594694,NULL,NULL,NULL,'2022-10-19 03:48:14','2022-10-19 03:48:14','2022-10-19 23:11:04','b0a94dee-bf7e-4942-b623-cb3bea1ea8cd'),(2564,1,23,805,'20220610_141758.jpg','image',2048,1152,1603505,NULL,NULL,NULL,'2022-10-19 21:56:26','2022-10-19 21:56:26','2022-10-19 21:56:26','986db0ba-0eb2-4529-ae37-1d5c600b8403'),(2565,1,23,805,'20220610_142051.jpg','image',2048,1152,1908999,NULL,NULL,NULL,'2022-10-19 21:57:05','2022-10-19 21:57:05','2022-10-19 21:57:05','772eeaa4-4242-43ef-962c-8b1c4b0a780d'),(2566,1,23,805,'20220610_142051-2.jpg','image',1152,2048,1370445,NULL,NULL,NULL,'2022-10-19 22:00:06','2022-10-19 22:00:07','2022-10-19 22:00:07','348cc223-b1e9-4bf3-a68b-aa994f1c56d8'),(2567,1,52,805,'20220610_141758.jpg','image',2048,1152,1603505,NULL,NULL,NULL,'2022-10-19 22:02:41','2022-10-19 22:02:42','2022-10-19 22:02:42','5a4590ce-638e-497e-b0ca-33c3cb71d020'),(2568,1,52,805,'Picture2-3.jpg','image',2048,2048,1663927,NULL,NULL,NULL,'2022-10-19 22:04:45','2022-10-19 22:04:45','2022-10-19 22:04:45','1b1259ec-0e4e-4f1b-b9f6-e539dd1f6237'),(2569,1,52,805,'20220610_142245-2.jpg','image',2048,1152,1487507,NULL,NULL,NULL,'2022-10-19 22:05:45','2022-10-19 22:05:45','2022-10-19 22:05:45','3cc84748-1cbf-4921-912e-05ab1873ea06'),(2570,1,52,805,'Picture3-3.jpg','image',2048,1152,1548623,NULL,NULL,NULL,'2022-10-19 22:05:59','2022-10-19 22:06:00','2022-10-19 22:06:00','96f4352e-ecf0-4ec7-a352-c5826bd79c74'),(2571,1,52,805,'20220610_141844-2.jpg','image',2048,2048,1307318,NULL,NULL,NULL,'2022-10-19 22:06:15','2022-10-19 22:06:15','2022-10-19 22:06:15','dc04070a-0efe-4c8f-b195-fc66931bac36'),(2580,2,53,805,'The-Kitset-Builds.png','image',1414,2000,1041208,NULL,NULL,NULL,'2022-10-19 22:16:15','2022-10-19 22:16:15','2022-10-19 23:11:04','3e5c884f-2665-4474-94a8-6087093cbaf9'),(2602,6,54,805,'android-icon-36x36.png','image',36,36,1537,NULL,NULL,NULL,'2022-10-26 20:09:43','2022-10-26 20:09:43','2022-10-26 20:09:43','cb478129-2aad-4ed9-a161-17cac7d6572d'),(2603,6,54,805,'android-icon-48x48.png','image',48,48,2038,NULL,NULL,NULL,'2022-10-26 20:10:38','2022-10-26 20:10:42','2022-10-26 20:10:42','d33feaf8-5712-4289-a0a0-46383f447613'),(2604,6,54,805,'android-icon-72x72.png','image',72,72,2907,NULL,NULL,NULL,'2022-10-26 20:11:27','2022-10-26 20:11:27','2022-10-26 20:11:27','b866ff10-067a-4e17-b654-dd6a4c165f39'),(2605,6,54,805,'android-icon-96x96.png','image',96,96,3937,NULL,NULL,NULL,'2022-10-26 20:11:28','2022-10-26 20:11:28','2022-10-26 20:11:28','ce594859-9d04-495e-89db-ce4bda924df4'),(2606,6,54,805,'android-icon-144x144.png','image',144,144,6560,NULL,NULL,NULL,'2022-10-26 20:11:29','2022-10-26 20:11:29','2022-10-26 20:11:29','3d503e18-d7b9-4e71-aa57-0697c4613666'),(2607,6,54,805,'android-icon-192x192.png','image',192,192,8739,NULL,NULL,NULL,'2022-10-26 20:11:30','2022-10-26 20:11:30','2022-10-26 20:11:30','57e20ca0-ca70-4262-afc3-8e9fd7c6035c'),(2608,6,54,805,'apple-icon.png','image',192,192,8739,NULL,NULL,NULL,'2022-10-26 20:11:30','2022-10-26 20:11:30','2022-10-26 20:11:30','369c1507-8912-43a1-8c21-fab8a2fed9bf'),(2609,6,54,805,'apple-icon-57x57.png','image',57,57,2398,NULL,NULL,NULL,'2022-10-26 20:11:31','2022-10-26 20:11:31','2022-10-26 20:11:31','1899f88f-881e-4c69-a0c8-fd1f60a69a3c'),(2610,6,54,805,'apple-icon-60x60.png','image',60,60,2488,NULL,NULL,NULL,'2022-10-26 20:11:32','2022-10-26 20:11:32','2022-10-26 20:11:32','bbf56a6d-9919-42a7-985e-28c72f757c10'),(2611,6,54,805,'apple-icon-72x72.png','image',72,72,2907,NULL,NULL,NULL,'2022-10-26 20:11:32','2022-10-26 20:11:32','2022-10-26 20:11:32','b047a6a2-e1ee-4430-b63d-e331ed736dc2'),(2612,6,54,805,'apple-icon-76x76.png','image',76,76,3063,NULL,NULL,NULL,'2022-10-26 20:11:33','2022-10-26 20:11:33','2022-10-26 20:11:33','46fade42-d7a2-4fdd-87f6-b68aa4ad79bd'),(2613,6,54,805,'apple-icon-114x114.png','image',114,114,4821,NULL,NULL,NULL,'2022-10-26 20:11:34','2022-10-26 20:11:34','2022-10-26 20:11:34','ece8bd33-7d65-4d1d-86f5-07c0455f4340'),(2614,6,54,805,'apple-icon-120x120.png','image',120,120,5161,NULL,NULL,NULL,'2022-10-26 20:11:34','2022-10-26 20:11:34','2022-10-26 20:11:34','17257954-f2ad-45c8-b4d8-074a078847c7'),(2615,6,54,805,'apple-icon-144x144.png','image',144,144,6560,NULL,NULL,NULL,'2022-10-26 20:11:35','2022-10-26 20:11:35','2022-10-26 20:11:35','c3bd02d0-3f52-457f-9875-319b41680c46'),(2616,6,54,805,'apple-icon-152x152.png','image',152,152,6998,NULL,NULL,NULL,'2022-10-26 20:11:36','2022-10-26 20:11:36','2022-10-26 20:11:36','e04730d9-ea57-4518-bb3b-3038ffb97cc9'),(2617,6,54,805,'apple-icon-180x180.png','image',180,180,8815,NULL,NULL,NULL,'2022-10-26 20:11:36','2022-10-26 20:11:36','2022-10-26 20:11:36','69c83866-d715-432e-95e5-79dac536cac2'),(2618,6,54,805,'apple-icon-precomposed.png','image',192,192,8739,NULL,NULL,NULL,'2022-10-26 20:11:37','2022-10-26 20:11:37','2022-10-26 20:11:37','e31d0f88-64aa-4fc4-ab6f-10d3a812a728'),(2619,6,54,805,'favicon-16x16.png','image',16,16,1129,NULL,NULL,NULL,'2022-10-26 20:17:30','2022-10-26 20:17:30','2022-10-26 20:17:30','35238a16-f32d-48e0-8da7-124358cd4a6d'),(2620,6,54,805,'favicon-32x32.png','image',32,32,1502,NULL,NULL,NULL,'2022-10-26 20:17:31','2022-10-26 20:17:31','2022-10-26 20:17:31','00320a45-8414-468d-9214-04090727da21'),(2621,6,54,805,'favicon-96x96.png','image',96,96,3937,NULL,NULL,NULL,'2022-10-26 20:17:32','2022-10-26 20:17:32','2022-10-26 20:17:32','6703402a-c58f-445f-a796-d0fb9b23e76d'),(2622,6,54,805,'manifest.json','json',NULL,NULL,720,NULL,NULL,NULL,'2022-10-26 20:17:32','2022-10-26 20:17:32','2022-10-26 20:17:32','67760a43-f166-4ed7-be42-47473c5e5b61'),(2623,6,54,805,'ms-icon-70x70.png','image',70,70,2798,NULL,NULL,NULL,'2022-10-26 20:17:33','2022-10-26 20:17:33','2022-10-26 20:17:33','cc4ac1bd-4129-47bb-99de-c1a3988b0132'),(2624,6,54,805,'ms-icon-144x144.png','image',144,144,6560,NULL,NULL,NULL,'2022-10-26 20:17:34','2022-10-26 20:17:34','2022-10-26 20:17:34','86ef0320-0951-4b0e-9e3a-40d7f834ce26'),(2625,6,54,805,'ms-icon-150x150.png','image',150,150,6945,NULL,NULL,NULL,'2022-10-26 20:17:34','2022-10-26 20:17:34','2022-10-26 20:17:34','ff86d43f-1ef0-4ae7-a011-6cfb15cc7fa5'),(2626,6,54,805,'ms-icon-310x310.png','image',310,310,17788,NULL,NULL,NULL,'2022-10-26 20:17:35','2022-10-26 20:17:35','2022-10-26 20:17:35','09249449-e963-4555-9a44-e4ad6420e71c');
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `craft_blitz_recommendations`
--

set autocommit=0;
INSERT INTO `craft_blitz_recommendations` VALUES (1,'26','','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-29 23:53:53','2021-08-29 23:53:53','1575b4c8-faeb-42ae-a1ff-a222ae31fda3'),(2,'69','','Eager-load the `Fallback Person` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Person` field.<br>`{% set entries = craft.entries.with([\'fallbackPerson\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-29 23:53:53','2021-08-29 23:53:53','a7523992-8cb9-4a15-be93-f556e5365a0d'),(3,'46','__string_template__94428858c408f819d7093e4d8f4f6129c56c3091d7421ddf891fef6c95a93df5','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:57','2022-10-20 01:36:57','c53fd521-a87c-49f1-80b7-53fae9db1cad'),(4,'46','__string_template__848bad9471ee193a4a07724f452091c5e577b973df0bf9149afd54f658976954','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','b0d0f799-98a9-46ef-baae-52cece69547e'),(5,'46','__string_template__3a6ee5a770af415979d3efbf2a4d5c9b12b89b4050ac2a62c24bd5b252b486fa','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','115e08f1-a128-47f2-86eb-9e2d24456c5b'),(6,'46','__string_template__cea23eb16a625f8cd774ab3808b2109fda552a18db1cf7257981b967dc960c60','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','440cec4b-e5ea-4060-9781-da21e8292503'),(7,'46','__string_template__29f213775d19da5373d0bdbc76a68eb6df9b91f04e1cf469bf7c4d713735c2d3','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','462413d1-36d5-4c3d-96d0-eb6d89df40bd'),(8,'46','__string_template__1f320dc823952112872331eeeb34028b13dbfb829a21d030c190fb54a5e1c3c3','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','e5deef53-c0f5-4127-a0f3-ce2e0a0d4402'),(9,'46','__string_template__350ea83cc290003590de642edda4e23a0379167e6efa18526a0a18742c1be9a2','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','b6509bfe-3dbc-4fbd-94aa-a395b2871c91'),(10,'46','__string_template__3fd7d09674738059cc5f2b7c563de2d21afc44bb3cfc79455ad9f5bc4ecc788f','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','51b9ac4d-a812-451e-9b1e-00b76e568b73'),(11,'46','__string_template__cd01619fd9ab38159799b65e2642f2430e579016ffb9a3867b27576af82881f3','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-20 01:36:56','2022-10-20 01:36:56','062daf76-c5f0-4c47-a174-df977173596f'),(15,'46','__string_template__522080a933cd0afbae3a7bd80e0a14eb98c6fdae90a57cdcb9d8e38241d029ea','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:55:09','2021-08-30 01:55:09','442b0916-dd6f-4ebf-b9f7-5c4075d08cc5'),(22,'46','/Users/nick/Code/light-breeze/templates/skeletons/internalPage.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:54:26','2021-08-30 01:54:26','b48643d6-e32a-4383-bc5d-d81bdca87ecc'),(23,'26','/Users/nick/Code/light-breeze/templates/cards/generic.twig','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:54:26','2021-08-30 01:54:26','fe41c9a8-aa76-4a9c-ba5e-65153426d80f'),(24,'26','/Users/nick/Code/light-breeze/templates/partials/card.twig','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:55:09','2021-08-30 01:55:09','b223a51e-b55a-4f0a-ae67-cb3a1c7b5c71'),(196,'47','/Users/nick/Code/light-breeze/templates/cards/article.twig','Eager-load the `Category` field.','Use the `with` parameter to eager-load sub-elements of the `Category` field.<br>`{% set entries = craft.entries.with([\'newsCategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:55:09','2021-08-30 01:55:09','f0607fe0-a449-48f9-a27a-65510d201e11'),(207,'47','/Users/nick/Code/light-breeze/templates/sections/news/newsDetail.twig','Eager-load the `Category` field.','Use the `with` parameter to eager-load sub-elements of the `Category` field.<br>`{% set entries = craft.entries.with([\'newsCategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2021-08-30 01:53:19','2021-08-30 01:53:19','440e7cd6-b962-44f9-a402-bbe0b006703a'),(1333,'26','__string_template__99b04ef2ea1df4f48cecce4a8df3de88a14c700be311c132eed922c4f8d1ec39','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:20:50','2022-10-27 19:20:50','2f82b92d-9907-4bc8-a921-85dc0896d706'),(1334,'26','__string_template__5603a459e3d9826d7ec37ecb1942e8aff01d35f306d87be8e0bffe6017e04d1a','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','bc3a97f4-281e-439f-be0b-1a86ec43de3c'),(1335,'26','__string_template__73830c7454952ff669173f1b7f366f19bdd8367089f137297ab8501c19d5b649','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','29ac68b5-73c2-4580-b8d9-6450a8a3bb5a'),(1336,'26','__string_template__152903f7a839af0d14cfc6b95bdec64fb1bd5a6ac2dd3ca07d9fa877f110ee75','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','bb4ee455-8a28-4310-9539-2220d85fafaf'),(1337,'26','__string_template__39539b216060f42908fb93ea0d739f8d3d5249df67cd183b8a3d97644838a21b','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','ab89105a-84df-47e3-b39d-f7957ecadcd9'),(1338,'26','__string_template__31d30e467f914dc3c3e241310d36612984fd6ab60d38b09fea0db7583f3c0486','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','03ddb77a-de59-4fee-aff1-5e4636594a1e'),(1339,'26','__string_template__a864b8d7506e7279f2082ace28e737ee758cab976bc2ffa3600506f77b2dc71f','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','8774a167-6326-48b9-aefd-64b32f625451'),(1340,'26','__string_template__ff21b4ebb9ed4d2f91c643542031c1f7db5fe44082d27fb71071c5dfb1dcdd8a','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','8123089f-2b94-4463-9114-bff6ff1efd17'),(1341,'26','__string_template__83b05a11ee3f954dd86b6fecbf3fde2e25a8fc6880a414ce122b45392ba1e745','Eager-load the `Fallback Banner` field.','Use the `with` parameter to eager-load sub-elements of the `Fallback Banner` field.<br>`{% set entries = craft.entries.with([\'fallbackBanner\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 10:02:39','2022-10-27 10:02:39','a1bb2466-911e-4a80-b141-01fb23b58cf1'),(2374,'46','/var/www/html/templates/partials/_ourProcess.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:03:30','2022-07-20 00:03:30','1557046b-0dbb-461a-ad13-ae419c367531'),(5944,'46','/var/www/html/templates/partials/_whyMopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:03:30','2022-07-20 00:03:30','2b747a38-a54a-4d0a-9b44-cf409f0064d8'),(7066,'46','/var/www/html/templates/partials/_caseStudies.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:03:30','2022-07-20 00:03:30','51ddefc5-8332-414e-88e5-339f43a3864b'),(10477,'46','/var/www/html/templates/sections/_ourProcess.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:11:07','2022-07-20 00:11:07','1729a378-eef4-40ff-aa0e-26bf0d7195e1'),(10478,'46','/var/www/html/templates/sections/_whyMopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:11:07','2022-07-20 00:11:07','accef1fa-f794-4a0b-81ea-e3a9a4ec9342'),(10479,'46','/var/www/html/templates/sections/_caseStudies.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-20 00:11:07','2022-07-20 00:11:07','590e6721-b0cc-4092-b27a-512fd41d854d'),(10490,'46','/var/www/html/templates/partials/pageSections/_ourProcess.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-21 22:39:20','2022-07-21 22:39:20','bac15545-f034-433b-b841-aee0f27115fa'),(10491,'46','/var/www/html/templates/partials/pageSections/_whyMopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-21 23:17:02','2022-07-21 23:17:02','9cbaa734-84d3-4332-bb6c-35503f8e23ca'),(10492,'46','/var/www/html/templates/partials/pageSections/_caseStudies.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:59:20','2022-07-25 21:59:20','7b7331d5-35f9-47b6-8ab7-03b9ac4f0926'),(10882,'76','/var/www/html/templates/pages/contact-us.twig','Eager-load the `Opening Hours` field.','Use the `with` parameter to eager-load sub-elements of the `Opening Hours` field.<br>`{% set entries = craft.entries.with([\'openingHours\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-12 03:31:26','2022-08-12 03:31:26','94893a48-3b1a-4094-acdb-5cae01bae9ef'),(11467,'95','/var/www/html/templates/index.twig','Eager-load the `Our Process Slides` field.','Use the `with` parameter to eager-load sub-elements of the `Our Process Slides` field.<br>`{% set entries = craft.entries.with([\'ourProcessSlides\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-21 23:11:36','2022-07-21 23:11:36','ceba8bd4-8fc2-4b77-a320-bfddd63f7e69'),(11470,'95','/var/www/html/templates/partials/pageSections/_ourProcess.twig','Eager-load the `Our Process Slides` field.','Use the `with` parameter to eager-load sub-elements of the `Our Process Slides` field.<br>`{% set entries = craft.entries.with([\'ourProcessSlides\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-27 01:30:08','2022-07-27 01:30:08','61fbccda-5bce-4f64-84e2-5d8f2202f937'),(11512,'97','/var/www/html/templates/partials/pageSections/_ourProcess.twig','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-27 01:30:08','2022-07-27 01:30:08','89f274bc-c372-4d5a-8ec3-0b82ef2892cc'),(11517,'91','/var/www/html/templates/partials/pageSections/_whyMopanui.twig','Eager-load the `Why Mopanui Slides` field.','Use the `with` parameter to eager-load sub-elements of the `Why Mopanui Slides` field.<br>`{% set entries = craft.entries.with([\'whyMopanuiSlides\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-04 01:14:54','2022-08-04 01:14:54','133ebd2f-afff-4f76-bd1b-228a8aadabc9'),(11518,'92','/var/www/html/templates/partials/pageSections/_whyMopanui.twig','Eager-load the `Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Featured Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-04 01:14:54','2022-08-04 01:14:54','28b55a71-ff53-4f78-a0f6-3a5b13c211c8'),(11709,'46','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:18:57','2022-08-15 20:18:57','17370efe-cda6-4c07-8bc1-d06f262cc5e4'),(11925,'101','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:18:57','2022-08-15 20:18:57','cd66da86-1978-4906-a8f2-9559905c85c8'),(11954,'103','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Article Images` field.','Use the `with` parameter to eager-load sub-elements of the `Article Images` field.<br>`{% set entries = craft.entries.with([\'images\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:18:57','2022-08-15 20:18:57','ac524806-0941-4732-80bf-563f7796bff8'),(11962,'105','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Article Image 2` field.','Use the `with` parameter to eager-load sub-elements of the `Article Image 2` field.<br>`{% set entries = craft.entries.with([\'articleImage2\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-24 21:07:04','2022-07-24 21:07:04','9e8994ac-305f-432f-8a54-2a86c1896886'),(12902,'109','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Values` field.','Use the `with` parameter to eager-load sub-elements of the `Values` field.<br>`{% set entries = craft.entries.with([\'values\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 08:55:15','2022-07-25 08:55:15','e600aaa0-6a23-41ef-88e1-f51435ac508e'),(12921,'115','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Icon` field.','Use the `with` parameter to eager-load sub-elements of the `Icon` field.<br>`{% set entries = craft.entries.with([\'icon\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 08:55:15','2022-07-25 08:55:15','9b989f43-e5d8-453e-a858-a3306997fc4d'),(13044,'119','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Icon` field.','Use the `with` parameter to eager-load sub-elements of the `Icon` field.<br>`{% set entries = craft.entries.with([\'icon\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:18:57','2022-08-15 20:18:57','9a10444f-64f1-4876-a0d2-33e3bb3f7a22'),(13439,'124','/var/www/html/templates/pages/why-mopanui.twig','Eager-load the `Subcategory` field.','Use the `with` parameter to eager-load sub-elements of the `Subcategory` field.<br>`{% set entries = craft.entries.with([\'subcategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:18:57','2022-08-15 20:18:57','d6e4528d-12f2-4c10-bc84-fab79739e747'),(14037,'46','/var/www/html/templates/singles/why-mopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:50:00','2022-07-25 21:50:00','166b4b60-fc03-4b46-8641-6c65aab2f3ee'),(14038,'101','/var/www/html/templates/singles/why-mopanui.twig','Eager-load the `Intro Article` field.','Use the `with` parameter to eager-load sub-elements of the `Intro Article` field.<br>`{% set entries = craft.entries.with([\'introArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:50:00','2022-07-25 21:50:00','dd895560-8101-4a3e-be94-9442a6c58948'),(14039,'103','/var/www/html/templates/singles/why-mopanui.twig','Eager-load the `Article Images` field.','Use the `with` parameter to eager-load sub-elements of the `Article Images` field.<br>`{% set entries = craft.entries.with([\'images\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:50:00','2022-07-25 21:50:00','3e0e0127-7a8b-43bd-a5a2-6d85082f98af'),(14040,'119','/var/www/html/templates/singles/why-mopanui.twig','Eager-load the `Icon` field.','Use the `with` parameter to eager-load sub-elements of the `Icon` field.<br>`{% set entries = craft.entries.with([\'icon\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:50:00','2022-07-25 21:50:00','cf0ec91f-1825-4a71-b676-ace690ebd5f1'),(14041,'124','/var/www/html/templates/singles/why-mopanui.twig','Eager-load the `Subcategory` field.','Use the `with` parameter to eager-load sub-elements of the `Subcategory` field.<br>`{% set entries = craft.entries.with([\'subcategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:50:00','2022-07-25 21:50:00','a26a2311-0a3d-470f-b0b5-467ac859e419'),(14057,'76','/var/www/html/templates/singles/contact-us.twig','Eager-load the `Opening Hours` field.','Use the `with` parameter to eager-load sub-elements of the `Opening Hours` field.<br>`{% set entries = craft.entries.with([\'openingHours\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-07-25 21:48:50','2022-07-25 21:48:50','e581f827-19e3-42bd-9682-6d1d19aa0530'),(14208,'46','/var/www/html/templates/pages/case-studies/index.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:40:27','2022-08-15 20:40:27','e3b49606-7219-425b-9bce-d5e6010e157c'),(14296,'101','/var/www/html/templates/pages/case-studies/index.twig','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:40:27','2022-08-15 20:40:27','da20d37f-c412-412b-8c92-80b27038a0c0'),(14709,'131','/var/www/html/templates/partials/pageSections/_caseStudies.twig','Eager-load the `Preview Image` field.','Use the `with` parameter to eager-load sub-elements of the `Preview Image` field.<br>`{% set entries = craft.entries.with([\'previewImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 21:21:26','2022-08-15 21:21:26','823a76b9-c52d-4a85-9f68-888a3e5df1d8'),(14755,'131','/var/www/html/templates/pages/case-studies/index.twig','Eager-load the `Preview Image` field.','Use the `with` parameter to eager-load sub-elements of the `Preview Image` field.<br>`{% set entries = craft.entries.with([\'previewImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:40:27','2022-08-15 20:40:27','e4bcfdaa-2f81-4cac-b637-19c545451fc7'),(15514,'132','/var/www/html/templates/pages/case-studies/_caseStudiesEntry.twig','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-12 03:49:17','2022-08-12 03:49:17','e262adae-d75f-4687-b336-63006f3616eb'),(16478,'147','/var/www/html/templates/partials/pageSections/_ourProcess.twig','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 21:21:26','2022-08-15 21:21:26','c57cb7d6-b4cd-4735-ac41-c54e71d018d5'),(16922,'156','/var/www/html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:58:56','2022-08-15 20:58:56','dec92773-d660-4241-ba2f-8c1124d436cc'),(17177,'157','/var/www/html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Floor Plan Image` field.','Use the `with` parameter to eager-load sub-elements of the `Floor Plan Image` field.<br>`{% set entries = craft.entries.with([\'floorPlanImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:58:56','2022-08-15 20:58:56','36ec3793-d19b-4c39-aad5-38b760eb5930'),(17581,'156','/var/www/html/templates/pages/the-builds/index.twig','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:58:53','2022-08-15 20:58:53','b41a4462-7889-42de-bf97-f27790ad9f51'),(22415,'160','/var/www/html/templates/pages/case-studies/_caseStudiesEntry.twig','Eager-load the `Image Gallery` field.','Use the `with` parameter to eager-load sub-elements of the `Image Gallery` field.<br>`{% set entries = craft.entries.with([\'imageGallery\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-12 03:49:17','2022-08-12 03:49:17','589b48ef-26ff-4e18-8709-aaf42ac13798'),(25490,'150','/var/www/html/templates/pages/the-builds/index.twig','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 20:58:53','2022-08-15 20:58:53','e807c55c-32b0-4064-a90d-a74c7d16c4b7'),(27967,'164','/var/www/html/templates/partials/pageSections/_whyMopanui.twig','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 21:21:26','2022-08-15 21:21:26','57844246-c3f2-411c-8e94-f872018e451b'),(28158,'170','/var/www/html/templates/index.twig','Eager-load the `The Build Featured Images` field.','Use the `with` parameter to eager-load sub-elements of the `The Build Featured Images` field.<br>`{% set entries = craft.entries.with([\'theBuildFeaturedImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-08-15 21:21:26','2022-08-15 21:21:26','4f4e4d1e-fed1-4421-b672-b0e1273bb64a'),(36880,'147','/home/mscraftstagingth/public_html/templates/partials/pageSections/_ourProcess.twig','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','3a379768-dba2-4351-8e84-257f3353930c'),(36881,'170','/home/mscraftstagingth/public_html/templates/index.twig','Eager-load the `The Build Featured Images` field.','Use the `with` parameter to eager-load sub-elements of the `The Build Featured Images` field.<br>`{% set entries = craft.entries.with([\'theBuildFeaturedImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:26:27','2022-10-27 19:26:27','700637f9-bf9b-4624-8adc-97bd686bf8dd'),(36882,'164','/home/mscraftstagingth/public_html/templates/partials/pageSections/_whyMopanui.twig','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:26:27','2022-10-27 19:26:27','1074a97f-83d3-43be-b598-ff0ede28763d'),(36883,'131','/home/mscraftstagingth/public_html/templates/partials/pageSections/_caseStudies.twig','Eager-load the `Preview Image` field.','Use the `with` parameter to eager-load sub-elements of the `Preview Image` field.<br>`{% set entries = craft.entries.with([\'previewImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','1d71eaea-1435-4bf1-b732-256cf12f0aed'),(36915,'156','/home/mscraftstagingth/public_html/templates/pages/the-builds/index.twig','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','c4221b4f-5527-4da9-bb72-e115595e28ab'),(36916,'150','/home/mscraftstagingth/public_html/templates/pages/the-builds/index.twig','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','8461b145-782d-4096-aeac-1d155309f248'),(36928,'46','/home/mscraftstagingth/public_html/templates/pages/why-mopanui.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','e410ed13-0e9a-4023-8b16-b5b603097c83'),(36929,'101','/home/mscraftstagingth/public_html/templates/pages/why-mopanui.twig','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','f397e734-00c1-40e8-a62d-c12a5c47857d'),(36930,'103','/home/mscraftstagingth/public_html/templates/pages/why-mopanui.twig','Eager-load the `Article Images` field.','Use the `with` parameter to eager-load sub-elements of the `Article Images` field.<br>`{% set entries = craft.entries.with([\'images\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','be92004f-8012-4d52-b629-5f2e86b6db53'),(36931,'119','/home/mscraftstagingth/public_html/templates/pages/why-mopanui.twig','Eager-load the `Icon` field.','Use the `with` parameter to eager-load sub-elements of the `Icon` field.<br>`{% set entries = craft.entries.with([\'icon\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','cd0a49dd-8b88-46a6-9b66-f980bb8b2553'),(36932,'124','/home/mscraftstagingth/public_html/templates/pages/why-mopanui.twig','Eager-load the `Subcategory` field.','Use the `with` parameter to eager-load sub-elements of the `Subcategory` field.<br>`{% set entries = craft.entries.with([\'subcategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','cc4507b7-6535-4f28-960e-81f92cbbe385'),(36942,'46','/home/mscraftstagingth/public_html/templates/pages/case-studies/index.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 18:45:39','2022-10-27 18:45:39','161b48e2-112c-4e6f-8616-8ae950966258'),(36943,'101','/home/mscraftstagingth/public_html/templates/pages/case-studies/index.twig','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 18:45:39','2022-10-27 18:45:39','4aedad90-731b-4e8b-8162-3a923122a328'),(36944,'131','/home/mscraftstagingth/public_html/templates/pages/case-studies/index.twig','Eager-load the `Preview Image` field.','Use the `with` parameter to eager-load sub-elements of the `Preview Image` field.<br>`{% set entries = craft.entries.with([\'previewImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 18:45:39','2022-10-27 18:45:39','21e717e2-e8a3-4bc2-a1ef-1413bb7ba6f8'),(37040,'76','/home/mscraftstagingth/public_html/templates/pages/contact-us.twig','Eager-load the `Opening Hours` field.','Use the `with` parameter to eager-load sub-elements of the `Opening Hours` field.<br>`{% set entries = craft.entries.with([\'openingHours\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:20:50','2022-10-27 19:20:50','32c7314e-dbf3-41e7-828e-9d672ea0c672'),(37737,'156','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','5ef73098-ec0c-4bf9-8763-405acf1cea9d'),(37738,'157','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Floor Plan Image` field.','Use the `with` parameter to eager-load sub-elements of the `Floor Plan Image` field.<br>`{% set entries = craft.entries.with([\'floorPlanImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','9b0a6e1e-4f77-453e-9941-d649c99a5bed'),(38068,'132','/home/mscraftstagingth/public_html/templates/pages/case-studies/_caseStudiesEntry.twig','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:04:12','2022-10-27 19:04:12','6768c707-a72d-477d-888a-5b9ef940a9dc'),(38069,'160','/home/mscraftstagingth/public_html/templates/pages/case-studies/_caseStudiesEntry.twig','Eager-load the `Image Gallery` field.','Use the `with` parameter to eager-load sub-elements of the `Image Gallery` field.<br>`{% set entries = craft.entries.with([\'imageGallery\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:04:12','2022-10-27 19:04:12','e6af691d-628c-462b-8880-90cdc4a2f271'),(38261,'151','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Build Category` field.','Use the `with` parameter to eager-load sub-elements of the `Build Category` field.<br>`{% set entries = craft.entries.with([\'buildCategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','bfd57fe6-cd88-4b43-93d7-b29ea6815c67'),(38262,'161','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Build Bedrooms` field.','Use the `with` parameter to eager-load sub-elements of the `Build Bedrooms` field.<br>`{% set entries = craft.entries.with([\'buildBedrooms\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','da367b95-5663-4f2e-bac5-ad3772a535b6'),(38263,'162','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Build Bathrooms` field.','Use the `with` parameter to eager-load sub-elements of the `Build Bathrooms` field.<br>`{% set entries = craft.entries.with([\'buildBathrooms\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','0dc0dd35-1e9b-4047-bec9-4f7a753c40ee'),(38265,'186','/home/mscraftstagingth/public_html/templates/pages/the-builds/buildsEntry.twig','Eager-load the `Floor Plan Details` field.','Use the `with` parameter to eager-load sub-elements of the `Floor Plan Details` field.<br>`{% set entries = craft.entries.with([\'floorPlanDetails\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','3e63eba2-de4c-431a-ad12-df8aa706604f'),(38762,'161','/home/mscraftstagingth/public_html/templates/pages/the-builds/index.twig','Eager-load the `Build Bedrooms` field.','Use the `with` parameter to eager-load sub-elements of the `Build Bedrooms` field.<br>`{% set entries = craft.entries.with([\'buildBedrooms\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','9ccb5392-b044-462e-8fda-0579146ae363'),(39313,'46','/home/mscraftstagingth/public_html/templates/index.twig','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:26:27','2022-10-27 19:26:27','5d75c10f-61b6-4803-b406-b0ccb5c9defb'),(40202,'149','/home/mscraftstagingth/public_html/templates/pages/the-builds/index.twig','Eager-load the `Catalogue Download` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Download` field.<br>`{% set entries = craft.entries.with([\'catalogueDownload\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','c37c3e34-36a2-44bd-8a45-812b3f6082f9'),(41095,'46','__string_template__b85efe4c6aaa0a7d94e30b0c067e995f74e839f4358e8196d8b86245705fa9ab','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:26:27','2022-10-27 19:26:27','05797b09-d34d-47ba-be39-a6ba2e8d5502'),(41096,'46','__string_template__b2eb2e76a3962c83855cb557699b726204d1c6a9f3c81a64593dcc9b36512fd6','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','fb4fadc5-0171-48e4-93bd-a86ab3c8a1fe'),(41097,'46','__string_template__74b01579b290890bd10188836d965b5ff437438ff22d0ab17ad70d3546abbf2c','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','d477441a-30d8-49de-a6e7-9375dd713d5b'),(41098,'46','__string_template__36f03cc72cd5975a27e67ba579c60366d2873fac0e6d712be5104d30c7bdc944','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','6dfc6c4f-c254-4b6f-8ba1-060427dfc9af'),(41099,'46','__string_template__dc084ad3ebcebf10e1ff758b392043e2c8343e788ad95da8a17892220b41e0ce','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','c957f11a-92ff-454e-bc65-fd22260e017f'),(41100,'46','__string_template__bf2579e272a465eadc3cd4dca937fd79141aea0bb105b07c085886983bd273d9','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','908a213a-3eea-4545-8ff5-40dd5efb141a'),(41101,'46','__string_template__3778a51103c3b802bcddec0f004bf42f4c0a7d6adefbd7328a6332029364c095','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','64bc63d0-a345-41d6-be19-dfb858d06a5b'),(41102,'46','__string_template__757e6e012513e57085974838869dd091150d480c2dc41d3651b2f73d8c9d06c8','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','df1357f3-4f94-4e77-977c-93e5d4f568e4'),(41103,'46','__string_template__35cdf9231d6bdf15f5ba1ec625180714ab1ab8ca65e581a299916e581d946a41','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:29:34','2022-10-27 03:29:34','c2342d0c-aeba-464c-8dc9-1bc5aa265fa8'),(41143,'101','__string_template__95d2ac927f3791992377f571cea7d06fd214f051cca47720935a0cb895af6478','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 18:45:39','2022-10-27 18:45:39','81fbef7d-430b-429f-be91-843ea0bca5a4'),(41156,'124','__string_template__e7a709bf7bd325fc9456771963ccea3fa12119eba5b9ca5974aa2d0d865b2258','Eager-load the `Subcategory` field.','Use the `with` parameter to eager-load sub-elements of the `Subcategory` field.<br>`{% set entries = craft.entries.with([\'subcategory\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 12:28:23','2022-10-27 12:28:23','2f68a4aa-f4c3-4e2b-a92f-243bc44ddc0a'),(41171,'150','__string_template__89df7ceaec727e17291352c4194aca2866ae3aa0745cb91052858b47c6f4f783','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:00','2022-10-27 19:28:00','f986c3fb-472d-475f-8d43-0f2a1e58a01a'),(41172,'150','__string_template__1041dbbab63933fe8367e4c01d127122a281ef98a7c1d27f5a985aca184d587f','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','70a46022-59b1-4437-9c79-5f2a0596ef05'),(41173,'150','__string_template__5807b6dfa8c2a50496fe4f88c4cf7613fd4947eceaf0525b86c151d004c687f6','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','b6f2c1c4-dc15-4e57-be95-02617cf93f77'),(41174,'150','__string_template__7e84eb17780c1e709e6d622534b583beba4d866dbcd86a08578a06cb0ccde4c2','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','91992f96-1490-4547-8b24-314978a48819'),(41175,'150','__string_template__11226820f7d4fc87c215c9a74502b4d6513d19c88a379c57216f9bc46eee0ad6','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','1ab694a9-0c8d-42fb-b600-e7c506c9244f'),(41176,'150','__string_template__c9cc9f6b147daac18b596df1d7296659ba1e0b6a987548c18bb6df16e87bd11c','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','fc796c7c-c4e1-4acf-95df-68cb9d8e5180'),(41177,'150','__string_template__c6dce55d306bc1293e182d979239c2c2cde83ce37e1b940646210acf67e4e8c0','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','880b58fa-5240-49a2-abd5-be3c421c4a9b'),(41178,'150','__string_template__3f4e578f9c626ebd457f7054a27ceb59d986fab0407c2f184dc9a3b1eb639ca3','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','f37aa616-d807-4988-a388-962a3339b63e'),(41179,'150','__string_template__aeeff3874e8a0135ede39441de5791a41e3d484ec5bec90940efa657b97fe690','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:46:58','2022-10-27 03:46:58','af35fbd5-afaa-4489-a2e7-82c5a3440803'),(41186,'132','__string_template__fccc5df0ffd2af18fdd6cdd4c6046005e9cbd43b591d0a283238c8b01acc624f','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:04:12','2022-10-27 19:04:12','747665ed-2a2e-440b-bb12-c33fc8e744d8'),(41187,'132','__string_template__3535c4076a809d29b900544e9e6810a33b8335f237b586b1576fbc79c3b747ab','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','783d713e-a026-49e2-bc6d-f0e2f80c7d96'),(41188,'132','__string_template__7d404c1c9b07b9d155e2a55e9b52c62311d6c7250b895adc15564b9ec25885d1','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','654bb382-0e51-4b35-838e-94230b10fad6'),(41189,'132','__string_template__c215aea173874a2686ee74d3441dbdf5581e1bc2b75799cb8aeff53e32b45037','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','081fa75d-7e48-4644-9ac7-bd1dd52fbbc9'),(41190,'132','__string_template__6bb4943b3263c2daeaa2f66531464348c21bf89171265507018a02fe54918c21','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','94c13949-3691-486d-b761-0ba33585c30f'),(41191,'132','__string_template__e8d1ab1b65a8bf18f63d767d645a0dac36cf3f1e28e8b0cf4e6ffc3007b81a05','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','698d3d34-7756-4804-9fc3-0d421b14fc25'),(41192,'132','__string_template__989b020eb9a7a195edc36661605ddfd3798e49e638bf3b67c467c07c5db3ae7d','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','f066782c-17de-4770-91aa-880645f8204b'),(41193,'132','__string_template__518a7f58a9a1b051a02167fc0c46ffd444b16e8da0e7e7151056b577c5224013','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','5f452399-797b-4379-a151-abe16ded1539'),(41194,'132','__string_template__1dc68a704a230ab79c48672dd1df1ec6db5fb43f495c9f8d55344a1c60072a23','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 03:53:21','2022-10-27 03:53:21','b1954ee2-e69d-40b7-9e68-13e608640e17'),(41463,'156','__string_template__9c2461005c08619d3dbdbed16e400b9ebe097fa596a50734f3506951e433123b','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 19:28:38','2022-10-27 19:28:38','e8791f12-16bb-430d-9567-8bd5d5d162d1'),(41464,'156','__string_template__9509ec3667115dc181933f902df5ed90858e1bdfba4db63b5c0c627e0f50a114','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','eff6a37d-a02e-4739-be4e-b89a5872d066'),(41465,'156','__string_template__4dc7ca7f512ab0ce4ce6a4e125044bf3cd9dc8891e15fdc176ad0081b5757dd8','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','372a70d0-e025-4a38-a98b-b9b644bc2715'),(41466,'156','__string_template__af6ac8a4ee6fd0f1aefdcf6065c9fe3bb073307100e812bc03119b0eb5e60efd','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','e033834d-54b7-4331-8c8a-eceaf5bea1fa'),(41467,'156','__string_template__23e4b9782353ac6c9b692658c2fe76e1308daae767a1d04ed9260bd29395b9a6','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','b866b505-00c8-44cd-9dff-51b870a72d76'),(41468,'156','__string_template__c16c6dac537d2a50ed44dce48eb0c991468b6104dd23976c93985c5e236f675c','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','975df056-37ee-4fcf-b0da-88e1037af30d'),(41469,'156','__string_template__abcdb3cb0372ea5798b1200e9a1a0863a7eb639ecd74769ec7dac4b69ead86b0','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','ebadcf3a-9433-483b-9f8b-dd83c9a8062e'),(41470,'156','__string_template__d75952b2ad2cce62d80ff19ae061d3b3d6c84e0307963c6373580188591b667b','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','1cd0808c-4287-49a9-ad8f-c679d12a966b'),(41471,'156','__string_template__82c4c5c026262fa074b6b648ab24e41b1f9a9209596ebb6ccded645b6c5ff8c4','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:38:45','2022-10-27 08:38:45','305f1f6d-03e4-4103-b908-10b8b2916380'),(44061,'156','','Eager-load the `Build Images` field.','Use the `with` parameter to eager-load sub-elements of the `Build Images` field.<br>`{% set entries = craft.entries.with([\'buildImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:13','2022-10-27 08:37:13','e0412834-f390-4750-a2b0-09871aa9dbf8'),(44062,'157','','Eager-load the `Floor Plan Image` field.','Use the `with` parameter to eager-load sub-elements of the `Floor Plan Image` field.<br>`{% set entries = craft.entries.with([\'floorPlanImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:13','2022-10-27 08:37:13','9df74f8b-db3b-4579-9aca-73d09bdc2d66'),(44063,'186','','Eager-load the `Floor Plan Details` field.','Use the `with` parameter to eager-load sub-elements of the `Floor Plan Details` field.<br>`{% set entries = craft.entries.with([\'floorPlanDetails\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:13','2022-10-27 08:37:13','a2ab197b-3b07-4264-b540-23c243ed826f'),(44064,'150','','Eager-load the `Catalogue Preview` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Preview` field.<br>`{% set entries = craft.entries.with([\'cataloguePreview\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:14','2022-10-27 08:37:14','166fe4a8-355f-457c-a68c-ee05405b5642'),(44065,'149','','Eager-load the `Catalogue Download` field.','Use the `with` parameter to eager-load sub-elements of the `Catalogue Download` field.<br>`{% set entries = craft.entries.with([\'catalogueDownload\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:14','2022-10-27 08:37:14','a00d4281-ea06-424a-8b5c-57c8901d9531'),(44066,'131','','Eager-load the `Preview Image` field.','Use the `with` parameter to eager-load sub-elements of the `Preview Image` field.<br>`{% set entries = craft.entries.with([\'previewImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:16','2022-10-27 08:37:16','031a9a43-abc5-4b05-828b-9bc403fc0b33'),(44067,'132','','Eager-load the `Case Featured Image` field.','Use the `with` parameter to eager-load sub-elements of the `Case Featured Image` field.<br>`{% set entries = craft.entries.with([\'caseFeaturedImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:16','2022-10-27 08:37:16','afc693ff-2e0b-4618-8573-534db0868ff7'),(44068,'160','','Eager-load the `Image Gallery` field.','Use the `with` parameter to eager-load sub-elements of the `Image Gallery` field.<br>`{% set entries = craft.entries.with([\'imageGallery\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:16','2022-10-27 08:37:16','69874889-04a5-4c1f-b423-9bb9163375e9'),(44069,'46','','Eager-load the `Feature Image` field.','Use the `with` parameter to eager-load sub-elements of the `Feature Image` field.<br>`{% set entries = craft.entries.with([\'featureImage\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:40','2022-10-27 08:37:40','6dfab0b7-d4cc-4560-8de0-e25de7ff4964'),(44070,'101','','Eager-load the `Two Column Article` field.','Use the `with` parameter to eager-load sub-elements of the `Two Column Article` field.<br>`{% set entries = craft.entries.with([\'twoColumnArticle\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:40','2022-10-27 08:37:40','16d6cf67-3250-476f-925b-b3ddab8516eb'),(44072,'170','','Eager-load the `The Build Featured Images` field.','Use the `with` parameter to eager-load sub-elements of the `The Build Featured Images` field.<br>`{% set entries = craft.entries.with([\'theBuildFeaturedImages\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:21','2022-10-27 08:37:21','a1ef7431-5fd1-46f2-8b35-e295736e5e9e'),(44075,'9','','Eager-load the `Content Blocks` field.','Use the `with` parameter to eager-load sub-elements of the `Content Blocks` field.<br>`{% set entries = craft.entries.with([\'contentBlocks\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:35','2022-10-27 08:37:35','f258bf76-d70d-4a0c-bf10-94304043fe47'),(44076,'11','','Eager-load the `Images` field.','Use the `with` parameter to eager-load sub-elements of the `Images` field.<br>`{% set entries = craft.entries.with([\'images\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:35','2022-10-27 08:37:35','bde2502d-15a4-43cc-adfd-d1c7bd21c022'),(44077,'15','','Eager-load the `Image` field.','Use the `with` parameter to eager-load sub-elements of the `Image` field.<br>`{% set entries = craft.entries.with([\'image\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:35','2022-10-27 08:37:35','89388d40-5f47-43ba-9104-31b79411010e'),(44078,'18','','Eager-load the `Video` field.','Use the `with` parameter to eager-load sub-elements of the `Video` field.<br>`{% set entries = craft.entries.with([\'video\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:35','2022-10-27 08:37:35','7523cd4d-9aab-4272-8c1b-3b599800bb25'),(44087,'103','','Eager-load the `Article Images` field.','Use the `with` parameter to eager-load sub-elements of the `Article Images` field.<br>`{% set entries = craft.entries.with([\'images\']).all() %}`<br><a href=\"https://docs.craftcms.com/v3/dev/eager-loading-elements.html\" class=\"go\" target=\"_blank\">Docs</a>','2022-10-27 08:37:40','2022-10-27 08:37:40','897a9809-29b6-40f6-8ab8-ea042dd153b6');
commit;

--
