手册:external_user表

This page is a translated version of the page Manual:External user table and the translation is 78% complete.
Outdated translations are marked like this.
手冊:索引 MediaWiki数据库布局 external_user表

external_user表追踪外部用户账户,如果使用了认证插件 的话。

MediaWiki版本:
1.16 – 1.21

该表在MediaWiki 1.22 gerrit:54900中连同外部验证功能被移除。 应该改用AuthManager

字段

eu_local_id

user_id 的外键

eu_external_id

Some opaque identifier provided by the external database

架构摘要

MediaWiki版本:
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    |       |
+----------------+------------------+------+-----+---------+-------+

索引

MediaWiki版本:
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      |         |               |
+---------------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+