]> git.mxchange.org Git - friendica.git/blobdiff - doc/database/db_cache.md
Merge pull request #10797 from annando/diaspora-deprecated
[friendica.git] / doc / database / db_cache.md
index 42a2045e110727415991abd1c600ec184eac2bc8..27a11daa66c7dbe8af06a5ae292b7ec2ff6d5aac 100644 (file)
@@ -1,12 +1,25 @@
 Table cache
 ===========
+
 Stores temporary data
 
-| Field   | Description                  | Type           | Null | Key | Default             | Extra |    
-| ------- | ---------------------------- | -------------- | ---- | --- | ------------------- | ----- |    
-| k       | cache key                    | varbinary(255) | NO   | PRI | NULL                |       |    
-| v       | cached serialized value      | mediumtext     | YES  |     | NULL                |       |    
-| expires | datetime of cache expiration | datetime       | NO   |     | 0001-01-01 00:00:00 |       |    
-| updated | datetime of cache insertion  | datetime       | NO   |     | 0001-01-01 00:00:00 |       |    
+Fields
+------
+
+| Field   | Description                  | Type           | Null | Key | Default             | Extra |
+| ------- | ---------------------------- | -------------- | ---- | --- | ------------------- | ----- |
+| k       | cache key                    | varbinary(255) | NO   | PRI | NULL                |       |
+| v       | cached serialized value      | mediumtext     | YES  |     | NULL                |       |
+| expires | datetime of cache expiration | datetime       | NO   |     | 0001-01-01 00:00:00 |       |
+| updated | datetime of cache insertion  | datetime       | NO   |     | 0001-01-01 00:00:00 |       |
+
+Indexes
+------------
+
+| Name      | Fields     |
+| --------- | ---------- |
+| PRIMARY   | k          |
+| k_expires | k, expires |
+
 
 Return to [database documentation](help/database)