X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_post-user.md;h=2fe91d144b4a74436a6729c98e3b63332c325c65;hb=9581b05603e6ee4e250738c159ed2e67b3fb2eeb;hp=5fbc3e985af726881d5af8b6346642ad090ebd69;hpb=bc58cb9b94e2553fa02a874b6c52ebe50e487833;p=friendica.git diff --git a/doc/database/db_post-user.md b/doc/database/db_post-user.md index 5fbc3e985a..2fe91d144b 100644 --- a/doc/database/db_post-user.md +++ b/doc/database/db_post-user.md @@ -34,7 +34,7 @@ Fields | event-id | Used to link to the event.id | int unsigned | YES | | NULL | | | unseen | post has not been seen | boolean | NO | | 1 | | | hidden | Marker to hide the post from the user | boolean | NO | | 0 | | -| notification-type | | tinyint unsigned | NO | | 0 | | +| notification-type | | smallint unsigned | NO | | 0 | | | wall | This item was posted to the wall of uid | boolean | NO | | 0 | | | origin | item originated at this site | boolean | NO | | 0 | | | psid | ID of the permission set of this post | int unsigned | YES | | NULL | | @@ -60,6 +60,7 @@ Indexes | author-id_uid | author-id, uid | | author-id_received | author-id, received | | parent-uri-id_uid | parent-uri-id, uid | +| uid_wall_received | uid, wall, received | | uid_contactid | uid, contact-id | | uid_unseen_contactid | uid, unseen, contact-id | | uid_unseen | uid, unseen |