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 bp_user
int NOT NULL REFERENCES /*_*/mwuser(user_id
) ON DELETE CASCADE,
7 bp_app_id
nvarchar(32) NOT NULL,
8 bp_password
nvarchar(255) NOT NULL,
9 bp_token
nvarchar(255) NOT NULL,
10 bp_restrictions
nvarchar(max) NOT NULL,
11 bp_grants
nvarchar(max) NOT NULL,
12 PRIMARY KEY (bp_user
, bp_app_id
)