Manual:external_user table
Appearance
From mediawiki.org
The external_user table tracked external user accounts, if ExternalAuth via AuthPlugin was used.
MediaWiki versions:
1.16 – 1.21
The table has been removed in MediaWiki 1.22 gerrit:54900 along with the ExternalAuth functionality. AuthManager should be used instead.
Fields
[edit ]eu_local_id
[edit ]Foreign key to user_id
eu_external_id
[edit ]Some opaque identifier provided by the external database
Schema summary
[edit ] MediaWiki versions:
1.16 – 1.21
DESCRIBEexternal_user;
+----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | eu_local_id | int(10) unsigned | NO | PRI | NULL | | | eu_external_id | varbinary(255) | NO | UNI | NULL | | +----------------+------------------+------+-----+---------+-------+
Indexes
[edit ] MediaWiki versions:
1.16 – 1.21
SHOWINDEXINexternal_user;
+---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | external_user | 0 | PRIMARY | 1 | eu_local_id | A | 0 | NULL | NULL | | BTREE | | | | external_user | 0 | eu_external_id | 1 | eu_external_id | A | 0 | NULL | NULL | | BTREE | | | +---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+