Added default value "NULL"

[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 ada42c2ea621505accf89e1ee1bee3d3eca864f3..bf4b7117f59f3d950fe060f9fc24b7eb05e6422e 100644 (file)
--- a/doc/database/db_parsed_url.md
+++ b/doc/database/db_parsed_url.md
@@ -1,12 +1,15 @@
 Table parsed_url
-================
+===========
+cache for 'parse_url' queries
 
-| Field        | Description                        | Type         | Null | Key | Default             | Extra |
-| ------------ | ---------------------------------- | ------------ | ---- | --- | ------------------- | ----- |
-| url          | page url                           | varchar(255) | NO   | PRI | NULL                |       |
-| guessing     | is the "guessing" mode active?     | tinyint(1)   | NO   | PRI | 0                   |       |
-| oembed       | is the data the result of oembed?  | tinyint(1)   | NO   | PRI | 0                   |       |
-| content      | page data                          | text         | NO   |     | NULL                |       |
-| created      | datetime of creation               | datetime     | NO   | MUL | 0000-00-00 00:00:00 |       |
+| Field | Description | Type | Null | Key | Default | Extra |
+| ----- | ----------- | ---- | ---- | --- | ------- | ----- |
+| url_hash | page url hash | binary(64) | YES | PRI | NULL |  |    
+| guessing | is the 'guessing' mode active? | boolean | YES | PRI | 0 |  |    
+| oembed | is the data the result of oembed? | boolean | YES | PRI | 0 |  |    
+| url | page url | text | YES |  | NULL |  |    
+| content | page data | mediumtext | NO |  | NULL |  |    
+| created | datetime of creation | datetime | YES |  | 0001-01-01 00:00:00 |  |    
+| expires | datetime of expiration | datetime | YES |  | 0001-01-01 00:00:00 |  |    
 
 Return to [database documentation](help/database)