<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table SO_FavoriteSite (
	favoriteSiteId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG
);

create table SO_MemberRequest (
	memberRequestId LONG not null primary key,
	groupId LONG,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	key_ VARCHAR(75) null,
	receiverUserId LONG,
	invitedRoleId LONG,
	invitedTeamId LONG,
	status INTEGER
);

create table SO_ProjectsEntry (
	projectsEntryId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(75) null,
	createDate DATE null,
	modifiedDate DATE null,
	title VARCHAR(75) null,
	description STRING null,
	startDate DATE null,
	endDate DATE null,
	data_ VARCHAR(1000) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create unique index IX_3AA03DF8 on SO_FavoriteSite (groupId, userId);
create index IX_DE2F16A6 on SO_FavoriteSite (userId);

create index IX_D34593C1 on SO_MemberRequest (groupId, receiverUserId, status);
create index IX_212FA0EC on SO_MemberRequest (key_);
create index IX_D6810661 on SO_MemberRequest (receiverUserId);
create index IX_16475447 on SO_MemberRequest (receiverUserId, status);

create index IX_3371C715 on SO_ProjectsEntry (userId);]]></indexes-sql>
</data>