<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table ChangesetCollection (
	changesetCollectionId 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,
	description VARCHAR(75) null
);

create table ChangesetEntry (
	changesetEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	changesetCollectionId LONG,
	classNameId LONG,
	classPK LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_9AC55E11 on ChangesetCollection (companyId, name[$COLUMN_LENGTH:75$]);
create unique index IX_ABEEE793 on ChangesetCollection (groupId, name[$COLUMN_LENGTH:75$]);
create index IX_EE4B4B0E on ChangesetCollection (groupId, userId);

create unique index IX_EF48912A on ChangesetEntry (changesetCollectionId, classNameId, classPK);
create index IX_A9985762 on ChangesetEntry (classNameId, groupId);
create index IX_CEB6AFA2 on ChangesetEntry (companyId);
create index IX_E00AB6A4 on ChangesetEntry (groupId);]]></indexes-sql>
</data>