[jira] [Commented] (OPENMEETINGS-2295) Multiple Users with same Username and Email

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPENMEETINGS-2295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17127372#comment-17127372 ] 

ASF subversion and git services commented on OPENMEETINGS-2295:
---------------------------------------------------------------

Commit 542cbbef12670a0fbed7dbbf160012aa0581426f in openmeetings's branch refs/heads/master from Maxim Solodovnik
[ https://gitbox.apache.org/repos/asf?p=openmeetings.git;h=542cbbe ]

[OPENMEETINGS-2295] restore will fail if email/login exists


> Multiple Users with same Username and Email
> -------------------------------------------
>
>                 Key: OPENMEETINGS-2295
>                 URL: https://issues.apache.org/jira/browse/OPENMEETINGS-2295
>             Project: Openmeetings
>          Issue Type: Bug
>    Affects Versions: 5.0.0-M3
>            Reporter: Kamhamea K.
>            Assignee: Maxim Solodovnik
>            Priority: Major
>         Attachments: multiple_users_active.jpg, multiple_users_deleted.jpg
>
>
> When a user is deleted the same user (identified by username and email) can be created again (see figure 1). This is not so much of a problem, rather normal behavior. However all the doublets can be restore, so the database ends up with multiple users sharing email and username (see figure 2)
> The best solution to this problem would be a unique key in the Mysql-Database.
> [https://stackoverflow.com/questions/635937/how-do-i-specify-unique-constraint-for-multiple-columns-in-mysql]
> The disadvantage is that no user can use the same username and email again even if the user is already deleted. Solutions for uniqueness of only active users are discussed here. 
> [https://stackoverflow.com/questions/46965617/mysql-unique-constraint-of-two-columns-only-if-second-column-is-a-specific-value]
> I suppose the solution of two different tables for active and deleted users is more streamline with the current project.
> Finally, as other databases than MySQL are supported the solution for these databases has to be considered too.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)