<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table DepotAppCustomization (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	depotAppCustomizationId LONG not null,
	companyId LONG,
	depotEntryId LONG,
	enabled BOOLEAN,
	portletId VARCHAR(75) null,
	primary key (depotAppCustomizationId, ctCollectionId)
);

create table DepotEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	depotEntryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	primary key (depotEntryId, ctCollectionId)
);

create table DepotEntryGroupRel (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	uuid_ VARCHAR(75) null,
	depotEntryGroupRelId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	ddmStructuresAvailable BOOLEAN,
	depotEntryId LONG,
	searchable BOOLEAN,
	toGroupId LONG,
	lastPublishDate DATE null,
	primary key (depotEntryGroupRelId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_5B76D798 on DepotAppCustomization (depotEntryId, enabled);
create unique index IX_2CE1592A on DepotAppCustomization (depotEntryId, portletId[$COLUMN_LENGTH:75$], ctCollectionId);

create unique index IX_E3EB2C84 on DepotEntry (groupId, ctCollectionId);

create index IX_146497CB on DepotEntryGroupRel (depotEntryId);
create index IX_7CA33F81 on DepotEntryGroupRel (toGroupId, ddmStructuresAvailable);
create unique index IX_1DD0EA9C on DepotEntryGroupRel (toGroupId, depotEntryId, ctCollectionId);
create index IX_BA106967 on DepotEntryGroupRel (toGroupId, searchable);
create unique index IX_A83D9516 on DepotEntryGroupRel (uuid_[$COLUMN_LENGTH:75$], ctCollectionId, groupId);]]></indexes-sql>
</data>