Database Table: userblobcache

From Dreamwidth Notes
Revision as of 15:56, 22 July 2010 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

Note: This table is removed and no longer used.
This is a global table. Ancient system for storing userpics. Used if MogileFS is not being run

Definition

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
)