insertXemeliosUser=\
INSERT INTO AUTH_UTILISATEUR(UTI_ID, UTI_OBJ_GUID, UTI_LOGIN, UTI_PASSWORD, UTI_PRENOM, UTI_NOM, UTI_ACTIF, UTI_ALL_FONC, UTI_ALL_DOC, UTI_ALL_COL, UTI_CRC) \
- VALUES(SQ_AUTH_UTILISATEURS.NEXTVAL, ?, ?, '*', ?, ?, ?, 0, 0, 0, ?)
+ VALUES(SQ_AUTH_UTILISATEURS.NEXTVAL, ?, ?, '*', ?, ?, ?, 0, 1, 0, ?)
updateXemeliosUser=\
UPDATE AUTH_UTILISATEUR \
SELECT DISTINCT UTI.UTI_ID, 'SIRET', REF_COLL.IDCOLL \
FROM AUTH_UTILISATEUR UTI \
JOIN REF_CRC_DEPT ON REF_CRC_DEPT.RFC_CRC_NOM = UTI.UTI_CRC \
- JOIN REF_COLL_SPL_IX REF_COLL ON SUBSTR(REF_COLL.CODIC, 0, 3) = LPAD(REF_CRC_DEPT.RFC_DEP_CODE, 3, '0')
\ No newline at end of file
+ JOIN REF_COLL_SPL_IX REF_COLL ON SUBSTR(REF_COLL.CODIC, 0, 3) = LPAD(REF_CRC_DEPT.RFC_DEP_CODE, 3, '0')
+
+
+unsynchronizeUser.cleanProfiles=DELETE FROM AUTH_UTI_PRF WHERE UTI_ID = ?
+
+unsynchronizeUser.cleanDocuments=DELETE FROM AUTH_HAB_DOC WHERE UTI_ID = ?
+
+unsynchronizeUser.cleanCollectivites=DELETE FROM AUTH_HAB_COL WHERE UTI_ID = ?
+
+unsynchronizeUser.deleteUser=DELETE FROM AUTH_UTILISATEUR WHERE UTI_ID = ?
\ No newline at end of file