Difference between revisions of "Database Table: userpicblob2"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format, definition)
(Robot: Updating: Format)
 
Line 1: Line 1:
{{Database Table|name=userpicblob2|table type=clustered}}
+
{{Database Table|name=userpicblob2|table type=clustered|repo=dw-free}}
 
Clustered. [[Description::Stores the actual userpic blobs. Optionally a blob server can be used instead of storing them here in the database.]]
 
Clustered. [[Description::Stores the actual userpic blobs. Optionally a blob server can be used instead of storing them here in the database.]]
  

Latest revision as of 15:57, 22 July 2010

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