Manual:bot_passwords/pt table
From Linux Web Expert
| ↑ Manual:Conteúdos | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>bot_passwords/pt</tvar> table</translate> |
| Versão MediaWiki: | <translate> ≥</translate> 1.27 |
A tabela bot_passwords guarda as palavras-passe robô.
Nos conjuntos de wiki utilizar algum tipo de início de sessão única, nas wikis pode utilizar uma única tabela partilhada; embora, a tabela
bot_password da wiki local não é necessariamente onde são guardadas as palavras-passe. Consulte $wgBotPasswordsDatabase e $wgBotPasswordsCluster.
Campos
bp_user
Id. de Central do utilizador. Na instalação predefinida, isto é uma chave externa para user.user_id.
bp_app_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.
bp_password
Cardinal da palavras-passe (tal como user.user_password).
bp_token
Token for remembering / invalidating the session (like user.user_token).
bp_restrictions
JSON blob for MWRestrictions.
bp_grants
Grants allowed to the account when authenticated with this bot-password.
Resumo de esquema
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
DESCRIBE bot_passwords/pt;
+-----------------+------------------+------+-----+----------------------------------+-------+ | 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 | | +-----------------+------------------+------+-----+----------------------------------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">
1.27 – 1.29
| <translate> MediaWiki versions:</translate> |
DESCRIBE bot_passwords/pt;
+-----------------+---------------+------+-----+----------------------------------+-------+ | 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 | | +-----------------+---------------+------+-----+----------------------------------+-------+
Indexes
| Versão MediaWiki: | <translate> ≥</translate> 1.27 |
SHOW INDEX IN bot_passwords/pt;
+---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +---------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
