Difference between revisions of "Database Table: userpicblob2"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating page description status.)
(Robot: Updating: Format)
 
(One intermediate revision by the same user not shown)
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.]]
  
 
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}}
 
{{Database Table Footer}}

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