<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table emaEvaluation_EmaEvaluation (
	eeId LONG not null primary key,
	evaluateurId LONG,
	studentId LONG,
	eeDate DATE null,
	comment_ VARCHAR(75) null
);

create table emaEvaluation_EmaProduction (
	epId LONG not null primary key,
	eeId LONG,
	classNameId LONG,
	objectId LONG,
	hashProd VARCHAR(75) null
);

create table emaEvaluation_EmaSkill (
	esId LONG not null primary key,
	eeId LONG,
	skillId LONG,
	skillDate DATE null,
	mark VARCHAR(75) null,
	evaluateurId LONG,
	studentId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_E1F3C675 on emaEvaluation_EmaEvaluation (studentId);
create index IX_46D7741A on emaEvaluation_EmaEvaluation (studentId, evaluateurId);

create index IX_3FE029D on emaEvaluation_EmaProduction (eeId);
create index IX_A9EE4BC7 on emaEvaluation_EmaProduction (hashProd);

create index IX_C846BDB7 on emaEvaluation_EmaSkill (eeId);
create index IX_54E2FBB9 on emaEvaluation_EmaSkill (evaluateurId, studentId);
create index IX_5F333E3 on emaEvaluation_EmaSkill (evaluateurId, studentId, skillId);
create index IX_99629FD4 on emaEvaluation_EmaSkill (skillId);]]></indexes-sql>
</data>