Merge remote-tracking branch 'origin/2022.12-rc' into fixes

[friendica.git] / doc / database / db_workerqueue.md

diff --git a/doc/database/db_workerqueue.md b/doc/database/db_workerqueue.md
index 16b6a2e0d89c056aa5b1e7de41278abcf838e66b..a479ecbcaa22ee7dc54881db0b8fcf0a231868ec 100644 (file)
--- a/doc/database/db_workerqueue.md
+++ b/doc/database/db_workerqueue.md
@@ -3,6 +3,9 @@ Table workerqueue
 
 Background tasks queue entries
 
+Fields
+------
+
 | Field     | Description                                             | Type             | Null | Key | Default             | Extra          |
 | --------- | ------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | -------------- |
 | id        | Auto incremented worker task id                         | int unsigned     | NO   | PRI | NULL                | auto_increment |
@@ -16,4 +19,20 @@ Background tasks queue entries
 | 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)