<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table TMS_TasksEntry (
	tasksEntryId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	title VARCHAR(75) null,
	priority INTEGER,
	assigneeUserId LONG,
	resolverUserId LONG,
	dueDate DATE null,
	finishDate DATE null,
	status INTEGER
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_9DB062B8 on TMS_TasksEntry (assigneeUserId);
create index IX_DF694DFB on TMS_TasksEntry (groupId);
create index IX_EE672124 on TMS_TasksEntry (groupId, assigneeUserId);
create index IX_EB40A85B on TMS_TasksEntry (groupId, resolverUserId);
create index IX_84A27B35 on TMS_TasksEntry (groupId, userId);
create index IX_9A89E9EF on TMS_TasksEntry (resolverUserId);
create index IX_5D4090C9 on TMS_TasksEntry (userId);]]></indexes-sql>
</data>