<?xml version="1.0" encoding="UTF-8"?>

<data>
	<tables-sql><![CDATA[create table amis_FriendFolder (
	friendFolderId LONG not null primary key,
	userId LONG,
	parentFolderId LONG,
	name VARCHAR(75) null
);

create table amis_Relationship (
	relationId LONG not null primary key,
	userId LONG,
	friendId LONG,
	stateId INTEGER,
	friendFolderId LONG,
	message VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_4D5F1242 on amis_FriendFolder (parentFolderId);
create index IX_833BEB7C on amis_FriendFolder (userId, parentFolderId);

create index IX_F2245974 on amis_Relationship (friendId);
create index IX_EE8CF2C8 on amis_Relationship (friendId, stateId);
create index IX_93B5261 on amis_Relationship (userId);
create index IX_A0D6BE40 on amis_Relationship (userId, friendFolderId, stateId);
create index IX_A1A0DA2E on amis_Relationship (userId, friendId);
create index IX_207CA34E on amis_Relationship (userId, friendId, stateId);
create index IX_BDCAB47B on amis_Relationship (userId, stateId);]]></indexes-sql>
</data>