]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_contact.md
Move rawContent before theme initialization
[friendica.git] / doc / database / db_contact.md
index 2e3ebc3130a1b166febe9af96efa2be7346e05b9..eb5c505d13ef27dc1587ca1c9396df7494daf59b 100644 (file)
@@ -5,7 +5,7 @@ Table contact
 |---------------------------|-----------------------------------------------------------|--------------|------|-----|---------------------|----------------|
 | id                        | sequential ID                                             | int(11)      | NO   | PRI | NULL                | auto_increment |
 | uid                       | user.id of the owner of this data                         | int(11)      | NO   | MUL | 0                   |                |
-| created                   |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
+| created                   |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
 | self                      | 1 if the contact is the user him/her self                 | tinyint(1)   | NO   |     | 0                   |                |
 | remote_self               |                                                           | tinyint(1)   | NO   |     | 0                   |                |
 | rel                       | The kind of the relation between the user and the contact | tinyint(1)   | NO   |     | 0                   |                |
@@ -41,14 +41,14 @@ Table contact
 | usehub                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
 | subhub                    |                                                           | tinyint(1)   | NO   |     | 0                   |                |
 | hub-verify                |                                                           | varchar(255) | NO   |     |                     |                |
-| last-update               | Date of the last try to update the contact info           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| success_update            | Date of the last successful contact update                | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| failure_update            | Date of the last failed update                            | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| name-date                 |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| uri-date                  |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| avatar-date               |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| term-date                 |                                                           | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
-| last-item                 | date of the last post                                     | datetime     | NO   |     | 0000-00-00 00:00:00 |                |
+| last-update               | Date of the last try to update the contact info           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| success_update            | Date of the last successful contact update                | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| failure_update            | Date of the last failed update                            | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| name-date                 |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| uri-date                  |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| avatar-date               |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| term-date                 |                                                           | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
+| last-item                 | date of the last post                                     | datetime     | NO   |     | 0001-01-01 00:00:00 |                |
 | priority                  |                                                           | tinyint(3)   | NO   |     | 0                   |                |
 | blocked                   |                                                           | tinyint(1)   | NO   |     | 1                   |                |
 | readonly                  | posts of the contact are readonly                         | tinyint(1)   | NO   |     | 0                   |                |
@@ -64,7 +64,7 @@ Table contact
 | info                      |                                                           | mediumtext   | NO   |     | NULL                |                |
 | profile-id                |                                                           | int(11)      | NO   |     | 0                   |                |
 | bdyear                    |                                                           | varchar(4)   | NO   |     |                     |                |
-| bd                        |                                                           | date         | NO   |     | 0000-00-00          |                |
+| bd                        |                                                           | date         | NO   |     | 0001-01-01          |                |
 | notify_new_posts          |                                                           | tinyint(1)   | NO   |     | 0                   |                |
 | fetch_further_information |                                                           | tinyint(1)   | NO   |     | 0                   |                |
 | ffi_keyword_blacklist     |                                                           | mediumtext   | NO   |     | NULL                |                |