+ "workerqueue" => [
+ "comment" => "Background tasks queue entries",
+ "fields" => [
+ "id" => ["type" => "int unsigned", "not null" => "1", "extra" => "auto_increment", "primary" => "1", "comment" => "Auto incremented worker task id"],
+ "command" => ["type" => "varchar(100)", "comment" => "Task command"],
+ "parameter" => ["type" => "mediumtext", "comment" => "Task parameter"],
+ "priority" => ["type" => "tinyint unsigned", "not null" => "1", "default" => "0", "comment" => "Task priority"],
+ "created" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Creation date"],
+ "pid" => ["type" => "int unsigned", "not null" => "1", "default" => "0", "comment" => "Process id of the worker"],
+ "executed" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Execution date"],
+ "next_try" => ["type" => "datetime", "not null" => "1", "default" => DBA::NULL_DATETIME, "comment" => "Next retrial date"],
+ "retrial" => ["type" => "tinyint", "not null" => "1", "default" => "0", "comment" => "Retrial counter"],
+ "done" => ["type" => "boolean", "not null" => "1", "default" => "0", "comment" => "Marked 1 when the task was done - will be deleted later"],
+ ],
+ "indexes" => [
+ "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"]
+ ]
+ ],