X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fdatabase%2Fdb_conversation.md;h=504b0dd4ae1c96bc125dc2865d1cec57ae03d939;hb=7224c0fc38d340447cd79ad6b7ebebc722d9627c;hp=964a98d6100220e256acc36b0d6d01d7e43bc9a8;hpb=2cd0c1d30d237806e9c3853aa0645f786e31855c;p=friendica.git

diff --git a/doc/database/db_conversation.md b/doc/database/db_conversation.md
index 964a98d610..504b0dd4ae 100644
--- a/doc/database/db_conversation.md
+++ b/doc/database/db_conversation.md
@@ -3,6 +3,9 @@ Table conversation
 
 Raw data and structure information for messages
 
+Fields
+------
+
 | Field             | Description                                                          | Type             | Null | Key | Default             | Extra |
 | ----------------- | -------------------------------------------------------------------- | ---------------- | ---- | --- | ------------------- | ----- |
 | item-uri          | Original URI of the item - unrelated to the table with the same name | varbinary(255)   | NO   | PRI | NULL                |       |
@@ -14,4 +17,14 @@ Raw data and structure information for messages
 | source            | Original source                                                      | mediumtext       | YES  |     | NULL                |       |
 | received          | Receiving date                                                       | datetime         | NO   |     | 0001-01-01 00:00:00 |       |
 
+Indexes
+------------
+
+| Name             | Fields           |
+| ---------------- | ---------------- |
+| PRIMARY          | item-uri         |
+| conversation-uri | conversation-uri |
+| received         | received         |
+
+
 Return to [database documentation](help/database)