Difference between revisions of "Database Table: userblobcache"

From Dreamwidth Notes
Jump to: navigation, search
(deleted userblobcache - bug 1711)
Line 1: Line 1:
{{Database Table|name=userblobcache|table type=clustered}}
+
 
[[description::Ancient system for storing userpics.  Used if MogileFS is not being run]]
+
= Definition =
+
<source lang="sql">
+
CREATE TABLE userblobcache (
+
    userid    INT UNSIGNED NOT NULL,
+
    bckey      VARCHAR(60) NOT NULL,
+
    PRIMARY KEY (userid, bckey),
+
    timeexpire  INT UNSIGNED NOT NULL,
+
    INDEX (timeexpire),
+
    value    MEDIUMBLOB
+
)
+
</source>
+
{{Database Table Footer}}
+

Revision as of 19:01, 22 April 2010