2021.09 CHANGELOG some more work has been done

[friendica.git] / doc / database / db_contact.md

diff --git a/doc/database/db_contact.md b/doc/database/db_contact.md
index 5a97c6e4dd70b1876501735545ea64e7744611e3..8eeac17ea701baeccccfec2b8ebb2407bac8d05e 100644 (file)
--- a/doc/database/db_contact.md
+++ b/doc/database/db_contact.md
@@ -15,7 +15,7 @@ Fields
 | self                      | 1 if the contact is the user him/her self                    | boolean            | NO   |     | 0                   |                |
 | remote_self               |                                                              | boolean            | NO   |     | 0                   |                |
 | rel                       | The kind of the relation between the user and the contact    | tinyint unsigned   | NO   |     | 0                   |                |
-| duplex                    |                                                              | boolean            | NO   |     | 0                   |                |
+| duplex                    | Deprecated                                                   | boolean            | NO   |     | 0                   |                |
 | network                   | Network of the contact                                       | char(4)            | NO   |     |                     |                |
 | protocol                  | Protocol of the contact                                      | char(4)            | NO   |     |                     |                |
 | name                      | Name that this contact is known by                           | varchar(255)       | NO   |     |                     |                |
@@ -24,16 +24,17 @@ Fields
 | about                     |                                                              | text               | YES  |     | NULL                |                |
 | keywords                  | public keywords (interests) of the contact                   | text               | YES  |     | NULL                |                |
 | gender                    | Deprecated                                                   | varchar(32)        | NO   |     |                     |                |
-| xmpp                      |                                                              | varchar(255)       | NO   |     |                     |                |
+| xmpp                      | XMPP address                                                 | varchar(255)       | NO   |     |                     |                |
+| matrix                    | Matrix address                                               | varchar(255)       | NO   |     |                     |                |
 | attag                     |                                                              | varchar(255)       | NO   |     |                     |                |
 | avatar                    |                                                              | varchar(255)       | NO   |     |                     |                |
 | photo                     | Link to the profile photo of the contact                     | varchar(255)       | YES  |     |                     |                |
 | thumb                     | Link to the profile photo (thumb size)                       | varchar(255)       | YES  |     |                     |                |
 | micro                     | Link to the profile photo (micro size)                       | varchar(255)       | YES  |     |                     |                |
 | header                    | Header picture                                               | varchar(255)       | YES  |     | NULL                |                |
-| site-pubkey               |                                                              | text               | YES  |     | NULL                |                |
-| issued-id                 |                                                              | varchar(255)       | NO   |     |                     |                |
-| dfrn-id                   |                                                              | varchar(255)       | NO   |     |                     |                |
+| site-pubkey               | Deprecated                                                   | text               | YES  |     | NULL                |                |
+| issued-id                 | Deprecated                                                   | varchar(255)       | NO   |     |                     |                |
+| dfrn-id                   | Deprecated                                                   | varchar(255)       | NO   |     |                     |                |
 | url                       |                                                              | varchar(255)       | NO   |     |                     |                |
 | nurl                      |                                                              | varchar(255)       | NO   |     |                     |                |
 | uri-id                    | Id of the item-uri table entry that contains the contact url | int unsigned       | YES  |     | NULL                |                |
@@ -48,8 +49,8 @@ Fields
 | confirm                   |                                                              | varchar(255)       | YES  |     | NULL                |                |
 | subscribe                 |                                                              | varchar(255)       | YES  |     | NULL                |                |
 | poco                      |                                                              | varchar(255)       | YES  |     | NULL                |                |
-| aes_allow                 |                                                              | boolean            | NO   |     | 0                   |                |
-| ret-aes                   |                                                              | boolean            | NO   |     | 0                   |                |
+| aes_allow                 | Deprecated                                                   | boolean            | NO   |     | 0                   |                |
+| ret-aes                   | Deprecated                                                   | boolean            | NO   |     | 0                   |                |
 | usehub                    |                                                              | boolean            | NO   |     | 0                   |                |
 | subhub                    |                                                              | boolean            | NO   |     | 0                   |                |
 | hub-verify                |                                                              | varchar(255)       | NO   |     |                     |                |
@@ -109,8 +110,6 @@ Indexes
 | nurl_uid                    | nurl(128), uid                       |
 | nick_uid                    | nick(128), uid                       |
 | attag_uid                   | attag(96), uid                       |
-| dfrn-id                     | dfrn-id(64)                          |
-| issued-id                   | issued-id(64)                        |
 | network_uid_lastupdate      | network, uid, last-update            |
 | uid_network_self_lastupdate | uid, network, self, last-update      |
 | uid_lastitem                | uid, last-item                       |