<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[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)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_430D791F on BlogsEntry (companyId, displayDate);
create index IX_8CACE77B on BlogsEntry (companyId, userId);
create unique index IX_D05A3CBC on BlogsEntry (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_D6281CFE on BlogsEntry (groupId, ctCollectionId, urlTitle[$COLUMN_LENGTH:255$]);
create index IX_621E19D on BlogsEntry (groupId, displayDate);
create index IX_FBDE0AA3 on BlogsEntry (groupId, userId, displayDate);
create unique index IX_69B961AF on BlogsEntry (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_7B596F05 on BlogsEntry (status, companyId, displayDate);
create index IX_D1CC59D5 on BlogsEntry (status, companyId, userId);
create index IX_67121F73 on BlogsEntry (status, displayDate);
create index IX_EC9E1903 on BlogsEntry (status, groupId, displayDate);
create index IX_6D777C09 on BlogsEntry (status, groupId, userId, displayDate);
create index IX_69157A4D on BlogsEntry (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>