<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table cabriMaquette_CahierCabri (
	ccId LONG not null primary key,
	name VARCHAR(75) null,
	creationDate DATE null,
	comment_ VARCHAR(75) null,
	nameVignette VARCHAR(75) null,
	nameParcoursVignette VARCHAR(75) null,
	level VARCHAR(75) null,
	category VARCHAR(75) null
);

create table cabriMaquette_ParcoursCabri (
	pcId LONG not null primary key,
	name VARCHAR(75) null,
	creationDate DATE null,
	comment_ VARCHAR(75) null
);

create table cabriMaquette_ParcoursItemCabri (
	picId LONG not null primary key,
	pcId LONG,
	ccId LONG,
	place LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_8304F79B on cabriMaquette_CahierCabri (category);
create index IX_C8BF72AB on cabriMaquette_CahierCabri (level);
create index IX_2299E95D on cabriMaquette_CahierCabri (level, category);

create index IX_FEE98408 on cabriMaquette_ParcoursItemCabri (ccId);
create index IX_1518841B on cabriMaquette_ParcoursItemCabri (pcId);]]></indexes-sql>
</data>