<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CChannelAccountEntryRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	CChannelAccountEntryRelId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	accountEntryId LONG,
	classNameId LONG,
	classPK LONG,
	commerceChannelId LONG,
	overrideEligibility BOOLEAN,
	priority DOUBLE,
	type_ INTEGER,
	primary key (CChannelAccountEntryRelId, ctCollectionId)
);

create table CPAttachmentFileEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPAttachmentFileEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	fileEntryId LONG,
	cdnEnabled BOOLEAN,
	cdnURL STRING null,
	displayDate DATE null,
	expirationDate DATE null,
	galleryEnabled BOOLEAN,
	title STRING null,
	json TEXT null,
	priority DOUBLE,
	type_ INTEGER,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (CPAttachmentFileEntryId, ctCollectionId)
);

create table CPDSpecificationOptionValue (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDSpecificationOptionValueId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CPSpecificationOptionId LONG,
	CPOptionCategoryId LONG,
	key_ VARCHAR(75) null,
	priority DOUBLE,
	value STRING null,
	lastPublishDate DATE null,
	primary key (CPDSpecificationOptionValueId, ctCollectionId)
);

create table CPDefinition (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	defaultLanguageId VARCHAR(75) null,
	CPDefinitionId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CProductId LONG,
	CPTaxCategoryId LONG,
	productTypeName VARCHAR(75) null,
	availableIndividually BOOLEAN,
	ignoreSKUCombinations BOOLEAN,
	shippable BOOLEAN,
	freeShipping BOOLEAN,
	shipSeparately BOOLEAN,
	shippingExtraPrice DOUBLE,
	width DOUBLE,
	height DOUBLE,
	depth DOUBLE,
	weight DOUBLE,
	taxExempt BOOLEAN,
	telcoOrElectronics BOOLEAN,
	DDMStructureKey VARCHAR(75) null,
	published BOOLEAN,
	displayDate DATE null,
	expirationDate DATE null,
	lastPublishDate DATE null,
	subscriptionEnabled BOOLEAN,
	subscriptionLength INTEGER,
	subscriptionType VARCHAR(75) null,
	subscriptionTypeSettings TEXT null,
	maxSubscriptionCycles LONG,
	deliverySubscriptionEnabled BOOLEAN,
	deliverySubscriptionLength INTEGER,
	deliverySubscriptionType VARCHAR(75) null,
	deliverySubTypeSettings VARCHAR(75) null,
	deliveryMaxSubscriptionCycles LONG,
	accountGroupFilterEnabled BOOLEAN,
	channelFilterEnabled BOOLEAN,
	version INTEGER,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (CPDefinitionId, ctCollectionId)
);

create table CPDefinitionLink (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDefinitionLinkId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CProductId LONG,
	displayDate DATE null,
	expirationDate DATE null,
	priority DOUBLE,
	type_ VARCHAR(75) null,
	lastPublishDate DATE null,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (CPDefinitionLinkId, ctCollectionId)
);

create table CPDefinitionLocalization (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	cpDefinitionLocalizationId LONG not null,
	companyId LONG,
	CPDefinitionId LONG,
	languageId VARCHAR(75) null,
	name STRING null,
	shortDescription STRING null,
	description TEXT null,
	metaTitle VARCHAR(255) null,
	metaDescription VARCHAR(255) null,
	metaKeywords VARCHAR(255) null,
	primary key (cpDefinitionLocalizationId, ctCollectionId)
);

create table CPDefinitionOptionRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDefinitionOptionRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CPOptionId LONG,
	name STRING null,
	description STRING null,
	commerceOptionTypeKey VARCHAR(75) null,
	infoItemServiceKey VARCHAR(255) null,
	priority DOUBLE,
	definedExternally BOOLEAN,
	facetable BOOLEAN,
	required BOOLEAN,
	skuContributor BOOLEAN,
	key_ VARCHAR(75) null,
	priceType VARCHAR(75) null,
	typeSettings TEXT null,
	primary key (CPDefinitionOptionRelId, ctCollectionId)
);

create table CPDefinitionOptionValueRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDefinitionOptionValueRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionOptionRelId LONG,
	CPInstanceUuid VARCHAR(75) null,
	CProductId LONG,
	key_ VARCHAR(75) null,
	name STRING null,
	preselected BOOLEAN,
	price BIGDECIMAL null,
	priority DOUBLE,
	quantity BIGDECIMAL null,
	unitOfMeasureKey VARCHAR(75) null,
	primary key (CPDefinitionOptionValueRelId, ctCollectionId)
);

create table CPDisplayLayout (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPDisplayLayoutId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	layoutPageTemplateEntryUuid VARCHAR(75) null,
	layoutUuid VARCHAR(75) null,
	primary key (CPDisplayLayoutId, ctCollectionId)
);

create table CPInstance (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPInstanceId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionId LONG,
	CPInstanceUuid VARCHAR(75) null,
	sku VARCHAR(75) null,
	gtin VARCHAR(75) null,
	manufacturerPartNumber VARCHAR(75) null,
	purchasable BOOLEAN,
	width DOUBLE,
	height DOUBLE,
	depth DOUBLE,
	weight DOUBLE,
	price BIGDECIMAL null,
	promoPrice BIGDECIMAL null,
	cost BIGDECIMAL null,
	published BOOLEAN,
	displayDate DATE null,
	expirationDate DATE null,
	lastPublishDate DATE null,
	overrideSubscriptionInfo BOOLEAN,
	subscriptionEnabled BOOLEAN,
	subscriptionLength INTEGER,
	subscriptionType VARCHAR(75) null,
	subscriptionTypeSettings TEXT null,
	maxSubscriptionCycles LONG,
	deliverySubscriptionEnabled BOOLEAN,
	deliverySubscriptionLength INTEGER,
	deliverySubscriptionType VARCHAR(75) null,
	deliverySubTypeSettings VARCHAR(75) null,
	deliveryMaxSubscriptionCycles LONG,
	unspsc VARCHAR(75) null,
	discontinued BOOLEAN,
	discontinuedDate DATE null,
	replacementCPInstanceUuid VARCHAR(75) null,
	replacementCProductId LONG,
	status INTEGER,
	statusByUserId LONG,
	statusByUserName VARCHAR(75) null,
	statusDate DATE null,
	primary key (CPInstanceId, ctCollectionId)
);

create table CPInstanceOptionValueRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPInstanceOptionValueRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPDefinitionOptionRelId LONG,
	CPDefinitionOptionValueRelId LONG,
	CPInstanceId LONG,
	primary key (CPInstanceOptionValueRelId, ctCollectionId)
);

create table CPInstanceUOM (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPInstanceUOMId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPInstanceId LONG,
	active_ BOOLEAN,
	incrementalOrderQuantity BIGDECIMAL null,
	key_ VARCHAR(75) null,
	name STRING null,
	precision_ INTEGER,
	primary_ BOOLEAN,
	priority DOUBLE,
	rate BIGDECIMAL null,
	sku VARCHAR(75) null,
	primary key (CPInstanceUOMId, ctCollectionId)
);

create table CPMeasurementUnit (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPMeasurementUnitId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name STRING null,
	key_ VARCHAR(75) null,
	rate DOUBLE,
	primary_ BOOLEAN,
	priority DOUBLE,
	type_ INTEGER,
	lastPublishDate DATE null,
	primary key (CPMeasurementUnitId, ctCollectionId)
);

create table CPOption (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPOptionId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name STRING null,
	description STRING null,
	commerceOptionTypeKey VARCHAR(75) null,
	facetable BOOLEAN,
	required BOOLEAN,
	skuContributor BOOLEAN,
	key_ VARCHAR(75) null,
	lastPublishDate DATE null,
	primary key (CPOptionId, ctCollectionId)
);

create table CPOptionCategory (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPOptionCategoryId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	title STRING null,
	description STRING null,
	priority DOUBLE,
	key_ VARCHAR(75) null,
	lastPublishDate DATE null,
	primary key (CPOptionCategoryId, ctCollectionId)
);

create table CPOptionValue (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPOptionValueId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPOptionId LONG,
	name STRING null,
	priority DOUBLE,
	key_ VARCHAR(75) null,
	lastPublishDate DATE null,
	primary key (CPOptionValueId, ctCollectionId)
);

create table CPSpecificationOption (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	CPSpecificationOptionId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	CPOptionCategoryId LONG,
	listTypeDefinitionId LONG,
	title STRING null,
	description STRING null,
	facetable BOOLEAN,
	key_ VARCHAR(75) null,
	priority DOUBLE,
	lastPublishDate DATE null,
	primary key (CPSpecificationOptionId, ctCollectionId)
);

create table CPTaxCategory (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CPTaxCategoryId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name STRING null,
	description STRING null,
	primary key (CPTaxCategoryId, ctCollectionId)
);

create table CProduct (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	CProductId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	publishedCPDefinitionId LONG,
	latestVersion INTEGER,
	primary key (CProductId, ctCollectionId)
);

create table CommerceCatalog (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	commerceCatalogId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	accountEntryId LONG,
	name VARCHAR(75) null,
	commerceCurrencyCode VARCHAR(75) null,
	catalogDefaultLanguageId VARCHAR(75) null,
	system_ BOOLEAN,
	primary key (commerceCatalogId, ctCollectionId)
);

create table CommerceChannel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	externalReferenceCode VARCHAR(75) null,
	commerceChannelId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	accountEntryId LONG,
	siteGroupId LONG,
	name VARCHAR(75) null,
	type_ VARCHAR(75) null,
	typeSettings VARCHAR(75) null,
	commerceCurrencyCode VARCHAR(75) null,
	priceDisplayType VARCHAR(75) null,
	discountsTargetNetPrice BOOLEAN,
	primary key (commerceChannelId, ctCollectionId)
);

create table CommerceChannelRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	commerceChannelRelId LONG not null,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	commerceChannelId LONG,
	primary key (commerceChannelRelId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_38280B2E on CChannelAccountEntryRel (accountEntryId);
create index IX_5F765A4F on CChannelAccountEntryRel (classNameId, classPK);
create unique index IX_7451E203 on CChannelAccountEntryRel (commerceChannelId, type_, accountEntryId, classNameId, classPK, ctCollectionId);
create index IX_E6E10CF1 on CChannelAccountEntryRel (commerceChannelId, type_, classNameId, classPK);
create index IX_52FD56CF on CChannelAccountEntryRel (type_, accountEntryId);

create index IX_4E725857 on CPAttachmentFileEntry (classNameId, classPK, cdnURL[$COLUMN_LENGTH:4000$]);
create index IX_DD114140 on CPAttachmentFileEntry (classNameId, classPK, fileEntryId);
create index IX_F34F24D9 on CPAttachmentFileEntry (classNameId, classPK, status, displayDate);
create index IX_5F3A96F1 on CPAttachmentFileEntry (classNameId, classPK, status, type_, galleryEnabled);
create index IX_6A165A0B on CPAttachmentFileEntry (classNameId, fileEntryId, groupId);
create unique index IX_25D041B5 on CPAttachmentFileEntry (ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$], companyId);
create index IX_5B2A1075 on CPAttachmentFileEntry (fileEntryId);
create index IX_E153EF0E on CPAttachmentFileEntry (status, displayDate);
create unique index IX_50416EE0 on CPAttachmentFileEntry (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create index IX_95975FB4 on CPDSpecificationOptionValue (CPDefinitionId, CPOptionCategoryId);
create index IX_173E8E91 on CPDSpecificationOptionValue (CPDefinitionId, CPSpecificationOptionId);
create unique index IX_CFB2B6D7 on CPDSpecificationOptionValue (CPDefinitionId, ctCollectionId, key_[$COLUMN_LENGTH:75$]);
create index IX_4F4EDBA5 on CPDSpecificationOptionValue (CPOptionCategoryId);
create index IX_573BE140 on CPDSpecificationOptionValue (CPSpecificationOptionId);
create index IX_8DA57014 on CPDSpecificationOptionValue (groupId);
create unique index IX_99CAED2A on CPDSpecificationOptionValue (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create index IX_3D5A0021 on CPDefinition (CPTaxCategoryId);
create index IX_1F4B9C67 on CPDefinition (CProductId, status);
create index IX_F1AEC8A7 on CPDefinition (CProductId, version);
create index IX_217AF702 on CPDefinition (companyId);
create index IX_419350EA on CPDefinition (groupId, status);
create index IX_99C4ED10 on CPDefinition (groupId, subscriptionEnabled);
create unique index IX_96393D8E on CPDefinition (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_E504F8F4 on CPDefinition (status, displayDate);
create index IX_46B4998E on CPDefinition (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_3A90EAC9 on CPDefinitionLink (CPDefinitionId, CProductId, type_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_5572A666 on CPDefinitionLink (CPDefinitionId, type_[$COLUMN_LENGTH:75$]);
create index IX_F7B5F85A on CPDefinitionLink (CProductId, type_[$COLUMN_LENGTH:75$]);
create index IX_FE4C04C0 on CPDefinitionLink (status, CPDefinitionId, type_[$COLUMN_LENGTH:75$]);
create index IX_786093B4 on CPDefinitionLink (status, CProductId, type_[$COLUMN_LENGTH:75$]);
create index IX_62BEA79A on CPDefinitionLink (status, displayDate);
create index IX_155AEF17 on CPDefinitionLink (status, expirationDate);
create unique index IX_112757D8 on CPDefinitionLink (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create unique index IX_CB617913 on CPDefinitionLocalization (CPDefinitionId, languageId[$COLUMN_LENGTH:75$], ctCollectionId);

create unique index IX_64314388 on CPDefinitionOptionRel (CPDefinitionId, ctCollectionId, CPOptionId);
create unique index IX_78CCF36B on CPDefinitionOptionRel (CPDefinitionId, ctCollectionId, key_[$COLUMN_LENGTH:75$]);
create index IX_BDB8420C on CPDefinitionOptionRel (CPDefinitionId, required);
create index IX_749E99EB on CPDefinitionOptionRel (CPDefinitionId, skuContributor);
create index IX_449BFCFE on CPDefinitionOptionRel (companyId);
create index IX_A65BAB00 on CPDefinitionOptionRel (groupId);
create unique index IX_44B059C2 on CPDefinitionOptionRel (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create unique index IX_55A05F1E on CPDefinitionOptionValueRel (CPDefinitionOptionRelId, key_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_4A77D282 on CPDefinitionOptionValueRel (CPDefinitionOptionRelId, preselected);
create index IX_3EB86274 on CPDefinitionOptionValueRel (CPInstanceUuid[$COLUMN_LENGTH:75$]);
create index IX_44C2E505 on CPDefinitionOptionValueRel (companyId);
create index IX_695AE8C7 on CPDefinitionOptionValueRel (groupId);
create index IX_2434CAD7 on CPDefinitionOptionValueRel (key_[$COLUMN_LENGTH:75$]);
create unique index IX_52855B17 on CPDefinitionOptionValueRel (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create index IX_290BF7BA on CPDisplayLayout (classNameId, classPK);
create unique index IX_7F728A18 on CPDisplayLayout (groupId, classNameId, classPK, ctCollectionId);
create index IX_965CA8C5 on CPDisplayLayout (groupId, layoutPageTemplateEntryUuid[$COLUMN_LENGTH:75$]);
create index IX_381B82DE on CPDisplayLayout (groupId, layoutUuid[$COLUMN_LENGTH:75$]);
create unique index IX_7649CF4D on CPDisplayLayout (groupId, uuid_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_FEC526EF on CPDisplayLayout (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_95564486 on CPInstance (CPDefinitionId, ctCollectionId, CPInstanceUuid[$COLUMN_LENGTH:75$]);
create unique index IX_E06787D8 on CPInstance (CPDefinitionId, ctCollectionId, sku[$COLUMN_LENGTH:75$]);
create index IX_4389A03 on CPInstance (CPDefinitionId, status, displayDate);
create index IX_34763899 on CPInstance (CPInstanceUuid[$COLUMN_LENGTH:75$]);
create index IX_9FB1144D on CPInstance (companyId, sku[$COLUMN_LENGTH:75$]);
create unique index IX_EB17985B on CPInstance (ctCollectionId, companyId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_A495773C on CPInstance (ctCollectionId, uuid_[$COLUMN_LENGTH:75$], groupId);
create index IX_C1F8242 on CPInstance (groupId);
create index IX_BD04B832 on CPInstance (status, displayDate);
create index IX_75478E1C on CPInstance (status, groupId);
create index IX_1140BD8 on CPInstance (status, replacementCPInstanceUuid[$COLUMN_LENGTH:75$], replacementCProductId);
create index IX_4654BD4C on CPInstance (uuid_[$COLUMN_LENGTH:75$]);

create index IX_E551D3AA on CPInstanceOptionValueRel (CPDefinitionOptionRelId);
create unique index IX_C7B0D143 on CPInstanceOptionValueRel (CPInstanceId, CPDefinitionOptionRelId, CPDefinitionOptionValueRelId, ctCollectionId);
create index IX_D3B702C2 on CPInstanceOptionValueRel (CPInstanceId, CPDefinitionOptionValueRelId);
create unique index IX_4399CE9D on CPInstanceOptionValueRel (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create index IX_4351C7A1 on CPInstanceUOM (CPInstanceId, active_);
create unique index IX_C6BA8E9A on CPInstanceUOM (CPInstanceId, key_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_611154B9 on CPInstanceUOM (CPInstanceId, primary_);
create index IX_2EED7F68 on CPInstanceUOM (companyId, key_[$COLUMN_LENGTH:75$], sku[$COLUMN_LENGTH:75$]);
create index IX_9DCFEBFC on CPInstanceUOM (companyId, sku[$COLUMN_LENGTH:75$]);
create index IX_ABE6B4BD on CPInstanceUOM (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_D52621F0 on CPMeasurementUnit (companyId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_51CDE4C1 on CPMeasurementUnit (companyId, ctCollectionId, key_[$COLUMN_LENGTH:75$]);
create index IX_F0C14577 on CPMeasurementUnit (companyId, type_, primary_);
create unique index IX_E3424311 on CPMeasurementUnit (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);

create unique index IX_4E312C7F on CPOption (companyId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create unique index IX_143B0E52 on CPOption (companyId, ctCollectionId, key_[$COLUMN_LENGTH:75$]);
create index IX_A64FCE2C on CPOption (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_D9120F4 on CPOptionCategory (companyId, key_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_ABB730CE on CPOptionCategory (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_DA77C838 on CPOptionValue (CPOptionId, ctCollectionId, key_[$COLUMN_LENGTH:75$]);
create unique index IX_DC509C0C on CPOptionValue (companyId, ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$]);
create index IX_D7C1A0BF on CPOptionValue (uuid_[$COLUMN_LENGTH:75$]);

create index IX_421ED80 on CPSpecificationOption (CPOptionCategoryId);
create unique index IX_8F980DC9 on CPSpecificationOption (companyId, key_[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_BF5FD94B on CPSpecificationOption (listTypeDefinitionId);
create index IX_972DFDE3 on CPSpecificationOption (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_79A007D5 on CPTaxCategory (companyId, externalReferenceCode[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_705EAB92 on CPTaxCategory (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_CB3A891B on CProduct (ctCollectionId, externalReferenceCode[$COLUMN_LENGTH:75$], companyId);
create index IX_77F5B8F8 on CProduct (groupId);
create unique index IX_F70CE3C6 on CProduct (uuid_[$COLUMN_LENGTH:75$], groupId, ctCollectionId);

create index IX_7A691498 on CommerceCatalog (accountEntryId);
create unique index IX_A8DE8457 on CommerceCatalog (companyId, externalReferenceCode[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_65864AFC on CommerceCatalog (companyId, system_);
create index IX_37D36450 on CommerceCatalog (uuid_[$COLUMN_LENGTH:75$]);

create index IX_C2C38B02 on CommerceChannel (accountEntryId);
create unique index IX_D8DAE041 on CommerceChannel (companyId, externalReferenceCode[$COLUMN_LENGTH:75$], ctCollectionId);
create index IX_E1ECD95 on CommerceChannel (siteGroupId);
create index IX_9E82EA6 on CommerceChannel (uuid_[$COLUMN_LENGTH:75$]);

create unique index IX_4469A625 on CommerceChannelRel (classNameId, classPK, commerceChannelId, ctCollectionId);
create index IX_48F8F6FC on CommerceChannelRel (commerceChannelId);]]></indexes-sql>
</data>