Modify Username

[kapz]

Hi Sindre,

I'd like to know if its possible to change a username? I'm very experienced with SQL so I'm guessing I can go into db.view page and update a column.

Again, I love Subsonic...thx for a great app

[sindre_mehus]

Hi,

I don't recommend doing that, since the username is used as both primary and foreign key in a lot of tables. If still wanna do it, the tables in question are:

user
user_role
user_settings
user_rating
custom_avatar
player

Cheers,
Sindre

[kapz]

Thanks for the quick reply. In that case I know how changing a primary key can make a mess of a DB. I'll leave it alone