auth_token table

Fields

Schema summary

 DESCRIBE auth_token;

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| auth_token_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| selector      | char(12)         | NO   | UNI | NULL    |                |
| token         | char(64)         | NO   |     | NULL    |                |
| user_id       | int(10) unsigned | NO   | MUL | 0       |                |
| token_expires | datetime         | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN auth_token;

+----------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name     | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_auth_token |          0 | PRIMARY      |            1 | auth_token_id | A         |           5 |     NULL | NULL   |      | BTREE      |         |               |
| dev_auth_token |          0 | idx_selector |            1 | selector      | A         |           5 |     NULL | NULL   |      | BTREE      |         |               |
| dev_auth_token |          1 | idx_user_id  |            1 | user_id       | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
+----------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+