--
-- Host: localhost    Database: lportal
-- ------------------------------------------------------


--
-- Table structure for table `AMImageEntry`
--

CREATE TABLE `AMImageEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `amImageEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `configurationUuid` varchar(75) DEFAULT NULL,
  `fileVersionId` bigint(20) DEFAULT NULL,
  `mimeType` varchar(75) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `size_` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`amImageEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_EBBEA9CD` (`configurationUuid`,`fileVersionId`,`ctCollectionId`),
  UNIQUE KEY `IX_681D2FFD` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_6DDD0C5F` (`companyId`),
  KEY `IX_51249CB0` (`configurationUuid`,`companyId`),
  KEY `IX_E879919E` (`fileVersionId`),
  KEY `IX_65AB1EA1` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AMImageEntry`
--

INSERT INTO `AMImageEntry` VALUES
(0,0,'a8aac3e3-2351-dca7-ea1b-a1d2695ed09b',31813,20120,64463788232944,'2024-11-21 12:19:43.014000','Preview-1000x0',31804,'image/png',112,112,1658),
(0,0,'2e4e3bb1-4f02-6539-9c08-ad9157bfc79e',31814,20120,64463788232944,'2024-11-21 12:19:43.066000','Thumbnail-300x300',31804,'image/png',112,112,1658),
(0,0,'946212d7-554c-0c75-5e84-e23be4b19f02',31846,20117,64463788232944,'2024-11-21 12:19:45.334000','Preview-1000x0',31832,'image/png',790,1000,85104),
(0,0,'8f38641d-0b03-0926-4d0f-673d7e8ef12c',31857,20117,64463788232944,'2024-11-21 12:19:45.513000','Thumbnail-300x300',31832,'image/png',237,300,13761),
(0,0,'f9be2164-704e-e6f9-bc06-b2ebf28df649',31863,20117,64463788232944,'2024-11-21 12:19:45.766000','Preview-1000x0',31853,'image/png',194,193,9758),
(0,0,'bbe45408-34af-543f-1022-bee4f07a012f',31866,20117,64463788232944,'2024-11-21 12:19:45.828000','Thumbnail-300x300',31853,'image/png',194,193,9758),
(0,0,'442345d6-48f8-26c8-4090-b70a852f8f14',31870,20117,64463788232944,'2024-11-21 12:19:45.965000','Preview-1000x0',31842,'image/png',693,1000,294159),
(0,0,'912f4d2c-2546-1682-0eec-ad1287bb548d',31876,20117,64463788232944,'2024-11-21 12:19:46.162000','Preview-1000x0',31865,'image/png',253,304,14601),
(0,0,'3ea92602-7570-c1c2-0688-ea1496254a09',31879,20117,64463788232944,'2024-11-21 12:19:46.233000','Thumbnail-300x300',31865,'image/png',250,300,34043),
(0,0,'f09d7080-70be-0a45-5483-3a1049523957',31888,20117,64463788232944,'2024-11-21 12:19:46.501000','Thumbnail-300x300',31842,'image/png',208,300,26921),
(0,0,'70d5f17e-ee41-fb59-9d07-19ed54b96e64',31890,20117,64463788232944,'2024-11-21 12:19:46.509000','Preview-1000x0',31878,'image/png',467,466,25116),
(0,0,'71329676-fddb-520d-d4fd-88f16746b009',31895,20117,64463788232944,'2024-11-21 12:19:46.577000','Thumbnail-300x300',31878,'image/png',300,299,32839),
(0,0,'904c5117-0dac-f2e0-f345-35abec74232b',31911,20117,64463788232944,'2024-11-21 12:19:47.217000','Preview-1000x0',31891,'image/png',639,1000,20920),
(0,0,'dab0cd95-0d58-f93b-a324-01591121f76f',31912,20117,64463788232944,'2024-11-21 12:19:47.363000','Thumbnail-300x300',31891,'image/png',192,300,4258),
(0,0,'81a359a1-e96d-c1b8-c5b0-9192da7dcdaa',31913,20117,64463788232944,'2024-11-21 12:19:47.550000','Preview-1000x0',31902,'image/png',582,1000,304821),
(0,0,'83f4db62-f228-ac37-7eee-a00b36787ead',31914,20117,64463788232944,'2024-11-21 12:19:47.665000','Thumbnail-300x300',31902,'image/png',175,300,38987);

--
-- Table structure for table `AccountEntry`
--

CREATE TABLE `AccountEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `accountEntryId` 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,
  `defaultBillingAddressId` bigint(20) DEFAULT NULL,
  `defaultCPaymentMethodKey` varchar(75) DEFAULT NULL,
  `defaultShippingAddressId` bigint(20) DEFAULT NULL,
  `parentAccountEntryId` bigint(20) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `domains` longtext DEFAULT NULL,
  `emailAddress` varchar(254) DEFAULT NULL,
  `logoId` bigint(20) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `restrictMembership` tinyint(4) DEFAULT NULL,
  `taxExemptionCode` varchar(75) DEFAULT NULL,
  `taxIdNumber` varchar(75) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`accountEntryId`),
  UNIQUE KEY `IX_FBFAF640` (`companyId`,`externalReferenceCode`),
  KEY `IX_48CB043` (`companyId`,`status`),
  KEY `IX_908C3410` (`userId`,`type_`),
  KEY `IX_6901A669` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountEntry`
--

INSERT INTO `AccountEntry` VALUES
(3,'aad9b9c0-674d-4fc3-789a-048134a5c4c1','aad9b9c0-674d-4fc3-789a-048134a5c4c1',32503,64463788232944,20123,'Test Test','2024-12-03 11:45:47.897000','2024-12-03 11:45:48.722000',0,NULL,0,0,'Sells rocks.',NULL,NULL,0,'RockSeller',1,NULL,'1','business',0,20123,'Test Test','2024-12-03 11:45:48.708000');

--
-- Table structure for table `AccountEntryOrganizationRel`
--

CREATE TABLE `AccountEntryOrganizationRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `accountEntryOrganizationRelId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `accountEntryId` bigint(20) DEFAULT NULL,
  `organizationId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`accountEntryOrganizationRelId`),
  KEY `IX_EC6CC41D` (`accountEntryId`,`organizationId`),
  KEY `IX_2FA4FA69` (`organizationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountEntryOrganizationRel`
--

INSERT INTO `AccountEntryOrganizationRel` VALUES
(0,32803,64463788232944,32503,32306);

--
-- Table structure for table `AccountEntryUserRel`
--

CREATE TABLE `AccountEntryUserRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `accountEntryUserRelId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `accountEntryId` bigint(20) DEFAULT NULL,
  `accountUserId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`accountEntryUserRelId`),
  KEY `IX_ED720A80` (`accountEntryId`,`accountUserId`),
  KEY `IX_4EA60AB4` (`accountUserId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountEntryUserRel`
--

INSERT INTO `AccountEntryUserRel` VALUES
(0,32608,64463788232944,32503,32603);

--
-- Table structure for table `AccountEntry_x_64463788232944`
--

CREATE TABLE `AccountEntry_x_64463788232944` (
  `accountEntryId` bigint(20) NOT NULL,
  PRIMARY KEY (`accountEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountEntry_x_64463788232944`
--


--
-- Table structure for table `AccountGroup`
--

CREATE TABLE `AccountGroup` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `accountGroupId` 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,
  `defaultAccountGroup` tinyint(4) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`accountGroupId`),
  UNIQUE KEY `IX_F7BFA1CD` (`companyId`,`externalReferenceCode`),
  KEY `IX_38BDB33` (`companyId`,`defaultAccountGroup`),
  KEY `IX_8EE6A92F` (`companyId`,`name`),
  KEY `IX_B4733E65` (`companyId`,`type_`),
  KEY `IX_E86A36FC` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountGroup`
--

INSERT INTO `AccountGroup` VALUES
(0,'ebaa8d4d-a762-dbc5-d216-f8c35fa7f460','ebaa8d4d-a762-dbc5-d216-f8c35fa7f460',28714,64463788232944,20096,NULL,'2024-11-21 12:18:30.288000','2024-11-21 12:18:30.288000',1,'This account group is used for guest users.','Guest',NULL),
(1,'4e18980d-dfbf-9ca1-998d-8d21116fbb8d','4e18980d-dfbf-9ca1-998d-8d21116fbb8d',32703,64463788232944,20123,'Test Test','2024-12-05 12:35:50.359000','2024-12-05 12:35:50.398000',0,NULL,'Rock Seller Managers','static');

--
-- Table structure for table `AccountGroupRel`
--

CREATE TABLE `AccountGroupRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `accountGroupRelId` 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,
  `accountGroupId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`accountGroupRelId`),
  KEY `IX_448835E3` (`accountGroupId`,`classNameId`,`classPK`),
  KEY `IX_E31F0762` (`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountGroupRel`
--

INSERT INTO `AccountGroupRel` VALUES
(0,28715,64463788232944,20096,NULL,'2024-11-21 12:18:30.305000','2024-11-21 12:18:30.305000',28714,28707,-1),
(0,32704,64463788232944,20123,'Test Test','2024-12-05 12:59:52.953000','2024-12-05 12:59:52.953000',32703,28707,32503);

--
-- Table structure for table `AccountRole`
--

CREATE TABLE `AccountRole` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `accountRoleId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `accountEntryId` bigint(20) DEFAULT NULL,
  `roleId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`accountRoleId`),
  KEY `IX_3A47CDD` (`accountEntryId`),
  KEY `IX_6BCBD313` (`companyId`,`accountEntryId`),
  KEY `IX_714A358E` (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AccountRole`
--

INSERT INTO `AccountRole` VALUES
(0,28717,64463788232944,0,28716),
(0,28720,64463788232944,0,28719),
(0,30039,64463788232944,0,30038),
(0,30041,64463788232944,0,30040),
(0,30043,64463788232944,0,30042),
(1,32904,64463788232944,32503,32903);

--
-- Table structure for table `Address`
--

CREATE TABLE `Address` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `addressId` 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,
  `countryId` bigint(20) DEFAULT NULL,
  `listTypeId` bigint(20) DEFAULT NULL,
  `regionId` bigint(20) DEFAULT NULL,
  `city` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `mailing` tinyint(4) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  `street1` varchar(255) DEFAULT NULL,
  `street2` varchar(255) DEFAULT NULL,
  `street3` varchar(255) DEFAULT NULL,
  `validationDate` datetime(6) DEFAULT NULL,
  `validationStatus` int(11) DEFAULT NULL,
  `zip` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`addressId`,`ctCollectionId`),
  UNIQUE KEY `IX_C0F7C08D` (`companyId`,`externalReferenceCode`,`ctCollectionId`),
  KEY `IX_FEAFC68A` (`companyId`,`classNameId`,`classPK`,`listTypeId`),
  KEY `IX_923BD178` (`companyId`,`classNameId`,`classPK`,`mailing`),
  KEY `IX_9226DBB4` (`companyId`,`classNameId`,`classPK`,`primary_`),
  KEY `IX_5A2093E7` (`countryId`),
  KEY `IX_C8E3E87D` (`regionId`),
  KEY `IX_5BC8B0D4` (`userId`),
  KEY `IX_381E55DA` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Address`
--

INSERT INTO `Address` VALUES
(0,0,'16252e97-76c9-864b-bc51-8b9c7e9cacdf','16252e97-76c9-864b-bc51-8b9c7e9cacdf',32906,64463788232944,20123,'Test Test','2024-12-11 13:03:27.970000','2024-12-11 13:03:27.970000',28707,32503,20362,2,6058,'New York','Rock Seller Address',0,0,0,'Rock Seller Address',0,'1234 Mulberry St',NULL,NULL,NULL,0,'40160'),
(0,0,'2eabc807-aa35-7eff-39ae-ef32e9b0ca1e','2eabc807-aa35-7eff-39ae-ef32e9b0ca1e',32914,64463788232944,20123,'Test Test','2024-12-12 12:19:02.097000','2024-12-12 12:19:02.097000',28707,32503,20362,9,0,'New York',NULL,0,0,1,NULL,1,'1234 Mulberry St',NULL,NULL,NULL,0,'12345');

--
-- Table structure for table `Address_x_64463788232944`
--

CREATE TABLE `Address_x_64463788232944` (
  `addressId` bigint(20) NOT NULL,
  PRIMARY KEY (`addressId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Address_x_64463788232944`
--


--
-- Table structure for table `AnalyticsAssociation`
--

CREATE TABLE `AnalyticsAssociation` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `analyticsAssociationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `associationClassName` varchar(75) DEFAULT NULL,
  `associationClassPK` bigint(20) DEFAULT NULL,
  `className` varchar(75) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`analyticsAssociationId`,`ctCollectionId`),
  KEY `IX_F25E6543` (`companyId`,`associationClassName`,`associationClassPK`),
  KEY `IX_6431FFA8` (`companyId`,`associationClassName`,`modifiedDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnalyticsAssociation`
--


--
-- Table structure for table `AnalyticsDeleteMessage`
--

CREATE TABLE `AnalyticsDeleteMessage` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `analyticsDeleteMessageId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `className` varchar(255) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`analyticsDeleteMessageId`,`ctCollectionId`),
  KEY `IX_3BF42B97` (`companyId`,`modifiedDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnalyticsDeleteMessage`
--


--
-- Table structure for table `AnalyticsMessage`
--

CREATE TABLE `AnalyticsMessage` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `analyticsMessageId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `body` longblob DEFAULT NULL,
  PRIMARY KEY (`analyticsMessageId`,`ctCollectionId`),
  KEY `IX_3A69CC81` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnalyticsMessage`
--


--
-- Table structure for table `AnnouncementsDelivery`
--

CREATE TABLE `AnnouncementsDelivery` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `deliveryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `email` tinyint(4) DEFAULT NULL,
  `sms` tinyint(4) DEFAULT NULL,
  `website` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`deliveryId`,`ctCollectionId`),
  UNIQUE KEY `IX_7EA033` (`userId`,`type_`,`ctCollectionId`),
  KEY `IX_37B0A8A2` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnnouncementsDelivery`
--

INSERT INTO `AnnouncementsDelivery` VALUES
(0,0,32101,64463788232944,20123,'general',0,0,1),
(0,0,32102,64463788232944,20123,'news',0,0,1),
(0,0,32103,64463788232944,20123,'test',0,0,1);

--
-- Table structure for table `AnnouncementsEntry`
--

CREATE TABLE `AnnouncementsEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `entryId` 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,
  `title` varchar(75) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `alert` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`entryId`,`ctCollectionId`),
  KEY `IX_14F06A6B` (`classNameId`,`classPK`,`alert`),
  KEY `IX_94C04525` (`classNameId`,`classPK`,`companyId`,`alert`),
  KEY `IX_3F376E7C` (`companyId`),
  KEY `IX_D49C2E66` (`userId`),
  KEY `IX_1AFBDE08` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnnouncementsEntry`
--


--
-- Table structure for table `AnnouncementsFlag`
--

CREATE TABLE `AnnouncementsFlag` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `flagId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `entryId` bigint(20) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`flagId`,`ctCollectionId`),
  KEY `IX_EF1F022A` (`companyId`),
  KEY `IX_ED8CE4E8` (`entryId`,`userId`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AnnouncementsFlag`
--


--
-- Table structure for table `AssetAutoTaggerEntry`
--

CREATE TABLE `AssetAutoTaggerEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `assetAutoTaggerEntryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `assetEntryId` bigint(20) DEFAULT NULL,
  `assetTagId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`assetAutoTaggerEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_50FDB5E7` (`assetEntryId`,`assetTagId`,`ctCollectionId`),
  KEY `IX_10831A78` (`assetTagId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetAutoTaggerEntry`
--


--
-- Table structure for table `AssetCategory`
--

CREATE TABLE `AssetCategory` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `categoryId` 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,
  `parentCategoryId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `vocabularyId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`categoryId`,`ctCollectionId`),
  UNIQUE KEY `IX_F3842169` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_AF94405C` (`groupId`,`uuid_`,`ctCollectionId`),
  UNIQUE KEY `IX_8C99329D` (`vocabularyId`,`parentCategoryId`,`name`,`ctCollectionId`),
  KEY `IX_F67BECAD` (`groupId`,`parentCategoryId`),
  KEY `IX_2710C64A` (`groupId`,`vocabularyId`,`name`),
  KEY `IX_68169942` (`groupId`,`vocabularyId`,`parentCategoryId`),
  KEY `IX_9DDD15EA` (`parentCategoryId`,`name`),
  KEY `IX_4D37BB00` (`uuid_`),
  KEY `IX_3537E488` (`vocabularyId`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetCategory`
--


--
-- Table structure for table `AssetCategoryProperty`
--

CREATE TABLE `AssetCategoryProperty` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `categoryPropertyId` 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,
  `categoryId` bigint(20) DEFAULT NULL,
  `key_` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`categoryPropertyId`,`ctCollectionId`),
  UNIQUE KEY `IX_87C75408` (`categoryId`,`key_`,`ctCollectionId`),
  KEY `IX_52340033` (`companyId`,`key_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetCategoryProperty`
--


--
-- Table structure for table `AssetDisplayPageEntry`
--

CREATE TABLE `AssetDisplayPageEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `assetDisplayPageEntryId` 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,
  `layoutPageTemplateEntryId` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`assetDisplayPageEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_73E15F86` (`groupId`,`ctCollectionId`,`classNameId`,`classPK`),
  UNIQUE KEY `IX_EF42C6CB` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_BFB8A913` (`layoutPageTemplateEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetDisplayPageEntry`
--


--
-- Table structure for table `AssetEntries_AssetTags`
--

CREATE TABLE `AssetEntries_AssetTags` (
  `companyId` bigint(20) NOT NULL,
  `entryId` bigint(20) NOT NULL,
  `tagId` bigint(20) NOT NULL,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctChangeType` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`entryId`,`tagId`,`ctCollectionId`),
  KEY `IX_112337B8` (`companyId`),
  KEY `IX_B2A61B55` (`tagId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetEntries_AssetTags`
--


--
-- Table structure for table `AssetEntry`
--

CREATE TABLE `AssetEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `entryId` 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,
  `classUuid` varchar(75) DEFAULT NULL,
  `classTypeId` bigint(20) DEFAULT NULL,
  `listable` tinyint(4) DEFAULT NULL,
  `visible` tinyint(4) DEFAULT NULL,
  `startDate` datetime(6) DEFAULT NULL,
  `endDate` datetime(6) DEFAULT NULL,
  `publishDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `mimeType` varchar(75) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `summary` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `layoutUuid` varchar(75) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  PRIMARY KEY (`entryId`,`ctCollectionId`),
  UNIQUE KEY `IX_7BF8337B` (`classNameId`,`classPK`,`ctCollectionId`),
  KEY `IX_7306C60` (`companyId`),
  KEY `IX_75D42FF9` (`expirationDate`),
  KEY `IX_6418BB52` (`groupId`,`classNameId`,`publishDate`,`expirationDate`),
  KEY `IX_82C4BEF6` (`groupId`,`classNameId`,`visible`),
  KEY `IX_1EBA6821` (`groupId`,`classUuid`),
  KEY `IX_FEC4A201` (`layoutUuid`),
  KEY `IX_2E4E3885` (`publishDate`),
  KEY `IX_9029E15A` (`visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetEntry`
--

INSERT INTO `AssetEntry` VALUES
(0,0,20115,20113,64463788232944,20096,NULL,'2024-11-21 12:18:03.039000','2024-11-21 12:18:03.039000',20031,1,'b4fb6fdd-b511-4c32-7381-ad93bb44f4a6',0,1,0,NULL,NULL,NULL,NULL,'text/html','Control Panel','','',NULL,NULL,0,0,0),
(1,0,20126,20120,64463788232944,20123,'Test Test','2024-11-21 12:18:04.660000','2024-11-21 12:51:58.166000',20071,20123,'bf7a18dd-9cdf-712b-11c6-2fc2d0dfafd3',0,1,0,NULL,NULL,NULL,NULL,NULL,'Test Test','','',NULL,NULL,0,0,0),
(0,0,20390,20120,64463788232944,20387,'default-service-account default-service-account','2024-11-21 12:18:11.771000','2024-11-21 12:18:11.771000',20071,20387,'34ff2a6f-21bb-c26c-d6ff-e3435402be69',0,1,0,NULL,NULL,NULL,NULL,NULL,'default-service-account default-service-account','','',NULL,NULL,0,0,0),
(0,0,29402,20116,64463788232944,20096,NULL,'2024-11-21 12:18:52.674000','2024-11-21 12:18:52.674000',20031,2,'58fb9b47-f098-c009-04dc-8987229fedd2',0,1,0,NULL,NULL,NULL,NULL,'text/html','Shared','','',NULL,NULL,0,0,0),
(0,0,29404,20116,64463788232944,20096,NULL,'2024-11-21 12:18:52.934000','2024-11-21 12:18:52.934000',20031,3,'4505bc96-fc70-0f7c-95c9-d109634e445d',0,1,0,NULL,NULL,NULL,NULL,'text/html','Shared','','',NULL,NULL,0,0,0),
(0,0,31681,31242,64463788232944,20096,NULL,'2024-11-21 12:19:34.192000','2024-11-21 12:19:34.192000',20031,4,'b82d3539-7b5b-75ba-79db-71e1559b060c',0,1,0,NULL,NULL,NULL,NULL,'text/html','Search','','',NULL,NULL,0,0,0),
(1,0,31698,20117,64463788232944,20096,NULL,'2024-11-21 12:19:39.024000','2024-11-21 12:19:39.528000',20031,5,'5dae60f8-11a7-0582-2889-f64cc3e6c5a1',0,1,0,NULL,NULL,NULL,NULL,'text/html','Search','','',NULL,NULL,0,0,0),
(0,0,31722,20120,64463788232944,20096,NULL,'2024-11-21 12:19:40.068000','2024-11-21 12:19:40.068000',20009,31718,'a555ef51-da9b-b981-4b0e-06d4af69dd19',0,1,0,NULL,NULL,NULL,NULL,'image/png','id-e17b5c49-6792-5953-296f-af0a2b1ff77','','',NULL,NULL,0,0,0),
(1,0,31807,20120,64463788232944,20096,NULL,'2024-11-21 12:19:42.103000','2024-11-21 12:19:42.124000',20009,31803,'3055c450-1c55-a0f1-ac58-0118e30ee5f8',0,1,1,NULL,NULL,'2024-11-21 12:19:42.103000',NULL,'image/png','company_logo.png','','',NULL,NULL,0,0,0),
(1,0,31822,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:43.057000','2024-11-21 12:19:51.507000',20031,6,'c60159ab-86ee-6046-b139-34adc8762820',0,1,0,NULL,NULL,'2024-11-21 12:19:51.507000',NULL,'text/html','Home','','',NULL,NULL,0,0,0),
(1,0,31828,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:43.372000','2024-11-21 12:19:51.507000',20031,7,'592bece0-834f-4733-f1fa-e8b6423fa33b',0,1,0,NULL,NULL,'2024-11-21 12:19:51.507000',NULL,'text/html','Home','','',NULL,NULL,0,0,0),
(0,0,31830,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:44.576000','2024-11-21 12:19:44.576000',20014,31829,'06e40407-843e-e6d3-6aab-ad3be15b7d35',0,1,1,NULL,NULL,'2024-11-21 12:19:44.576000',NULL,NULL,'Provided by Liferay','','',NULL,NULL,0,0,0),
(1,0,31835,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:44.897000','2024-11-21 12:19:44.928000',20009,31831,'8ae0d697-90c5-7827-8a23-6f757790701e',0,1,1,NULL,NULL,'2024-11-21 12:19:44.897000',NULL,'image/png','astronaut.png','','',NULL,NULL,0,0,0),
(1,0,31845,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.170000','2024-11-21 12:19:45.193000',20009,31841,'756d79da-250e-4f8a-3f54-999abc9e3924',0,1,1,NULL,NULL,'2024-11-21 12:19:45.170000',NULL,'image/png','earth.png','','',NULL,NULL,0,0,0),
(1,0,31856,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.470000','2024-11-21 12:19:45.506000',20009,31852,'a52a042c-d9c7-7204-a5be-7877a567009e',0,1,1,NULL,NULL,'2024-11-21 12:19:45.470000',NULL,'image/png','moon.png','','',NULL,NULL,0,0,0),
(1,0,31869,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:45.817000','2024-11-21 12:19:45.868000',20009,31864,'8b66e9b9-2e39-faea-1f58-0911afcc0c18',0,1,1,NULL,NULL,'2024-11-21 12:19:45.817000',NULL,'image/png','planet.png','','',NULL,NULL,0,0,0),
(1,0,31882,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.218000','2024-11-21 12:19:46.253000',20009,31877,'8e07bfda-2bd8-805f-0bea-ff13014fdd85',0,1,1,NULL,NULL,'2024-11-21 12:19:46.218000',NULL,'image/png','satellite.png','','',NULL,NULL,0,0,0),
(1,0,31894,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.509000','2024-11-21 12:19:46.527000',20009,31889,'14719bba-6841-dc15-bb3d-8a0ebcc5fff1',0,1,1,NULL,NULL,'2024-11-21 12:19:46.509000',NULL,'image/png','stars.png','','',NULL,NULL,0,0,0),
(1,0,31905,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:46.739000','2024-11-21 12:19:46.776000',20009,31901,'f2cc664c-d4c4-f133-a5d0-9f6d3241c45c',0,1,1,NULL,NULL,'2024-11-21 12:19:46.739000',NULL,'image/png','tree.png','','',NULL,NULL,0,0,0),
(1,0,31922,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:48.746000','2024-11-21 12:19:48.746000',20031,8,'35a95ce2-7cd1-af25-e4ab-e9f1417e44b5',0,1,0,NULL,NULL,'2024-11-21 12:19:48.746000',NULL,'text/html','404','','',NULL,NULL,0,0,0),
(1,0,31928,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:48.809000','2024-11-21 12:19:48.746000',20031,9,'498b687d-77e6-9822-9e20-ccf8571c0c3f',0,1,0,NULL,NULL,'2024-11-21 12:19:48.746000',NULL,'text/html','404','','',NULL,NULL,0,0,0),
(0,0,31945,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.675000','2024-11-21 12:19:50.675000',20009,31941,'081b5d64-8cab-2fd9-6be1-d1a8233e1f4c',0,1,0,NULL,NULL,NULL,NULL,'image/png','31915_preview.png','','',NULL,NULL,0,0,0),
(1,0,31957,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:50.965000','2024-11-21 12:19:50.965000',20031,10,'3d5f4cab-1061-fb49-10bf-8a874c25bfb1',0,1,0,NULL,NULL,'2024-11-21 12:19:50.965000',NULL,'text/html','500','','',NULL,NULL,0,0,0),
(1,0,31963,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.059000','2024-11-21 12:19:50.965000',20031,11,'9546ca6e-a601-30ed-5290-49a069da5b66',0,1,0,NULL,NULL,'2024-11-21 12:19:50.965000',NULL,'text/html','500','','',NULL,NULL,0,0,0),
(0,0,31976,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.286000','2024-11-21 12:19:51.286000',20009,31972,'dc31eb8d-e816-b826-ca2b-b39da6c867eb',0,1,0,NULL,NULL,NULL,NULL,'image/png','31946_preview.png','','',NULL,NULL,0,0,0),
(1,0,31988,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.507000','2024-11-21 12:19:51.507000',20031,12,'41d1daf4-9d6a-6fb0-dfac-7a56d6b3ba58',0,1,0,NULL,NULL,'2024-11-21 12:19:51.507000',NULL,'text/html','Cookie Policy','','',NULL,NULL,0,0,0),
(1,0,31994,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.582000','2024-11-21 12:19:51.507000',20031,13,'0a5ebb00-22fe-8673-807c-05487715657f',0,1,0,NULL,NULL,'2024-11-21 12:19:51.507000',NULL,'text/html','Cookie Policy','','',NULL,NULL,0,0,0),
(0,0,32025,20117,64463788232944,20123,'Test Test','2024-11-21 12:19:51.913000','2024-11-21 12:19:51.913000',20009,32021,'ff939be8-d3ff-9e12-03a6-6f9a0cfa774a',0,1,0,NULL,NULL,NULL,NULL,'image/png','31977_preview.png','','',NULL,NULL,0,0,0),
(0,0,32107,20125,64463788232944,20123,'Test Test','2024-11-21 12:52:01.033000','2024-11-21 12:52:01.033000',20031,14,'57515a66-b738-ed14-98d3-776f3eb9b075',0,1,0,NULL,NULL,NULL,NULL,'text/html','My Dashboard','','',NULL,NULL,0,0,0),
(0,0,32111,20125,64463788232944,20123,'Test Test','2024-11-21 12:52:01.916000','2024-11-21 12:52:01.916000',20031,15,'706b5894-1cca-cb88-a9a1-af049fc7cc5b',0,1,0,NULL,NULL,NULL,NULL,'text/html','My Profile','','',NULL,NULL,0,0,0),
(0,0,32217,20117,64463788232944,20096,NULL,'2024-11-21 12:59:09.024000','2024-11-21 12:59:09.024000',20031,16,'33644289-478e-b3f2-b9ab-cb3a3dc183b8',0,1,0,NULL,NULL,NULL,NULL,'text/html','Control Panel','','',NULL,NULL,0,0,0),
(0,0,32223,20120,64463788232944,20123,'Test Test','2024-11-22 12:18:16.864000','2024-11-22 12:18:16.864000',20071,32220,'171905b0-1bc8-b755-2c58-8467510ecd7f',0,1,0,NULL,NULL,NULL,NULL,NULL,'Fred Flint','','',NULL,NULL,0,0,0),
(0,0,32231,20117,64463788232944,20096,NULL,'2024-11-22 13:09:32.624000','2024-11-22 13:09:32.624000',20031,17,'ea513abd-ed7d-4823-b51d-1e07ffce537e',0,1,0,NULL,NULL,NULL,NULL,'text/html','Control Panel','','',NULL,NULL,0,0,0),
(1,0,32308,20120,64463788232944,20123,'Test Test','2024-11-26 13:44:08.938000','2024-11-26 13:44:22.487000',20042,32306,'7efc76e4-db9e-9366-f053-c4f1916a5927',0,1,0,NULL,NULL,NULL,NULL,NULL,'Bedstone','','',NULL,NULL,0,0,0),
(0,0,32505,20120,64463788232944,20123,'Test Test','2024-12-03 11:45:47.897000','2024-12-03 11:45:47.911000',28707,32503,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,'RockSeller','Sells rocks.','',NULL,NULL,0,0,0),
(0,0,32606,20120,64463788232944,20123,'Test Test','2024-12-04 13:19:59.533000','2024-12-04 13:19:59.533000',20071,32603,'2eb25dd6-e7be-54da-0e4f-941218aba05d',0,1,0,NULL,NULL,NULL,NULL,NULL,'Seller Manager','','',NULL,NULL,0,0,0),
(0,0,32926,20120,64463788232944,20123,'Test Test','2024-12-16 12:58:08.525000','2024-12-16 12:58:08.525000',20029,32925,NULL,0,1,0,NULL,NULL,NULL,NULL,NULL,'All About Rocks','','',NULL,NULL,0,0,0),
(0,0,32935,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.086000','2024-12-16 12:58:09.086000',20031,18,'976bd19c-3a5e-8dc2-7a00-ddcb3a3cbc87',0,1,0,NULL,NULL,NULL,NULL,'text/html','404 Error','','',NULL,NULL,0,0,0),
(0,0,32941,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.196000','2024-12-16 12:58:09.086000',20031,19,'e779299a-6569-53ff-0cca-6ec8ee8721f6',0,1,0,NULL,NULL,NULL,NULL,'text/html','404 Error','','',NULL,NULL,0,0,0),
(0,0,32967,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.586000','2024-12-16 12:58:09.086000',20031,20,'02aa8fa3-5bd4-0343-6933-ce08d3d05d58',0,1,0,NULL,NULL,NULL,NULL,'text/html','500 Error','','',NULL,NULL,0,0,0),
(0,0,32973,32925,64463788232944,20123,'Test Test','2024-12-16 12:58:09.628000','2024-12-16 12:58:09.586000',20031,21,'57d651dc-5ab1-5659-2267-42112eb6c1f9',0,1,0,NULL,NULL,NULL,NULL,'text/html','500 Error','','',NULL,NULL,0,0,0),
(0,0,32998,32925,64463788232944,20096,NULL,'2024-12-16 16:32:21.344000','2024-12-16 16:32:21.344000',20031,22,'19c56370-a902-bca1-465d-a56684fd9dea',0,1,0,NULL,NULL,NULL,NULL,'text/html','Control Panel','','',NULL,NULL,0,0,0),
(1,0,33005,32925,64463788232944,20096,NULL,'2024-12-16 16:45:56.115000','2024-12-16 16:45:56.190000',28809,33004,'61d7e1dc-25a4-210e-8a7a-6b88de117163',0,1,1,NULL,NULL,NULL,NULL,'text/html','FrontPage','','',NULL,NULL,0,0,0),
(1,0,33018,20117,64463788232944,20123,'Test Test','2024-12-19 12:55:23.325000','2024-12-19 12:55:23.495000',28838,33014,'14c65a6f-a5d8-8c69-de56-545e71e98763',30029,1,1,NULL,NULL,'2024-12-19 12:54:00.000000',NULL,'text/html','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">Igneous Rocks</Title></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Description language-id=\"en_US\">&lt;p>Catalog of Igneous Rocks&lt;/p></Description></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Description language-id=\"en_US\">&lt;p>Catalog of Igneous Rocks&lt;/p></Description></root>',NULL,NULL,0,0,0),
(1,0,33029,20117,64463788232944,20123,'Test Test','2024-12-19 17:56:11.153000','2024-12-19 17:56:11.263000',28838,33025,'1ae07564-2766-9b6e-83c5-eba05a41f074',30029,1,1,NULL,NULL,'2024-12-19 17:55:00.000000',NULL,'text/html','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Title language-id=\"en_US\">River Rocks</Title></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Description language-id=\"en_US\">&lt;p>River Rocks&lt;/p></Description></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Description language-id=\"en_US\">&lt;p>River Rocks&lt;/p></Description></root>',NULL,NULL,0,0,0),
(0,0,33075,32925,64463788232944,20123,'Test Test','2024-12-23 14:02:05.714000','2024-12-23 14:02:05.714000',20031,25,'15c3ab1f-d407-1a9a-b3aa-19c0e27f5a17',0,1,0,NULL,NULL,NULL,NULL,'text/html','Types of Rocks','','',NULL,NULL,0,0,0),
(0,0,33081,32925,64463788232944,20123,'Test Test','2024-12-23 14:02:05.813000','2024-12-23 14:02:05.714000',20031,26,'fcb0f7b6-a3c4-e527-3e1f-0055f470e010',0,1,0,NULL,NULL,NULL,NULL,'text/html','Types of Rocks','','',NULL,NULL,0,0,0),
(0,0,33165,32925,64463788232944,20096,NULL,'2024-12-27 13:31:40.853000','2024-12-27 13:31:40.853000',20031,29,'bac18a1a-dd50-40ed-0505-226d11917c12',0,1,0,NULL,NULL,NULL,NULL,'text/html','Control Panel','','',NULL,NULL,0,0,0);

--
-- Table structure for table `AssetEntryAssetCategoryRel`
--

CREATE TABLE `AssetEntryAssetCategoryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `assetEntryAssetCategoryRelId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `assetEntryId` bigint(20) DEFAULT NULL,
  `assetCategoryId` bigint(20) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  PRIMARY KEY (`assetEntryAssetCategoryRelId`,`ctCollectionId`),
  KEY `IX_19EC1746` (`assetCategoryId`),
  KEY `IX_E597E5D5` (`assetEntryId`,`assetCategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetEntryAssetCategoryRel`
--


--
-- Table structure for table `AssetLink`
--

CREATE TABLE `AssetLink` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `linkId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `entryId1` bigint(20) DEFAULT NULL,
  `entryId2` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  PRIMARY KEY (`linkId`,`ctCollectionId`),
  UNIQUE KEY `IX_7FC555F2` (`entryId1`,`entryId2`,`type_`,`ctCollectionId`),
  KEY `IX_14D5A20D` (`entryId1`,`type_`),
  KEY `IX_91F132C` (`entryId2`,`type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetLink`
--


--
-- Table structure for table `AssetListEntry`
--

CREATE TABLE `AssetListEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `assetListEntryId` 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,
  `assetListEntryKey` varchar(75) DEFAULT NULL,
  `title` varchar(75) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `assetEntrySubtype` varchar(255) DEFAULT NULL,
  `assetEntryType` varchar(255) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`assetListEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_D3D0EE8D` (`groupId`,`ctCollectionId`,`assetListEntryKey`),
  UNIQUE KEY `IX_5856D7F` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_E08A6DF6` (`groupId`,`ctCollectionId`,`uuid_`),
  UNIQUE KEY `IX_5B95A9C6` (`groupId`,`title`,`ctCollectionId`),
  KEY `IX_D8D58598` (`groupId`,`assetEntryType`,`assetEntrySubtype`),
  KEY `IX_40A918D0` (`groupId`,`title`,`assetEntryType`,`assetEntrySubtype`),
  KEY `IX_4FE08A35` (`groupId`,`type_`),
  KEY `IX_5B11862A` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetListEntry`
--


--
-- Table structure for table `AssetListEntryAssetEntryRel`
--

CREATE TABLE `AssetListEntryAssetEntryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `assetListEntryAssetEntryRelId` 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,
  `assetListEntryId` bigint(20) DEFAULT NULL,
  `assetEntryId` bigint(20) DEFAULT NULL,
  `segmentsEntryId` bigint(20) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`assetListEntryAssetEntryRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_FAAE938C` (`assetListEntryId`,`segmentsEntryId`,`position`,`ctCollectionId`),
  UNIQUE KEY `IX_A46B1691` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_622F04CA` (`assetEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetListEntryAssetEntryRel`
--


--
-- Table structure for table `AssetListEntrySegmentsEntryRel`
--

CREATE TABLE `AssetListEntrySegmentsEntryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `alEntrySegmentsEntryRelId` 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,
  `assetListEntryId` bigint(20) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `segmentsEntryId` bigint(20) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`alEntrySegmentsEntryRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_56302677` (`assetListEntryId`,`segmentsEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_AE822E09` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_1C9A6A4C` (`segmentsEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetListEntrySegmentsEntryRel`
--


--
-- Table structure for table `AssetListEntryUsage`
--

CREATE TABLE `AssetListEntryUsage` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `assetListEntryUsageId` 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,
  `containerKey` varchar(255) DEFAULT NULL,
  `containerType` bigint(20) DEFAULT NULL,
  `key_` varchar(255) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`assetListEntryUsageId`,`ctCollectionId`),
  UNIQUE KEY `IX_512AA275` (`groupId`,`classNameId`,`key_`,`plid`,`containerType`,`containerKey`,`ctCollectionId`),
  UNIQUE KEY `IX_57EC072B` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_E1D6CA09` (`classNameId`,`key_`,`companyId`),
  KEY `IX_10BA153A` (`groupId`,`classNameId`,`key_`,`type_`),
  KEY `IX_BBE5024F` (`plid`,`containerType`,`containerKey`),
  KEY `IX_561E0151` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetListEntryUsage`
--


--
-- Table structure for table `AssetTag`
--

CREATE TABLE `AssetTag` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `tagId` 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(75) DEFAULT NULL,
  `assetCount` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`tagId`,`ctCollectionId`),
  UNIQUE KEY `IX_A43FBC4` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_D63322F9` (`groupId`,`name`),
  KEY `IX_C43137AF` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetTag`
--


--
-- Table structure for table `AssetVocabulary`
--

CREATE TABLE `AssetVocabulary` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `vocabularyId` 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(75) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `visibilityType` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`vocabularyId`,`ctCollectionId`),
  UNIQUE KEY `IX_E06DEF51` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_32F2132B` (`groupId`,`ctCollectionId`,`name`),
  UNIQUE KEY `IX_3966DE44` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_B22D908C` (`companyId`),
  KEY `IX_C0AAD74D` (`groupId`,`name`),
  KEY `IX_2F7F11EE` (`groupId`,`visibilityType`),
  KEY `IX_55F58818` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `AssetVocabulary`
--

INSERT INTO `AssetVocabulary` VALUES
(0,0,'b94e16f3-6e70-cb9b-8643-47163514fedc','b94e16f3-6e70-cb9b-8643-47163514fedc',31238,20120,64463788232944,20096,NULL,'2024-11-21 12:19:30.827000','2024-11-21 12:19:30.827000','topic','<?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\"><Title language-id=\"sv_SE\">Ämne</Title><Title language-id=\"pt_BR\">Tópico</Title><Title language-id=\"ja_JP\">トピック</Title><Title language-id=\"fr_FR\">Sujet</Title><Title language-id=\"hu_HU\">Téma</Title><Title language-id=\"de_DE\">Thema</Title><Title language-id=\"ca_ES\">Tema</Title><Title language-id=\"ar_SA\">عنوان رئيسي</Title><Title language-id=\"fi_FI\">Aihe</Title><Title language-id=\"en_US\">Topic</Title><Title language-id=\"zh_CN\">主题</Title><Title language-id=\"es_ES\">Tema</Title><Title language-id=\"nl_NL\">Onderwerp</Title></root>',NULL,NULL,0,NULL),
(2,0,'9eda5a36-e163-4efc-6222-9634c6b08985','9eda5a36-e163-4efc-6222-9634c6b08985',31239,20120,64463788232944,20096,NULL,'2024-11-21 12:19:31.114000','2024-11-21 12:19:31.663000','audience','<?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\"><Title language-id=\"en_US\">Audience</Title><Title language-id=\"ar_SA\">الجمهور</Title><Title language-id=\"ca_ES\">Públic</Title><Title language-id=\"zh_CN\">受众</Title><Title language-id=\"nl_NL\">Doelgroep</Title><Title language-id=\"fi_FI\">Kohdeyleisö</Title><Title language-id=\"fr_FR\">Publics</Title><Title language-id=\"de_DE\">Zielgruppe</Title><Title language-id=\"hu_HU\">Közönség</Title><Title language-id=\"ja_JP\">オーディエンス</Title><Title language-id=\"pt_BR\">Público-alvo</Title><Title language-id=\"es_ES\">Público</Title><Title language-id=\"sv_SE\">Målgrupp</Title></root>',NULL,'selectedClassNameIds=28838:-1,20009:-1,29033:-1\n',1,NULL),
(2,0,'345f8b20-18f4-7926-18a0-b479ad5080c7','345f8b20-18f4-7926-18a0-b479ad5080c7',31240,20120,64463788232944,20096,NULL,'2024-11-21 12:19:31.275000','2024-11-21 12:19:31.752000','stage','<?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\"><Title language-id=\"en_US\">Stage</Title><Title language-id=\"ar_SA\">الولاية</Title><Title language-id=\"ca_ES\">Fase</Title><Title language-id=\"zh_CN\">审核阶段</Title><Title language-id=\"nl_NL\">Pre-publicatiefase</Title><Title language-id=\"fi_FI\">Vaihe</Title><Title language-id=\"fr_FR\">Étape</Title><Title language-id=\"de_DE\">Phase</Title><Title language-id=\"hu_HU\">Szakasz</Title><Title language-id=\"ja_JP\">ステージ</Title><Title language-id=\"pt_BR\">Estágio</Title><Title language-id=\"es_ES\">Fase</Title><Title language-id=\"sv_SE\">Testmiljö</Title></root>',NULL,'selectedClassNameIds=28838:-1,20009:-1,29033:-1\n',1,NULL);

--
-- Table structure for table `Audit_AuditEvent`
--

CREATE TABLE `Audit_AuditEvent` (
  `auditEventId` 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,
  `eventType` varchar(75) DEFAULT NULL,
  `className` varchar(200) DEFAULT NULL,
  `classPK` varchar(75) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `clientHost` varchar(255) DEFAULT NULL,
  `clientIP` varchar(255) DEFAULT NULL,
  `serverName` varchar(255) DEFAULT NULL,
  `serverPort` int(11) DEFAULT NULL,
  `sessionID` varchar(255) DEFAULT NULL,
  `additionalInfo` longtext DEFAULT NULL,
  PRIMARY KEY (`auditEventId`),
  KEY `IX_8FE31EDF` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Audit_AuditEvent`
--

INSERT INTO `Audit_AuditEvent` VALUES
(31401,0,64463788232944,0,NULL,'2024-11-21 12:19:07.167000','ADD','com.liferay.object.model.ObjectField','30046',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31402,0,64463788232944,0,NULL,'2024-11-21 12:19:07.191000','ADD','com.liferay.object.model.ObjectField','30047',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31403,0,64463788232944,0,NULL,'2024-11-21 12:19:07.202000','ADD','com.liferay.object.model.ObjectField','30048',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31404,0,64463788232944,0,NULL,'2024-11-21 12:19:07.212000','ADD','com.liferay.object.model.ObjectField','30049',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"addressId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31405,0,64463788232944,0,NULL,'2024-11-21 12:19:07.230000','ADD','com.liferay.object.model.ObjectField','30050',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31406,0,64463788232944,0,NULL,'2024-11-21 12:19:07.239000','ADD','com.liferay.object.model.ObjectField','30051',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31407,0,64463788232944,0,NULL,'2024-11-21 12:19:07.256000','ADD','com.liferay.object.model.ObjectField','30052',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"name\",\"DBColumnName\":\"name\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Namn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名前\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Név\",\"de_DE\":\"Name\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم\",\"fi_FI\":\"Nimi\",\"en_US\":\"Name\",\"zh_CN\":\"名称\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Naam\"}}'),
(31408,0,64463788232944,0,NULL,'2024-11-21 12:19:07.282000','ADD','com.liferay.object.model.ObjectField','30053',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"streetAddressLine1\",\"DBColumnName\":\"street1\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Gata 1\",\"pt_BR\":\"Endereço 1\",\"ja_JP\":\"町名\",\"fr_FR\":\"Rue 1\",\"hu_HU\":\"Utca 1\",\"de_DE\":\"Straße 1\",\"ca_ES\":\"Carrer 1\",\"ar_SA\":\"الشارع 1\",\"fi_FI\":\"Katuosoite 1\",\"en_US\":\"Street 1\",\"zh_CN\":\"街道1\",\"es_ES\":\"Calle 1\",\"nl_NL\":\"Adresregel 1\"}}'),
(31409,0,64463788232944,0,NULL,'2024-11-21 12:19:07.394000','ADD','com.liferay.object.model.ObjectField','30056',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31410,0,64463788232944,0,NULL,'2024-11-21 12:19:07.404000','ADD','com.liferay.object.model.ObjectField','30057',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31411,0,64463788232944,0,NULL,'2024-11-21 12:19:07.409000','ADD','com.liferay.object.model.ObjectField','30058',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31412,0,64463788232944,0,NULL,'2024-11-21 12:19:07.417000','ADD','com.liferay.object.model.ObjectField','30059',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"accountEntryId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31413,0,64463788232944,0,NULL,'2024-11-21 12:19:07.424000','ADD','com.liferay.object.model.ObjectField','30060',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31414,0,64463788232944,0,NULL,'2024-11-21 12:19:07.430000','ADD','com.liferay.object.model.ObjectField','30061',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31415,0,64463788232944,0,NULL,'2024-11-21 12:19:07.443000','ADD','com.liferay.object.model.ObjectField','30062',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"description\",\"DBColumnName\":\"description\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Beskrivning\",\"pt_BR\":\"Descrição\",\"ja_JP\":\"説明\",\"fr_FR\":\"Description\",\"hu_HU\":\"Leírás\",\"de_DE\":\"Beschreibung\",\"ca_ES\":\"Descripció\",\"ar_SA\":\"الوصف\",\"fi_FI\":\"Kuvaus\",\"en_US\":\"Description\",\"zh_CN\":\"描述\",\"es_ES\":\"Descripción\",\"nl_NL\":\"Beschrijving\"}}'),
(31416,0,64463788232944,0,NULL,'2024-11-21 12:19:07.448000','ADD','com.liferay.object.model.ObjectField','30063',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"name\",\"DBColumnName\":\"name\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Namn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名前\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Név\",\"de_DE\":\"Name\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم\",\"fi_FI\":\"Nimi\",\"en_US\":\"Name\",\"zh_CN\":\"名称\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Naam\"}}'),
(31417,0,64463788232944,0,NULL,'2024-11-21 12:19:07.459000','ADD','com.liferay.object.model.ObjectField','30064',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"type\",\"DBColumnName\":\"type\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Typ\",\"pt_BR\":\"Tipo\",\"ja_JP\":\"種類\",\"fr_FR\":\"Type\",\"hu_HU\":\"Típus\",\"de_DE\":\"Typ\",\"ca_ES\":\"Tipus\",\"ar_SA\":\"النوع\",\"fi_FI\":\"Tyyppi\",\"en_US\":\"Type\",\"zh_CN\":\"类型\",\"es_ES\":\"Tipo\",\"nl_NL\":\"Type\"}}'),
(31418,0,64463788232944,0,NULL,'2024-11-21 12:19:07.522000','ADD','com.liferay.object.model.ObjectField','30067',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31419,0,64463788232944,0,NULL,'2024-11-21 12:19:07.527000','ADD','com.liferay.object.model.ObjectField','30068',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31420,0,64463788232944,0,NULL,'2024-11-21 12:19:07.532000','ADD','com.liferay.object.model.ObjectField','30069',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31421,0,64463788232944,0,NULL,'2024-11-21 12:19:07.537000','ADD','com.liferay.object.model.ObjectField','30070',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"organizationId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31422,0,64463788232944,0,NULL,'2024-11-21 12:19:07.542000','ADD','com.liferay.object.model.ObjectField','30071',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31423,0,64463788232944,0,NULL,'2024-11-21 12:19:07.546000','ADD','com.liferay.object.model.ObjectField','30072',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31424,0,64463788232944,0,NULL,'2024-11-21 12:19:07.557000','ADD','com.liferay.object.model.ObjectField','30073',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"comment\",\"DBColumnName\":\"comment\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Kommentarer\",\"pt_BR\":\"Comentários\",\"ja_JP\":\"コメント\",\"fr_FR\":\"Commentaires\",\"hu_HU\":\"Megjegyzések\",\"de_DE\":\"Kommentare\",\"ca_ES\":\"Comentaris\",\"ar_SA\":\"ملاحظات\",\"fi_FI\":\"Kommentit\",\"en_US\":\"Comments\",\"zh_CN\":\"评论\",\"es_ES\":\"Comentarios\",\"nl_NL\":\"Reacties\"}}'),
(31425,0,64463788232944,0,NULL,'2024-11-21 12:19:07.562000','ADD','com.liferay.object.model.ObjectField','30074',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"name\",\"DBColumnName\":\"name\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Namn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名前\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Név\",\"de_DE\":\"Name\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم\",\"fi_FI\":\"Nimi\",\"en_US\":\"Name\",\"zh_CN\":\"名称\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Naam\"}}'),
(31426,0,64463788232944,0,NULL,'2024-11-21 12:19:07.621000','ADD','com.liferay.object.model.ObjectField','30077',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31427,0,64463788232944,0,NULL,'2024-11-21 12:19:07.626000','ADD','com.liferay.object.model.ObjectField','30078',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31428,0,64463788232944,0,NULL,'2024-11-21 12:19:07.631000','ADD','com.liferay.object.model.ObjectField','30079',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31429,0,64463788232944,0,NULL,'2024-11-21 12:19:07.635000','ADD','com.liferay.object.model.ObjectField','30080',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"userId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31430,0,64463788232944,0,NULL,'2024-11-21 12:19:07.640000','ADD','com.liferay.object.model.ObjectField','30081',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31431,0,64463788232944,0,NULL,'2024-11-21 12:19:07.644000','ADD','com.liferay.object.model.ObjectField','30082',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31432,0,64463788232944,0,NULL,'2024-11-21 12:19:07.658000','ADD','com.liferay.object.model.ObjectField','30083',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"additionalName\",\"DBColumnName\":\"middleName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Mellannamn\",\"pt_BR\":\"Segundo Nome\",\"ja_JP\":\"ミドルネーム\",\"fr_FR\":\"Deuxième Prénom\",\"hu_HU\":\"Középső név\",\"de_DE\":\"Zweitname\",\"ca_ES\":\"Segon nom\",\"ar_SA\":\"الإسم الأوسط\",\"fi_FI\":\"Toinen nimi\",\"en_US\":\"Middle Name\",\"zh_CN\":\"中间名\",\"es_ES\":\"Segundo nombre\",\"nl_NL\":\"Tussenvoegsel\"}}'),
(31433,0,64463788232944,0,NULL,'2024-11-21 12:19:07.669000','ADD','com.liferay.object.model.ObjectField','30084',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"alternateName\",\"DBColumnName\":\"screenName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Användarnamn\",\"pt_BR\":\"Nome de Usuário\",\"ja_JP\":\"スクリーン名\",\"fr_FR\":\"login\",\"hu_HU\":\"Felhasználónév\",\"de_DE\":\"Benutzername\",\"ca_ES\":\"Nom d\'usuari\",\"ar_SA\":\"الإسم الظاهر\",\"fi_FI\":\"Nimimerkki\",\"en_US\":\"Screen Name\",\"zh_CN\":\"屏幕显示名称\",\"es_ES\":\"Nombre de usuario\",\"nl_NL\":\"Gebruikersnaam\"}}'),
(31434,0,64463788232944,0,NULL,'2024-11-21 12:19:07.679000','ADD','com.liferay.object.model.ObjectField','30085',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"emailAddress\",\"DBColumnName\":\"emailAddress\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"E-postadress\",\"pt_BR\":\"Endereço de e-mail\",\"ja_JP\":\"メールアドレス\",\"fr_FR\":\"Adresse email\",\"hu_HU\":\"E-mail cím\",\"de_DE\":\"E-Mail-Adresse\",\"ca_ES\":\"Adreça de correu electrònic\",\"ar_SA\":\"عنوان البريد الإلكتروني\",\"fi_FI\":\"Sähköpostiosoite\",\"en_US\":\"Email Address\",\"zh_CN\":\"电子邮件地址\",\"es_ES\":\"Dirección de correo\",\"nl_NL\":\"E-mailadres\"}}'),
(31435,0,64463788232944,0,NULL,'2024-11-21 12:19:07.688000','ADD','com.liferay.object.model.ObjectField','30086',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"familyName\",\"DBColumnName\":\"lastName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Efternamn\",\"pt_BR\":\"Sobrenome\",\"ja_JP\":\"姓\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Vezetéknév\",\"de_DE\":\"Nachname\",\"ca_ES\":\"Cognom\",\"ar_SA\":\"الإسم الأخير\",\"fi_FI\":\"Sukunimi\",\"en_US\":\"Last Name\",\"zh_CN\":\"姓\",\"es_ES\":\"Apellido\",\"nl_NL\":\"Achternaam\"}}'),
(31436,0,64463788232944,0,NULL,'2024-11-21 12:19:07.697000','ADD','com.liferay.object.model.ObjectField','30087',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"givenName\",\"DBColumnName\":\"firstName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Tilltalsnamn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名\",\"fr_FR\":\"Prénom\",\"hu_HU\":\"Keresztnév\",\"de_DE\":\"Vorname\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم الأول\",\"fi_FI\":\"Etunimi\",\"en_US\":\"First Name\",\"zh_CN\":\"名字\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Voornaam\"}}'),
(31437,0,64463788232944,0,NULL,'2024-11-21 12:19:07.707000','ADD','com.liferay.object.model.ObjectField','30088',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"lastLoginDate\",\"DBColumnName\":\"lastLoginDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Senaste inloggningsdatum\",\"pt_BR\":\"Data do último login\",\"ja_JP\":\"最終ログイン日\",\"fr_FR\":\"Date de la dernière connexion\",\"hu_HU\":\"Utolsó bejelentkezés dátuma\",\"de_DE\":\"Letztes Anmeldedatum\",\"ca_ES\":\"Data de l\'últim inici de sessió\",\"ar_SA\":\"تاريخ آخر تسجيل دخول\",\"fi_FI\":\"Viimeisin Kirjautumispäivä\",\"en_US\":\"Last Login Date\",\"zh_CN\":\"上次登录日期\",\"es_ES\":\"Fecha del último inicio de sesión\",\"nl_NL\":\"Laatste inlogdatum\"}}'),
(31438,0,64463788232944,0,NULL,'2024-11-21 12:19:07.718000','ADD','com.liferay.object.model.ObjectField','30089',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"uuid\",\"DBColumnName\":\"uuid_\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"UUID\",\"pt_BR\":\"UUID\",\"ja_JP\":\"UUID\",\"fr_FR\":\"UUID (IDentifiant Unique Universel)\",\"hu_HU\":\"UUID\",\"de_DE\":\"UUID\",\"ca_ES\":\"UUID\",\"ar_SA\":\"UUID\",\"fi_FI\":\"UUID\",\"en_US\":\"UUID\",\"zh_CN\":\"通用唯一标识符\",\"es_ES\":\"UUID\",\"nl_NL\":\"UUID\"}}'),
(31439,0,64463788232944,0,NULL,'2024-11-21 12:19:07.784000','ADD','com.liferay.object.model.ObjectField','30092',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31440,0,64463788232944,0,NULL,'2024-11-21 12:19:07.791000','ADD','com.liferay.object.model.ObjectField','30093',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31441,0,64463788232944,0,NULL,'2024-11-21 12:19:07.796000','ADD','com.liferay.object.model.ObjectField','30094',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31442,0,64463788232944,0,NULL,'2024-11-21 12:19:07.801000','ADD','com.liferay.object.model.ObjectField','30095',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"commercePricingClassId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31443,0,64463788232944,0,NULL,'2024-11-21 12:19:07.806000','ADD','com.liferay.object.model.ObjectField','30096',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31444,0,64463788232944,0,NULL,'2024-11-21 12:19:07.810000','ADD','com.liferay.object.model.ObjectField','30097',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31445,0,64463788232944,0,NULL,'2024-11-21 12:19:07.819000','ADD','com.liferay.object.model.ObjectField','30098',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"description\",\"DBColumnName\":\"description\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Beskrivning\",\"pt_BR\":\"Descrição\",\"ja_JP\":\"説明\",\"fr_FR\":\"Description\",\"hu_HU\":\"Leírás\",\"de_DE\":\"Beschreibung\",\"ca_ES\":\"Descripció\",\"ar_SA\":\"الوصف\",\"fi_FI\":\"Kuvaus\",\"en_US\":\"Description\",\"zh_CN\":\"描述\",\"es_ES\":\"Descripción\",\"nl_NL\":\"Beschrijving\"}}'),
(31446,0,64463788232944,0,NULL,'2024-11-21 12:19:07.835000','ADD','com.liferay.object.model.ObjectField','30099',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"productsCount\",\"DBColumnName\":\"productsCount\",\"DBType\":\"Integer\",\"businessType\":\"Integer\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Antal produkter\",\"pt_BR\":\"Número de produtos\",\"ja_JP\":\"製品数\",\"fr_FR\":\"Nombre de produits\",\"hu_HU\":\"Termékek száma\",\"de_DE\":\"Anzahl der Produkte\",\"ca_ES\":\"Nombre de productes\",\"ar_SA\":\"عدد المنتجات\",\"fi_FI\":\"Tuotteiden lukumäärä\",\"en_US\":\"Number of Products\",\"zh_CN\":\"产品数量\",\"es_ES\":\"Número de productos\",\"nl_NL\":\"Aantal producten\"}}'),
(31447,0,64463788232944,0,NULL,'2024-11-21 12:19:07.846000','ADD','com.liferay.object.model.ObjectField','30100',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"title\",\"DBColumnName\":\"title\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Titel\",\"pt_BR\":\"Título\",\"ja_JP\":\"タイトル\",\"fr_FR\":\"Titre\",\"hu_HU\":\"Cím\",\"de_DE\":\"Titel\",\"ca_ES\":\"Títol\",\"ar_SA\":\"العنوان\",\"fi_FI\":\"Otsikko\",\"en_US\":\"Title\",\"zh_CN\":\"标题\",\"es_ES\":\"Título\",\"nl_NL\":\"Titel\"}}'),
(31448,0,64463788232944,0,NULL,'2024-11-21 12:19:17.301000','ADD','com.liferay.object.model.ObjectDefinition','30607',NULL,NULL,NULL,NULL,0,NULL,'{\"scope\":\"company\",\"name\":\"CPDefinition\",\"active\":true,\"labelMap\":{\"sv_SE\":\"Handelsprodukt\",\"pt_BR\":\"Produto do Comércio\",\"ja_JP\":\"コマース製品\",\"fr_FR\":\"Produit commercial\",\"hu_HU\":\"Kereskedelmi termék\",\"de_DE\":\"Handelsprodukt\",\"ca_ES\":\"Producte de comerç\",\"ar_SA\":\"المنتج التجاري\",\"fi_FI\":\"Kaupankäyntituote\",\"en_US\":\"Commerce Product\",\"zh_CN\":\"商务产品\",\"es_ES\":\"Producto de comercio\",\"nl_NL\":\"Handelsproduct\"}}'),
(31449,0,64463788232944,0,NULL,'2024-11-21 12:19:17.310000','ADD','com.liferay.object.model.ObjectField','30608',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31450,0,64463788232944,0,NULL,'2024-11-21 12:19:17.314000','ADD','com.liferay.object.model.ObjectField','30609',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31451,0,64463788232944,0,NULL,'2024-11-21 12:19:17.318000','ADD','com.liferay.object.model.ObjectField','30610',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31452,0,64463788232944,0,NULL,'2024-11-21 12:19:17.321000','ADD','com.liferay.object.model.ObjectField','30611',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"CPDefinitionId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31453,0,64463788232944,0,NULL,'2024-11-21 12:19:17.325000','ADD','com.liferay.object.model.ObjectField','30612',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31454,0,64463788232944,0,NULL,'2024-11-21 12:19:17.329000','ADD','com.liferay.object.model.ObjectField','30613',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31455,0,64463788232944,0,NULL,'2024-11-21 12:19:17.336000','ADD','com.liferay.object.model.ObjectField','30614',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"active\",\"DBColumnName\":\"active\",\"DBType\":\"Boolean\",\"businessType\":\"Boolean\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Aktiv\",\"pt_BR\":\"Ativo\",\"ja_JP\":\"有効\",\"fr_FR\":\"Actif\",\"hu_HU\":\"Aktív\",\"de_DE\":\"Aktiv\",\"ca_ES\":\"Actiu\",\"ar_SA\":\"مفعّل\",\"fi_FI\":\"Aktiivinen\",\"en_US\":\"Active\",\"zh_CN\":\"已激活\",\"es_ES\":\"Activo\",\"nl_NL\":\"Actief\"}}'),
(31456,0,64463788232944,0,NULL,'2024-11-21 12:19:17.345000','ADD','com.liferay.object.model.ObjectField','30615',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"catalogId\",\"DBColumnName\":\"catalogId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Katalog-ID\",\"pt_BR\":\"ID do catálogo\",\"ja_JP\":\"カタログ ID\",\"fr_FR\":\"ID catalogue\",\"hu_HU\":\"Katalógusazonosító\",\"de_DE\":\"Katalog-ID\",\"ca_ES\":\"ID del catàleg\",\"ar_SA\":\"معرف الكتالوج\",\"fi_FI\":\"Luettelon tunnus\",\"en_US\":\"Catalog ID\",\"zh_CN\":\"目录 ID\",\"es_ES\":\"Identificador del catálogo\",\"nl_NL\":\"Catalogus-ID\"}}'),
(31457,0,64463788232944,0,NULL,'2024-11-21 12:19:17.350000','ADD','com.liferay.object.model.ObjectField','30616',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"description\",\"DBColumnName\":\"description\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Beskrivning\",\"pt_BR\":\"Descrição\",\"ja_JP\":\"説明\",\"fr_FR\":\"Description\",\"hu_HU\":\"Leírás\",\"de_DE\":\"Beschreibung\",\"ca_ES\":\"Descripció\",\"ar_SA\":\"الوصف\",\"fi_FI\":\"Kuvaus\",\"en_US\":\"Description\",\"zh_CN\":\"描述\",\"es_ES\":\"Descripción\",\"nl_NL\":\"Beschrijving\"}}'),
(31458,0,64463788232944,0,NULL,'2024-11-21 12:19:17.353000','ADD','com.liferay.object.model.ObjectField','30617',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"name\",\"DBColumnName\":\"name\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Namn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名前\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Név\",\"de_DE\":\"Name\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم\",\"fi_FI\":\"Nimi\",\"en_US\":\"Name\",\"zh_CN\":\"名称\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Naam\"}}'),
(31459,0,64463788232944,0,NULL,'2024-11-21 12:19:17.360000','ADD','com.liferay.object.model.ObjectField','30618',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"productId\",\"DBColumnName\":\"CPDefinitionId\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Produkt-ID\",\"pt_BR\":\"ID do Produto\",\"ja_JP\":\"製品ID\",\"fr_FR\":\"ID de produit\",\"hu_HU\":\"Termékazonosító\",\"de_DE\":\"Produkt-ID\",\"ca_ES\":\"ID de producte\",\"ar_SA\":\"معرِّف المنتج\",\"fi_FI\":\"Tuotteen Tunnus\",\"en_US\":\"Product ID\",\"zh_CN\":\"产品 ID\",\"es_ES\":\"ID de producto\",\"nl_NL\":\"Product-ID\"}}'),
(31460,0,64463788232944,0,NULL,'2024-11-21 12:19:17.368000','ADD','com.liferay.object.model.ObjectField','30619',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"productType\",\"DBColumnName\":\"productType\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Produkttyp\",\"pt_BR\":\"Tipo de Produto\",\"ja_JP\":\"製品種類\",\"fr_FR\":\"Type de produit\",\"hu_HU\":\"Termék típusa\",\"de_DE\":\"Produktart\",\"ca_ES\":\"Tipus de producte\",\"ar_SA\":\"نوع المنتج\",\"fi_FI\":\"Tuotteen Tyyppi\",\"en_US\":\"Product Type\",\"zh_CN\":\"产品类型\",\"es_ES\":\"Tipo de producto\",\"nl_NL\":\"Producttype\"}}'),
(31461,0,64463788232944,0,NULL,'2024-11-21 12:19:17.374000','ADD','com.liferay.object.model.ObjectField','30620',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"shortDescription\",\"DBColumnName\":\"shortDescription\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Översiktsbeskrivning\",\"pt_BR\":\"Descrição curta\",\"ja_JP\":\"説明\",\"fr_FR\":\"Description Courte\",\"hu_HU\":\"Rövid leírás\",\"de_DE\":\"Kurze Beschreibung\",\"ca_ES\":\"Descripció breu\",\"ar_SA\":\"الوصف المختصر\",\"fi_FI\":\"Lyhyt kuvaus\",\"en_US\":\"Short Description\",\"zh_CN\":\"简短的描述\",\"es_ES\":\"Descripción Corta\",\"nl_NL\":\"Korte beschrijving\"}}'),
(31462,0,64463788232944,0,NULL,'2024-11-21 12:19:17.381000','ADD','com.liferay.object.model.ObjectField','30621',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"skuFormatted\",\"DBColumnName\":\"skuFormatted\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Artikelnr\",\"pt_BR\":\"SKU\",\"ja_JP\":\"SKU\",\"fr_FR\":\"Unité de gestion des stocks (SKU)\",\"hu_HU\":\"SKU (leltári azonosító)\",\"de_DE\":\"SKU\",\"ca_ES\":\"referència\",\"ar_SA\":\"رمز الصنف التعريفي\",\"fi_FI\":\"SKU:t\",\"en_US\":\"SKU\",\"zh_CN\":\"SKU\",\"es_ES\":\"Ref.\",\"nl_NL\":\"Artikelnummer\"}}'),
(31463,0,64463788232944,0,NULL,'2024-11-21 12:19:17.390000','ADD','com.liferay.object.model.ObjectField','30622',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"thumbnail\",\"DBColumnName\":\"thumbnail\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Miniatyrskiss\",\"pt_BR\":\"Miniatura\",\"ja_JP\":\"サムネイル\",\"fr_FR\":\"Miniature\",\"hu_HU\":\"Parancsikon\",\"de_DE\":\"Miniaturansicht\",\"ca_ES\":\"Miniatura\",\"ar_SA\":\"صورة مصغّرة\",\"fi_FI\":\"Pienikuva\",\"en_US\":\"Thumbnail\",\"zh_CN\":\"缩略图\",\"es_ES\":\"Vista en miniatura\",\"nl_NL\":\"Miniatuurafbeelding\"}}'),
(31464,0,64463788232944,0,NULL,'2024-11-21 12:19:17.393000','ADD','com.liferay.object.model.ObjectField','30623',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"uuid\",\"DBColumnName\":\"uuid\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"UUID\",\"pt_BR\":\"UUID\",\"ja_JP\":\"UUID\",\"fr_FR\":\"UUID (IDentifiant Unique Universel)\",\"hu_HU\":\"UUID\",\"de_DE\":\"UUID\",\"ca_ES\":\"UUID\",\"ar_SA\":\"UUID\",\"fi_FI\":\"UUID\",\"en_US\":\"UUID\",\"zh_CN\":\"通用唯一标识符\",\"es_ES\":\"UUID\",\"nl_NL\":\"UUID\"}}'),
(31465,0,64463788232944,0,NULL,'2024-11-21 12:19:17.408000','UPDATE','com.liferay.object.model.ObjectDefinition','30607',NULL,NULL,NULL,NULL,0,NULL,'{\"attributes\":[{\"newValue\":\"30617\",\"name\":\"titleObjectFieldId\",\"oldValue\":\"0\"}]}'),
(31466,0,64463788232944,0,NULL,'2024-11-21 12:19:18.384000','ADD','com.liferay.object.model.ObjectDefinition','30625',NULL,NULL,NULL,NULL,0,NULL,'{\"scope\":\"company\",\"name\":\"CommerceOrder\",\"active\":true,\"labelMap\":{\"sv_SE\":\"Handelsbeställning\",\"pt_BR\":\"Pedido do comércio\",\"ja_JP\":\"コマース注文\",\"fr_FR\":\"Commande commerciale\",\"hu_HU\":\"Kereskedelmi rendelés\",\"de_DE\":\"Handelsbestellung\",\"ca_ES\":\"Comanda de comerç\",\"ar_SA\":\"طلب تجاري\",\"fi_FI\":\"Kauppatilaus\",\"en_US\":\"Commerce Order\",\"zh_CN\":\"商务订单\",\"es_ES\":\"Pedido de comercio\",\"nl_NL\":\"Handelsorder\"}}'),
(31467,0,64463788232944,0,NULL,'2024-11-21 12:19:18.394000','ADD','com.liferay.object.model.ObjectField','30626',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31468,0,64463788232944,0,NULL,'2024-11-21 12:19:18.399000','ADD','com.liferay.object.model.ObjectField','30627',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31469,0,64463788232944,0,NULL,'2024-11-21 12:19:18.404000','ADD','com.liferay.object.model.ObjectField','30628',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31470,0,64463788232944,0,NULL,'2024-11-21 12:19:18.408000','ADD','com.liferay.object.model.ObjectField','30629',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"commerceOrderId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31471,0,64463788232944,0,NULL,'2024-11-21 12:19:18.412000','ADD','com.liferay.object.model.ObjectField','30630',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31472,0,64463788232944,0,NULL,'2024-11-21 12:19:18.417000','ADD','com.liferay.object.model.ObjectField','30631',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31473,0,64463788232944,0,NULL,'2024-11-21 12:19:18.426000','ADD','com.liferay.object.model.ObjectField','30632',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"accountId\",\"DBColumnName\":\"accountId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Konto-ID\",\"pt_BR\":\"ID de conta\",\"ja_JP\":\"アカウントID\",\"fr_FR\":\"ID du compte\",\"hu_HU\":\"Fiókazonosító\",\"de_DE\":\"Konto-ID\",\"ca_ES\":\"ID del compte\",\"ar_SA\":\"معرف الحساب\",\"fi_FI\":\"Tilinumero\",\"en_US\":\"Account ID\",\"zh_CN\":\"帐户 ID\",\"es_ES\":\"Identificador de cuenta\",\"nl_NL\":\"Account-ID\"}}'),
(31474,0,64463788232944,0,NULL,'2024-11-21 12:19:18.436000','ADD','com.liferay.object.model.ObjectField','30633',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"channelId\",\"DBColumnName\":\"channelId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Kanal-ID\",\"pt_BR\":\"ID do canal\",\"ja_JP\":\"チャンネルID\",\"fr_FR\":\"ID de canal\",\"hu_HU\":\"Csatornaazonosító\",\"de_DE\":\"Kanal-ID\",\"ca_ES\":\"ID de canal\",\"ar_SA\":\"معرف القناة\",\"fi_FI\":\"Kanavan ID\",\"en_US\":\"Channel ID\",\"zh_CN\":\"渠道 ID\",\"es_ES\":\"Identificador de canal\",\"nl_NL\":\"Kanaal-ID\"}}'),
(31475,0,64463788232944,0,NULL,'2024-11-21 12:19:18.445000','ADD','com.liferay.object.model.ObjectField','30634',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"currencyCode\",\"DBColumnName\":\"currencyCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Valutakod\",\"pt_BR\":\"Código da moeda\",\"ja_JP\":\"通貨コード\",\"fr_FR\":\"Code devise\",\"hu_HU\":\"Pénznemkód\",\"de_DE\":\"Währungscode\",\"ca_ES\":\"Codi de moneda\",\"ar_SA\":\"رمز العملة\",\"fi_FI\":\"Valuuttatunnus\",\"en_US\":\"Currency Code\",\"zh_CN\":\"货币代码\",\"es_ES\":\"Código de divisa\",\"nl_NL\":\"Valutacode\"}}'),
(31476,0,64463788232944,0,NULL,'2024-11-21 12:19:18.454000','ADD','com.liferay.object.model.ObjectField','30635',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"orderDate\",\"DBColumnName\":\"orderDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Ordna efter datum\",\"pt_BR\":\"Data do Pedido\",\"ja_JP\":\"注文日\",\"fr_FR\":\"Date de commande\",\"hu_HU\":\"Rendezési dátum\",\"de_DE\":\"Auftragsdatum\",\"ca_ES\":\"Ordena per data\",\"ar_SA\":\"تاريخ الطلب\",\"fi_FI\":\"Tilauspäivämäärä\",\"en_US\":\"Order Date\",\"zh_CN\":\"排序日期\",\"es_ES\":\"Fecha del pedido\",\"nl_NL\":\"Besteldatum\"}}'),
(31477,0,64463788232944,0,NULL,'2024-11-21 12:19:18.464000','ADD','com.liferay.object.model.ObjectField','30636',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"orderStatus\",\"DBColumnName\":\"orderStatus\",\"DBType\":\"Integer\",\"businessType\":\"Integer\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Orderstatus\",\"pt_BR\":\"Status do pedido\",\"ja_JP\":\"注文ステータス\",\"fr_FR\":\"Statut de la commande\",\"hu_HU\":\"Rendelés állapota\",\"de_DE\":\"Bestellungsstatus\",\"ca_ES\":\"Estat de la comanda\",\"ar_SA\":\"حالة الطلب\",\"fi_FI\":\"Tilauksen Tila\",\"en_US\":\"Order Status\",\"zh_CN\":\"订单状态\",\"es_ES\":\"Estado del pedido\",\"nl_NL\":\"Orderstatus\"}}'),
(31478,0,64463788232944,0,NULL,'2024-11-21 12:19:18.472000','ADD','com.liferay.object.model.ObjectField','30637',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"orderTypeExternalReferenceCode\",\"DBColumnName\":\"orderTypeExternalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"orderTypeExternalReferenceCode\",\"pt_BR\":\"orderTypeExternalReferenceCode\",\"ja_JP\":\"orderTypeExternalReferenceCode\",\"fr_FR\":\"orderTypeExternalReferenceCode\",\"hu_HU\":\"orderTypeExternalReferenceCode\",\"de_DE\":\"orderTypeExternalReferenceCode\",\"ca_ES\":\"orderTypeExternalReferenceCode\",\"ar_SA\":\"orderTypeExternalReferenceCode\",\"fi_FI\":\"orderTypeExternalReferenceCode\",\"en_US\":\"orderTypeExternalReferenceCode\",\"zh_CN\":\"orderTypeExternalReferenceCode\",\"es_ES\":\"orderTypeExternalReferenceCode\",\"nl_NL\":\"orderTypeExternalReferenceCode\"}}'),
(31479,0,64463788232944,0,NULL,'2024-11-21 12:19:18.481000','ADD','com.liferay.object.model.ObjectField','30638',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"orderTypeId\",\"DBColumnName\":\"orderTypeId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Ordertyp-ID\",\"pt_BR\":\"ID do tipos de pedido\",\"ja_JP\":\"注文タイプ ID\",\"fr_FR\":\"ID type de commande\",\"hu_HU\":\"Rendeléstípus azonosítója\",\"de_DE\":\"Bestellungstyp-ID\",\"ca_ES\":\"ID del tipus de comanda\",\"ar_SA\":\"معرف نوع الأمر\",\"fi_FI\":\"Tilaustyypin tunnus\",\"en_US\":\"Order Type ID\",\"zh_CN\":\"订单类型 ID\",\"es_ES\":\"Identificador del tipo de pedido\",\"nl_NL\":\"ID bestellingtype\"}}'),
(31480,0,64463788232944,0,NULL,'2024-11-21 12:19:18.491000','ADD','com.liferay.object.model.ObjectField','30639',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"shippingAmount\",\"DBColumnName\":\"shippingAmount\",\"DBType\":\"BigDecimal\",\"businessType\":\"PrecisionDecimal\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Leveransbelopp\",\"pt_BR\":\"Valor do frete\",\"ja_JP\":\"配送金額\",\"fr_FR\":\"Montant de la livraison\",\"hu_HU\":\"Szállítási díj\",\"de_DE\":\"Versandkosten\",\"ca_ES\":\"Import de l\'enviament\",\"ar_SA\":\"مبلغ الشحن\",\"fi_FI\":\"Toimituskulut\",\"en_US\":\"Shipping Amount\",\"zh_CN\":\"配送金额\",\"es_ES\":\"Gastos de envío\",\"nl_NL\":\"Verzendkosten\"}}'),
(31481,0,64463788232944,0,NULL,'2024-11-21 12:19:18.500000','ADD','com.liferay.object.model.ObjectField','30640',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"shippingAmountFormatted\",\"DBColumnName\":\"shippingAmountFormatted\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Formaterat leveransbelopp\",\"pt_BR\":\"Quantidade de envio formatada\",\"ja_JP\":\"書式付き配送金額\",\"fr_FR\":\"Montant d\'expédition formaté\",\"hu_HU\":\"Formázott szállítási összeg\",\"de_DE\":\"Formatierter Versandbetrag\",\"ca_ES\":\"Import de l\'entrega formatat\",\"ar_SA\":\"مبلغ الشحن المنسق\",\"fi_FI\":\"Muotoiltu toimitussumma\",\"en_US\":\"Formatted Shipping Amount\",\"zh_CN\":\"格式化配送金额\",\"es_ES\":\"Importe de envío con formato\",\"nl_NL\":\"Geformatteerd bedrag verzending\"}}'),
(31482,0,64463788232944,0,NULL,'2024-11-21 12:19:18.509000','ADD','com.liferay.object.model.ObjectField','30641',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"taxAmount\",\"DBColumnName\":\"taxAmount\",\"DBType\":\"BigDecimal\",\"businessType\":\"PrecisionDecimal\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Momsbelopp\",\"pt_BR\":\"Qtd de imposto\",\"ja_JP\":\"税額\",\"fr_FR\":\"Montant des taxes\",\"hu_HU\":\"Adó összege\",\"de_DE\":\"Steuerbetrag\",\"ca_ES\":\"Import dels impostos\",\"ar_SA\":\"مبلغ الضريبة\",\"fi_FI\":\"Verosumma\",\"en_US\":\"Tax Amount\",\"zh_CN\":\"税额\",\"es_ES\":\"Importe de impuestos\",\"nl_NL\":\"Belastingbedrag\"}}'),
(31483,0,64463788232944,0,NULL,'2024-11-21 12:19:18.523000','ADD','com.liferay.object.model.ObjectField','30642',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"taxAmountFormatted\",\"DBColumnName\":\"taxAmountFormatted\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"formatted-tax-amount\",\"pt_BR\":\"formatted-tax-amount\",\"ja_JP\":\"formatted-tax-amount\",\"fr_FR\":\"formatted-tax-amount\",\"hu_HU\":\"formatted-tax-amount\",\"de_DE\":\"formatted-tax-amount\",\"ca_ES\":\"formatted-tax-amount\",\"ar_SA\":\"formatted-tax-amount\",\"fi_FI\":\"formatted-tax-amount\",\"en_US\":\"formatted-tax-amount\",\"zh_CN\":\"formatted-tax-amount\",\"es_ES\":\"formatted-tax-amount\",\"nl_NL\":\"formatted-tax-amount\"}}'),
(31484,0,64463788232944,0,NULL,'2024-11-21 12:19:18.533000','ADD','com.liferay.object.model.ObjectField','30643',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"total\",\"DBColumnName\":\"total\",\"DBType\":\"BigDecimal\",\"businessType\":\"PrecisionDecimal\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Totalt\",\"pt_BR\":\"Total\",\"ja_JP\":\"合計\",\"fr_FR\":\"Total\",\"hu_HU\":\"Összesen\",\"de_DE\":\"Gesamt\",\"ca_ES\":\"Total\",\"ar_SA\":\"مجمل\",\"fi_FI\":\"Yhteensä\",\"en_US\":\"Total\",\"zh_CN\":\"总计\",\"es_ES\":\"Total\",\"nl_NL\":\"Totaal\"}}'),
(31485,0,64463788232944,0,NULL,'2024-11-21 12:19:18.542000','ADD','com.liferay.object.model.ObjectField','30644',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"totalFormatted\",\"DBColumnName\":\"totalFormatted\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Formaterad totalsumma\",\"pt_BR\":\"Quantidade de total formatada\",\"ja_JP\":\"書式付き合計金額\",\"fr_FR\":\"Montant total formaté\",\"hu_HU\":\"Formázott végösszeg\",\"de_DE\":\"Formatierte Gesamtsumme\",\"ca_ES\":\"Import total formatat\",\"ar_SA\":\"المبلغ الإجمالي المنسق\",\"fi_FI\":\"Muotoiltu kokonaissumma\",\"en_US\":\"Formatted Total Amount\",\"zh_CN\":\"格式化总金额\",\"es_ES\":\"Importe total con formato\",\"nl_NL\":\"Geformatteerd bedrag totaal\"}}'),
(31486,0,64463788232944,0,NULL,'2024-11-21 12:19:18.549000','UPDATE','com.liferay.object.model.ObjectDefinition','30625',NULL,NULL,NULL,NULL,0,NULL,'{\"attributes\":[{\"newValue\":\"30629\",\"name\":\"titleObjectFieldId\",\"oldValue\":\"0\"}]}'),
(31487,0,64463788232944,0,NULL,'2024-11-21 12:19:20.071000','ADD','com.liferay.object.model.ObjectDefinition','30646',NULL,NULL,NULL,NULL,0,NULL,'{\"scope\":\"company\",\"name\":\"CommerceOrderItem\",\"active\":true,\"labelMap\":{\"sv_SE\":\"Orderartikel för handel\",\"pt_BR\":\"Itens do pedido do comércio\",\"ja_JP\":\"コマースの注文商品\",\"fr_FR\":\"Article de commande commerciale\",\"hu_HU\":\"Kereskedelmi rendelés eleme\",\"de_DE\":\"Handelsauftragsposition\",\"ca_ES\":\"Article de comanda de comerç\",\"ar_SA\":\"عناصر الطلب التجاري\",\"fi_FI\":\"Kauppatilauksen Tuote\",\"en_US\":\"Commerce Order Item\",\"zh_CN\":\"商务订单条目\",\"es_ES\":\"Artículo de pedido de comercio\",\"nl_NL\":\"Handelsorderitem\"}}'),
(31488,0,64463788232944,0,NULL,'2024-11-21 12:19:20.085000','ADD','com.liferay.object.model.ObjectField','30647',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(31489,0,64463788232944,0,NULL,'2024-11-21 12:19:20.096000','ADD','com.liferay.object.model.ObjectField','30648',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(31490,0,64463788232944,0,NULL,'2024-11-21 12:19:20.103000','ADD','com.liferay.object.model.ObjectField','30649',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(31491,0,64463788232944,0,NULL,'2024-11-21 12:19:20.110000','ADD','com.liferay.object.model.ObjectField','30650',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"commerceOrderItemId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(31492,0,64463788232944,0,NULL,'2024-11-21 12:19:20.116000','ADD','com.liferay.object.model.ObjectField','30651',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(31493,0,64463788232944,0,NULL,'2024-11-21 12:19:20.120000','ADD','com.liferay.object.model.ObjectField','30652',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(31494,0,64463788232944,0,NULL,'2024-11-21 12:19:20.129000','ADD','com.liferay.object.model.ObjectField','30653',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"orderId\",\"DBColumnName\":\"orderId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"sv_SE\":\"Sortera på\",\"pt_BR\":\"ID do Pedido\",\"ja_JP\":\"オーダーID\",\"fr_FR\":\"Id de commande\",\"hu_HU\":\"Rendelés azonosító\",\"de_DE\":\"Auftragsnummer\",\"ca_ES\":\"Ordena per Id\",\"ar_SA\":\"الترتيب حسب\",\"fi_FI\":\"Tilaus ID\",\"en_US\":\"Order ID\",\"zh_CN\":\"订单编号\",\"es_ES\":\"Identificador de pedido\",\"nl_NL\":\"Op ID sorteren\"}}'),
(31495,0,64463788232944,0,NULL,'2024-11-21 12:19:20.133000','ADD','com.liferay.object.model.ObjectField','30654',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"sku\",\"DBColumnName\":\"sku\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Artikelnr\",\"pt_BR\":\"SKU\",\"ja_JP\":\"SKU\",\"fr_FR\":\"Unité de gestion des stocks (SKU)\",\"hu_HU\":\"SKU (leltári azonosító)\",\"de_DE\":\"SKU\",\"ca_ES\":\"referència\",\"ar_SA\":\"رمز الصنف التعريفي\",\"fi_FI\":\"SKU:t\",\"en_US\":\"SKU\",\"zh_CN\":\"SKU\",\"es_ES\":\"Ref.\",\"nl_NL\":\"Artikelnummer\"}}'),
(31496,0,64463788232944,0,NULL,'2024-11-21 12:19:20.137000','ADD','com.liferay.object.model.ObjectField','30655',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"name\",\"DBColumnName\":\"name\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Namn\",\"pt_BR\":\"Nome\",\"ja_JP\":\"名前\",\"fr_FR\":\"Nom\",\"hu_HU\":\"Név\",\"de_DE\":\"Name\",\"ca_ES\":\"Nom\",\"ar_SA\":\"الإسم\",\"fi_FI\":\"Nimi\",\"en_US\":\"Name\",\"zh_CN\":\"名称\",\"es_ES\":\"Nombre\",\"nl_NL\":\"Naam\"}}'),
(31497,0,64463788232944,0,NULL,'2024-11-21 12:19:20.147000','ADD','com.liferay.object.model.ObjectField','30656',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"unitOfMeasureKey\",\"DBColumnName\":\"unitOfMeasureKey\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Måttenhet\",\"pt_BR\":\"Unidade de medida\",\"ja_JP\":\"測定単位\",\"fr_FR\":\"Unité de mesure\",\"hu_HU\":\"Mértékegység\",\"de_DE\":\"Maßeinheit\",\"ca_ES\":\"Unitat de mesura\",\"ar_SA\":\"وحدة القياس\",\"fi_FI\":\"Mittayksikkö\",\"en_US\":\"Unit of Measure\",\"zh_CN\":\"计量单位\",\"es_ES\":\"Unidad de medida\",\"nl_NL\":\"Meeteenheid\"}}'),
(31498,0,64463788232944,0,NULL,'2024-11-21 12:19:20.156000','ADD','com.liferay.object.model.ObjectField','30657',NULL,NULL,NULL,NULL,0,NULL,'{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"unitPrice\",\"DBColumnName\":\"unitPrice\",\"DBType\":\"BigDecimal\",\"businessType\":\"PrecisionDecimal\",\"required\":true,\"labelMap\":{\"sv_SE\":\"Enhetspris\",\"pt_BR\":\"Preço Unitário\",\"ja_JP\":\"単価\",\"fr_FR\":\"Prix \\u200b\\u200bunitaire\",\"hu_HU\":\"Egységár\",\"de_DE\":\"Stückpreis\",\"ca_ES\":\"Preu unitari\",\"ar_SA\":\"سعر الوحدة\",\"fi_FI\":\"Yksikköhinta\",\"en_US\":\"Unit Price\",\"zh_CN\":\"单价\",\"es_ES\":\"Precio unitario\",\"nl_NL\":\"Eenheidsprijs\"}}'),
(31499,0,64463788232944,0,NULL,'2024-11-21 12:19:20.163000','UPDATE','com.liferay.object.model.ObjectDefinition','30646',NULL,NULL,NULL,NULL,0,NULL,'{\"attributes\":[{\"newValue\":\"30650\",\"name\":\"titleObjectFieldId\",\"oldValue\":\"0\"}]}'),
(32113,0,64463788232944,0,NULL,'2024-11-21 12:51:57.132000','UPDATE','com.liferay.portal.kernel.model.User','20123',NULL,'127.0.0.1','127.0.0.1','localhost',8080,'E63D9CCB7E0C4FC5F9B6E0EC16D7B34E','{\"attributes\":[{\"newValue\":\"test@test.com\",\"name\":\"emailAddress\",\"oldValue\":\"test@liferay.com\"}]}'),
(32211,0,64463788232944,20123,'Test Test','2024-11-21 12:57:07.142000','UPDATE','com.liferay.portal.kernel.model.User','20123',NULL,'127.0.0.1','127.0.0.1','localhost',8080,'E63D9CCB7E0C4FC5F9B6E0EC16D7B34E','{\"attributes\":[{\"newValue\":\"true\",\"name\":\"agreedToTermsOfUse\",\"oldValue\":\"false\"}]}'),
(32212,0,64463788232944,20123,'Test Test','2024-11-21 12:57:25.156000','UPDATE','com.liferay.portal.kernel.model.User','20123',NULL,'127.0.0.1','127.0.0.1','localhost',8080,'E63D9CCB7E0C4FC5F9B6E0EC16D7B34E','{\"attributes\":[{\"newValue\":\"\",\"name\":\"password\",\"oldValue\":\"\"}]}'),
(32213,0,64463788232944,20123,'Test Test','2024-11-21 12:57:38.794000','UPDATE','com.liferay.portal.kernel.model.User','20123',NULL,'127.0.0.1','127.0.0.1','localhost',8080,'A17D45623D983EFC0A2809F876279611','{\"attributes\":[{\"newValue\":\"what-is-your-father\'s-middle-name\",\"name\":\"reminderQueryQuestion\",\"oldValue\":\"\"},{\"newValue\":\"\",\"name\":\"reminderQueryAnswer\",\"oldValue\":\"\"}]}'),
(32225,0,64463788232944,20123,'Test Test','2024-11-22 12:18:16.863000','ADD','com.liferay.portal.kernel.model.User','32220',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'1A2D22E1761260C9E13157A7E3F45D06','{\"emailAddress\":\"fred@fred.com\",\"screenName\":\"fred\",\"userName\":\"Fred Flint\",\"userId\":\"32220\"}'),
(32226,0,64463788232944,20123,'Test Test','2024-11-22 12:18:18.556000','UPDATE','com.liferay.portal.kernel.model.User','32220',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'1A2D22E1761260C9E13157A7E3F45D06','{\"attributes\":[{\"newValue\":\"\",\"name\":\"password\",\"oldValue\":\"\"}]}'),
(32227,0,64463788232944,20123,'Test Test','2024-11-22 12:18:19.675000','UPDATE','com.liferay.portal.kernel.model.User','32220',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'1A2D22E1761260C9E13157A7E3F45D06','{\"attributes\":[{\"newValue\":\"true\",\"name\":\"active\",\"oldValue\":\"false\"}]}'),
(32309,0,64463788232944,20123,'Test Test','2024-11-26 13:43:11.990000','ADD','com.liferay.portal.kernel.model.User','32303',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'8735BB67D9AFED815E8CB416BBB039CE','{\"emailAddress\":\"Anonymous64463788232944_1@test.com\",\"screenName\":\"Anonymous64463788232944_1\",\"userName\":\"Anonymous Anonymous\",\"userId\":\"32303\"}'),
(32310,0,64463788232944,20123,'Test Test','2024-11-26 13:44:08.842000','ADD','com.liferay.portal.kernel.model.Organization','32306',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'8735BB67D9AFED815E8CB416BBB039CE','{}'),
(32609,0,64463788232944,20123,'Test Test','2024-12-04 13:19:59.527000','ADD','com.liferay.portal.kernel.model.User','32603',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'E11F838ECB59C263214169DA305000BC','{\"emailAddress\":\"none@none.com\",\"screenName\":\"rocksellermanager\",\"userName\":\"Seller Manager\",\"userId\":\"32603\"}'),
(32610,0,64463788232944,20123,'Test Test','2024-12-04 13:20:01.522000','UPDATE','com.liferay.portal.kernel.model.User','32603',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'E11F838ECB59C263214169DA305000BC','{\"attributes\":[{\"newValue\":\"\",\"name\":\"password\",\"oldValue\":\"\"}]}'),
(32611,0,64463788232944,20123,'Test Test','2024-12-04 13:20:02.661000','UPDATE','com.liferay.portal.kernel.model.User','32603',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'E11F838ECB59C263214169DA305000BC','{\"attributes\":[{\"newValue\":\"true\",\"name\":\"active\",\"oldValue\":\"false\"}]}'),
(33213,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.632000','UPDATE','com.liferay.object.model.ObjectDefinition','30045',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33214,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.661000','UPDATE','com.liferay.object.model.ObjectDefinition','30055',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33215,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.669000','UPDATE','com.liferay.object.model.ObjectDefinition','30066',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33216,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.676000','UPDATE','com.liferay.object.model.ObjectDefinition','30076',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33217,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.692000','UPDATE','com.liferay.object.model.ObjectDefinition','30091',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33218,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.703000','UPDATE','com.liferay.object.model.ObjectDefinition','30607',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33219,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.724000','UPDATE','com.liferay.object.model.ObjectDefinition','30625',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33220,0,64463788232944,20123,'Test Test','2025-01-07 14:04:30.738000','UPDATE','com.liferay.object.model.ObjectDefinition','30646',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33221,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.232000','ADD','com.liferay.object.model.ObjectDefinition','33205',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"scope\":\"company\",\"name\":\"C_Rock\",\"active\":false,\"labelMap\":{\"en_US\":\"Rock\"}}'),
(33222,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.278000','ADD','com.liferay.object.model.ObjectField','33206',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(33223,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.299000','ADD','com.liferay.object.model.ObjectField','33207',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(33224,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.304000','ADD','com.liferay.object.model.ObjectField','33208',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(33225,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.309000','ADD','com.liferay.object.model.ObjectField','33209',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"objectEntryId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(33226,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.319000','ADD','com.liferay.object.model.ObjectField','33210',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(33227,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.324000','ADD','com.liferay.object.model.ObjectField','33211',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(33228,0,64463788232944,20123,'Test Test','2025-01-07 14:05:20.332000','UPDATE','com.liferay.object.model.ObjectDefinition','33205',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[{\"newValue\":\"33209\",\"name\":\"titleObjectFieldId\",\"oldValue\":\"0\"}]}'),
(33231,0,64463788232944,20123,'Test Test','2025-01-07 14:09:05.968000','ADD','com.liferay.object.model.ObjectField','33229',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"en_US\",\"name\":\"name\",\"DBColumnName\":\"name_\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"en_US\":\"Name\"}}'),
(33232,0,64463788232944,20123,'Test Test','2025-01-07 14:09:05.976000','ADD','com.liferay.object.model.ObjectFieldSetting','33230',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"name\":\"uniqueValues\",\"objectFieldId\":\"33229\",\"value\":\"true\"}'),
(33243,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.372000','ADD','com.liferay.object.model.ObjectDefinition','33233',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"scope\":\"company\",\"name\":\"C_Mineral\",\"active\":false,\"labelMap\":{\"en_US\":\"Mineral\"}}'),
(33244,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.388000','ADD','com.liferay.object.model.ObjectField','33234',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"creator\",\"DBColumnName\":\"userName\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Author\"}}'),
(33245,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.399000','ADD','com.liferay.object.model.ObjectField','33235',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"createDate\",\"DBColumnName\":\"createDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Create Date\"}}'),
(33246,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.409000','ADD','com.liferay.object.model.ObjectField','33236',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"externalReferenceCode\",\"DBColumnName\":\"externalReferenceCode\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"External Reference Code\"}}'),
(33247,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.426000','ADD','com.liferay.object.model.ObjectField','33237',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":true,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"id\",\"DBColumnName\":\"objectEntryId\",\"DBType\":\"Long\",\"businessType\":\"LongInteger\",\"required\":false,\"labelMap\":{\"en_US\":\"ID\"}}'),
(33248,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.433000','ADD','com.liferay.object.model.ObjectField','33238',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"modifiedDate\",\"DBColumnName\":\"modifiedDate\",\"DBType\":\"Date\",\"businessType\":\"Date\",\"required\":false,\"labelMap\":{\"en_US\":\"Modified Date\"}}'),
(33249,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.439000','ADD','com.liferay.object.model.ObjectField','33239',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":false,\"indexedLanguageId\":\"\",\"name\":\"status\",\"DBColumnName\":\"status\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":false,\"labelMap\":{\"en_US\":\"Status\"}}'),
(33250,0,64463788232944,20123,'Test Test','2025-01-07 14:10:32.448000','UPDATE','com.liferay.object.model.ObjectDefinition','33233',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[{\"newValue\":\"33237\",\"name\":\"titleObjectFieldId\",\"oldValue\":\"0\"}]}'),
(33251,0,64463788232944,20123,'Test Test','2025-01-07 14:11:01.630000','ADD','com.liferay.object.model.ObjectField','33241',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"en_US\",\"name\":\"name\",\"DBColumnName\":\"name_\",\"DBType\":\"String\",\"businessType\":\"Text\",\"required\":true,\"labelMap\":{\"en_US\":\"Name\"}}'),
(33252,0,64463788232944,20123,'Test Test','2025-01-07 14:11:01.635000','ADD','com.liferay.object.model.ObjectFieldSetting','33242',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"name\":\"uniqueValues\",\"objectFieldId\":\"33241\",\"value\":\"true\"}'),
(33257,0,64463788232944,20123,'Test Test','2025-01-07 14:12:45.131000','ADD','com.liferay.object.model.ObjectField','33254',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"indexedAsKeyword\":false,\"listTypeDefinitionId\":\"0\",\"indexed\":true,\"indexedLanguageId\":\"\",\"name\":\"r_rockMineral_c_rockId\",\"DBColumnName\":\"r_rockMineral_c_rockId\",\"DBType\":\"Long\",\"businessType\":\"Relationship\",\"required\":false,\"labelMap\":{\"en_US\":\"RockMineral\"}}'),
(33258,0,64463788232944,20123,'Test Test','2025-01-07 14:12:45.132000','ADD','com.liferay.object.model.ObjectFieldSetting','33255',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"name\":\"objectDefinition1ShortName\",\"objectFieldId\":\"33254\",\"value\":\"Rock\"}'),
(33259,0,64463788232944,20123,'Test Test','2025-01-07 14:12:45.132000','ADD','com.liferay.object.model.ObjectFieldSetting','33256',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"name\":\"objectRelationshipERCObjectFieldName\",\"objectFieldId\":\"33254\",\"value\":\"r_rockMineral_c_rockERC\"}'),
(33260,0,64463788232944,20123,'Test Test','2025-01-07 14:12:45.136000','ADD','com.liferay.object.model.ObjectRelationship','33253',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"deletionType\":\"prevent\",\"labelMap\":{\"en_US\":\"RockMineral\"}}'),
(33261,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.331000','UPDATE','com.liferay.object.model.ObjectDefinition','30045',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33262,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.338000','UPDATE','com.liferay.object.model.ObjectDefinition','30055',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33263,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.344000','UPDATE','com.liferay.object.model.ObjectDefinition','30066',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33264,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.351000','UPDATE','com.liferay.object.model.ObjectDefinition','30076',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33265,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.357000','UPDATE','com.liferay.object.model.ObjectDefinition','30091',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33266,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.365000','UPDATE','com.liferay.object.model.ObjectDefinition','30607',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33267,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.372000','UPDATE','com.liferay.object.model.ObjectDefinition','30625',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33268,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.379000','UPDATE','com.liferay.object.model.ObjectDefinition','30646',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33269,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.385000','UPDATE','com.liferay.object.model.ObjectDefinition','33205',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33270,0,64463788232944,20123,'Test Test','2025-01-07 14:16:08.390000','UPDATE','com.liferay.object.model.ObjectDefinition','33233',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[]}'),
(33327,0,64463788232944,20123,'Test Test','2025-01-07 14:16:58.231000','UPDATE','com.liferay.object.model.ObjectDefinition','33205',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[{\"newValue\":\"true\",\"name\":\"active\",\"oldValue\":\"false\"}]}'),
(33328,0,64463788232944,20123,'Test Test','2025-01-07 14:16:59.176000','UPDATE','com.liferay.object.model.ObjectDefinition','33233',NULL,'192.168.2.96','192.168.2.96','localliferay',8080,'7DCDEE666E78A3F1B74926D37F96AFA6','{\"attributes\":[{\"newValue\":\"true\",\"name\":\"active\",\"oldValue\":\"false\"}]}');

--
-- Table structure for table `BackgroundTask`
--

CREATE TABLE `BackgroundTask` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `backgroundTaskId` 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(255) DEFAULT NULL,
  `servletContextNames` varchar(255) DEFAULT NULL,
  `taskExecutorClassName` varchar(200) DEFAULT NULL,
  `taskContextMap` longtext DEFAULT NULL,
  `completed` tinyint(4) DEFAULT NULL,
  `completionDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusMessage` longtext DEFAULT NULL,
  PRIMARY KEY (`backgroundTaskId`),
  KEY `IX_C5A6C78F` (`companyId`),
  KEY `IX_FBF5FAA2` (`completed`),
  KEY `IX_C71C3B7` (`groupId`,`status`),
  KEY `IX_F6136B70` (`groupId`,`taskExecutorClassName`,`completed`,`name`),
  KEY `IX_7FC3A8C9` (`groupId`,`taskExecutorClassName`,`name`),
  KEY `IX_7E757D70` (`groupId`,`taskExecutorClassName`,`status`),
  KEY `IX_75638CDF` (`status`),
  KEY `IX_2FCFE748` (`taskExecutorClassName`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BackgroundTask`
--


--
-- Table structure for table `BatchEngineExportTask`
--

CREATE TABLE `BatchEngineExportTask` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `batchEngineExportTaskId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `callbackURL` varchar(255) DEFAULT NULL,
  `className` varchar(255) DEFAULT NULL,
  `content` longblob DEFAULT NULL,
  `contentType` varchar(75) DEFAULT NULL,
  `endTime` datetime(6) DEFAULT NULL,
  `errorMessage` longtext DEFAULT NULL,
  `fieldNames` longtext DEFAULT NULL,
  `executeStatus` varchar(75) DEFAULT NULL,
  `parameters` longtext DEFAULT NULL,
  `processedItemsCount` int(11) DEFAULT NULL,
  `startTime` datetime(6) DEFAULT NULL,
  `taskItemDelegateName` varchar(75) DEFAULT NULL,
  `totalItemsCount` int(11) DEFAULT NULL,
  PRIMARY KEY (`batchEngineExportTaskId`),
  UNIQUE KEY `IX_EAC5DE50` (`companyId`,`externalReferenceCode`),
  KEY `IX_DADA545C` (`executeStatus`),
  KEY `IX_8B990859` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchEngineExportTask`
--


--
-- Table structure for table `BatchEngineImportTask`
--

CREATE TABLE `BatchEngineImportTask` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `batchEngineImportTaskId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `batchSize` bigint(20) DEFAULT NULL,
  `callbackURL` varchar(255) DEFAULT NULL,
  `className` varchar(255) DEFAULT NULL,
  `content` longblob DEFAULT NULL,
  `contentType` varchar(75) DEFAULT NULL,
  `endTime` datetime(6) DEFAULT NULL,
  `errorMessage` longtext DEFAULT NULL,
  `executeStatus` varchar(75) DEFAULT NULL,
  `fieldNameMapping` longtext DEFAULT NULL,
  `importStrategy` int(11) DEFAULT NULL,
  `operation` varchar(75) DEFAULT NULL,
  `parameters` longtext DEFAULT NULL,
  `processedItemsCount` int(11) DEFAULT NULL,
  `startTime` datetime(6) DEFAULT NULL,
  `taskItemDelegateName` varchar(75) DEFAULT NULL,
  `totalItemsCount` int(11) DEFAULT NULL,
  PRIMARY KEY (`batchEngineImportTaskId`),
  UNIQUE KEY `IX_2BBBB941` (`companyId`,`externalReferenceCode`),
  KEY `IX_ABC8050B` (`executeStatus`),
  KEY `IX_4FFDD808` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchEngineImportTask`
--


--
-- Table structure for table `BatchEngineImportTaskError`
--

CREATE TABLE `BatchEngineImportTaskError` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `batchEngineImportTaskErrorId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `batchEngineImportTaskId` bigint(20) DEFAULT NULL,
  `item` longtext DEFAULT NULL,
  `itemIndex` int(11) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  PRIMARY KEY (`batchEngineImportTaskErrorId`),
  KEY `IX_863EDEA9` (`batchEngineImportTaskId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchEngineImportTaskError`
--


--
-- Table structure for table `BatchPlannerMapping`
--

CREATE TABLE `BatchPlannerMapping` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `batchPlannerMappingId` 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,
  `batchPlannerPlanId` bigint(20) DEFAULT NULL,
  `externalFieldName` varchar(75) DEFAULT NULL,
  `externalFieldType` varchar(75) DEFAULT NULL,
  `internalFieldName` varchar(75) DEFAULT NULL,
  `internalFieldType` varchar(75) DEFAULT NULL,
  `script` longtext DEFAULT NULL,
  PRIMARY KEY (`batchPlannerMappingId`),
  UNIQUE KEY `IX_E025DC1A` (`batchPlannerPlanId`,`externalFieldName`,`internalFieldName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchPlannerMapping`
--


--
-- Table structure for table `BatchPlannerPlan`
--

CREATE TABLE `BatchPlannerPlan` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `batchPlannerPlanId` 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,
  `export` tinyint(4) DEFAULT NULL,
  `externalType` varchar(75) DEFAULT NULL,
  `externalURL` longtext DEFAULT NULL,
  `internalClassName` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `size_` int(11) DEFAULT NULL,
  `taskItemDelegateName` varchar(75) DEFAULT NULL,
  `total` int(11) DEFAULT NULL,
  `template` tinyint(4) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`batchPlannerPlanId`),
  KEY `IX_18CD7477` (`companyId`,`export`,`template`),
  KEY `IX_221A54A0` (`companyId`,`name`),
  KEY `IX_F2F05D4F` (`companyId`,`template`),
  KEY `IX_874FA8DB` (`companyId`,`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchPlannerPlan`
--


--
-- Table structure for table `BatchPlannerPolicy`
--

CREATE TABLE `BatchPlannerPolicy` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `batchPlannerPolicyId` 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,
  `batchPlannerPlanId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `value` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`batchPlannerPolicyId`),
  UNIQUE KEY `IX_A8E0209F` (`batchPlannerPlanId`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BatchPlannerPolicy`
--


--
-- Table structure for table `BlogsEntry`
--

CREATE TABLE `BlogsEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `entryId` 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` varchar(255) DEFAULT NULL,
  `subtitle` longtext DEFAULT NULL,
  `urlTitle` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `allowPingbacks` tinyint(4) DEFAULT NULL,
  `allowTrackbacks` tinyint(4) DEFAULT NULL,
  `trackbacks` longtext DEFAULT NULL,
  `coverImageCaption` longtext DEFAULT NULL,
  `coverImageFileEntryId` bigint(20) DEFAULT NULL,
  `coverImageURL` longtext DEFAULT NULL,
  `smallImage` tinyint(4) DEFAULT NULL,
  `smallImageFileEntryId` bigint(20) DEFAULT NULL,
  `smallImageId` bigint(20) 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 (`entryId`,`ctCollectionId`),
  UNIQUE KEY `IX_D05A3CBC` (`groupId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_D6281CFE` (`groupId`,`ctCollectionId`,`urlTitle`),
  UNIQUE KEY `IX_69B961AF` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_430D791F` (`companyId`,`displayDate`),
  KEY `IX_8CACE77B` (`companyId`,`userId`),
  KEY `IX_621E19D` (`groupId`,`displayDate`),
  KEY `IX_FBDE0AA3` (`groupId`,`userId`,`displayDate`),
  KEY `IX_7B596F05` (`status`,`companyId`,`displayDate`),
  KEY `IX_D1CC59D5` (`status`,`companyId`,`userId`),
  KEY `IX_67121F73` (`status`,`displayDate`),
  KEY `IX_EC9E1903` (`status`,`groupId`,`displayDate`),
  KEY `IX_6D777C09` (`status`,`groupId`,`userId`,`displayDate`),
  KEY `IX_69157A4D` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BlogsEntry`
--


--
-- Table structure for table `BookmarksEntry`
--

CREATE TABLE `BookmarksEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `entryId` 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,
  `folderId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `priority` 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 (`entryId`,`ctCollectionId`),
  UNIQUE KEY `IX_788BA343` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_1F90CA2D` (`companyId`),
  KEY `IX_5200100C` (`groupId`,`folderId`),
  KEY `IX_69D78EAC` (`groupId`,`status`,`folderId`,`userId`),
  KEY `IX_37518B0F` (`groupId`,`status`,`userId`),
  KEY `IX_F16A8A87` (`status`,`companyId`),
  KEY `IX_B670BA39` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BookmarksEntry`
--


--
-- Table structure for table `BookmarksFolder`
--

CREATE TABLE `BookmarksFolder` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` 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(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 (`folderId`,`ctCollectionId`),
  UNIQUE KEY `IX_F2715D9` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_2ABA25D7` (`companyId`),
  KEY `IX_D16018A6` (`groupId`,`parentFolderId`,`status`),
  KEY `IX_8C7A9C31` (`status`,`companyId`),
  KEY `IX_451E7AE3` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BookmarksFolder`
--


--
-- Table structure for table `BrowserTracker`
--

CREATE TABLE `BrowserTracker` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `browserTrackerId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `browserKey` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`browserTrackerId`),
  UNIQUE KEY `IX_E7B95510` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `BrowserTracker`
--


--
-- Table structure for table `CChannelAccountEntryRel`
--

CREATE TABLE `CChannelAccountEntryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `CChannelAccountEntryRelId` 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,
  `accountEntryId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `commerceChannelId` bigint(20) DEFAULT NULL,
  `overrideEligibility` tinyint(4) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  PRIMARY KEY (`CChannelAccountEntryRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_7451E203` (`commerceChannelId`,`type_`,`accountEntryId`,`classNameId`,`classPK`,`ctCollectionId`),
  KEY `IX_38280B2E` (`accountEntryId`),
  KEY `IX_5F765A4F` (`classNameId`,`classPK`),
  KEY `IX_E6E10CF1` (`commerceChannelId`,`type_`,`classNameId`,`classPK`),
  KEY `IX_52FD56CF` (`type_`,`accountEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CChannelAccountEntryRel`
--


--
-- Table structure for table `CDiscountCAccountGroupRel`
--

CREATE TABLE `CDiscountCAccountGroupRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CDiscountCAccountGroupRelId` 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,
  `commerceDiscountId` bigint(20) DEFAULT NULL,
  `commerceAccountGroupId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CDiscountCAccountGroupRelId`),
  UNIQUE KEY `IX_9D768AF5` (`commerceDiscountId`,`commerceAccountGroupId`),
  KEY `IX_F7FFBCCA` (`commerceAccountGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CDiscountCAccountGroupRel`
--


--
-- Table structure for table `CIAudit`
--

CREATE TABLE `CIAudit` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CIAuditId` 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,
  `logType` varchar(75) DEFAULT NULL,
  `logTypeSettings` longtext DEFAULT NULL,
  `quantity` decimal(30,16) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `unitOfMeasureKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CIAuditId`),
  KEY `IX_45C5C370` (`companyId`,`sku`,`unitOfMeasureKey`),
  KEY `IX_E7D143D9` (`createDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIAudit`
--


--
-- Table structure for table `CIBookedQuantity`
--

CREATE TABLE `CIBookedQuantity` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CIBookedQuantityId` 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,
  `bookedNote` varchar(75) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `quantity` decimal(30,16) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `unitOfMeasureKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CIBookedQuantityId`),
  KEY `IX_33BF9CB0` (`expirationDate`),
  KEY `IX_EB8535EA` (`sku`,`companyId`,`unitOfMeasureKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIBookedQuantity`
--


--
-- Table structure for table `CIReplenishmentItem`
--

CREATE TABLE `CIReplenishmentItem` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CIReplenishmentItemId` 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,
  `commerceInventoryWarehouseId` bigint(20) DEFAULT NULL,
  `availabilityDate` datetime(6) DEFAULT NULL,
  `quantity` decimal(30,16) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `unitOfMeasureKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CIReplenishmentItemId`),
  UNIQUE KEY `IX_3462AACC` (`companyId`,`externalReferenceCode`),
  KEY `IX_F588314` (`availabilityDate`),
  KEY `IX_967CACA8` (`commerceInventoryWarehouseId`),
  KEY `IX_EBEBFEE2` (`sku`,`companyId`,`unitOfMeasureKey`),
  KEY `IX_DA9C2C43` (`sku`,`unitOfMeasureKey`,`availabilityDate`),
  KEY `IX_B359B95D` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIReplenishmentItem`
--


--
-- Table structure for table `CIWarehouse`
--

CREATE TABLE `CIWarehouse` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CIWarehouseId` 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,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `street1` varchar(75) DEFAULT NULL,
  `street2` varchar(75) DEFAULT NULL,
  `street3` varchar(75) DEFAULT NULL,
  `city` varchar(75) DEFAULT NULL,
  `zip` varchar(75) DEFAULT NULL,
  `commerceRegionCode` varchar(75) DEFAULT NULL,
  `countryTwoLettersISOCode` varchar(75) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CIWarehouseId`),
  UNIQUE KEY `IX_68E6B8D8` (`companyId`,`externalReferenceCode`),
  KEY `IX_331A3FD3` (`companyId`,`active_`,`countryTwoLettersISOCode`),
  KEY `IX_DADA8974` (`companyId`,`countryTwoLettersISOCode`),
  KEY `IX_3CCB62D1` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIWarehouse`
--


--
-- Table structure for table `CIWarehouseGroupRel`
--

CREATE TABLE `CIWarehouseGroupRel` (
  `CIWarehouseGroupRelId` 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,
  `commerceWarehouseId` bigint(20) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`CIWarehouseGroupRelId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIWarehouseGroupRel`
--


--
-- Table structure for table `CIWarehouseItem`
--

CREATE TABLE `CIWarehouseItem` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CIWarehouseItemId` 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,
  `commerceInventoryWarehouseId` bigint(20) DEFAULT NULL,
  `quantity` decimal(30,16) DEFAULT NULL,
  `reservedQuantity` decimal(30,16) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `unitOfMeasureKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CIWarehouseItemId`),
  UNIQUE KEY `IX_B4413476` (`commerceInventoryWarehouseId`,`sku`,`unitOfMeasureKey`),
  UNIQUE KEY `IX_8A09C40B` (`companyId`,`externalReferenceCode`),
  KEY `IX_B86B6C8B` (`companyId`,`sku`,`unitOfMeasureKey`),
  KEY `IX_4AD4537E` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIWarehouseItem`
--


--
-- Table structure for table `CIWarehouseRel`
--

CREATE TABLE `CIWarehouseRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CIWarehouseRelId` 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,
  `CIWarehouseId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CIWarehouseRelId`),
  UNIQUE KEY `IX_A743341B` (`CIWarehouseId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CIWarehouseRel`
--


--
-- Table structure for table `CNTemplateCAccountGroupRel`
--

CREATE TABLE `CNTemplateCAccountGroupRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CNTemplateCAccountGroupRelId` 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,
  `commerceNotificationTemplateId` bigint(20) DEFAULT NULL,
  `commerceAccountGroupId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CNTemplateCAccountGroupRelId`),
  UNIQUE KEY `IX_AFBF7DA` (`commerceNotificationTemplateId`,`commerceAccountGroupId`),
  KEY `IX_7951AAEB` (`commerceAccountGroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CNTemplateCAccountGroupRel`
--


--
-- Table structure for table `CNotificationAttachment`
--

CREATE TABLE `CNotificationAttachment` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CNotificationAttachmentId` 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,
  `CNotificationQueueEntryId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `deleteOnSend` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`CNotificationAttachmentId`),
  UNIQUE KEY `IX_339EA78D` (`uuid_`,`groupId`),
  KEY `IX_6E9D8183` (`CNotificationQueueEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CNotificationAttachment`
--


--
-- Table structure for table `COREntry`
--

CREATE TABLE `COREntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `COREntryId` 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,
  `description` varchar(75) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `typeSettings` 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 (`COREntryId`),
  UNIQUE KEY `IX_4BD0EB07` (`companyId`,`externalReferenceCode`),
  KEY `IX_E0154022` (`companyId`,`active_`,`type_`),
  KEY `IX_FDA23B9F` (`companyId`,`type_`),
  KEY `IX_8599BE68` (`status`,`displayDate`),
  KEY `IX_4AFDBD89` (`status`,`expirationDate`),
  KEY `IX_DD753A02` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `COREntry`
--


--
-- Table structure for table `COREntryRel`
--

CREATE TABLE `COREntryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `COREntryRelId` 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,
  `COREntryId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`COREntryRelId`),
  UNIQUE KEY `IX_EA6EFFC3` (`COREntryId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `COREntryRel`
--


--
-- Table structure for table `CPAttachmentFileEntry`
--

CREATE TABLE `CPAttachmentFileEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPAttachmentFileEntryId` 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,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `cdnEnabled` tinyint(4) DEFAULT NULL,
  `cdnURL` longtext DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `galleryEnabled` tinyint(4) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `json` longtext DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `type_` 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 (`CPAttachmentFileEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_25D041B5` (`ctCollectionId`,`externalReferenceCode`,`companyId`),
  UNIQUE KEY `IX_50416EE0` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_4E725857` (`classNameId`,`classPK`,`cdnURL`(255)),
  KEY `IX_DD114140` (`classNameId`,`classPK`,`fileEntryId`),
  KEY `IX_F34F24D9` (`classNameId`,`classPK`,`status`,`displayDate`),
  KEY `IX_5F3A96F1` (`classNameId`,`classPK`,`status`,`type_`,`galleryEnabled`),
  KEY `IX_6A165A0B` (`classNameId`,`fileEntryId`,`groupId`),
  KEY `IX_5B2A1075` (`fileEntryId`),
  KEY `IX_E153EF0E` (`status`,`displayDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPAttachmentFileEntry`
--


--
-- Table structure for table `CPDAvailabilityEstimate`
--

CREATE TABLE `CPDAvailabilityEstimate` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDAvailabilityEstimateId` 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,
  `commerceAvailabilityEstimateId` bigint(20) DEFAULT NULL,
  `CProductId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPDAvailabilityEstimateId`),
  UNIQUE KEY `IX_17D56F1B` (`CProductId`),
  KEY `IX_E560850D` (`commerceAvailabilityEstimateId`),
  KEY `IX_109320B4` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDAvailabilityEstimate`
--


--
-- Table structure for table `CPDSpecificationOptionValue`
--

CREATE TABLE `CPDSpecificationOptionValue` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDSpecificationOptionValueId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CPSpecificationOptionId` bigint(20) DEFAULT NULL,
  `CPOptionCategoryId` bigint(20) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPDSpecificationOptionValueId`,`ctCollectionId`),
  UNIQUE KEY `IX_CFB2B6D7` (`CPDefinitionId`,`ctCollectionId`,`key_`),
  UNIQUE KEY `IX_99CAED2A` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_95975FB4` (`CPDefinitionId`,`CPOptionCategoryId`),
  KEY `IX_173E8E91` (`CPDefinitionId`,`CPSpecificationOptionId`),
  KEY `IX_4F4EDBA5` (`CPOptionCategoryId`),
  KEY `IX_573BE140` (`CPSpecificationOptionId`),
  KEY `IX_8DA57014` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDSpecificationOptionValue`
--


--
-- Table structure for table `CPDVirtualSettingFileEntry`
--

CREATE TABLE `CPDVirtualSettingFileEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDVirtualSettingFileEntryId` 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,
  `CPDefinitionVirtualSettingId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CPDVirtualSettingFileEntryId`),
  UNIQUE KEY `IX_762A2056` (`uuid_`,`groupId`),
  KEY `IX_C606354` (`CPDefinitionVirtualSettingId`),
  KEY `IX_B9327D21` (`fileEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDVirtualSettingFileEntry`
--


--
-- Table structure for table `CPDefinition`
--

CREATE TABLE `CPDefinition` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `defaultLanguageId` varchar(75) DEFAULT NULL,
  `CPDefinitionId` 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,
  `CProductId` bigint(20) DEFAULT NULL,
  `CPTaxCategoryId` bigint(20) DEFAULT NULL,
  `productTypeName` varchar(75) DEFAULT NULL,
  `availableIndividually` tinyint(4) DEFAULT NULL,
  `ignoreSKUCombinations` tinyint(4) DEFAULT NULL,
  `shippable` tinyint(4) DEFAULT NULL,
  `freeShipping` tinyint(4) DEFAULT NULL,
  `shipSeparately` tinyint(4) DEFAULT NULL,
  `shippingExtraPrice` double DEFAULT NULL,
  `width` double DEFAULT NULL,
  `height` double DEFAULT NULL,
  `depth` double DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `taxExempt` tinyint(4) DEFAULT NULL,
  `telcoOrElectronics` tinyint(4) DEFAULT NULL,
  `DDMStructureKey` varchar(75) DEFAULT NULL,
  `published` tinyint(4) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `subscriptionEnabled` tinyint(4) DEFAULT NULL,
  `subscriptionLength` int(11) DEFAULT NULL,
  `subscriptionType` varchar(75) DEFAULT NULL,
  `subscriptionTypeSettings` longtext DEFAULT NULL,
  `maxSubscriptionCycles` bigint(20) DEFAULT NULL,
  `deliverySubscriptionEnabled` tinyint(4) DEFAULT NULL,
  `deliverySubscriptionLength` int(11) DEFAULT NULL,
  `deliverySubscriptionType` varchar(75) DEFAULT NULL,
  `deliverySubTypeSettings` varchar(75) DEFAULT NULL,
  `deliveryMaxSubscriptionCycles` bigint(20) DEFAULT NULL,
  `accountGroupFilterEnabled` tinyint(4) DEFAULT NULL,
  `channelFilterEnabled` tinyint(4) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionId`,`ctCollectionId`),
  UNIQUE KEY `IX_96393D8E` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_3D5A0021` (`CPTaxCategoryId`),
  KEY `IX_1F4B9C67` (`CProductId`,`status`),
  KEY `IX_F1AEC8A7` (`CProductId`,`version`),
  KEY `IX_217AF702` (`companyId`),
  KEY `IX_419350EA` (`groupId`,`status`),
  KEY `IX_99C4ED10` (`groupId`,`subscriptionEnabled`),
  KEY `IX_E504F8F4` (`status`,`displayDate`),
  KEY `IX_46B4998E` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinition`
--


--
-- Table structure for table `CPDefinitionGroupedEntry`
--

CREATE TABLE `CPDefinitionGroupedEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionGroupedEntryId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `entryCProductId` bigint(20) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionGroupedEntryId`),
  UNIQUE KEY `IX_64F7EFA0` (`CPDefinitionId`,`entryCProductId`),
  UNIQUE KEY `IX_E30475B0` (`uuid_`,`groupId`),
  KEY `IX_8B75194F` (`entryCProductId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionGroupedEntry`
--


--
-- Table structure for table `CPDefinitionInventory`
--

CREATE TABLE `CPDefinitionInventory` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionInventoryId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CPDefinitionInventoryEngine` varchar(75) DEFAULT NULL,
  `lowStockActivity` varchar(75) DEFAULT NULL,
  `displayAvailability` tinyint(4) DEFAULT NULL,
  `displayStockQuantity` tinyint(4) DEFAULT NULL,
  `minStockQuantity` decimal(30,16) DEFAULT NULL,
  `backOrders` tinyint(4) DEFAULT NULL,
  `minOrderQuantity` decimal(30,16) DEFAULT NULL,
  `maxOrderQuantity` decimal(30,16) DEFAULT NULL,
  `allowedOrderQuantities` varchar(75) DEFAULT NULL,
  `multipleOrderQuantity` decimal(30,16) DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionInventoryId`,`ctCollectionId`),
  UNIQUE KEY `IX_C37B844F` (`ctCollectionId`,`CPDefinitionId`),
  UNIQUE KEY `IX_6C4F2D3A` (`uuid_`,`ctCollectionId`,`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionInventory`
--


--
-- Table structure for table `CPDefinitionLink`
--

CREATE TABLE `CPDefinitionLink` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionLinkId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CProductId` bigint(20) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `type_` varchar(75) 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 (`CPDefinitionLinkId`,`ctCollectionId`),
  UNIQUE KEY `IX_3A90EAC9` (`CPDefinitionId`,`CProductId`,`type_`,`ctCollectionId`),
  UNIQUE KEY `IX_112757D8` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_5572A666` (`CPDefinitionId`,`type_`),
  KEY `IX_F7B5F85A` (`CProductId`,`type_`),
  KEY `IX_FE4C04C0` (`status`,`CPDefinitionId`,`type_`),
  KEY `IX_786093B4` (`status`,`CProductId`,`type_`),
  KEY `IX_62BEA79A` (`status`,`displayDate`),
  KEY `IX_155AEF17` (`status`,`expirationDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionLink`
--


--
-- Table structure for table `CPDefinitionLocalization`
--

CREATE TABLE `CPDefinitionLocalization` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `cpDefinitionLocalizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `languageId` varchar(75) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `shortDescription` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `metaTitle` varchar(255) DEFAULT NULL,
  `metaDescription` varchar(255) DEFAULT NULL,
  `metaKeywords` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cpDefinitionLocalizationId`,`ctCollectionId`),
  UNIQUE KEY `IX_CB617913` (`CPDefinitionId`,`languageId`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionLocalization`
--


--
-- Table structure for table `CPDefinitionOptionRel`
--

CREATE TABLE `CPDefinitionOptionRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionOptionRelId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CPOptionId` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `commerceOptionTypeKey` varchar(75) DEFAULT NULL,
  `infoItemServiceKey` varchar(255) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `definedExternally` tinyint(4) DEFAULT NULL,
  `facetable` tinyint(4) DEFAULT NULL,
  `required` tinyint(4) DEFAULT NULL,
  `skuContributor` tinyint(4) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `priceType` varchar(75) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionOptionRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_64314388` (`CPDefinitionId`,`ctCollectionId`,`CPOptionId`),
  UNIQUE KEY `IX_78CCF36B` (`CPDefinitionId`,`ctCollectionId`,`key_`),
  UNIQUE KEY `IX_44B059C2` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_BDB8420C` (`CPDefinitionId`,`required`),
  KEY `IX_749E99EB` (`CPDefinitionId`,`skuContributor`),
  KEY `IX_449BFCFE` (`companyId`),
  KEY `IX_A65BAB00` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionOptionRel`
--


--
-- Table structure for table `CPDefinitionOptionValueRel`
--

CREATE TABLE `CPDefinitionOptionValueRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionOptionValueRelId` 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,
  `CPDefinitionOptionRelId` bigint(20) DEFAULT NULL,
  `CPInstanceUuid` varchar(75) DEFAULT NULL,
  `CProductId` bigint(20) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `preselected` tinyint(4) DEFAULT NULL,
  `price` decimal(30,16) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `quantity` decimal(30,16) DEFAULT NULL,
  `unitOfMeasureKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionOptionValueRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_55A05F1E` (`CPDefinitionOptionRelId`,`key_`,`ctCollectionId`),
  UNIQUE KEY `IX_52855B17` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_4A77D282` (`CPDefinitionOptionRelId`,`preselected`),
  KEY `IX_3EB86274` (`CPInstanceUuid`),
  KEY `IX_44C2E505` (`companyId`),
  KEY `IX_695AE8C7` (`groupId`),
  KEY `IX_2434CAD7` (`key_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionOptionValueRel`
--


--
-- Table structure for table `CPDefinitionVirtualSetting`
--

CREATE TABLE `CPDefinitionVirtualSetting` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDefinitionVirtualSettingId` 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,
  `activationStatus` int(11) DEFAULT NULL,
  `duration` bigint(20) DEFAULT NULL,
  `maxUsages` int(11) DEFAULT NULL,
  `useSample` tinyint(4) DEFAULT NULL,
  `sampleFileEntryId` bigint(20) DEFAULT NULL,
  `sampleURL` varchar(255) DEFAULT NULL,
  `termsOfUseRequired` tinyint(4) DEFAULT NULL,
  `termsOfUseContent` longtext DEFAULT NULL,
  `termsOfUseArticleResourcePK` bigint(20) DEFAULT NULL,
  `override` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPDefinitionVirtualSettingId`),
  UNIQUE KEY `IX_19B2FD20` (`classNameId`,`classPK`),
  UNIQUE KEY `IX_8ED43481` (`uuid_`,`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinitionVirtualSetting`
--


--
-- Table structure for table `CPDefinition_x_64463788232944`
--

CREATE TABLE `CPDefinition_x_64463788232944` (
  `CPDefinitionId` bigint(20) NOT NULL,
  PRIMARY KEY (`CPDefinitionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDefinition_x_64463788232944`
--


--
-- Table structure for table `CPDisplayLayout`
--

CREATE TABLE `CPDisplayLayout` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPDisplayLayoutId` 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,
  `layoutPageTemplateEntryUuid` varchar(75) DEFAULT NULL,
  `layoutUuid` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CPDisplayLayoutId`,`ctCollectionId`),
  UNIQUE KEY `IX_7F728A18` (`groupId`,`classNameId`,`classPK`,`ctCollectionId`),
  UNIQUE KEY `IX_7649CF4D` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_290BF7BA` (`classNameId`,`classPK`),
  KEY `IX_965CA8C5` (`groupId`,`layoutPageTemplateEntryUuid`),
  KEY `IX_381B82DE` (`groupId`,`layoutUuid`),
  KEY `IX_FEC526EF` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPDisplayLayout`
--


--
-- Table structure for table `CPInstance`
--

CREATE TABLE `CPInstance` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPInstanceId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CPInstanceUuid` varchar(75) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  `gtin` varchar(75) DEFAULT NULL,
  `manufacturerPartNumber` varchar(75) DEFAULT NULL,
  `purchasable` tinyint(4) DEFAULT NULL,
  `width` double DEFAULT NULL,
  `height` double DEFAULT NULL,
  `depth` double DEFAULT NULL,
  `weight` double DEFAULT NULL,
  `price` decimal(30,16) DEFAULT NULL,
  `promoPrice` decimal(30,16) DEFAULT NULL,
  `cost` decimal(30,16) DEFAULT NULL,
  `published` tinyint(4) DEFAULT NULL,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `overrideSubscriptionInfo` tinyint(4) DEFAULT NULL,
  `subscriptionEnabled` tinyint(4) DEFAULT NULL,
  `subscriptionLength` int(11) DEFAULT NULL,
  `subscriptionType` varchar(75) DEFAULT NULL,
  `subscriptionTypeSettings` longtext DEFAULT NULL,
  `maxSubscriptionCycles` bigint(20) DEFAULT NULL,
  `deliverySubscriptionEnabled` tinyint(4) DEFAULT NULL,
  `deliverySubscriptionLength` int(11) DEFAULT NULL,
  `deliverySubscriptionType` varchar(75) DEFAULT NULL,
  `deliverySubTypeSettings` varchar(75) DEFAULT NULL,
  `deliveryMaxSubscriptionCycles` bigint(20) DEFAULT NULL,
  `unspsc` varchar(75) DEFAULT NULL,
  `discontinued` tinyint(4) DEFAULT NULL,
  `discontinuedDate` datetime(6) DEFAULT NULL,
  `replacementCPInstanceUuid` varchar(75) DEFAULT NULL,
  `replacementCProductId` 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 (`CPInstanceId`,`ctCollectionId`),
  UNIQUE KEY `IX_95564486` (`CPDefinitionId`,`ctCollectionId`,`CPInstanceUuid`),
  UNIQUE KEY `IX_E06787D8` (`CPDefinitionId`,`ctCollectionId`,`sku`),
  UNIQUE KEY `IX_EB17985B` (`ctCollectionId`,`companyId`,`externalReferenceCode`),
  UNIQUE KEY `IX_A495773C` (`ctCollectionId`,`uuid_`,`groupId`),
  KEY `IX_4389A03` (`CPDefinitionId`,`status`,`displayDate`),
  KEY `IX_34763899` (`CPInstanceUuid`),
  KEY `IX_9FB1144D` (`companyId`,`sku`),
  KEY `IX_C1F8242` (`groupId`),
  KEY `IX_BD04B832` (`status`,`displayDate`),
  KEY `IX_75478E1C` (`status`,`groupId`),
  KEY `IX_1140BD8` (`status`,`replacementCPInstanceUuid`,`replacementCProductId`),
  KEY `IX_4654BD4C` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPInstance`
--


--
-- Table structure for table `CPInstanceOptionValueRel`
--

CREATE TABLE `CPInstanceOptionValueRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPInstanceOptionValueRelId` 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,
  `CPDefinitionOptionRelId` bigint(20) DEFAULT NULL,
  `CPDefinitionOptionValueRelId` bigint(20) DEFAULT NULL,
  `CPInstanceId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CPInstanceOptionValueRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_C7B0D143` (`CPInstanceId`,`CPDefinitionOptionRelId`,`CPDefinitionOptionValueRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_4399CE9D` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_E551D3AA` (`CPDefinitionOptionRelId`),
  KEY `IX_D3B702C2` (`CPInstanceId`,`CPDefinitionOptionValueRelId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPInstanceOptionValueRel`
--


--
-- Table structure for table `CPInstanceUOM`
--

CREATE TABLE `CPInstanceUOM` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPInstanceUOMId` 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,
  `CPInstanceId` bigint(20) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `incrementalOrderQuantity` decimal(30,16) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `precision_` int(11) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `rate` decimal(30,16) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CPInstanceUOMId`,`ctCollectionId`),
  UNIQUE KEY `IX_C6BA8E9A` (`CPInstanceId`,`key_`,`ctCollectionId`),
  KEY `IX_4351C7A1` (`CPInstanceId`,`active_`),
  KEY `IX_611154B9` (`CPInstanceId`,`primary_`),
  KEY `IX_2EED7F68` (`companyId`,`key_`,`sku`),
  KEY `IX_9DCFEBFC` (`companyId`,`sku`),
  KEY `IX_ABE6B4BD` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPInstanceUOM`
--


--
-- Table structure for table `CPLCommerceGroupAccountRel`
--

CREATE TABLE `CPLCommerceGroupAccountRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPLCommerceAccountGroupRelId` 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,
  `commercePriceListId` bigint(20) DEFAULT NULL,
  `commerceAccountGroupId` bigint(20) DEFAULT NULL,
  `order_` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPLCommerceAccountGroupRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_8EF03EDA` (`commercePriceListId`,`commerceAccountGroupId`,`ctCollectionId`),
  KEY `IX_29EF081D` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPLCommerceGroupAccountRel`
--


--
-- Table structure for table `CPMeasurementUnit`
--

CREATE TABLE `CPMeasurementUnit` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPMeasurementUnitId` 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` longtext DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `rate` double DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPMeasurementUnitId`,`ctCollectionId`),
  UNIQUE KEY `IX_D52621F0` (`companyId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_51CDE4C1` (`companyId`,`ctCollectionId`,`key_`),
  UNIQUE KEY `IX_E3424311` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_F0C14577` (`companyId`,`type_`,`primary_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPMeasurementUnit`
--

INSERT INTO `CPMeasurementUnit` VALUES
(0,0,'61244a0b-8eba-e649-8762-8c036cbc4e51','61244a0b-8eba-e649-8762-8c036cbc4e51',29902,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.258000','2024-11-21 12:18:57.258000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">inches</Name></root>','in',1,1,1,0,NULL),
(0,0,'309702bf-cda4-b5bc-8fa9-c578d02e5c2c','309702bf-cda4-b5bc-8fa9-c578d02e5c2c',29903,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.269000','2024-11-21 12:18:57.269000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">feet</Name></root>','ft',0.08333333,0,2,0,NULL),
(0,0,'77a0cce2-d6c4-3794-2615-8f4847afe9ed','77a0cce2-d6c4-3794-2615-8f4847afe9ed',29904,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.271000','2024-11-21 12:18:57.271000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">meters</Name></root>','m',0.0254,0,3,0,NULL),
(0,0,'440feabb-adaa-69e7-079e-408880936e2e','440feabb-adaa-69e7-079e-408880936e2e',29905,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.273000','2024-11-21 12:18:57.273000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">millimeters</Name></root>','mm',25.4,0,4,0,NULL),
(0,0,'f085eede-3d52-154c-1865-ec4c52e11b0a','f085eede-3d52-154c-1865-ec4c52e11b0a',29906,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.277000','2024-11-21 12:18:57.277000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">ounces</Name></root>','oz',16,0,1,1,NULL),
(0,0,'31b433e2-193a-df56-53f1-2039b7d8dc6f','31b433e2-193a-df56-53f1-2039b7d8dc6f',29907,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.285000','2024-11-21 12:18:57.285000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">pounds</Name></root>','lb',1,1,2,1,NULL),
(0,0,'c82fb3cf-9a74-3dc1-2a5c-543c7284d13b','c82fb3cf-9a74-3dc1-2a5c-543c7284d13b',29908,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.287000','2024-11-21 12:18:57.287000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">kilograms</Name></root>','kg',0.45359237,0,3,1,NULL),
(0,0,'1a6de374-900c-76a7-19e8-981ad4b73ce5','1a6de374-900c-76a7-19e8-981ad4b73ce5',29909,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.290000','2024-11-21 12:18:57.290000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">grams</Name></root>','g',453.59237,0,4,1,NULL),
(0,0,'1f9735a2-041f-6ac5-408f-10c9d4a0040f','1f9735a2-041f-6ac5-408f-10c9d4a0040f',29910,0,64463788232944,20123,'Test Test','2024-11-21 12:18:57.294000','2024-11-21 12:18:57.294000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US\" default-locale=\"en_US\"><Name language-id=\"en_US\">piece(s)</Name></root>','pc',1,1,1,2,NULL);

--
-- Table structure for table `CPMethodGroupRelQualifier`
--

CREATE TABLE `CPMethodGroupRelQualifier` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CPMethodGroupRelQualifierId` 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,
  `CPaymentMethodGroupRelId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CPMethodGroupRelQualifierId`),
  UNIQUE KEY `IX_D9799B2A` (`CPaymentMethodGroupRelId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPMethodGroupRelQualifier`
--


--
-- Table structure for table `CPOption`
--

CREATE TABLE `CPOption` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPOptionId` 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,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `commerceOptionTypeKey` varchar(75) DEFAULT NULL,
  `facetable` tinyint(4) DEFAULT NULL,
  `required` tinyint(4) DEFAULT NULL,
  `skuContributor` tinyint(4) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPOptionId`,`ctCollectionId`),
  UNIQUE KEY `IX_4E312C7F` (`companyId`,`ctCollectionId`,`externalReferenceCode`),
  UNIQUE KEY `IX_143B0E52` (`companyId`,`ctCollectionId`,`key_`),
  KEY `IX_A64FCE2C` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPOption`
--


--
-- Table structure for table `CPOptionCategory`
--

CREATE TABLE `CPOptionCategory` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPOptionCategoryId` 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,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPOptionCategoryId`,`ctCollectionId`),
  UNIQUE KEY `IX_D9120F4` (`companyId`,`key_`,`ctCollectionId`),
  KEY `IX_ABB730CE` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPOptionCategory`
--


--
-- Table structure for table `CPOptionValue`
--

CREATE TABLE `CPOptionValue` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPOptionValueId` 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,
  `CPOptionId` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPOptionValueId`,`ctCollectionId`),
  UNIQUE KEY `IX_DA77C838` (`CPOptionId`,`ctCollectionId`,`key_`),
  UNIQUE KEY `IX_DC509C0C` (`companyId`,`ctCollectionId`,`externalReferenceCode`),
  KEY `IX_D7C1A0BF` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPOptionValue`
--


--
-- Table structure for table `CPSpecificationOption`
--

CREATE TABLE `CPSpecificationOption` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CPSpecificationOptionId` 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,
  `CPOptionCategoryId` bigint(20) DEFAULT NULL,
  `listTypeDefinitionId` bigint(20) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `facetable` tinyint(4) DEFAULT NULL,
  `key_` varchar(75) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`CPSpecificationOptionId`,`ctCollectionId`),
  UNIQUE KEY `IX_8F980DC9` (`companyId`,`key_`,`ctCollectionId`),
  KEY `IX_421ED80` (`CPOptionCategoryId`),
  KEY `IX_BF5FD94B` (`listTypeDefinitionId`),
  KEY `IX_972DFDE3` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPSpecificationOption`
--


--
-- Table structure for table `CPTaxCategory`
--

CREATE TABLE `CPTaxCategory` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CPTaxCategoryId` 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,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  PRIMARY KEY (`CPTaxCategoryId`,`ctCollectionId`),
  UNIQUE KEY `IX_79A007D5` (`companyId`,`externalReferenceCode`,`ctCollectionId`),
  KEY `IX_705EAB92` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPTaxCategory`
--


--
-- Table structure for table `CPricingClassCPDefinitionRel`
--

CREATE TABLE `CPricingClassCPDefinitionRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `CPricingClassCPDefinitionRelId` 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,
  `commercePricingClassId` bigint(20) DEFAULT NULL,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CPricingClassCPDefinitionRelId`,`ctCollectionId`),
  UNIQUE KEY `IX_DA09B6F3` (`commercePricingClassId`,`CPDefinitionId`,`ctCollectionId`),
  KEY `IX_31653559` (`CPDefinitionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CPricingClassCPDefinitionRel`
--


--
-- Table structure for table `CProduct`
--

CREATE TABLE `CProduct` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `CProductId` 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,
  `publishedCPDefinitionId` bigint(20) DEFAULT NULL,
  `latestVersion` int(11) DEFAULT NULL,
  PRIMARY KEY (`CProductId`,`ctCollectionId`),
  UNIQUE KEY `IX_CB3A891B` (`ctCollectionId`,`externalReferenceCode`,`companyId`),
  UNIQUE KEY `IX_F70CE3C6` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_77F5B8F8` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CProduct`
--


--
-- Table structure for table `CSDiagramEntry`
--

CREATE TABLE `CSDiagramEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `CSDiagramEntryId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `CPInstanceId` bigint(20) DEFAULT NULL,
  `CProductId` bigint(20) DEFAULT NULL,
  `diagram` tinyint(4) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `sequence` varchar(75) DEFAULT NULL,
  `sku` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CSDiagramEntryId`,`ctCollectionId`),
  UNIQUE KEY `IX_4748C557` (`CPDefinitionId`,`sequence`,`ctCollectionId`),
  KEY `IX_129C0EC6` (`CPInstanceId`),
  KEY `IX_E1E7EA90` (`CProductId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CSDiagramEntry`
--


--
-- Table structure for table `CSDiagramPin`
--

CREATE TABLE `CSDiagramPin` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `CSDiagramPinId` 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,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `positionX` double DEFAULT NULL,
  `positionY` double DEFAULT NULL,
  `sequence` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CSDiagramPinId`,`ctCollectionId`),
  KEY `IX_B0DD2127` (`CPDefinitionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CSDiagramPin`
--


--
-- Table structure for table `CSDiagramSetting`
--

CREATE TABLE `CSDiagramSetting` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `CSDiagramSettingId` 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,
  `CPAttachmentFileEntryId` bigint(20) DEFAULT NULL,
  `CPDefinitionId` bigint(20) DEFAULT NULL,
  `color` varchar(75) DEFAULT NULL,
  `radius` double DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CSDiagramSettingId`,`ctCollectionId`),
  UNIQUE KEY `IX_4F753100` (`CPDefinitionId`,`ctCollectionId`),
  KEY `IX_BCB38741` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CSDiagramSetting`
--


--
-- Table structure for table `CSFixedOptionQualifier`
--

CREATE TABLE `CSFixedOptionQualifier` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CSFixedOptionQualifierId` 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,
  `commerceShippingFixedOptionId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`CSFixedOptionQualifierId`),
  UNIQUE KEY `IX_1D29E189` (`commerceShippingFixedOptionId`,`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CSFixedOptionQualifier`
--


--
-- Table structure for table `CSOptionAccountEntryRel`
--

CREATE TABLE `CSOptionAccountEntryRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CSOptionAccountEntryRelId` 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,
  `accountEntryId` bigint(20) DEFAULT NULL,
  `commerceChannelId` bigint(20) DEFAULT NULL,
  `commerceShippingMethodKey` varchar(75) DEFAULT NULL,
  `commerceShippingOptionKey` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`CSOptionAccountEntryRelId`),
  UNIQUE KEY `IX_4F4C712A` (`accountEntryId`,`commerceChannelId`),
  KEY `IX_B48AB5E` (`commerceChannelId`),
  KEY `IX_64B9CFFC` (`commerceShippingOptionKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CSOptionAccountEntryRel`
--


--
-- Table structure for table `CShippingFixedOptionRel`
--

CREATE TABLE `CShippingFixedOptionRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `CShippingFixedOptionRelId` 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,
  `commerceShippingMethodId` bigint(20) DEFAULT NULL,
  `commerceShippingFixedOptionId` bigint(20) DEFAULT NULL,
  `commerceInventoryWarehouseId` bigint(20) DEFAULT NULL,
  `countryId` bigint(20) DEFAULT NULL,
  `regionId` bigint(20) DEFAULT NULL,
  `zip` varchar(75) DEFAULT NULL,
  `weightFrom` double DEFAULT NULL,
  `weightTo` double DEFAULT NULL,
  `fixedPrice` decimal(30,16) DEFAULT NULL,
  `rateUnitWeightPrice` decimal(30,16) DEFAULT NULL,
  `ratePercentage` double DEFAULT NULL,
  PRIMARY KEY (`CShippingFixedOptionRelId`),
  KEY `IX_D89A7E24` (`commerceShippingFixedOptionId`),
  KEY `IX_4AA09D60` (`commerceShippingMethodId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CShippingFixedOptionRel`
--


--
-- Table structure for table `CTAutoResolutionInfo`
--

CREATE TABLE `CTAutoResolutionInfo` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctAutoResolutionInfoId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `modelClassNameId` bigint(20) DEFAULT NULL,
  `sourceModelClassPK` bigint(20) DEFAULT NULL,
  `targetModelClassPK` bigint(20) DEFAULT NULL,
  `conflictIdentifier` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`ctAutoResolutionInfoId`),
  KEY `IX_F925260` (`ctCollectionId`,`modelClassNameId`,`sourceModelClassPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTAutoResolutionInfo`
--


--
-- Table structure for table `CTCollection`
--

CREATE TABLE `CTCollection` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `ctCollectionId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `ctRemoteId` bigint(20) DEFAULT NULL,
  `schemaVersionId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `onDemandUserId` bigint(20) DEFAULT NULL,
  `shareable` tinyint(4) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`ctCollectionId`),
  UNIQUE KEY `IX_30F5BCCA` (`companyId`,`externalReferenceCode`),
  KEY `IX_8D52E6F9` (`companyId`,`status`),
  KEY `IX_CCDD86CD` (`schemaVersionId`),
  KEY `IX_DA0BBE1F` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTCollection`
--


--
-- Table structure for table `CTCollectionTemplate`
--

CREATE TABLE `CTCollectionTemplate` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionTemplateId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`ctCollectionTemplateId`),
  KEY `IX_489283B9` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTCollectionTemplate`
--


--
-- Table structure for table `CTComment`
--

CREATE TABLE `CTComment` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCommentId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `ctEntryId` bigint(20) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`ctCommentId`),
  KEY `IX_FE644B52` (`ctCollectionId`),
  KEY `IX_C5E592B8` (`ctEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTComment`
--


--
-- Table structure for table `CTEntry`
--

CREATE TABLE `CTEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `externalReferenceCode` varchar(75) DEFAULT NULL,
  `ctEntryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `modelClassNameId` bigint(20) DEFAULT NULL,
  `modelClassPK` bigint(20) DEFAULT NULL,
  `modelMvccVersion` bigint(20) DEFAULT NULL,
  `changeType` int(11) DEFAULT NULL,
  PRIMARY KEY (`ctEntryId`),
  UNIQUE KEY `IX_295C418C` (`ctCollectionId`,`modelClassNameId`,`modelClassPK`),
  UNIQUE KEY `IX_7FBB3312` (`externalReferenceCode`,`companyId`),
  KEY `IX_E1E08DCD` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTEntry`
--


--
-- Table structure for table `CTMessage`
--

CREATE TABLE `CTMessage` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctMessageId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `messageContent` longtext DEFAULT NULL,
  PRIMARY KEY (`ctMessageId`),
  KEY `IX_9FB742FA` (`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTMessage`
--


--
-- Table structure for table `CTPreferences`
--

CREATE TABLE `CTPreferences` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctPreferencesId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `previousCtCollectionId` bigint(20) DEFAULT NULL,
  `confirmationEnabled` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ctPreferencesId`),
  UNIQUE KEY `IX_516E5375` (`companyId`,`userId`),
  KEY `IX_3FECC82B` (`ctCollectionId`),
  KEY `IX_D9EA7A42` (`previousCtCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTPreferences`
--


--
-- Table structure for table `CTProcess`
--

CREATE TABLE `CTProcess` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctProcessId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `ctCollectionId` bigint(20) DEFAULT NULL,
  `backgroundTaskId` bigint(20) DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ctProcessId`),
  KEY `IX_7523B0A4` (`companyId`),
  KEY `IX_46BA2033` (`ctCollectionId`,`type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTProcess`
--


--
-- Table structure for table `CTRemote`
--

CREATE TABLE `CTRemote` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctRemoteId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  `url` varchar(75) DEFAULT NULL,
  `clientId` varchar(75) DEFAULT NULL,
  `clientSecret` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`ctRemoteId`),
  KEY `IX_9B9391EB` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTRemote`
--


--
-- Table structure for table `CTSContent`
--

CREATE TABLE `CTSContent` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `ctsContentId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `repositoryId` bigint(20) DEFAULT NULL,
  `path_` varchar(75) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `data_` longblob DEFAULT NULL,
  `size_` bigint(20) DEFAULT NULL,
  `storeType` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`ctsContentId`,`ctCollectionId`),
  UNIQUE KEY `IX_8948D363` (`companyId`,`repositoryId`,`storeType`,`path_`,`version`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTSContent`
--


--
-- Table structure for table `CTSchemaVersion`
--

CREATE TABLE `CTSchemaVersion` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `schemaVersionId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `schemaContext` longtext DEFAULT NULL,
  PRIMARY KEY (`schemaVersionId`),
  KEY `IX_687AE35C` (`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTSchemaVersion`
--


--
-- Table structure for table `CTermEntryLocalization`
--

CREATE TABLE `CTermEntryLocalization` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `cTermEntryLocalizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `commerceTermEntryId` bigint(20) DEFAULT NULL,
  `languageId` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `label` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`cTermEntryLocalizationId`),
  UNIQUE KEY `IX_B197F41B` (`commerceTermEntryId`,`languageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CTermEntryLocalization`
--


--
-- Table structure for table `CVirtualOrderItemFileEntry`
--

CREATE TABLE `CVirtualOrderItemFileEntry` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `cVirtualOrderItemFileEntryId` 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,
  `commerceVirtualOrderItemId` bigint(20) DEFAULT NULL,
  `fileEntryId` bigint(20) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `usages` int(11) DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`cVirtualOrderItemFileEntryId`),
  UNIQUE KEY `IX_68E33939` (`uuid_`,`groupId`),
  KEY `IX_C83537E` (`commerceVirtualOrderItemId`,`fileEntryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CVirtualOrderItemFileEntry`
--


--
-- Table structure for table `Calendar`
--

CREATE TABLE `Calendar` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `calendarId` 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,
  `calendarResourceId` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `timeZoneId` varchar(75) DEFAULT NULL,
  `color` int(11) DEFAULT NULL,
  `defaultCalendar` tinyint(4) DEFAULT NULL,
  `enableComments` tinyint(4) DEFAULT NULL,
  `enableRatings` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`calendarId`,`ctCollectionId`),
  UNIQUE KEY `IX_31D79378` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_97FC174E` (`groupId`,`calendarResourceId`,`defaultCalendar`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Calendar`
--


--
-- Table structure for table `CalendarBooking`
--

CREATE TABLE `CalendarBooking` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `calendarBookingId` 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,
  `calendarId` bigint(20) DEFAULT NULL,
  `calendarResourceId` bigint(20) DEFAULT NULL,
  `parentCalendarBookingId` bigint(20) DEFAULT NULL,
  `recurringCalendarBookingId` bigint(20) DEFAULT NULL,
  `vEventUid` varchar(255) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `location` longtext DEFAULT NULL,
  `startTime` bigint(20) DEFAULT NULL,
  `endTime` bigint(20) DEFAULT NULL,
  `allDay` tinyint(4) DEFAULT NULL,
  `recurrence` longtext DEFAULT NULL,
  `firstReminder` bigint(20) DEFAULT NULL,
  `firstReminderType` varchar(75) DEFAULT NULL,
  `secondReminder` bigint(20) DEFAULT NULL,
  `secondReminderType` varchar(75) 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 (`calendarBookingId`,`ctCollectionId`),
  UNIQUE KEY `IX_9090D8F0` (`calendarId`,`ctCollectionId`,`vEventUid`),
  UNIQUE KEY `IX_BD5AA0AC` (`calendarId`,`parentCalendarBookingId`,`ctCollectionId`),
  UNIQUE KEY `IX_99E210F9` (`uuid_`,`ctCollectionId`,`groupId`),
  KEY `IX_470170B4` (`calendarId`,`status`),
  KEY `IX_B198FFC` (`calendarResourceId`),
  KEY `IX_F7B8A941` (`parentCalendarBookingId`,`status`),
  KEY `IX_14ADC52E` (`recurringCalendarBookingId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CalendarBooking`
--


--
-- Table structure for table `CalendarNotificationTemplate`
--

CREATE TABLE `CalendarNotificationTemplate` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `calendarNotificationTemplateId` 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,
  `calendarId` bigint(20) DEFAULT NULL,
  `notificationType` varchar(75) DEFAULT NULL,
  `notificationTypeSettings` varchar(200) DEFAULT NULL,
  `notificationTemplateType` varchar(75) DEFAULT NULL,
  `subject` varchar(75) DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`calendarNotificationTemplateId`,`ctCollectionId`),
  UNIQUE KEY `IX_10D0E1DD` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_7727A482` (`calendarId`,`notificationType`,`notificationTemplateType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CalendarNotificationTemplate`
--


--
-- Table structure for table `CalendarResource`
--

CREATE TABLE `CalendarResource` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `ctCollectionId` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `calendarResourceId` 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,
  `classUuid` varchar(75) DEFAULT NULL,
  `code_` varchar(75) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`calendarResourceId`,`ctCollectionId`),
  UNIQUE KEY `IX_D8D5DB05` (`ctCollectionId`,`classNameId`,`classPK`),
  UNIQUE KEY `IX_FD05567A` (`groupId`,`uuid_`,`ctCollectionId`),
  KEY `IX_74AD9DDD` (`active_`,`code_`,`companyId`),
  KEY `IX_40678371` (`groupId`,`active_`),
  KEY `IX_55C2F8AA` (`groupId`,`code_`),
  KEY `IX_150E2F22` (`uuid_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `CalendarResource`
--


--
-- Table structure for table `ChangesetCollection`
--

CREATE TABLE `ChangesetCollection` (
  `changesetCollectionId` 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(75) DEFAULT NULL,
  `description` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`changesetCollectionId`),
  UNIQUE KEY `IX_ABEEE793` (`groupId`,`name`),
  KEY `IX_9AC55E11` (`companyId`,`name`),
  KEY `IX_EE4B4B0E` (`groupId`,`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ChangesetCollection`
--


--
-- Table structure for table `ChangesetEntry`
--

CREATE TABLE `ChangesetEntry` (
  `changesetEntryId` 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,
  `changesetCollectionId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`changesetEntryId`),
  UNIQUE KEY `IX_EF48912A` (`changesetCollectionId`,`classNameId`,`classPK`),
  KEY `IX_A9985762` (`classNameId`,`groupId`),
  KEY `IX_CEB6AFA2` (`companyId`),
  KEY `IX_E00AB6A4` (`groupId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ChangesetEntry`
--


--
-- Table structure for table `ClassName_`
--

CREATE TABLE `ClassName_` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `classNameId` bigint(20) NOT NULL,
  `value` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`classNameId`),
  UNIQUE KEY `IX_B27A301F` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ClassName_`
--

INSERT INTO `ClassName_` VALUES
(0,20001,'com.liferay.announcements.kernel.model.AnnouncementsDelivery'),
(0,20002,'com.liferay.announcements.kernel.model.AnnouncementsEntry'),
(0,20003,'com.liferay.announcements.kernel.model.AnnouncementsFlag'),
(0,20004,'com.liferay.asset.kernel.model.AssetCategory'),
(0,20005,'com.liferay.asset.kernel.model.AssetEntry'),
(0,20006,'com.liferay.asset.kernel.model.AssetTag'),
(0,20007,'com.liferay.asset.kernel.model.AssetVocabulary'),
(0,20008,'com.liferay.counter.kernel.model.Counter'),
(0,20009,'com.liferay.document.library.kernel.model.DLFileEntry'),
(0,20010,'com.liferay.document.library.kernel.model.DLFileEntryMetadata'),
(0,20011,'com.liferay.document.library.kernel.model.DLFileEntryType'),
(0,20012,'com.liferay.document.library.kernel.model.DLFileShortcut'),
(0,20013,'com.liferay.document.library.kernel.model.DLFileVersion'),
(0,20014,'com.liferay.document.library.kernel.model.DLFolder'),
(0,20015,'com.liferay.expando.kernel.model.ExpandoColumn'),
(0,20016,'com.liferay.expando.kernel.model.ExpandoRow'),
(0,20017,'com.liferay.expando.kernel.model.ExpandoTable'),
(0,20018,'com.liferay.expando.kernel.model.ExpandoValue'),
(0,20019,'com.liferay.exportimport.kernel.model.ExportImportConfiguration'),
(0,20020,'com.liferay.portal.kernel.model.Address'),
(0,20021,'com.liferay.portal.kernel.model.BrowserTracker'),
(0,20022,'com.liferay.portal.kernel.model.ClassName'),
(0,20023,'com.liferay.portal.kernel.model.Company'),
(0,20024,'com.liferay.portal.kernel.model.CompanyInfo'),
(0,20025,'com.liferay.portal.kernel.model.Contact'),
(0,20026,'com.liferay.portal.kernel.model.Country'),
(0,20027,'com.liferay.portal.kernel.model.CountryLocalization'),
(0,20028,'com.liferay.portal.kernel.model.EmailAddress'),
(0,20029,'com.liferay.portal.kernel.model.Group'),
(0,20030,'com.liferay.portal.kernel.model.Image'),
(0,20031,'com.liferay.portal.kernel.model.Layout'),
(0,20032,'com.liferay.portal.kernel.model.LayoutBranch'),
(0,20033,'com.liferay.portal.kernel.model.LayoutFriendlyURL'),
(0,20034,'com.liferay.portal.kernel.model.LayoutPrototype'),
(0,20035,'com.liferay.portal.kernel.model.LayoutRevision'),
(0,20036,'com.liferay.portal.kernel.model.LayoutSet'),
(0,20037,'com.liferay.portal.kernel.model.LayoutSetBranch'),
(0,20038,'com.liferay.portal.kernel.model.LayoutSetPrototype'),
(0,20039,'com.liferay.portal.kernel.model.ListType'),
(0,20040,'com.liferay.portal.kernel.model.MembershipRequest'),
(0,20041,'com.liferay.portal.kernel.model.OrgLabor'),
(0,20042,'com.liferay.portal.kernel.model.Organization'),
(0,20043,'com.liferay.portal.kernel.model.PasswordPolicy'),
(0,20044,'com.liferay.portal.kernel.model.PasswordPolicyRel'),
(0,20045,'com.liferay.portal.kernel.model.PasswordTracker'),
(0,20046,'com.liferay.portal.kernel.model.Phone'),
(0,20047,'com.liferay.portal.kernel.model.PluginSetting'),
(0,20048,'com.liferay.portal.kernel.model.PortalPreferenceValue'),
(0,20049,'com.liferay.portal.kernel.model.PortalPreferences'),
(0,20050,'com.liferay.portal.kernel.model.Portlet'),
(0,20051,'com.liferay.portal.kernel.model.PortletItem'),
(0,20052,'com.liferay.portal.kernel.model.PortletPreferenceValue'),
(0,20053,'com.liferay.portal.kernel.model.PortletPreferences'),
(0,20054,'com.liferay.portal.kernel.model.RecentLayoutBranch'),
(0,20055,'com.liferay.portal.kernel.model.RecentLayoutRevision'),
(0,20056,'com.liferay.portal.kernel.model.RecentLayoutSetBranch'),
(0,20057,'com.liferay.portal.kernel.model.Region'),
(0,20058,'com.liferay.portal.kernel.model.RegionLocalization'),
(0,20059,'com.liferay.portal.kernel.model.Release'),
(0,20060,'com.liferay.portal.kernel.model.RememberMeToken'),
(0,20061,'com.liferay.portal.kernel.model.Repository'),
(0,20062,'com.liferay.portal.kernel.model.RepositoryEntry'),
(0,20063,'com.liferay.portal.kernel.model.ResourceAction'),
(0,20064,'com.liferay.portal.kernel.model.ResourcePermission'),
(0,20065,'com.liferay.portal.kernel.model.Role'),
(0,20066,'com.liferay.portal.kernel.model.ServiceComponent'),
(0,20067,'com.liferay.portal.kernel.model.Subscription'),
(0,20068,'com.liferay.portal.kernel.model.SystemEvent'),
(0,20069,'com.liferay.portal.kernel.model.Team'),
(0,20070,'com.liferay.portal.kernel.model.Ticket'),
(0,20071,'com.liferay.portal.kernel.model.User'),
(0,20072,'com.liferay.portal.kernel.model.UserGroup'),
(0,20073,'com.liferay.portal.kernel.model.UserGroupGroupRole'),
(0,20074,'com.liferay.portal.kernel.model.UserGroupRole'),
(0,20075,'com.liferay.portal.kernel.model.UserIdMapper'),
(0,20076,'com.liferay.portal.kernel.model.UserNotificationDelivery'),
(0,20077,'com.liferay.portal.kernel.model.UserNotificationEvent'),
(0,20078,'com.liferay.portal.kernel.model.UserTracker'),
(0,20079,'com.liferay.portal.kernel.model.UserTrackerPath'),
(0,20080,'com.liferay.portal.kernel.model.VirtualHost'),
(0,20081,'com.liferay.portal.kernel.model.WebDAVProps'),
(0,20082,'com.liferay.portal.kernel.model.Website'),
(0,20083,'com.liferay.portal.kernel.model.WorkflowDefinitionLink'),
(0,20084,'com.liferay.portal.kernel.model.WorkflowInstanceLink'),
(0,20085,'com.liferay.portal.kernel.workflow.WorkflowTask'),
(0,20086,'com.liferay.ratings.kernel.model.RatingsEntry'),
(0,20087,'com.liferay.ratings.kernel.model.RatingsStats'),
(0,20088,'com.liferay.social.kernel.model.SocialActivity'),
(0,20089,'com.liferay.social.kernel.model.SocialActivityAchievement'),
(0,20090,'com.liferay.social.kernel.model.SocialActivityCounter'),
(0,20091,'com.liferay.social.kernel.model.SocialActivityLimit'),
(0,20092,'com.liferay.social.kernel.model.SocialActivitySet'),
(0,20093,'com.liferay.social.kernel.model.SocialActivitySetting'),
(0,20094,'com.liferay.social.kernel.model.SocialRelation'),
(0,20095,'com.liferay.social.kernel.model.SocialRequest'),
(0,20118,'com.liferay.portal.kernel.model.UserPersonalSite'),
(0,28403,'com.liferay.commerce.model.CommerceAddress'),
(0,28404,'com.liferay.commerce.model.CommerceAddressRestriction'),
(0,28405,'com.liferay.commerce.model.CommerceAvailabilityEstimate'),
(0,28406,'com.liferay.commerce.model.CommerceOrder'),
(0,28407,'com.liferay.commerce.model.CommerceOrderItem'),
(0,28408,'com.liferay.commerce.model.CommerceOrderNote'),
(0,28409,'com.liferay.commerce.model.CommerceOrderPayment'),
(0,28410,'com.liferay.commerce.model.CommerceOrderType'),
(0,28411,'com.liferay.commerce.model.CommerceOrderTypeRel'),
(0,28412,'com.liferay.commerce.model.CommerceShipment'),
(0,28413,'com.liferay.commerce.model.CommerceShipmentItem'),
(0,28414,'com.liferay.commerce.model.CommerceShippingMethod'),
(0,28415,'com.liferay.commerce.model.CommerceShippingOptionAccountEntryRel'),
(0,28416,'com.liferay.commerce.model.CommerceSubscriptionEntry'),
(0,28417,'com.liferay.commerce.model.CPDAvailabilityEstimate'),
(0,28418,'com.liferay.commerce.model.CPDefinitionInventory'),
(0,28421,'com.liferay.commerce.price.list.model.CommercePriceEntry'),
(0,28422,'com.liferay.commerce.price.list.model.CommercePriceList'),
(0,28423,'com.liferay.commerce.price.list.model.CommercePriceListAccountRel'),
(0,28424,'com.liferay.commerce.price.list.model.CommercePriceListChannelRel'),
(0,28425,'com.liferay.commerce.price.list.model.CommercePriceListCommerceAccountGroupRel'),
(0,28426,'com.liferay.commerce.price.list.model.CommercePriceListDiscountRel'),
(0,28427,'com.liferay.commerce.price.list.model.CommercePriceListOrderTypeRel'),
(0,28428,'com.liferay.commerce.price.list.model.CommerceTierPriceEntry'),
(0,28431,'com.liferay.depot.model.DepotAppCustomization'),
(0,28432,'com.liferay.depot.model.DepotEntry'),
(0,28433,'com.liferay.depot.model.DepotEntryGroupRel'),
(0,28436,'com.liferay.dynamic.data.mapping.model.DDMContent'),
(0,28437,'com.liferay.dynamic.data.mapping.model.DDMDataProviderInstance'),
(0,28438,'com.liferay.dynamic.data.mapping.model.DDMDataProviderInstanceLink'),
(0,28439,'com.liferay.dynamic.data.mapping.model.DDMField'),
(0,28440,'com.liferay.dynamic.data.mapping.model.DDMFieldAttribute'),
(0,28441,'com.liferay.dynamic.data.mapping.model.DDMFormInstance'),
(0,28442,'com.liferay.dynamic.data.mapping.model.DDMFormInstanceRecord'),
(0,28443,'com.liferay.dynamic.data.mapping.model.DDMFormInstanceRecordVersion'),
(0,28444,'com.liferay.dynamic.data.mapping.model.DDMFormInstanceReport'),
(0,28445,'com.liferay.dynamic.data.mapping.model.DDMFormInstanceVersion'),
(0,28446,'com.liferay.dynamic.data.mapping.model.DDMStorageLink'),
(0,28447,'com.liferay.dynamic.data.mapping.model.DDMStructure'),
(0,28448,'com.liferay.dynamic.data.mapping.model.DDMStructureLayout'),
(0,28449,'com.liferay.dynamic.data.mapping.model.DDMStructureLink'),
(0,28450,'com.liferay.dynamic.data.mapping.model.DDMStructureVersion'),
(0,28451,'com.liferay.dynamic.data.mapping.model.DDMTemplate'),
(0,28452,'com.liferay.dynamic.data.mapping.model.DDMTemplateLink'),
(0,28453,'com.liferay.dynamic.data.mapping.model.DDMTemplateVersion'),
(0,28456,'com.liferay.commerce.notification.model.CommerceNotificationAttachment'),
(0,28457,'com.liferay.commerce.notification.model.CommerceNotificationQueueEntry'),
(0,28458,'com.liferay.commerce.notification.model.CommerceNotificationTemplate'),
(0,28459,'com.liferay.commerce.notification.model.CommerceNotificationTemplateCommerceAccountGroupRel'),
(0,28462,'com.liferay.portal.lock.model.Lock'),
(0,28465,'com.liferay.layout.seo.model.LayoutSEOEntry'),
(0,28466,'com.liferay.layout.seo.model.LayoutSEOSite'),
(0,28469,'com.liferay.asset.category.property.model.AssetCategoryProperty'),
(0,28472,'com.liferay.saved.content.model.SavedContentEntry'),
(0,28475,'com.liferay.push.notifications.model.PushNotificationsDevice'),
(0,28478,'com.liferay.commerce.qualifier.model.CommerceQualifierEntry'),
(0,28481,'com.liferay.adaptive.media.image.model.AMImageEntry'),
(0,28484,'com.liferay.commerce.payment.model.CommercePaymentEntry'),
(0,28485,'com.liferay.commerce.payment.model.CommercePaymentEntryAudit'),
(0,28486,'com.liferay.commerce.payment.model.CommercePaymentMethodGroupRel'),
(0,28487,'com.liferay.commerce.payment.model.CommercePaymentMethodGroupRelQualifier'),
(0,28502,'com.liferay.friendly.url.model.FriendlyURLEntry'),
(0,28503,'com.liferay.friendly.url.model.FriendlyURLEntryLocalization'),
(0,28504,'com.liferay.friendly.url.model.FriendlyURLEntryMapping'),
(0,28507,'com.liferay.template.model.TemplateEntry'),
(0,28510,'com.liferay.object.model.ObjectAction'),
(0,28511,'com.liferay.object.model.ObjectDefinition'),
(0,28512,'com.liferay.object.model.ObjectEntry'),
(0,28513,'com.liferay.object.model.ObjectField'),
(0,28514,'com.liferay.object.model.ObjectFieldSetting'),
(0,28515,'com.liferay.object.model.ObjectFilter'),
(0,28516,'com.liferay.object.model.ObjectFolder'),
(0,28517,'com.liferay.object.model.ObjectFolderItem'),
(0,28518,'com.liferay.object.model.ObjectLayout'),
(0,28519,'com.liferay.object.model.ObjectLayoutBox'),
(0,28520,'com.liferay.object.model.ObjectLayoutColumn'),
(0,28521,'com.liferay.object.model.ObjectLayoutRow'),
(0,28522,'com.liferay.object.model.ObjectLayoutTab'),
(0,28523,'com.liferay.object.model.ObjectRelationship'),
(0,28524,'com.liferay.object.model.ObjectState'),
(0,28525,'com.liferay.object.model.ObjectStateFlow'),
(0,28526,'com.liferay.object.model.ObjectStateTransition'),
(0,28527,'com.liferay.object.model.ObjectValidationRule'),
(0,28528,'com.liferay.object.model.ObjectValidationRuleSetting'),
(0,28529,'com.liferay.object.model.ObjectView'),
(0,28530,'com.liferay.object.model.ObjectViewColumn'),
(0,28531,'com.liferay.object.model.ObjectViewFilterColumn'),
(0,28532,'com.liferay.object.model.ObjectViewSortColumn'),
(0,28535,'com.liferay.commerce.shop.by.diagram.model.CSDiagramEntry'),
(0,28536,'com.liferay.commerce.shop.by.diagram.model.CSDiagramPin'),
(0,28537,'com.liferay.commerce.shop.by.diagram.model.CSDiagramSetting'),
(0,28540,'com.liferay.site.model.SiteFriendlyURL'),
(0,28544,'com.liferay.commerce.wish.list.model.CommerceWishList'),
(0,28545,'com.liferay.commerce.wish.list.model.CommerceWishListItem'),
(0,28548,'com.liferay.knowledge.base.model.KBArticle'),
(0,28549,'com.liferay.knowledge.base.model.KBComment'),
(0,28550,'com.liferay.knowledge.base.model.KBFolder'),
(0,28551,'com.liferay.knowledge.base.model.KBTemplate'),
(0,28554,'com.liferay.json.storage.model.JSONStorageEntry'),
(0,28601,'com.liferay.client.extension.model.ClientExtensionEntry'),
(0,28602,'com.liferay.client.extension.model.ClientExtensionEntryRel'),
(0,28605,'com.liferay.list.type.model.ListTypeDefinition'),
(0,28606,'com.liferay.list.type.model.ListTypeEntry'),
(0,28609,'com.liferay.commerce.shipping.engine.fixed.model.CommerceShippingFixedOption'),
(0,28610,'com.liferay.commerce.shipping.engine.fixed.model.CommerceShippingFixedOptionQualifier'),
(0,28611,'com.liferay.commerce.shipping.engine.fixed.model.CommerceShippingFixedOptionRel'),
(0,28614,'com.liferay.portal.security.service.access.policy.model.SAPEntry'),
(0,28631,'com.liferay.microblogs.model.MicroblogsEntry'),
(0,28703,'com.liferay.commerce.order.rule.model.COREntry'),
(0,28704,'com.liferay.commerce.order.rule.model.COREntryRel'),
(0,28707,'com.liferay.account.model.AccountEntry'),
(0,28708,'com.liferay.account.model.AccountEntryOrganizationRel'),
(0,28709,'com.liferay.account.model.AccountEntryUserRel'),
(0,28710,'com.liferay.account.model.AccountGroup'),
(0,28711,'com.liferay.account.model.AccountGroupRel'),
(0,28712,'com.liferay.account.model.AccountRole'),
(0,28722,'com.liferay.site.navigation.model.SiteNavigationMenu'),
(0,28723,'com.liferay.site.navigation.model.SiteNavigationMenuItem'),
(0,28726,'com.liferay.invitation.invite.members.model.MemberRequest'),
(0,28729,'com.liferay.sharing.model.SharingEntry'),
(0,28732,'com.liferay.changeset.model.ChangesetCollection'),
(0,28733,'com.liferay.changeset.model.ChangesetEntry'),
(0,28736,'com.liferay.asset.list.model.AssetListEntry'),
(0,28737,'com.liferay.asset.list.model.AssetListEntryAssetEntryRel'),
(0,28738,'com.liferay.asset.list.model.AssetListEntrySegmentsEntryRel'),
(0,28739,'com.liferay.asset.list.model.AssetListEntryUsage'),
(0,28742,'com.liferay.commerce.inventory.model.CommerceInventoryAudit'),
(0,28743,'com.liferay.commerce.inventory.model.CommerceInventoryBookedQuantity'),
(0,28744,'com.liferay.commerce.inventory.model.CommerceInventoryReplenishmentItem'),
(0,28745,'com.liferay.commerce.inventory.model.CommerceInventoryWarehouse'),
(0,28746,'com.liferay.commerce.inventory.model.CommerceInventoryWarehouseItem'),
(0,28747,'com.liferay.commerce.inventory.model.CommerceInventoryWarehouseRel'),
(0,28750,'com.liferay.translation.model.TranslationEntry'),
(0,28753,'com.liferay.document.library.content.model.DLContent'),
(0,28756,'com.liferay.reading.time.model.ReadingTimeEntry'),
(0,28759,'com.liferay.dispatch.model.DispatchLog'),
(0,28760,'com.liferay.dispatch.model.DispatchTrigger'),
(0,28763,'com.liferay.analytics.message.storage.model.AnalyticsAssociation'),
(0,28764,'com.liferay.analytics.message.storage.model.AnalyticsDeleteMessage'),
(0,28765,'com.liferay.analytics.message.storage.model.AnalyticsMessage'),
(0,28768,'com.liferay.commerce.product.type.grouped.model.CPDefinitionGroupedEntry'),
(0,28771,'com.liferay.asset.display.page.model.AssetDisplayPageEntry'),
(0,28774,'com.liferay.portal.security.audit.storage.model.AuditEvent'),
(0,28777,'com.liferay.message.boards.model.MBBan'),
(0,28778,'com.liferay.message.boards.model.MBCategory'),
(0,28779,'com.liferay.message.boards.model.MBDiscussion'),
(0,28780,'com.liferay.message.boards.model.MBMailingList'),
(0,28781,'com.liferay.message.boards.model.MBMessage'),
(0,28782,'com.liferay.message.boards.model.MBSuspiciousActivity'),
(0,28783,'com.liferay.message.boards.model.MBThread'),
(0,28784,'com.liferay.message.boards.model.MBThreadFlag'),
(0,28787,'com.liferay.layout.model.LayoutClassedModelUsage'),
(0,28788,'com.liferay.layout.model.LayoutLocalization'),
(0,28791,'com.liferay.segments.model.SegmentsEntry'),
(0,28792,'com.liferay.segments.model.SegmentsEntryRel'),
(0,28793,'com.liferay.segments.model.SegmentsEntryRole'),
(0,28794,'com.liferay.segments.model.SegmentsExperience'),
(0,28795,'com.liferay.segments.model.SegmentsExperiment'),
(0,28796,'com.liferay.segments.model.SegmentsExperimentRel'),
(0,28799,'com.liferay.redirect.model.RedirectEntry'),
(0,28800,'com.liferay.redirect.model.RedirectNotFoundEntry'),
(0,28803,'com.liferay.batch.engine.model.BatchEngineExportTask'),
(0,28804,'com.liferay.batch.engine.model.BatchEngineImportTask'),
(0,28805,'com.liferay.batch.engine.model.BatchEngineImportTaskError'),
(0,28808,'com.liferay.wiki.model.WikiNode'),
(0,28809,'com.liferay.wiki.model.WikiPage'),
(0,28810,'com.liferay.wiki.model.WikiPageResource'),
(0,28813,'com.liferay.dynamic.data.lists.model.DDLRecord'),
(0,28814,'com.liferay.dynamic.data.lists.model.DDLRecordSet'),
(0,28815,'com.liferay.dynamic.data.lists.model.DDLRecordSetVersion'),
(0,28816,'com.liferay.dynamic.data.lists.model.DDLRecordVersion'),
(0,28819,'com.liferay.commerce.product.type.virtual.order.model.CommerceVirtualOrderItem'),
(0,28820,'com.liferay.commerce.product.type.virtual.order.model.CommerceVirtualOrderItemFileEntry'),
(0,28823,'com.liferay.notification.model.NotificationQueueEntry'),
(0,28824,'com.liferay.notification.model.NotificationQueueEntryAttachment'),
(0,28825,'com.liferay.notification.model.NotificationRecipient'),
(0,28826,'com.liferay.notification.model.NotificationRecipientSetting'),
(0,28827,'com.liferay.notification.model.NotificationTemplate'),
(0,28828,'com.liferay.notification.model.NotificationTemplateAttachment'),
(0,28831,'com.liferay.commerce.tax.model.CommerceTaxMethod'),
(0,28834,'com.liferay.marketplace.model.App'),
(0,28835,'com.liferay.marketplace.model.Module'),
(0,28838,'com.liferay.journal.model.JournalArticle'),
(0,28839,'com.liferay.journal.model.JournalArticleLocalization'),
(0,28840,'com.liferay.journal.model.JournalArticleResource'),
(0,28841,'com.liferay.journal.model.JournalContentSearch'),
(0,28842,'com.liferay.journal.model.JournalFeed'),
(0,28843,'com.liferay.journal.model.JournalFolder'),
(0,28846,'com.liferay.commerce.discount.model.CommerceDiscount'),
(0,28847,'com.liferay.commerce.discount.model.CommerceDiscountAccountRel'),
(0,28848,'com.liferay.commerce.discount.model.CommerceDiscountCommerceAccountGroupRel'),
(0,28849,'com.liferay.commerce.discount.model.CommerceDiscountOrderTypeRel'),
(0,28850,'com.liferay.commerce.discount.model.CommerceDiscountRel'),
(0,28851,'com.liferay.commerce.discount.model.CommerceDiscountRule'),
(0,28852,'com.liferay.commerce.discount.model.CommerceDiscountUsageEntry'),
(0,28855,'com.liferay.asset.link.model.AssetLink'),
(0,28858,'com.liferay.subscription.model.Subscription'),
(0,28861,'com.liferay.asset.entry.rel.model.AssetEntryAssetCategoryRel'),
(0,28864,'com.liferay.fragment.model.FragmentCollection'),
(0,28865,'com.liferay.fragment.model.FragmentComposition'),
(0,28866,'com.liferay.fragment.model.FragmentEntry'),
(0,28867,'com.liferay.fragment.model.FragmentEntryLink'),
(0,28868,'com.liferay.fragment.model.FragmentEntryVersion'),
(0,28871,'com.liferay.change.tracking.store.model.CTSContent'),
(0,28874,'com.liferay.commerce.product.type.virtual.model.CPDefinitionVirtualSetting'),
(0,28875,'com.liferay.commerce.product.type.virtual.model.CPDVirtualSettingFileEntry'),
(0,28878,'com.liferay.document.library.model.DLFileVersionPreview'),
(0,28879,'com.liferay.document.library.model.DLStorageQuota'),
(0,28882,'com.liferay.oauth2.provider.model.OAuth2Application'),
(0,28883,'com.liferay.oauth2.provider.model.OAuth2ApplicationScopeAliases'),
(0,28884,'com.liferay.oauth2.provider.model.OAuth2Authorization'),
(0,28885,'com.liferay.oauth2.provider.model.OAuth2ScopeGrant'),
(0,28888,'com.liferay.trash.model.TrashEntry'),
(0,28889,'com.liferay.trash.model.TrashVersion'),
(0,28892,'com.liferay.commerce.tax.engine.fixed.model.CommerceTaxFixedRate'),
(0,28893,'com.liferay.commerce.tax.engine.fixed.model.CommerceTaxFixedRateAddressRel'),
(0,28896,'com.liferay.commerce.pricing.model.CommercePriceModifier'),
(0,28897,'com.liferay.commerce.pricing.model.CommercePriceModifierRel'),
(0,28898,'com.liferay.commerce.pricing.model.CommercePricingClass'),
(0,28899,'com.liferay.commerce.pricing.model.CommercePricingClassCPDefinitionRel'),
(0,28902,'com.liferay.commerce.product.model.CommerceCatalog'),
(0,28903,'com.liferay.commerce.product.model.CommerceChannel'),
(0,28904,'com.liferay.commerce.product.model.CommerceChannelAccountEntryRel'),
(0,28905,'com.liferay.commerce.product.model.CommerceChannelRel'),
(0,28906,'com.liferay.commerce.product.model.CPAttachmentFileEntry'),
(0,28907,'com.liferay.commerce.product.model.CPDefinition'),
(0,28908,'com.liferay.commerce.product.model.CPDefinitionLink'),
(0,28909,'com.liferay.commerce.product.model.CPDefinitionLocalization'),
(0,28910,'com.liferay.commerce.product.model.CPDefinitionOptionRel'),
(0,28911,'com.liferay.commerce.product.model.CPDefinitionOptionValueRel'),
(0,28912,'com.liferay.commerce.product.model.CPDefinitionSpecificationOptionValue'),
(0,28913,'com.liferay.commerce.product.model.CPDisplayLayout'),
(0,28914,'com.liferay.commerce.product.model.CPInstance'),
(0,28915,'com.liferay.commerce.product.model.CPInstanceOptionValueRel'),
(0,28916,'com.liferay.commerce.product.model.CPInstanceUnitOfMeasure'),
(0,28917,'com.liferay.commerce.product.model.CPMeasurementUnit'),
(0,28918,'com.liferay.commerce.product.model.CPOption'),
(0,28919,'com.liferay.commerce.product.model.CPOptionCategory'),
(0,28920,'com.liferay.commerce.product.model.CPOptionValue'),
(0,28921,'com.liferay.commerce.product.model.CProduct'),
(0,28922,'com.liferay.commerce.product.model.CPSpecificationOption'),
(0,28923,'com.liferay.commerce.product.model.CPTaxCategory'),
(0,28927,'com.liferay.document.library.sync.model.DLSyncEvent'),
(0,28930,'com.liferay.style.book.model.StyleBookEntry'),
(0,28931,'com.liferay.style.book.model.StyleBookEntryVersion'),
(0,28934,'com.liferay.layout.utility.page.model.LayoutUtilityPageEntry'),
(0,28937,'com.liferay.oauth.client.persistence.model.OAuthClientASLocalMetadata'),
(0,28938,'com.liferay.oauth.client.persistence.model.OAuthClientEntry'),
(0,28941,'com.liferay.commerce.currency.model.CommerceCurrency'),
(0,28944,'com.liferay.document.library.opener.model.DLOpenerFileEntryReference'),
(0,28947,'com.liferay.bookmarks.model.BookmarksEntry'),
(0,28948,'com.liferay.bookmarks.model.BookmarksFolder'),
(0,28951,'com.liferay.asset.auto.tagger.model.AssetAutoTaggerEntry'),
(0,28954,'com.liferay.contacts.model.Entry'),
(0,28957,'com.liferay.calendar.model.Calendar'),
(0,28958,'com.liferay.calendar.model.CalendarBooking'),
(0,28959,'com.liferay.calendar.model.CalendarNotificationTemplate'),
(0,28960,'com.liferay.calendar.model.CalendarResource'),
(0,28963,'com.liferay.portal.security.sso.openid.connect.persistence.model.OpenIdConnectSession'),
(0,28966,'com.liferay.portal.language.override.model.PLOEntry'),
(0,28979,'com.liferay.layout.page.template.model.LayoutPageTemplateCollection'),
(0,28980,'com.liferay.layout.page.template.model.LayoutPageTemplateEntry'),
(0,28981,'com.liferay.layout.page.template.model.LayoutPageTemplateStructure'),
(0,28982,'com.liferay.layout.page.template.model.LayoutPageTemplateStructureRel'),
(0,28985,'com.liferay.batch.planner.model.BatchPlannerMapping'),
(0,28986,'com.liferay.batch.planner.model.BatchPlannerPlan'),
(0,28987,'com.liferay.batch.planner.model.BatchPlannerPolicy'),
(0,29001,'com.liferay.view.count.model.ViewCountEntry'),
(0,29004,'com.liferay.commerce.term.model.CommerceTermEntry'),
(0,29005,'com.liferay.commerce.term.model.CommerceTermEntryRel'),
(0,29006,'com.liferay.commerce.term.model.CTermEntryLocalization'),
(0,29009,'com.liferay.portal.workflow.kaleo.model.KaleoAction'),
(0,29010,'com.liferay.portal.workflow.kaleo.model.KaleoCondition'),
(0,29011,'com.liferay.portal.workflow.kaleo.model.KaleoDefinition'),
(0,29012,'com.liferay.portal.workflow.kaleo.model.KaleoDefinitionVersion'),
(0,29013,'com.liferay.portal.workflow.kaleo.model.KaleoInstance'),
(0,29014,'com.liferay.portal.workflow.kaleo.model.KaleoInstanceToken'),
(0,29015,'com.liferay.portal.workflow.kaleo.model.KaleoLog'),
(0,29016,'com.liferay.portal.workflow.kaleo.model.KaleoNode'),
(0,29017,'com.liferay.portal.workflow.kaleo.model.KaleoNotification'),
(0,29018,'com.liferay.portal.workflow.kaleo.model.KaleoNotificationRecipient'),
(0,29019,'com.liferay.portal.workflow.kaleo.model.KaleoTask'),
(0,29020,'com.liferay.portal.workflow.kaleo.model.KaleoTaskAssignment'),
(0,29021,'com.liferay.portal.workflow.kaleo.model.KaleoTaskAssignmentInstance'),
(0,29022,'com.liferay.portal.workflow.kaleo.model.KaleoTaskForm'),
(0,29023,'com.liferay.portal.workflow.kaleo.model.KaleoTaskFormInstance'),
(0,29024,'com.liferay.portal.workflow.kaleo.model.KaleoTaskInstanceToken'),
(0,29025,'com.liferay.portal.workflow.kaleo.model.KaleoTimer'),
(0,29026,'com.liferay.portal.workflow.kaleo.model.KaleoTimerInstanceToken'),
(0,29027,'com.liferay.portal.workflow.kaleo.model.KaleoTransition'),
(0,29030,'com.liferay.portal.background.task.model.BackgroundTask'),
(0,29033,'com.liferay.blogs.model.BlogsEntry'),
(0,29036,'com.liferay.change.tracking.model.CTAutoResolutionInfo'),
(0,29037,'com.liferay.change.tracking.model.CTCollection'),
(0,29038,'com.liferay.change.tracking.model.CTCollectionTemplate'),
(0,29039,'com.liferay.change.tracking.model.CTComment'),
(0,29040,'com.liferay.change.tracking.model.CTEntry'),
(0,29041,'com.liferay.change.tracking.model.CTMessage'),
(0,29042,'com.liferay.change.tracking.model.CTPreferences'),
(0,29043,'com.liferay.change.tracking.model.CTProcess'),
(0,29044,'com.liferay.change.tracking.model.CTRemote'),
(0,29045,'com.liferay.change.tracking.model.CTSchemaVersion'),
(0,29048,'com.liferay.data.engine.model.DEDataDefinitionFieldLink'),
(0,29049,'com.liferay.data.engine.model.DEDataListView'),
(0,30602,'com.liferay.document.library.kernel.processor.RawMetadataProcessor'),
(0,31243,'com.liferay.commerce.product.content.category.web.internal.portlet.CPCategoryContentPortlet'),
(0,31244,'com.liferay.portlet.display.template.PortletDisplayTemplate'),
(0,31248,'com.liferay.commerce.cart.content.web.internal.portlet.CommerceCartContentMiniPortlet'),
(0,31252,'com.liferay.commerce.cart.content.web.internal.portlet.CommerceCartContentPortlet'),
(0,31256,'com.liferay.commerce.cart.content.web.internal.portlet.CommerceCartContentTotalPortlet'),
(0,31266,'com.liferay.commerce.product.content.search.web.internal.display.context.CPOptionsSearchFacetDisplayContext'),
(0,31276,'com.liferay.commerce.product.content.search.web.internal.portlet.CPSearchResultsPortlet'),
(0,31280,'com.liferay.commerce.product.content.search.web.internal.display.context.CPSpecificationOptionsSearchFacetTermDisplayContext'),
(0,31290,'com.liferay.portal.kernel.servlet.taglib.ui.BreadcrumbEntry'),
(0,31300,'com.liferay.portal.kernel.repository.model.FileEntry'),
(0,31307,'com.liferay.rss.web.internal.util.RSSFeed'),
(0,31500,'com.liferay.portal.search.web.internal.category.facet.portlet.CategoryFacetPortlet'),
(0,31513,'com.liferay.portal.search.web.internal.custom.facet.portlet.CustomFacetPortlet'),
(0,31520,'com.liferay.portal.search.web.internal.custom.filter.display.context.CustomFilterDisplayContext'),
(0,31524,'com.liferay.portal.search.web.internal.date.facet.portlet.DateFacetPortlet'),
(0,31534,'com.liferay.portal.search.web.internal.folder.facet.portlet.FolderFacetPortlet'),
(0,31541,'com.liferay.portal.search.web.internal.modified.facet.portlet.ModifiedFacetPortlet'),
(0,31545,'com.liferay.portal.search.web.internal.search.bar.portlet.SearchBarPortlet'),
(0,31549,'com.liferay.portal.search.web.internal.result.display.context.SearchResultSummaryDisplayContext'),
(0,31559,'com.liferay.portal.search.web.internal.site.facet.portlet.SiteFacetPortlet'),
(0,31566,'com.liferay.portal.search.web.internal.sort.display.context.SortDisplayContext'),
(0,31570,'com.liferay.portal.search.web.internal.tag.facet.portlet.TagFacetPortlet'),
(0,31580,'com.liferay.portal.search.web.internal.type.facet.portlet.TypeFacetPortlet'),
(0,31587,'com.liferay.portal.search.web.internal.user.facet.portlet.UserFacetPortlet'),
(0,31594,'com.liferay.commerce.address.content.web.internal.portlet.CommerceAddressContentPortlet'),
(0,31598,'com.liferay.portal.kernel.theme.NavItem'),
(0,31635,'com.liferay.portal.kernel.servlet.taglib.ui.LanguageEntry'),
(0,31666,'com.liferay.info.item.provider.InfoItemFormProvider'),
(0,31667,'com.liferay.commerce.order.content.web.internal.portlet.CommerceOrderContentPortlet'),
(0,31668,'com.liferay.commerce.product.content.web.internal.portlet.CPContentPortlet'),
(0,31669,'com.liferay.commerce.product.content.web.internal.portlet.CPCompareContentMiniPortlet'),
(0,31670,'com.liferay.commerce.product.type.virtual.order.content.web.internal.portlet.CommerceVirtualOrderItemContentPortlet'),
(0,31671,'com.liferay.commerce.product.content.web.internal.portlet.CPCompareContentPortlet'),
(0,31672,'com.liferay.commerce.order.content.web.internal.portlet.CommerceOpenOrderContentPortlet'),
(0,31673,'com.liferay.commerce.product.asset.categories.navigation.web.internal.portlet.CPAssetCategoriesNavigationPortlet'),
(0,31674,'com.liferay.commerce.product.content.web.internal.portlet.CPPublisherPortlet'),
(0,31675,'com.liferay.expando.model.adapter.StagedExpandoTable'),
(0,31676,'com.liferay.expando.kernel.model.adapter.StagedExpandoColumn'),
(0,31678,'com.liferay.portal.kernel.model.Layout-true'),
(0,31694,'com.liferay.portal.kernel.model.Layout-false'),
(0,31712,'com.liferay.portal.repository.portletrepository.PortletRepository'),
(0,31715,'com.liferay.portal.repository.liferayrepository.LiferayRepository'),
(0,31716,'com.liferay.portal.repository.temporaryrepository.TemporaryFileEntryRepository'),
(0,31818,'com.liferay.layout.util.structure.CollectionStyledLayoutStructureItem'),
(0,33011,'com.liferay.data.engine.internal.content.type.DefaultDataDefinitionContentType'),
(0,33271,'com.liferay.object.model.ObjectDefinition#33205'),
(0,33299,'com.liferay.object.model.ObjectDefinition#33233');

--
