Database Table: userpicblob2

From Dreamwidth Notes
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