Manual:Bot passwords table/en

The bot_passwords table stores bot passwords.

bp_user
Central ID of the user. On a default installation this is a foreign key to.

bp_app_id
App ID, used to differentiate multiple applications using the same account; applications using bot login need to pass  as username.

bp_password
Password hash (like ).

bp_token
Token for remembering / invalidating the session (like ).

bp_restrictions
JSON blob for.

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

Schema summary
+-+--+--+-+--+---+ +-+--+--+-+--+---+ +-+--+--+-+--+---+
 * 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                             |       |

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