META-INF.sql.tables.sql Maven / Gradle / Ivy
The newest version!
create table BlogsEntry (
mvccVersion LONG default 0 not null,
ctCollectionId LONG default 0 not null,
uuid_ VARCHAR(75) null,
externalReferenceCode VARCHAR(75) null,
entryId LONG not null,
groupId LONG,
companyId LONG,
userId LONG,
userName VARCHAR(75) null,
createDate DATE null,
modifiedDate DATE null,
title VARCHAR(255) null,
subtitle STRING null,
urlTitle VARCHAR(255) null,
description STRING null,
content TEXT null,
displayDate DATE null,
allowPingbacks BOOLEAN,
allowTrackbacks BOOLEAN,
trackbacks TEXT null,
coverImageCaption STRING null,
coverImageFileEntryId LONG,
coverImageURL STRING null,
smallImage BOOLEAN,
smallImageFileEntryId LONG,
smallImageId LONG,
smallImageURL STRING null,
lastPublishDate DATE null,
status INTEGER,
statusByUserId LONG,
statusByUserName VARCHAR(75) null,
statusDate DATE null,
primary key (entryId, ctCollectionId)
);
© 2015 - 2025 Weber Informatics LLC | Privacy Policy