CREATE UNIQUE INDEX /*i*/user_properties_user_property ON /*_*/user_properties (up_user,up_property);
CREATE INDEX /*i*/user_properties_property ON /*_*/user_properties (up_property);
---
--- This table contains a user's bot passwords: passwords that allow access to
--- the account via the API with limited rights.
---
-CREATE TABLE /*_*/bot_passwords (
- -- User ID obtained from CentralIdLookup.
- bp_user int NOT NULL,
-
- -- Application identifier
- bp_app_id varbinary(32) NOT NULL,
-
- -- Password hashes, like user.user_password
- bp_password tinyblob NOT NULL,
-
- -- Like user.user_token
- bp_token binary(32) NOT NULL default '',
-
- -- JSON blob for MWRestrictions
- bp_restrictions blob NOT NULL,
-
- -- Grants allowed to the account when authenticated with this bot-password
- bp_grants blob NOT NULL,
-
- PRIMARY KEY ( bp_user, bp_app_id )
-) /*$wgDBTableOptions*/;
-
--
-- Core of the wiki: each page has an entry here which identifies
-- it by title and contains some essential metadata.