Database Table: userblobcache

From Dreamwidth Notes
Revision as of 16:20, 22 July 2010 by Exor674 (Talk | contribs)

Jump to: navigation, search

Note: This table is removed and no longer used. This table was removed in dw-free changeset 1198e89d8511 [1]
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
)