Příručka:Databázová tabulka user_former_groups

From mediawiki.org
This page is a translated version of the page Manual:User former groups table and the translation is 44% complete.
Manuál:Obsah MediaWiki schéma databáze Tabulka user_former_groups
Verze MediaWiki:
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.

Pole

ufg_user

Key to user_id .

ufg_group

Name of the group, which the user was member of.

Přehled změn ve schématu tabulky

Verze MediaWiki:
1.21

DESCRIBE user_former_groups;

+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(255)   | NO   | PRI |         |       |
+-----------+------------------+------+-----+---------+-------+
Verze MediaWiki:
1.19 – 1.20

DESCRIBE user_former_groups;

+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(32)    | NO   | PRI | NULL    |       |
+-----------+------------------+------+-----+---------+-------+
Verze MediaWiki:
1.18

DESCRIBE user_former_groups;

+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(16)    | NO   | PRI | NULL    |       |
+-----------+------------------+------+-----+---------+-------+

Indexy

Verze MediaWiki:
1.30

SHOW INDEX IN user_former_groups;

+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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      |         |               |
+--------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+