Manual:external_user table
From Linux Web Expert
| ↑ Manual:Contents | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>external_user</tvar> table</translate> |
The external_user table tracked external user accounts, if ExternalAuth via AuthPlugin was used.
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.21</tvar> is unsupported version</translate>"> 1.16 – 1.21
| <translate> MediaWiki versions:</translate> |
The table has been removed in MediaWiki 1.22 gerrit:54900 along with the ExternalAuth functionality. AuthManager should be used instead.
Fields
eu_local_id
Foreign key to user_id
eu_external_id
Some opaque identifier provided by the external database
Schema summary
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.21</tvar> is unsupported version</translate>"> 1.16 – 1.21
| <translate> MediaWiki versions:</translate> |
DESCRIBE external_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
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.21</tvar> is unsupported version</translate>"> 1.16 – 1.21
| <translate> MediaWiki versions:</translate> |
SHOW INDEX IN external_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 | | | +---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
