<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table communityInfos_CommunityInfos (
	communityInfosId LONG not null primary key,
	groupId LONG,
	etabId LONG,
	status INTEGER,
	scope INTEGER,
	creatorId LONG,
	creationDate DATE null,
	expirationDate DATE null,
	requestLifeExtension BOOLEAN,
	desiredExtension DATE null,
	politic INTEGER,
	viewInCDT BOOLEAN
);

create table communityInfos_GroupInfos (
	groupId LONG not null primary key,
	defaultGroupView VARCHAR(75) null
);

create table communityInfos_OrganizationMapping (
	organizationId LONG,
	entStructureJointure VARCHAR(75) not null primary key
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_B3C79958 on communityInfos_CommunityInfos (creatorId, status);
create index IX_F308C4C4 on communityInfos_CommunityInfos (etabId);
create index IX_D948F1F5 on communityInfos_CommunityInfos (etabId, expirationDate);
create index IX_DCA7FFAA on communityInfos_CommunityInfos (etabId, status);
create index IX_6F2779F6 on communityInfos_CommunityInfos (expirationDate);
create index IX_CDF3D385 on communityInfos_CommunityInfos (groupId);
create index IX_F2AB344C on communityInfos_CommunityInfos (requestLifeExtension, etabId);
create index IX_E40259B7 on communityInfos_CommunityInfos (status, politic);]]></indexes-sql>
</data>