Add column to table in mysql

[raminr63]

hi. guys i use mybb as the group creator for my site.
i want to add a column named xuid in the mybb_users table so when users want to register in my site put their xuid that contains 16 digits and words and be saved in this column
so please give me the code for adding the xuid column to the mybb_users table.

[Fou-Lu]

ALTER TABLE mybb_users ADD COLUMN xuid char(16) assuming that when you mean 16 digits and words you mean 16 characters.
For more reference: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html
Of course you'll need to write the PHP code to actually do something with it.