X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_workerqueue.md;h=a479ecbcaa22ee7dc54881db0b8fcf0a231868ec;hb=0747eb49618d8b017d92b08172eed984216db81c;hp=ec10ba5496a83f4d4760fcc16bd51b86d9baa3f9;hpb=31db9dbef7f6a4f98a6c29d15493bcffb0c39929;p=friendica.git

diff --git a/doc/database/db_workerqueue.md b/doc/database/db_workerqueue.md
index ec10ba5496..a479ecbcaa 100644
--- a/doc/database/db_workerqueue.md
+++ b/doc/database/db_workerqueue.md
@@ -1,18 +1,38 @@
 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)