Jump to content

Extension:OAuth/oauth_registered_consumer table

From mediawiki.org


mysql> describe oauth_registered_consumer;
+--------------------------+---------------------+------+-----+---------+----------------+
| Field                    | Type                | Null | Key | Default | Extra          |
+--------------------------+---------------------+------+-----+---------+----------------+
| oarc_id                  | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| oarc_consumer_key        | varbinary(32)       | NO   | UNI | NULL    |                |
| oarc_name                | varbinary(128)      | NO   | MUL | NULL    |                |
| oarc_user_id             | int(10) unsigned    | NO   | MUL | NULL    |                |
| oarc_version             | varbinary(32)       | NO   |     | NULL    |                |
| oarc_callback_url        | blob                | NO   |     | NULL    |                |
| oarc_callback_is_prefix  | tinyblob            | YES  |     | NULL    |                |
| oarc_description         | blob                | NO   |     | NULL    |                |
| oarc_email               | varbinary(255)      | NO   |     | NULL    |                |
| oarc_email_authenticated | varbinary(14)       | YES  |     | NULL    |                |
| oarc_developer_agreement | tinyint(4)          | NO   |     | 0       |                |
| oarc_owner_only          | tinyint(4)          | NO   |     | 0       |                |
| oarc_wiki                | varbinary(32)       | NO   |     | NULL    |                |
| oarc_grants              | blob                | NO   |     | NULL    |                |
| oarc_registration        | varbinary(14)       | NO   |     | NULL    |                |
| oarc_secret_key          | varbinary(32)       | YES  |     | NULL    |                |
| oarc_rsa_key             | blob                | YES  |     | NULL    |                |
| oarc_restrictions        | blob                | NO   |     | NULL    |                |
| oarc_stage               | tinyint(3) unsigned | NO   | MUL | 0       |                |
| oarc_stage_timestamp     | varbinary(14)       | NO   |     | NULL    |                |
| oarc_deleted             | tinyint(3) unsigned | NO   |     | 0       |                |
+--------------------------+---------------------+------+-----+---------+----------------+