Manual:User former groups table

Language:	English

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

user_former_groups table

MediaWiki version:

≥ 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 he has 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

MediaWiki version:

1.21

mysql> describe user_former_groups;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(255)   | NO   | PRI |         |       |
+-----------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

MediaWiki version:

1.19

mysql> describe user_former_groups;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(32)    | NO   | PRI |         |       |
+-----------+------------------+------+-----+---------+-------+

MediaWiki version:

1.18

mysql> describe user_former_groups;
+-----------+------------------+------+-----+---------+-------+
| Field     | Type             | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+-------+
| ufg_user  | int(10) unsigned | NO   | PRI | 0       |       |
| ufg_group | varbinary(16)    | NO   | PRI |         |       |
+-----------+------------------+------+-----+---------+-------+
2 rows in set (0.11 sec)

DatabasesManual:Database layout

Engines: MySQLManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist