Fields

Schema summary

 DESCRIBE auth_token;	

6.0

+---------------+------------------+------+-----+---------+----------------+
| 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 |
+------------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_auth_token |          0 | PRIMARY      |            1 | auth_token_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_auth_token |          0 | idx_selector |            1 | selector      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| wacko_auth_token |          1 | idx_user_id  |            1 | user_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+