X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_contact.md;h=8221f279e271418fae472c03a76dcdf749d524f8;hb=a275f0a719c605e358334833a3a9d49a310f2389;hp=6f5a39536699583650e540623eba076edeaff478;hpb=a10f55bb85b503c098ea1642adf4e9bda26e6746;p=friendica.git diff --git a/doc/database/db_contact.md b/doc/database/db_contact.md index 6f5a395366..8221f279e2 100644 --- a/doc/database/db_contact.md +++ b/doc/database/db_contact.md @@ -21,6 +21,7 @@ Fields | xmpp | XMPP address | varchar(255) | NO | | | | | matrix | Matrix address | varchar(255) | NO | | | | | avatar | | varbinary(383) | NO | | | | +| blurhash | BlurHash representation of the avatar | varbinary(255) | YES | | NULL | | | header | Header picture | varbinary(383) | YES | | NULL | | | url | | varbinary(383) | NO | | | | | nurl | | varbinary(383) | NO | | | | @@ -50,8 +51,8 @@ Fields | archive | | boolean | NO | | 0 | | | unsearchable | Contact prefers to not be searchable | boolean | NO | | 0 | | | sensitive | Contact posts sensitive content | boolean | NO | | 0 | | -| baseurl | baseurl of the contact | varbinary(383) | YES | | | | -| gsid | Global Server ID | int unsigned | YES | | NULL | | +| baseurl | baseurl of the contact from the gserver record, can be missing | varbinary(383) | YES | | | | +| gsid | Global Server ID, can be missing | int unsigned | YES | | NULL | | | bd | | date | NO | | 0001-01-01 | | | reason | | text | YES | | NULL | | | self | 1 if the contact is the user him/her self | boolean | NO | | 0 | | @@ -80,7 +81,7 @@ Fields | confirm | | varbinary(383) | YES | | NULL | | | poco | | varbinary(383) | YES | | NULL | | | writable | | boolean | NO | | 0 | | -| forum | contact is a forum. Deprecated, use 'contact-type' = 'community' and 'manually-approve' = false instead | boolean | NO | | 0 | | +| forum | contact is a group. Deprecated, use 'contact-type' = 'community' and 'manually-approve' = false instead | boolean | NO | | 0 | | | prv | contact is a private group. Deprecated, use 'contact-type' = 'community' and 'manually-approve' = true instead | boolean | NO | | 0 | | | bdyear | | varchar(4) | NO | | | | | site-pubkey | Deprecated | text | YES | | NULL | |