Fix user sync script when swapping rooms

[nymous]

In lib/tasks/sync_accounts.rake

Initial situation:

• User 1 in B001
• User 2 in A001

What we want to sync:

• User 1 in A001
• User 2 in B001

Because we loop on users in ID number, we will set User 1 room to A001 first, which will break the unique constraint.

We can replace our unique index with a unique constraint that is DEFERRABLE, then configure in the transaction that we want to delay constraint validation.

[tekvalir]

#528 removes the room from the scope of the OIDC. If the latter is merged this issue would not be one anymore.

[D0gmaDev]

Not sure to agree @tekvalir. Swapping rooms from lea5 would still not be possible without going for an intermediate

[tekvalir]

This issue is about sync script of the OIDC ^^. I am not sure there is something of an implementation to edit the room on lea5 thus would be an issue when we will make the feature.