[Koha-bugs] [Bug 1861] New: Unique patrons logins not (totally) enforced

[bugzilla-daemon]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1861

           Summary: Unique patrons logins not (totally) enforced
           Product: Koha
           Version: rel_3_0
          Platform: PC
        OS/Version: Linux - Gentoo
            Status: NEW
          Severity: normal
          Priority: P4
         Component: Patron Import
        AssignedTo: address@hidden
        ReportedBy: address@hidden
         QAContact: address@hidden


The Koha 3.0 patron admin page will prevent you from creating a user who has an
identical OPAC login as someone else (though I would change the error message
from "Login/password already exists." to "Login already exists.", since it's
not the password that's the problem).

However, there's nothing enforced in the MySQL database to prevent patrons from
being imported or manually inserted with duplicate logins.  Would it be better
to change the MySQL spec from this:

    KEY `userid` (`userid`)

to this?

    UNIQUE KEY `userid` (`userid`)




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.