X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-delivery.md;h=2a766eea56f31b93a697df17e70f389a40d2522b;hb=9581b05603e6ee4e250738c159ed2e67b3fb2eeb;hp=1937e059a5e43dbce1e2cf9dee85bae6860f5ac7;hpb=c608d857077cc3c830637dbcbd40a92f842f456d;p=friendica.git diff --git a/doc/database/db_post-delivery.md b/doc/database/db_post-delivery.md index 1937e059a5..2a766eea56 100644 --- a/doc/database/db_post-delivery.md +++ b/doc/database/db_post-delivery.md @@ -1,18 +1,20 @@ Table post-delivery =========== -Status of ActivityPub inboxes +Delivery data for posts for the batch processing Fields ------ -| Field | Description | Type | Null | Key | Default | Extra | -| -------- | --------------------------------------------------------- | ------------------ | ---- | --- | ------------------- | ----- | -| uri-id | Id of the item-uri table entry that contains the item uri | int unsigned | NO | PRI | NULL | | -| inbox-id | Item-uri id of inbox url | int unsigned | NO | PRI | NULL | | -| uid | Delivering user | mediumint unsigned | YES | | NULL | | -| created | | datetime | YES | | 0001-01-01 00:00:00 | | -| command | | varbinary(32) | YES | | NULL | | +| Field | Description | Type | Null | Key | Default | Extra | +| --------- | --------------------------------------------------------- | ------------------ | ---- | --- | ------------------- | ----- | +| uri-id | Id of the item-uri table entry that contains the item uri | int unsigned | NO | PRI | NULL | | +| inbox-id | Item-uri id of inbox url | int unsigned | NO | PRI | NULL | | +| uid | Delivering user | mediumint unsigned | YES | | NULL | | +| created | | datetime | YES | | 0001-01-01 00:00:00 | | +| command | | varbinary(32) | YES | | NULL | | +| failed | Number of times the delivery has failed | tinyint | YES | | 0 | | +| receivers | JSON encoded array with the receiving contacts | mediumtext | YES | | NULL | | Indexes ------------