Difference between revisions of "Database Table: userpicblob2"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 20: Line 20:
 
[[Clustered database]]
 
[[Clustered database]]
  
[[Category: Database Tables|userpicblob2]]
+
[[Category:Database Tables Needing Conversion|userpicblob2]]

Revision as of 14:06, 2 October 2009

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

Location

Clustered database