Manual:user_former_groups table

From MediaWiki.org
Jump to: navigation, search

Other languages:
English • ‎日本語 • ‎polski
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_groupsManual:user_groups table, 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[edit]

ufg_user[edit]

Key to user_idManual:user table#user_id.

ufg_group[edit]

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

Schema summary[edit]

MediaWiki version: 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 | NULL    |       |
+-----------+------------------+------+-----+---------+-------+


MediaWiki versions: 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    |       |
+-----------+------------------+------+-----+---------+-------+


MediaWiki version: 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    |       |
+-----------+------------------+------+-----+---------+-------+
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist