--- /dev/null
+create table userProperties_Contact (
+ contactId LONG not null primary key,
+ userId LONG,
+ address VARCHAR(75) null,
+ isAddressAuthorized BOOLEAN,
+ mail VARCHAR(75) null,
+ isMailAuthorized BOOLEAN,
+ mobile VARCHAR(75) null,
+ isMobileAuthorized BOOLEAN
+);
+
+create table userProperties_DashboardConfig (
+ userId LONG not null primary key,
+ configuration STRING null
+);
+
+create table userProperties_DashboardDefaultConfig (
+ roleId LONG not null primary key,
+ configuration STRING null
+);
+
+create table userProperties_InternalOauth (
+ internalOauthId LONG not null primary key,
+ token VARCHAR(75) null,
+ url VARCHAR(75) null,
+ userId LONG,
+ timeMarker DATE null
+);
+
+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_UserContact (
+ contactId LONG not null primary key,
+ userId LONG,
+ address VARCHAR(200) null,
+ isAddressAuthorized BOOLEAN,
+ mail VARCHAR(150) null,
+ isMailAuthorized BOOLEAN,
+ mobilePhone VARCHAR(75) null,
+ mobilePhoneSMS VARCHAR(75) null,
+ homePhone VARCHAR(75) null,
+ proPhone VARCHAR(75) null
+);
+
+create table userProperties_UserInternalSSO (
+ userInternalSSOId LONG not null primary key,
+ ssoKey STRING null,
+ ssoValue STRING 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(500) null,
+ device VARCHAR(10) 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(150) null,
+ forwardByMail BOOLEAN,
+ imSignature STRING null,
+ imUseSignature BOOLEAN,
+ teleserviceId VARCHAR(75) null,
+ teleservicePwd VARCHAR(75) null,
+ unfoldMenu BOOLEAN,
+ shareDetails BOOLEAN,
+ details STRING null,
+ entPersonJointure VARCHAR(150) null,
+ etabId LONG,
+ ajaxablePortlets BOOLEAN,
+ mailPasswordRecovery VARCHAR(150) null,
+ dateMailPasswordRecovery DATE null,
+ keyPasswordRecovery STRING null,
+ hideMenu BOOLEAN,
+ themeColor VARCHAR(75) null,
+ grantHolder BOOLEAN,
+ transported BOOLEAN,
+ status VARCHAR(75) null,
+ webdavActivated BOOLEAN,
+ termsOfUseAgreedDate DATE null
+);
+
+create table userProperties_UserRelationship (
+ userRelationshipId LONG not null primary key,
+ fromUserId LONG,
+ toUserId LONG,
+ toUserSconetId VARCHAR(150) null,
+ relationType VARCHAR(150) null
+);
\ No newline at end of file