@ # mysqlshow qmail_db usertable
Database: qmail_db  Table: usertable  Rows: 0
+-------------+------------------+------+-----+--------------------+-------+---------------------------------+
| Field       | Type             | Null | Key | Default            | Extra | Privileges                      |
+-------------+------------------+------+-----+--------------------+-------+---------------------------------+
| id          | char(32)         |      | MUL |                    |       | select,insert,update,references |
| crypt       | char(32) binary  |      |     |                    |       | select,insert,update,references |
| uid         | int(10) unsigned |      |     | 65534              |       | select,insert,update,references |
| gid         | int(10) unsigned |      |     | 65534              |       | select,insert,update,references |
| shell       | char(100) binary |      | MUL | /noexists          |       | select,insert,update,references |
| home        | char(100) binary |      | MUL | /tmp/foofoo/barbar |       | select,insert,update,references |
| start_date  | date             |      | MUL | 0000-00-00         |       | select,insert,update,references |
| expire_date | date             |      | MUL | 2030-01-01         |       | select,insert,update,references |
| active      | enum('Y','N')    |      | MUL | Y                  |       | select,insert,update,references |
+-------------+------------------+------+-----+--------------------+-------+---------------------------------+