Database Table: userblob

From Dreamwidth Notes
Jump to: navigation, search

This is a clustered table. Ancient system for storing userpics. Used if MogileFS or BlobCache 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