mysql> desc users; +-------------+------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------------------+----------------+ | user_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | username | varchar(128) | NO | | NULL | | | mail_host | varchar(128) | NO | | NULL | | | alias | varchar(128) | NO | | NULL | | | created | datetime | NO | | 0000-00-00 00:00:00 | | | last_login | datetime | NO | | 0000-00-00 00:00:00 | | | language | varchar(5) | NO | | en | | | preferences | text | YES | | NULL | | +-------------+------------------+------+-----+---------------------+----------------+ 8 rows in set (0.00 sec)