Merge pull request #12407 from HankG/friendica-api-photo-endpoint-updates

[friendica.git] / doc / database / db_parsed_url.md

diff --git a/doc/database/db_parsed_url.md b/doc/database/db_parsed_url.md
index 757b8c0ab4226c7001627f67da748cdece0358cd..1752cd0b5b1e8fea5018102e20e70a245d70143d 100644 (file)
--- a/doc/database/db_parsed_url.md
+++ b/doc/database/db_parsed_url.md
@@ -1,15 +1,29 @@
 Table parsed_url
 ===========
-cache for 'parse_url' queries
-
-| Field | Description | Type | Null | Key | Default | Extra |
-| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
-| url_hash | page url hash                     | binary(64) | NO  | PRI | NULL                |  |    
-| guessing | is the 'guessing' mode active?    | boolean    | NO  | PRI | 0                   |  |    
-| oembed   | is the data the result of oembed? | boolean    | NO  | PRI | 0                   |  |    
-| url      | page url                          | text       | NO  |     | NULL                |  |    
-| content  | page data                         | mediumtext | YES |     | NULL                |  |    
-| created  | datetime of creation              | datetime   | NO  |     | 0001-01-01 00:00:00 |  |    
-| expires  | datetime of expiration            | datetime   | NO  |     | 0001-01-01 00:00:00 |  |    
+
+cache for 'parse_url' queries
+
+Fields
+------
+
+| Field    | Description                       | Type       | Null | Key | Default             | Extra |
+| -------- | --------------------------------- | ---------- | ---- | --- | ------------------- | ----- |
+| url_hash | page url hash                     | binary(64) | NO   | PRI | NULL                |       |
+| guessing | is the 'guessing' mode active?    | boolean    | NO   | PRI | 0                   |       |
+| oembed   | is the data the result of oembed? | boolean    | NO   | PRI | 0                   |       |
+| url      | page url                          | text       | NO   |     | NULL                |       |
+| content  | page data                         | mediumtext | YES  |     | NULL                |       |
+| created  | datetime of creation              | datetime   | NO   |     | 0001-01-01 00:00:00 |       |
+| expires  | datetime of expiration            | datetime   | NO   |     | 0001-01-01 00:00:00 |       |
+
+Indexes
+------------
+
+| Name    | Fields                     |
+| ------- | -------------------------- |
+| PRIMARY | url_hash, guessing, oembed |
+| created | created                    |
+| expires | expires                    |
+
 
 Return to [database documentation](help/database)