[Mapbender-dev] primary key for mb_user_name?

[Astrid Emde]

Christoph Baudson schrieb:
> Hello,
> 
> when I start Mapbender like this
> 
> login.php?name=<aUserName>&password=<thisUsersPassword>&mb_user_myGui=<aGuiId> 
> 
> 
> I have to specify a user *name*, but not a user *ID*. But the column 
> "mb_user_name" has no primary key. Isn't this a problem? Maybe adding a 
> primary key to "mb_user_name" would not be a bad idea.

Hi Christoph,

I think we don't have a problem with mb_user_name not having a primary key.

If you have a look at the database-structure in the mapbender-wiki 
http://www.mapbender.org/index.php/Database-structure you can see that 
the connection between the mb_user-table and the other tables is 
realised by the primary key mb_user_id.

Only for the login, we ask for the mb_user_name. After we checked the 
authentication we go on with the mb_user_id.

Or did I forget something?

-- 
Greetings astrid