]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_profile.md
Merge pull request #12000 from tobiasd/20221015-vagrant
[friendica.git] / doc / database / db_profile.md
index 79de8ade5db37ad1eb3870ccba78f1beacc407ff..c180332c5b037a0cff9cdd7d6b6223b25fe782c8 100644 (file)
@@ -45,20 +45,21 @@ Fields
 | education    | Deprecated                                    | text               | YES  |     | NULL       |                |
 | contact      | Deprecated                                    | text               | YES  |     | NULL       |                |
 | homepage     |                                               | varchar(255)       | NO   |     |            |                |
-| xmpp         |                                               | varchar(255)       | NO   |     |            |                |
-| photo        |                                               | varchar(255)       | NO   |     |            |                |
-| thumb        |                                               | varchar(255)       | NO   |     |            |                |
+| xmpp         | XMPP address                                  | varchar(255)       | NO   |     |            |                |
+| matrix       | Matrix address                                | varchar(255)       | NO   |     |            |                |
+| photo        |                                               | varbinary(383)     | NO   |     |            |                |
+| thumb        |                                               | varbinary(383)     | NO   |     |            |                |
 | publish      | publish default profile in local directory    | boolean            | NO   |     | 0          |                |
 | net-publish  | publish profile in global directory           | boolean            | NO   |     | 0          |                |
 
 Indexes
 ------------
 
-| Name | Fields |
-|------|---------|
-| PRIMARY | id |
-| uid_is-default | uid, is-default |
-| pub_keywords | FULLTEXT, pub_keywords |
+| Name           | Fields                 |
+| -------------- | ---------------------- |
+| PRIMARY        | id                     |
+| uid_is-default | uid, is-default        |
+| pub_keywords   | FULLTEXT, pub_keywords |
 
 Foreign Keys
 ------------