changing MYSQL table column names

[osayidan]

Hi
I'm working on integrating a game server with vbulletin, and to do so i will have to change the column names that one of these uses to match the other, I think it would take much longer to modify the game source code for this, so i will go for changing it on vbulletin.

What i need to do is as follows:
change the VB table field "userid" to "account_id"
change the VB table field "username" to "userid"

Obviously, i know how to change the field names in MySQL, what i need help with is a quick and/or efficient and accurate way of changing the vbulletin source to properly use these new field names.

Thanks.