<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table TemplateEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	templateEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	ddmTemplateId LONG,
	infoItemClassName VARCHAR(75) null,
	infoItemFormVariationKey VARCHAR(75) null,
	lastPublishDate DATE null,
	primary key (templateEntryId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_9B9729B4 on TemplateEntry (ddmTemplateId);
create unique index IX_D36C36F3 on TemplateEntry (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_D011CDAB on TemplateEntry (groupId, infoItemClassName[$COLUMN_LENGTH:75$], infoItemFormVariationKey[$COLUMN_LENGTH:75$]);
create unique index IX_F7DCA9E6 on TemplateEntry (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_3AF3BA36 on TemplateEntry (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>