-- Table structure for table `DEDataDefinitionFieldLink`
--

CREATE TABLE `DEDataDefinitionFieldLink` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `deDataDefinitionFieldLinkId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `ddmStructureId` bigint(20) DEFAULT NULL,
  `fieldName` varchar(255) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`deDataDefinitionFieldLinkId`,`ctCollectionId`),
  UNIQUE KEY `IX_B0B67DC9` (`ddmStructureId`,`classNameId`,`fieldName`,`classPK`,`ctCollectionId`),
  UNIQUE KEY `IX_2F184154` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_99628DD1` (`classNameId`,`classPK`),
  KEY `IX_E931B304` (`ddmStructureId`,`fieldName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DEDataDefinitionFieldLink`
--


--
-- Table structure for table `DEDataListView`
--

CREATE TABLE `DEDataListView` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `deDataListViewId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `appliedFilters` longtext DEFAULT NULL,
  `ddmStructureId` bigint(20) DEFAULT NULL,
  `fieldNames` longtext DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `sortField` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`deDataListViewId`,`ctCollectionId`),
  UNIQUE KEY `IX_275E4568` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_1C932689` (`ddmStructureId`),
  KEY `IX_6C111CBD` (`groupId`,`ddmStructureId`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DEDataListView`
--


--
-- Table structure for table `DLContent`
--

CREATE TABLE `DLContent` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `contentId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `path_` varchar(255) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `data_` longblob DEFAULT NULL,
  `size_` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`contentId`,`ctCollectionId`),
  UNIQUE KEY `IX_8E223106` (`companyId`,`repositoryId`,`path_`,`version`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLContent`
--


--
-- Table structure for table `DLFileEntry`
--

CREATE TABLE `DLFileEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `fileEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `folderId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `fileName` varchar(255) DEFAULT NULL,
  `extension` varchar(75) DEFAULT NULL,
  `mimeType` varchar(75) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `extraSettings` longtext DEFAULT NULL,
  `fileEntryTypeId` bigint(20) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `size_` bigint(20) DEFAULT NULL,
  `smallImageId` bigint(20) DEFAULT NULL,
  `largeImageId` bigint(20) DEFAULT NULL,
  `custom1ImageId` bigint(20) DEFAULT NULL,
  `custom2ImageId` bigint(20) DEFAULT NULL,
  `manualCheckInRequired` tinyint(4) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `reviewDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fileEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_761F8629` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_672F1AA0` (`groupId`,`ctCollectionId`,`uuid_`),
  UNIQUE KEY `IX_1920CC0C` (`groupId`,`folderId`,`ctCollectionId`,`fileName`),
  UNIQUE KEY `IX_7BDA28F0` (`groupId`,`folderId`,`ctCollectionId`,`name`),
  UNIQUE KEY `IX_4ADDCFF7` (`groupId`,`folderId`,`ctCollectionId`,`title`),
  KEY `IX_4CB1B2B4` (`companyId`),
  KEY `IX_B8526DBE` (`custom1ImageId`),
  KEY `IX_AC9BDEDD` (`custom2ImageId`),
  KEY `IX_772ECDE7` (`fileEntryTypeId`),
  KEY `IX_8F6C75D0` (`folderId`,`name`),
  KEY `IX_57FFBBCA` (`folderId`,`repositoryId`),
  KEY `IX_29D0AF28` (`groupId`,`folderId`,`fileEntryTypeId`),
  KEY `IX_1DC796CD` (`groupId`,`folderId`,`userId`),
  KEY `IX_43261870` (`groupId`,`userId`),
  KEY `IX_4DB7A143` (`largeImageId`),
  KEY `IX_D9492CF6` (`mimeType`),
  KEY `IX_9EE96CAD` (`repositoryId`),
  KEY `IX_25F5CAB9` (`smallImageId`,`largeImageId`,`custom1ImageId`,`custom2ImageId`),
  KEY `IX_64F0FE40` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileEntry`
--

INSERT INTO `DLFileEntry` VALUES
(1,0,'a555ef51-da9b-b981-4b0e-06d4af69dd19','a555ef51-da9b-b981-4b0e-06d4af69dd19',31718,20120,64463788232944,20096,NULL,'2024-11-21 12:19:40.068000','2024-11-21 12:19:40.182000',28882,101,31713,31717,'/31714/31717/','1','id-e17b5c49-6792-5953-296f-af0a2b1ff77',NULL,'image/png','id-e17b5c49-6792-5953-296f-af0a2b1ff77',NULL,'',0,'1.0',846,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'3055c450-1c55-a0f1-ac58-0118e30ee5f8','image.default.company.logo',31803,20120,64463788232944,20096,NULL,'2024-11-21 12:19:42.103000','2024-11-21 12:19:42.116000',0,0,31801,31802,'/31802/','2','company_logo.png','png','image/png','company_logo.png',NULL,'',0,'1.0',634,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'8ae0d697-90c5-7827-8a23-6f757790701e','8ae0d697-90c5-7827-8a23-6f757790701e',31831,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:44.897000','2024-11-21 12:19:44.927000',0,0,20117,31829,'/31829/','3','astronaut.png','png','image/png','astronaut.png',NULL,'',0,'1.0',40255,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'756d79da-250e-4f8a-3f54-999abc9e3924','756d79da-250e-4f8a-3f54-999abc9e3924',31841,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.170000','2024-11-21 12:19:45.190000',0,0,20117,31829,'/31829/','4','earth.png','png','image/png','earth.png',NULL,'',0,'1.0',356773,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'a52a042c-d9c7-7204-a5be-7877a567009e','a52a042c-d9c7-7204-a5be-7877a567009e',31852,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.470000','2024-11-21 12:19:45.499000',0,0,20117,31829,'/31829/','5','moon.png','png','image/png','moon.png',NULL,'',0,'1.0',5720,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'8b66e9b9-2e39-faea-1f58-0911afcc0c18','8b66e9b9-2e39-faea-1f58-0911afcc0c18',31864,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.817000','2024-11-21 12:19:45.862000',0,0,20117,31829,'/31829/','6','planet.png','png','image/png','planet.png',NULL,'',0,'1.0',8440,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'8e07bfda-2bd8-805f-0bea-ff13014fdd85','8e07bfda-2bd8-805f-0bea-ff13014fdd85',31877,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.218000','2024-11-21 12:19:46.251000',0,0,20117,31829,'/31829/','7','satellite.png','png','image/png','satellite.png',NULL,'',0,'1.0',14429,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'14719bba-6841-dc15-bb3d-8a0ebcc5fff1','14719bba-6841-dc15-bb3d-8a0ebcc5fff1',31889,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.509000','2024-11-21 12:19:46.526000',0,0,20117,31829,'/31829/','8','stars.png','png','image/png','stars.png',NULL,'',0,'1.0',35548,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'f2cc664c-d4c4-f133-a5d0-9f6d3241c45c','f2cc664c-d4c4-f133-a5d0-9f6d3241c45c',31901,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.739000','2024-11-21 12:19:46.771000',0,0,20117,31829,'/31829/','9','tree.png','png','image/png','tree.png',NULL,'',0,'1.0',367504,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'081b5d64-8cab-2fd9-6be1-d1a8233e1f4c','081b5d64-8cab-2fd9-6be1-d1a8233e1f4c',31941,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.675000','2024-11-21 12:19:50.698000',28934,31915,31939,31940,'/31940/','10','31915_preview.png','png','image/png','31915_preview.png',NULL,'',0,'1.0',604726,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'dc31eb8d-e816-b826-ca2b-b39da6c867eb','dc31eb8d-e816-b826-ca2b-b39da6c867eb',31972,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.286000','2024-11-21 12:19:51.342000',28934,31946,31939,31940,'/31940/','11','31946_preview.png','png','image/png','31946_preview.png',NULL,'',0,'1.0',307368,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'ff939be8-d3ff-9e12-03a6-6f9a0cfa774a','ff939be8-d3ff-9e12-03a6-6f9a0cfa774a',32021,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.913000','2024-11-21 12:19:51.932000',28934,31977,31939,31940,'/31940/','12','31977_preview.png','png','image/png','31977_preview.png',NULL,'',0,'1.0',4846,0,0,0,0,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `DLFileEntryMetadata`
--

CREATE TABLE `DLFileEntryMetadata` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `fileEntryMetadataId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `DDMStorageId` bigint(20) DEFAULT NULL,
  `DDMStructureId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `fileVersionId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`fileEntryMetadataId`,`ctCollectionId`),
  UNIQUE KEY `IX_5DC2B977` (`fileVersionId`,`DDMStructureId`,`ctCollectionId`),
  KEY `IX_4F40FE5E` (`fileEntryId`),
  KEY `IX_D49AB5D1` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileEntryMetadata`
--

INSERT INTO `DLFileEntryMetadata` VALUES
(0,0,'11c0657c-b4e1-c0b2-2836-7512e11aad99',31724,64463788232944,31725,30603,31718,31719),
(0,0,'9702e22d-cdc4-1bd1-f825-c39a47584f91',31808,64463788232944,31809,30603,31803,31804),
(0,0,'1ed92502-944a-97e7-822e-4ec80a1cead7',31837,64463788232944,31838,30603,31831,31832),
(0,0,'67b14eca-9c42-f1fe-0306-566b2f78c405',31848,64463788232944,31849,30603,31841,31842),
(0,0,'9c3161b4-0807-cad0-8396-e2132f45a8ee',31859,64463788232944,31860,30603,31852,31853),
(0,0,'958f5ee2-f1c4-874f-518e-cdde841b4cb7',31872,64463788232944,31873,30603,31864,31865),
(0,0,'071cb1d9-16d7-9c6f-404d-d397804d6bcf',31884,64463788232944,31885,30603,31877,31878),
(0,0,'8dbfe585-25e8-66c5-6516-75cea218c104',31897,64463788232944,31898,30603,31889,31891),
(0,0,'3ca575fb-be0e-091e-5472-77b4ef386658',31907,64463788232944,31908,30603,31901,31902),
(0,0,'fe18f82c-943a-73f0-da3e-04f4b7243bb6',31947,64463788232944,31948,30603,31941,31942),
(0,0,'1c4f3499-8976-4fae-e202-0e2cda95aff5',31978,64463788232944,31979,30603,31972,31973),
(0,0,'4e00a5bc-5c03-2f18-b93a-d0b28d8466e1',32026,64463788232944,32027,30603,32021,32022);

--
-- Table structure for table `DLFileEntryType`
--

CREATE TABLE `DLFileEntryType` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `fileEntryTypeId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `dataDefinitionId` bigint(20) DEFAULT NULL,
  `fileEntryTypeKey` varchar(75) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `scope` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fileEntryTypeId`,`ctCollectionId`),
  UNIQUE KEY `IX_93ED0F06` (`groupId`,`ctCollectionId`,`dataDefinitionId`),
  UNIQUE KEY `IX_A5C4723D` (`groupId`,`ctCollectionId`,`fileEntryTypeKey`),
  UNIQUE KEY `IX_C1518AF6` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_90724726` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileEntryType`
--

INSERT INTO `DLFileEntryType` VALUES
(0,0,'d7c29844-531a-77e5-627d-cf9488088aa7',0,0,0,0,NULL,'2024-11-21 12:17:52.791000','2024-11-21 12:17:52.791000',0,'BASIC-DOCUMENT','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">basic-document</Name></root>',NULL,0,NULL),
(0,0,'0a9f43eb-cdc8-604a-b414-1126f34f0e3c',30705,20120,64463788232944,20096,NULL,'2024-11-21 12:19:21.479000','2024-11-21 12:19:21.479000',30701,'GOOGLE_DOCS','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,sv_SE,pt_BR,ja_JP,fr_FR,hu_HU,de_DE,ca_ES,ar_SA,fi_FI,zh_CN,es_ES,nl_NL\" default-locale=\"en_US\"><Name language-id=\"sv_SE\">Google Drive-genväg</Name><Name language-id=\"pt_BR\">Atalho do Google Drive</Name><Name language-id=\"ja_JP\">Google ドライブのショートカット</Name><Name language-id=\"fr_FR\">Raccourci Google Drive</Name><Name language-id=\"hu_HU\">Google Drive parancsikon</Name><Name language-id=\"de_DE\">Google Drive-Verknüpfung</Name><Name language-id=\"ca_ES\">Drecera de Google Drive</Name><Name language-id=\"ar_SA\">اختصار Google Drive</Name><Name language-id=\"fi_FI\">Google Driven pikavalinta</Name><Name language-id=\"en_US\">Google Drive Shortcut</Name><Name language-id=\"zh_CN\">Google 云端硬盘快捷方式</Name><Name language-id=\"es_ES\">Acceso directo de Google Drive</Name><Name language-id=\"nl_NL\">Snelkoppeling naar Google Drive</Name></root>',NULL,1,NULL),
(0,0,'e262199c-b8f0-bbde-5b4f-55226d9441d0',30905,20120,64463788232944,20096,NULL,'2024-11-21 12:19:22.009000','2024-11-21 12:19:22.009000',30901,'DL_VIDEO_EXTERNAL_SHORTCUT','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,sv_SE,pt_BR,ja_JP,fr_FR,hu_HU,de_DE,ca_ES,ar_SA,fi_FI,zh_CN,es_ES,nl_NL\" default-locale=\"en_US\"><Name language-id=\"sv_SE\">Genväg till extern video</Name><Name language-id=\"pt_BR\">Atalho de vídeo externo</Name><Name language-id=\"ja_JP\">外部動画のショートカット</Name><Name language-id=\"fr_FR\">Raccourci vidéo externe</Name><Name language-id=\"hu_HU\">Külső videó parancsikon</Name><Name language-id=\"de_DE\">Verknüpfung zu externem Video</Name><Name language-id=\"ca_ES\">Drecera de vídeo extern</Name><Name language-id=\"ar_SA\">اختصار الفيديو الخارجي</Name><Name language-id=\"fi_FI\">Ulkoisen videon pikavalinta</Name><Name language-id=\"en_US\">External Video Shortcut</Name><Name language-id=\"zh_CN\">外部视频快捷方式</Name><Name language-id=\"es_ES\">Acceso directo de vídeo externo</Name><Name language-id=\"nl_NL\">Snelkoppeling naar externe video</Name></root>',NULL,1,NULL);

--
-- Table structure for table `DLFileEntryTypes_DLFolders`
--

CREATE TABLE `DLFileEntryTypes_DLFolders` (
  `companyId` bigint(20) NOT NULL,
  `fileEntryTypeId` bigint(20) NOT NULL,
  `folderId` bigint(20) NOT NULL,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctChangeType` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`fileEntryTypeId`,`folderId`,`ctCollectionId`),
  KEY `IX_2E64D9F9` (`companyId`),
  KEY `IX_6E00A2EC` (`folderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileEntryTypes_DLFolders`
--


--
-- Table structure for table `DLFileShortcut`
--

CREATE TABLE `DLFileShortcut` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `fileShortcutId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `folderId` bigint(20) DEFAULT NULL,
  `toFileEntryId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fileShortcutId`,`ctCollectionId`),
  UNIQUE KEY `IX_86FE17F8` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_8571953E` (`companyId`,`status`),
  KEY `IX_17EE3098` (`groupId`,`folderId`,`active_`,`status`),
  KEY `IX_4B7247F6` (`toFileEntryId`),
  KEY `IX_4831EBE4` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileShortcut`
--


--
-- Table structure for table `DLFileVersion`
--

CREATE TABLE `DLFileVersion` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `fileVersionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `folderId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `fileName` varchar(255) DEFAULT NULL,
  `extension` varchar(75) DEFAULT NULL,
  `mimeType` varchar(75) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `changeLog` varchar(75) DEFAULT NULL,
  `extraSettings` longtext DEFAULT NULL,
  `fileEntryTypeId` bigint(20) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `size_` bigint(20) DEFAULT NULL,
  `checksum` varchar(75) DEFAULT NULL,
  `storeUUID` varchar(255) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `reviewDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fileVersionId`,`ctCollectionId`),
  UNIQUE KEY `IX_10E504DF` (`fileEntryId`,`version`,`ctCollectionId`),
  UNIQUE KEY `IX_350F5CAE` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_CF394FE` (`companyId`,`storeUUID`),
  KEY `IX_BC5541ED` (`groupId`,`folderId`,`version`,`title`),
  KEY `IX_FFB3395C` (`mimeType`),
  KEY `IX_5898E799` (`status`,`companyId`,`expirationDate`),
  KEY `IX_92309600` (`status`,`displayDate`),
  KEY `IX_D50EAA41` (`status`,`fileEntryId`),
  KEY `IX_799D5D47` (`status`,`groupId`,`folderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileVersion`
--

INSERT INTO `DLFileVersion` VALUES
(1,0,'5d1574b9-2884-4544-dc98-15af8a6905e1',31719,20120,64463788232944,20096,NULL,'2024-11-21 12:19:40.128000','2024-11-21 12:19:40.182000',31713,31717,31718,'/31714/31717/','id-e17b5c49-6792-5953-296f-af0a2b1ff77',NULL,'image/png','id-e17b5c49-6792-5953-296f-af0a2b1ff77',NULL,NULL,'',0,'1.0',846,NULL,'afdf1e72-cbf2-4470-9518-f043e66ef907',NULL,NULL,NULL,NULL,0,20096,NULL,'2024-11-21 12:19:40.182000'),
(1,0,'fd1a812c-3824-11e9-eba8-ce8205169cd8',31804,20120,64463788232944,20096,NULL,'2024-11-21 12:19:42.106000','2024-11-21 12:19:42.116000',31801,31802,31803,'/31802/','company_logo.png','png','image/png','company_logo.png',NULL,NULL,'',0,'1.0',634,NULL,'c2268e7d-59e9-4465-8b7f-b807d2813dc6',NULL,NULL,NULL,NULL,0,20096,NULL,'2024-11-21 12:19:42.116000'),
(1,0,'797e1e01-0213-a663-c2ef-1ff6b192b92b',31832,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:44.901000','2024-11-21 12:19:44.927000',20117,31829,31831,'/31829/','astronaut.png','png','image/png','astronaut.png',NULL,NULL,'',0,'1.0',40255,NULL,'75cf5295-5318-464b-bf49-93c4f92ccbdb',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:44.927000'),
(1,0,'ac4a2ce0-0679-40d6-0b7e-b68fed28a638',31842,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.173000','2024-11-21 12:19:45.190000',20117,31829,31841,'/31829/','earth.png','png','image/png','earth.png',NULL,NULL,'',0,'1.0',356773,NULL,'11e808af-2035-482d-9835-1d97aeef1c1d',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:45.190000'),
(1,0,'62a060c4-4fe3-b40f-7692-b6025a5e4119',31853,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.477000','2024-11-21 12:19:45.499000',20117,31829,31852,'/31829/','moon.png','png','image/png','moon.png',NULL,NULL,'',0,'1.0',5720,NULL,'c367273b-5309-4514-abc5-db7779629eb4',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:45.499000'),
(1,0,'edd495f3-886f-bb34-484b-5680247c67b1',31865,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.827000','2024-11-21 12:19:45.862000',20117,31829,31864,'/31829/','planet.png','png','image/png','planet.png',NULL,NULL,'',0,'1.0',8440,NULL,'7fb68d33-91bd-4a9e-bc17-bb5606e16c88',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:45.862000'),
(1,0,'363d0a35-f60b-7292-4832-890371799627',31878,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.228000','2024-11-21 12:19:46.251000',20117,31829,31877,'/31829/','satellite.png','png','image/png','satellite.png',NULL,NULL,'',0,'1.0',14429,NULL,'6ab290ca-ea7c-4738-a23b-3f633ced8394',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:46.251000'),
(1,0,'ad193d3b-07b8-c654-5720-6cdb129e21cf',31891,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.513000','2024-11-21 12:19:46.526000',20117,31829,31889,'/31829/','stars.png','png','image/png','stars.png',NULL,NULL,'',0,'1.0',35548,NULL,'a8228265-f91f-4055-8dfc-5a611500853a',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:46.526000'),
(1,0,'d6b0c610-9e01-c310-b12b-ab8b7edd2bd9',31902,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.747000','2024-11-21 12:19:46.771000',20117,31829,31901,'/31829/','tree.png','png','image/png','tree.png',NULL,NULL,'',0,'1.0',367504,NULL,'bb8f67d6-0f67-4a1d-bca7-bf0a92632e5c',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:46.771000'),
(1,0,'a7896695-da38-5e56-b54a-d193ee9b5eb6',31942,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.683000','2024-11-21 12:19:50.698000',31939,31940,31941,'/31940/','31915_preview.png','png','image/png','31915_preview.png',NULL,NULL,'',0,'1.0',604726,NULL,'efa7c888-fbbc-4031-9fbe-9c3a1804d08b',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:50.698000'),
(1,0,'44bcb37c-d845-d9b7-8ed7-c78193c36085',31973,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.332000','2024-11-21 12:19:51.342000',31939,31940,31972,'/31940/','31946_preview.png','png','image/png','31946_preview.png',NULL,NULL,'',0,'1.0',307368,NULL,'ce7fe153-b479-4e1d-86d4-7733b79f5dc8',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:51.342000'),
(1,0,'27aba49d-e89b-6731-3059-78cd064f5d72',32022,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.922000','2024-11-21 12:19:51.932000',31939,31940,32021,'/31940/','31977_preview.png','png','image/png','31977_preview.png',NULL,NULL,'',0,'1.0',4846,NULL,'ee37a26c-2d75-4d67-9887-9f472acb8ccd',NULL,NULL,NULL,NULL,0,20123,'Test Test','2024-11-21 12:19:51.932000');

--
-- Table structure for table `DLFileVersionPreview`
--

CREATE TABLE `DLFileVersionPreview` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `dlFileVersionPreviewId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `fileVersionId` bigint(20) DEFAULT NULL,
  `previewStatus` int(11) DEFAULT NULL,
  PRIMARY KEY (`dlFileVersionPreviewId`,`ctCollectionId`),
  UNIQUE KEY `IX_DA3FFE` (`fileEntryId`,`fileVersionId`,`ctCollectionId`),
  KEY `IX_E43957CD` (`fileVersionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFileVersionPreview`
--


--
-- Table structure for table `DLFolder`
--

CREATE TABLE `DLFolder` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `folderId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `mountPoint` tinyint(4) DEFAULT NULL,
  `parentFolderId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `lastPostDate` datetime(6) DEFAULT NULL,
  `defaultFileEntryTypeId` bigint(20) DEFAULT NULL,
  `hidden_` tinyint(4) DEFAULT NULL,
  `restrictionType` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`folderId`,`ctCollectionId`),
  UNIQUE KEY `IX_F0D74691` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_4C35E652` (`groupId`,`parentFolderId`,`ctCollectionId`,`name`),
  UNIQUE KEY `IX_53E6B584` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_A74DB14C` (`companyId`),
  KEY `IX_CE360BF6` (`groupId`,`parentFolderId`,`hidden_`,`status`),
  KEY `IX_2D8D2D2B` (`groupId`,`parentFolderId`,`mountPoint`,`hidden_`,`status`),
  KEY `IX_D6D77780` (`mountPoint`,`repositoryId`),
  KEY `IX_51556082` (`parentFolderId`,`name`),
  KEY `IX_56F3D47C` (`parentFolderId`,`repositoryId`),
  KEY `IX_EE29C715` (`repositoryId`),
  KEY `IX_B199E2A6` (`status`,`companyId`),
  KEY `IX_CBC408D8` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLFolder`
--

INSERT INTO `DLFolder` VALUES
(1,0,'1d78cae0-e51f-503d-57af-9cdb115157ee','1d78cae0-e51f-503d-57af-9cdb115157ee',31714,20120,64463788232944,20096,NULL,'2024-11-21 12:19:39.769000','2024-11-21 12:19:39.769000',31713,1,0,'/31714/','com.liferay.oauth2.provider',NULL,'2024-11-21 12:19:39.860000',0,1,0,NULL,0,0,NULL,NULL),
(1,0,'d01f4492-221c-23e9-6e70-8cd5989f4d6e','d01f4492-221c-23e9-6e70-8cd5989f4d6e',31717,20120,64463788232944,20096,NULL,'2024-11-21 12:19:39.861000','2024-11-21 12:19:39.861000',31713,0,31714,'/31714/31717/','icons',NULL,'2024-11-21 12:19:40.068000',0,0,0,NULL,0,0,NULL,NULL),
(1,0,'446f98c4-5771-c937-a243-be0703b142d2','446f98c4-5771-c937-a243-be0703b142d2',31802,20120,64463788232944,20096,NULL,'2024-11-21 12:19:41.833000','2024-11-21 12:19:41.833000',31801,1,0,'/31802/','image.default.company.logo',NULL,'2024-11-21 12:19:42.103000',0,1,0,NULL,0,0,NULL,NULL),
(7,0,'06e40407-843e-e6d3-6aab-ad3be15b7d35','06e40407-843e-e6d3-6aab-ad3be15b7d35',31829,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:44.576000','2024-11-21 12:19:44.576000',20117,0,0,'/31829/','Provided by Liferay',NULL,'2024-11-21 12:19:46.739000',0,0,0,NULL,0,0,NULL,NULL),
(3,0,'d1a59eec-9e88-b9e5-25eb-a49ee25ca731','d1a59eec-9e88-b9e5-25eb-a49ee25ca731',31940,20117,64463788232944,20096,NULL,'2024-11-21 12:19:50.643000','2024-11-21 12:19:48.746000',31939,1,0,'/31940/','com_liferay_layout_admin_web_portlet_GroupPagesPortlet',NULL,'2024-11-21 12:19:51.913000',0,1,0,NULL,0,0,NULL,NULL);

--
-- Table structure for table `DLOpenerFileEntryReference`
--

CREATE TABLE `DLOpenerFileEntryReference` (
  `dlOpenerFileEntryReferenceId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `referenceKey` varchar(75) DEFAULT NULL,
  `referenceType` varchar(75) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  PRIMARY KEY (`dlOpenerFileEntryReferenceId`),
  UNIQUE KEY `IX_54148667` (`fileEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLOpenerFileEntryReference`
--


--
-- Table structure for table `DLStorageQuota`
--

CREATE TABLE `DLStorageQuota` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `dlStorageQuotaId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `storageSize` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`dlStorageQuotaId`),
  UNIQUE KEY `IX_1214035D` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLStorageQuota`
--

INSERT INTO `DLStorageQuota` VALUES
(11,31723,64463788232944,1747089);

--
-- Table structure for table `DLSyncEvent`
--

CREATE TABLE `DLSyncEvent` (
  `syncEventId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `modifiedTime` bigint(20) DEFAULT NULL,
  `event` varchar(75) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `typePK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`syncEventId`),
  UNIQUE KEY `IX_57D82B06` (`typePK`),
  KEY `IX_3D8E1607` (`modifiedTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DLSyncEvent`
--


--
-- Table structure for table `DepotAppCustomization`
--

CREATE TABLE `DepotAppCustomization` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `depotAppCustomizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `depotEntryId` bigint(20) DEFAULT NULL,
  `enabled` tinyint(4) DEFAULT NULL,
  `portletId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`depotAppCustomizationId`,`ctCollectionId`),
  UNIQUE KEY `IX_2CE1592A` (`depotEntryId`,`portletId`,`ctCollectionId`),
  KEY `IX_5B76D798` (`depotEntryId`,`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DepotAppCustomization`
--


--
-- Table structure for table `DepotEntry`
--

CREATE TABLE `DepotEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `depotEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`depotEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_E3EB2C84` (`groupId`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DepotEntry`
--


--
-- Table structure for table `DepotEntryGroupRel`
--

CREATE TABLE `DepotEntryGroupRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `depotEntryGroupRelId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `ddmStructuresAvailable` tinyint(4) DEFAULT NULL,
  `depotEntryId` bigint(20) DEFAULT NULL,
  `searchable` tinyint(4) DEFAULT NULL,
  `toGroupId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`depotEntryGroupRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_1DD0EA9C` (`toGroupId`,`depotEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_A83D9516` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_146497CB` (`depotEntryId`),
  KEY `IX_7CA33F81` (`toGroupId`,`ddmStructuresAvailable`),
  KEY `IX_BA106967` (`toGroupId`,`searchable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DepotEntryGroupRel`
--


--
-- Table structure for table `DispatchLog`
--

CREATE TABLE `DispatchLog` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `dispatchLogId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `dispatchTriggerId` bigint(20) DEFAULT NULL,
  `endDate` datetime(6) DEFAULT NULL,
  `error` longtext DEFAULT NULL,
  `output_` longtext DEFAULT NULL,
  `startDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`dispatchLogId`),
  KEY `IX_36F4EB5F` (`dispatchTriggerId`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DispatchLog`
--

INSERT INTO `DispatchLog` VALUES
(1,32219,64463788232944,20096,NULL,'2024-11-22 00:00:00.066000','2024-11-22 00:00:00.076000',30907,'2024-11-22 00:00:00.075000',NULL,NULL,'2024-11-22 00:00:00.064000',2),
(1,32232,64463788232944,20096,NULL,'2024-11-23 00:00:00.021000','2024-11-23 00:00:00.026000',30907,'2024-11-23 00:00:00.026000',NULL,NULL,'2024-11-23 00:00:00.019000',2),
(1,32233,64463788232944,20096,NULL,'2024-11-24 00:00:00.024000','2024-11-24 00:00:00.028000',30907,'2024-11-24 00:00:00.028000',NULL,NULL,'2024-11-24 00:00:00.022000',2),
(1,32234,64463788232944,20096,NULL,'2024-11-25 00:00:00.018000','2024-11-25 00:00:00.029000',30907,'2024-11-25 00:00:00.029000',NULL,NULL,'2024-11-25 00:00:00.016000',2),
(1,32235,64463788232944,20096,NULL,'2024-11-26 00:00:00.024000','2024-11-26 00:00:00.028000',30907,'2024-11-26 00:00:00.028000',NULL,NULL,'2024-11-26 00:00:00.023000',2),
(1,32405,64463788232944,20096,NULL,'2024-11-28 00:00:00.059000','2024-11-28 00:00:00.078000',30907,'2024-11-28 00:00:00.077000',NULL,NULL,'2024-11-28 00:00:00.056000',2),
(1,32406,64463788232944,20096,NULL,'2024-11-29 00:00:00.027000','2024-11-29 00:00:00.032000',30907,'2024-11-29 00:00:00.032000',NULL,NULL,'2024-11-29 00:00:00.025000',2),
(1,32407,64463788232944,20096,NULL,'2024-11-30 00:00:00.021000','2024-11-30 00:00:00.026000',30907,'2024-11-30 00:00:00.026000',NULL,NULL,'2024-11-30 00:00:00.019000',2),
(1,32408,64463788232944,20096,NULL,'2024-12-01 00:00:00.028000','2024-12-01 00:00:00.039000',30907,'2024-12-01 00:00:00.039000',NULL,NULL,'2024-12-01 00:00:00.025000',2),
(1,32409,64463788232944,20096,NULL,'2024-12-02 00:00:00.022000','2024-12-02 00:00:00.029000',30907,'2024-12-02 00:00:00.028000',NULL,NULL,'2024-12-02 00:00:00.020000',2),
(1,32410,64463788232944,20096,NULL,'2024-12-03 00:00:00.027000','2024-12-03 00:00:00.032000',30907,'2024-12-03 00:00:00.032000',NULL,NULL,'2024-12-03 00:00:00.025000',2),
(1,32506,64463788232944,20096,NULL,'2024-12-04 00:00:00.057000','2024-12-04 00:00:00.067000',30907,'2024-12-04 00:00:00.066000',NULL,NULL,'2024-12-04 00:00:00.054000',2),
(1,32612,64463788232944,20096,NULL,'2024-12-05 00:00:00.075000','2024-12-05 00:00:00.087000',30907,'2024-12-05 00:00:00.087000',NULL,NULL,'2024-12-05 00:00:00.073000',2),
(1,32705,64463788232944,20096,NULL,'2024-12-06 00:00:00.063000','2024-12-06 00:00:00.076000',30907,'2024-12-06 00:00:00.075000',NULL,NULL,'2024-12-06 00:00:00.061000',2),
(1,32706,64463788232944,20096,NULL,'2024-12-07 00:00:00.034000','2024-12-07 00:00:00.039000',30907,'2024-12-07 00:00:00.039000',NULL,NULL,'2024-12-07 00:00:00.032000',2),
(1,32707,64463788232944,20096,NULL,'2024-12-08 00:00:00.034000','2024-12-08 00:00:00.039000',30907,'2024-12-08 00:00:00.039000',NULL,NULL,'2024-12-08 00:00:00.032000',2),
(1,32708,64463788232944,20096,NULL,'2024-12-09 00:00:00.032000','2024-12-09 00:00:00.044000',30907,'2024-12-09 00:00:00.044000',NULL,NULL,'2024-12-09 00:00:00.029000',2),
(1,32804,64463788232944,20096,NULL,'2024-12-10 00:00:00.068000','2024-12-10 00:00:00.079000',30907,'2024-12-10 00:00:00.079000',NULL,NULL,'2024-12-10 00:00:00.065000',2),
(1,32905,64463788232944,20096,NULL,'2024-12-11 00:00:00.073000','2024-12-11 00:00:00.085000',30907,'2024-12-11 00:00:00.084000',NULL,NULL,'2024-12-11 00:00:00.069000',2),
(1,32908,64463788232944,20096,NULL,'2024-12-12 00:00:00.033000','2024-12-12 00:00:00.038000',30907,'2024-12-12 00:00:00.038000',NULL,NULL,'2024-12-12 00:00:00.031000',2),
(1,32915,64463788232944,20096,NULL,'2024-12-13 00:00:00.034000','2024-12-13 00:00:00.040000',30907,'2024-12-13 00:00:00.040000',NULL,NULL,'2024-12-13 00:00:00.029000',2),
(1,32922,64463788232944,20096,NULL,'2024-12-14 00:00:00.037000','2024-12-14 00:00:00.049000',30907,'2024-12-14 00:00:00.049000',NULL,NULL,'2024-12-14 00:00:00.032000',2),
(1,32923,64463788232944,20096,NULL,'2024-12-15 00:00:00.023000','2024-12-15 00:00:00.028000',30907,'2024-12-15 00:00:00.028000',NULL,NULL,'2024-12-15 00:00:00.018000',2),
(1,32924,64463788232944,20096,NULL,'2024-12-16 00:00:00.034000','2024-12-16 00:00:00.040000',30907,'2024-12-16 00:00:00.040000',NULL,NULL,'2024-12-16 00:00:00.029000',2),
(1,33007,64463788232944,20096,NULL,'2024-12-17 00:00:00.035000','2024-12-17 00:00:00.040000',30907,'2024-12-17 00:00:00.040000',NULL,NULL,'2024-12-17 00:00:00.030000',2),
(1,33008,64463788232944,20096,NULL,'2024-12-18 00:00:00.038000','2024-12-18 00:00:00.045000',30907,'2024-12-18 00:00:00.045000',NULL,NULL,'2024-12-18 00:00:00.033000',2),
(1,33009,64463788232944,20096,NULL,'2024-12-19 00:00:00.034000','2024-12-19 00:00:00.041000',30907,'2024-12-19 00:00:00.040000',NULL,NULL,'2024-12-19 00:00:00.028000',2),
(1,33034,64463788232944,20096,NULL,'2024-12-20 00:00:00.035000','2024-12-20 00:00:00.041000',30907,'2024-12-20 00:00:00.041000',NULL,NULL,'2024-12-20 00:00:00.032000',2),
(1,33063,64463788232944,20096,NULL,'2024-12-21 00:00:00.024000','2024-12-21 00:00:00.031000',30907,'2024-12-21 00:00:00.030000',NULL,NULL,'2024-12-21 00:00:00.019000',2),
(1,33064,64463788232944,20096,NULL,'2024-12-22 00:00:00.033000','2024-12-22 00:00:00.039000',30907,'2024-12-22 00:00:00.039000',NULL,NULL,'2024-12-22 00:00:00.027000',2),
(1,33065,64463788232944,20096,NULL,'2024-12-23 00:00:00.021000','2024-12-23 00:00:00.026000',30907,'2024-12-23 00:00:00.026000',NULL,NULL,'2024-12-23 00:00:00.018000',2);

--
-- Table structure for table `DispatchTrigger`
--

CREATE TABLE `DispatchTrigger` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `dispatchTriggerId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `cronExpression` varchar(75) DEFAULT NULL,
  `dispatchTaskClusterMode` int(11) DEFAULT NULL,
  `dispatchTaskExecutorType` varchar(75) DEFAULT NULL,
  `dispatchTaskSettings` longtext DEFAULT NULL,
  `endDate` datetime(6) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `overlapAllowed` tinyint(4) DEFAULT NULL,
  `startDate` datetime(6) DEFAULT NULL,
  `system_` tinyint(4) DEFAULT NULL,
  `timeZoneId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`dispatchTriggerId`),
  UNIQUE KEY `IX_10690B19` (`companyId`,`externalReferenceCode`),
  UNIQUE KEY `IX_D86DCE63` (`companyId`,`name`),
  KEY `IX_71D6AFE9` (`active_`,`dispatchTaskClusterMode`),
  KEY `IX_1B108A04` (`companyId`,`dispatchTaskExecutorType`),
  KEY `IX_F6ABBDDE` (`companyId`,`userId`),
  KEY `IX_EF08D30` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `DispatchTrigger`
--

INSERT INTO `DispatchTrigger` VALUES
(1,'7df9484a-5456-6176-5b0b-e1e0bb77f2b8','7df9484a-5456-6176-5b0b-e1e0bb77f2b8',30907,64463788232944,20096,NULL,'2024-11-21 12:19:23.142000','2024-11-21 12:19:23.160000',1,'0 0 0 * * ?',0,'scheduled-publications-conflict-checks','',NULL,'scheduled-publications-conflict-checks',0,'2024-11-21 12:19:00.000000',1,'UTC');

--
-- Table structure for table `EmailAddress`
--

CREATE TABLE `EmailAddress` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `emailAddressId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `address` varchar(254) DEFAULT NULL,
  `listTypeId` bigint(20) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`emailAddressId`,`ctCollectionId`),
  KEY `IX_2A2CB130` (`companyId`,`classNameId`,`classPK`,`primary_`),
  KEY `IX_7B43CD8` (`userId`),
  KEY `IX_D24F3956` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `EmailAddress`
--

INSERT INTO `EmailAddress` VALUES
(1,0,'bc17267a-5189-9ab8-26c9-54955dd0484d',32917,64463788232944,20123,'Test Test','2024-12-13 11:15:29.034000','2024-12-13 11:15:29.091000',28707,32503,'rockseller@isp.com',13,1);

--
-- Table structure for table `ExpandoColumn`
--

CREATE TABLE `ExpandoColumn` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `columnId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `tableId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `defaultData` longtext DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  PRIMARY KEY (`columnId`,`ctCollectionId`),
  UNIQUE KEY `IX_4A7D3605` (`tableId`,`name`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ExpandoColumn`
--

INSERT INTO `ExpandoColumn` VALUES
(0,0,20378,64463788232944,'2024-11-21 12:18:11.058000',20377,'accessSecret',15,'',''),
(0,0,20379,64463788232944,'2024-11-21 12:18:11.073000',20377,'accessToken',15,'',''),
(0,0,20380,64463788232944,'2024-11-21 12:18:11.082000',20377,'requestSecret',15,'',''),
(0,0,20381,64463788232944,'2024-11-21 12:18:11.091000',20377,'requestToken',15,'','');

--
-- Table structure for table `ExpandoRow`
--

CREATE TABLE `ExpandoRow` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `rowId_` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `tableId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`rowId_`,`ctCollectionId`),
  UNIQUE KEY `IX_488E0C53` (`tableId`,`classPK`,`ctCollectionId`),
  KEY `IX_49EB3118` (`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ExpandoRow`
--


--
-- Table structure for table `ExpandoTable`
--

CREATE TABLE `ExpandoTable` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `tableId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`tableId`,`ctCollectionId`),
  UNIQUE KEY `IX_87D370E2` (`companyId`,`classNameId`,`name`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ExpandoTable`
--

INSERT INTO `ExpandoTable` VALUES
(0,0,20377,64463788232944,20071,'MP');

--
-- Table structure for table `ExpandoValue`
--

CREATE TABLE `ExpandoValue` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `valueId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `tableId` bigint(20) DEFAULT NULL,
  `columnId` bigint(20) DEFAULT NULL,
  `rowId_` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `data_` longtext DEFAULT NULL,
  PRIMARY KEY (`valueId`,`ctCollectionId`),
  UNIQUE KEY `IX_E6D98E43` (`columnId`,`rowId_`,`ctCollectionId`),
  UNIQUE KEY `IX_D8C72C45` (`tableId`,`columnId`,`classPK`,`ctCollectionId`),
  KEY `IX_CAD04B0D` (`classPK`,`classNameId`),
  KEY `IX_9112A7A0` (`rowId_`),
  KEY `IX_1BD3F4C` (`tableId`,`classPK`),
  KEY `IX_B71E92D5` (`tableId`,`rowId_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ExpandoValue`
--


--
-- Table structure for table `ExportImportConfiguration`
--

CREATE TABLE `ExportImportConfiguration` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `exportImportConfigurationId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`exportImportConfigurationId`),
  KEY `IX_1827A2E5` (`companyId`),
  KEY `IX_38FA468D` (`groupId`,`status`),
  KEY `IX_47CC6234` (`groupId`,`type_`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ExportImportConfiguration`
--


--
-- Table structure for table `FragmentCollection`
--

CREATE TABLE `FragmentCollection` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `fragmentCollectionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `fragmentCollectionKey` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fragmentCollectionId`,`ctCollectionId`),
  UNIQUE KEY `IX_3C778AA9` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_9BFCBA4D` (`groupId`,`ctCollectionId`,`fragmentCollectionKey`),
  UNIQUE KEY `IX_AD02299C` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_536510F5` (`groupId`,`name`),
  KEY `IX_8FB7E9C0` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FragmentCollection`
--


--
-- Table structure for table `FragmentComposition`
--

CREATE TABLE `FragmentComposition` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `fragmentCompositionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `fragmentCollectionId` bigint(20) DEFAULT NULL,
  `fragmentCompositionKey` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `data_` longtext DEFAULT NULL,
  `previewFileEntryId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fragmentCompositionId`,`ctCollectionId`),
  UNIQUE KEY `IX_CE01B795` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_9A26E9A1` (`groupId`,`ctCollectionId`,`fragmentCompositionKey`),
  UNIQUE KEY `IX_5D7BAE88` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_5C61E2DD` (`fragmentCollectionId`),
  KEY `IX_11001AAC` (`groupId`,`fragmentCollectionId`,`name`,`status`),
  KEY `IX_28248B2D` (`groupId`,`fragmentCollectionId`,`status`),
  KEY `IX_70029354` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FragmentComposition`
--


--
-- Table structure for table `FragmentEntry`
--

CREATE TABLE `FragmentEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `headId` bigint(20) DEFAULT NULL,
  `head` tinyint(4) DEFAULT NULL,
  `fragmentEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `fragmentCollectionId` bigint(20) DEFAULT NULL,
  `fragmentEntryKey` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `html` longtext DEFAULT NULL,
  `js` longtext DEFAULT NULL,
  `cacheable` tinyint(4) DEFAULT NULL,
  `configuration` longtext DEFAULT NULL,
  `icon` varchar(75) DEFAULT NULL,
  `previewFileEntryId` bigint(20) DEFAULT NULL,
  `readOnly` tinyint(4) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `typeOptions` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fragmentEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_25B5B355` (`ctCollectionId`,`headId`),
  UNIQUE KEY `IX_8DDC1989` (`groupId`,`head`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_C3F2A8E5` (`groupId`,`head`,`ctCollectionId`,`fragmentEntryKey`),
  UNIQUE KEY `IX_A420787C` (`groupId`,`head`,`uuid_`,`ctCollectionId`),
  KEY `IX_DFBAF515` (`externalReferenceCode`),
  KEY `IX_ADC3EFB9` (`fragmentCollectionId`,`head`),
  KEY `IX_8B622592` (`groupId`,`fragmentCollectionId`,`head`,`name`),
  KEY `IX_24159CF8` (`groupId`,`fragmentCollectionId`,`head`,`status`,`name`),
  KEY `IX_14AA0B48` (`groupId`,`fragmentCollectionId`,`head`,`type_`,`status`),
  KEY `IX_18F9DFE` (`groupId`,`fragmentCollectionId`,`name`),
  KEY `IX_BE29E964` (`groupId`,`fragmentCollectionId`,`status`,`name`),
  KEY `IX_BD1F4C5C` (`groupId`,`fragmentCollectionId`,`type_`,`status`),
  KEY `IX_7F3F0EB3` (`groupId`,`fragmentEntryKey`),
  KEY `IX_515CC759` (`head`,`type_`),
  KEY `IX_40CE21AD` (`type_`),
  KEY `IX_6E7DE18C` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FragmentEntry`
--


--
-- Table structure for table `FragmentEntryLink`
--

CREATE TABLE `FragmentEntryLink` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `fragmentEntryLinkId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `originalFragmentEntryLinkId` bigint(20) DEFAULT NULL,
  `fragmentEntryId` bigint(20) DEFAULT NULL,
  `segmentsExperienceId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `html` longtext DEFAULT NULL,
  `js` longtext DEFAULT NULL,
  `configuration` longtext DEFAULT NULL,
  `deleted` tinyint(4) DEFAULT NULL,
  `editableValues` longtext DEFAULT NULL,
  `namespace` varchar(75) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `rendererKey` varchar(200) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `lastPropagationDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fragmentEntryLinkId`,`ctCollectionId`),
  UNIQUE KEY `IX_3CAD70F7` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_BE3A6BEA` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_67FF823E` (`fragmentEntryId`,`deleted`),
  KEY `IX_2FB5437D` (`groupId`,`classNameId`,`classPK`),
  KEY `IX_4A9E751A` (`groupId`,`fragmentEntryId`,`classNameId`,`classPK`),
  KEY `IX_3D731EF6` (`groupId`,`plid`,`deleted`),
  KEY `IX_A234739A` (`groupId`,`plid`,`fragmentEntryId`),
  KEY `IX_22C863E3` (`groupId`,`plid`,`originalFragmentEntryLinkId`),
  KEY `IX_EECD9CBD` (`groupId`,`plid`,`segmentsExperienceId`,`deleted`),
  KEY `IX_EAA73980` (`groupId`,`plid`,`segmentsExperienceId`,`rendererKey`),
  KEY `IX_EB688B56` (`groupId`,`segmentsExperienceId`,`classNameId`,`classPK`),
  KEY `IX_352AE29E` (`rendererKey`,`companyId`),
  KEY `IX_17C15BB2` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FragmentEntryLink`
--

INSERT INTO `FragmentEntryLink` VALUES
(8,0,'480b962c-8e98-cbe3-e9b4-2f99ada2e306','480b962c-8e98-cbe3-e9b4-2f99ada2e306',31929,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:49.486000','2024-12-10 12:18:38.326000',0,0,31916,20031,8,8,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"404\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','iuhb',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.326000',NULL),
(8,0,'73878a45-d1a5-9eb0-4082-c676b9817c4c','73878a45-d1a5-9eb0-4082-c676b9817c4c',31930,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:49.558000','2024-12-10 12:18:38.341000',0,0,31916,20031,8,8,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"Page Not Found\",\"config\":{\"mapperType\":\"link\"}}}}','nugi',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.341000',NULL),
(8,0,'109fe03c-4100-71e4-0e13-07a135887474','109fe03c-4100-71e4-0e13-07a135887474',31931,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:49.571000','2024-12-10 12:18:38.350000',0,0,31916,20031,8,8,'','[#if configuration.type == \"action\"]\n	<button class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"action\" data-lfr-editable-type=\"action\">\n		Go Somewhere\n	</button>\n\n	[#else]\n		<div class=\"component-button text-break\">\n			<a class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"link\" data-lfr-editable-type=\"link\" href=\"\" id=\"fragment-${fragmentEntryLinkNamespace}-link\">\n				Go Somewhere\n			</a>\n		</div>\n[/#if]','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"link\",\n					\"label\": \"type\",\n					\"name\": \"type\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"action\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"primary\",\n					\"label\": \"style\",\n					\"name\": \"buttonType\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"primary\"\n							},\n							{\n								\"value\": \"secondary\"\n							},\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"outline-primary\"\n							},\n							{\n								\"value\": \"outline-secondary\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"nm\",\n					\"label\": \"size\",\n					\"name\": \"buttonSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"small\",\n								\"value\": \"sm\"\n							},\n							{\n								\"label\": \"normal\",\n								\"value\": \"nm\"\n							},\n							{\n								\"label\": \"large\",\n								\"value\": \"lg\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"button-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"link\":{\"defaultValue\":\"\\n\\t\\t\\t\\tGo Somewhere\\n\\t\\t\\t\",\"en_US\":\"Go Back\",\"config\":{\"mapperType\":\"link\",\"href\":{\"en_US\":\"javascript:history.back()\"}}},\"action\":{\"defaultValue\":\"\\n\\t\\tGo Somewhere\\n\\t\",\"config\":{}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"buttonType\":\"link\",\"type\":\"link\",\"buttonSize\":\"sm\"}}','agpm',2,'BASIC_COMPONENT-button',1,'2024-12-10 12:18:38.350000',NULL),
(8,0,'3b439f56-c3c2-00fd-a0ff-8dbd7d0de1ca','3b439f56-c3c2-00fd-a0ff-8dbd7d0de1ca',31936,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.520000','2024-12-10 12:18:38.402000',0,0,31916,20031,9,9,'','[#if configuration.type == \"action\"]\n	<button class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"action\" data-lfr-editable-type=\"action\">\n		Go Somewhere\n	</button>\n\n	[#else]\n		<div class=\"component-button text-break\">\n			<a class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"link\" data-lfr-editable-type=\"link\" href=\"\" id=\"fragment-${fragmentEntryLinkNamespace}-link\">\n				Go Somewhere\n			</a>\n		</div>\n[/#if]','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"link\",\n					\"label\": \"type\",\n					\"name\": \"type\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"action\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"primary\",\n					\"label\": \"style\",\n					\"name\": \"buttonType\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"primary\"\n							},\n							{\n								\"value\": \"secondary\"\n							},\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"outline-primary\"\n							},\n							{\n								\"value\": \"outline-secondary\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"nm\",\n					\"label\": \"size\",\n					\"name\": \"buttonSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"small\",\n								\"value\": \"sm\"\n							},\n							{\n								\"label\": \"normal\",\n								\"value\": \"nm\"\n							},\n							{\n								\"label\": \"large\",\n								\"value\": \"lg\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"button-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"link\":{\"defaultValue\":\"\\n\\t\\t\\t\\tGo Somewhere\\n\\t\\t\\t\",\"en_US\":\"Go Back\",\"config\":{\"mapperType\":\"link\",\"href\":{\"en_US\":\"javascript:history.back()\"}}},\"action\":{\"defaultValue\":\"\\n\\t\\tGo Somewhere\\n\\t\",\"config\":{}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"buttonType\":\"link\",\"type\":\"link\",\"buttonSize\":\"sm\"}}','agpm',2,'BASIC_COMPONENT-button',1,'2024-12-10 12:18:38.402000',NULL),
(8,0,'e0b0b731-da68-73bd-f86a-3b7cfcb241fa','e0b0b731-da68-73bd-f86a-3b7cfcb241fa',31937,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.536000','2024-12-10 12:18:38.373000',0,0,31916,20031,9,9,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"404\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','iuhb',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.373000',NULL),
(8,0,'0728e64a-4ec8-aa2b-ad4b-13fb470ff3a3','0728e64a-4ec8-aa2b-ad4b-13fb470ff3a3',31938,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.547000','2024-12-10 12:18:38.387000',0,0,31916,20031,9,9,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"Page Not Found\",\"config\":{\"mapperType\":\"link\"}}}}','nugi',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.387000',NULL),
(8,0,'3fecfc8b-dc7c-60c7-42a0-e8142abfedff','3fecfc8b-dc7c-60c7-42a0-e8142abfedff',31964,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.131000','2024-12-10 12:18:38.421000',0,0,31951,20031,10,10,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"500\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','xjhz',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.421000',NULL),
(8,0,'cc62c8ca-64ca-62a4-f426-d8775b699701','cc62c8ca-64ca-62a4-f426-d8775b699701',31965,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.169000','2024-12-10 12:18:38.434000',0,0,31951,20031,10,10,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Internt serverfel\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Erro interno do servidor\",\"fr_FR\":\"Erreur Interne Du Serveur\",\"ja_JP\":\"内部サーバエラー\",\"ca_ES\":\"Error intern del servidor\",\"de_DE\":\"Interner Serverfehler\",\"hu_HU\":\"Belső szerverhiba\",\"ar_SA\":\"خطأ خادم داخلي\",\"fi_FI\":\"Virhe palvelussa\",\"en_US\":\"Internal Server Error\",\"es_ES\":\"Error interno del servidor\",\"zh_CN\":\"内部服务器错误\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Interne serverfout\"}}}','fucb',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.434000',NULL),
(8,0,'ba4ef16b-450b-1fcb-5185-d40a1167bea7','ba4ef16b-450b-1fcb-5185-d40a1167bea7',31970,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.246000','2024-12-10 12:18:38.474000',0,0,31951,20031,11,11,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Internt serverfel\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Erro interno do servidor\",\"fr_FR\":\"Erreur Interne Du Serveur\",\"ja_JP\":\"内部サーバエラー\",\"ca_ES\":\"Error intern del servidor\",\"de_DE\":\"Interner Serverfehler\",\"hu_HU\":\"Belső szerverhiba\",\"ar_SA\":\"خطأ خادم داخلي\",\"fi_FI\":\"Virhe palvelussa\",\"en_US\":\"Internal Server Error\",\"es_ES\":\"Error interno del servidor\",\"zh_CN\":\"内部服务器错误\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Interne serverfout\"}}}','fucb',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.473000',NULL),
(8,0,'fb483223-da12-b30a-d8b1-a34a94123dd8','fb483223-da12-b30a-d8b1-a34a94123dd8',31971,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.251000','2024-12-10 12:18:38.453000',0,0,31951,20031,11,11,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"500\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','xjhz',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.453000',NULL),
(8,0,'5ae45ece-b40b-300b-b8e6-713378203e7b','5ae45ece-b40b-300b-b8e6-713378203e7b',31995,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.619000','2024-12-10 12:18:38.538000',0,0,31982,20031,12,12,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Cookies List\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h2\"}}','bust',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.538000',NULL),
(8,0,'9f64f486-d660-e260-759e-72e1d7be2f72','9f64f486-d660-e260-759e-72e1d7be2f72',31996,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.635000','2024-12-10 12:18:38.632000',0,0,31982,20031,12,12,'','[#if configuration.type == \"action\"]\n	<button class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"action\" data-lfr-editable-type=\"action\">\n		Go Somewhere\n	</button>\n\n	[#else]\n		<div class=\"component-button text-break\">\n			<a class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"link\" data-lfr-editable-type=\"link\" href=\"\" id=\"fragment-${fragmentEntryLinkNamespace}-link\">\n				Go Somewhere\n			</a>\n		</div>\n[/#if]','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"link\",\n					\"label\": \"type\",\n					\"name\": \"type\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"action\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"primary\",\n					\"label\": \"style\",\n					\"name\": \"buttonType\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"primary\"\n							},\n							{\n								\"value\": \"secondary\"\n							},\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"outline-primary\"\n							},\n							{\n								\"value\": \"outline-secondary\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"nm\",\n					\"label\": \"size\",\n					\"name\": \"buttonSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"small\",\n								\"value\": \"sm\"\n							},\n							{\n								\"label\": \"normal\",\n								\"value\": \"nm\"\n							},\n							{\n								\"label\": \"large\",\n								\"value\": \"lg\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"button-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"link\":{\"defaultValue\":\"\\n\\t\\t\\t\\tGo Somewhere\\n\\t\\t\\t\",\"config\":{\"mapperType\":\"link\"}},\"action\":{\"defaultValue\":\"\\n\\t\\tGo Somewhere\\n\\t\",\"en_US\":\"Manage Cookies Settings\",\"config\":{}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"buttonType\":\"secondary\",\"type\":\"action\",\"buttonSize\":\"sm\"}}','mlme',1,'BASIC_COMPONENT-button',1,'2024-12-10 12:18:38.632000',NULL),
(8,0,'7fb45caa-ed3a-fca7-52a1-c72a9dcbce69','7fb45caa-ed3a-fca7-52a1-c72a9dcbce69',31997,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.645000','2024-12-10 12:18:38.556000',0,0,31982,20031,12,12,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"<div>A cookie is a small piece of data (text file) that a website \\u2013 when visited by a user \\u2013 asks your browser to store on your device in order to remember information about you, such as your language preference or login information. Those cookies are set by us and called first-party cookies. We also use third-party cookies \\u2013 which are cookies from a domain different than the domain of the website you are visiting \\u2013 for our advertising and marketing efforts. More specifically, we use cookies and other tracking technologies for the following purposes:<\\/div>\\n\",\"config\":{\"mapperType\":\"link\"}}}}','xxmh',0,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.556000',NULL),
(8,0,'f2c68d92-361b-70f5-95b4-4248d29b7142','f2c68d92-361b-70f5-95b4-4248d29b7142',31998,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.653000','2024-12-10 12:18:38.574000',0,0,31982,20031,12,12,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Strictly Necessary Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','rvhl',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.574000',NULL),
(8,0,'43307a84-4e0a-261b-4776-008fc04bdb41','43307a84-4e0a-261b-4776-008fc04bdb41',31999,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.660000','2024-12-10 12:18:38.647000',0,0,31982,20031,12,12,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will then not work. These cookies do not store any personally identifiable information.\",\"config\":{\"mapperType\":\"link\"}}}}','wmnc',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.647000',NULL),
(8,0,'5a4798f8-cfd1-96f5-c3a6-1bacc698e39f','5a4798f8-cfd1-96f5-c3a6-1bacc698e39f',32000,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.668000','2024-12-10 12:18:38.494000',0,0,31982,20031,12,12,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Functional Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','qweu',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.494000',NULL),
(8,0,'db57ed35-a412-c44d-ec56-c5b60be45ddb','db57ed35-a412-c44d-ec56-c5b60be45ddb',32001,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.700000','2024-12-10 12:18:38.588000',0,0,31982,20031,12,12,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies, then some or all of these services may not function properly.\",\"config\":{\"mapperType\":\"link\"}}}}','ydja',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.588000',NULL),
(8,0,'2a9dd8a1-5814-fa30-f863-9c1c4e25e896','2a9dd8a1-5814-fa30-f863-9c1c4e25e896',32002,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.707000','2024-12-10 12:18:38.509000',0,0,31982,20031,12,12,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Performance Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','opko',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.509000',NULL),
(8,0,'33b4fdc3-ae92-ad41-69d1-937ebb140520','33b4fdc3-ae92-ad41-69d1-937ebb140520',32003,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.712000','2024-12-10 12:18:38.603000',0,0,31982,20031,12,12,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies, we will not know when you have visited our site.\",\"config\":{\"mapperType\":\"link\"}}}}','aivu',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.603000',NULL),
(8,0,'eef481e2-6f95-b3cb-2087-110bd24d9860','eef481e2-6f95-b3cb-2087-110bd24d9860',32004,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.719000','2024-12-10 12:18:38.526000',0,0,31982,20031,12,12,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Personalization Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','euue',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.526000',NULL),
(8,0,'4754ed62-366e-e910-999c-8671d6ac81c2','4754ed62-366e-e910-999c-8671d6ac81c2',32005,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.725000','2024-12-10 12:18:38.619000',0,0,31982,20031,12,12,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and Internet device. If you do not allow these cookies, you will experience less targeted advertising.\",\"config\":{\"mapperType\":\"link\"}}}}','uakt',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.619000',NULL),
(8,0,'8b53f691-578b-d9ce-24d8-f65397593430','8b53f691-578b-d9ce-24d8-f65397593430',32010,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.798000','2024-12-10 12:18:38.663000',0,0,31982,20031,13,13,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Strictly Necessary Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','rvhl',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.663000',NULL),
(8,0,'659ba2dc-93e0-ad9a-33e0-c5e5eb815e85','659ba2dc-93e0-ad9a-33e0-c5e5eb815e85',32011,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.804000','2024-12-10 12:18:38.744000',0,0,31982,20031,13,13,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will then not work. These cookies do not store any personally identifiable information.\",\"config\":{\"mapperType\":\"link\"}}}}','wmnc',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.744000',NULL),
(8,0,'ea48508e-2d7a-7baa-550a-d48ffa46a6bc','ea48508e-2d7a-7baa-550a-d48ffa46a6bc',32012,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.809000','2024-12-10 12:18:38.677000',0,0,31982,20031,13,13,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Personalization Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','euue',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.677000',NULL),
(8,0,'d544d488-90f4-5f1d-6e9c-dcd684ee164a','d544d488-90f4-5f1d-6e9c-dcd684ee164a',32013,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.815000','2024-12-10 12:18:38.764000',0,0,31982,20031,13,13,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and Internet device. If you do not allow these cookies, you will experience less targeted advertising.\",\"config\":{\"mapperType\":\"link\"}}}}','uakt',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.764000',NULL),
(8,0,'5881c70f-192f-909d-208d-df4500c811a1','5881c70f-192f-909d-208d-df4500c811a1',32014,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.820000','2024-12-10 12:18:38.694000',0,0,31982,20031,13,13,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"<div>A cookie is a small piece of data (text file) that a website \\u2013 when visited by a user \\u2013 asks your browser to store on your device in order to remember information about you, such as your language preference or login information. Those cookies are set by us and called first-party cookies. We also use third-party cookies \\u2013 which are cookies from a domain different than the domain of the website you are visiting \\u2013 for our advertising and marketing efforts. More specifically, we use cookies and other tracking technologies for the following purposes:<\\/div>\\n\",\"config\":{\"mapperType\":\"link\"}}}}','xxmh',0,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.694000',NULL),
(8,0,'f4432604-ceec-b3f9-4576-c20cd3f56c3a','f4432604-ceec-b3f9-4576-c20cd3f56c3a',32015,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.826000','2024-12-10 12:18:38.705000',0,0,31982,20031,13,13,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Performance Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','opko',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.705000',NULL),
(8,0,'e73553d4-23e7-289f-a8e2-c9d6178671c1','e73553d4-23e7-289f-a8e2-c9d6178671c1',32016,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.858000','2024-12-10 12:18:38.782000',0,0,31982,20031,13,13,'','[#if configuration.type == \"action\"]\n	<button class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"action\" data-lfr-editable-type=\"action\">\n		Go Somewhere\n	</button>\n\n	[#else]\n		<div class=\"component-button text-break\">\n			<a class=\"btn btn-${configuration.buttonSize} btn-${configuration.buttonType}\" data-lfr-editable-id=\"link\" data-lfr-editable-type=\"link\" href=\"\" id=\"fragment-${fragmentEntryLinkNamespace}-link\">\n				Go Somewhere\n			</a>\n		</div>\n[/#if]','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"link\",\n					\"label\": \"type\",\n					\"name\": \"type\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"action\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"primary\",\n					\"label\": \"style\",\n					\"name\": \"buttonType\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"primary\"\n							},\n							{\n								\"value\": \"secondary\"\n							},\n							{\n								\"value\": \"link\"\n							},\n							{\n								\"value\": \"outline-primary\"\n							},\n							{\n								\"value\": \"outline-secondary\"\n							}\n						]\n					}\n				},\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"nm\",\n					\"label\": \"size\",\n					\"name\": \"buttonSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"small\",\n								\"value\": \"sm\"\n							},\n							{\n								\"label\": \"normal\",\n								\"value\": \"nm\"\n							},\n							{\n								\"label\": \"large\",\n								\"value\": \"lg\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"button-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"link\":{\"defaultValue\":\"\\n\\t\\t\\t\\tGo Somewhere\\n\\t\\t\\t\",\"config\":{\"mapperType\":\"link\"}},\"action\":{\"defaultValue\":\"\\n\\t\\tGo Somewhere\\n\\t\",\"en_US\":\"Manage Cookies Settings\",\"config\":{}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"buttonType\":\"secondary\",\"type\":\"action\",\"buttonSize\":\"sm\"}}','mlme',1,'BASIC_COMPONENT-button',1,'2024-12-10 12:18:38.782000',NULL),
(8,0,'e297f66d-962d-7992-8bab-129770838d73','e297f66d-962d-7992-8bab-129770838d73',32017,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.863000','2024-12-10 12:18:38.718000',0,0,31982,20031,13,13,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Functional Cookies\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h3\"}}','qweu',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.718000',NULL),
(8,0,'343c8132-2972-6008-4af5-80b7640915be','343c8132-2972-6008-4af5-80b7640915be',32018,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.869000','2024-12-10 12:18:38.798000',0,0,31982,20031,13,13,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies, then some or all of these services may not function properly.\",\"config\":{\"mapperType\":\"link\"}}}}','ydja',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.798000',NULL),
(8,0,'a96be7c8-7739-42ed-c29b-463acf71e331','a96be7c8-7739-42ed-c29b-463acf71e331',32019,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.874000','2024-12-10 12:18:38.811000',0,0,31982,20031,13,13,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"en_US\":\"These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us know which pages are the most and least popular and see how visitors move around the site. If you do not allow these cookies, we will not know when you have visited our site.\",\"config\":{\"mapperType\":\"link\"}}}}','aivu',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.811000',NULL),
(8,0,'a46aa0c6-1ee1-9660-6a5c-5f52a2629fb3','a46aa0c6-1ee1-9660-6a5c-5f52a2629fb3',32020,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.879000','2024-12-10 12:18:38.731000',0,0,31982,20031,13,13,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"en_US\":\"Cookies List\",\"config\":{\"mapperType\":\"link\"}}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h2\"}}','bust',0,'BASIC_COMPONENT-heading',1,'2024-12-10 12:18:38.731000',NULL),
(8,0,'a0a552c8-bdc2-aaed-b04b-49be17ff01e7','a0a552c8-bdc2-aaed-b04b-49be17ff01e7',32030,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.190000','2024-12-10 12:18:38.245000',0,0,31815,20031,7,7,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Välkommen till Liferay\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Bem vindo ao Liferay\",\"fr_FR\":\"Bienvenue à Liferay\",\"ja_JP\":\"Liferayへようこそ\",\"ca_ES\":\"Benvingut, benvinguda a Liferay\",\"de_DE\":\"Willkommen bei Liferay\",\"hu_HU\":\"Isten hozott a Liferay-nél!\",\"ar_SA\":\"أهلا بكم في Liferay\",\"fi_FI\":\"Liferay toivottaa tervetulleeksi\",\"en_US\":\"Welcome to Liferay\",\"es_ES\":\"Bienvenido a Liferay\",\"zh_CN\":\"欢迎来到Liferay\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Welkom bij Liferay\"}}}','osgp',0,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.244000',NULL),
(8,0,'caf9d75c-f343-655a-91cb-17d5d35e54b0','caf9d75c-f343-655a-91cb-17d5d35e54b0',32031,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.225000','2024-12-10 12:18:38.299000',0,0,31815,20031,7,7,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"Enjoy using the best DXP on Earth!\",\"config\":{\"mapperType\":\"link\"}}}}','auky',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.299000',NULL),
(8,0,'d50313c1-1fef-9220-4e7f-8a39af11138b','d50313c1-1fef-9220-4e7f-8a39af11138b',32032,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.237000','2024-12-10 12:18:38.266000',0,0,31815,20031,7,7,'','<div class=\"component-image overflow-hidden\">\n	<img alt=\"\" class=\"${configuration.imageSize}\" data-lfr-editable-id=\"image-square\" data-lfr-editable-type=\"image\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHgAAABECAYAAABK3PEEAAAACXBIWXMAAC4jAAAuIwF4pT92AAABBUlEQVR4Xu3VAQkAIBDFUO0fRLCD2RSM8dg12Mbn5trnjo41MAvMtv1gBbb7FhjvW+AC6wZwvn5wgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI7XgguMG8DxWnCBcQM4XgsuMG4Ax2vBBcYN4HgtuMC4ARyvBRcYN4DjteAC4wZwvBZcYNwAjteCC4wbwPFacIFxAzheCy4wbgDHa8EFxg3geC24wLgBHK8FFxg3gOO14ALjBnC8Flxg3ACO14ILjBvA8VpwgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI73ADVez7kdh2y/AAAAAElFTkSuQmCC\" />\n</div>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"w-100\",\n					\"label\": \"image-size\",\n					\"name\": \"imageSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"fit\",\n								\"value\": \"w-100\"\n							},\n							{\n								\"label\": \"original-size\",\n								\"value\": \"w-0\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"image-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"image-square\":{\"classPK\":\"31901\",\"defaultValue\":\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHgAAABECAYAAABK3PEEAAAACXBIWXMAAC4jAAAuIwF4pT92AAABBUlEQVR4Xu3VAQkAIBDFUO0fRLCD2RSM8dg12Mbn5trnjo41MAvMtv1gBbb7FhjvW+AC6wZwvn5wgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI7XgguMG8DxWnCBcQM4XgsuMG4Ax2vBBcYN4HgtuMC4ARyvBRcYN4DjteAC4wZwvBZcYNwAjteCC4wbwPFacIFxAzheCy4wbgDHa8EFxg3geC24wLgBHK8FFxg3gOO14ALjBnC8Flxg3ACO14ILjBvA8VpwgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI73ADVez7kdh2y/AAAAAElFTkSuQmCC\",\"classNameId\":\"31300\",\"config\":{\"mapperType\":\"link\"},\"fieldId\":\"FileEntry_fileURL\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"imageSize\":\"w-100\"}}','jpkk',0,'BASIC_COMPONENT-image',1,'2024-12-10 12:18:38.265000',NULL),
(8,0,'0c429f6e-d465-e5fb-cbe2-1a7673490c77','0c429f6e-d465-e5fb-cbe2-1a7673490c77',32034,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.332000','2024-12-10 12:18:37.415000',32030,0,31815,20031,6,6,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Välkommen till Liferay\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Bem vindo ao Liferay\",\"fr_FR\":\"Bienvenue à Liferay\",\"ja_JP\":\"Liferayへようこそ\",\"ca_ES\":\"Benvingut, benvinguda a Liferay\",\"de_DE\":\"Willkommen bei Liferay\",\"hu_HU\":\"Isten hozott a Liferay-nél!\",\"ar_SA\":\"أهلا بكم في Liferay\",\"fi_FI\":\"Liferay toivottaa tervetulleeksi\",\"en_US\":\"Welcome to Liferay\",\"es_ES\":\"Bienvenido a Liferay\",\"zh_CN\":\"欢迎来到Liferay\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Welkom bij Liferay\"}}}','osgp',0,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:36.847000',NULL),
(8,0,'0d507fce-b898-2c61-8f46-6b53fc5a73df','0d507fce-b898-2c61-8f46-6b53fc5a73df',32035,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.338000','2024-12-10 12:18:38.228000',32031,0,31815,20031,6,6,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"defaultValue\":\"Enjoy using the best DXP on Earth!\",\"config\":{\"mapperType\":\"link\"}}}}','auky',1,'BASIC_COMPONENT-paragraph',1,'2024-12-10 12:18:38.228000',NULL),
(8,0,'d1d7d74a-7e42-ca97-a491-2cd9055ff162','d1d7d74a-7e42-ca97-a491-2cd9055ff162',32036,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:52.347000','2024-12-10 12:18:37.788000',32032,0,31815,20031,6,6,'','<div class=\"component-image overflow-hidden\">\n	<img alt=\"\" class=\"${configuration.imageSize}\" data-lfr-editable-id=\"image-square\" data-lfr-editable-type=\"image\" src=\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHgAAABECAYAAABK3PEEAAAACXBIWXMAAC4jAAAuIwF4pT92AAABBUlEQVR4Xu3VAQkAIBDFUO0fRLCD2RSM8dg12Mbn5trnjo41MAvMtv1gBbb7FhjvW+AC6wZwvn5wgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI7XgguMG8DxWnCBcQM4XgsuMG4Ax2vBBcYN4HgtuMC4ARyvBRcYN4DjteAC4wZwvBZcYNwAjteCC4wbwPFacIFxAzheCy4wbgDHa8EFxg3geC24wLgBHK8FFxg3gOO14ALjBnC8Flxg3ACO14ILjBvA8VpwgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI73ADVez7kdh2y/AAAAAElFTkSuQmCC\" />\n</div>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"w-100\",\n					\"label\": \"image-size\",\n					\"name\": \"imageSize\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"label\": \"fit\",\n								\"value\": \"w-100\"\n							},\n							{\n								\"label\": \"original-size\",\n								\"value\": \"w-0\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"image-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"image-square\":{\"classPK\":\"31901\",\"defaultValue\":\"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAHgAAABECAYAAABK3PEEAAAACXBIWXMAAC4jAAAuIwF4pT92AAABBUlEQVR4Xu3VAQkAIBDFUO0fRLCD2RSM8dg12Mbn5trnjo41MAvMtv1gBbb7FhjvW+AC6wZwvn5wgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI7XgguMG8DxWnCBcQM4XgsuMG4Ax2vBBcYN4HgtuMC4ARyvBRcYN4DjteAC4wZwvBZcYNwAjteCC4wbwPFacIFxAzheCy4wbgDHa8EFxg3geC24wLgBHK8FFxg3gOO14ALjBnC8Flxg3ACO14ILjBvA8VpwgXEDOF4LLjBuAMdrwQXGDeB4LbjAuAEcrwUXGDeA47XgAuMGcLwWXGDcAI73ADVez7kdh2y/AAAAAElFTkSuQmCC\",\"classNameId\":\"31300\",\"config\":{\"mapperType\":\"link\"},\"fieldId\":\"FileEntry_fileURL\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"imageSize\":\"w-100\"}}','jpkk',0,'BASIC_COMPONENT-image',1,'2024-12-10 12:18:37.788000',NULL),
(0,0,'55e798aa-402e-d0f2-f2e0-b1d42148c1d0','55e798aa-402e-d0f2-f2e0-b1d42148c1d0',32942,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.417000','2024-12-16 12:58:09.086000',0,0,32929,20031,19,19,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Sidan hittades inte\",\"defaultValue\":\"\\n\\tHeading Example\\n\",\"pt_BR\":\"Página não encontrada\",\"ja_JP\":\"ページが見つかりません\",\"fr_FR\":\"Page introuvable\",\"hu_HU\":\"Az oldal nem található\",\"de_DE\":\"Seite nicht gefunden\",\"ca_ES\":\"No s\'ha trobat la pàgina\",\"ar_SA\":\"لم يتم العثور على الصفحة\",\"fi_FI\":\"Sivua ei löydy\",\"en_US\":\"Page Not Found\",\"zh_CN\":\"找不到页面\",\"es_ES\":\"Página no encontrada\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Pagina niet gevonden\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','keir',0,'BASIC_COMPONENT-heading',1,'2024-12-16 12:58:09.418000',NULL),
(0,0,'36356bf8-6f61-0df7-37be-27cb10ae12f1','36356bf8-6f61-0df7-37be-27cb10ae12f1',32943,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.432000','2024-12-16 12:58:09.086000',0,0,32929,20031,19,19,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Felkod: 404\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Código de erro: 404\",\"ja_JP\":\"エラーコード: 404\",\"fr_FR\":\"Code d\'erreur : 404\",\"hu_HU\":\"Hibakód: 404\",\"de_DE\":\"Fehlercode: 404\",\"ca_ES\":\"Codi d\'error: 404\",\"ar_SA\":\"رمز الخطأ: 404\",\"fi_FI\":\"Virhekoodi: 404\",\"en_US\":\"Error Code: 404\",\"zh_CN\":\"错误代码：404\",\"es_ES\":\"Código de error: 404\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Foutcode: 404\"}}}','qkqb',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.433000',NULL),
(0,0,'7473a264-b837-79b9-a4aa-8414cd528f8f','7473a264-b837-79b9-a4aa-8414cd528f8f',32944,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.438000','2024-12-16 12:58:09.086000',0,0,32929,20031,19,19,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Den begärda adressen hittades inte i systemet.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"O endereço solicitado não foi encontrado no sistema.\",\"ja_JP\":\"リクエストされたアドレスはシステム上に見つかりませんでした。\",\"fr_FR\":\"L\'adresse demandée n\'a pas été trouvée dans le système.\",\"hu_HU\":\"A kért cím nem található a rendszerben.\",\"de_DE\":\"Die angeforderte Adresse wurde im System nicht gefunden.\",\"ca_ES\":\"No s\'ha trobat l\'adreça sol·licitada al sistema.\",\"ar_SA\":\"لم يتم العثور على العنوان المطلوب في النظام.\",\"fi_FI\":\"Pyydettyä osoitetta ei löytynyt järjestelmässä.\",\"en_US\":\"The requested address was not found on the system.\",\"zh_CN\":\"在系统上找不到请求的地址。\",\"es_ES\":\"La dirección solicitada no se encontró en el sistema.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Het gevraagde adres is niet gevonden in het systeem.\"}}}','ddec',2,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.439000',NULL),
(0,0,'21ece3ba-6fa7-1a66-b88f-7245b3191bee','21ece3ba-6fa7-1a66-b88f-7245b3191bee',32945,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.444000','2024-12-16 12:58:09.086000',0,0,32929,20031,19,19,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Anvisningar\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Instruções\",\"ja_JP\":\"説明\",\"fr_FR\":\"Instructions\",\"hu_HU\":\"Utasítások\",\"de_DE\":\"Anweisungen\",\"ca_ES\":\"Instruccions\",\"ar_SA\":\"التعليمات\",\"fi_FI\":\"Ohjeet\",\"en_US\":\"Instructions\",\"zh_CN\":\"说明\",\"es_ES\":\"Instrucciones\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Instructies\"}}}','iiis',0,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.446000',NULL),
(0,0,'09a3239b-73f6-32d9-055f-6cfe84837a83','09a3239b-73f6-32d9-055f-6cfe84837a83',32946,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.452000','2024-12-16 12:58:09.086000',0,0,32929,20031,19,19,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Granska den angivna URL-adressen och försök att uppdatera sidan. Problemet kan vara tillfälligt.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Revise o endereço de URL digitado e tente atualizar a página. O problema pode ser temporário.\",\"ja_JP\":\"入力した URL アドレスを確認してからページを更新してみてください。この問題は一時的なものである可能性があります。\",\"fr_FR\":\"Vérifiez l\'URL saisie et essayez d\'actualiser la page. Le problème peut être temporaire.\",\"hu_HU\":\"Ellenőrizze a beírt URL-címet, és próbálja meg frissíteni az oldalt. Lehet, hogy a probléma csak átmeneti.\",\"de_DE\":\"Überprüfen Sie die eingegebene URL-Adresse und versuchen Sie, die Seite zu aktualisieren. Das Problem kann vorübergehender Natur sein.\",\"ca_ES\":\"Reviseu l\'adreça URL teclejada i intenteu actualitzar la pàgina. El problema pot ser temporal.\",\"ar_SA\":\"راجع عنوان URL المكتوب وجرب تحديث الصفحة. قد تكون المشكلة مؤقتة.\",\"fi_FI\":\"Tarkista kirjoitettu URL-osoite ja kokeile päivittää sivu. Ongelma saattaa olla tilapäinen.\",\"en_US\":\"Review the typed URL address and try to refresh the page. The problem may be temporary.\",\"zh_CN\":\"检查键入的 URL 地址并尝试刷新页面。问题可能是暂时的。\",\"es_ES\":\"Revise la dirección URL introducida e pruebe a actualizar la página. Es posible que el problema sea temporal.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Controleer de ingevoerde URL en probeer de pagina te vernieuwen. Misschien is het een tijdelijk probleem.\"}}}','ciiq',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.453000',NULL),
(0,0,'4a077e28-7f12-c227-e553-2b39c2534df0','4a077e28-7f12-c227-e553-2b39c2534df0',32951,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.504000','2024-12-16 12:58:09.086000',0,0,32929,20031,18,18,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Sidan hittades inte\",\"defaultValue\":\"\\n\\tHeading Example\\n\",\"pt_BR\":\"Página não encontrada\",\"ja_JP\":\"ページが見つかりません\",\"fr_FR\":\"Page introuvable\",\"hu_HU\":\"Az oldal nem található\",\"de_DE\":\"Seite nicht gefunden\",\"ca_ES\":\"No s\'ha trobat la pàgina\",\"ar_SA\":\"لم يتم العثور على الصفحة\",\"fi_FI\":\"Sivua ei löydy\",\"en_US\":\"Page Not Found\",\"zh_CN\":\"找不到页面\",\"es_ES\":\"Página no encontrada\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Pagina niet gevonden\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','bgsb',0,'BASIC_COMPONENT-heading',1,'2024-12-16 12:58:09.505000',NULL),
(0,0,'db816915-bf19-7b74-d667-668f437b380e','db816915-bf19-7b74-d667-668f437b380e',32952,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.510000','2024-12-16 12:58:09.086000',0,0,32929,20031,18,18,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Felkod: 404\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Código de erro: 404\",\"ja_JP\":\"エラーコード: 404\",\"fr_FR\":\"Code d\'erreur : 404\",\"hu_HU\":\"Hibakód: 404\",\"de_DE\":\"Fehlercode: 404\",\"ca_ES\":\"Codi d\'error: 404\",\"ar_SA\":\"رمز الخطأ: 404\",\"fi_FI\":\"Virhekoodi: 404\",\"en_US\":\"Error Code: 404\",\"zh_CN\":\"错误代码：404\",\"es_ES\":\"Código de error: 404\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Foutcode: 404\"}}}','wmqw',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.511000',NULL),
(0,0,'9a33ffa9-8dfc-8361-7571-da6fce170a79','9a33ffa9-8dfc-8361-7571-da6fce170a79',32953,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.518000','2024-12-16 12:58:09.086000',0,0,32929,20031,18,18,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Den begärda adressen hittades inte i systemet.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"O endereço solicitado não foi encontrado no sistema.\",\"ja_JP\":\"リクエストされたアドレスはシステム上に見つかりませんでした。\",\"fr_FR\":\"L\'adresse demandée n\'a pas été trouvée dans le système.\",\"hu_HU\":\"A kért cím nem található a rendszerben.\",\"de_DE\":\"Die angeforderte Adresse wurde im System nicht gefunden.\",\"ca_ES\":\"No s\'ha trobat l\'adreça sol·licitada al sistema.\",\"ar_SA\":\"لم يتم العثور على العنوان المطلوب في النظام.\",\"fi_FI\":\"Pyydettyä osoitetta ei löytynyt järjestelmässä.\",\"en_US\":\"The requested address was not found on the system.\",\"zh_CN\":\"在系统上找不到请求的地址。\",\"es_ES\":\"La dirección solicitada no se encontró en el sistema.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Het gevraagde adres is niet gevonden in het systeem.\"}}}','misk',2,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.519000',NULL),
(0,0,'a8cb3079-893a-2009-56f7-039ea70adf5e','a8cb3079-893a-2009-56f7-039ea70adf5e',32954,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.526000','2024-12-16 12:58:09.086000',0,0,32929,20031,18,18,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Anvisningar\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Instruções\",\"ja_JP\":\"説明\",\"fr_FR\":\"Instructions\",\"hu_HU\":\"Utasítások\",\"de_DE\":\"Anweisungen\",\"ca_ES\":\"Instruccions\",\"ar_SA\":\"التعليمات\",\"fi_FI\":\"Ohjeet\",\"en_US\":\"Instructions\",\"zh_CN\":\"说明\",\"es_ES\":\"Instrucciones\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Instructies\"}}}','kioc',0,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.527000',NULL),
(0,0,'3ff4fe3a-91f6-7f4a-36e4-c07ef6b25808','3ff4fe3a-91f6-7f4a-36e4-c07ef6b25808',32955,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.532000','2024-12-16 12:58:09.086000',0,0,32929,20031,18,18,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Granska den angivna URL-adressen och försök att uppdatera sidan. Problemet kan vara tillfälligt.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Revise o endereço de URL digitado e tente atualizar a página. O problema pode ser temporário.\",\"ja_JP\":\"入力した URL アドレスを確認してからページを更新してみてください。この問題は一時的なものである可能性があります。\",\"fr_FR\":\"Vérifiez l\'URL saisie et essayez d\'actualiser la page. Le problème peut être temporaire.\",\"hu_HU\":\"Ellenőrizze a beírt URL-címet, és próbálja meg frissíteni az oldalt. Lehet, hogy a probléma csak átmeneti.\",\"de_DE\":\"Überprüfen Sie die eingegebene URL-Adresse und versuchen Sie, die Seite zu aktualisieren. Das Problem kann vorübergehender Natur sein.\",\"ca_ES\":\"Reviseu l\'adreça URL teclejada i intenteu actualitzar la pàgina. El problema pot ser temporal.\",\"ar_SA\":\"راجع عنوان URL المكتوب وجرب تحديث الصفحة. قد تكون المشكلة مؤقتة.\",\"fi_FI\":\"Tarkista kirjoitettu URL-osoite ja kokeile päivittää sivu. Ongelma saattaa olla tilapäinen.\",\"en_US\":\"Review the typed URL address and try to refresh the page. The problem may be temporary.\",\"zh_CN\":\"检查键入的 URL 地址并尝试刷新页面。问题可能是暂时的。\",\"es_ES\":\"Revise la dirección URL introducida e pruebe a actualizar la página. Es posible que el problema sea temporal.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Controleer de ingevoerde URL en probeer de pagina te vernieuwen. Misschien is het een tijdelijk probleem.\"}}}','srrn',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.533000',NULL),
(0,0,'3d7f3f5e-36b4-1673-79f2-9c2e0cad53f6','3d7f3f5e-36b4-1673-79f2-9c2e0cad53f6',32974,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.676000','2024-12-16 12:58:09.586000',0,0,32961,20031,21,21,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Serverfel\",\"defaultValue\":\"\\n\\tHeading Example\\n\",\"pt_BR\":\"Erro de servidor\",\"ja_JP\":\"サーバーエラー\",\"fr_FR\":\"Erreur du serveur\",\"hu_HU\":\"Kiszolgálóhiba\",\"de_DE\":\"Serverfehler\",\"ca_ES\":\"Error de servidor\",\"ar_SA\":\"خطأ في الخادم\",\"fi_FI\":\"Palvelinvirhe\",\"en_US\":\"Server Error\",\"zh_CN\":\"服务器错误\",\"es_ES\":\"Error de servidor\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Serverfout\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','utmk',0,'BASIC_COMPONENT-heading',1,'2024-12-16 12:58:09.677000',NULL),
(0,0,'7b9eeeb9-8a1c-9b99-66fb-c929a5103479','7b9eeeb9-8a1c-9b99-66fb-c929a5103479',32975,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.684000','2024-12-16 12:58:09.586000',0,0,32961,20031,21,21,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Felkod: 500\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Código de erro: 500\",\"ja_JP\":\"エラーコード: 500\",\"fr_FR\":\"Code d\'erreur : 500\",\"hu_HU\":\"Hibakód: 500\",\"de_DE\":\"Fehlercode: 500\",\"ca_ES\":\"Codi d\'error: 500\",\"ar_SA\":\"رمز الخطأ: 500\",\"fi_FI\":\"Virhekoodi: 500\",\"en_US\":\"Error Code: 500\",\"zh_CN\":\"错误代码：500\",\"es_ES\":\"Código de error: 500\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Foutcode: 500\"}}}','xmby',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.685000',NULL),
(0,0,'1cfbb7eb-3996-d223-cf11-64dd19444032','1cfbb7eb-3996-d223-cf11-64dd19444032',32976,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.690000','2024-12-16 12:58:09.586000',0,0,32961,20031,21,21,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Det gick inte att hantera den begärda sidan.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Ocorreu um problema ao atender a página solicitada.\",\"ja_JP\":\"リクエストされたページを提供中に問題が発生しました。\",\"fr_FR\":\"Un problème est survenu lors de la diffusion de la page demandée.\",\"hu_HU\":\"A kért oldal kiszolgálása során probléma merült fel.\",\"de_DE\":\"Es gab ein Problem bei der Bereitstellung der angeforderten Seite.\",\"ca_ES\":\"S\'ha produït un problema en difondre la pàgina sol·licitada.\",\"ar_SA\":\"حدث مشكلة في عرض الصفحة المطلوبة.\",\"fi_FI\":\"Virhe näytettäessä pyydettyä sivua.\",\"en_US\":\"There was a problem serving the requested page.\",\"zh_CN\":\"提供请求的页面时发生问题。\",\"es_ES\":\"Se produjo un problema al servir la página solicitada.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Er is een probleem opgetreden bij het weergeven van de opgevraagde pagina.\"}}}','pxpe',2,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.690000',NULL),
(0,0,'f1c3d0e1-dabd-ebd7-8567-f97a5a093fc7','f1c3d0e1-dabd-ebd7-8567-f97a5a093fc7',32977,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.696000','2024-12-16 12:58:09.586000',0,0,32961,20031,21,21,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Anvisningar\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Instruções\",\"ja_JP\":\"説明\",\"fr_FR\":\"Instructions\",\"hu_HU\":\"Utasítások\",\"de_DE\":\"Anweisungen\",\"ca_ES\":\"Instruccions\",\"ar_SA\":\"التعليمات\",\"fi_FI\":\"Ohjeet\",\"en_US\":\"Instructions\",\"zh_CN\":\"说明\",\"es_ES\":\"Instrucciones\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Instructies\"}}}','sneg',0,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.697000',NULL),
(0,0,'609adc48-8389-f0da-d498-17016822aa39','609adc48-8389-f0da-d498-17016822aa39',32978,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.703000','2024-12-16 12:58:09.586000',0,0,32961,20031,21,21,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Vänta i 30 sekunder och försök igen.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Aguarde 30 segundos e tente novamente.\",\"ja_JP\":\"30 秒待ってから再度お試しください。\",\"fr_FR\":\"Veuillez patienter 30 secondes et réessayer.\",\"hu_HU\":\"Várjon 30 másodpercet, és próbálja meg újra.\",\"de_DE\":\"Bitte warten Sie 30 Sekunden und versuchen Sie es erneut.\",\"ca_ES\":\"Espereu 30 segons i torneu-ho a provar.\",\"ar_SA\":\"يُرجى الانتظار 30 ثانية وإعادة المحاولة.\",\"fi_FI\":\"Odota 30 sekuntia ja yritä uudelleen.\",\"en_US\":\"Please wait 30 seconds and try again.\",\"zh_CN\":\"请等待 30 秒并重试。\",\"es_ES\":\"Espere 30 segundos y vuelva a intentarlo.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Wacht 30 seconden en probeer het opnieuw.\"}}}','ptbs',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.704000',NULL),
(0,0,'f1371efe-b896-dcaa-e401-44e16c035c78','f1371efe-b896-dcaa-e401-44e16c035c78',32983,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.734000','2024-12-16 12:58:09.586000',0,0,32961,20031,20,20,'.fragment-heading-text-colored a {\n	color: inherit;\n}','<${configuration.headingLevel} class=\"component-heading mb-0 text-break\" data-lfr-editable-id=\"element-text\"\n	data-lfr-editable-type=\"text\">\n	Heading Example\n</${configuration.headingLevel}>','','{\n	\"fieldSets\": [\n		{\n			\"fields\": [\n				{\n					\"dataType\": \"string\",\n					\"defaultValue\": \"h1\",\n					\"label\": \"heading-level\",\n					\"name\": \"headingLevel\",\n					\"type\": \"select\",\n					\"typeOptions\": {\n						\"validValues\": [\n							{\n								\"value\": \"h1\"\n							},\n							{\n								\"value\": \"h2\"\n							},\n							{\n								\"value\": \"h3\"\n							},\n							{\n								\"value\": \"h4\"\n							},\n							{\n								\"value\": \"h5\"\n							},\n							{\n								\"value\": \"h6\"\n							}\n						]\n					}\n				}\n			],\n			\"label\": \"heading-options\"\n		}\n	]\n}',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Serverfel\",\"defaultValue\":\"\\n\\tHeading Example\\n\",\"pt_BR\":\"Erro de servidor\",\"ja_JP\":\"サーバーエラー\",\"fr_FR\":\"Erreur du serveur\",\"hu_HU\":\"Kiszolgálóhiba\",\"de_DE\":\"Serverfehler\",\"ca_ES\":\"Error de servidor\",\"ar_SA\":\"خطأ في الخادم\",\"fi_FI\":\"Palvelinvirhe\",\"en_US\":\"Server Error\",\"zh_CN\":\"服务器错误\",\"es_ES\":\"Error de servidor\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Serverfout\"}},\"com.liferay.fragment.entry.processor.freemarker.FreeMarkerFragmentEntryProcessor\":{\"headingLevel\":\"h1\"}}','ruzs',0,'BASIC_COMPONENT-heading',1,'2024-12-16 12:58:09.735000',NULL),
(0,0,'54269004-b70f-3c18-c19c-c68ceebfdf06','54269004-b70f-3c18-c19c-c68ceebfdf06',32984,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.743000','2024-12-16 12:58:09.586000',0,0,32961,20031,20,20,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Felkod: 500\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Código de erro: 500\",\"ja_JP\":\"エラーコード: 500\",\"fr_FR\":\"Code d\'erreur : 500\",\"hu_HU\":\"Hibakód: 500\",\"de_DE\":\"Fehlercode: 500\",\"ca_ES\":\"Codi d\'error: 500\",\"ar_SA\":\"رمز الخطأ: 500\",\"fi_FI\":\"Virhekoodi: 500\",\"en_US\":\"Error Code: 500\",\"zh_CN\":\"错误代码：500\",\"es_ES\":\"Código de error: 500\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Foutcode: 500\"}}}','mdge',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.744000',NULL),
(0,0,'746a70f0-5afc-1738-6e1a-0f97496c765f','746a70f0-5afc-1738-6e1a-0f97496c765f',32985,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.749000','2024-12-16 12:58:09.586000',0,0,32961,20031,20,20,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Det gick inte att hantera den begärda sidan.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Ocorreu um problema ao atender a página solicitada.\",\"ja_JP\":\"リクエストされたページを提供中に問題が発生しました。\",\"fr_FR\":\"Un problème est survenu lors de la diffusion de la page demandée.\",\"hu_HU\":\"A kért oldal kiszolgálása során probléma merült fel.\",\"de_DE\":\"Es gab ein Problem bei der Bereitstellung der angeforderten Seite.\",\"ca_ES\":\"S\'ha produït un problema en difondre la pàgina sol·licitada.\",\"ar_SA\":\"حدث مشكلة في عرض الصفحة المطلوبة.\",\"fi_FI\":\"Virhe näytettäessä pyydettyä sivua.\",\"en_US\":\"There was a problem serving the requested page.\",\"zh_CN\":\"提供请求的页面时发生问题。\",\"es_ES\":\"Se produjo un problema al servir la página solicitada.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Er is een probleem opgetreden bij het weergeven van de opgevraagde pagina.\"}}}','agdy',2,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.750000',NULL),
(0,0,'af09ea8e-eb97-b29f-da92-221bfb897555','af09ea8e-eb97-b29f-da92-221bfb897555',32986,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.756000','2024-12-16 12:58:09.586000',0,0,32961,20031,20,20,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Anvisningar\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Instruções\",\"ja_JP\":\"説明\",\"fr_FR\":\"Instructions\",\"hu_HU\":\"Utasítások\",\"de_DE\":\"Anweisungen\",\"ca_ES\":\"Instruccions\",\"ar_SA\":\"التعليمات\",\"fi_FI\":\"Ohjeet\",\"en_US\":\"Instructions\",\"zh_CN\":\"说明\",\"es_ES\":\"Instrucciones\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Instructies\"}}}','cbfk',0,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.757000',NULL),
(0,0,'1786cb4c-cdf3-6dac-c943-0da0debe01b5','1786cb4c-cdf3-6dac-c943-0da0debe01b5',32987,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.761000','2024-12-16 12:58:09.586000',0,0,32961,20031,20,20,'.component-paragraph img {\n	max-width: 100%;\n}','<div class=\"clearfix component-paragraph text-break\" data-lfr-editable-id=\"element-text\" data-lfr-editable-type=\"rich-text\">\n	A paragraph is a self-contained unit of a discourse in writing dealing with\n	a particular point or idea. Paragraphs are usually an expected part of\n	formal writing, used to organize longer prose.\n</div>','','',0,'{\"com.liferay.fragment.entry.processor.editable.EditableFragmentEntryProcessor\":{\"element-text\":{\"sv_SE\":\"Vänta i 30 sekunder och försök igen.\",\"defaultValue\":\"\\n\\tA paragraph is a self-contained unit of a discourse in writing dealing with\\n\\ta particular point or idea. Paragraphs are usually an expected part of\\n\\tformal writing, used to organize longer prose.\\n\",\"pt_BR\":\"Aguarde 30 segundos e tente novamente.\",\"ja_JP\":\"30 秒待ってから再度お試しください。\",\"fr_FR\":\"Veuillez patienter 30 secondes et réessayer.\",\"hu_HU\":\"Várjon 30 másodpercet, és próbálja meg újra.\",\"de_DE\":\"Bitte warten Sie 30 Sekunden und versuchen Sie es erneut.\",\"ca_ES\":\"Espereu 30 segons i torneu-ho a provar.\",\"ar_SA\":\"يُرجى الانتظار 30 ثانية وإعادة المحاولة.\",\"fi_FI\":\"Odota 30 sekuntia ja yritä uudelleen.\",\"en_US\":\"Please wait 30 seconds and try again.\",\"zh_CN\":\"请等待 30 秒并重试。\",\"es_ES\":\"Espere 30 segundos y vuelva a intentarlo.\",\"config\":{\"mapperType\":\"link\"},\"nl_NL\":\"Wacht 30 seconden en probeer het opnieuw.\"}}}','yqsu',1,'BASIC_COMPONENT-paragraph',1,'2024-12-16 12:58:09.762000',NULL);

--
-- Table structure for table `FragmentEntryVersion`
--

CREATE TABLE `FragmentEntryVersion` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `fragmentEntryVersionId` bigint(20) NOT NULL,
  `version` int(11) DEFAULT NULL,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `fragmentEntryId` bigint(20) DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `fragmentCollectionId` bigint(20) DEFAULT NULL,
  `fragmentEntryKey` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `html` longtext DEFAULT NULL,
  `js` longtext DEFAULT NULL,
  `cacheable` tinyint(4) DEFAULT NULL,
  `configuration` longtext DEFAULT NULL,
  `icon` varchar(75) DEFAULT NULL,
  `previewFileEntryId` bigint(20) DEFAULT NULL,
  `readOnly` tinyint(4) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `typeOptions` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`fragmentEntryVersionId`,`ctCollectionId`),
  UNIQUE KEY `IX_2D0AE389` (`groupId`,`version`,`ctCollectionId`,`fragmentEntryKey`),
  UNIQUE KEY `IX_AF627C58` (`groupId`,`version`,`uuid_`,`ctCollectionId`),
  UNIQUE KEY `IX_F81BA8E3` (`version`,`ctCollectionId`,`fragmentEntryId`),
  KEY `IX_7A6F05CF` (`fragmentCollectionId`,`version`),
  KEY `IX_391FD151` (`fragmentEntryId`),
  KEY `IX_2509F8CA` (`groupId`,`fragmentCollectionId`,`name`),
  KEY `IX_FD32B830` (`groupId`,`fragmentCollectionId`,`status`,`name`),
  KEY `IX_5F305710` (`groupId`,`fragmentCollectionId`,`type_`,`status`),
  KEY `IX_8D72731C` (`groupId`,`fragmentCollectionId`,`version`,`name`),
  KEY `IX_986CC082` (`groupId`,`fragmentCollectionId`,`version`,`status`,`name`),
  KEY `IX_2B3758FE` (`groupId`,`fragmentCollectionId`,`version`,`type_`,`status`),
  KEY `IX_519A387F` (`groupId`,`fragmentEntryKey`),
  KEY `IX_850F2979` (`type_`),
  KEY `IX_B2BEE958` (`uuid_`),
  KEY `IX_75B533A9` (`version`,`type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FragmentEntryVersion`
--


--
-- Table structure for table `FriendlyURLEntry`
--

CREATE TABLE `FriendlyURLEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `defaultLanguageId` varchar(75) DEFAULT NULL,
  `friendlyURLEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`friendlyURLEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_D51F1A48` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_F3DC928B` (`groupId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FriendlyURLEntry`
--

INSERT INTO `FriendlyURLEntry` VALUES
(0,0,'c335ca12-75da-4f59-2b57-e0960fdc376b','en_US',31680,31242,64463788232944,'2024-11-21 12:19:34.333000','2024-11-21 12:19:34.333000',31678,4),
(0,0,'816eb2c9-ddff-f135-cdb4-83989df0caa8','en_US',31697,20117,64463788232944,'2024-11-21 12:19:39.035000','2024-11-21 12:19:39.035000',31694,5),
(0,0,'9327d0f4-c4d0-9c94-5fca-b2750ebe85b9','en_US',31721,20120,64463788232944,'2024-11-21 12:19:40.150000','2024-11-21 12:19:40.150000',31300,31718),
(0,0,'815ad866-2888-af0c-658e-6607cb3711a2','en_US',31806,20120,64463788232944,'2024-11-21 12:19:42.109000','2024-11-21 12:19:42.109000',31300,31803),
(0,0,'c39c4402-0558-7866-b13e-1351d59409f9','en_US',31821,20117,64463788232944,'2024-11-21 12:19:43.352000','2024-11-21 12:19:43.352000',31694,6),
(0,0,'5f1c1e15-4cdf-8a0b-808a-e69f623311b2','en_US',31827,20117,64463788232944,'2024-11-21 12:19:43.403000','2024-11-21 12:19:43.057000',31694,7),
(0,0,'328e6246-5de0-ed86-9911-5b3ada24fe21','en_US',31834,20117,64463788232944,'2024-11-21 12:19:44.905000','2024-11-21 12:19:44.905000',31300,31831),
(0,0,'c5bd6c7a-f0f9-5a16-8ec4-e60d9b067ac0','en_US',31844,20117,64463788232944,'2024-11-21 12:19:45.178000','2024-11-21 12:19:45.178000',31300,31841),
(0,0,'47f38a3b-87e7-8d08-00c3-7dd3529751a4','en_US',31855,20117,64463788232944,'2024-11-21 12:19:45.482000','2024-11-21 12:19:45.482000',31300,31852),
(0,0,'8e65b6bb-e84e-858c-5510-a004bc023134','en_US',31868,20117,64463788232944,'2024-11-21 12:19:45.834000','2024-11-21 12:19:45.834000',31300,31864),
(0,0,'4a2bb1a1-8780-7916-e810-67a185ff5731','en_US',31881,20117,64463788232944,'2024-11-21 12:19:46.238000','2024-11-21 12:19:46.238000',31300,31877),
(0,0,'a7fffbe7-b968-c3e8-8a47-24a3d354deba','en_US',31893,20117,64463788232944,'2024-11-21 12:19:46.517000','2024-11-21 12:19:46.517000',31300,31889),
(0,0,'0cf3595c-5475-d46b-bde1-7111f20bb8b9','en_US',31904,20117,64463788232944,'2024-11-21 12:19:46.756000','2024-11-21 12:19:46.756000',31300,31901),
(0,0,'f3d50523-897b-4ffb-2472-4d3ed4dc774d','en_US',31921,20117,64463788232944,'2024-11-21 12:19:48.764000','2024-11-21 12:19:43.057000',31694,8),
(0,0,'3e3a904f-4b82-eef2-901f-cba8391bd3a1','en_US',31927,20117,64463788232944,'2024-11-21 12:19:48.821000','2024-11-21 12:19:48.746000',31694,9),
(0,0,'82b082a7-e08b-9ede-8aae-2bd76e29c0b0','en_US',31944,20117,64463788232944,'2024-11-21 12:19:50.687000','2024-11-21 12:19:50.687000',31300,31941),
(0,0,'813c387c-18bb-650c-c2b8-4b9cb56d0574','en_US',31956,20117,64463788232944,'2024-11-21 12:19:51.029000','2024-11-21 12:19:48.746000',31694,10),
(0,0,'04c1a2aa-9835-fcf6-ba0e-2fa72aff1382','en_US',31962,20117,64463788232944,'2024-11-21 12:19:51.102000','2024-11-21 12:19:50.965000',31694,11),
(0,0,'510227b2-e85f-08f1-50fd-b1ace33b6be6','en_US',31975,20117,64463788232944,'2024-11-21 12:19:51.336000','2024-11-21 12:19:51.336000',31300,31972),
(0,0,'2127acad-932d-35bf-38e5-57da87d17668','en_US',31987,20117,64463788232944,'2024-11-21 12:19:51.535000','2024-11-21 12:19:50.965000',31694,12),
(0,0,'a569f46b-4957-5e1a-c6ae-a465d1ccd7ba','en_US',31993,20117,64463788232944,'2024-11-21 12:19:51.596000','2024-11-21 12:19:51.507000',31694,13),
(0,0,'1b8a1373-c1a7-a60b-ddf5-42cebfe6fc19','en_US',32024,20117,64463788232944,'2024-11-21 12:19:51.926000','2024-11-21 12:19:51.926000',31300,32021),
(0,0,'a5bd9de2-2ca1-0b90-c062-735e63823162','en_US',32106,20125,64463788232944,'2024-11-21 12:52:01.218000','2024-11-21 12:52:01.218000',31678,14),
(0,0,'f08285a6-02ea-c1ca-4ee9-bd2cbe3159e6','en_US',32110,20125,64463788232944,'2024-11-21 12:52:01.929000','2024-11-21 12:52:01.929000',31694,15),
(0,0,'e87f89d1-492a-023b-a2b9-cce20c7176b1','en_US',32216,20117,64463788232944,'2024-11-21 12:59:09.080000','2024-11-21 12:59:09.080000',31678,16),
(0,0,'34eb0afa-9c5f-b572-fdb6-1499b870c104','en_US',32230,20117,64463788232944,'2024-11-22 13:09:32.656000','2024-11-22 13:09:32.656000',31694,17),
(0,0,'5bbf1139-7349-3a82-4326-086aa389a56e','en_US',32934,32925,64463788232944,'2024-12-16 12:58:09.158000','2024-12-16 12:58:09.158000',31694,18),
(0,0,'5c1bea96-5603-d1df-3f44-ba9933f77632','en_US',32940,32925,64463788232944,'2024-12-16 12:58:09.210000','2024-12-16 12:58:09.086000',31694,19),
(0,0,'60a0f809-6cb2-4c51-9a3f-9e25068b7ee5','en_US',32966,32925,64463788232944,'2024-12-16 12:58:09.606000','2024-12-16 12:58:09.086000',31694,20),
(0,0,'0444aa3a-f1df-ce1c-b01f-af0c830df098','en_US',32972,32925,64463788232944,'2024-12-16 12:58:09.642000','2024-12-16 12:58:09.586000',31694,21),
(0,0,'39f1eb12-d892-ce2f-e7e6-a5ba7a34ce72','en_US',32997,32925,64463788232944,'2024-12-16 16:32:21.364000','2024-12-16 16:32:21.364000',31678,22),
(0,0,'13bd4a28-e27b-75bd-50fe-85269876b36c','en_US',33016,20117,64463788232944,'2024-12-19 12:55:23.340000','2024-12-19 12:55:23.340000',28838,33014),
(0,0,'19a70363-5b58-7f68-9c1e-e85317a5fe5a','en_US',33027,20117,64463788232944,'2024-12-19 17:56:11.163000','2024-12-19 17:56:11.163000',28838,33025),
(0,0,'3801fedd-8867-6aa5-d1fb-eaba04a018d9','en_US',33074,32925,64463788232944,'2024-12-23 14:02:05.769000','2024-12-23 14:02:05.769000',31694,25),
(0,0,'240dc0f9-51d6-9d05-7c29-95485fa7bfbb','en_US',33080,32925,64463788232944,'2024-12-23 14:02:05.841000','2024-12-23 14:02:05.714000',31694,26);

--
-- Table structure for table `FriendlyURLEntryLocalization`
--

CREATE TABLE `FriendlyURLEntryLocalization` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `friendlyURLEntryLocalizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `friendlyURLEntryId` bigint(20) DEFAULT NULL,
  `languageId` varchar(75) DEFAULT NULL,
  `urlTitle` varchar(255) DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`friendlyURLEntryLocalizationId`,`ctCollectionId`),
  UNIQUE KEY `IX_53B5CB4B` (`classNameId`,`groupId`,`languageId`,`urlTitle`,`ctCollectionId`),
  UNIQUE KEY `IX_5292D20F` (`languageId`,`ctCollectionId`,`friendlyURLEntryId`),
  KEY `IX_2B00D1D3` (`classNameId`,`groupId`,`languageId`,`classPK`),
  KEY `IX_570320E6` (`classNameId`,`groupId`,`urlTitle`),
  KEY `IX_310462C` (`classNameId`,`urlTitle`,`ctCollectionId`,`companyId`),
  KEY `IX_BFA6E36A` (`friendlyURLEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FriendlyURLEntryLocalization`
--

INSERT INTO `FriendlyURLEntryLocalization` VALUES
(0,0,1,64463788232944,31680,'en_US','/layout',31242,31678,4),
(0,0,2,64463788232944,31697,'en_US','/search',20117,31694,5),
(0,0,3,64463788232944,31721,'en_US','id-e17b5c49-6792-5953-296f-af0a2b1ff77',20120,31300,31718),
(0,0,4,64463788232944,31806,'en_US','company_logo-png',20120,31300,31803),
(0,0,5,64463788232944,31821,'en_US','/home',20117,31694,6),
(0,0,6,64463788232944,31827,'en_US','/e9a65c6e-36bb-09a1-8871-8e0f861751ef',20117,31694,7),
(0,0,7,64463788232944,31834,'en_US','astronaut-png',20117,31300,31831),
(0,0,8,64463788232944,31844,'en_US','earth-png',20117,31300,31841),
(0,0,9,64463788232944,31855,'en_US','moon-png',20117,31300,31852),
(0,0,10,64463788232944,31868,'en_US','planet-png',20117,31300,31864),
(0,0,11,64463788232944,31881,'en_US','satellite-png',20117,31300,31877),
(0,0,12,64463788232944,31893,'en_US','stars-png',20117,31300,31889),
(0,0,13,64463788232944,31904,'en_US','tree-png',20117,31300,31901),
(0,0,14,64463788232944,31921,'en_US','/4fbe099e-8126-2fee-f3c5-80d2bfd3515a',20117,31694,8),
(0,0,15,64463788232944,31927,'en_US','/d998c093-bc43-c31b-fb49-dbef706bbc7c',20117,31694,9),
(0,0,16,64463788232944,31944,'en_US','31915_preview-png',20117,31300,31941),
(0,0,17,64463788232944,31956,'en_US','/8d3ff005-3129-c721-59d8-2790825204ac',20117,31694,10),
(0,0,18,64463788232944,31962,'en_US','/bfb62556-eeaa-63d9-f9fe-4cab65face52',20117,31694,11),
(0,0,19,64463788232944,31975,'en_US','31946_preview-png',20117,31300,31972),
(0,0,20,64463788232944,31987,'en_US','/0b704058-4a41-c5ac-f95a-628383adaf8a',20117,31694,12),
(0,0,21,64463788232944,31993,'en_US','/6658876f-5c17-6d06-48ea-62a3837fe0f3',20117,31694,13),
(0,0,22,64463788232944,32024,'en_US','31977_preview-png',20117,31300,32021),
(0,0,101,64463788232944,32106,'en_US','/home',20125,31678,14),
(0,0,102,64463788232944,32110,'en_US','/home',20125,31694,15),
(0,0,201,64463788232944,32216,'en_US','/manage',20117,31678,16),
(0,0,202,64463788232944,32230,'en_US','/manage',20117,31694,17),
(0,0,301,64463788232944,32934,'en_US','/ea6689a5-5e6e-0092-09c3-72ef56726a32',32925,31694,18),
(0,0,302,64463788232944,32940,'en_US','/06e5daeb-e793-4d01-ecc2-9820107d9fab',32925,31694,19),
(0,0,303,64463788232944,32966,'en_US','/069c1b68-6599-d323-1547-720488d419c3',32925,31694,20),
(0,0,304,64463788232944,32972,'en_US','/bfca335a-2c1e-c85a-b00d-5cdf41dffd96',32925,31694,21),
(0,0,305,64463788232944,32997,'en_US','/manage',32925,31678,22),
(0,0,306,64463788232944,33016,'en_US','igneous-rocks',20117,28838,33014),
(0,0,307,64463788232944,33027,'en_US','river-rocks',20117,28838,33025),
(0,0,310,64463788232944,33074,'en_US','/types-of-rocks',32925,31694,25),
(0,0,311,64463788232944,33080,'en_US','/b3922f50-9dc0-896d-5522-c3fd538a5f1e',32925,31694,26);

--
-- Table structure for table `FriendlyURLEntryMapping`
--

CREATE TABLE `FriendlyURLEntryMapping` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `friendlyURLEntryMappingId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `friendlyURLEntryId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`friendlyURLEntryMappingId`,`ctCollectionId`),
  UNIQUE KEY `IX_5BE324B9` (`classNameId`,`classPK`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `FriendlyURLEntryMapping`
--

INSERT INTO `FriendlyURLEntryMapping` VALUES
(0,0,31679,64463788232944,31678,4,31680),
(0,0,31696,64463788232944,31694,5,31697),
(0,0,31720,64463788232944,31300,31718,31721),
(0,0,31805,64463788232944,31300,31803,31806),
(0,0,31820,64463788232944,31694,6,31821),
(0,0,31826,64463788232944,31694,7,31827),
(0,0,31833,64463788232944,31300,31831,31834),
(0,0,31843,64463788232944,31300,31841,31844),
(0,0,31854,64463788232944,31300,31852,31855),
(0,0,31867,64463788232944,31300,31864,31868),
(0,0,31880,64463788232944,31300,31877,31881),
(0,0,31892,64463788232944,31300,31889,31893),
(0,0,31903,64463788232944,31300,31901,31904),
(0,0,31920,64463788232944,31694,8,31921),
(0,0,31926,64463788232944,31694,9,31927),
(0,0,31943,64463788232944,31300,31941,31944),
(0,0,31955,64463788232944,31694,10,31956),
(0,0,31961,64463788232944,31694,11,31962),
(0,0,31974,64463788232944,31300,31972,31975),
(0,0,31986,64463788232944,31694,12,31987),
(0,0,31992,64463788232944,31694,13,31993),
(0,0,32023,64463788232944,31300,32021,32024),
(0,0,32105,64463788232944,31678,14,32106),
(0,0,32109,64463788232944,31694,15,32110),
(0,0,32215,64463788232944,31678,16,32216),
(0,0,32229,64463788232944,31694,17,32230),
(0,0,32933,64463788232944,31694,18,32934),
(0,0,32939,64463788232944,31694,19,32940),
(0,0,32965,64463788232944,31694,20,32966),
(0,0,32971,64463788232944,31694,21,32972),
(0,0,32996,64463788232944,31678,22,32997),
(0,0,33015,64463788232944,28838,33014,33016),
(0,0,33026,64463788232944,28838,33025,33027),
(0,0,33073,64463788232944,31694,25,33074),
(0,0,33079,64463788232944,31694,26,33080);

--
-- Table structure for table `Group_`
--

CREATE TABLE `Group_` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `groupId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `creatorUserId` bigint(20) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `parentGroupId` bigint(20) DEFAULT NULL,
  `liveGroupId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `groupKey` varchar(150) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `manualMembership` tinyint(4) DEFAULT NULL,
  `membershipRestriction` int(11) DEFAULT NULL,
  `friendlyURL` varchar(255) DEFAULT NULL,
  `site` tinyint(4) DEFAULT NULL,
  `remoteStagingGroupCount` int(11) DEFAULT NULL,
  `inheritContent` tinyint(4) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`groupId`,`ctCollectionId`),
  UNIQUE KEY `IX_DBA56EF9` (`companyId`,`classNameId`,`ctCollectionId`,`classPK`),
  UNIQUE KEY `IX_23B1C81D` (`companyId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_3551EED4` (`companyId`,`ctCollectionId`,`friendlyURL`),
  UNIQUE KEY `IX_42E6E774` (`companyId`,`ctCollectionId`,`groupKey`),
  KEY `IX_75017452` (`active_`,`type_`),
  KEY `IX_8257E37B` (`classNameId`,`classPK`),
  KEY `IX_DDC91A87` (`companyId`,`active_`),
  KEY `IX_ABE2D54` (`companyId`,`classNameId`,`parentGroupId`),
  KEY `IX_DF76A247` (`companyId`,`classNameId`,`site`),
  KEY `IX_5D75499E` (`companyId`,`parentGroupId`),
  KEY `IX_B91488EC` (`companyId`,`site`,`active_`),
  KEY `IX_7B216735` (`companyId`,`site`,`parentGroupId`,`inheritContent`),
  KEY `IX_16218A38` (`liveGroupId`),
  KEY `IX_F981514E` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Group_`
--

INSERT INTO `Group_` VALUES
(2,0,'ed1b4d09-0103-b696-b6de-fd934d5a746a','L_CONTROL_PANEL',20113,64463788232944,20096,'2024-11-21 12:18:02.973000',20029,20113,0,0,'/20113/','Control Panel','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Control Panel</Name></root>',NULL,3,'',1,0,'/control_panel',0,0,0,1),
(2,0,'6c38d929-ea68-7a2b-d544-75574a3075f1','L_FORMS',20116,64463788232944,20096,'2024-11-21 12:18:03.167000',20029,20116,0,0,'/20116/','Forms','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Forms</Name></root>',NULL,3,'',1,0,'/forms',0,0,0,1),
(3,0,'844d4f1d-1662-90dc-4243-f95f83cce501','L_GUEST',20117,64463788232944,20096,'2024-11-21 12:19:39.650000',20029,20117,0,0,'/20117/','Guest','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Guest</Name></root>',NULL,2,'searchLayoutCreated=true\n',1,0,'/guest',1,0,0,1),
(2,0,'3f06f46c-a2e3-6d68-5b81-3025265f2271','L_USER_PERSONAL_SITE',20119,64463788232944,20096,'2024-11-21 12:18:03.210000',20118,20096,0,0,'/20119/','User Personal Site','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">User Personal Site</Name></root>',NULL,3,'',1,0,'/personal_site',0,0,0,1),
(0,0,'8efb0e90-637c-0fd1-1676-4934e057a067','8efb0e90-637c-0fd1-1676-4934e057a067',20120,64463788232944,20096,'2024-11-21 12:18:03.224000',20023,64463788232944,0,0,'/20120/','64463788232944','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Global</Name></root>',NULL,0,'',1,0,'/global',1,0,0,1),
(1,0,'bb369f05-ddf9-b348-f023-db00bb5de25e','bb369f05-ddf9-b348-f023-db00bb5de25e',20125,64463788232944,20123,'2024-11-21 12:18:04.801000',20071,20123,0,0,'/20125/','20123',NULL,NULL,0,'',1,0,'/test',0,0,0,1),
(1,0,'9b9e7c3a-a02c-232d-8b4b-deffa3526288','9b9e7c3a-a02c-232d-8b4b-deffa3526288',20389,64463788232944,20387,'2024-11-21 12:18:12.987000',20071,20387,0,0,'/20389/','20387',NULL,NULL,0,'',1,0,'/default-service-account',0,0,0,1),
(0,0,'042b36c7-b52f-fdf8-ec28-0199833255cc','042b36c7-b52f-fdf8-ec28-0199833255cc',31242,64463788232944,20096,'2024-11-21 12:19:31.909000',20034,31241,0,0,'/31242/','31241','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,sv_SE,pt_BR,ja_JP,fr_FR,hu_HU,de_DE,ca_ES,ar_SA,fi_FI,zh_CN,es_ES,nl_NL\" default-locale=\"en_US\"><Name language-id=\"sv_SE\">Sök</Name><Name language-id=\"pt_BR\">Busca</Name><Name language-id=\"ja_JP\">検索</Name><Name language-id=\"fr_FR\">Rechercher</Name><Name language-id=\"hu_HU\">Keresés</Name><Name language-id=\"de_DE\">Suche</Name><Name language-id=\"ca_ES\">Cerca</Name><Name language-id=\"ar_SA\">البحث</Name><Name language-id=\"fi_FI\">Haku</Name><Name language-id=\"en_US\">Search</Name><Name language-id=\"zh_CN\">搜索</Name><Name language-id=\"es_ES\">Búsqueda</Name><Name language-id=\"nl_NL\">Zoeken</Name></root>',NULL,0,'',1,0,'/template-31241',0,0,0,1),
(0,0,'44ac4599-b86c-36f9-44fb-47b0983dddb2','44ac4599-b86c-36f9-44fb-47b0983dddb2',31798,64463788232944,20096,'2024-11-21 12:19:41.254000',28902,31797,0,0,'/31798/','31797','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Master</Name></root>',NULL,3,'',0,0,'/master',0,0,0,1),
(1,0,'7c12b10b-4fbf-432c-8e58-8630263193f3','7c12b10b-4fbf-432c-8e58-8630263193f3',32222,64463788232944,32220,'2024-11-22 12:18:19.677000',20071,32220,0,0,'/32222/','32220',NULL,NULL,0,'',1,0,'/fred',0,0,0,1),
(1,0,'3c6d74d8-469e-a334-9c55-295f86993e79','3c6d74d8-469e-a334-9c55-295f86993e79',32305,64463788232944,32303,'2024-11-26 13:43:13.203000',20071,32303,0,0,'/32305/','32303',NULL,NULL,0,'',1,0,'/anonymous64463788232944_1',0,0,0,0),
(1,0,'082b9ad8-b208-2434-a32e-24d0569d62a3','082b9ad8-b208-2434-a32e-24d0569d62a3',32307,64463788232944,20123,'2024-11-26 13:44:22.483000',20042,32306,0,0,'/32307/','Bedstone LFR_ORGANIZATION','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Bedstone</Name></root>',NULL,3,'',0,0,'/bedstone',0,0,0,1),
(0,0,'8a2ac7c4-98e1-6a96-5203-9bc7596e829c','8a2ac7c4-98e1-6a96-5203-9bc7596e829c',32504,64463788232944,20123,'2024-12-03 11:45:47.921000',28707,32503,0,0,'/32504/','32503','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">RockSeller</Name></root>',NULL,3,'',0,0,'/rockseller',0,0,0,1),
(1,0,'db04291d-3c58-8a97-b3ef-f6ecb5da1a1c','db04291d-3c58-8a97-b3ef-f6ecb5da1a1c',32605,64463788232944,32603,'2024-12-04 13:20:02.663000',20071,32603,0,0,'/32605/','32603',NULL,NULL,0,'',1,0,'/rocksellermanager',0,0,0,1),
(2,0,'c287752f-7184-2978-c0be-2fcaadd5fc99','c287752f-7184-2978-c0be-2fcaadd5fc99',32925,64463788232944,20123,'2024-12-16 12:58:09.038000',20029,32925,0,0,'/32925/','All About Rocks','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">All About Rocks</Name></root>',NULL,2,'contentSharingWithChildrenEnabled=-1\nlocales=en_US,ar_SA,ca_ES,zh_CN,nl_NL,fi_FI,fr_FR,de_DE,hu_HU,ja_JP,pt_BR,es_ES,sv_SE\ntrashEnabled=true\n',1,0,'/all-about-rocks',1,0,0,1);

--
-- Table structure for table `Groups_Orgs`
--

CREATE TABLE `Groups_Orgs` (
  `companyId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `organizationId` bigint(20) NOT NULL,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctChangeType` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`groupId`,`organizationId`,`ctCollectionId`),
  KEY `IX_8BFD4548` (`companyId`),
  KEY `IX_6BBB7682` (`organizationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Groups_Orgs`
--


--
-- Table structure for table `Groups_Roles`
--

CREATE TABLE `Groups_Roles` (
  `companyId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctChangeType` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`groupId`,`roleId`,`ctCollectionId`),
  KEY `IX_557D8550` (`companyId`),
  KEY `IX_3103EF3D` (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Groups_Roles`
--


--
-- Table structure for table `Groups_UserGroups`
--

CREATE TABLE `Groups_UserGroups` (
  `companyId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `userGroupId` bigint(20) NOT NULL,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctChangeType` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`groupId`,`userGroupId`,`ctCollectionId`),
  KEY `IX_676FC818` (`companyId`),
  KEY `IX_3B69160F` (`userGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Groups_UserGroups`
--


--
-- Table structure for table `IM_MemberRequest`
--

CREATE TABLE `IM_MemberRequest` (
  `memberRequestId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `receiverUserId` bigint(20) DEFAULT NULL,
  `invitedRoleId` bigint(20) DEFAULT NULL,
  `invitedTeamId` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`memberRequestId`),
  KEY `IX_B4BCD9B4` (`key_`),
  KEY `IX_FED88A7B` (`receiverUserId`,`status`,`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `IM_MemberRequest`
--


--
-- Table structure for table `Image`
--

CREATE TABLE `Image` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `imageId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `size_` int(11) DEFAULT NULL,
  PRIMARY KEY (`imageId`,`ctCollectionId`),
  KEY `IX_6A925A4D` (`size_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Image`
--


--
-- Table structure for table `JSONStorageEntry`
--

CREATE TABLE `JSONStorageEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `jsonStorageEntryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `parentJSONStorageEntryId` bigint(20) DEFAULT NULL,
  `index_` int(11) DEFAULT NULL,
  `key_` varchar(255) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `valueLong` bigint(20) DEFAULT NULL,
  `valueString` longtext DEFAULT NULL,
  PRIMARY KEY (`jsonStorageEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_28660EE5` (`classNameId`,`classPK`,`index_`,`key_`,`parentJSONStorageEntryId`,`ctCollectionId`),
  KEY `IX_8FDDE8E8` (`classNameId`,`companyId`,`index_`,`type_`,`valueLong`),
  KEY `IX_140EE1BB` (`classNameId`,`companyId`,`key_`,`type_`,`valueLong`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JSONStorageEntry`
--


--
-- Table structure for table `JournalArticle`
--

CREATE TABLE `JournalArticle` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `id_` bigint(20) NOT NULL,
  `resourcePrimKey` bigint(20) DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `folderId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `articleId` varchar(75) DEFAULT NULL,
  `version` double DEFAULT NULL,
  `urlTitle` varchar(255) DEFAULT NULL,
  `DDMStructureId` bigint(20) DEFAULT NULL,
  `DDMTemplateKey` varchar(75) DEFAULT NULL,
  `defaultLanguageId` varchar(75) DEFAULT NULL,
  `layoutUuid` varchar(75) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `reviewDate` datetime(6) DEFAULT NULL,
  `indexable` tinyint(4) DEFAULT NULL,
  `smallImage` tinyint(4) DEFAULT NULL,
  `smallImageId` bigint(20) DEFAULT NULL,
  `smallImageSource` int(11) DEFAULT NULL,
  `smallImageURL` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id_`,`ctCollectionId`),
  UNIQUE KEY `IX_D3ACAD4A` (`groupId`,`articleId`,`version`,`ctCollectionId`),
  UNIQUE KEY `IX_F73C7E0D` (`groupId`,`uuid_`,`ctCollectionId`),
  UNIQUE KEY `IX_4D29D87C` (`groupId`,`version`,`ctCollectionId`,`externalReferenceCode`),
  KEY `IX_745E04FA` (`DDMStructureId`),
  KEY `IX_75CCA4D1` (`DDMTemplateKey`),
  KEY `IX_3D070845` (`companyId`,`version`),
  KEY `IX_A2D2CDB8` (`externalReferenceCode`),
  KEY `IX_3048AF7A` (`groupId`,`DDMStructureId`),
  KEY `IX_31B74F51` (`groupId`,`DDMTemplateKey`),
  KEY `IX_6D117C1E` (`groupId`,`classNameId`,`DDMStructureId`),
  KEY `IX_6E801BF5` (`groupId`,`classNameId`,`DDMTemplateKey`),
  KEY `IX_9CE6E0FA` (`groupId`,`classNameId`,`classPK`),
  KEY `IX_A2534AC2` (`groupId`,`classNameId`,`layoutUuid`),
  KEY `IX_373DCC43` (`groupId`,`classNameId`,`userId`),
  KEY `IX_5CD17502` (`groupId`,`folderId`),
  KEY `IX_3C028C1E` (`groupId`,`layoutUuid`),
  KEY `IX_5CA5E0F6` (`groupId`,`status`,`articleId`),
  KEY `IX_BCAFC000` (`groupId`,`status`,`classNameId`,`folderId`),
  KEY `IX_9D8D768` (`groupId`,`status`,`folderId`),
  KEY `IX_CF8F8F68` (`groupId`,`status`,`urlTitle`),
  KEY `IX_22882D02` (`groupId`,`urlTitle`),
  KEY `IX_D19C1B9F` (`groupId`,`userId`),
  KEY `IX_3F1EA19E` (`layoutUuid`),
  KEY `IX_89FF8B06` (`resourcePrimKey`,`indexable`),
  KEY `IX_EF9B7028` (`smallImageId`),
  KEY `IX_15ADA32B` (`status`,`companyId`,`version`),
  KEY `IX_2AA511D5` (`status`,`displayDate`),
  KEY `IX_BCE7DFEC` (`status`,`resourcePrimKey`,`indexable`),
  KEY `IX_F029602F` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalArticle`
--

INSERT INTO `JournalArticle` VALUES
(1,0,'6fb0259d-4efe-8544-f9ab-2b84298ebccb',33013,33014,20117,64463788232944,20123,'Test Test','2024-12-19 12:55:23.325000','2024-12-19 12:55:23.485000','6fb0259d-4efe-8544-f9ab-2b84298ebccb',0,0,0,'/','33012',1,'igneous-rocks',30029,'BASIC-WEB-CONTENT','en_US',NULL,'2024-12-19 12:54:00.000000',NULL,NULL,1,0,0,1,NULL,NULL,0,20123,'Test Test','2024-12-19 12:55:23.485000'),
(1,0,'78804d28-aa78-dd69-e5a5-79cc2dc9e7a2',33024,33025,20117,64463788232944,20123,'Test Test','2024-12-19 17:56:11.153000','2024-12-19 17:56:11.254000','78804d28-aa78-dd69-e5a5-79cc2dc9e7a2',0,0,0,'/','33023',1,'river-rocks',30029,'BASIC-WEB-CONTENT','en_US',NULL,'2024-12-19 17:55:00.000000',NULL,NULL,1,0,0,1,NULL,NULL,0,20123,'Test Test','2024-12-19 17:56:11.254000');

--
-- Table structure for table `JournalArticleLocalization`
--

CREATE TABLE `JournalArticleLocalization` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `articleLocalizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `articlePK` bigint(20) DEFAULT NULL,
  `title` varchar(800) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `languageId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`articleLocalizationId`,`ctCollectionId`),
  UNIQUE KEY `IX_5593D868` (`articlePK`,`languageId`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalArticleLocalization`
--

INSERT INTO `JournalArticleLocalization` VALUES
(0,0,33017,64463788232944,33013,'Igneous Rocks','<p>Catalog of Igneous Rocks</p>','en_US'),
(0,0,33028,64463788232944,33024,'River Rocks','<p>River Rocks</p>','en_US');

--
-- Table structure for table `JournalArticleResource`
--

CREATE TABLE `JournalArticleResource` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `resourcePrimKey` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `articleId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`resourcePrimKey`,`ctCollectionId`),
  UNIQUE KEY `IX_42F04A2C` (`groupId`,`ctCollectionId`,`articleId`),
  UNIQUE KEY `IX_37A8A767` (`uuid_`,`groupId`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalArticleResource`
--

INSERT INTO `JournalArticleResource` VALUES
(0,0,'14c65a6f-a5d8-8c69-de56-545e71e98763',33014,20117,64463788232944,'33012'),
(0,0,'1ae07564-2766-9b6e-83c5-eba05a41f074',33025,20117,64463788232944,'33023');

--
-- Table structure for table `JournalContentSearch`
--

CREATE TABLE `JournalContentSearch` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `contentSearchId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `privateLayout` tinyint(4) DEFAULT NULL,
  `layoutId` bigint(20) DEFAULT NULL,
  `portletId` varchar(200) DEFAULT NULL,
  `articleId` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`contentSearchId`,`ctCollectionId`),
  UNIQUE KEY `IX_F91BC3CC` (`groupId`,`privateLayout`,`articleId`,`layoutId`,`portletId`,`ctCollectionId`),
  KEY `IX_9207CB31` (`articleId`),
  KEY `IX_42F51F38` (`companyId`),
  KEY `IX_6838E427` (`groupId`,`articleId`),
  KEY `IX_7ACC74C9` (`groupId`,`privateLayout`,`layoutId`,`portletId`),
  KEY `IX_8DAF8A35` (`portletId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalContentSearch`
--


--
-- Table structure for table `JournalFeed`
--

CREATE TABLE `JournalFeed` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `id_` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `feedId` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `DDMStructureId` bigint(20) DEFAULT NULL,
  `DDMTemplateKey` varchar(75) DEFAULT NULL,
  `DDMRendererTemplateKey` varchar(75) DEFAULT NULL,
  `delta` int(11) DEFAULT NULL,
  `orderByCol` varchar(75) DEFAULT NULL,
  `orderByType` varchar(75) DEFAULT NULL,
  `targetLayoutFriendlyUrl` varchar(255) DEFAULT NULL,
  `targetPortletId` varchar(200) DEFAULT NULL,
  `contentField` varchar(75) DEFAULT NULL,
  `feedFormat` varchar(75) DEFAULT NULL,
  `feedVersion` double DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id_`,`ctCollectionId`),
  UNIQUE KEY `IX_E5E4C71A` (`groupId`,`ctCollectionId`,`feedId`),
  UNIQUE KEY `IX_800F33AF` (`uuid_`,`groupId`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalFeed`
--


--
-- Table structure for table `JournalFolder`
--

CREATE TABLE `JournalFolder` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `folderId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `parentFolderId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `restrictionType` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`folderId`,`ctCollectionId`),
  UNIQUE KEY `IX_5C538C20` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_266332E3` (`groupId`,`parentFolderId`,`ctCollectionId`,`name`),
  UNIQUE KEY `IX_1965F913` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_E6E2725D` (`companyId`),
  KEY `IX_E988689E` (`groupId`,`name`),
  KEY `IX_EFD9CAC` (`groupId`,`parentFolderId`,`status`),
  KEY `IX_8D6902B7` (`status`,`companyId`),
  KEY `IX_63BDFA69` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `JournalFolder`
--


--
-- Table structure for table `KBArticle`
--

CREATE TABLE `KBArticle` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `kbArticleId` bigint(20) NOT NULL,
  `resourcePrimKey` bigint(20) DEFAULT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `rootResourcePrimKey` bigint(20) DEFAULT NULL,
  `parentResourceClassNameId` bigint(20) DEFAULT NULL,
  `parentResourcePrimKey` bigint(20) DEFAULT NULL,
  `kbFolderId` bigint(20) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `urlTitle` varchar(75) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `sections` longtext DEFAULT NULL,
  `latest` tinyint(4) DEFAULT NULL,
  `main` tinyint(4) DEFAULT NULL,
  `sourceURL` longtext DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `reviewDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kbArticleId`,`ctCollectionId`),
  UNIQUE KEY `IX_8DC73951` (`groupId`,`ctCollectionId`,`uuid_`),
  UNIQUE KEY `IX_1096F938` (`groupId`,`ctCollectionId`,`version`,`externalReferenceCode`),
  UNIQUE KEY `IX_9A21A6D4` (`resourcePrimKey`,`ctCollectionId`,`version`),
  KEY `IX_7E9C8FF8` (`externalReferenceCode`),
  KEY `IX_4A49CDD6` (`groupId`,`kbFolderId`,`urlTitle`),
  KEY `IX_7B1749F4` (`groupId`,`latest`,`kbFolderId`),
  KEY `IX_E2460F71` (`groupId`,`latest`,`parentResourcePrimKey`),
  KEY `IX_5C814FBF` (`groupId`,`main`,`parentResourcePrimKey`),
  KEY `IX_37000F91` (`groupId`,`resourcePrimKey`,`latest`),
  KEY `IX_FF9D0743` (`groupId`,`resourcePrimKey`,`main`),
  KEY `IX_F3FC873C` (`groupId`,`status`,`kbFolderId`,`urlTitle`),
  KEY `IX_9CD524DA` (`groupId`,`status`,`latest`,`kbFolderId`),
  KEY `IX_68D688CB` (`groupId`,`status`,`latest`,`parentResourcePrimKey`),
  KEY `IX_E3B45799` (`groupId`,`status`,`main`,`parentResourcePrimKey`),
  KEY `IX_FD8E8D66` (`groupId`,`status`,`parentResourcePrimKey`),
  KEY `IX_2C55146B` (`groupId`,`status`,`resourcePrimKey`,`latest`),
  KEY `IX_8C417A9D` (`groupId`,`status`,`resourcePrimKey`,`main`),
  KEY `IX_827ACC48` (`latest`,`companyId`),
  KEY `IX_B8038671` (`latest`,`parentResourcePrimKey`),
  KEY `IX_FD5B5196` (`main`,`companyId`),
  KEY `IX_A13086BF` (`main`,`parentResourcePrimKey`),
  KEY `IX_A9E2C691` (`resourcePrimKey`,`latest`),
  KEY `IX_69C17E43` (`resourcePrimKey`,`main`),
  KEY `IX_C5C0D1BD` (`status`,`companyId`),
  KEY `IX_A67A6415` (`status`,`displayDate`),
  KEY `IX_69DBFCA2` (`status`,`latest`,`companyId`),
  KEY `IX_12CFFCB` (`status`,`latest`,`parentResourcePrimKey`),
  KEY `IX_8020D070` (`status`,`main`,`companyId`),
  KEY `IX_BD3C8E99` (`status`,`main`,`parentResourcePrimKey`),
  KEY `IX_D34C0466` (`status`,`parentResourcePrimKey`),
  KEY `IX_8890CB6B` (`status`,`resourcePrimKey`,`latest`),
  KEY `IX_61FEF19D` (`status`,`resourcePrimKey`,`main`),
  KEY `IX_C23FA26F` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KBArticle`
--


--
-- Table structure for table `KBComment`
--

CREATE TABLE `KBComment` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `kbCommentId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `userRating` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`kbCommentId`,`ctCollectionId`),
  UNIQUE KEY `IX_3854CAF6` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_47D3AE89` (`classNameId`,`classPK`,`status`),
  KEY `IX_E952C7DD` (`classNameId`,`classPK`,`userId`),
  KEY `IX_E8D43932` (`groupId`,`classNameId`),
  KEY `IX_828BA082` (`groupId`,`status`),
  KEY `IX_8E470726` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KBComment`
--


--
-- Table structure for table `KBFolder`
--

CREATE TABLE `KBFolder` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `kbFolderId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `parentKBFolderId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `urlTitle` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kbFolderId`,`ctCollectionId`),
  UNIQUE KEY `IX_538A8E60` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_9697B53` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_F32A081D` (`companyId`),
  KEY `IX_3FA4415C` (`groupId`,`parentKBFolderId`,`name`),
  KEY `IX_C8923D43` (`groupId`,`parentKBFolderId`,`status`),
  KEY `IX_729A89FA` (`groupId`,`parentKBFolderId`,`urlTitle`),
  KEY `IX_30B67029` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KBFolder`
--


--
-- Table structure for table `KBTemplate`
--

CREATE TABLE `KBTemplate` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `kbTemplateId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kbTemplateId`,`ctCollectionId`),
  UNIQUE KEY `IX_7C6D824B` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_83D9CC13` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KBTemplate`
--


--
-- Table structure for table `KaleoAction`
--

CREATE TABLE `KaleoAction` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoActionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoClassName` varchar(200) DEFAULT NULL,
  `kaleoClassPK` bigint(20) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoNodeName` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `executionType` varchar(20) DEFAULT NULL,
  `script` longtext DEFAULT NULL,
  `scriptLanguage` varchar(255) DEFAULT NULL,
  `scriptRequiredContexts` longtext DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`kaleoActionId`,`ctCollectionId`),
  KEY `IX_50E9112C` (`companyId`),
  KEY `IX_ED710674` (`kaleoClassName`,`kaleoClassPK`,`companyId`,`executionType`),
  KEY `IX_4B2545E8` (`kaleoClassName`,`kaleoClassPK`,`executionType`),
  KEY `IX_F8808C50` (`kaleoDefinitionVersionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoAction`
--

INSERT INTO `KaleoAction` VALUES
(0,0,31730,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.893000','2024-11-21 12:19:40.893000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31729,31726,31727,'approved','approve',NULL,'onEntry','',NULL,NULL,0,'UPDATE_STATUS',0),
(0,0,31749,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.989000','2024-11-21 12:19:40.989000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31748,31726,31727,'update','deny',NULL,'onAssignment','',NULL,NULL,1,'UPDATE_STATUS',4),
(0,0,31750,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.989000','2024-11-21 12:19:40.989000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31748,31726,31727,'update','pending',NULL,'onAssignment','',NULL,NULL,2,'UPDATE_STATUS',1),
(0,0,31764,0,64463788232944,20096,NULL,'2024-11-21 12:19:41.183000','2024-11-21 12:19:41.183000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31763,31761,31762,'approved','approve',NULL,'onEntry','',NULL,NULL,0,'UPDATE_STATUS',0),
(0,0,31787,0,64463788232944,20096,NULL,'2024-11-21 12:19:41.213000','2024-11-21 12:19:41.213000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31786,31761,31762,'update','deny',NULL,'onAssignment','',NULL,NULL,1,'UPDATE_STATUS',4),
(0,0,31788,0,64463788232944,20096,NULL,'2024-11-21 12:19:41.213000','2024-11-21 12:19:41.213000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31786,31761,31762,'update','pending',NULL,'onAssignment','',NULL,NULL,2,'UPDATE_STATUS',1);

--
-- Table structure for table `KaleoCondition`
--

CREATE TABLE `KaleoCondition` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoConditionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoNodeId` bigint(20) DEFAULT NULL,
  `script` longtext DEFAULT NULL,
  `scriptLanguage` varchar(75) DEFAULT NULL,
  `scriptRequiredContexts` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoConditionId`,`ctCollectionId`),
  KEY `IX_FEE46067` (`companyId`),
  KEY `IX_353B7FB5` (`kaleoDefinitionVersionId`),
  KEY `IX_86CBD4C` (`kaleoNodeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoCondition`
--

INSERT INTO `KaleoCondition` VALUES
(0,0,31733,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.910000','2024-11-21 12:19:40.910000',31726,31727,31732,'\n			com.liferay.message.boards.moderation.internal.kaleo.runtime.condition.MBModerationConditionEvaluator\n		','java',NULL);

--
-- Table structure for table `KaleoDefinition`
--

CREATE TABLE `KaleoDefinition` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoDefinitionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `scope` varchar(75) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`kaleoDefinitionId`,`ctCollectionId`),
  KEY `IX_EEFC11D0` (`active_`),
  KEY `IX_37ED1EF9` (`companyId`,`active_`,`name`),
  KEY `IX_D1C1A80A` (`companyId`,`active_`,`scope`),
  KEY `IX_EC14F81A` (`companyId`,`name`,`version`),
  KEY `IX_6E339BF5` (`companyId`,`scope`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoDefinition`
--

INSERT INTO `KaleoDefinition` VALUES
(1,0,31726,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.817000','2024-11-21 12:19:41.025000','message-boards-user-stats-moderation','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,sv_SE,pt_BR,fr_FR,ja_JP,ca_ES,de_DE,hu_HU,ar_SA,fi_FI,zh_CN,es_ES,nl_NL\" default-locale=\"en_US\"><title language-id=\"sv_SE\">Moderering av användarstatistik för diskussionsforum</title><title language-id=\"pt_BR\">Moderação de estatísticas de usuário do fórum</title><title language-id=\"fr_FR\">Modération sur statistiques utilisateur des forums de discussion</title><title language-id=\"ja_JP\">掲示板ユーザー統計の承認</title><title language-id=\"ca_ES\">Moderació de les estadístiques d\'usuari dels taulers de missatges</title><title language-id=\"de_DE\">Moderation der Foren-Benutzerstatistiken</title><title language-id=\"hu_HU\">Fórumok felhasználói statisztikáinak a moderálása</title><title language-id=\"ar_SA\">الإشراف على إحصاءات مستخدم لوحات الرسائل</title><title language-id=\"fi_FI\">Keskustelualueiden käyttäjätilastojen moderointi</title><title language-id=\"en_US\">Message Boards User Stats Moderation</title><title language-id=\"zh_CN\">留言板用户统计审核</title><title language-id=\"es_ES\">Moderación de estadísticas de usuario de los foros de discusión</title><title language-id=\"nl_NL\">Moderatiestatistieken forumgebruiker</title></root>','Users with a reputation over the threshold get their threads and comments approved automatically.','{\"#tag-name\":\"workflow-definition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Message Board Threads and Comments Reputation Approver\"},{\"#tag-name\":\"description\",\"#value\":\"Users with a reputation over the threshold get their threads and comments approved automatically.\"},{\"#tag-name\":\"version\",\"#value\":\"1\"},{\"#tag-name\":\"condition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        199,\",\"                        43\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"script\",\"#cdata-value\":[\"com.liferay.message.boards.moderation.internal.kaleo.runtime.condition.MBModerationConditionEvaluator\"]},{\"#tag-name\":\"script-language\",\"#value\":\"java\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"created\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        36,\",\"                        51\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"initial\",\"#value\":\"true\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"target\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approved\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"terminal\\\": true,\",\"                    \\\"xy\\\": [\",\"                        648,\",\"                        50\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"status\",\"#value\":\"0\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onEntry\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"update\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"transitions\\\": {\",\"                        \\\"resubmit\\\": {\",\"                            \\\"bendpoints\\\": [\",\"                                [\",\"                                    303,\",\"                                    140\",\"                                ]\",\"                            ]\",\"                        }\",\"                    },\",\"                    \\\"xy\\\": [\",\"                        636,\",\"                        245\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"deny\"},{\"#tag-name\":\"status\",\"#value\":\"4\"},{\"#tag-name\":\"priority\",\"#value\":\"1\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"pending\"},{\"#tag-name\":\"status\",\"#value\":\"1\"},{\"#tag-name\":\"priority\",\"#value\":\"2\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Creator Modification Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"Your submission was rejected by ${userName}.\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was rejected by ${userName}, please modify and resubmit.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"user\"}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"resubmit\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        285,\",\"                        186\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"${userName} has sent you a ${entryType} for review\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"${userName} has sent you a ${entryType} for review in the workflow.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"assignees\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Completion Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"Your submission was reviewed by ${userName}.\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was reviewed by ${userName}<#if taskComments?has_content> with the following comments: \\\"${taskComments}\\\"<\\/#if>.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onExit\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"roles\",\"#child-nodes\":[{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Portal Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Content Reviewer\"}]}]}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"reject\"},{\"#tag-name\":\"target\",\"#value\":\"update\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]}],\"xmlns\":\"urn:liferay.com:liferay-workflow_7.4.0\",\"xsi:schemaLocation\":\"urn:liferay.com:liferay-workflow_7.4.0 http://www.liferay.com/dtd/liferay-workflow-definition_7_4_0.xsd\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"}','com.liferay.message.boards.model.MBMessage',1,1),
(1,0,31761,0,64463788232944,20096,NULL,'2024-11-21 12:19:41.159000','2024-11-21 12:19:41.231000','Single Approver','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,ar_SA,ca_ES,zh_CN,nl_NL,fi_FI,fr_FR,de_DE,hu_HU,ja_JP,pt_BR,es_ES,sv_SE\" default-locale=\"en_US\"><title language-id=\"en_US\">Single Approver</title><title language-id=\"ar_SA\">مسؤول موافقة واحد</title><title language-id=\"ca_ES\">Aprovador únic</title><title language-id=\"zh_CN\">单个审批者</title><title language-id=\"nl_NL\">Enkele goedkeurder</title><title language-id=\"fi_FI\">Yksittäinen Hyväksyjä</title><title language-id=\"fr_FR\">Valideur unique</title><title language-id=\"de_DE\">Einzelne genehmigende Person</title><title language-id=\"hu_HU\">Egyetlen jóváhagyó</title><title language-id=\"ja_JP\">唯一の承認者</title><title language-id=\"pt_BR\">Aprovador Único</title><title language-id=\"es_ES\">Aprobador único</title><title language-id=\"sv_SE\">Enskild godkännare</title></root>','A single approver can approve a workflow content.','{\"#tag-name\":\"workflow-definition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Single Approver\"},{\"#tag-name\":\"description\",\"#value\":\"A single approver can approve a workflow content.\"},{\"#tag-name\":\"version\",\"#value\":\"1\"},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"created\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        165,\",\"                        76\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"initial\",\"#value\":\"true\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approved\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"terminal\\\": true,\",\"                    \\\"xy\\\": [\",\"                        539,\",\"                        74\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"status\",\"#value\":\"0\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onEntry\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"update\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"transitions\\\": {\",\"                        \\\"resubmit\\\": {\",\"                            \\\"bendpoints\\\": [\",\"                                [\",\"                                    303,\",\"                                    140\",\"                                ]\",\"                            ]\",\"                        }\",\"                    },\",\"                    \\\"xy\\\": [\",\"                        164,\",\"                        533\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"deny\"},{\"#tag-name\":\"status\",\"#value\":\"4\"},{\"#tag-name\":\"priority\",\"#value\":\"1\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"pending\"},{\"#tag-name\":\"status\",\"#value\":\"1\"},{\"#tag-name\":\"priority\",\"#value\":\"2\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Creator Modification Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was rejected by ${userName}, please modify and resubmit.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"user\"}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"resubmit\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        165,\",\"                        292\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"${userName} sent you a ${entryType} for review in the workflow.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"assignees\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Completion Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was reviewed<#if taskComments?has_content> and the reviewer applied the following ${taskComments}<\\/#if>.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onExit\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"roles\",\"#child-nodes\":[{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Account Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Account Member\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Order Manager\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Owner\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Owner\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Portal Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Owner\"}]}]}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"reject\"},{\"#tag-name\":\"target\",\"#value\":\"update\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]}],\"xmlns\":\"urn:liferay.com:liferay-workflow_7.4.0\",\"xsi:schemaLocation\":\"urn:liferay.com:liferay-workflow_7.4.0 http://www.liferay.com/dtd/liferay-workflow-definition_7_4_0.xsd\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"}','all',1,1);

--
-- Table structure for table `KaleoDefinitionVersion`
--

CREATE TABLE `KaleoDefinitionVersion` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoDefinitionVersionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `startKaleoNodeId` bigint(20) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kaleoDefinitionVersionId`,`ctCollectionId`),
  UNIQUE KEY `IX_3ADEC2A` (`companyId`,`name`,`version`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoDefinitionVersion`
--

INSERT INTO `KaleoDefinitionVersion` VALUES
(1,0,31727,0,64463788232944,20096,NULL,'2024-11-21 12:19:40.838000','2024-11-21 12:19:41.030000',31726,'message-boards-user-stats-moderation','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,sv_SE,pt_BR,fr_FR,ja_JP,ca_ES,de_DE,hu_HU,ar_SA,fi_FI,zh_CN,es_ES,nl_NL\" default-locale=\"en_US\"><title language-id=\"sv_SE\">Moderering av användarstatistik för diskussionsforum</title><title language-id=\"pt_BR\">Moderação de estatísticas de usuário do fórum</title><title language-id=\"fr_FR\">Modération sur statistiques utilisateur des forums de discussion</title><title language-id=\"ja_JP\">掲示板ユーザー統計の承認</title><title language-id=\"ca_ES\">Moderació de les estadístiques d\'usuari dels taulers de missatges</title><title language-id=\"de_DE\">Moderation der Foren-Benutzerstatistiken</title><title language-id=\"hu_HU\">Fórumok felhasználói statisztikáinak a moderálása</title><title language-id=\"ar_SA\">الإشراف على إحصاءات مستخدم لوحات الرسائل</title><title language-id=\"fi_FI\">Keskustelualueiden käyttäjätilastojen moderointi</title><title language-id=\"en_US\">Message Boards User Stats Moderation</title><title language-id=\"zh_CN\">留言板用户统计审核</title><title language-id=\"es_ES\">Moderación de estadísticas de usuario de los foros de discusión</title><title language-id=\"nl_NL\">Moderatiestatistieken forumgebruiker</title></root>','Users with a reputation over the threshold get their threads and comments approved automatically.','{\"#tag-name\":\"workflow-definition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Message Board Threads and Comments Reputation Approver\"},{\"#tag-name\":\"description\",\"#value\":\"Users with a reputation over the threshold get their threads and comments approved automatically.\"},{\"#tag-name\":\"version\",\"#value\":\"1\"},{\"#tag-name\":\"condition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        199,\",\"                        43\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"script\",\"#cdata-value\":[\"com.liferay.message.boards.moderation.internal.kaleo.runtime.condition.MBModerationConditionEvaluator\"]},{\"#tag-name\":\"script-language\",\"#value\":\"java\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"created\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        36,\",\"                        51\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"initial\",\"#value\":\"true\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"target\",\"#value\":\"check-reputation\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approved\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"terminal\\\": true,\",\"                    \\\"xy\\\": [\",\"                        648,\",\"                        50\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"status\",\"#value\":\"0\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onEntry\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"update\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"transitions\\\": {\",\"                        \\\"resubmit\\\": {\",\"                            \\\"bendpoints\\\": [\",\"                                [\",\"                                    303,\",\"                                    140\",\"                                ]\",\"                            ]\",\"                        }\",\"                    },\",\"                    \\\"xy\\\": [\",\"                        636,\",\"                        245\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"deny\"},{\"#tag-name\":\"status\",\"#value\":\"4\"},{\"#tag-name\":\"priority\",\"#value\":\"1\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"pending\"},{\"#tag-name\":\"status\",\"#value\":\"1\"},{\"#tag-name\":\"priority\",\"#value\":\"2\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Creator Modification Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"Your submission was rejected by ${userName}.\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was rejected by ${userName}, please modify and resubmit.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"user\"}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"resubmit\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        285,\",\"                        186\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"${userName} has sent you a ${entryType} for review\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"${userName} has sent you a ${entryType} for review in the workflow.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"assignees\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Completion Notification\"},{\"#tag-name\":\"description\",\"#cdata-value\":[\"Your submission was reviewed by ${userName}.\"]},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was reviewed by ${userName}<#if taskComments?has_content> with the following comments: \\\"${taskComments}\\\"<\\/#if>.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onExit\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"roles\",\"#child-nodes\":[{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Portal Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Content Reviewer\"}]}]}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"reject\"},{\"#tag-name\":\"target\",\"#value\":\"update\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]}],\"xmlns\":\"urn:liferay.com:liferay-workflow_7.4.0\",\"xsi:schemaLocation\":\"urn:liferay.com:liferay-workflow_7.4.0 http://www.liferay.com/dtd/liferay-workflow-definition_7_4_0.xsd\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"}','1.0',31734,0,20096,NULL,'2024-11-21 12:19:40.838000'),
(1,0,31762,0,64463788232944,20096,NULL,'2024-11-21 12:19:41.165000','2024-11-21 12:19:41.233000',31761,'Single Approver','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,ar_SA,ca_ES,zh_CN,nl_NL,fi_FI,fr_FR,de_DE,hu_HU,ja_JP,pt_BR,es_ES,sv_SE\" default-locale=\"en_US\"><title language-id=\"en_US\">Single Approver</title><title language-id=\"ar_SA\">مسؤول موافقة واحد</title><title language-id=\"ca_ES\">Aprovador únic</title><title language-id=\"zh_CN\">单个审批者</title><title language-id=\"nl_NL\">Enkele goedkeurder</title><title language-id=\"fi_FI\">Yksittäinen Hyväksyjä</title><title language-id=\"fr_FR\">Valideur unique</title><title language-id=\"de_DE\">Einzelne genehmigende Person</title><title language-id=\"hu_HU\">Egyetlen jóváhagyó</title><title language-id=\"ja_JP\">唯一の承認者</title><title language-id=\"pt_BR\">Aprovador Único</title><title language-id=\"es_ES\">Aprobador único</title><title language-id=\"sv_SE\">Enskild godkännare</title></root>','A single approver can approve a workflow content.','{\"#tag-name\":\"workflow-definition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Single Approver\"},{\"#tag-name\":\"description\",\"#value\":\"A single approver can approve a workflow content.\"},{\"#tag-name\":\"version\",\"#value\":\"1\"},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"created\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        165,\",\"                        76\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"initial\",\"#value\":\"true\"},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"state\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approved\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"terminal\\\": true,\",\"                    \\\"xy\\\": [\",\"                        539,\",\"                        74\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"status\",\"#value\":\"0\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onEntry\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"update\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"transitions\\\": {\",\"                        \\\"resubmit\\\": {\",\"                            \\\"bendpoints\\\": [\",\"                                [\",\"                                    303,\",\"                                    140\",\"                                ]\",\"                            ]\",\"                        }\",\"                    },\",\"                    \\\"xy\\\": [\",\"                        164,\",\"                        533\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"deny\"},{\"#tag-name\":\"status\",\"#value\":\"4\"},{\"#tag-name\":\"priority\",\"#value\":\"1\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"action\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"pending\"},{\"#tag-name\":\"status\",\"#value\":\"1\"},{\"#tag-name\":\"priority\",\"#value\":\"2\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Creator Modification Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was rejected by ${userName}, please modify and resubmit.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"user\"}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"resubmit\"},{\"#tag-name\":\"target\",\"#value\":\"review\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]}]}]},{\"#tag-name\":\"task\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"review\"},{\"#tag-name\":\"metadata\",\"#cdata-value\":[\"\",\"                {\",\"                    \\\"xy\\\": [\",\"                        165,\",\"                        292\",\"                    ]\",\"                }\",\"            \"]},{\"#tag-name\":\"actions\",\"#child-nodes\":[{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"${userName} sent you a ${entryType} for review in the workflow.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"notification-type\",\"#value\":\"user-notification\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"assignees\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onAssignment\"}]},{\"#tag-name\":\"notification\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"Review Completion Notification\"},{\"#tag-name\":\"template\",\"#cdata-value\":[\"Your submission was reviewed<#if taskComments?has_content> and the reviewer applied the following ${taskComments}<\\/#if>.\"]},{\"#tag-name\":\"template-language\",\"#value\":\"freemarker\"},{\"#tag-name\":\"notification-type\",\"#value\":\"email\"},{\"#tag-name\":\"recipients\",\"#child-nodes\":[{\"#tag-name\":\"user\"}],\"receptionType\":\"to\"},{\"#tag-name\":\"execution-type\",\"#value\":\"onExit\"}]}]},{\"#tag-name\":\"assignments\",\"#child-nodes\":[{\"#tag-name\":\"roles\",\"#child-nodes\":[{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Account Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Account Member\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"account\"},{\"#tag-name\":\"name\",\"#value\":\"Order Manager\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"depot\"},{\"#tag-name\":\"name\",\"#value\":\"Asset Library Owner\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"organization\"},{\"#tag-name\":\"name\",\"#value\":\"Organization Owner\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"regular\"},{\"#tag-name\":\"name\",\"#value\":\"Portal Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Administrator\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Content Reviewer\"}]},{\"#tag-name\":\"role\",\"#child-nodes\":[{\"#tag-name\":\"role-type\",\"#value\":\"site\"},{\"#tag-name\":\"name\",\"#value\":\"Site Owner\"}]}]}]},{\"#tag-name\":\"transitions\",\"#child-nodes\":[{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"approve\"},{\"#tag-name\":\"target\",\"#value\":\"approved\"},{\"#tag-name\":\"default\",\"#value\":\"true\"}]},{\"#tag-name\":\"transition\",\"#child-nodes\":[{\"#tag-name\":\"name\",\"#value\":\"reject\"},{\"#tag-name\":\"target\",\"#value\":\"update\"},{\"#tag-name\":\"default\",\"#value\":\"false\"}]}]}]}],\"xmlns\":\"urn:liferay.com:liferay-workflow_7.4.0\",\"xsi:schemaLocation\":\"urn:liferay.com:liferay-workflow_7.4.0 http://www.liferay.com/dtd/liferay-workflow-definition_7_4_0.xsd\",\"xmlns:xsi\":\"http://www.w3.org/2001/XMLSchema-instance\"}','1.0',31765,0,20096,NULL,'2024-11-21 12:19:41.165000');

--
-- Table structure for table `KaleoInstance`
--

CREATE TABLE `KaleoInstance` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoInstanceId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionName` varchar(200) DEFAULT NULL,
  `kaleoDefinitionVersion` int(11) DEFAULT NULL,
  `rootKaleoInstanceTokenId` bigint(20) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `className` varchar(200) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  `workflowContext` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoInstanceId`,`ctCollectionId`),
  KEY `IX_58D85ECB` (`className`,`classPK`),
  KEY `IX_BF5839F8` (`companyId`,`kaleoDefinitionName`,`kaleoDefinitionVersion`,`completionDate`),
  KEY `IX_DFAFED59` (`companyId`,`userId`,`kaleoInstanceId`),
  KEY `IX_3D0874DE` (`completed`,`kaleoDefinitionId`),
  KEY `IX_3DA1A5AC` (`kaleoDefinitionVersionId`,`completed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoInstance`
--


--
-- Table structure for table `KaleoInstanceToken`
--

CREATE TABLE `KaleoInstanceToken` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoInstanceTokenId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoInstanceId` bigint(20) DEFAULT NULL,
  `parentKaleoInstanceTokenId` bigint(20) DEFAULT NULL,
  `currentKaleoNodeId` bigint(20) DEFAULT NULL,
  `currentKaleoNodeName` varchar(200) DEFAULT NULL,
  `className` varchar(200) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kaleoInstanceTokenId`,`ctCollectionId`),
  KEY `IX_360D34D9` (`companyId`,`parentKaleoInstanceTokenId`,`completionDate`),
  KEY `IX_1181057E` (`kaleoDefinitionVersionId`),
  KEY `IX_F42AAFF6` (`kaleoInstanceId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoInstanceToken`
--


--
-- Table structure for table `KaleoLog`
--

CREATE TABLE `KaleoLog` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoLogId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `kaleoClassName` varchar(200) DEFAULT NULL,
  `kaleoClassPK` bigint(20) DEFAULT NULL,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoInstanceId` bigint(20) DEFAULT NULL,
  `kaleoInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoTaskInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoNodeName` varchar(200) DEFAULT NULL,
  `terminalKaleoNode` tinyint(4) DEFAULT NULL,
  `kaleoActionId` bigint(20) DEFAULT NULL,
  `kaleoActionName` varchar(200) DEFAULT NULL,
  `kaleoActionDescription` longtext DEFAULT NULL,
  `previousKaleoNodeId` bigint(20) DEFAULT NULL,
  `previousKaleoNodeName` varchar(200) DEFAULT NULL,
  `previousAssigneeClassName` varchar(200) DEFAULT NULL,
  `previousAssigneeClassPK` bigint(20) DEFAULT NULL,
  `currentAssigneeClassName` varchar(200) DEFAULT NULL,
  `currentAssigneeClassPK` bigint(20) DEFAULT NULL,
  `type_` varchar(50) DEFAULT NULL,
  `comment_` longtext DEFAULT NULL,
  `startDate` datetime(6) DEFAULT NULL,
  `endDate` datetime(6) DEFAULT NULL,
  `duration` bigint(20) DEFAULT NULL,
  `workflowContext` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoLogId`,`ctCollectionId`),
  KEY `IX_73B5F4DE` (`companyId`),
  KEY `IX_935D8E5E` (`kaleoDefinitionVersionId`),
  KEY `IX_5BC6AB16` (`kaleoInstanceId`),
  KEY `IX_18212EF6` (`kaleoInstanceTokenId`,`type_`,`kaleoClassName`,`kaleoClassPK`),
  KEY `IX_B0CDCA38` (`kaleoTaskInstanceTokenId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoLog`
--


--
-- Table structure for table `KaleoNode`
--

