MediaWiki users

Question

How can I change the default MySQL table "user" , that's used to store new members?

Answer 1

Here is some information about the "user" table.

Answer 2

is it more of a database question? in mysql you could issue command, for example:

ALTER TABLE user ADD COLUMN user_birthday DATE;

check the actual name of user table. MW uses table prefix option which may not be empty.

The actual statement will depend on what column you want to add of course.

However, for the better portability of your wiki (e.g. easier upgrade) you might want to create a new table instead for the user profile that would have user_id as FOREIGN_KEY

Also there is a field user_options which stores name=value pairs of extra data. - you can make use of that if you don't care about searching your DB against the new "field".