Difference between revisions of "Database Table: userpicblob2"
From Dreamwidth Notes
Foxfirefey (Talk | contribs) m (added to database tables category) |
|||
| Line 4: | Line 4: | ||
[[Category: Database Tables|userpicblob2]] | [[Category: Database Tables|userpicblob2]] | ||
| + | [[Category: Database Table|userpicblob2]] | ||
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | CREATE TABLE userpicblob2 ( | ||
| + | userid int unsigned not null, | ||
| + | picid int unsigned not null, | ||
| + | imagedata blob, | ||
| + | PRIMARY KEY (userid, picid) | ||
| + | ) max_rows=10000000 | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
| + | [[Clustered database]] | ||
Revision as of 18:23, 22 March 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
