X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_workerqueue.md;h=a479ecbcaa22ee7dc54881db0b8fcf0a231868ec;hb=0747eb49618d8b017d92b08172eed984216db81c;hp=16b6a2e0d89c056aa5b1e7de41278abcf838e66b;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git diff --git a/doc/database/db_workerqueue.md b/doc/database/db_workerqueue.md index 16b6a2e0d8..a479ecbcaa 100644 --- 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)