Database Table: userblob

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

Jump to: navigation, search

This is a clustered table. Ancient system for storing userpics. Used if MogileFS is not being run.

Definition

CREATE TABLE userblob (
    journalid   INT       UNSIGNED NOT NULL,
    DOMAIN      TINYINT   UNSIGNED NOT NULL,
    blobid      MEDIUMINT UNSIGNED NOT NULL,
    LENGTH      MEDIUMINT UNSIGNED,
 
    PRIMARY KEY (journalid, DOMAIN, blobid),
    KEY (DOMAIN)
)

Relationships