X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_gcontact.md;h=3c0118a33dcb5cda5d21ccb21664b658ee537c62;hb=39d35025b5147da90574c11be784a151939def18;hp=c47e72622816f760c7e3f07f83b94456fb15f276;hpb=012107f5f775de6fe87d8c8d37e797d2316758c5;p=friendica.git diff --git a/doc/database/db_gcontact.md b/doc/database/db_gcontact.md index c47e726228..3c0118a33d 100644 --- a/doc/database/db_gcontact.md +++ b/doc/database/db_gcontact.md @@ -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 | |