]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_gcontact.md
Merge pull request #5735 from Aditoo17/patch-1
[friendica.git] / doc / database / db_gcontact.md
index c47e72622816f760c7e3f07f83b94456fb15f276..3c0118a33dcb5cda5d21ccb21664b658ee537c62 100644 (file)
@@ -10,15 +10,15 @@ 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   |     | 0000-00-00          |                |
+| 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                   |                |