<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CommerceTaxFixedRate (
	mvccVersion LONG default 0 not null,
	commerceTaxFixedRateId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPTaxCategoryId LONG,
	commerceTaxMethodId LONG,
	rate DOUBLE
);

create table CommerceTaxFixedRateAddressRel (
	mvccVersion LONG default 0 not null,
	CTaxFixedRateAddressRelId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceTaxMethodId LONG,
	CPTaxCategoryId LONG,
	countryId LONG,
	regionId LONG,
	zip VARCHAR(75) null,
	rate DOUBLE
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_DA39AA7F on CommerceTaxFixedRate (CPTaxCategoryId, commerceTaxMethodId);
create index IX_52767DD2 on CommerceTaxFixedRate (commerceTaxMethodId);

create index IX_37AE3A58 on CommerceTaxFixedRateAddressRel (CPTaxCategoryId);
create index IX_CB69750D on CommerceTaxFixedRateAddressRel (commerceTaxMethodId);
create index IX_DB83CD12 on CommerceTaxFixedRateAddressRel (countryId);]]></indexes-sql>
</data>