<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table applicationManager_AMFilter (
	filterId LONG not null primary key,
	parentId LONG,
	populationId LONG,
	criteria VARCHAR(75) null,
	operator VARCHAR(75) null,
	value LONG
);

create table applicationManager_AMFilterContainer (
	filterContainerId LONG not null primary key,
	parentId LONG,
	populationId LONG,
	operator VARCHAR(75) null
);

create table applicationManager_AMSingleUsers (
	singleUserId LONG not null primary key,
	userId LONG,
	populationId LONG
);

create table applicationManager_ApplicationManagerPopulation (
	populationId LONG not null primary key,
	nom VARCHAR(75) null,
	companyId LONG
);

create table applicationManager_ApplicationManagerRoles (
	managerAppliRoleId LONG not null primary key,
	populationId LONG,
	roleApplicatifId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_5EE55CE5 on applicationManager_AMFilter (parentId);
create index IX_D793C708 on applicationManager_AMFilter (populationId);

create index IX_95BFEF7A on applicationManager_AMFilterContainer (parentId);
create index IX_5BE4E736 on applicationManager_AMFilterContainer (parentId, populationId);
create index IX_2309071D on applicationManager_AMFilterContainer (populationId);

create index IX_5F1E60D4 on applicationManager_AMSingleUsers (populationId);
create index IX_807FB5D2 on applicationManager_AMSingleUsers (userId);

create index IX_4A7F37D6 on applicationManager_ApplicationManagerPopulation (companyId);

create index IX_3E307CE0 on applicationManager_ApplicationManagerRoles (populationId);
create index IX_F6EDFF7E on applicationManager_ApplicationManagerRoles (roleApplicatifId);
create index IX_32A4A03A on applicationManager_ApplicationManagerRoles (roleApplicatifId, populationId);]]></indexes-sql>
</data>