<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CommerceWishList (
	mvccVersion LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	commerceWishListId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	name VARCHAR(75) null,
	defaultWishList BOOLEAN
);

create table CommerceWishListItem (
	mvccVersion LONG default 0 not null,
	commerceWishListItemId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	commerceWishListId LONG,
	CPInstanceUuid VARCHAR(75) null,
	CProductId LONG,
	json TEXT null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_777290D8 on CommerceWishList (groupId, userId, defaultWishList);
create unique index IX_FB7BEB90 on CommerceWishList (groupId, uuid_[$COLUMN_LENGTH:75$]);
create index IX_6680B6BE on CommerceWishList (userId, createDate);
create index IX_47CF092E on CommerceWishList (uuid_[$COLUMN_LENGTH:75$]);

create index IX_9DA3D36A on CommerceWishListItem (CPInstanceUuid[$COLUMN_LENGTH:75$]);
create index IX_CF9B9CD4 on CommerceWishListItem (CProductId);
create index IX_BC95AC54 on CommerceWishListItem (commerceWishListId, CPInstanceUuid[$COLUMN_LENGTH:75$], CProductId);
create index IX_C172BCA3 on CommerceWishListItem (commerceWishListId, CProductId);]]></indexes-sql>
</data>