X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_conversation.md;h=504b0dd4ae1c96bc125dc2865d1cec57ae03d939;hb=904ee0ea591894da1dd9d1fc50a444c28966d946;hp=bcc531a4950030c6965f6691bad5cdb9ff771b34;hpb=a827f948c867ceebf60d82b0740032512be23302;p=friendica.git

diff --git a/doc/database/db_conversation.md b/doc/database/db_conversation.md
index bcc531a495..504b0dd4ae 100644
--- a/doc/database/db_conversation.md
+++ b/doc/database/db_conversation.md
@@ -1,16 +1,30 @@
 Table conversation
 ===========
+
 Raw data and structure information for messages
 
-| 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 |  |    
-| reply-to-uri | URI to which this item is a reply | varbinary(255) | NO |  |  |  |    
-| conversation-uri | GNU Social conversation URI | varbinary(255) | NO |  |  |  |    
-| conversation-href | GNU Social conversation link | varbinary(255) | NO |  |  |  |    
-| protocol | The protocol of the item | tinyint unsigned | NO |  | 255 |  |    
-| direction | How the message arrived here: 1=push, 2=pull | tinyint unsigned | NO |  | 0 |  |    
-| source | Original source | mediumtext | YES |  | NULL |  |    
-| received | Receiving date | datetime | NO |  | 0001-01-01 00:00:00 |  |    
+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                |       |
+| reply-to-uri      | URI to which this item is a reply                                    | varbinary(255)   | NO   |     |                     |       |
+| conversation-uri  | GNU Social conversation URI                                          | varbinary(255)   | NO   |     |                     |       |
+| conversation-href | GNU Social conversation link                                         | varbinary(255)   | NO   |     |                     |       |
+| protocol          | The protocol of the item                                             | tinyint unsigned | NO   |     | 255                 |       |
+| direction         | How the message arrived here: 1=push, 2=pull                         | tinyint unsigned | NO   |     | 0                   |       |
+| 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)