Merge pull request #5735 from Aditoo17/patch-1

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

diff --git a/doc/database/db_gcontact.md b/doc/database/db_gcontact.md
index 8e9de43c96fb99827970be4c99a810fd9f796627..3c0118a33dcb5cda5d21ccb21664b658ee537c62 100644 (file)
--- a/doc/database/db_gcontact.md
+++ b/doc/database/db_gcontact.md
@@ -10,17 +10,22 @@ Table gcontact
 | nurl         |                                    | varchar(255)     | NO   | MUL |                     |                |
 | photo        | Link to the profile photo          | varchar(255)     | NO   |     |                     |                |
 | connect      |                                    | varchar(255)     | NO   |     |                     |                |
-| created      |                                    | datetime         | NO   |     | 0000-00-00 00:00:00 |                |
-| updated      |                                    | datetime         | YES  | MUL | 0000-00-00 00:00:00 |                |
-| last_contact |                                    | datetime         | YES  |     | 0000-00-00 00:00:00 |                |
-| last_failure |                                    | datetime         | YES  |     | 0000-00-00 00:00:00 |                |
+| created      |                                    | datetime         | NO   |     | 0001-01-01 00:00:00 |                |
+| updated      |                                    | datetime         | YES  | MUL | 0001-01-01 00:00:00 |                |
+| last_contact |                                    | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
+| last_failure |                                    | datetime         | YES  |     | 0001-01-01 00:00:00 |                |
 | location     |                                    | varchar(255)     | NO   |     |                     |                |
 | about        |                                    | text             | NO   |     | NULL                |                |
 | keywords     | puplic keywords (interests)        | text             | NO   |     | NULL                |                |
 | gender       |                                    | varchar(32)      | NO   |     |                     |                |
+| birthday     |                                    | varchar(32)      | NO   |     | 0001-01-01          |                |
 | community    | 1 if contact is forum account      | tinyint(1)       | NO   |     | 0                   |                |
+| hide         | 1 = should be hidden from search   | tinyint(1)       | NO   |     | 0                   |                |
+| nsfw         | 1 = contact posts nsfw content     | tinyint(1)       | NO   |     | 0                   |                |
 | network      | social network protocol            | varchar(255)     | NO   |     |                     |                |
 | addr         |                                    | varchar(255)     | NO   |     |                     |                |
+| notify       |                                    | text             | NO   |     |                     |                |
+| alias        |                                    | varchar(255)     | NO   |     |                     |                |
 | generation   |                                    | tinyint(3)       | NO   |     | 0                   |                |
 | server_url   | baseurl of the contacts server     | varchar(255)     | NO   |     |                     |                |