<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CSFixedOptionQualifier (
	mvccVersion LONG default 0 not null,
	CSFixedOptionQualifierId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	commerceShippingFixedOptionId LONG
);

create table CShippingFixedOptionRel (
	mvccVersion LONG default 0 not null,
	CShippingFixedOptionRelId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceShippingMethodId LONG,
	commerceShippingFixedOptionId LONG,
	commerceInventoryWarehouseId LONG,
	countryId LONG,
	regionId LONG,
	zip VARCHAR(75) null,
	weightFrom DOUBLE,
	weightTo DOUBLE,
	fixedPrice BIGDECIMAL null,
	rateUnitWeightPrice BIGDECIMAL null,
	ratePercentage DOUBLE
);

create table CommerceShippingFixedOption (
	mvccVersion LONG default 0 not null,
	commerceShippingFixedOptionId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceShippingMethodId LONG,
	amount BIGDECIMAL null,
	description STRING null,
	key_ VARCHAR(75) null,
	name STRING null,
	priority DOUBLE
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_1D29E189 on CSFixedOptionQualifier (commerceShippingFixedOptionId, classNameId, classPK);

create index IX_D89A7E24 on CShippingFixedOptionRel (commerceShippingFixedOptionId);
create index IX_4AA09D60 on CShippingFixedOptionRel (commerceShippingMethodId);

create index IX_DCB21C1F on CommerceShippingFixedOption (commerceShippingMethodId);
create unique index IX_BCEAE976 on CommerceShippingFixedOption (companyId, key_[$COLUMN_LENGTH:75$]);]]></indexes-sql>
</data>