Table Details

Thursday 03 May 2007 2:20:35 am

Hi,

users are handled in the same manner as other content objects in eZ Publish.
So firstname, lastname etc. are stored in the ezcontentobject_attribute table.

Hope that helps.
Silke

Thursday 03 May 2007 3:20:55 am

Have a look at the way content classes work and content object attributes are stored in general.

http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/the_content_class
http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/class_attributes
http://ez.no/doc/ez_publish/technical_manual/3_8/concepts_and_basics/content_management/the_content_object

The user content class is described here:
http://ez.no/doc/ez_publish/technical_manual/3_8/reference/content_classes/users/user

All that might look a bit strange at first, but the benefit of this concept is its huge flexibility.

For example, if you want to look up all users' firstnames you can use this SQL statement:

select * from ezcontentobject_attribute where contentclassattribute_id = 8;

You can look up class attribute ids in the admin area at Setup > Classes.
For example http://<your_host>/<your_ez_siteaccess>/class/view/4

I hope this was useful for you to understand eZ Publish' concept of storing object data.
But in general, if you want to change object data per script you should use the appropriate PHP classes and methods rather than plain SQL.