| 1 | mysql> DESC jobqueue; |
|---|
| 2 | +--------------+--------------+------+-----+---------------------+-----------------------------+ |
|---|
| 3 | | Field | Type | Null | Key | Default | Extra | |
|---|
| 4 | +--------------+--------------+------+-----+---------------------+-----------------------------+ |
|---|
| 5 | | id | int(11) | NO | PRI | NULL | auto_increment | |
|---|
| 6 | | chanid | int(10) | NO | MUL | 0 | | |
|---|
| 7 | | starttime | datetime | NO | | 0000-00-00 00:00:00 | | |
|---|
| 8 | | inserttime | datetime | NO | | 0000-00-00 00:00:00 | | |
|---|
| 9 | | type | int(11) | NO | | 0 | | |
|---|
| 10 | | cmds | int(11) | NO | | 0 | | |
|---|
| 11 | | flags | int(11) | NO | | 0 | | |
|---|
| 12 | | status | int(11) | NO | | 0 | | |
|---|
| 13 | | statustime | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | |
|---|
| 14 | | hostname | varchar(64) | YES | | | | |
|---|
| 15 | | args | blob | NO | | NULL | | |
|---|
| 16 | | comment | varchar(128) | NO | | | | |
|---|
| 17 | | schedruntime | datetime | NO | | 2007-01-01 00:00:00 | | |
|---|
| 18 | +--------------+--------------+------+-----+---------------------+-----------------------------+ |
|---|
| 19 | 13 rows in set (0.03 sec) |
|---|
| 20 | |
|---|
| 21 | mysql> |
|---|
