X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_item.md;h=d24d92bad8f16139a70d8bcd48194e7d4694dc91;hb=8045fae706acea930df5960e360b7b6636a9e3d9;hp=00fa213c8999778284a15ce17b15e5c355826ef7;hpb=f4173d17649afc81c14278941cd046f958818d93;p=friendica.git diff --git a/doc/database/db_item.md b/doc/database/db_item.md index 00fa213c89..d24d92bad8 100644 --- a/doc/database/db_item.md +++ b/doc/database/db_item.md @@ -16,17 +16,19 @@ Table item | parent-uri | uri of the parent to this item | varchar(255) | NO | MUL | | | | extid | | varchar(255 | NO | MUL | | | | thr-parent | If the parent of this item is not the top-level item in the conversation, the uri of the immediate parent; otherwise set to parent-uri | varchar(255) | NO | | | | -| created | Creation timestamp. | datetime | NO | | 0000-00-00 00:00:00 | | -| edited | Date of last edit (default is created) | datetime | NO | | 0000-00-00 00:00:00 | | -| commented | Date of last comment/reply to this item | datetime | NO | | 0000-00-00 00:00:00 | | -| received | datetime | datetime | NO | | 0000-00-00 00:00:00 | | -| changed | Date that something in the conversation changed, indicating clients should fetch the conversation again | datetime | NO | | 0000-00-00 00:00:00 | | +| created | Creation timestamp. | datetime | NO | | 0001-01-01 00:00:00 | | +| edited | Date of last edit (default is created) | datetime | NO | | 0001-01-01 00:00:00 | | +| commented | Date of last comment/reply to this item | datetime | NO | | 0001-01-01 00:00:00 | | +| received | datetime | datetime | NO | | 0001-01-01 00:00:00 | | +| changed | Date that something in the conversation changed, indicating clients should fetch the conversation again | datetime | NO | | 0001-01-01 00:00:00 | | | owner-name | Name of the owner of this item | varchar(255) | NO | | | | | owner-link | Link to the profile page of the owner of this item | varchar(255) | NO | | | | | owner-avatar | Link to the avatar picture of the owner of this item | varchar(255) | NO | | | | +| owner-id | Link to the contact table with uid=0 of the owner of this item | int(11) | NO | MUL | 0 | | | author-name | Name of the author of this item | varchar(255) | NO | | | | | author-link | Link to the profile page of the author of this item | varchar(255) | NO | | | | | author-avatar | Link to the avatar picture of the author of this item | varchar(255) | NO | | | | +| author-id | Link to the contact table with uid=0 of the author of this item | int(11) | NO | MUL | 0 | | | title | item title | varchar(255) | NO | | | | | body | item body content | mediumtext | NO | | NULL | | | app | application which generated this item | varchar(255) | NO | | | |