Difference between revisions of "Database Table: userpicblob2"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Clustered. Stores the actual userpic blobs. Optionally a blob server can be used instead of storing them here in the database.
+
{{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.]]
  
 
Where non-mogile sites store userpics.
 
Where non-mogile sites store userpics.
 
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE userpicblob2 (
 
CREATE TABLE userpicblob2 (
  userid int unsigned not null,
+
    userid int unsigned not null,
  picid int unsigned not null,
+
    picid int unsigned not null,
  imagedata blob,
+
    imagedata blob,
  PRIMARY KEY (userid, picid)
+
 
 +
    PRIMARY KEY (userid, picid)
 
) max_rows=10000000
 
) max_rows=10000000
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Clustered database]]
+
 
+
[[Category: Database Tables|userpicblob2]]
+

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