user table

Fields

Schema summary

 DESCRIBE user;

+-----------------------------+----------------------+------+-----+---------+----------------+
| Field                       | Type                 | Null | Key | Default | Extra          |
+-----------------------------+----------------------+------+-----+---------+----------------+
| user_id                     | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| user_name                   | varchar(80)          | NO   | UNI | NULL    |                |
| real_name                   | varchar(80)          | NO   |     | NULL    |                |
| account_lang                | varchar(2)           | NO   |     | NULL    |                |
| password                    | varchar(255)         | NO   |     | NULL    |                |
| email                       | varchar(100)         | NO   |     | NULL    |                |
| account_status              | tinyint(1) unsigned  | NO   |     | 0       |                |
| account_type                | tinyint(1) unsigned  | NO   | MUL | 0       |                |
| enabled                     | tinyint(1) unsigned  | NO   | MUL | 1       |                |
| signup_time                 | datetime             | YES  | MUL | NULL    |                |
| change_password             | varchar(64)          | NO   |     | NULL    |                |
| user_ip                     | varchar(45)          | NO   |     | NULL    |                |
| email_confirm               | varchar(64)          | NO   |     | NULL    |                |
| last_visit                  | datetime             | YES  |     | NULL    |                |
| last_mark                   | datetime             | YES  |     | NULL    |                |
| login_count                 | int(10) unsigned     | NO   |     | 0       |                |
| lost_password_request_count | smallint(6) unsigned | NO   |     | 0       |                |
| failed_login_count          | smallint(6) unsigned | NO   |     | 0       |                |
| total_pages                 | int(10) unsigned     | NO   |     | 0       |                |
| total_revisions             | int(10) unsigned     | NO   |     | 0       |                |
| total_comments              | int(10) unsigned     | NO   |     | 0       |                |
| total_uploads               | int(10) unsigned     | NO   |     | 0       |                |
| fingerprint                 | varchar(40)          | YES  |     | NULL    |                |
+-----------------------------+----------------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN user;

+----------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_user |          0 | PRIMARY          |            1 | user_id      | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |
| dev_user |          0 | idx_user_name    |            1 | user_name    | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |
| dev_user |          1 | idx_account_type |            1 | account_type | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |
| dev_user |          1 | idx_enabled      |            1 | enabled      | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| dev_user |          1 | idx_signup_time  |            1 | signup_time  | A         |           6 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------+------------+------------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+