Manual:bot_passwords table

Jump to navigation Jump to search

Other languages:
English • ‎日本語 • ‎中文
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout bot_passwords table

MediaWiki version: 1.27

Stores bot passwords.

On wiki farms using some kind of single sign-on, wikis can use a single shared table; thus, the local wiki's 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 to user.user_idManual:User table#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 (like user.user_passwordManual:User table#user password).


Token for remembering / invalidating the session (like user.user_tokenManual:User table#user token).


JSON blob for MWRestrictions.


Grants allowed to the account when authenticated with this bot-password.

Schema summary[edit]

MediaWiki version: 1.27

DESCRIBE bot_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   |     | NULL    |       |
| bp_restrictions | blob          | NO   |     | NULL    |       |
| bp_grants       | blob          | NO   |     | NULL    |       |
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: actorarchivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifierssite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist