<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table Subscription (
	mvccVersion LONG default 0 not null,
	ctCollectionId LONG default 0 not null,
	subscriptionId LONG not null,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	classNameId LONG,
	classPK LONG,
	frequency VARCHAR(75) null,
	primary key (subscriptionId, ctCollectionId)
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_6BBFF1A6 on Subscription (classNameId, companyId, classPK);
create index IX_C4FAEA47 on Subscription (groupId);
create unique index IX_6CA01A0A on Subscription (userId, classNameId, companyId, classPK, ctCollectionId);
create index IX_C717464D on Subscription (userId, groupId);]]></indexes-sql>
</data>