<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CTermEntryLocalization (
	mvccVersion LONG default 0 not null,
	cTermEntryLocalizationId LONG not null primary key,
	companyId LONG,
	commerceTermEntryId LONG,
	languageId VARCHAR(75) null,
	description TEXT null,
	label VARCHAR(75) null
);

create table CommerceTermEntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	defaultLanguageId VARCHAR(75) null,
	commerceTermEntryId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	active_ BOOLEAN,
	displayDate DATE null,
	expirationDate DATE null,
	name VARCHAR(75) null,
	priority DOUBLE,
	type_ VARCHAR(75) null,
	typeSettings VARCHAR(75) null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null
);

create table CommerceTermEntryRel (
	mvccVersion LONG default 0 not null,
	commerceTermEntryRelId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	commerceTermEntryId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_B197F41B on CTermEntryLocalization (commerceTermEntryId, languageId[$COLUMN_LENGTH:75$]);

create index IX_E73B0D12 on CommerceTermEntry (companyId, active_);
create unique index IX_B241C786 on CommerceTermEntry (companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_2AB59656 on CommerceTermEntry (companyId, name[$COLUMN_LENGTH:75$]);
create index IX_E90D7AAB on CommerceTermEntry (companyId, type_[$COLUMN_LENGTH:75$], active_);
create unique index IX_F91A2436 on CommerceTermEntry (companyId, type_[$COLUMN_LENGTH:75$], priority);
create index IX_25217F89 on CommerceTermEntry (status, displayDate);
create index IX_1E15CC8 on CommerceTermEntry (status, expirationDate);
create index IX_7C4118E3 on CommerceTermEntry (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_2AA8B117 on CommerceTermEntryRel (commerceTermEntryId, classNameId, classPK);]]></indexes-sql>
</data>