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 | | |
+----------------+------------+--------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+