<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table DEDataDefinitionFieldLink (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	deDataDefinitionFieldLinkId LONG not null,
	groupId LONG,
	companyId LONG,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	ddmStructureId LONG,
	fieldName VARCHAR(255) null,
	lastPublishDate DATE null,
	primary key (deDataDefinitionFieldLinkId, ctCollectionId)
);

create table DEDataListView (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	deDataListViewId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	appliedFilters TEXT null,
	ddmStructureId LONG,
	fieldNames TEXT null,
	name STRING null,
	sortField VARCHAR(75) null,
	primary key (deDataListViewId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_99628DD1 on DEDataDefinitionFieldLink (classNameId, classPK);
create unique index IX_B0B67DC9 on DEDataDefinitionFieldLink (ddmStructureId, classNameId, fieldName[$COLUMN_LENGTH:255$], classPK, ctCollectionId);
create index IX_E931B304 on DEDataDefinitionFieldLink (ddmStructureId, fieldName[$COLUMN_LENGTH:255$]);
create unique index IX_2F184154 on DEDataDefinitionFieldLink (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create index IX_1C932689 on DEDataListView (ddmStructureId);
create index IX_6C111CBD on DEDataListView (groupId, ddmStructureId, companyId);
create unique index IX_275E4568 on DEDataListView (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);]]></indexes-sql>
</data>