<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table PM_UserThread (
	userThreadId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	mbThreadId LONG,
	topMBMessageId LONG,
	read_ BOOLEAN,
	deleted BOOLEAN
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_A821854B on PM_UserThread (mbThreadId);
create index IX_3084E97 on PM_UserThread (userId);
create index IX_434EE852 on PM_UserThread (userId, deleted);
create index IX_466F2985 on PM_UserThread (userId, mbThreadId);
create index IX_A16EF3C7 on PM_UserThread (userId, read_, deleted);]]></indexes-sql>
</data>