Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Customization of Database: cms_user versus cms_usersettings View modes: 
User avatar
Member
Member
neil-fourmangos - 4/26/2009 11:02:56 PM
   
Customization of Database: cms_user versus cms_usersettings
Hi,

Quick question - I'd like to add in some additional information regarding users and I'm not sure which table I should modify. Should I do user or usersettings? Is there a serious difference between the two tables? Can I use either one of them?

Thanks!!!

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 4/27/2009 11:14:38 AM
   
RE:Customization of Database: cms_user versus cms_usersettings
Hi,

It depends on what you want to add to the table. In general it does not matter in which table you will add the column (using the interface in Site Manager -> Development -> System tables).
The CMS_User table was split due to the community features. In the CMS_User table are only records necessary for all users, in the settings table you can find the additional information for the users - like comments, gender, avatar, badge, etc.

Best Regards,
Juraj Ondrus

User avatar
Member
Member
neil-fourmangos - 4/27/2009 11:53:12 AM
   
RE:Customization of Database: cms_user versus cms_usersettings
Thanks Juraj! I have another question coming up shortly but this makes complete sense.