-- lportal.CPAttachmentFileEntry definition

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,
  `displayDate` datetime(6) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `title` longtext,
  `json` longtext,
  `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_6B55EC7F` (`companyId`,`externalReferenceCode`,`ctCollectionId`),
  UNIQUE KEY `IX_50416EE0` (`uuid_`,`groupId`,`ctCollectionId`),
  KEY `IX_8DE7A0B5` (`classNameId`,`classPK`,`cdnURL`(255),`ctCollectionId`),
  KEY `IX_E53AD4BF` (`classNameId`,`classPK`,`ctCollectionId`),
  KEY `IX_68966943` (`classNameId`,`classPK`,`displayDate`,`status`,`ctCollectionId`),
  KEY `IX_7C51979E` (`classNameId`,`classPK`,`fileEntryId`,`ctCollectionId`),
  KEY `IX_EDBD5798` (`classNameId`,`classPK`,`type_`,`status`,`ctCollectionId`),
  KEY `IX_8AF22978` (`displayDate`,`status`,`ctCollectionId`),
  KEY `IX_2DC4AC5E` (`uuid_`,`companyId`,`ctCollectionId`),
  KEY `IX_5C706B86` (`uuid_`,`ctCollectionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;