]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_fcontact.md
Small cleanup (#5416)
[friendica.git] / doc / database / db_fcontact.md
index e1cecbf87bf95747577f3f875f40a748edfc1651..d9a786acc98072c179c426869fcb9d83106192d2 100644 (file)
@@ -4,6 +4,7 @@ Table fcontact
 | Field    | Description   | Type             | Null | Key | Default             | Extra           |
 | -------- | ------------- | ---------------- | ---- | --- | ------------------- | --------------- |
 | id       | sequential ID | int(10) unsigned | NO   | PRI | NULL                | auto_increment  |
+| guid     | unique id     | varchar(64)      | NO   |     |                     |                 |
 | url      |               | varchar(255)     | NO   |     |                     |                 |
 | name     |               | varchar(255)     | NO   |     |                     |                 |
 | photo    |               | varchar(255)     | NO   |     |                     |                 |
@@ -18,6 +19,6 @@ Table fcontact
 | network  |               | varchar(32)      | NO   |     |                     |                 |
 | alias    |               | varchar(255)     | NO   |     |                     |                 |
 | pubkey   |               | text             | NO   |     | NULL                |                 |
-| updated  |               | datetime         | NO   |     | 0000-00-00 00:00:00 |                 |
+| updated  |               | datetime         | NO   |     | 0001-01-01 00:00:00 |                 |
 
 Return to [database documentation](help/database)