Database Table: userblob

From Dreamwidth Notes
Revision as of 07:09, 9 February 2017 by AzureLunaticDW (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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