Extension:OATHAuth/oathauth_devices table

The OATHAuth extension needs an extra database table to store the 2FA devices. This is the database schema used to create the respective "oathauth_devices" table:

MediaWiki version:

≥ 1.41

mysql> describe oathauth_devices;
+------------+----------------+------+-----+---------+----------------+
| Field      | Type           | Null | Key | Default | Extra          |
+------------+----------------+------+-----+---------+----------------+
| oad_id     | int(11)        | NO   | PRI | NULL    | auto_increment |
| oad_user   | int(11)        | NO   | MUL | NULL    |                |
| oad_type   | int(11)        | NO   |     | NULL    |                |
| oad_name   | varbinary(255) | YES  |     | NULL    |                |
| oad_created| binary(14)     | YES  |     | NULL    |                |
| oad_data   | blob           | YES  |     | NULL    |                |
+------------+----------------+------+-----+---------+----------------+

oad_id

Unique ID of this authentication device

oad_user

User ID referencing the user table.

oad_type

Device type ID, references the "oathauth_types" table

oad_name

User-specified name of this device

oad_created

Timestamp when this authentication device was created

oad_data

Data associated with the authentication device. This is specific to the device type.

Older versions

MediaWiki version:

≤ 1.40

See the information on the "oathauth_users" table.