<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table serviceManager_Service (
	serviceId LONG not null primary key,
	serviceName VARCHAR(75) null,
	serviceKey VARCHAR(75) null,
	categoryName VARCHAR(75) null,
	image STRING null,
	hasCustomUrl BOOLEAN,
	hasGlobalUrl BOOLEAN,
	globalUrl STRING null,
	exportUser BOOLEAN,
	exportParent BOOLEAN,
	exportStudent BOOLEAN,
	exportTeacher BOOLEAN,
	portletId LONG
);

create table serviceManager_ServiceDefaultRole (
	ServiceDefaultRoleId LONG not null primary key,
	roleId LONG,
	serviceId LONG
);

create table serviceManager_ServiceDiffusion (
	serviceDiffusionId LONG not null primary key,
	etabId LONG,
	serviceId LONG,
	isAvailable BOOLEAN,
	serviceUrl STRING null
);

create table serviceManager_ServiceFilterEtab (
	ServiceFilterEtabId LONG not null primary key,
	serviceId LONG,
	etabId LONG
);

create table serviceManager_ServicePopulation (
	ServicePopulationId LONG not null primary key,
	populationId LONG,
	serviceId LONG,
	etabId LONG
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_7212650C on serviceManager_Service (serviceId);
create index IX_D0580A32 on serviceManager_Service (serviceKey);
create index IX_3F8AD2BC on serviceManager_Service (serviceName);

create index IX_D025BC91 on serviceManager_ServiceDefaultRole (serviceId);
create index IX_41283AF6 on serviceManager_ServiceDefaultRole (serviceId, roleId);

create index IX_F6506ADC on serviceManager_ServiceDiffusion (etabId);
create index IX_41024963 on serviceManager_ServiceDiffusion (serviceId);
create index IX_D1FC2162 on serviceManager_ServiceDiffusion (serviceId, etabId);

create index IX_BE5D0AC4 on serviceManager_ServiceFilterEtab (serviceId);
create index IX_1AF3F1C3 on serviceManager_ServiceFilterEtab (serviceId, etabId);

create index IX_C8364EFD on serviceManager_ServicePopulation (populationId);
create index IX_15BE383F on serviceManager_ServicePopulation (serviceId);
create index IX_C5B9743E on serviceManager_ServicePopulation (serviceId, etabId);
create index IX_E31DF33B on serviceManager_ServicePopulation (serviceId, populationId);]]></indexes-sql>
</data>