2 -- This table contains a user's bot passwords: passwords that allow access to
3 -- the account via the API with limited rights.
5 CREATE TABLE /*_*/bot_passwords (
6 -- Foreign key to user.user_id
9 -- Application identifier
10 bp_app_id
varbinary(32) NOT NULL,
12 -- Password hashes, like user.user_password
13 bp_password tinyblob
NOT NULL,
15 -- Like user.user_token
16 bp_token
binary(32) NOT NULL default '',
18 -- JSON blob for MWRestrictions
19 bp_restrictions
blob NOT NULL,
21 -- Grants allowed to the account when authenticated with this bot-password
22 bp_grants
blob NOT NULL,
24 PRIMARY KEY ( bp_user
, bp_app_id
)
25 ) /*$wgDBTableOptions*/;