User groups table

From MediaWiki.org

MediaWiki database layout

User groups table

1 Fields
- 1.1 ug_user
- 1.2 ug_group
2 Schema summary
3 Default mediawiki groups

MediaWiki version:

1.5

The user groups table maps the users in a particular MediaWiki installation to their corresponding user rights. Each group can be assigned a mixture of permissions through LocalSettings.php or via extensions; all users of a particular group have those permissions granted to them as a result of their membership in the group. As the table is separate from the user table, this allows for the creation of a shared user database with permissions that vary from wiki to wiki within a wiki farm. This table was introduced on r5648, in MediaWiki 1.5.

All unregistered users belong to the '*' only; all registered users are automatically part of the 'user' group. User groups are additive; as a result, all registered users have all the privileges assigned to the '*' group as well.

Note: If you are using 1.3 or 1.4, have a look at setting user rights in MediaWiki in Meta. Before MediaWiki 1.5, the user table contained a user_rights field for this purpose.

[edit] Fields

[edit] ug_user

This field links to a given user's user_id. It is a foreign key used to link accounts with their assigned privileges.

[edit] ug_group

This field stores the user's permissions, which are stored as groups. At runtime, $wgGroupPermissions will associate group keys with particular permissions; a user will have the combined permissions of any group they're explicitly in, plus the implicit '*' and 'user' groups.

[edit] Schema summary

MediaWiki version:

1.9

MediaWiki version:

1.8

MediaWiki version:

1.7

MediaWiki version:

1.6

MediaWiki version:

1.5

DESCRIBE user_groups in MediaWiki 1.5-1.9 gives the following:

+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| ug_user  | int(5) unsigned | NO   | PRI | 0       |       |
| ug_group | char(16)        | NO   | PRI | NULL    |       |
+----------+-----------------+------+-----+---------+-------+

[edit] Default mediawiki groups

In a default mediaWiki installation, ug_group can be one of the following :

 query : SELECT DISTINCT ug_group FROM user_groups;

+------------+
| ug_group   |
+------------+
| bot        |
| bureaucrat |
| checkuser  |
| developer  |
| steward    |
| sysop      |
+------------+