<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table TrashEntry (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	entryId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	classNameId LONG,
	classPK LONG,
	systemEventSetKey LONG,
	typeSettings TEXT null,
	status INTEGER,
	primary key (entryId, ctCollectionId)
);

create table TrashVersion (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	versionId LONG not null,
	companyId LONG,
	entryId LONG,
	classNameId LONG,
	classPK LONG,
	typeSettings TEXT null,
	status INTEGER,
	primary key (versionId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_16DA0033 on TrashEntry (classNameId, classPK, ctCollectionId);
create index IX_2674F2A8 on TrashEntry (companyId);
create index IX_FC4EEA64 on TrashEntry (groupId, classNameId);
create index IX_6CAAE2E8 on TrashEntry (groupId, createDate);

create unique index IX_96536499 on TrashVersion (classNameId, classPK, ctCollectionId);
create index IX_72D58D37 on TrashVersion (entryId, classNameId);]]></indexes-sql>
</data>