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