-- 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,'bbff71de-78c7-8a81-a361-13c124dcadaa','bbff71de-78c7-8a81-a361-13c124dcadaa',31635,20120,87782848217510,20096,NULL,'2025-01-23 16:30:43.001000','2025-01-23 16:30:43.106000',28886,101,31630,31634,'/31631/31634/','1','id-c89c5ff7-11fc-0a9d-476e-73f8566413d',NULL,'image/png','id-c89c5ff7-11fc-0a9d-476e-73f8566413d',NULL,'',0,'1.0',846,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'10be1654-915c-d630-ed5c-b3b6058c1405','image.default.company.logo',31720,20120,87782848217510,20096,NULL,'2025-01-23 16:30:45.984000','2025-01-23 16:30:45.999000',0,0,31718,31719,'/31719/','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,'c2e693f1-f163-04e5-598d-0e200cc448cc','c2e693f1-f163-04e5-598d-0e200cc448cc',31748,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:48.839000','2025-01-23 16:30:48.878000',0,0,20117,31746,'/31746/','3','astronaut.png','png','image/png','astronaut.png',NULL,'',0,'1.0',40255,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'280818ba-8b75-70e2-61ee-53334672053c','280818ba-8b75-70e2-61ee-53334672053c',31758,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.183000','2025-01-23 16:30:49.220000',0,0,20117,31746,'/31746/','4','earth.png','png','image/png','earth.png',NULL,'',0,'1.0',356773,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'1a6f71de-7f0b-c675-6ba3-7977886730e2','1a6f71de-7f0b-c675-6ba3-7977886730e2',31767,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.570000','2025-01-23 16:30:49.597000',0,0,20117,31746,'/31746/','5','moon.png','png','image/png','moon.png',NULL,'',0,'1.0',5720,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'0263fbc1-dab7-3dcb-2f01-d507bff4d098','0263fbc1-dab7-3dcb-2f01-d507bff4d098',31782,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.942000','2025-01-23 16:30:49.969000',0,0,20117,31746,'/31746/','6','planet.png','png','image/png','planet.png',NULL,'',0,'1.0',8440,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'ba48cbe9-c254-c34d-5a86-4b187ed22bc8','ba48cbe9-c254-c34d-5a86-4b187ed22bc8',31794,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.287000','2025-01-23 16:30:50.315000',0,0,20117,31746,'/31746/','7','satellite.png','png','image/png','satellite.png',NULL,'',0,'1.0',14429,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'88f702d9-a919-d05e-8478-673e5291fe05','88f702d9-a919-d05e-8478-673e5291fe05',31806,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.578000','2025-01-23 16:30:50.605000',0,0,20117,31746,'/31746/','8','stars.png','png','image/png','stars.png',NULL,'',0,'1.0',35548,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'0dc96f38-e7cc-2694-6e6f-85371a28d6e4','0dc96f38-e7cc-2694-6e6f-85371a28d6e4',31818,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.847000','2025-01-23 16:30:50.878000',0,0,20117,31746,'/31746/','9','tree.png','png','image/png','tree.png',NULL,'',0,'1.0',367504,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'0d416349-1ed1-2d63-a840-17ff4e210227','0d416349-1ed1-2d63-a840-17ff4e210227',31858,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.505000','2025-01-23 16:30:54.521000',28933,31832,31856,31857,'/31857/','10','31832_preview.png','png','image/png','31832_preview.png',NULL,'',0,'1.0',604726,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'529fb23a-0d3e-d394-ec89-f361c78a9a6a','529fb23a-0d3e-d394-ec89-f361c78a9a6a',31889,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.111000','2025-01-23 16:30:55.145000',28933,31863,31856,31857,'/31857/','11','31863_preview.png','png','image/png','31863_preview.png',NULL,'',0,'1.0',307368,0,0,0,0,0,NULL,NULL,NULL,NULL),
(1,0,'f76b0265-171d-150a-5dde-dcf70bbc5622','f76b0265-171d-150a-5dde-dcf70bbc5622',31938,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.727000','2025-01-23 16:30:55.752000',28933,31894,31856,31857,'/31857/','12','31894_preview.png','png','image/png','31894_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,'8ead6eb3-7a68-b075-9283-d227f5bbb1d1',31641,87782848217510,31642,30603,31635,31636),
(0,0,'42fe4a82-a54e-8699-8f28-33d4730c5933',31725,87782848217510,31726,30603,31720,31721),
(0,0,'ee982285-b7bf-c8fa-4237-380b0a9571b8',31754,87782848217510,31755,30603,31748,31749),
(0,0,'15776dc8-4b71-45c3-a64b-a9b735ade458',31765,87782848217510,31766,30603,31758,31759),
(0,0,'b2d3754a-b6b3-6b1f-d741-d2a5dcb46474',31776,87782848217510,31777,30603,31767,31768),
(0,0,'6bfe9e19-1b4a-6038-cb28-e530f5b93c81',31789,87782848217510,31790,30603,31782,31783),
(0,0,'072f54dd-01dd-2058-9349-440f1aeea427',31801,87782848217510,31802,30603,31794,31795),
(0,0,'eaca9408-8750-edb9-7dc1-f4c6d3febe19',31814,87782848217510,31815,30603,31806,31807),
(0,0,'8c2236fe-5979-b7ab-129c-b39f1f969c5b',31825,87782848217510,31826,30603,31818,31819),
(0,0,'7d4efb79-48cc-06e9-1281-b7dbe25af52c',31867,87782848217510,31868,30603,31858,31859),
(0,0,'91550cc0-8373-056d-050d-a1320ce4a1e1',31895,87782848217510,31896,30603,31889,31890),
(0,0,'591b560b-6bff-e736-49ed-66c4e2a57865',31943,87782848217510,31944,30603,31938,31939);

--
-- 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,'eaa42c46-928b-56c0-7b78-6c1bf49f8e7b',0,0,0,0,NULL,'2025-01-23 16:28:56.831000','2025-01-23 16:28:56.831000',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,'f84d4221-2c60-567f-6c54-20ecc0c8f4a5',30705,20120,87782848217510,20096,NULL,'2025-01-23 16:30:26.254000','2025-01-23 16:30:26.254000',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,'c44cda0f-9ddf-f958-f189-f1caa8f15fcd',30905,20120,87782848217510,20096,NULL,'2025-01-23 16:30:26.962000','2025-01-23 16:30:26.962000',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,'f39b0983-5112-3937-304e-04b73af5f753',31636,20120,87782848217510,20096,NULL,'2025-01-23 16:30:43.054000','2025-01-23 16:30:43.106000',31630,31634,31635,'/31631/31634/','id-c89c5ff7-11fc-0a9d-476e-73f8566413d',NULL,'image/png','id-c89c5ff7-11fc-0a9d-476e-73f8566413d',NULL,NULL,'',0,'1.0',846,NULL,'4afe2f73-fcea-4b9d-8ef9-9b991c34d8df',NULL,NULL,NULL,NULL,0,20096,NULL,'2025-01-23 16:30:43.106000'),
(1,0,'e4f35d1e-d797-5006-4b41-215d2dd358b1',31721,20120,87782848217510,20096,NULL,'2025-01-23 16:30:45.987000','2025-01-23 16:30:45.999000',31718,31719,31720,'/31719/','company_logo.png','png','image/png','company_logo.png',NULL,NULL,'',0,'1.0',634,NULL,'7f438691-c839-4eff-883a-5d30d60a2a9d',NULL,NULL,NULL,NULL,0,20096,NULL,'2025-01-23 16:30:45.999000'),
(1,0,'dc510391-7d92-33ab-260d-857ea9dd0ed4',31749,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:48.843000','2025-01-23 16:30:48.878000',20117,31746,31748,'/31746/','astronaut.png','png','image/png','astronaut.png',NULL,NULL,'',0,'1.0',40255,NULL,'73b4370c-38b6-4e49-a0d7-5bf041613ba2',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:48.878000'),
(1,0,'27b2aef0-4edf-2a10-3000-f7e1dbd78fbd',31759,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.188000','2025-01-23 16:30:49.220000',20117,31746,31758,'/31746/','earth.png','png','image/png','earth.png',NULL,NULL,'',0,'1.0',356773,NULL,'b12b7f26-e103-4289-aa53-0d6f93589296',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:49.220000'),
(1,0,'96f58f83-2cfb-a5c5-047b-f17dd8b9e4d3',31768,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.575000','2025-01-23 16:30:49.597000',20117,31746,31767,'/31746/','moon.png','png','image/png','moon.png',NULL,NULL,'',0,'1.0',5720,NULL,'51ed992d-46f0-4edf-9881-02c914854691',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:49.597000'),
(1,0,'34b1a302-cfac-13f2-bdbf-32c647b7528b',31783,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:49.948000','2025-01-23 16:30:49.969000',20117,31746,31782,'/31746/','planet.png','png','image/png','planet.png',NULL,NULL,'',0,'1.0',8440,NULL,'11b249bd-c4bc-4176-bc00-eb3909b9d3b0',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:49.969000'),
(1,0,'d3287657-1cb3-7724-a923-be3349746a05',31795,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.297000','2025-01-23 16:30:50.315000',20117,31746,31794,'/31746/','satellite.png','png','image/png','satellite.png',NULL,NULL,'',0,'1.0',14429,NULL,'19a19e1b-5ce5-4942-8f87-7345f1c26254',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:50.315000'),
(1,0,'c844e1f9-b322-f65c-ae2d-afbd3287c867',31807,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.584000','2025-01-23 16:30:50.605000',20117,31746,31806,'/31746/','stars.png','png','image/png','stars.png',NULL,NULL,'',0,'1.0',35548,NULL,'73f20683-96e0-4fbb-8d69-5109134481bf',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:50.605000'),
(1,0,'4ade994c-8c5a-7b02-3a3d-84c27e3aae06',31819,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:50.853000','2025-01-23 16:30:50.878000',20117,31746,31818,'/31746/','tree.png','png','image/png','tree.png',NULL,NULL,'',0,'1.0',367504,NULL,'4fe8887f-ef2d-4ec1-a71f-3ebfc17ca985',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:50.878000'),
(1,0,'75145450-1560-2b67-ca07-d0dc9ebab907',31859,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.512000','2025-01-23 16:30:54.521000',31856,31857,31858,'/31857/','31832_preview.png','png','image/png','31832_preview.png',NULL,NULL,'',0,'1.0',604726,NULL,'f32e4f66-7a8f-4b3e-818e-b9b04ae95155',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:54.521000'),
(1,0,'e085487a-e90a-0fc1-bcfe-7539a762ca71',31890,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.125000','2025-01-23 16:30:55.145000',31856,31857,31889,'/31857/','31863_preview.png','png','image/png','31863_preview.png',NULL,NULL,'',0,'1.0',307368,NULL,'0139f29a-46b5-40c5-8359-3927925e373b',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:55.144000'),
(1,0,'1776a571-4ff2-ae80-69d0-e1272eca5030',31939,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.737000','2025-01-23 16:30:55.752000',31856,31857,31938,'/31857/','31894_preview.png','png','image/png','31894_preview.png',NULL,NULL,'',0,'1.0',4846,NULL,'857c5093-ddb6-47cf-9f30-948ff613f413',NULL,NULL,NULL,NULL,0,20123,'Test Test','2025-01-23 16:30:55.752000');

--
-- 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,'dcf2e663-26af-9f96-0068-dbbaa5846517','dcf2e663-26af-9f96-0068-dbbaa5846517',31631,20120,87782848217510,20096,NULL,'2025-01-23 16:30:42.783000','2025-01-23 16:30:42.783000',31630,1,0,'/31631/','com.liferay.oauth2.provider',NULL,'2025-01-23 16:30:42.836000',0,1,0,NULL,0,0,NULL,NULL),
(1,0,'40d29915-455c-ef68-19b4-91f2ffb2d061','40d29915-455c-ef68-19b4-91f2ffb2d061',31634,20120,87782848217510,20096,NULL,'2025-01-23 16:30:42.837000','2025-01-23 16:30:42.837000',31630,0,31631,'/31631/31634/','icons',NULL,'2025-01-23 16:30:43.001000',0,0,0,NULL,0,0,NULL,NULL),
(1,0,'f11c13f4-c379-0ce4-5c06-62b5c3c31124','f11c13f4-c379-0ce4-5c06-62b5c3c31124',31719,20120,87782848217510,20096,NULL,'2025-01-23 16:30:45.660000','2025-01-23 16:30:45.660000',31718,1,0,'/31719/','image.default.company.logo',NULL,'2025-01-23 16:30:45.984000',0,1,0,NULL,0,0,NULL,NULL),
(7,0,'dbba7231-10b5-c9a1-056d-e42c6713d988','dbba7231-10b5-c9a1-056d-e42c6713d988',31746,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:48.560000','2025-01-23 16:30:48.560000',20117,0,0,'/31746/','Provided by Liferay',NULL,'2025-01-23 16:30:50.847000',0,0,0,NULL,0,0,NULL,NULL),
(3,0,'ed7070a2-c098-5a8a-6509-1a95454c0710','ed7070a2-c098-5a8a-6509-1a95454c0710',31857,20117,87782848217510,20096,NULL,'2025-01-23 16:30:54.475000','2025-01-23 16:30:52.897000',31856,1,0,'/31857/','com_liferay_layout_admin_web_portlet_GroupPagesPortlet',NULL,'2025-01-23 16:30:55.727000',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,31640,87782848217510,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,31983,87782848217510,20096,NULL,'2025-01-24 00:00:00.052000','2025-01-24 00:00:00.062000',30907,'2025-01-24 00:00:00.062000',NULL,NULL,'2025-01-24 00:00:00.049000',2),
(1,31984,87782848217510,20096,NULL,'2025-01-25 00:00:00.021000','2025-01-25 00:00:00.026000',30907,'2025-01-25 00:00:00.026000',NULL,NULL,'2025-01-25 00:00:00.018000',2),
(1,31985,87782848217510,20096,NULL,'2025-01-26 00:00:00.029000','2025-01-26 00:00:00.034000',30907,'2025-01-26 00:00:00.034000',NULL,NULL,'2025-01-26 00:00:00.024000',2),
(1,31986,87782848217510,20096,NULL,'2025-01-27 00:00:00.024000','2025-01-27 00:00:00.031000',30907,'2025-01-27 00:00:00.030000',NULL,NULL,'2025-01-27 00:00:00.021000',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,'58be4861-3f0b-8a84-e6e4-9eb67ef5d2e8','58be4861-3f0b-8a84-e6e4-9eb67ef5d2e8',30907,87782848217510,20096,NULL,'2025-01-23 16:30:28.013000','2025-01-23 16:30:28.026000',1,'0 0 0 * * ?',0,'scheduled-publications-conflict-checks','',NULL,'scheduled-publications-conflict-checks',0,'2025-01-23 16:30: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`
--


--
-- 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,87782848217510,'2025-01-23 16:29:18.110000',20377,'accessSecret',15,'',''),
(0,0,20379,87782848217510,'2025-01-23 16:29:18.133000',20377,'accessToken',15,'',''),
(0,0,20380,87782848217510,'2025-01-23 16:29:18.148000',20377,'requestSecret',15,'',''),
(0,0,20381,87782848217510,'2025-01-23 16:29:18.160000',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,87782848217510,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
(0,0,'f20f645a-3e23-44cc-cc7f-85fef4f9aa47','f20f645a-3e23-44cc-cc7f-85fef4f9aa47',31846,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:53.543000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}','hqrc',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:53.547000',NULL),
(0,0,'6bfc88a2-2058-e247-137a-fa5c9c0e47e5','6bfc88a2-2058-e247-137a-fa5c9c0e47e5',31847,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:53.594000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}}}','hjzu',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:53.594000',NULL),
(0,0,'e3a48956-5275-8ee0-b6be-89c99f5ed57f','e3a48956-5275-8ee0-b6be-89c99f5ed57f',31848,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:53.605000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}','ovim',2,'BASIC_COMPONENT-button',1,'2025-01-23 16:30:53.605000',NULL),
(0,0,'9bfb4429-8045-5c6e-1af5-d613f52e8faf','9bfb4429-8045-5c6e-1af5-d613f52e8faf',31853,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.354000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}','hqrc',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:53.547000',NULL),
(0,0,'4a81d782-4dfd-ca26-2636-21f8028ee675','4a81d782-4dfd-ca26-2636-21f8028ee675',31854,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.369000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}}}','hjzu',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:53.594000',NULL),
(0,0,'18540d9d-e680-a87a-d15b-447cdee06aec','18540d9d-e680-a87a-d15b-447cdee06aec',31855,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.379000','2025-01-23 16:30:52.897000',0,0,31833,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\"}}','ovim',2,'BASIC_COMPONENT-button',1,'2025-01-23 16:30:53.605000',NULL),
(0,0,'50ba552b-e9c7-322b-52d0-49db0452b741','50ba552b-e9c7-322b-52d0-49db0452b741',31881,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.915000','2025-01-23 16:30:54.779000',0,0,31864,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\"}}','coqv',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:54.915000',NULL),
(0,0,'d37d8c49-692e-771b-95cd-78c95c5a4da1','d37d8c49-692e-771b-95cd-78c95c5a4da1',31882,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.948000','2025-01-23 16:30:54.779000',0,0,31864,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\"}}}','mqkw',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:54.948000',NULL),
(0,0,'f65d452b-386d-c66e-931a-5d217b672146','f65d452b-386d-c66e-931a-5d217b672146',31887,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.040000','2025-01-23 16:30:54.779000',0,0,31864,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\"}}','coqv',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:54.915000',NULL),
(0,0,'771f97fb-12ec-ac74-d46a-5594a33519f4','771f97fb-12ec-ac74-d46a-5594a33519f4',31888,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.047000','2025-01-23 16:30:54.779000',0,0,31864,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\"}}}','mqkw',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:54.948000',NULL),
(0,0,'39bc088b-f965-da62-d1ef-a79f2e29750a','39bc088b-f965-da62-d1ef-a79f2e29750a',31912,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.390000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ucgb',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.390000',NULL),
(0,0,'d0d680c0-8d46-edee-7481-a08c4cf480c5','d0d680c0-8d46-edee-7481-a08c4cf480c5',31913,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.410000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','htwu',1,'BASIC_COMPONENT-button',1,'2025-01-23 16:30:55.410000',NULL),
(0,0,'d4bc2a6f-3eeb-549a-cbb7-34b2e41bb4bf','d4bc2a6f-3eeb-549a-cbb7-34b2e41bb4bf',31914,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.419000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','ssww',0,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.420000',NULL),
(0,0,'d6796ff7-cf0f-07c2-28f1-83ce5e43b275','d6796ff7-cf0f-07c2-28f1-83ce5e43b275',31915,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.427000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','avwg',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.427000',NULL),
(0,0,'da1132c5-5096-9a1f-e860-c82a741b3282','da1132c5-5096-9a1f-e860-c82a741b3282',31916,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.433000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','zdfl',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.433000',NULL),
(0,0,'4cc39bae-c28e-0740-72d5-24cd3b48e568','4cc39bae-c28e-0740-72d5-24cd3b48e568',31917,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.446000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ofcq',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.446000',NULL),
(0,0,'108a617f-e51c-0ff0-9bb6-0aecf2cc8e59','108a617f-e51c-0ff0-9bb6-0aecf2cc8e59',31918,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.455000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','hufj',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.455000',NULL),
(0,0,'8723f1e7-04f4-ffb6-9c9c-22a4e7f771a9','8723f1e7-04f4-ffb6-9c9c-22a4e7f771a9',31919,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.468000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ucyd',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.468000',NULL),
(0,0,'50299964-4b0c-4e0a-2797-d27884871ead','50299964-4b0c-4e0a-2797-d27884871ead',31920,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.479000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','nola',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.479000',NULL),
(0,0,'ed57818f-f704-d459-6797-ff80c87fc0ff','ed57818f-f704-d459-6797-ff80c87fc0ff',31921,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.492000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','iwko',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.492000',NULL),
(0,0,'720f9a66-da33-c59e-925e-f30ec74ce8e4','720f9a66-da33-c59e-925e-f30ec74ce8e4',31922,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.508000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','rcaa',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.508000',NULL),
(0,0,'29c34f41-0e6a-c810-1e6a-cd5335240fb4','29c34f41-0e6a-c810-1e6a-cd5335240fb4',31927,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.624000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','avwg',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.427000',NULL),
(0,0,'20f8ddcf-1845-92a5-a3bc-fde825fa4396','20f8ddcf-1845-92a5-a3bc-fde825fa4396',31928,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.631000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','zdfl',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.433000',NULL),
(0,0,'9f0d0123-e961-91c5-b3f2-104940005474','9f0d0123-e961-91c5-b3f2-104940005474',31929,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.637000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','iwko',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.492000',NULL),
(0,0,'8f3c1c1d-ea91-0097-444a-cdaf7538efa5','8f3c1c1d-ea91-0097-444a-cdaf7538efa5',31930,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.643000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','rcaa',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.508000',NULL),
(0,0,'cadfe4ab-b95f-ff82-d477-157aea32674a','cadfe4ab-b95f-ff82-d477-157aea32674a',31931,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.648000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','ssww',0,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.420000',NULL),
(0,0,'650fb447-bd0a-6431-5df4-4af765f114f1','650fb447-bd0a-6431-5df4-4af765f114f1',31932,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.660000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ucyd',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.468000',NULL),
(0,0,'48ab7818-d8a2-d2fb-0c67-3904cc761940','48ab7818-d8a2-d2fb-0c67-3904cc761940',31933,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.665000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','htwu',1,'BASIC_COMPONENT-button',1,'2025-01-23 16:30:55.410000',NULL),
(0,0,'c8641e3b-87e7-2edb-2ade-3835f0303343','c8641e3b-87e7-2edb-2ade-3835f0303343',31934,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.671000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ofcq',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.446000',NULL),
(0,0,'2440ce43-358a-d3a0-7abb-3c509e113f17','2440ce43-358a-d3a0-7abb-3c509e113f17',31935,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.677000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','hufj',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.455000',NULL),
(0,0,'59c6796d-f9b2-6688-fa79-de4a8cec49f7','59c6796d-f9b2-6688-fa79-de4a8cec49f7',31936,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.683000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}}}','nola',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.479000',NULL),
(0,0,'9d8f961e-ccf7-6c2e-0fb8-7305c4907f0d','9d8f961e-ccf7-6c2e-0fb8-7305c4907f0d',31937,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.690000','2025-01-23 16:30:55.270000',0,0,31897,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\"}}','ucgb',0,'BASIC_COMPONENT-heading',1,'2025-01-23 16:30:55.390000',NULL),
(0,0,'41b5205a-f88b-dbc4-ccd5-8a1dc403c69c','41b5205a-f88b-dbc4-ccd5-8a1dc403c69c',31947,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.986000','2025-01-23 16:30:55.270000',0,0,31731,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\"}}}','qlil',0,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.986000',NULL),
(0,0,'829113bf-af7c-8dcc-cd2a-fa9c069402e7','829113bf-af7c-8dcc-cd2a-fa9c069402e7',31948,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:56.002000','2025-01-23 16:30:55.270000',0,0,31731,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\"}}}}','cizf',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:56.002000',NULL),
(0,0,'943dd8f6-7623-e6e7-df39-7c8613da3176','943dd8f6-7623-e6e7-df39-7c8613da3176',31949,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:56.022000','2025-01-23 16:30:55.270000',0,0,31731,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\":\"31818\",\"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\"}}','upxa',0,'BASIC_COMPONENT-image',1,'2025-01-23 16:30:56.023000',NULL),
(0,0,'03043885-7102-33c1-a201-d8fbf76430df','03043885-7102-33c1-a201-d8fbf76430df',31951,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:56.111000','2025-01-23 16:30:55.270000',31948,0,31731,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\"}}}}','cizf',1,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:56.002000',NULL),
(0,0,'b9d79bb9-f4c8-62f4-7fda-cee867da4971','b9d79bb9-f4c8-62f4-7fda-cee867da4971',31952,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:56.119000','2025-01-23 16:30:55.270000',31947,0,31731,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\"}}}','qlil',0,'BASIC_COMPONENT-paragraph',1,'2025-01-23 16:30:55.986000',NULL),
(0,0,'df636b43-4e13-6516-8612-8f73db82806e','df636b43-4e13-6516-8612-8f73db82806e',31953,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:56.124000','2025-01-23 16:30:55.270000',31949,0,31731,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\":\"31818\",\"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\"}}','upxa',0,'BASIC_COMPONENT-image',1,'2025-01-23 16:30:56.023000',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,'af9cff2c-0299-bffb-6a9a-8aa01de8be56','en_US',31491,31242,87782848217510,'2025-01-23 16:30:37.316000','2025-01-23 16:30:37.316000',31489,4),
(0,0,'9640d941-adb6-e410-ecb7-7cfc320f4803','en_US',31614,20117,87782848217510,'2025-01-23 16:30:42.039000','2025-01-23 16:30:42.039000',31611,5),
(0,0,'a83a56ce-e557-b5fd-9cda-95f35ac88236','en_US',31638,20120,87782848217510,'2025-01-23 16:30:43.072000','2025-01-23 16:30:43.072000',31300,31635),
(0,0,'346cec2e-ddd5-dadb-7636-155b96ef0e53','en_US',31723,20120,87782848217510,'2025-01-23 16:30:45.990000','2025-01-23 16:30:45.990000',31300,31720),
(0,0,'a8047eea-faba-cae1-34ba-ca33691c36d2','en_US',31738,20117,87782848217510,'2025-01-23 16:30:47.102000','2025-01-23 16:30:47.102000',31611,6),
(0,0,'bdb9e131-7046-4ee6-21f3-2c4959f7edf2','en_US',31744,20117,87782848217510,'2025-01-23 16:30:47.145000','2025-01-23 16:30:46.861000',31611,7),
(0,0,'7ce9e919-b31e-c3b5-0cef-33726ff72b69','en_US',31751,20117,87782848217510,'2025-01-23 16:30:48.850000','2025-01-23 16:30:48.850000',31300,31748),
(0,0,'3ea26d78-0f54-2e59-240c-641a6774c75f','en_US',31761,20117,87782848217510,'2025-01-23 16:30:49.200000','2025-01-23 16:30:49.200000',31300,31758),
(0,0,'9b182649-5b22-acad-bf75-1a53f688887b','en_US',31771,20117,87782848217510,'2025-01-23 16:30:49.580000','2025-01-23 16:30:49.580000',31300,31767),
(0,0,'96627d35-31df-34b0-49e6-6c163d3d6ba4','en_US',31785,20117,87782848217510,'2025-01-23 16:30:49.951000','2025-01-23 16:30:49.951000',31300,31782),
(0,0,'710e3935-9582-9853-c3af-f5ef12824252','en_US',31797,20117,87782848217510,'2025-01-23 16:30:50.302000','2025-01-23 16:30:50.302000',31300,31794),
(0,0,'72e356a7-939e-e9c7-4444-60de3ac1d299','en_US',31810,20117,87782848217510,'2025-01-23 16:30:50.591000','2025-01-23 16:30:50.591000',31300,31806),
(0,0,'1ed11fbf-b846-8082-2bb1-25851003d6e4','en_US',31821,20117,87782848217510,'2025-01-23 16:30:50.863000','2025-01-23 16:30:50.863000',31300,31818),
(0,0,'3d9c7bcd-1348-b905-5b1d-db38387b908c','en_US',31838,20117,87782848217510,'2025-01-23 16:30:52.914000','2025-01-23 16:30:46.861000',31611,8),
(0,0,'1a0e58ee-2da2-1943-f76f-2f009f4697ac','en_US',31844,20117,87782848217510,'2025-01-23 16:30:52.944000','2025-01-23 16:30:52.897000',31611,9),
(0,0,'5039d489-b603-486d-6042-0fcf073ce95e','en_US',31861,20117,87782848217510,'2025-01-23 16:30:54.515000','2025-01-23 16:30:54.515000',31300,31858),
(0,0,'22ecf1d2-add1-3742-e3c1-8131eec06fb1','en_US',31871,20117,87782848217510,'2025-01-23 16:30:54.827000','2025-01-23 16:30:52.897000',31611,10),
(0,0,'e1f3c584-b14b-1633-6922-808744013d5a','en_US',31879,20117,87782848217510,'2025-01-23 16:30:54.886000','2025-01-23 16:30:54.779000',31611,11),
(0,0,'0ba8f77b-40d1-e4b9-a480-4e95f7b4e1b6','en_US',31892,20117,87782848217510,'2025-01-23 16:30:55.132000','2025-01-23 16:30:55.132000',31300,31889),
(0,0,'207d6834-6cf9-2e0a-cb97-167b538c1e38','en_US',31904,20117,87782848217510,'2025-01-23 16:30:55.303000','2025-01-23 16:30:54.779000',31611,12),
(0,0,'55fbd1db-4d51-60ff-b136-806a98d38414','en_US',31910,20117,87782848217510,'2025-01-23 16:30:55.353000','2025-01-23 16:30:55.270000',31611,13),
(0,0,'0dda8d9e-a4a5-2d9b-b4ff-65ea9f05fc59','en_US',31941,20117,87782848217510,'2025-01-23 16:30:55.741000','2025-01-23 16:30:55.741000',31300,31938),
(0,0,'7d29a85f-fa68-fbfb-453c-a38c2157bc51','en_US',31965,20125,87782848217510,'2025-01-23 16:31:22.326000','2025-01-23 16:31:22.326000',31489,14),
(0,0,'1c98dfcd-104c-d644-55f9-a11b20aa92a6','en_US',31969,20125,87782848217510,'2025-01-23 16:31:22.559000','2025-01-23 16:31:22.559000',31611,15),
(0,0,'64ee4ec5-6303-3614-67e1-de9ffd4412d8','en_US',31977,20117,87782848217510,'2025-01-23 16:31:52.220000','2025-01-23 16:31:52.220000',31611,16);

--
-- 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,87782848217510,31491,'en_US','/layout',31242,31489,4),
(0,0,2,87782848217510,31614,'en_US','/search',20117,31611,5),
(0,0,3,87782848217510,31638,'en_US','id-c89c5ff7-11fc-0a9d-476e-73f8566413d',20120,31300,31635),
(0,0,4,87782848217510,31723,'en_US','company_logo-png',20120,31300,31720),
(0,0,5,87782848217510,31738,'en_US','/home',20117,31611,6),
(0,0,6,87782848217510,31744,'en_US','/4ccb9648-0e40-40c1-f24c-0f4aeb32f844',20117,31611,7),
(0,0,7,87782848217510,31751,'en_US','astronaut-png',20117,31300,31748),
(0,0,8,87782848217510,31761,'en_US','earth-png',20117,31300,31758),
(0,0,9,87782848217510,31771,'en_US','moon-png',20117,31300,31767),
(0,0,10,87782848217510,31785,'en_US','planet-png',20117,31300,31782),
(0,0,11,87782848217510,31797,'en_US','satellite-png',20117,31300,31794),
(0,0,12,87782848217510,31810,'en_US','stars-png',20117,31300,31806),
(0,0,13,87782848217510,31821,'en_US','tree-png',20117,31300,31818),
(0,0,14,87782848217510,31838,'en_US','/0928132a-b011-6a1c-5d57-9c624330b3a1',20117,31611,8),
(0,0,15,87782848217510,31844,'en_US','/8a733320-411f-1f70-4060-16e6aec7a51b',20117,31611,9),
(0,0,16,87782848217510,31861,'en_US','31832_preview-png',20117,31300,31858),
(0,0,17,87782848217510,31871,'en_US','/6734c2bb-5c1e-d7e6-0b88-b60ba9595805',20117,31611,10),
(0,0,18,87782848217510,31879,'en_US','/25a02548-3d06-db51-459b-253287f0ff91',20117,31611,11),
(0,0,19,87782848217510,31892,'en_US','31863_preview-png',20117,31300,31889),
(0,0,20,87782848217510,31904,'en_US','/989ecf72-3e6c-73cd-6576-916e8382678b',20117,31611,12),
(0,0,21,87782848217510,31910,'en_US','/54895690-e057-0228-b9ae-cc0e7539d210',20117,31611,13),
(0,0,22,87782848217510,31941,'en_US','31894_preview-png',20117,31300,31938),
(0,0,23,87782848217510,31965,'en_US','/home',20125,31489,14),
(0,0,24,87782848217510,31969,'en_US','/home',20125,31611,15),
(0,0,25,87782848217510,31977,'en_US','/manage',20117,31611,16);

--
-- 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,31490,87782848217510,31489,4,31491),
(0,0,31613,87782848217510,31611,5,31614),
(0,0,31637,87782848217510,31300,31635,31638),
(0,0,31722,87782848217510,31300,31720,31723),
(0,0,31737,87782848217510,31611,6,31738),
(0,0,31743,87782848217510,31611,7,31744),
(0,0,31750,87782848217510,31300,31748,31751),
(0,0,31760,87782848217510,31300,31758,31761),
(0,0,31770,87782848217510,31300,31767,31771),
(0,0,31784,87782848217510,31300,31782,31785),
(0,0,31796,87782848217510,31300,31794,31797),
(0,0,31809,87782848217510,31300,31806,31810),
(0,0,31820,87782848217510,31300,31818,31821),
(0,0,31837,87782848217510,31611,8,31838),
(0,0,31843,87782848217510,31611,9,31844),
(0,0,31860,87782848217510,31300,31858,31861),
(0,0,31870,87782848217510,31611,10,31871),
(0,0,31878,87782848217510,31611,11,31879),
(0,0,31891,87782848217510,31300,31889,31892),
(0,0,31903,87782848217510,31611,12,31904),
(0,0,31909,87782848217510,31611,13,31910),
(0,0,31940,87782848217510,31300,31938,31941),
(0,0,31964,87782848217510,31489,14,31965),
(0,0,31968,87782848217510,31611,15,31969),
(0,0,31976,87782848217510,31611,16,31977);

--
-- 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,'c55cd032-13cc-01f8-3201-2dd1adce2600','L_CONTROL_PANEL',20113,87782848217510,20096,'2025-01-23 16:29:10.191000',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,'3860af82-75a2-2502-b798-f1759be5f58c','L_FORMS',20116,87782848217510,20096,'2025-01-23 16:29:10.416000',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,'d99628d9-86a4-2099-5ecf-6daeacc62191','L_GUEST',20117,87782848217510,20096,'2025-01-23 16:30:42.641000',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,'770c3909-6da1-3d22-9211-881647ba0dcb','L_USER_PERSONAL_SITE',20119,87782848217510,20096,'2025-01-23 16:29:10.462000',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,'0ad26e7e-415b-26d2-26b4-c573af73e814','0ad26e7e-415b-26d2-26b4-c573af73e814',20120,87782848217510,20096,'2025-01-23 16:29:10.476000',20023,87782848217510,0,0,'/20120/','87782848217510','<?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,'3c95d356-7d6f-b88c-7ba9-c8fb231807a4','3c95d356-7d6f-b88c-7ba9-c8fb231807a4',20125,87782848217510,20123,'2025-01-23 16:29:12.119000',20071,20123,0,0,'/20125/','20123',NULL,NULL,0,'',1,0,'/test',0,0,0,1),
(1,0,'9b01c9a6-9d51-92d6-94d4-5b182b94be02','9b01c9a6-9d51-92d6-94d4-5b182b94be02',20389,87782848217510,20387,'2025-01-23 16:29:19.981000',20071,20387,0,0,'/20389/','20387',NULL,NULL,0,'',1,0,'/default-service-account',0,0,0,1),
(0,0,'861abbe1-25b5-d358-78c1-53f310d3c1a2','861abbe1-25b5-d358-78c1-53f310d3c1a2',31242,87782848217510,20096,'2025-01-23 16:30:35.683000',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,'93b45c5e-4718-f93b-d20e-2e9d35e9d4d8','93b45c5e-4718-f93b-d20e-2e9d35e9d4d8',31715,87782848217510,20096,'2025-01-23 16:30:44.895000',28902,31714,0,0,'/31715/','31714','<?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);

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


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


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


--
-- 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,31648,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.944000','2025-01-23 16:30:43.944000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31647,31643,31645,'approved','approve',NULL,'onEntry','',NULL,NULL,0,'UPDATE_STATUS',0),
(0,0,31666,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.082000','2025-01-23 16:30:44.082000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31665,31643,31645,'update','deny',NULL,'onAssignment','',NULL,NULL,1,'UPDATE_STATUS',4),
(0,0,31667,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.082000','2025-01-23 16:30:44.082000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31665,31643,31645,'update','pending',NULL,'onAssignment','',NULL,NULL,2,'UPDATE_STATUS',1),
(0,0,31681,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.823000','2025-01-23 16:30:44.823000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31680,31678,31679,'approved','approve',NULL,'onEntry','',NULL,NULL,0,'UPDATE_STATUS',0),
(0,0,31704,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.856000','2025-01-23 16:30:44.856000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31703,31678,31679,'update','deny',NULL,'onAssignment','',NULL,NULL,1,'UPDATE_STATUS',4),
(0,0,31705,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.857000','2025-01-23 16:30:44.857000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31703,31678,31679,'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,31650,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.969000','2025-01-23 16:30:43.969000',31643,31645,31649,'\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,31643,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.858000','2025-01-23 16:30:44.145000','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,31678,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.793000','2025-01-23 16:30:44.871000','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,31645,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.894000','2025-01-23 16:30:44.152000',31643,'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',31651,0,20096,NULL,'2025-01-23 16:30:43.894000'),
(1,0,31679,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.800000','2025-01-23 16:30:44.873000',31678,'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',31682,0,20096,NULL,'2025-01-23 16:30:44.800000');

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

CREATE TABLE `KaleoNode` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoNodeId` 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,
  `name` varchar(200) DEFAULT NULL,
  `label` longtext DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `type_` varchar(20) DEFAULT NULL,
  `initial_` tinyint(4) DEFAULT NULL,
  `terminal` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`kaleoNodeId`,`ctCollectionId`),
  KEY `IX_4B1D16B4` (`companyId`,`kaleoDefinitionVersionId`),
  KEY `IX_F066921C` (`kaleoDefinitionVersionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoNode`
--

INSERT INTO `KaleoNode` VALUES
(0,0,31647,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.937000','2025-01-23 16:30:43.937000',31643,31645,'approved',NULL,'{ \"terminal\": true, \"xy\": [ 648, 50 ] }',NULL,'STATE',0,1),
(0,0,31649,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.964000','2025-01-23 16:30:43.964000',31643,31645,'check-reputation',NULL,'{ \"xy\": [ 199, 43 ] }',NULL,'CONDITION',0,0),
(0,0,31651,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.980000','2025-01-23 16:30:43.980000',31643,31645,'created',NULL,'{ \"xy\": [ 36, 51 ] }',NULL,'STATE',1,0),
(0,0,31652,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.983000','2025-01-23 16:30:43.983000',31643,31645,'review',NULL,'{ \"xy\": [ 285, 186 ] }',NULL,'TASK',0,0),
(0,0,31665,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.082000','2025-01-23 16:30:44.082000',31643,31645,'update',NULL,'{ \"transitions\": { \"resubmit\": { \"bendpoints\": [ [ 303, 140 ] ] } }, \"xy\": [ 636, 245 ] }',NULL,'TASK',0,0),
(0,0,31680,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.815000','2025-01-23 16:30:44.815000',31678,31679,'approved',NULL,'{ \"terminal\": true, \"xy\": [ 539, 74 ] }',NULL,'STATE',0,1),
(0,0,31682,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.825000','2025-01-23 16:30:44.825000',31678,31679,'created',NULL,'{ \"xy\": [ 165, 76 ] }',NULL,'STATE',1,0),
(0,0,31683,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.828000','2025-01-23 16:30:44.828000',31678,31679,'review',NULL,'{ \"xy\": [ 165, 292 ] }',NULL,'TASK',0,0),
(0,0,31703,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.856000','2025-01-23 16:30:44.856000',31678,31679,'update',NULL,'{ \"transitions\": { \"resubmit\": { \"bendpoints\": [ [ 303, 140 ] ] } }, \"xy\": [ 164, 533 ] }',NULL,'TASK',0,0);

--
-- Table structure for table `KaleoNotification`
--

CREATE TABLE `KaleoNotification` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoNotificationId` 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,
  `template` longtext DEFAULT NULL,
  `templateLanguage` varchar(75) DEFAULT NULL,
  `notificationTypes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kaleoNotificationId`,`ctCollectionId`),
  KEY `IX_38829497` (`companyId`),
  KEY `IX_F3362E93` (`kaleoClassName`,`kaleoClassPK`,`executionType`),
  KEY `IX_B8486585` (`kaleoDefinitionVersionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoNotification`
--

INSERT INTO `KaleoNotification` VALUES
(0,0,31653,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.984000','2025-01-23 16:30:43.984000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31652,31643,31645,'review','Review Notification','${userName} has sent you a ${entryType} for review','onAssignment','${userName} has sent you a ${entryType} for review in the workflow.','freemarker','user-notification,email'),
(0,0,31655,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.001000','2025-01-23 16:30:44.001000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31652,31643,31645,'review','Review Completion Notification','Your submission was reviewed by ${userName}.','onExit','Your submission was reviewed by ${userName}<#if taskComments?has_content> with the following comments: \"${taskComments}\"</#if>.','freemarker','email'),
(0,0,31668,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.082000','2025-01-23 16:30:44.082000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31665,31643,31645,'update','Creator Modification Notification','Your submission was rejected by ${userName}.','onAssignment','Your submission was rejected by ${userName}, please modify and resubmit.','freemarker','user-notification,email'),
(0,0,31684,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.828000','2025-01-23 16:30:44.828000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31683,31678,31679,'review','Review Notification',NULL,'onAssignment','${userName} sent you a ${entryType} for review in the workflow.','freemarker','user-notification,email'),
(0,0,31686,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.829000','2025-01-23 16:30:44.829000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31683,31678,31679,'review','Review Completion Notification',NULL,'onExit','Your submission was reviewed<#if taskComments?has_content> and the reviewer applied the following ${taskComments}</#if>.','freemarker','email'),
(0,0,31706,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.857000','2025-01-23 16:30:44.857000','com.liferay.portal.workflow.kaleo.model.KaleoNode',31703,31678,31679,'update','Creator Modification Notification',NULL,'onAssignment','Your submission was rejected by ${userName}, please modify and resubmit.','freemarker','user-notification,email');

--
-- Table structure for table `KaleoNotificationRecipient`
--

CREATE TABLE `KaleoNotificationRecipient` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoNotificationRecipientId` 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,
  `kaleoNotificationId` bigint(20) DEFAULT NULL,
  `recipientClassName` varchar(200) DEFAULT NULL,
  `recipientClassPK` bigint(20) DEFAULT NULL,
  `recipientRoleType` int(11) DEFAULT NULL,
  `recipientScript` longtext DEFAULT NULL,
  `recipientScriptLanguage` varchar(75) DEFAULT NULL,
  `recipientScriptContexts` longtext DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `notificationReceptionType` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`kaleoNotificationRecipientId`,`ctCollectionId`),
  KEY `IX_2C8C4AF4` (`companyId`),
  KEY `IX_B6D98988` (`kaleoDefinitionVersionId`),
  KEY `IX_7F4FED02` (`kaleoNotificationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoNotificationRecipient`
--

INSERT INTO `KaleoNotificationRecipient` VALUES
(0,0,31654,0,87782848217510,20096,NULL,'2025-01-23 16:30:43.995000','2025-01-23 16:30:43.995000',31643,31645,31653,'assignees',0,0,'',NULL,NULL,NULL,'to'),
(0,0,31656,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.001000','2025-01-23 16:30:44.001000',31643,31645,31655,'com.liferay.portal.kernel.model.User',0,0,'',NULL,NULL,NULL,'to'),
(0,0,31669,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.083000','2025-01-23 16:30:44.083000',31643,31645,31668,'com.liferay.portal.kernel.model.User',0,0,'',NULL,NULL,NULL,'to'),
(0,0,31685,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.828000','2025-01-23 16:30:44.828000',31678,31679,31684,'assignees',0,0,'',NULL,NULL,NULL,'to'),
(0,0,31687,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.829000','2025-01-23 16:30:44.829000',31678,31679,31686,'com.liferay.portal.kernel.model.User',0,0,'',NULL,NULL,NULL,'to'),
(0,0,31707,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.857000','2025-01-23 16:30:44.857000',31678,31679,31706,'com.liferay.portal.kernel.model.User',0,0,'',NULL,NULL,NULL,'to');

--
-- Table structure for table `KaleoTask`
--

CREATE TABLE `KaleoTask` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskId` 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,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskId`,`ctCollectionId`),
  KEY `IX_E1F8B23D` (`companyId`),
  KEY `IX_FECA871F` (`kaleoDefinitionVersionId`),
  KEY `IX_77B3F1A2` (`kaleoNodeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTask`
--

INSERT INTO `KaleoTask` VALUES
(0,0,31657,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.016000','2025-01-23 16:30:44.016000',31643,31645,31652,'review',NULL),
(0,0,31670,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.093000','2025-01-23 16:30:44.093000',31643,31645,31665,'update',NULL),
(0,0,31688,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.835000','2025-01-23 16:30:44.835000',31678,31679,31683,'review',NULL),
(0,0,31708,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.863000','2025-01-23 16:30:44.863000',31678,31679,31703,'update',NULL);

--
-- Table structure for table `KaleoTaskAssignment`
--

CREATE TABLE `KaleoTaskAssignment` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskAssignmentId` 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,
  `kaleoNodeId` bigint(20) DEFAULT NULL,
  `assigneeClassName` varchar(200) DEFAULT NULL,
  `assigneeClassPK` bigint(20) DEFAULT NULL,
  `assigneeActionId` varchar(75) DEFAULT NULL,
  `assigneeScript` longtext DEFAULT NULL,
  `assigneeScriptLanguage` varchar(75) DEFAULT NULL,
  `assigneeScriptRequiredContexts` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskAssignmentId`,`ctCollectionId`),
  KEY `IX_611732B0` (`companyId`),
  KEY `IX_1087068E` (`kaleoClassName`,`kaleoClassPK`,`assigneeClassName`),
  KEY `IX_E362B24C` (`kaleoDefinitionVersionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTaskAssignment`
--

INSERT INTO `KaleoTaskAssignment` VALUES
(0,0,31658,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.023000','2025-01-23 16:30:44.023000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31657,31643,31645,0,'com.liferay.portal.kernel.model.Role',31659,NULL,'',NULL,NULL),
(0,0,31660,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.057000','2025-01-23 16:30:44.057000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31657,31643,31645,0,'com.liferay.portal.kernel.model.Role',20384,NULL,'',NULL,NULL),
(0,0,31661,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.060000','2025-01-23 16:30:44.060000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31657,31643,31645,0,'com.liferay.portal.kernel.model.Role',31662,NULL,'',NULL,NULL),
(0,0,31663,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.067000','2025-01-23 16:30:44.067000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31657,31643,31645,0,'com.liferay.portal.kernel.model.Role',31664,NULL,'',NULL,NULL),
(0,0,31671,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.100000','2025-01-23 16:30:44.100000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31670,31643,31645,0,'com.liferay.portal.kernel.model.User',0,NULL,'',NULL,NULL),
(0,0,31689,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.835000','2025-01-23 16:30:44.835000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20108,NULL,'',NULL,NULL),
(0,0,31690,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.837000','2025-01-23 16:30:44.837000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',31659,NULL,'',NULL,NULL),
(0,0,31691,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.837000','2025-01-23 16:30:44.837000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',28715,NULL,'',NULL,NULL),
(0,0,31692,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.837000','2025-01-23 16:30:44.837000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20382,NULL,'',NULL,NULL),
(0,0,31693,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.839000','2025-01-23 16:30:44.839000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',31664,NULL,'',NULL,NULL),
(0,0,31694,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.839000','2025-01-23 16:30:44.839000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20112,NULL,'',NULL,NULL),
(0,0,31695,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.843000','2025-01-23 16:30:44.843000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',30040,NULL,'',NULL,NULL),
(0,0,31696,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.844000','2025-01-23 16:30:44.844000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20110,NULL,'',NULL,NULL),
(0,0,31697,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.845000','2025-01-23 16:30:44.845000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',28718,NULL,'',NULL,NULL),
(0,0,31698,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.845000','2025-01-23 16:30:44.845000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20384,NULL,'',NULL,NULL),
(0,0,31699,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.845000','2025-01-23 16:30:44.845000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',31662,NULL,'',NULL,NULL),
(0,0,31700,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.846000','2025-01-23 16:30:44.846000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20107,NULL,'',NULL,NULL),
(0,0,31701,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.848000','2025-01-23 16:30:44.848000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20386,NULL,'',NULL,NULL),
(0,0,31702,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.853000','2025-01-23 16:30:44.853000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31688,31678,31679,0,'com.liferay.portal.kernel.model.Role',20100,NULL,'',NULL,NULL),
(0,0,31709,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.864000','2025-01-23 16:30:44.864000','com.liferay.portal.workflow.kaleo.model.KaleoTask',31708,31678,31679,0,'com.liferay.portal.kernel.model.User',0,NULL,'',NULL,NULL);

--
-- Table structure for table `KaleoTaskAssignmentInstance`
--

CREATE TABLE `KaleoTaskAssignmentInstance` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskAssignmentInstanceId` 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,
  `kaleoInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoTaskInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoTaskId` bigint(20) DEFAULT NULL,
  `kaleoTaskName` varchar(200) DEFAULT NULL,
  `assigneeClassName` varchar(200) DEFAULT NULL,
  `assigneeClassPK` bigint(20) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskAssignmentInstanceId`,`ctCollectionId`),
  KEY `IX_3BD436FD` (`assigneeClassName`,`assigneeClassPK`),
  KEY `IX_3E60C5A5` (`assigneeClassName`,`kaleoTaskInstanceTokenId`),
  KEY `IX_F6042803` (`assigneeClassPK`,`groupId`),
  KEY `IX_6E3CDA1B` (`companyId`),
  KEY `IX_B751E781` (`kaleoDefinitionVersionId`),
  KEY `IX_67A9EE93` (`kaleoInstanceId`),
  KEY `IX_D4C2235B` (`kaleoTaskInstanceTokenId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTaskAssignmentInstance`
--


--
-- Table structure for table `KaleoTaskForm`
--

CREATE TABLE `KaleoTaskForm` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskFormId` 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,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoNodeId` bigint(20) DEFAULT NULL,
  `kaleoTaskId` bigint(20) DEFAULT NULL,
  `kaleoTaskName` varchar(200) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `formCompanyId` bigint(20) DEFAULT NULL,
  `formDefinition` longtext DEFAULT NULL,
  `formGroupId` bigint(20) DEFAULT NULL,
  `formId` bigint(20) DEFAULT NULL,
  `formUuid` varchar(75) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskFormId`,`ctCollectionId`),
  KEY `IX_EFDA7E59` (`companyId`),
  KEY `IX_3B8B7F83` (`kaleoDefinitionVersionId`),
  KEY `IX_945326BE` (`kaleoNodeId`),
  KEY `IX_E38A5954` (`kaleoTaskId`,`formUuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTaskForm`
--


--
-- Table structure for table `KaleoTaskFormInstance`
--

CREATE TABLE `KaleoTaskFormInstance` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskFormInstanceId` 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,
  `kaleoDefinitionId` bigint(20) DEFAULT NULL,
  `kaleoDefinitionVersionId` bigint(20) DEFAULT NULL,
  `kaleoInstanceId` bigint(20) DEFAULT NULL,
  `kaleoTaskId` bigint(20) DEFAULT NULL,
  `kaleoTaskInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoTaskFormId` bigint(20) DEFAULT NULL,
  `formValues` longtext DEFAULT NULL,
  `formValueEntryGroupId` bigint(20) DEFAULT NULL,
  `formValueEntryId` bigint(20) DEFAULT NULL,
  `formValueEntryUuid` varchar(75) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskFormInstanceId`,`ctCollectionId`),
  KEY `IX_77B26CC4` (`companyId`),
  KEY `IX_F118DB8` (`kaleoDefinitionVersionId`),
  KEY `IX_FF271E7C` (`kaleoInstanceId`),
  KEY `IX_E7F42BD0` (`kaleoTaskFormId`),
  KEY `IX_2A86346C` (`kaleoTaskId`),
  KEY `IX_2C81C992` (`kaleoTaskInstanceTokenId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTaskFormInstance`
--


--
-- Table structure for table `KaleoTaskInstanceToken`
--

CREATE TABLE `KaleoTaskInstanceToken` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTaskInstanceTokenId` 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,
  `kaleoInstanceTokenId` bigint(20) DEFAULT NULL,
  `kaleoTaskId` bigint(20) DEFAULT NULL,
  `kaleoTaskName` varchar(200) DEFAULT NULL,
  `className` varchar(200) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `completionUserId` bigint(20) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  `dueDate` datetime(6) DEFAULT NULL,
  `workflowContext` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoTaskInstanceTokenId`,`ctCollectionId`),
  KEY `IX_A3271995` (`className`,`classPK`),
  KEY `IX_4B55EBE` (`companyId`,`userId`,`completed`),
  KEY `IX_B2822979` (`kaleoDefinitionVersionId`),
  KEY `IX_B857A115` (`kaleoInstanceId`,`kaleoTaskId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTaskInstanceToken`
--


--
-- Table structure for table `KaleoTimer`
--

CREATE TABLE `KaleoTimer` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTimerId` 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,
  `name` varchar(75) DEFAULT NULL,
  `blocking` tinyint(4) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `duration` double DEFAULT NULL,
  `scale` varchar(75) DEFAULT NULL,
  `recurrenceDuration` double DEFAULT NULL,
  `recurrenceScale` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`kaleoTimerId`,`ctCollectionId`),
  KEY `IX_1A479F32` (`kaleoClassName`,`kaleoClassPK`,`blocking`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTimer`
--


--
-- Table structure for table `KaleoTimerInstanceToken`
--

CREATE TABLE `KaleoTimerInstanceToken` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTimerInstanceTokenId` 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,
  `kaleoTimerId` bigint(20) DEFAULT NULL,
  `kaleoTimerName` varchar(200) DEFAULT NULL,
  `blocking` tinyint(4) DEFAULT NULL,
  `completionUserId` bigint(20) DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  `workflowContext` longtext DEFAULT NULL,
  PRIMARY KEY (`kaleoTimerInstanceTokenId`,`ctCollectionId`),
  KEY `IX_DB96C55B` (`kaleoInstanceId`),
  KEY `IX_9932524C` (`kaleoInstanceTokenId`,`completed`,`blocking`),
  KEY `IX_13A5BA2C` (`kaleoInstanceTokenId`,`kaleoTimerId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTimerInstanceToken`
--


--
-- Table structure for table `KaleoTransition`
--

CREATE TABLE `KaleoTransition` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `kaleoTransitionId` 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,
  `name` varchar(200) DEFAULT NULL,
  `label` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `sourceKaleoNodeId` bigint(20) DEFAULT NULL,
  `sourceKaleoNodeName` varchar(200) DEFAULT NULL,
  `targetKaleoNodeId` bigint(20) DEFAULT NULL,
  `targetKaleoNodeName` varchar(200) DEFAULT NULL,
  `defaultTransition` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`kaleoTransitionId`,`ctCollectionId`),
  KEY `IX_41D6C6D` (`companyId`),
  KEY `IX_16B426EF` (`kaleoDefinitionVersionId`),
  KEY `IX_A38E2194` (`kaleoNodeId`,`defaultTransition`),
  KEY `IX_85268A11` (`kaleoNodeId`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `KaleoTransition`
--

INSERT INTO `KaleoTransition` VALUES
(0,0,31672,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.110000','2025-01-23 16:30:44.110000',31643,31645,31649,'approve',NULL,NULL,31649,'check-reputation',31647,'approved',1),
(0,0,31673,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.121000','2025-01-23 16:30:44.121000',31643,31645,31649,'review',NULL,NULL,31649,'check-reputation',31652,'review',0),
(0,0,31674,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.136000','2025-01-23 16:30:44.136000',31643,31645,31651,'check-reputation',NULL,NULL,31651,'created',31649,'check-reputation',1),
(0,0,31675,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.138000','2025-01-23 16:30:44.138000',31643,31645,31652,'approve',NULL,NULL,31652,'review',31647,'approved',1),
(0,0,31676,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.140000','2025-01-23 16:30:44.140000',31643,31645,31652,'reject',NULL,NULL,31652,'review',31665,'update',0),
(0,0,31677,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.144000','2025-01-23 16:30:44.144000',31643,31645,31665,'resubmit',NULL,NULL,31665,'update',31652,'review',1),
(0,0,31710,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.865000','2025-01-23 16:30:44.865000',31678,31679,31682,'review',NULL,NULL,31682,'created',31683,'review',1),
(0,0,31711,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.866000','2025-01-23 16:30:44.866000',31678,31679,31683,'approve',NULL,NULL,31683,'review',31680,'approved',1),
(0,0,31712,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.868000','2025-01-23 16:30:44.868000',31678,31679,31683,'reject',NULL,NULL,31683,'review',31703,'update',0),
(0,0,31713,0,87782848217510,20096,NULL,'2025-01-23 16:30:44.870000','2025-01-23 16:30:44.870000',31678,31679,31703,'resubmit',NULL,NULL,31703,'update',31683,'review',1);

--
-- Table structure for table `Layout`
--

CREATE TABLE `Layout` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `plid` 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,
  `parentPlid` bigint(20) DEFAULT NULL,
  `privateLayout` tinyint(4) DEFAULT NULL,
  `layoutId` bigint(20) DEFAULT NULL,
  `parentLayoutId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `keywords` longtext DEFAULT NULL,
  `robots` longtext DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `hidden_` tinyint(4) DEFAULT NULL,
  `system_` tinyint(4) DEFAULT NULL,
  `friendlyURL` varchar(255) DEFAULT NULL,
  `iconImageId` bigint(20) DEFAULT NULL,
  `themeId` varchar(75) DEFAULT NULL,
  `colorSchemeId` varchar(75) DEFAULT NULL,
  `styleBookEntryId` bigint(20) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `faviconFileEntryId` bigint(20) DEFAULT NULL,
  `masterLayoutPlid` bigint(20) DEFAULT NULL,
  `layoutPrototypeUuid` varchar(75) DEFAULT NULL,
  `layoutPrototypeLinkEnabled` tinyint(4) DEFAULT NULL,
  `sourcePrototypeLayoutUuid` varchar(75) DEFAULT NULL,
  `publishDate` 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 (`plid`,`ctCollectionId`),
  UNIQUE KEY `IX_E81EADC5` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_502B1A93` (`groupId`,`privateLayout`,`ctCollectionId`,`friendlyURL`),
  UNIQUE KEY `IX_4FBF955A` (`groupId`,`privateLayout`,`ctCollectionId`,`layoutId`),
  UNIQUE KEY `IX_18646B93` (`groupId`,`privateLayout`,`ctCollectionId`,`uuid_`),
  KEY `IX_B8E1E6E5` (`classNameId`,`classPK`),
  KEY `IX_881EABCB` (`companyId`,`layoutPrototypeUuid`),
  KEY `IX_993CBA31` (`groupId`,`masterLayoutPlid`),
  KEY `IX_7DAA999F` (`groupId`,`privateLayout`,`parentLayoutId`,`hidden_`),
  KEY `IX_7399B71E` (`groupId`,`privateLayout`,`parentLayoutId`,`priority`),
  KEY `IX_8F78BAFA` (`groupId`,`privateLayout`,`parentLayoutId`,`system_`),
  KEY `IX_8CE8C0D9` (`groupId`,`privateLayout`,`sourcePrototypeLayoutUuid`),
  KEY `IX_A0364689` (`groupId`,`privateLayout`,`status`),
  KEY `IX_1A1B61D2` (`groupId`,`privateLayout`,`type_`),
  KEY `IX_6EDC627B` (`groupId`,`type_`),
  KEY `IX_23922F7D` (`iconImageId`),
  KEY `IX_B529BFD3` (`layoutPrototypeUuid`),
  KEY `IX_1D4DCAA5` (`parentPlid`),
  KEY `IX_3BC009C0` (`privateLayout`,`iconImageId`),
  KEY `IX_39A18ECC` (`sourcePrototypeLayoutUuid`),
  KEY `IX_D0822724` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Layout`
--

INSERT INTO `Layout` VALUES
(0,0,'71d2d38f-a899-5c9c-3e5c-03f8ff327c4d','71d2d38f-a899-5c9c-3e5c-03f8ff327c4d',1,20113,87782848217510,20096,NULL,'2025-01-23 16:29:10.255000','2025-01-23 16:29:10.255000',0,1,1,0,0,0,'<?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,NULL,'control_panel','privateLayout=true\n',0,0,'/manage',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:29:10.255000',NULL,0,20096,NULL,'2025-01-23 16:29:10.255000'),
(0,0,'aac6a130-8b4c-5c17-262c-31f37f63fe4f','aac6a130-8b4c-5c17-262c-31f37f63fe4f',2,20116,87782848217510,20096,NULL,'2025-01-23 16:29:58.023000','2025-01-23 16:29:58.023000',0,0,1,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Shared</Name></root>','','',NULL,NULL,'com_liferay_dynamic_data_mapping_form_web_portlet_DDMFormPortlet','layoutUpdateable=false\n',1,0,'/shared',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:29:58.023000',NULL,0,20096,NULL,'2025-01-23 16:29:58.023000'),
(0,0,'d64f2add-99dd-3cb4-b901-4233ad5e59c8','d64f2add-99dd-3cb4-b901-4233ad5e59c8',3,20116,87782848217510,20096,NULL,'2025-01-23 16:29:58.262000','2025-01-23 16:29:58.262000',0,1,1,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Shared</Name></root>','','',NULL,NULL,'com_liferay_dynamic_data_mapping_form_web_portlet_DDMFormPortlet','layoutUpdateable=false\nprivateLayout=true\n',1,0,'/shared',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:29:58.262000',NULL,0,20096,NULL,'2025-01-23 16:29:58.262000'),
(22,0,'dbf24c2c-a0de-5f33-c4d2-e63a73a64438','dbf24c2c-a0de-5f33-c4d2-e63a73a64438',4,31242,87782848217510,20096,NULL,'2025-01-23 16:30:37.211000','2025-01-23 16:30:41.947000',0,1,1,0,0,0,'<?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,NULL,'portlet','column-1=com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_suggestions_portlet_SuggestionsPortlet_INSTANCE_juAz5utRDEqd,\ncolumn-2=com_liferay_portal_search_web_site_facet_portlet_SiteFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_type_facet_portlet_TypeFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_tag_facet_portlet_TagFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_category_facet_portlet_CategoryFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_folder_facet_portlet_FolderFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_user_facet_portlet_UserFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_modified_facet_portlet_ModifiedFacetPortlet_INSTANCE_juAz5utRDEqd,\ncolumn-3=com_liferay_portal_search_web_search_results_portlet_SearchResultsPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_search_options_portlet_SearchOptionsPortlet_INSTANCE_juAz5utRDEqd,\nlayout-template-id=1_2_columns_i\nprivateLayout=true\n',0,0,'/layout',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:30:37.211000',NULL,0,20096,NULL,'2025-01-23 16:30:37.211000'),
(12,0,'dc67a1be-dcd2-4fb9-7563-22abb4f5d2e1','dc67a1be-dcd2-4fb9-7563-22abb4f5d2e1',5,20117,87782848217510,20096,NULL,'2025-01-23 16:30:42.016000','2025-01-23 16:30:47.437000',0,0,1,0,0,0,'<?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=\"en_US\">Search</Name><Name language-id=\"ar_SA\">البحث</Name><Name language-id=\"ca_ES\">Cerca</Name><Name language-id=\"zh_CN\">搜索</Name><Name language-id=\"nl_NL\">Zoeken</Name><Name language-id=\"fi_FI\">Haku</Name><Name language-id=\"fr_FR\">Rechercher</Name><Name language-id=\"de_DE\">Suche</Name><Name language-id=\"hu_HU\">Keresés</Name><Name language-id=\"ja_JP\">検索</Name><Name language-id=\"pt_BR\">Busca</Name><Name language-id=\"es_ES\">Búsqueda</Name><Name language-id=\"sv_SE\">Sök</Name></root>','','<?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\"><Description language-id=\"en_US\">Display search results with a default set of facets.</Description><Description language-id=\"ar_SA\">اعرض نتائج البحث مع مجموعة افتراضية من الواجهات.</Description><Description language-id=\"ca_ES\">Mostra els resultats de cerca amb un conjunt de facetes predeterminades.</Description><Description language-id=\"zh_CN\">通过默认Facet集显示搜索结果。</Description><Description language-id=\"nl_NL\">Zoekresultaten met een standaard facettenset weergeven.</Description><Description language-id=\"fi_FI\">Näytä hakutulokset oletusfacettisarjalla.</Description><Description language-id=\"fr_FR\">Afficher les résultats de recherche avec un jeu de facettes par défaut.</Description><Description language-id=\"de_DE\">Suchergebnisse mit einem standardmäßigen Facettenset anzeigen.</Description><Description language-id=\"hu_HU\">Megjeleníti a keresési eredményeket az alapértelmezett fazettakészlettel.</Description><Description language-id=\"ja_JP\">ファセットの既定のセットで検索結果を表示します。</Description><Description language-id=\"pt_BR\">Exibir resultados de pesquisa com um conjunto de facetas padrão.</Description><Description language-id=\"es_ES\">Mostrar resultados de la búsqueda con un conjunto por defecto de facetas.</Description><Description language-id=\"sv_SE\">Visa sökresultat med en standarduppsättning av fasetter.</Description></root>',NULL,NULL,'portlet','column-1=com_liferay_portal_search_web_search_bar_portlet_SearchBarPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_suggestions_portlet_SuggestionsPortlet_INSTANCE_juAz5utRDEqd,\ncolumn-2=com_liferay_portal_search_web_site_facet_portlet_SiteFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_type_facet_portlet_TypeFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_tag_facet_portlet_TagFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_category_facet_portlet_CategoryFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_folder_facet_portlet_FolderFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_user_facet_portlet_UserFacetPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_modified_facet_portlet_ModifiedFacetPortlet_INSTANCE_juAz5utRDEqd,\ncolumn-3=com_liferay_portal_search_web_search_results_portlet_SearchResultsPortlet_INSTANCE_juAz5utRDEqd,com_liferay_portal_search_web_search_options_portlet_SearchOptionsPortlet_INSTANCE_juAz5utRDEqd,\nlast-merge-time=1737649842497\nlayout-template-id=1_2_columns_i\nprivateLayout=true\n',1,0,'/search',0,NULL,NULL,0,'',1,0,0,'f630031c-35db-cfff-7882-19bb374826da',0,NULL,'2025-01-23 16:30:42.016000',NULL,0,20096,NULL,'2025-01-23 16:30:42.016000'),
(4,0,'c8d56765-c38f-4e16-e91d-ecaf90f45162','c8d56765-c38f-4e16-e91d-ecaf90f45162',6,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:46.861000','2025-01-23 16:30:56.216000',0,0,2,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Home</Name></root>','','',NULL,NULL,'content','',0,0,'/home',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:30:46.861000',NULL,0,20123,'Test Test','2025-01-23 16:30:55.270000'),
(3,0,'fc179a0e-c7cc-66b6-05f7-4c72b87b4356','fc179a0e-c7cc-66b6-05f7-4c72b87b4356',7,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:47.120000','2025-01-23 16:30:56.170000',0,0,3,0,20031,6,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Home</Name></root>','','',NULL,NULL,'content','published=true\n',1,1,'/4ccb9648-0e40-40c1-f24c-0f4aeb32f844',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:30:46.861000',NULL,0,20123,'Test Test','2025-01-23 16:30:55.270000'),
(3,0,'dbed5e69-6e9a-3093-1479-806daec3fcb5','dbed5e69-6e9a-3093-1479-806daec3fcb5',8,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:52.897000','2025-01-23 16:30:54.468000',0,0,4,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">404</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">404</Title></root>','',NULL,NULL,'utility','lfr-theme:regular:show-footer=false\nlfr-theme:regular:show-header=false\n',1,1,'/0928132a-b011-6a1c-5d57-9c624330b3a1',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:46.861000',NULL,0,20123,'Test Test','2025-01-23 16:30:52.897000'),
(1,0,'f20e3cb8-483b-55a8-a9aa-287b41699441','f20e3cb8-483b-55a8-a9aa-287b41699441',9,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:52.932000','2025-01-23 16:30:54.454000',0,0,5,0,20031,8,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">404</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">404</Title></root>','',NULL,NULL,'utility','lfr-theme:regular:show-footer=false\nlfr-theme:regular:show-header=false\npublished=true\n',1,1,'/8a733320-411f-1f70-4060-16e6aec7a51b',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:52.897000',NULL,0,20123,'Test Test','2025-01-23 16:30:52.897000'),
(2,0,'cd4f4eed-9e40-ba92-63f0-0688968d3585','cd4f4eed-9e40-ba92-63f0-0688968d3585',10,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.779000','2025-01-23 16:30:55.093000',0,0,6,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">500</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">500</Title></root>','',NULL,NULL,'utility','lfr-theme:regular:show-footer=false\nlfr-theme:regular:show-header=false\n',1,1,'/6734c2bb-5c1e-d7e6-0b88-b60ba9595805',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:52.897000',NULL,0,20123,'Test Test','2025-01-23 16:30:54.779000'),
(1,0,'0e99029d-a25d-ebd2-6f35-81c3dc5fdc52','0e99029d-a25d-ebd2-6f35-81c3dc5fdc52',11,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:54.849000','2025-01-23 16:30:55.084000',0,0,7,0,20031,10,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">500</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">500</Title></root>','',NULL,NULL,'utility','lfr-theme:regular:show-footer=false\nlfr-theme:regular:show-header=false\npublished=true\n',1,1,'/25a02548-3d06-db51-459b-253287f0ff91',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:54.779000',NULL,0,20123,'Test Test','2025-01-23 16:30:54.779000'),
(2,0,'9ea3b661-011b-f198-4771-893888c0215a','9ea3b661-011b-f198-4771-893888c0215a',12,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.270000','2025-01-23 16:30:55.720000',0,0,8,0,0,0,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Cookie Policy</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">Cookie Policy</Title></root>','',NULL,NULL,'utility','',1,1,'/989ecf72-3e6c-73cd-6576-916e8382678b',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:54.779000',NULL,0,20123,'Test Test','2025-01-23 16:30:55.270000'),
(1,0,'d6fdf148-7c9f-8d92-c100-79a7f1f342d9','d6fdf148-7c9f-8d92-c100-79a7f1f342d9',13,20117,87782848217510,20123,'Test Test','2025-01-23 16:30:55.329000','2025-01-23 16:30:55.717000',0,0,9,0,20031,12,'<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">Cookie Policy</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">Cookie Policy</Title></root>','',NULL,NULL,'utility','published=true\n',1,1,'/54895690-e057-0228-b9ae-cc0e7539d210',0,'classic_WAR_classictheme','01',0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:30:55.270000',NULL,0,20123,'Test Test','2025-01-23 16:30:55.270000'),
(1,0,'54464253-a14a-6ded-e7da-ccb53c55b7ef','54464253-a14a-6ded-e7da-ccb53c55b7ef',14,20125,87782848217510,20123,'Test Test','2025-01-23 16:31:22.317000','2025-01-23 16:31:22.507000',0,1,1,0,0,0,'<?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\">Min instrumentpanel</Name><Name language-id=\"pt_BR\">Meu Painel</Name><Name language-id=\"ja_JP\">マイダッシュボード</Name><Name language-id=\"fr_FR\">Mon tableau de bord</Name><Name language-id=\"hu_HU\">Vezérlőpultom</Name><Name language-id=\"de_DE\">Meine privaten Seiten</Name><Name language-id=\"ca_ES\">El meu quadre de comandament</Name><Name language-id=\"ar_SA\">لوحة المعلومات</Name><Name language-id=\"fi_FI\">Koontinäyttöni</Name><Name language-id=\"en_US\">My Dashboard</Name><Name language-id=\"zh_CN\">我的面板</Name><Name language-id=\"es_ES\">Panel de mando</Name><Name language-id=\"nl_NL\">Mijn dashboard</Name></root>','','',NULL,NULL,'portlet','column-1=com_liferay_site_my_sites_web_portlet_MySitesPortlet,\nlayout-template-id=1_column\nprivateLayout=true\n',0,0,'/home',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:31:22.317000',NULL,0,20123,'Test Test','2025-01-23 16:31:22.317000'),
(1,0,'865cbbf4-09a1-b54c-7551-cb3700f4694b','865cbbf4-09a1-b54c-7551-cb3700f4694b',15,20125,87782848217510,20123,'Test Test','2025-01-23 16:31:22.545000','2025-01-23 16:31:22.703000',0,0,1,0,0,0,'<?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\">Min profil</Name><Name language-id=\"pt_BR\">Meu Perfil</Name><Name language-id=\"ja_JP\">プロフィール</Name><Name language-id=\"fr_FR\">Mon Profil</Name><Name language-id=\"hu_HU\">Saját profil</Name><Name language-id=\"de_DE\">Mein Profil</Name><Name language-id=\"ca_ES\">El meu perfil</Name><Name language-id=\"ar_SA\">اللمحة الرئيسية</Name><Name language-id=\"fi_FI\">Oma profiili</Name><Name language-id=\"en_US\">My Profile</Name><Name language-id=\"zh_CN\">我的个人资料</Name><Name language-id=\"es_ES\">Mi Perfil</Name><Name language-id=\"nl_NL\">Mijn profiel</Name></root>','','',NULL,NULL,'portlet','column-1=com_liferay_contacts_web_portlet_ProfilePortlet_INSTANCE_rg9AnP0RA02x,\nlayout-template-id=1_column\n',0,0,'/home',0,NULL,NULL,0,'',0,0,0,NULL,0,NULL,'2025-01-23 16:31:22.545000',NULL,0,20123,'Test Test','2025-01-23 16:31:22.545000'),
(1,0,'4245b24b-3f62-6911-d073-3ccb634edf66','4245b24b-3f62-6911-d073-3ccb634edf66',16,20117,87782848217510,20096,NULL,'2025-01-23 16:31:52.212000','2025-01-23 16:31:52.259000',0,0,10,0,0,0,'<?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,NULL,'portlet','layout-template-id=1_column_dynamic\n',1,1,'/manage',0,NULL,NULL,0,'',2147483647,0,0,NULL,0,NULL,'2025-01-23 16:31:52.212000',NULL,0,20096,NULL,'2025-01-23 16:31:52.212000');

--
