Manual:external_user table

From mediawiki.org
Other languages:
Manual:Contents MediaWiki database layout external_user table

The external_user table tracked external user accounts, if ExternalAuth was used.

MediaWiki versions:
1.16 – 1.21

The table has been removed in MediaWiki 1.22 gerrit:54900 along with the ExternalAuth functionality. AuthPlugin 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      |         |               |
+---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+