Handbuch:external_user-Tabelle

This page is a translated version of the page Manual:External user table and the translation is 56% complete.

MediaWiki-Datenbank-Layout

external_user-Tabelle

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 sollte stattdessen verwendet werden.

Felder

eu_local_id

Foreign key to user_id

eu_external_id

Some opaque identifier provided by the external database

Schematische Übersicht

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    |       |
+----------------+------------------+------+-----+---------+-------+

Indexe

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      |         |               |
+---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+