--
-- Host: 127.0.0.1    Database: cooperativamaism_junta
-- ------------------------------------------------------


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

CREATE TABLE `addresses` (
  `id` int(11) NOT NULL,
  `ownerId` int(11) DEFAULT NULL,
  `countryCode` varchar(255) NOT NULL,
  `administrativeArea` varchar(255) DEFAULT NULL,
  `locality` varchar(255) DEFAULT NULL,
  `dependentLocality` varchar(255) DEFAULT NULL,
  `postalCode` varchar(255) DEFAULT NULL,
  `sortingCode` varchar(255) DEFAULT NULL,
  `addressLine1` varchar(255) DEFAULT NULL,
  `addressLine2` varchar(255) DEFAULT NULL,
  `organization` varchar(255) DEFAULT NULL,
  `organizationTaxId` varchar(255) DEFAULT NULL,
  `fullName` varchar(255) DEFAULT NULL,
  `firstName` varchar(255) DEFAULT NULL,
  `lastName` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_djfddlsxsevmrvaqemopqoitxylyzlcrixgv` (`ownerId`),
  CONSTRAINT `fk_djfddlsxsevmrvaqemopqoitxylyzlcrixgv` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_iobuwmkbfdoglizemhlhsowgrmhfdgvznpva` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `pluginId` int(11) DEFAULT NULL,
  `heading` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `unread` tinyint(1) NOT NULL DEFAULT '1',
  `dateRead` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_nhoronwpuuxwzwhmqksahamcfpychtlqzgzc` (`userId`,`unread`,`dateRead`,`dateCreated`),
  KEY `idx_eiyyaycqgzvggmhneeseusifcffnljymlpro` (`dateRead`),
  KEY `fk_hrgcyvqxnavxrsmwpfayisgiryvkkgpaiahi` (`pluginId`),
  CONSTRAINT `fk_hrgcyvqxnavxrsmwpfayisgiryvkkgpaiahi` FOREIGN KEY (`pluginId`) REFERENCES `plugins` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ssjvnrbhrrhakzzsybhyldouitjeairrmpoi` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `assets` (
  `id` int(11) NOT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `folderId` int(11) NOT NULL,
  `uploaderId` int(11) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `kind` varchar(50) NOT NULL DEFAULT 'unknown',
  `alt` text,
  `width` int(11) unsigned DEFAULT NULL,
  `height` int(11) unsigned DEFAULT NULL,
  `size` bigint(20) unsigned DEFAULT NULL,
  `focalPoint` varchar(13) DEFAULT NULL,
  `deletedWithVolume` tinyint(1) DEFAULT NULL,
  `keptFile` tinyint(1) DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_whdamtezijlngxqpjinsdqcavleqrmdsytgp` (`filename`,`folderId`),
  KEY `idx_hnqsyrhpmakzxxtzrnobuhwmqjjqnkynidpj` (`folderId`),
  KEY `idx_ofbxiosogewsfnxwrhzmdajkwrgdmsjgasho` (`volumeId`),
  KEY `fk_ozkjvwleytxdbpoltrepucsqmhfngjikhjbk` (`uploaderId`),
  CONSTRAINT `fk_itlbihhxvwmbfngsbvrxmzphiosipdtnxvxz` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ofwxcjodqxjngwndyeexazhgziwkccdnhemr` FOREIGN KEY (`folderId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ozkjvwleytxdbpoltrepucsqmhfngjikhjbk` FOREIGN KEY (`uploaderId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_usqrqqgwnikriqxunodpshktjbuktxnxlosk` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_svjihsucnwlmqhmlzsqrzabxwlfvwvjnaqnk` (`groupId`),
  KEY `fk_qwsxhhxzzobsgwflfefzwfivncpxiqpbvhbq` (`parentId`),
  CONSTRAINT `fk_buduahtuexbfjkcfqkmsrytbswlgxdpvcnow` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_gubwxabuucbyilywksaytzusyszriazpdtpc` FOREIGN KEY (`groupId`) REFERENCES `categorygroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_qwsxhhxzzobsgwflfefzwfivncpxiqpbvhbq` FOREIGN KEY (`parentId`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `categorygroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `defaultPlacement` enum('beginning','end') NOT NULL DEFAULT 'end',
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_narlpjblqmamenafrpzsqiluxyfnpyzgxljl` (`name`),
  KEY `idx_wpututxgodvrmgrvqomiqiiyuqzzqqgpfika` (`handle`),
  KEY `idx_niwwjfhspkggoedewtrbncluujdybsldkhhb` (`structureId`),
  KEY `idx_rnvflnlwwascuklcdrjbmjrdoqiegqrwrmbo` (`fieldLayoutId`),
  KEY `idx_jrbledaleziveyjvnvawerxyogzbxzmdmtcq` (`dateDeleted`),
  CONSTRAINT `fk_eoahuivlpsurxlpkpptjqypopagegmtwvbee` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pnmbapnldsivngjsyflevachqfawxampgfjb` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

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

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

CREATE TABLE `changedfields` (
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `propagated` tinyint(1) NOT NULL,
  `userId` int(11) DEFAULT NULL,
  PRIMARY KEY (`elementId`,`siteId`,`fieldId`),
  KEY `idx_lmpzpdjpqqpoilucghbwmfhzanmgvaaieeeo` (`elementId`,`siteId`,`dateUpdated`),
  KEY `fk_fbnpthihmmjzfwrqaddwuiincsthxvxbkuzy` (`siteId`),
  KEY `fk_aatadzirpsbqwhevkxggklouxgxjyapzbqok` (`fieldId`),
  KEY `fk_mqmwclcgiyunwtafikpbmqllwaaybqongfjz` (`userId`),
  CONSTRAINT `fk_aatadzirpsbqwhevkxggklouxgxjyapzbqok` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_fbnpthihmmjzfwrqaddwuiincsthxvxbkuzy` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_mqmwclcgiyunwtafikpbmqllwaaybqongfjz` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `fk_uytbmlurlacetuacgwcaxqbxrpphusyobjdu` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_ohboalewzhvnxhtdxwnkvrauyuzifyilqvlp` (`elementId`,`siteId`),
  KEY `idx_ocuoeacnpkybsiozbmajmwffytwytgmujfrj` (`siteId`),
  KEY `idx_fcgxbdfslsjucggqwsbyefiwzgtohxfqaboy` (`title`),
  CONSTRAINT `fk_ifxeoxzzgaconwygsgvhjfvzhbjhnrtnrmqq` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_jkyukgbhnkzgnqixfkldlzjbtzvdyvxahyqs` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `drafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `canonicalId` 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 `idx_dmfnscilfenalncczmmdvfpehogpffsoctat` (`creatorId`,`provisional`),
  KEY `idx_zwwhlazgnmaemsrvrnlrcmmdgpyggccbuqkn` (`saved`),
  KEY `fk_frxixkjltwwlxogcibfavanvvrrkfhzlgrhf` (`canonicalId`),
  CONSTRAINT `fk_frxixkjltwwlxogcibfavanvvrrkfhzlgrhf` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_slacvlkucwomcvoumpifswosbvqecjnohclv` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `elements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `canonicalId` int(11) DEFAULT NULL,
  `draftId` int(11) DEFAULT NULL,
  `revisionId` int(11) DEFAULT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `type` varchar(255) 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 `idx_jalyauvfdzwqoabqyfkxrdgvaowvnhlklrwp` (`dateDeleted`),
  KEY `idx_hphdevbfjnjhnbtcagtogtdjaxpyphlwpnmw` (`fieldLayoutId`),
  KEY `idx_rshxllxoobzxkbkiswpsifnyfsbglytdrvid` (`type`),
  KEY `idx_xdfsrmuogdodpyzmqagxxhlnnagpbfjndejc` (`enabled`),
  KEY `idx_vekxwetaccyktmhvyapkcoktsroahgmgjppq` (`canonicalId`),
  KEY `idx_xypjicsisbmdjqdhvczthdnpzbeuhmnldota` (`archived`,`dateCreated`),
  KEY `idx_pmpzzocaupqzzejivdxtpbaawjsnezdoqntp` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`),
  KEY `idx_gdinedlecebuwidncbxrnhumftcilmvdrory` (`archived`,`dateDeleted`,`draftId`,`revisionId`,`canonicalId`,`enabled`),
  KEY `fk_dtfgynqskiiaowizjbzncixlqsfsvdgojtij` (`draftId`),
  KEY `fk_qwjzdbsjblwkvrxfhfrjxihhfrahvskymlca` (`revisionId`),
  CONSTRAINT `fk_avuzclknxbcggqiatukaiwlazadnawmxglvd` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_dtfgynqskiiaowizjbzncixlqsfsvdgojtij` FOREIGN KEY (`draftId`) REFERENCES `drafts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_gsfcxfguspjfxhelucoyegybwntkwyfalgry` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_qwjzdbsjblwkvrxfhfrjxihhfrahvskymlca` FOREIGN KEY (`revisionId`) REFERENCES `revisions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `elements_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `elementId` int(11) NOT NULL,
  `siteId` int(11) NOT NULL,
  `slug` varchar(255) 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 `idx_xdttpdtbwernvzrpzrjuetswgalndnvxzhsw` (`elementId`,`siteId`),
  KEY `idx_hccocrclajvlcrkgfrtmhgdpghmfndhvniod` (`siteId`),
  KEY `idx_ahqribcnatkariwjrdkalfubjoctlgnjhfah` (`slug`,`siteId`),
  KEY `idx_qwjcetmkxkczgtnghqffsysvwshdblqvyxaq` (`enabled`),
  KEY `idx_eenicetmlfxjslscyqtakhiluduphhszjbaj` (`uri`,`siteId`),
  CONSTRAINT `fk_tzqjdjuhbhidemgmkwqgfxgraalkmcyjffab` FOREIGN KEY (`siteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_yvvbgwmhmkfhwuqjjpfqdrusyarqdylhsttv` FOREIGN KEY (`elementId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `entries` (
  `id` int(11) NOT NULL,
  `sectionId` int(11) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `typeId` int(11) NOT NULL,
  `authorId` int(11) DEFAULT NULL,
  `postDate` datetime DEFAULT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `deletedWithEntryType` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_ifsrelqieavcddhybmwdwokvzioopusuutrd` (`postDate`),
  KEY `idx_kghffkjvrirxxjajysgljoqsohfcgcpkjulw` (`expiryDate`),
  KEY `idx_wbqpeytutkmwadfogjtgbjsqqtzvrxsdfgdd` (`authorId`),
  KEY `idx_epynmnwzzwibfvnrdviymsrpubadfqhvquse` (`sectionId`),
  KEY `idx_hkacrphqqbsfhceheblfoatbucvknczcblmk` (`typeId`),
  KEY `fk_bhlrsxnyozabdqtpzlfygwqqwlegsxszgmys` (`parentId`),
  CONSTRAINT `fk_bhlrsxnyozabdqtpzlfygwqqwlegsxszgmys` FOREIGN KEY (`parentId`) REFERENCES `entries` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_cimbvtdektuprnhmrjtoahhbkdaindproaat` FOREIGN KEY (`typeId`) REFERENCES `entrytypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_feivhncuwvqtkmkcooujhnnsbsjaofihfpuc` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_iseehsxozgrigxsxtelmhggdlzpvrhdbgyzo` FOREIGN KEY (`authorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_otxnypirtfbmbqzxgrbuscgwsefqpjtxckcw` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `entrytypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sectionId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) 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(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_llihxykmtecyyffnttzjwanyjktzbhevaaih` (`name`,`sectionId`),
  KEY `idx_wseyovcojkuyahqrwjpqwmtcdsdjmxsmunvd` (`handle`,`sectionId`),
  KEY `idx_bfjnqhjqcmnbjyjylrwpfrrcsgjniwmgfpja` (`sectionId`),
  KEY `idx_sfiubfnlrosxmdladrkwavajuphpoyeaavme` (`fieldLayoutId`),
  KEY `idx_rmzhcsdeqgqxlysbxccztfzyjvppocdpjwdf` (`dateDeleted`),
  CONSTRAINT `fk_lyoipjxcfngwngpomtupbnlnhwtjusbmwmkf` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_umlmeiarpayhmouaohlndvlrsimowvtymigc` FOREIGN KEY (`sectionId`) REFERENCES `sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `idx_qqgstwxncipctjliafkmgpzsqqfbthukxnpm` (`name`),
  KEY `idx_xowwocdovxbalrikawiklasrchbbbtsqrhtl` (`dateDeleted`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `fieldlayoutfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layoutId` int(11) NOT NULL,
  `tabId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_cddebmyjjphlknmztjulakqslxjlepedrtpi` (`layoutId`,`fieldId`),
  KEY `idx_gaiygwqzkkytcxmcsgvhoxheulfhdatdsqrv` (`sortOrder`),
  KEY `idx_yzzdipnwmymrfmuppbtutchmswenzsmyadbg` (`tabId`),
  KEY `idx_mfsscijwnkkdaxutzrjxhwxeclvhsttwdqtm` (`fieldId`),
  CONSTRAINT `fk_bokcfewsbjvqlzxjiclzmgxhrxiquigbgmud` FOREIGN KEY (`layoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pvedbgbyeoaqhetfmubijzwsipywuhzisood` FOREIGN KEY (`tabId`) REFERENCES `fieldlayouttabs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_vyuxgellfabzmqohvylfathewrxxfjetoamc` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `idx_jegnkimxhuerjsegukmaqouyobsdulbodegg` (`dateDeleted`),
  KEY `idx_anvtmxnzzeweomsszsopcsfdhszqbxvhghxl` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `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 `idx_ryapqobflpdllzmhryxjqjzdibwqfspghnqx` (`handle`,`context`),
  KEY `idx_avwomuewvsxnbnvpuvmvwmfaqagmpyfzdooh` (`groupId`),
  KEY `idx_evvtxdgiwakazijerscubayveipkipgovfgj` (`context`),
  CONSTRAINT `fk_sukzptvbndzbrfmbpppgowodqcpuklwpxikw` FOREIGN KEY (`groupId`) REFERENCES `fieldgroups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_wsxlpwwacrqjtfrayndbxuezsfoasbtczdqc` (`name`),
  KEY `idx_dxptdbtnpzlfwhjtrmzkxaqyjtgcdaubpuxi` (`handle`),
  KEY `idx_cbsshnybruvlqaykzvmzskgpbsmquwrhjmux` (`fieldLayoutId`),
  KEY `idx_wxoavqeyxzqenemrobxbecwamspbdcqywbxf` (`sortOrder`),
  CONSTRAINT `fk_lcfurqccglookqadzzjjqbaorttebnwfvrlf` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_msljibbpdgpksyfqluzkmxkgykosqlfnqzkz` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `imagetransformindex` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `assetId` int(11) NOT NULL,
  `transformer` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `transformString` varchar(255) NOT NULL,
  `fileExists` tinyint(1) NOT NULL DEFAULT '0',
  `inProgress` tinyint(1) NOT NULL DEFAULT '0',
  `error` tinyint(1) NOT NULL DEFAULT '0',
  `dateIndexed` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_rmgyxwzugsxjramvsqntxnnfivrjalpveyrp` (`assetId`,`transformString`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `imagetransforms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `mode` enum('stretch','fit','crop','letterbox') NOT NULL DEFAULT 'crop',
  `position` enum('top-left','top-center','top-right','center-left','center-center','center-right','bottom-left','bottom-center','bottom-right') NOT NULL DEFAULT 'center-center',
  `width` int(11) unsigned DEFAULT NULL,
  `height` int(11) unsigned DEFAULT NULL,
  `format` varchar(255) DEFAULT NULL,
  `quality` int(11) DEFAULT NULL,
  `interlace` enum('none','line','plane','partition') NOT NULL DEFAULT 'none',
  `fill` varchar(11) DEFAULT NULL,
  `upscale` tinyint(1) NOT NULL DEFAULT '1',
  `parameterChangeTime` datetime DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_qjsihtsydcsefptofqsuutdlwueywmrleooh` (`name`),
  KEY `idx_tejofqwttqibhqsrwczqahyaimdflofemezg` (`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `matrixblocks`
--

CREATE TABLE `matrixblocks` (
  `id` int(11) NOT NULL,
  `primaryOwnerId` int(11) NOT NULL,
  `fieldId` int(11) NOT NULL,
  `typeId` int(11) NOT NULL,
  `deletedWithOwner` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_qwcywwpouhavkuikwmfpwctbtqtuuurbvfhy` (`primaryOwnerId`),
  KEY `idx_pnqprfijhlzfvvxtjmaiobusfugjlknpvmkr` (`fieldId`),
  KEY `idx_smwmaqayuhtwczfgigezzmloklqiezswmnjd` (`typeId`),
  CONSTRAINT `fk_ahwgopvylonevvsrnwnglelmsoszlvyzexea` FOREIGN KEY (`typeId`) REFERENCES `matrixblocktypes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_fodpepigrmyrbhpmfartzhdungdmitxgocnm` FOREIGN KEY (`primaryOwnerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_hrqmhugwubcdegyqvlkkovclgbfvkyinnsmn` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_lswgsrpoiunlnigfbbumqkxjrypwcmasfynp` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Table structure for table `matrixblocks_owners`
--

CREATE TABLE `matrixblocks_owners` (
  `blockId` int(11) NOT NULL,
  `ownerId` int(11) NOT NULL,
  `sortOrder` smallint(6) unsigned NOT NULL,
  PRIMARY KEY (`blockId`,`ownerId`),
  KEY `fk_hzrybcrrlvtnpcttsgbflghzhgjcdlwingqu` (`ownerId`),
  CONSTRAINT `fk_hzrybcrrlvtnpcttsgbflghzhgjcdlwingqu` FOREIGN KEY (`ownerId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_inqtuyoeajdlbhstztmaowzyfpuvqgtuqqbk` FOREIGN KEY (`blockId`) REFERENCES `matrixblocks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `matrixblocktypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_sbcwokvagwrjpqrldugrtpxwxmdmeqbqdifq` (`name`,`fieldId`),
  KEY `idx_zrbwhvloaflmiojyhmocceybeeltmuyjuehl` (`handle`,`fieldId`),
  KEY `idx_nkvsbhqrewsseavszzijfxxcowyblbajclxx` (`fieldId`),
  KEY `idx_hmhjcbqgdbssglqojopuvunzwccvrhtzglpx` (`fieldLayoutId`),
  CONSTRAINT `fk_otzruqojucsyrwqrckekgfrpugzuhfucibgf` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_utwbtrzbrvptdjrqncokjatywemhgnyxdcem` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `idx_ukmrwfklwnskidofdfqkwwhombeisobgczfi` (`track`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

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

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

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

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

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

CREATE TABLE `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(11) unsigned NOT NULL DEFAULT '1024',
  `dateReserved` datetime DEFAULT NULL,
  `timeUpdated` int(11) DEFAULT NULL,
  `progress` smallint(6) NOT NULL DEFAULT '0',
  `progressLabel` varchar(255) DEFAULT NULL,
  `attempt` int(11) DEFAULT NULL,
  `fail` tinyint(1) DEFAULT '0',
  `dateFailed` datetime DEFAULT NULL,
  `error` text,
  PRIMARY KEY (`id`),
  KEY `idx_nijxiywlpnnqtkmlcirobeljtkkiwtwtveag` (`channel`,`fail`,`timeUpdated`,`timePushed`),
  KEY `idx_zggstncszgzeokflraaewndvximgrfibttzl` (`channel`,`fail`,`timeUpdated`,`delay`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

CREATE TABLE `relations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldId` int(11) NOT NULL,
  `sourceId` int(11) NOT NULL,
  `sourceSiteId` int(11) DEFAULT NULL,
  `targetId` int(11) NOT NULL,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_vbcfremrunxmfdpyqdjqscewfzunzrltaskk` (`fieldId`,`sourceId`,`sourceSiteId`,`targetId`),
  KEY `idx_dvdbztpfwjloqmaewccwnpzylbvgvrhwbdfs` (`sourceId`),
  KEY `idx_rnoisvmcvrksoehkdfvzhaehmkrjqvobxdck` (`targetId`),
  KEY `idx_hbmhffhtkgpiljrcmaktsuybcfdsdrixugay` (`sourceSiteId`),
  CONSTRAINT `fk_jydnzksgyxvwfobvwgtxxrwrvcwldlpcjald` FOREIGN KEY (`fieldId`) REFERENCES `fields` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_ufpntrpnynfyhobjmyhhomemazysebyfrzxi` FOREIGN KEY (`sourceId`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_zjobnstgfscafemjmvuglcgdfgsckkvswnxz` FOREIGN KEY (`sourceSiteId`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `revisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `canonicalId` int(11) NOT NULL,
  `creatorId` int(11) DEFAULT NULL,
  `num` int(11) NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_oigjyjolorgzjtqcvdlujrfpldxzguqupctk` (`canonicalId`,`num`),
  KEY `fk_viwtpypksaqsrgwaddrupwggcrvykvsxchsc` (`creatorId`),
  CONSTRAINT `fk_viwtpypksaqsrgwaddrupwggcrvykvsxchsc` FOREIGN KEY (`creatorId`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_xjsoswgmvtburbwyaybbfsjaohjculaasbsp` FOREIGN KEY (`canonicalId`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `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 `idx_yezorebiguhgmpmgdusqtdeahzikyfrazolm` (`handle`),
  KEY `idx_axwavyocrothghudilsjfwgqapenqsabeowl` (`name`),
  KEY `idx_pumtylkguhtusqkqsegeungyvislgxxxcktx` (`structureId`),
  KEY `idx_fbvacfhzcwdiivqireabrwkkdhbzpvzvjrqi` (`dateDeleted`),
  CONSTRAINT `fk_lewhmfhkrojdkthbzmuyhkffwjpvpqndfncm` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

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

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

CREATE TABLE `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 `idx_ybxkdmwgapmktycsiljnnlkzwuaxncfycium` (`userId`,`message`),
  CONSTRAINT `fk_icnnzsrecygejzisjwymfvmlmcxluayioumq` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `idx_lvwanyobinyhfukbcsxaizsczadjncbojtmz` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `structureelements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `structureId` int(11) NOT NULL,
  `elementId` int(11) DEFAULT NULL,
  `root` int(11) unsigned DEFAULT NULL,
  `lft` int(11) unsigned NOT NULL,
  `rgt` int(11) unsigned NOT NULL,
  `level` smallint(6) unsigned NOT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_logvnvmzetqzdpgzwfdfuxllforwthtvqdck` (`structureId`,`elementId`),
  KEY `idx_vlpezellkdrldexjlxfqjvfbwosvgenywnkk` (`root`),
  KEY `idx_nxqzruidpwwmngiigcopsuvtadwycexglrru` (`lft`),
  KEY `idx_rxcmpcsfrclceserzkkozwkwwayloquxrmxt` (`rgt`),
  KEY `idx_wxufmbygyeccxwyqgovvyuwrbukdqzhtuuxk` (`level`),
  KEY `idx_gdyoeghractqxijxvgiyxzlgceghgiuiczhn` (`elementId`),
  CONSTRAINT `fk_wmtdvmujaqhmnaamilnoqtbbdzsrntbkxgpx` FOREIGN KEY (`structureId`) REFERENCES `structures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `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 `idx_zrnjhceqqptaaarfgbrrocggztaqvoinfmnk` (`name`),
  KEY `idx_igpquvwvqcqzmhvuqvrtwcjbxvwexvegeyxc` (`handle`),
  KEY `idx_vehizpdlrvjhvxwzgqkelyrlygpgcycuvlsj` (`dateDeleted`),
  KEY `fk_fveactxycchvygtwnabcjdiuswxgvsjsrxox` (`fieldLayoutId`),
  CONSTRAINT `fk_fveactxycchvygtwnabcjdiuswxgvsjsrxox` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `tags` (
  `id` int(11) NOT NULL,
  `groupId` int(11) NOT NULL,
  `deletedWithGroup` tinyint(1) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_dcetxnexxqhupkwbpnarhmemjnmdneiwlgvo` (`groupId`),
  CONSTRAINT `fk_bcytxetfwgyyreegllirvomdinjfvfvjgafm` FOREIGN KEY (`groupId`) REFERENCES `taggroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_zutiisijeuermojhgmlsugbcegjzghraelhq` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `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 `idx_awrlyhdfbmtjvymuuuamwxgaeodruusfokag` (`handle`),
  KEY `idx_oedrufpjgxkavtqejibswrcsynfdkzutsinw` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE `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 `idx_gmsgmdpjzguaaegwotjnowxgrqaffcdsifpk` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

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

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

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

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

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

CREATE TABLE `volumefolders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `volumeId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_utvltvmiprddfqzinknqsgngkaxvpwnllgfe` (`name`,`parentId`,`volumeId`),
  KEY `idx_fghkpywxuwymbmbdaakrwgtjgxkftsgfzzcy` (`parentId`),
  KEY `idx_bepblzvluhnjbwnnczcvgvrgavmeswngewdy` (`volumeId`),
  CONSTRAINT `fk_bkhghvybegnmiumredfezsvjfsjjkradcuek` FOREIGN KEY (`parentId`) REFERENCES `volumefolders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_dyyrxidbadfusghttxhhqktuleeezcwzvzxj` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

CREATE TABLE `volumes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fieldLayoutId` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `handle` varchar(255) NOT NULL,
  `fs` varchar(255) NOT NULL,
  `transformFs` varchar(255) DEFAULT NULL,
  `transformSubpath` varchar(255) DEFAULT NULL,
  `titleTranslationMethod` varchar(255) NOT NULL DEFAULT 'site',
  `titleTranslationKeyFormat` text,
  `sortOrder` smallint(6) unsigned DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateUpdated` datetime NOT NULL,
  `dateDeleted` datetime DEFAULT NULL,
  `uid` char(36) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_oygajhulortrwmxniqcdggfycfahilnhtabp` (`name`),
  KEY `idx_kddnmgvkpvlsqzulwnuslkgxtlurstqzugle` (`handle`),
  KEY `idx_ijnjvhbkjchhyacpmgdualhkbjcaimggrrzz` (`fieldLayoutId`),
  KEY `idx_tyseocclrpjugjxwkghdzkmwdlokfxoxcxbx` (`dateDeleted`),
  CONSTRAINT `fk_uerlvyhsykymfebwetqysgkcbxzutsetwgql` FOREIGN KEY (`fieldLayoutId`) REFERENCES `fieldlayouts` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

--
-- Dumping routines for database 'cooperativamaism_junta'
--


--
-- Host: 127.0.0.1    Database: cooperativamaism_junta
-- ------------------------------------------------------


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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `content` VALUES (1,1,1,NULL,'2024-02-16 17:40:41','2024-02-16 17:40:41','42df3d24-1556-4bae-ac28-0c2f41ce2508');
commit;
set autocommit=0;
commit;
set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `elements` VALUES (1,NULL,NULL,NULL,NULL,'craft\\elements\\User',1,0,'2024-02-16 17:40:41','2024-02-16 17:40:41',NULL,NULL,'b7d803d1-cf68-4e54-9e03-7d3fc7334017');
commit;

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

set autocommit=0;
INSERT INTO `elements_sites` VALUES (1,1,1,NULL,NULL,1,'2024-02-16 17:40:41','2024-02-16 17:40:41','c7bc7fc3-8d38-49d5-a6b4-b5f15d6a32d7');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `fieldgroups` VALUES (1,'Common','2024-02-16 17:40:41','2024-02-16 17:40:41',NULL,'52344ede-a26d-4fbf-a81c-5ddb1d312483');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

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

--
-- Dumping data for table `imagetransforms`
--

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `info` VALUES (1,'4.4.17','4.4.0.4',1,'cgyhbvnirinj','3@wamrrfvelj','2024-02-16 17:40:41','2024-02-19 12:15:48','136d5d63-e8cc-4d9a-a803-c8eb4a7c6ec2');
commit;

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

set autocommit=0;
commit;

--
-- Dumping data for table `matrixblocks_owners`
--

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `migrations` VALUES (1,'craft','Install','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','c5fb6e98-6670-4e38-8498-6703035772f2'),(2,'craft','m210121_145800_asset_indexing_changes','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','17dc6c48-8915-42e3-9d83-3d3276df0596'),(3,'craft','m210624_222934_drop_deprecated_tables','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','41ffc141-328b-42d6-b57c-ccab93c60b32'),(4,'craft','m210724_180756_rename_source_cols','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','223d89d9-acfa-416b-86e9-e4cadeb579a8'),(5,'craft','m210809_124211_remove_superfluous_uids','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','1e8e4703-5947-46cf-962f-c829f79b3e4a'),(6,'craft','m210817_014201_universal_users','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','86a0ea29-e29b-4b74-8205-723951ddf9b0'),(7,'craft','m210904_132612_store_element_source_settings_in_project_config','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','57726c38-1823-477d-920d-4abbc4d63fde'),(8,'craft','m211115_135500_image_transformers','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','df636877-9e69-479f-b6f4-84c404bae241'),(9,'craft','m211201_131000_filesystems','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','732e061c-0e9b-4607-a2a4-be44c20ef966'),(10,'craft','m220103_043103_tab_conditions','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','0fbff83d-cc43-45e3-89bc-86b558e424c0'),(11,'craft','m220104_003433_asset_alt_text','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','d91230ec-bd5f-426d-8f55-51120b2b314b'),(12,'craft','m220123_213619_update_permissions','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','a482a0a4-1249-412e-92ff-0fbf3a8fbd2c'),(13,'craft','m220126_003432_addresses','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','6081e3ca-cfa3-46ae-b0b8-08ecaae9e09a'),(14,'craft','m220209_095604_add_indexes','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','efc9732f-0d66-43e5-91d7-1f149d08d7b5'),(15,'craft','m220213_015220_matrixblocks_owners_table','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','b77b1313-ba9c-48c1-8ac7-c49bc4c6c1ff'),(16,'craft','m220214_000000_truncate_sessions','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','945ad1ca-9ac1-4a49-b4df-4467e1344957'),(17,'craft','m220222_122159_full_names','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','bea81685-b2a6-4c17-bcb6-f62aac75a776'),(18,'craft','m220223_180559_nullable_address_owner','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','8461abf7-598d-4af8-a118-3aab888c40c6'),(19,'craft','m220225_165000_transform_filesystems','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','47342d09-da39-4759-a7d1-da93f4554f6c'),(20,'craft','m220309_152006_rename_field_layout_elements','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','ed157e3c-1530-40de-8dcf-4313f523a315'),(21,'craft','m220314_211928_field_layout_element_uids','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','09f212fc-7d7c-49ac-b11f-23959b9dd39f'),(22,'craft','m220316_123800_transform_fs_subpath','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','0aac934f-10b5-42a2-9224-fd418b4d8753'),(23,'craft','m220317_174250_release_all_jobs','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','21a9b865-4f15-4539-897b-a9abf3cb6c10'),(24,'craft','m220330_150000_add_site_gql_schema_components','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','9a46f022-1300-4dd1-817d-e4dac15b5874'),(25,'craft','m220413_024536_site_enabled_string','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','e4d67f82-23de-4610-a376-87847ef4db11'),(26,'craft','m221027_160703_add_image_transform_fill','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','0edf417b-3570-46e1-87e6-a73ce71f2f38'),(27,'craft','m221028_130548_add_canonical_id_index','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','be3f69d2-3c2e-4f4d-92e7-c21d9dc4def1'),(28,'craft','m221118_003031_drop_element_fks','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','968d7fa1-ab43-4cf3-8923-06a4cdc7cc97'),(29,'craft','m230131_120713_asset_indexing_session_new_options','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','43b56d2d-370c-4445-9b80-41eb6f84ed47'),(30,'craft','m230226_013114_drop_plugin_license_columns','2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-16 17:40:42','02bf8a85-d03b-48f8-9efe-a0eb881c6502');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `projectconfig` VALUES ('dateModified','1708105241'),('email.fromEmail','\"dev@primariu.pt\"'),('email.fromName','\"Junta Cooperativamaismesaofrio\"'),('email.transportType','\"craft\\\\mail\\\\transportadapters\\\\Sendmail\"'),('fieldGroups.52344ede-a26d-4fbf-a81c-5ddb1d312483.name','\"Common\"'),('meta.__names__.26c2b616-574d-43e2-b10c-e89b7a84b056','\"Junta Cooperativamaismesaofrio\"'),('meta.__names__.52344ede-a26d-4fbf-a81c-5ddb1d312483','\"Common\"'),('meta.__names__.614c673f-bac0-46c7-9be3-28a54870bd96','\"Junta Cooperativamaismesaofrio\"'),('siteGroups.614c673f-bac0-46c7-9be3-28a54870bd96.name','\"Junta Cooperativamaismesaofrio\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.baseUrl','\"$PRIMARY_SITE_URL\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.handle','\"default\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.hasUrls','true'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.language','\"pt\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.name','\"Junta Cooperativamaismesaofrio\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.primary','true'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.siteGroup','\"614c673f-bac0-46c7-9be3-28a54870bd96\"'),('sites.26c2b616-574d-43e2-b10c-e89b7a84b056.sortOrder','1'),('system.edition','\"solo\"'),('system.live','true'),('system.name','\"Junta Cooperativamaismesaofrio\"'),('system.schemaVersion','\"4.4.0.4\"'),('system.timeZone','\"America/Los_Angeles\"'),('users.allowPublicRegistration','false'),('users.defaultGroup','null'),('users.photoSubpath','null'),('users.photoVolumeUid','null'),('users.requireEmailVerification','true');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `searchindex` VALUES (1,'email',0,1,' dev primariu pt '),(1,'firstname',0,1,''),(1,'fullname',0,1,''),(1,'lastname',0,1,''),(1,'slug',0,1,''),(1,'username',0,1,' dev primariu pt ');
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `sitegroups` VALUES (1,'Junta Cooperativamaismesaofrio','2024-02-16 17:40:41','2024-02-16 17:40:41',NULL,'614c673f-bac0-46c7-9be3-28a54870bd96');
commit;

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

set autocommit=0;
INSERT INTO `sites` VALUES (1,1,1,'true','Junta Cooperativamaismesaofrio','default','pt',1,'$PRIMARY_SITE_URL',1,'2024-02-16 17:40:41','2024-02-16 17:40:41',NULL,'26c2b616-574d-43e2-b10c-e89b7a84b056');
commit;

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

set autocommit=0;
commit;

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

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

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

set autocommit=0;
commit;

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

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

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

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

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

set autocommit=0;
commit;

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

set autocommit=0;
commit;

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

set autocommit=0;
INSERT INTO `widgets` VALUES (1,1,'craft\\widgets\\RecentEntries',1,NULL,'{\"siteId\":1,\"section\":\"*\",\"limit\":10}',1,'2024-02-16 17:40:43','2024-02-16 17:40:43','c2dc6ddc-6288-4fa1-8629-4cfb2aba1fe7'),(2,1,'craft\\widgets\\CraftSupport',2,NULL,'[]',1,'2024-02-16 17:40:43','2024-02-16 17:40:43','bb402e5b-d89b-4d7b-97d8-1a143cb31df1'),(3,1,'craft\\widgets\\Updates',3,NULL,'[]',1,'2024-02-16 17:40:43','2024-02-16 17:40:43','e90bdc33-09d6-4855-b2d5-6dd0aed269e1'),(4,1,'craft\\widgets\\Feed',4,NULL,'{\"url\":\"https:\\/\\/craftcms.com\\/news.rss\",\"title\":\"Craft News\",\"limit\":5}',1,'2024-02-16 17:40:43','2024-02-16 17:40:43','7265e0eb-6f30-463b-8c54-d675f0c186fa');
commit;

--
-- Dumping routines for database 'cooperativamaism_junta'
--


