| 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
------------