-- MySQL dump 10.13 Distrib 5.7.41, for Linux (x86_64) -- -- Host: 127.0.0.1 Database: cooperativamaism_junta -- ------------------------------------------------------ -- Server version 5.7.41 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `addresses` -- DROP TABLE IF EXISTS `addresses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `announcements` -- DROP TABLE IF EXISTS `announcements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `assetindexdata` -- DROP TABLE IF EXISTS `assetindexdata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assetindexdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessionId` int(11) NOT NULL, `volumeId` int(11) NOT NULL, `uri` text, `size` bigint(20) unsigned DEFAULT NULL, `timestamp` datetime DEFAULT NULL, `isDir` tinyint(1) DEFAULT '0', `recordId` int(11) DEFAULT NULL, `isSkipped` tinyint(1) DEFAULT '0', `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 `idx_snalxdmvfvbfrrrgtxfiyuhqbpkjaanzmccp` (`sessionId`,`volumeId`), KEY `idx_wvvodkedpufyafidkepaqcsuzamdlnnlidzv` (`volumeId`), CONSTRAINT `fk_gyjagmcxdkbkhyftthnncgkybfmqsbtyjsqq` FOREIGN KEY (`sessionId`) REFERENCES `assetindexingsessions` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_oavmzazanwakyzwkgnedrgioxgmkavlqrkbm` FOREIGN KEY (`volumeId`) REFERENCES `volumes` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `assetindexingsessions` -- DROP TABLE IF EXISTS `assetindexingsessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `assets` -- DROP TABLE IF EXISTS `assets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `categorygroups` -- DROP TABLE IF EXISTS `categorygroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `categorygroups_sites` -- DROP TABLE IF EXISTS `categorygroups_sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `changedattributes` -- DROP TABLE IF EXISTS `changedattributes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `changedfields` -- DROP TABLE IF EXISTS `changedfields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `content` -- DROP TABLE IF EXISTS `content`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `craftidtokens` -- DROP TABLE IF EXISTS `craftidtokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 `fk_bpeoaqcfqwiceohthbrexwllnutsgixjclom` (`userId`), CONSTRAINT `fk_bpeoaqcfqwiceohthbrexwllnutsgixjclom` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `deprecationerrors` -- DROP TABLE IF EXISTS `deprecationerrors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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(6) 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 `idx_aqlhkurqylvdueifdxhqrywaavbivdwyqqgr` (`key`,`fingerprint`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `drafts` -- DROP TABLE IF EXISTS `drafts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `elements` -- DROP TABLE IF EXISTS `elements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `elements_sites` -- DROP TABLE IF EXISTS `elements_sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `entries` -- DROP TABLE IF EXISTS `entries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `entrytypes` -- DROP TABLE IF EXISTS `entrytypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fieldgroups` -- DROP TABLE IF EXISTS `fieldgroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fieldlayoutfields` -- DROP TABLE IF EXISTS `fieldlayoutfields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fieldlayouts` -- DROP TABLE IF EXISTS `fieldlayouts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fieldlayouttabs` -- DROP TABLE IF EXISTS `fieldlayouttabs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fields` -- DROP TABLE IF EXISTS `fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `globalsets` -- DROP TABLE IF EXISTS `globalsets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gqlschemas` -- DROP TABLE IF EXISTS `gqlschemas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gqltokens` -- DROP TABLE IF EXISTS `gqltokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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`), UNIQUE KEY `idx_qjdywawzwqhvbmjjxrgbuovfrufyehzurixc` (`accessToken`), UNIQUE KEY `idx_lpixzeafwhrviyxwgbgmivtkcpsetxwghdgf` (`name`), KEY `fk_nyyfzrawtqbktpsjlnyrmhfvpmbjwnuxzhmc` (`schemaId`), CONSTRAINT `fk_nyyfzrawtqbktpsjlnyrmhfvpmbjwnuxzhmc` FOREIGN KEY (`schemaId`) REFERENCES `gqlschemas` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `imagetransformindex` -- DROP TABLE IF EXISTS `imagetransformindex`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `imagetransforms` -- DROP TABLE IF EXISTS `imagetransforms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `info` -- DROP TABLE IF EXISTS `info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `matrixblocks` -- DROP TABLE IF EXISTS `matrixblocks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `matrixblocks_owners` -- DROP TABLE IF EXISTS `matrixblocks_owners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `matrixblocktypes` -- DROP TABLE IF EXISTS `matrixblocktypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `plugins` -- DROP TABLE IF EXISTS `plugins`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `projectconfig` -- DROP TABLE IF EXISTS `projectconfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `projectconfig` ( `path` varchar(255) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `queue` -- DROP TABLE IF EXISTS `queue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `relations` -- DROP TABLE IF EXISTS `relations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `resourcepaths` -- DROP TABLE IF EXISTS `resourcepaths`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `resourcepaths` ( `hash` varchar(255) NOT NULL, `path` varchar(255) NOT NULL, PRIMARY KEY (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `revisions` -- DROP TABLE IF EXISTS `revisions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `searchindex` -- DROP TABLE IF EXISTS `searchindex`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sections` -- DROP TABLE IF EXISTS `sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sections_sites` -- DROP TABLE IF EXISTS `sections_sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sequences` -- DROP TABLE IF EXISTS `sequences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sequences` ( `name` varchar(255) NOT NULL, `next` int(11) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 `idx_hbaqsziczdksygutkjphypznmtqsgfhwhrwa` (`uid`), KEY `idx_kkbsirqsuwjmeiormfdzylbaonadahzeahxs` (`token`), KEY `idx_rdxrcahphlslttydxkywiqkjwmsljsdjnonw` (`dateUpdated`), KEY `idx_hhjqyfbwvzvkjpxqasphddkylpxqofoxrfih` (`userId`), CONSTRAINT `fk_xzvjwkyfpgcwhlnvyrerfjsgcffodvlxpxzk` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `shunnedmessages` -- DROP TABLE IF EXISTS `shunnedmessages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sitegroups` -- DROP TABLE IF EXISTS `sitegroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sites` -- DROP TABLE IF EXISTS `sites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `structureelements` -- DROP TABLE IF EXISTS `structureelements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `structures` -- DROP TABLE IF EXISTS `structures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `systemmessages` -- DROP TABLE IF EXISTS `systemmessages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 `idx_iqljanwnwgswozyoxbbitmooyreieauztbaf` (`key`,`language`), KEY `idx_epxvqmidijnfdxbercnihfxrhfburmvodkny` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `taggroups` -- DROP TABLE IF EXISTS `taggroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tokens` -- DROP TABLE IF EXISTS `tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 `idx_pbxlrxkjwaviwqwnfehhsxipskypjcptprnj` (`token`), KEY `idx_hmhpnomtcpeeoqpycrhagmcgxpzefbashjxj` (`expiryDate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `usergroups` -- DROP TABLE IF EXISTS `usergroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `usergroups_users` -- DROP TABLE IF EXISTS `usergroups_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userpermissions` -- DROP TABLE IF EXISTS `userpermissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userpermissions_usergroups` -- DROP TABLE IF EXISTS `userpermissions_usergroups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userpermissions_users` -- DROP TABLE IF EXISTS `userpermissions_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `userpreferences` -- DROP TABLE IF EXISTS `userpreferences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) NOT NULL, `photoId` int(11) DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT '0', `pending` tinyint(1) NOT NULL DEFAULT '0', `locked` tinyint(1) NOT NULL DEFAULT '0', `suspended` tinyint(1) NOT NULL DEFAULT '0', `admin` tinyint(1) NOT NULL DEFAULT '0', `username` varchar(255) DEFAULT NULL, `fullName` varchar(255) DEFAULT NULL, `firstName` varchar(255) DEFAULT NULL, `lastName` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `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, PRIMARY KEY (`id`), KEY `idx_janrxdfomtzcssampdtvenltkffrafdtcvws` (`active`), KEY `idx_fqeuczlnhaahqfpkofzgkjyteoubhislrnmm` (`locked`), KEY `idx_dvpeukfufokucsnryrfzjujbqibgzvrwpdxf` (`pending`), KEY `idx_hoglppnwawwqlearrdelxtybprtvphubzvrj` (`suspended`), KEY `idx_zdpbmgwveogcgmcsymaghthnlyilyptxzjhl` (`verificationCode`), KEY `idx_jknateeyxfcqhcaizwzunbaaljuwxahafpwq` (`email`), KEY `idx_hzkkfsfrgatmrbyyitjiaaoghxldprttpuix` (`username`), KEY `fk_ayycygqtlmxpsnpnctgydjuwjomijvvvojks` (`photoId`), CONSTRAINT `fk_ayycygqtlmxpsnpnctgydjuwjomijvvvojks` FOREIGN KEY (`photoId`) REFERENCES `assets` (`id`) ON DELETE SET NULL, CONSTRAINT `fk_zfzwtoobwvdwxjyvikttocgrmciknlkfjkpy` FOREIGN KEY (`id`) REFERENCES `elements` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `volumefolders` -- DROP TABLE IF EXISTS `volumefolders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `volumes` -- DROP TABLE IF EXISTS `volumes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `widgets` -- DROP TABLE IF EXISTS `widgets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping routines for database 'cooperativamaism_junta' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-02-19 12:16:43 -- MySQL dump 10.13 Distrib 5.7.41, for Linux (x86_64) -- -- Host: 127.0.0.1 Database: cooperativamaism_junta -- ------------------------------------------------------ -- Server version 5.7.41 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Dumping data for table `addresses` -- LOCK TABLES `addresses` WRITE; /*!40000 ALTER TABLE `addresses` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `addresses` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `announcements` -- LOCK TABLES `announcements` WRITE; /*!40000 ALTER TABLE `announcements` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `announcements` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `assetindexingsessions` -- LOCK TABLES `assetindexingsessions` WRITE; /*!40000 ALTER TABLE `assetindexingsessions` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `assetindexingsessions` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `assets` -- LOCK TABLES `assets` WRITE; /*!40000 ALTER TABLE `assets` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `assets` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `categorygroups` -- LOCK TABLES `categorygroups` WRITE; /*!40000 ALTER TABLE `categorygroups` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `categorygroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `categorygroups_sites` -- LOCK TABLES `categorygroups_sites` WRITE; /*!40000 ALTER TABLE `categorygroups_sites` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `categorygroups_sites` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `changedattributes` -- LOCK TABLES `changedattributes` WRITE; /*!40000 ALTER TABLE `changedattributes` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `changedattributes` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `changedfields` -- LOCK TABLES `changedfields` WRITE; /*!40000 ALTER TABLE `changedfields` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `changedfields` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `content` -- LOCK TABLES `content` WRITE; /*!40000 ALTER TABLE `content` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `content` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `craftidtokens` -- LOCK TABLES `craftidtokens` WRITE; /*!40000 ALTER TABLE `craftidtokens` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `craftidtokens` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `deprecationerrors` -- LOCK TABLES `deprecationerrors` WRITE; /*!40000 ALTER TABLE `deprecationerrors` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `deprecationerrors` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `drafts` -- LOCK TABLES `drafts` WRITE; /*!40000 ALTER TABLE `drafts` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `drafts` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `elements` -- LOCK TABLES `elements` WRITE; /*!40000 ALTER TABLE `elements` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `elements` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `elements_sites` -- LOCK TABLES `elements_sites` WRITE; /*!40000 ALTER TABLE `elements_sites` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `elements_sites` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `entries` -- LOCK TABLES `entries` WRITE; /*!40000 ALTER TABLE `entries` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `entries` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `entrytypes` -- LOCK TABLES `entrytypes` WRITE; /*!40000 ALTER TABLE `entrytypes` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `entrytypes` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `fieldgroups` -- LOCK TABLES `fieldgroups` WRITE; /*!40000 ALTER TABLE `fieldgroups` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `fieldgroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `fieldlayoutfields` -- LOCK TABLES `fieldlayoutfields` WRITE; /*!40000 ALTER TABLE `fieldlayoutfields` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `fieldlayoutfields` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `fieldlayouts` -- LOCK TABLES `fieldlayouts` WRITE; /*!40000 ALTER TABLE `fieldlayouts` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `fieldlayouts` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `fieldlayouttabs` -- LOCK TABLES `fieldlayouttabs` WRITE; /*!40000 ALTER TABLE `fieldlayouttabs` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `fieldlayouttabs` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `fields` -- LOCK TABLES `fields` WRITE; /*!40000 ALTER TABLE `fields` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `fields` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `globalsets` -- LOCK TABLES `globalsets` WRITE; /*!40000 ALTER TABLE `globalsets` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `globalsets` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `gqlschemas` -- LOCK TABLES `gqlschemas` WRITE; /*!40000 ALTER TABLE `gqlschemas` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `gqlschemas` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `gqltokens` -- LOCK TABLES `gqltokens` WRITE; /*!40000 ALTER TABLE `gqltokens` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `gqltokens` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `imagetransforms` -- LOCK TABLES `imagetransforms` WRITE; /*!40000 ALTER TABLE `imagetransforms` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `imagetransforms` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `info` -- LOCK TABLES `info` WRITE; /*!40000 ALTER TABLE `info` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `info` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `matrixblocks` -- LOCK TABLES `matrixblocks` WRITE; /*!40000 ALTER TABLE `matrixblocks` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `matrixblocks` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `matrixblocks_owners` -- LOCK TABLES `matrixblocks_owners` WRITE; /*!40000 ALTER TABLE `matrixblocks_owners` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `matrixblocks_owners` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `matrixblocktypes` -- LOCK TABLES `matrixblocktypes` WRITE; /*!40000 ALTER TABLE `matrixblocktypes` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `matrixblocktypes` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `plugins` -- LOCK TABLES `plugins` WRITE; /*!40000 ALTER TABLE `plugins` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `plugins` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `projectconfig` -- LOCK TABLES `projectconfig` WRITE; /*!40000 ALTER TABLE `projectconfig` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `projectconfig` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `queue` -- LOCK TABLES `queue` WRITE; /*!40000 ALTER TABLE `queue` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `queue` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `relations` -- LOCK TABLES `relations` WRITE; /*!40000 ALTER TABLE `relations` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `relations` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `revisions` -- LOCK TABLES `revisions` WRITE; /*!40000 ALTER TABLE `revisions` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `revisions` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `searchindex` -- LOCK TABLES `searchindex` WRITE; /*!40000 ALTER TABLE `searchindex` DISABLE KEYS */; 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 '); /*!40000 ALTER TABLE `searchindex` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `sections` -- LOCK TABLES `sections` WRITE; /*!40000 ALTER TABLE `sections` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `sections` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `sections_sites` -- LOCK TABLES `sections_sites` WRITE; /*!40000 ALTER TABLE `sections_sites` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `sections_sites` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `sequences` -- LOCK TABLES `sequences` WRITE; /*!40000 ALTER TABLE `sequences` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `sequences` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `shunnedmessages` -- LOCK TABLES `shunnedmessages` WRITE; /*!40000 ALTER TABLE `shunnedmessages` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `shunnedmessages` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `sitegroups` -- LOCK TABLES `sitegroups` WRITE; /*!40000 ALTER TABLE `sitegroups` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `sitegroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `sites` -- LOCK TABLES `sites` WRITE; /*!40000 ALTER TABLE `sites` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `sites` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `structureelements` -- LOCK TABLES `structureelements` WRITE; /*!40000 ALTER TABLE `structureelements` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `structureelements` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `structures` -- LOCK TABLES `structures` WRITE; /*!40000 ALTER TABLE `structures` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `structures` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `systemmessages` -- LOCK TABLES `systemmessages` WRITE; /*!40000 ALTER TABLE `systemmessages` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `systemmessages` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `taggroups` -- LOCK TABLES `taggroups` WRITE; /*!40000 ALTER TABLE `taggroups` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `taggroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `tags` -- LOCK TABLES `tags` WRITE; /*!40000 ALTER TABLE `tags` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `tags` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `tokens` -- LOCK TABLES `tokens` WRITE; /*!40000 ALTER TABLE `tokens` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `tokens` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `usergroups` -- LOCK TABLES `usergroups` WRITE; /*!40000 ALTER TABLE `usergroups` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `usergroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `usergroups_users` -- LOCK TABLES `usergroups_users` WRITE; /*!40000 ALTER TABLE `usergroups_users` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `usergroups_users` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `userpermissions` -- LOCK TABLES `userpermissions` WRITE; /*!40000 ALTER TABLE `userpermissions` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `userpermissions` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `userpermissions_usergroups` -- LOCK TABLES `userpermissions_usergroups` WRITE; /*!40000 ALTER TABLE `userpermissions_usergroups` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `userpermissions_usergroups` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `userpermissions_users` -- LOCK TABLES `userpermissions_users` WRITE; /*!40000 ALTER TABLE `userpermissions_users` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `userpermissions_users` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `userpreferences` -- LOCK TABLES `userpreferences` WRITE; /*!40000 ALTER TABLE `userpreferences` DISABLE KEYS */; set autocommit=0; INSERT INTO `userpreferences` VALUES (1,'{\"language\":\"pt\"}'); /*!40000 ALTER TABLE `userpreferences` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; set autocommit=0; INSERT INTO `users` VALUES (1,NULL,1,0,0,0,1,'dev@primariu.pt',NULL,NULL,NULL,'dev@primariu.pt','$2y$13$.dQXf02qW1cNbHVfgalmXOTIUvQHAbKZ0IzqVJ9uIR1liASTL0R0u','2024-02-19 12:15:24',NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,'2024-02-16 17:40:42','2024-02-16 17:40:42','2024-02-19 12:15:24'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `volumefolders` -- LOCK TABLES `volumefolders` WRITE; /*!40000 ALTER TABLE `volumefolders` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `volumefolders` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `volumes` -- LOCK TABLES `volumes` WRITE; /*!40000 ALTER TABLE `volumes` DISABLE KEYS */; set autocommit=0; /*!40000 ALTER TABLE `volumes` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping data for table `widgets` -- LOCK TABLES `widgets` WRITE; /*!40000 ALTER TABLE `widgets` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `widgets` ENABLE KEYS */; UNLOCK TABLES; commit; -- -- Dumping routines for database 'cooperativamaism_junta' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-02-19 12:16:43