Category added

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

diff --git a/doc/database/db_oembed.md b/doc/database/db_oembed.md
index 651a52e740fe6776eee98e6a7cdea37cf6da6457..bdcbbcc2bfc53ab406fd56e8025a80ca350d4504 100644 (file)
--- a/doc/database/db_oembed.md
+++ b/doc/database/db_oembed.md
@@ -1,11 +1,25 @@
 Table oembed
-============
-
-| Field        | Description                        | Type         | Null | Key | Default             | Extra |
-| ------------ | ---------------------------------- | ------------ | ---- | --- | ------------------- | ----- |
-| url          | page url                           | varchar(255) | NO   | PRI | NULL                |       |
-| maxwidth     | Maximum width passed to Oembed     | int(11)      | NO   | PRI | 0                   |       |
-| content      | OEmbed data of the page            | text         | NO   |     | NULL                |       |
-| created      | datetime of creation               | datetime     | NO   | MUL | 0001-01-01 00:00:00 |       |
+===========
+
+cache for OEmbed queries
+
+Fields
+------
+
+| Field    | Description                    | Type               | Null | Key | Default             | Extra |
+| -------- | ------------------------------ | ------------------ | ---- | --- | ------------------- | ----- |
+| url      | page url                       | varbinary(383)     | NO   | PRI | NULL                |       |
+| maxwidth | Maximum width passed to Oembed | mediumint unsigned | NO   | PRI | NULL                |       |
+| content  | OEmbed data of the page        | mediumtext         | YES  |     | NULL                |       |
+| created  | datetime of creation           | datetime           | NO   |     | 0001-01-01 00:00:00 |       |
+
+Indexes
+------------
+
+| Name    | Fields        |
+| ------- | ------------- |
+| PRIMARY | url, maxwidth |
+| created | created       |
+
 
 Return to [database documentation](help/database)