Database Table: userblobcache

From Dreamwidth Notes
Revision as of 21:52, 11 May 2010 by Exor674 (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
)