<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table ListTypeDefinition (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	listTypeDefinitionId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name STRING null,
	system_ BOOLEAN
);

create table ListTypeEntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	listTypeEntryId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	listTypeDefinitionId LONG,
	key_ VARCHAR(75) null,
	name STRING null,
	type_ VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_FF39F41C on ListTypeDefinition (externalReferenceCode[$COLUMN_LENGTH:75$], companyId);
create index IX_C3F53B03 on ListTypeDefinition (uuid_[$COLUMN_LENGTH:75$]);

create index IX_8FB531BD on ListTypeEntry (externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_C413932E on ListTypeEntry (listTypeDefinitionId, key_[$COLUMN_LENGTH:75$]);
create index IX_79966E34 on ListTypeEntry (uuid_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>