Manual:User groups table/fr

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 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, 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. Avant MediaWiki 1.5, les droits utilisateur se trouvaient dans le champ de la table.

All unregistered users automatically belong to the  group and only to that group; all registered users additionally are automatically part of the   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.

ug_user
This field links to a given user's. 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, 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   groups. Example  values: 'bot', 'bureaucrat', 'sysop'.

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

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



Résumé du schéma
+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * 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    |       |

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

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

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

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

Les index
 +-++---+--+-+---+-+--++--++-+---+ +-++---+--+-+---+-+--++--++-+---+ +-++---+--+-+---+-+--++--++-+---+
 * 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:

++ ++ ++
 * ug_group  |
 * bot       |
 * bureaucrat |
 * sysop     |