]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_post-delivery.md
Merge remote-tracking branch 'upstream/develop' into api-edit
[friendica.git] / doc / database / db_post-delivery.md
index 79e858193a8b26e185c8f28a72a39fcab23bcb72..2a766eea56f31b93a697df17e70f389a40d2522b 100644 (file)
@@ -6,13 +6,15 @@ 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
 ------------