<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table LayoutClassedModelUsage (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	layoutClassedModelUsageId LONG not null,
	groupId LONG,
	companyId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	cmExternalReferenceCode VARCHAR(75) null,
	containerKey VARCHAR(200) null,
	containerType LONG,
	plid LONG,
	type_ INTEGER,
	lastPublishDate DATE null,
	primary key (layoutClassedModelUsageId, ctCollectionId)
);

create table LayoutLocalization (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	layoutLocalizationId LONG not null,
	groupId LONG,
	companyId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	content TEXT null,
	languageId VARCHAR(75) null,
	plid LONG,
	lastPublishDate DATE null,
	primary key (layoutLocalizationId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_DCAD0AD3 on LayoutClassedModelUsage (classNameId, classPK, cmExternalReferenceCode[$COLUMN_LENGTH:75$], containerType, plid, containerKey[$COLUMN_LENGTH:200$], ctCollectionId);
create index IX_B041F1F5 on LayoutClassedModelUsage (classNameId, classPK, type_);
create index IX_B51E9567 on LayoutClassedModelUsage (classNameId, companyId, cmExternalReferenceCode[$COLUMN_LENGTH:75$], type_);
create index IX_6AAEDC6 on LayoutClassedModelUsage (classNameId, companyId, containerType);
create index IX_F747B9BD on LayoutClassedModelUsage (containerType, plid, containerKey[$COLUMN_LENGTH:200$]);
create index IX_19448DD6 on LayoutClassedModelUsage (plid);
create unique index IX_EC008A3 on LayoutClassedModelUsage (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create unique index IX_7925C939 on LayoutLocalization (plid, ctCollectionId, languageId[$COLUMN_LENGTH:75$]);
create unique index IX_8DC09EE1 on LayoutLocalization (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);]]></indexes-sql>
</data>