Database Table: userpicblob2

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This is a clustered table. Clustered. Stores the actual userpic blobs. Optionally a blob server can be used instead of storing them here in the database.

Where non-mogile sites store userpics.

Definition

CREATE TABLE userpicblob2 (
    userid INT UNSIGNED NOT NULL,
    picid INT UNSIGNED NOT NULL,
    imagedata BLOB,
 
    PRIMARY KEY (userid, picid)
) max_rows=10000000

Relationships