| MediaWiki version: | ≥ 1.27 |
Thebot_passwords table storesbot passwords.
bot_password table is not necessarily the one where the passwords are stored. See$wgBotPasswordsDatabase and$wgBotPasswordsCluster.Central ID of the user.On a default installation this is a foreign key touser.user_id.
App ID, used to differentiate multiple applications using the same account; applications using bot login need to pass<real username>@<app id> as username.
Password hash (likeuser.user_password).
Token for remembering / invalidating the session (likeuser.user_token).
JSON blob forMWRestrictions.
Grants allowed to the account when authenticated with this bot-password.
| MediaWiki version: | ≥ 1.30 |
DESCRIBEbot_passwords;
+-----------------+------------------+------+-----+----------------------------------+-------+| Field | Type | Null | Key | Default | Extra |+-----------------+------------------+------+-----+----------------------------------+-------+| bp_user | int(10) unsigned | NO | PRI | NULL | || bp_app_id | varbinary(32) | NO | PRI | NULL | || bp_password | tinyblob | NO | | NULL | || bp_token | binary(32) | NO | | | || bp_restrictions | blob | NO | | NULL | || bp_grants | blob | NO | | NULL | |+-----------------+------------------+------+-----+----------------------------------+-------+
| MediaWiki versions: | 1.27 – 1.29 |
DESCRIBEbot_passwords;
+-----------------+---------------+------+-----+----------------------------------+-------+| Field | Type | Null | Key | Default | Extra |+-----------------+---------------+------+-----+----------------------------------+-------+| bp_user | int(11) | NO | PRI | NULL | || bp_app_id | varbinary(32) | NO | PRI | NULL | || bp_password | tinyblob | NO | | NULL | || bp_token | binary(32) | NO | | | || bp_restrictions | blob | NO | | NULL | || bp_grants | blob | NO | | NULL | |+-----------------+---------------+------+-----+----------------------------------+-------+
| MediaWiki version: | ≥ 1.27 |
SHOWINDEXINbot_passwords;
+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+| bot_passwords | 0 | PRIMARY | 1 | bp_user | A | 0 | NULL | NULL | | BTREE | | || bot_passwords | 0 | PRIMARY | 2 | bp_app_id | A | 0 | NULL | NULL | | BTREE | | |+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+