[Mapbender-dev] primary key for mb_user_name?

[Michael Schulz]

Hi,

i agree with Christoph, the main cause for a unique username is the
fact, that the user table is possibly filled from another source than
the web registration form (I had to do that). Thus the table
definition should reflect the unique user name constraint as the
application already assumes it (e.g. the maxLogin functionality that
uses username).

I couldn't think of a contra argument, but then i don't know the code
by heart as Uli and the others do.

Cheers, Michael


On 8/7/06, Uli Rothstein <uli.rothstein at ccgis.de> wrote:
> Hi,
>
> do we realy need a unique user name?
> This is a basic decision and there are some pros and cons:
> * the application works with the user_id if the user is authenticated by name
> and password
> * the maxLogin disables an account by username
> Certainly there are much more arguments.
> Let's start a discussion....
>
> Regards
> Uli
>
>
>
>
>
>
>
>
> Astrid Emde schrieb:
> > Christoph Baudson schrieb:
> >> Astrid,
> >>
> >>> Only for the login, we ask for the mb_user_name. After we checked the
> >>> authentication we go on with the mb_user_id.
> >>
> >> Although the registration procedure checks, if this username is taken,
> >> it might occur that a database entry comes from another source but the
> >> registration form on the web, f.e. a command line entry or a different
> >> module (someone adds his own registration module for instance).
> >>
> >> Because the user name needs to be unique, it should be reflected in
> >> the database too, so adding a UNIQUE constraint should suffice.
> >
> > Hi christoph,
> >
> > now I unterstand your point and agree to the primary key on the column
> > mb_user_name.
> >
> > Astrid
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe at mapbender.osgeo.org
> > For additional commands, e-mail: dev-help at mapbender.osgeo.org
> >
>
>
> --
> --------------------------------
>         Ulrich Rothstein
>           CCGIS GbR
>         Siemensstraße 8
>          53121 Bonn
>            GERMANY
> --------------------------------
>
>    uli.rothstein at ccgis.de
>         www.ccgis.de
>     www.mapbender.org
> --------------------------------
> Zentrale:  ++49 (0) 228 90826  0
> Durchwahl: ++49 (0) 228 90826 17
> Fax:       ++49 (0) 228 90826 11
> --------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe at mapbender.osgeo.org
> For additional commands, e-mail: dev-help at mapbender.osgeo.org
>
>


-- 
-----------------------------------------------------------
Michael Schulz
mschulz at webgis.de

in medias res
Gesellschaft für Informationstechnologie mbH

In den Weihermatten 66
79108 Freiburg

Tel  +49 (0)761 556959-5
Fax +49 (0)761 556959-6

http://www.webgis.de / http://www.zopecms.de
-----------------------------------------------------------