ChiliProject is not maintained anymore. Please be advised that there will be no more updates.
We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.
Uniqueness of User model fields need to be checked by database indexes (Bug #213)
| Status: | Open | Start date: | 2011-02-20 |
|---|---|---|---|
| Priority: | Normal | Due date: | |
| Assignee: | Holger Just |
% Done: | 0% |
| Category: | - | ||
| Target version: | - | ||
| Remote issue URL: | http://www.redmine.org/issues/5976 | Affected version: |
Description
Although, the User model defines :login and :mail as unique, it is not guaranteed that these are indeed unique in the database. Parallel requests can insert the exactly same users (apart from the id) if the transaction overlap.
Therefore I propose to add a unique-index to the database to ensure uniqueness. Also, I propose to always save the login in lowercase to properly use that index. There still has to be checked if that correctly works with the legacy mixed case logins