X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doc%2Fdatabase%2Fdb_cache.md;h=27a11daa66c7dbe8af06a5ae292b7ec2ff6d5aac;hb=19603fd6a57c9de0015efe93f019ae6d6204259d;hp=3675474a5ab7b74bccd24477ad6e4f5c23ed3909;hpb=07faa14361f46b744e4b135d161ad491baa93809;p=friendica.git diff --git a/doc/database/db_cache.md b/doc/database/db_cache.md index 3675474a5a..27a11daa66 100644 --- a/doc/database/db_cache.md +++ b/doc/database/db_cache.md @@ -1,11 +1,25 @@ Table cache =========== -| Field | Description | Type | Null | Key | Default | Extra | -| ------------ | ---------------------------------- | ------------ | ---- | --- | ------------------- | ----- | -| k | horizontal width + url or resource | varchar(255) | NO | PRI | NULL | | -| v | OEmbed response from site | text | NO | | NULL | | -| updated | datetime of cache insertion | datetime | NO | MUL | 0001-01-01 00:00:00 | | -| expire_mode | | int(11) | NO | | 0 | | +Stores temporary data + +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)