Manuel:table user_groups

↑ Manuel:Contenu

Schéma de base de données MédiaWiki

table user_groups

Version de MediaWiki :

≥ 1.5

La table user_groups associe les utilisateurs d'une installation MediaWiki donnée à leur droits utilisateur correspondants. 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. Comme cette table est distincte de la table user , ceci permet de créer une base de données partagée d'utilisateurs avec des droits qui changent selons le wiki, à l'intérieur d'une ferme de wikis. Cette table a été introduite en r5648, dans MediaWiki 1.5. If you are using MediaWiki 1.3 or 1.4, have a look at Manuel:Droits utilisateurs (anciennes versions) . Avant MediaWiki 1.5, les droits utilisateur se trouvaient dans le champ user_rights de la table user .

All unregistered users automatically belong to the '*' group and only to that group; all registered users additionally 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. Formerly there was a "sysop bit"; now, making a user a sysop adds a row to user_groups.

Implicit group memberships and auto-promoted groups such as *, user, or autoconfirmed are not stored in this table. To retrieve all effective groups use UserGroupManager::getUserEffectiveGroups() .

Champs

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.

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. Example ug_group values: 'bot', 'bureaucrat', 'sysop'.

Il y a une ligne pour chaque groupe (explicite) auquel appartient l'utilisateur.

ug_expiry

Version de MediaWiki :

≥ 1.29

Ce champs indique la date d'expiration du groupe. It is similar to pr_expiry in the page_restrictions table and ipb_expiry in the ipblocks table.

Résumé du schéma

Version de MediaWiki :

≥ 1.29

DESCRIBE user_groups;

+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ug_user   | int(10) unsigned | NO   | PRI | 0       |       |
| ug_group  | varbinary(255)   | NO   | PRI |         |       |
| ug_expiry | varbinary(14)    | YES  | MUL | NULL    |       |
+-----------+------------------+------+-----+---------+-------+

Versions de MediaWiki :

1.21 – 1.28

DESCRIBE user_groups;

+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| ug_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ug_group | varbinary(255)   | NO   | PRI |         |       |
+----------+------------------+------+-----+---------+-------+

Versions de MediaWiki :

1.19 – 1.20

DESCRIBE user_groups;

+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| ug_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ug_group | varbinary(32)    | NO   | PRI |         |       |
+----------+------------------+------+-----+---------+-------+

Versions de MediaWiki :

1.10 – 1.18

DESCRIBE user_groups;

+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| ug_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ug_group | varbinary(16)    | NO   | PRI |         |       |
+----------+------------------+------+-----+---------+-------+

Versions de MediaWiki :

1.5 – 1.9

DESCRIBE user_groups;

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

Les index

Version de MediaWiki :

≥ 1.29

SHOW INDEX IN user_groups;

+-------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| user_groups |          0 | PRIMARY   |            1 | ug_user     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| user_groups |          0 | PRIMARY   |            2 | ug_group    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| user_groups |          1 | ug_group  |            1 | ug_group    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| user_groups |          1 | ug_expiry |            1 | ug_expiry   | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+-------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Groupes MediaWiki par défaut

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

SELECT DISTINCT `ug_group` FROM `user_groups`;

+------------+
| ug_group   |
+------------+
| bot        |
| bureaucrat |
| sysop      |
+------------+