Database Table: userblob
From Dreamwidth Notes
Revision as of 07:09, 9 February 2017 by AzureLunaticDW (Talk | contribs)
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) )