Manual:external_user table
| ↑ Manual:Contents | MediaWiki database layout | external_user table |
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 |
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
[edit]| MediaWiki versions: | 1.16 – 1.21 |
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 | | | +---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+