User Profile Field - Few questions...

[Suri.CMS]

Hi All,
Lets say I added a User Profile Field during registration. And few users registered and provided appropriate values.

1) Where the values are stored ? Which database table ?

2) After few days, if I delete that User Profile field, then what happens to the already existing values ?

3) If I edit that User Profile field and change it to have different options, then what happens to the already existing values ?

[Lynne]

1) userfields

2) the column gest deleted in the table - so all the data does also

3) nothing until the user edits that field

[Dismounted]

By the way, do not try editing the fields in the database directly, it doesn't work that way.

[Kaemon]

Originally Posted by Dismounted

By the way, do not try editing the fields in the database directly, it doesn't work that way.

woah. I was just about to do a database update. Can you clarify why I shouldn't or what I should do instead?

Let's say I have a custom profile field (field 9) called "Favorite Color" with a single-select dropdown and 2 options:
Red
Blue

After 500 users have registered, the userfield table will have a value of "Red" or "Blue" in column "field9".

If I want to change the color options to "Red" and "Green", couldn't I just update the userfield table by setting field9 to "Green" where field9 = 'Blue'?

Thanks for your help.