X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-thread-user.md;h=7c6eac868caa726bbca2861535f46ed1178fd043;hb=ab42fd88a4c05f6e76bc836c42b751d9c6d22dbd;hp=3efb5a77af42aa4bd16607981c07a199bec84e2f;hpb=c9ec2e21b3db208282b553fccdd425479f58bf0e;p=friendica.git diff --git a/doc/database/db_post-thread-user.md b/doc/database/db_post-thread-user.md index 3efb5a77af..7c6eac868c 100644 --- a/doc/database/db_post-thread-user.md +++ b/doc/database/db_post-thread-user.md @@ -18,13 +18,13 @@ Fields | changed | Date that something in the conversation changed, indicating clients should fetch the conversation again | datetime | NO | | 0001-01-01 00:00:00 | | | commented | | datetime | NO | | 0001-01-01 00:00:00 | | | uid | Owner id which owns this copy of the item | mediumint unsigned | NO | PRI | 0 | | -| pinned | The thread is pinned on the profile page | boolean | NO | | 0 | | +| pinned | deprecated | boolean | NO | | 0 | | | starred | | boolean | NO | | 0 | | | ignored | Ignore updates for this thread | boolean | NO | | 0 | | | wall | This item was posted to the wall of uid | boolean | NO | | 0 | | | mention | | boolean | NO | | 0 | | | pubmail | | boolean | NO | | 0 | | -| forum_mode | | tinyint unsigned | NO | | 0 | | +| forum_mode | Deprecated | tinyint unsigned | NO | | 0 | | | contact-id | contact.id | int unsigned | NO | | 0 | | | unseen | post has not been seen | boolean | NO | | 1 | | | hidden | Marker to hide the post from the user | boolean | NO | | 0 | | @@ -35,23 +35,23 @@ Fields Indexes ------------ -| Name | Fields | -| ------------- | -------------- | -| PRIMARY | uid, uri-id | -| uri-id | uri-id | -| owner-id | owner-id | -| author-id | author-id | -| causer-id | causer-id | -| uid | uid | -| contact-id | contact-id | -| psid | psid | -| post-user-id | post-user-id | -| commented | commented | -| uid_received | uid, received | -| uid_pinned | uid, pinned | -| uid_commented | uid, commented | -| uid_starred | uid, starred | -| uid_mention | uid, mention | +| Name | Fields | +| ----------------- | ------------------- | +| PRIMARY | uid, uri-id | +| uri-id | uri-id | +| owner-id | owner-id | +| author-id | author-id | +| causer-id | causer-id | +| uid | uid | +| contact-id | contact-id | +| psid | psid | +| post-user-id | post-user-id | +| commented | commented | +| uid_received | uid, received | +| uid_wall_received | uid, wall, received | +| uid_commented | uid, commented | +| uid_starred | uid, starred | +| uid_mention | uid, mention | Foreign Keys ------------