Forums / Developer / Data model : ezuser and ezuser_settings

Data model : ezuser and ezuser_settings

Author Message

Hugues Charleux

Wednesday 29 September 2010 1:30:39 am

Hi all,

Fetching users the other day, I was just wondering...

Why are there two different tables, ezuser and ezuser_setting ?

I didn't get deep into code but it looks like the ezuser_setting fields[1] are mandatory for each ezuser records.

This makes the API more painfull as you have to fetch a eZUserSetting object to get those information.
This make an extra SQL query to get those informations.

This is not a big deal but looks strange, did I miss something ? Some historical background maybe ?

[1] is_enabled | max_login

André R.

Wednesday 29 September 2010 1:49:09 am

This should be part of ezuser someday indeed, not sure why there are two myself. Probably a reason that is not valid anymore :)

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Nicolas Pastorino

Wednesday 29 September 2010 1:50:15 am

That could a useful bug report, couldn't it ?

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye