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.
*, 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 | +------------+