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.
Category:Wikimedia extension database tables#oathauth devices%20table
