Table workerqueue
===========
+
Background tasks queue entries
-| Field | Description | Type | Null | Key | Default | Extra |
-| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
-| id | Auto incremented worker task id | int unsigned | YES | PRI | NULL | auto_increment |
-| command | Task command | varchar(100) | NO | | NULL | |
-| parameter | Task parameter | mediumtext | NO | | NULL | |
-| priority | Task priority | tinyint unsigned | YES | | 0 | |
-| created | Creation date | datetime | YES | | 0001-01-01 00:00:00 | |
-| pid | Process id of the worker | int unsigned | YES | | 0 | |
-| executed | Execution date | datetime | YES | | 0001-01-01 00:00:00 | |
-| next_try | Next retrial date | datetime | YES | | 0001-01-01 00:00:00 | |
-| retrial | Retrial counter | tinyint | YES | | 0 | |
-| done | Marked 1 when the task was done - will be deleted later | boolean | YES | | 0 | |
+Fields
+------
+
+| Field | Description | Type | Null | Key | Default | Extra |
+| --------- | ------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | -------------- |
+| id | Auto incremented worker task id | int unsigned | NO | PRI | NULL | auto_increment |
+| command | Task command | varchar(100) | YES | | NULL | |
+| parameter | Task parameter | mediumtext | YES | | NULL | |
+| priority | Task priority | tinyint unsigned | NO | | 0 | |
+| created | Creation date | datetime | NO | | 0001-01-01 00:00:00 | |
+| pid | Process id of the worker | int unsigned | NO | | 0 | |
+| executed | Execution date | datetime | NO | | 0001-01-01 00:00:00 | |
+| next_try | Next retrial date | datetime | NO | | 0001-01-01 00:00:00 | |
+| retrial | Retrial counter | tinyint | NO | | 0 | |
+| done | Marked 1 when the task was done - will be deleted later | boolean | NO | | 0 | |
+
+Indexes
+------------
+
+| Name | Fields |
+| ----------------------------- | -------------------------------- |
+| PRIMARY | id |
+| command | command |
+| done_command_parameter | done, command, parameter(64) |
+| done_executed | done, executed |
+| done_priority_retrial_created | done, priority, retrial, created |
+| done_priority_next_try | done, priority, next_try |
+| done_pid_next_try | done, pid, next_try |
+| done_pid_retrial | done, pid, retrial |
+| done_pid_priority_created | done, pid, priority, created |
+
Return to [database documentation](help/database)