mysql> desc users;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user     | varchar(90)      | NO   |     | NULL    |                |
| password | varchar(120)     | NO   |     | NULL    |                |
| email    | varchar(255)     | YES  |     | NULL    |                |
| role     | varchar(50)      | YES  |     | NULL    |                |
| language | varchar(3)       | YES  |     | NULL    |                |
| resetkey | varchar(255)     | YES  |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)