<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table MessageBoards_MBLastAccess (
	lastAccessId LONG not null primary key,
	userId LONG,
	threadId LONG,
	lastAccess DATE null
);

create table MessageBoards_MBMessageInfos (
	messageInfosId LONG not null primary key,
	userId LONG,
	messageId LONG,
	threadId LONG,
	rowIndex INTEGER,
	rowIndexResponse INTEGER,
	citation VARCHAR(75) null,
	isAnonymous BOOLEAN,
	pseudo VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_D3E1FBD3 on MessageBoards_MBLastAccess (userId, threadId);

create index IX_7F68256E on MessageBoards_MBMessageInfos (messageId);
create index IX_DC532409 on MessageBoards_MBMessageInfos (threadId, rowIndex);
create index IX_B4E3412A on MessageBoards_MBMessageInfos (threadId, rowIndexResponse);
create index IX_1F317EFE on MessageBoards_MBMessageInfos (userId);]]></indexes-sql>
</data>