Manual:user_former_groups/fr table
From Linux Web Expert
| ↑ Manuel:Contenu | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>user_former_groups/fr</tvar> table</translate> |
| Version de MediaWiki : | <translate> ≥</translate> 1.18 |
The user_former_groups table stores the groups the user has once belonged to (will not contain groups the user had belonged to before MW 1.17). The user may again belong to these groups; check the table user_groups, if you want to know. This is used to keep MediaWiki from automatically adding users to groups from which they have been manually removed before. The table was added in r90749.
Fields
ufg_user
Key to user_id.
ufg_group
Name of the group, which the user was member of.
Schema summary
| Version de MediaWiki : | <translate> ≥</translate> 1.21 |
DESCRIBE user_former_groups/fr;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | ufg_user | int(10) unsigned | NO | PRI | 0 | | | ufg_group | varbinary(255) | NO | PRI | | | +-----------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.20</tvar> is unsupported version</translate>">
1.19 – 1.20
| <translate> MediaWiki versions:</translate> |
DESCRIBE user_former_groups/fr;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | ufg_user | int(10) unsigned | NO | PRI | 0 | | | ufg_group | varbinary(32) | NO | PRI | NULL | | +-----------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.18</tvar> is unsupported version</translate>">
1.18
| Version de MediaWiki : |
DESCRIBE user_former_groups/fr;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | ufg_user | int(10) unsigned | NO | PRI | 0 | | | ufg_group | varbinary(16) | NO | PRI | NULL | | +-----------+------------------+------+-----+---------+-------+
Indexes
<translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN user_former_groups/fr;
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | user_former_groups | 0 | PRIMARY | 1 | ufg_user | A | 0 | NULL | NULL | | BTREE | | | | user_former_groups | 0 | PRIMARY | 2 | ufg_group | A | 0 | NULL | NULL | | BTREE | | | +--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
