<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table CarnetAdresses_Fiche (
	ficheId LONG not null primary key,
	groupId LONG,
	relUserId LONG,
	properties VARCHAR(75) null
);

create table CarnetAdresses_FicheProperty (
	ficheId LONG,
	groupId LONG,
	propertyId LONG not null primary key,
	name VARCHAR(75) null,
	value_ VARCHAR(75) null,
	type_ VARCHAR(75) null
);

create table CarnetAdresses_Fiche_Liste (
	listeId LONG not null,
	ficheId LONG not null,
	primary key (listeId, ficheId)
);

create table CarnetAdresses_ListProperty (
	listeId LONG,
	groupId LONG,
	propertyId LONG not null primary key,
	name VARCHAR(75) null,
	value_ VARCHAR(75) null,
	type_ VARCHAR(75) null
);

create table CarnetAdresses_Liste (
	listeId LONG not null primary key,
	groupId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_81BD6679 on CarnetAdresses_Fiche (groupId);
create index IX_8C6DD416 on CarnetAdresses_Fiche (groupId, relUserId);
create index IX_1C728A3E on CarnetAdresses_Fiche (relUserId);

create index IX_22CC57E2 on CarnetAdresses_FicheProperty (ficheId);
create index IX_EF902464 on CarnetAdresses_FicheProperty (groupId);
create index IX_1F154103 on CarnetAdresses_FicheProperty (groupId, ficheId, name);
create index IX_41E94CF1 on CarnetAdresses_FicheProperty (groupId, type_);
create index IX_829072FD on CarnetAdresses_FicheProperty (groupId, value);
create index IX_CF7EB566 on CarnetAdresses_FicheProperty (groupId, value_);

create index IX_A8CCFECF on CarnetAdresses_Fiche_Liste (ficheId);
create index IX_85457459 on CarnetAdresses_Fiche_Liste (listeId);

create index IX_C0ECC512 on CarnetAdresses_ListProperty (groupId, listeId, name);
create index IX_3024FFF6 on CarnetAdresses_ListProperty (groupId, type_);
create index IX_70CC2602 on CarnetAdresses_ListProperty (groupId, value);
create index IX_A8B96301 on CarnetAdresses_ListProperty (groupId, value_);
create index IX_72084607 on CarnetAdresses_ListProperty (listeId);

create index IX_172981AF on CarnetAdresses_Liste (groupId);]]></indexes-sql>
</data>