<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table ClientExtensionEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	clientExtensionEntryId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	description TEXT null,
	name STRING null,
	properties TEXT null,
	sourceCodeURL STRING null,
	type_ VARCHAR(75) null,
	typeSettings TEXT null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (clientExtensionEntryId, ctCollectionId)
);

create table ClientExtensionEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	clientExtensionEntryRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	cetExternalReferenceCode VARCHAR(75) null,
	type_ VARCHAR(75) null,
	typeSettings TEXT null,
	lastPublishDate DATE null,
	primary key (clientExtensionEntryRelId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_EFD3CBF7 on ClientExtensionEntry (companyId, externalReferenceCode[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_32C1FC31 on ClientExtensionEntry (companyId, type_[$COLUMN_LENGTH:75$]);
create index IX_526820B0 on ClientExtensionEntry (uuid_[$COLUMN_LENGTH:75$]);

create index IX_A3BB58FF on ClientExtensionEntryRel (classNameId, classPK, type_[$COLUMN_LENGTH:75$]);
create index IX_44C5316 on ClientExtensionEntryRel (companyId, cetExternalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_DB5627B6 on ClientExtensionEntryRel (groupId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_E6F09C55 on ClientExtensionEntryRel (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);]]></indexes-sql>
</data>