<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CVirtualOrderItemFileEntry (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	cVirtualOrderItemFileEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceVirtualOrderItemId LONG,
	fileEntryId LONG,
	url VARCHAR(255) null,
	usages INTEGER,
	version VARCHAR(75) null
);

create table CommerceVirtualOrderItem (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	commerceVirtualOrderItemId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceOrderItemId LONG,
	activationStatus INTEGER,
	duration LONG,
	maxUsages INTEGER,
	active_ BOOLEAN,
	startDate DATE null,
	endDate DATE null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_C83537E on CVirtualOrderItemFileEntry (commerceVirtualOrderItemId, fileEntryId);
create unique index IX_68E33939 on CVirtualOrderItemFileEntry (uuid_[$COLUMN_LENGTH:75$], groupId);

create unique index IX_44EADF9A on CommerceVirtualOrderItem (commerceOrderItemId);
create unique index IX_81F354CD on CommerceVirtualOrderItem (uuid_[$COLUMN_LENGTH:75$], groupId);]]></indexes-sql>
</data>