<?xml version="1.0"?>

<data>
	<tables-sql><![CDATA[create table userProperties_NotifyConfig (
	notifyConfigId LONG not null primary key,
	userId LONG,
	activate BOOLEAN,
	notifyCasier BOOLEAN,
	notifyActu BOOLEAN,
	notifyGrpDoc BOOLEAN,
	notifyForum BOOLEAN,
	notifyAgenda BOOLEAN,
	digestPeriod INTEGER
);

create table userProperties_UserInternalSSO (
	userInternalSSOId LONG not null primary key,
	ssoKey VARCHAR(75) null,
	ssoValue VARCHAR(75) null,
	timeMarker DATE null
);

create table userProperties_UserMailSynchronisation (
	userId LONG not null primary key,
	lastSynchronisation DATE null
);

create table userProperties_UserMatching (
	userMatchingId LONG not null primary key,
	userId LONG,
	withUserId LONG,
	valid BOOLEAN
);

create table userProperties_UserMobileNotification (
	userMobileNotificationId LONG not null primary key,
	userId LONG,
	etabId LONG,
	enable BOOLEAN,
	token VARCHAR(75) null,
	device VARCHAR(75) null
);

create table userProperties_UserProperties (
	userPropertiesId LONG not null primary key,
	userId LONG,
	portraitVisible BOOLEAN,
	jabberId VARCHAR(75) null,
	jabberPwd VARCHAR(75) null,
	cartableView VARCHAR(75) null,
	agendaView VARCHAR(75) null,
	cdtView VARCHAR(75) null,
	forwardMail VARCHAR(75) null,
	forwardByMail BOOLEAN,
	imSignature VARCHAR(75) null,
	imUseSignature BOOLEAN,
	teleserviceId VARCHAR(75) null,
	teleservicePwd VARCHAR(75) null,
	unfoldMenu BOOLEAN,
	shareDetails BOOLEAN,
	details VARCHAR(75) null,
	entPersonJointure VARCHAR(75) null,
	etabId LONG,
	ajaxablePortlets BOOLEAN,
	mailPasswordRecovery VARCHAR(75) null,
	dateMailPasswordRecovery DATE null,
	keyPasswordRecovery VARCHAR(75) null
);

create table userProperties_UserRelationship (
	userRelationshipId LONG not null primary key,
	fromUserId LONG,
	toUserId LONG,
	toUserSconetId VARCHAR(75) null,
	relationType VARCHAR(75) null
);]]></tables-sql>
	<sequences-sql><![CDATA[]]></sequences-sql>
	<indexes-sql><![CDATA[create index IX_2E3370B9 on userProperties_NotifyConfig (activate);
create index IX_E05CAA52 on userProperties_NotifyConfig (activate, digestPeriod);
create index IX_7C23864C on userProperties_NotifyConfig (userId);

create index IX_A8BFB1D0 on userProperties_UserInternalSSO (ssoKey);

create index IX_DFF68309 on userProperties_UserMatching (userId);
create index IX_121593A9 on userProperties_UserMatching (userId, withUserId);
create index IX_128BC3E3 on userProperties_UserMatching (userId, withUserId, valid);
create index IX_5129816F on userProperties_UserMatching (withUserId);

create index IX_2114297E on userProperties_UserMobileNotification (etabId);
create index IX_58103FB5 on userProperties_UserMobileNotification (etabId, enable);
create index IX_71F596B9 on userProperties_UserMobileNotification (userId);
create index IX_86FA41F0 on userProperties_UserMobileNotification (userId, enable);

create index IX_280E6869 on userProperties_UserProperties (entPersonJointure);
create index IX_AE3404DA on userProperties_UserProperties (keyPasswordRecovery);
create index IX_D01FFA20 on userProperties_UserProperties (mailPasswordRecovery);
create index IX_12A0B5BF on userProperties_UserProperties (userId);

create index IX_F3313098 on userProperties_UserRelationship (fromUserId, relationType);
create index IX_C38ED323 on userProperties_UserRelationship (fromUserId, toUserId);
create index IX_6E6672EB on userProperties_UserRelationship (fromUserId, toUserSconetId, relationType);
create index IX_C16E77A9 on userProperties_UserRelationship (toUserId, relationType);
create index IX_FD37D7E7 on userProperties_UserRelationship (toUserSconetId, relationType);]]></indexes-sql>
</data>