Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates

[friendica.git] / doc / database / db_post-history.md

diff --git a/doc/database/db_post-history.md b/doc/database/db_post-history.md
index 007dcb7f9147766696e20c98eb3641890cf618da..d3e967411ed9504756b31fc97efa2150c884c8a7 100644 (file)
--- a/doc/database/db_post-history.md
+++ b/doc/database/db_post-history.md
@@ -6,26 +6,26 @@ Post history
 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                |       |
-| edited          | Date of edit                                                                                                              | datetime     | NO   | PRI | 0001-01-01 00:00:00 |       |
-| title           | item title                                                                                                                | varchar(255) | NO   |     |                     |       |
-| content-warning |                                                                                                                           | varchar(255) | NO   |     |                     |       |
-| body            | item body content                                                                                                         | mediumtext   | YES  |     | NULL                |       |
-| raw-body        | Body without embedded media links                                                                                         | mediumtext   | YES  |     | NULL                |       |
-| location        | text location where this item originated                                                                                  | varchar(255) | NO   |     |                     |       |
-| coord           | longitude/latitude pair representing location where this item originated                                                  | varchar(255) | NO   |     |                     |       |
-| language        | Language information about this post                                                                                      | text         | YES  |     | NULL                |       |
-| app             | application which generated this item                                                                                     | varchar(255) | NO   |     |                     |       |
-| rendered-hash   |                                                                                                                           | varchar(32)  | NO   |     |                     |       |
-| rendered-html   | item.body converted to html                                                                                               | mediumtext   | YES  |     | NULL                |       |
-| object-type     | ActivityStreams object type                                                                                               | varchar(100) | NO   |     |                     |       |
-| object          | JSON encoded object structure unless it is an implied object (normal post)                                                | text         | YES  |     | NULL                |       |
-| target-type     | ActivityStreams target type if applicable (URI)                                                                           | varchar(100) | NO   |     |                     |       |
-| target          | JSON encoded target structure if used                                                                                     | text         | YES  |     | NULL                |       |
-| resource-id     | Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type | varchar(32)  | NO   |     |                     |       |
-| plink           | permalink or URL to a displayable copy of the message at its source                                                       | varchar(255) | NO   |     |                     |       |
+| 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                |       |
+| edited          | Date of edit                                                                                                              | datetime       | NO   | PRI | 0001-01-01 00:00:00 |       |
+| title           | item title                                                                                                                | varchar(255)   | NO   |     |                     |       |
+| content-warning |                                                                                                                           | varchar(255)   | NO   |     |                     |       |
+| body            | item body content                                                                                                         | mediumtext     | YES  |     | NULL                |       |
+| raw-body        | Body without embedded media links                                                                                         | mediumtext     | YES  |     | NULL                |       |
+| location        | text location where this item originated                                                                                  | varchar(255)   | NO   |     |                     |       |
+| coord           | longitude/latitude pair representing location where this item originated                                                  | varchar(255)   | NO   |     |                     |       |
+| language        | Language information about this post                                                                                      | text           | YES  |     | NULL                |       |
+| app             | application which generated this item                                                                                     | varchar(255)   | NO   |     |                     |       |
+| rendered-hash   |                                                                                                                           | varchar(32)    | NO   |     |                     |       |
+| rendered-html   | item.body converted to html                                                                                               | mediumtext     | YES  |     | NULL                |       |
+| object-type     | ActivityStreams object type                                                                                               | varchar(100)   | NO   |     |                     |       |
+| object          | JSON encoded object structure unless it is an implied object (normal post)                                                | text           | YES  |     | NULL                |       |
+| target-type     | ActivityStreams target type if applicable (URI)                                                                           | varchar(100)   | NO   |     |                     |       |
+| target          | JSON encoded target structure if used                                                                                     | text           | YES  |     | NULL                |       |
+| resource-id     | Used to link other tables to items, it identifies the linked resource (e.g. photo) and if set must also set resource_type | varchar(32)    | NO   |     |                     |       |
+| plink           | permalink or URL to a displayable copy of the message at its source                                                       | varbinary(383) | NO   |     |                     |       |
 
 Indexes
 ------------