<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table COREntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	COREntryId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	active_ BOOLEAN,
	description VARCHAR(75) null,
	displayDate DATE null,
	expirationDate DATE null,
	name VARCHAR(75) null,
	priority INTEGER,
	type_ VARCHAR(75) null,
	typeSettings TEXT null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null
);

create table COREntryRel (
	mvccVersion LONG default 0 not null,
	COREntryRelId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	COREntryId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_E0154022 on COREntry (companyId, active_, type_[$COLUMN_LENGTH:75$]);
create unique index IX_4BD0EB07 on COREntry (companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_FDA23B9F on COREntry (companyId, type_[$COLUMN_LENGTH:75$]);
create index IX_8599BE68 on COREntry (status, displayDate);
create index IX_4AFDBD89 on COREntry (status, expirationDate);
create index IX_DD753A02 on COREntry (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_EA6EFFC3 on COREntryRel (COREntryId, classNameId, classPK);]]></indexes-sql>
</data>