User Profile Field - Few questions...
 

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 ?

1) userfields

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

3) nothing until the user edits that field

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.