Difference between revisions of "Database Table: userpicblob2"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
|||
| Line 3: | Line 3: | ||
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 ( | ||
| Line 15: | Line 14: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
| + | = Location = | ||
| − | |||
[[Clustered database]] | [[Clustered database]] | ||
| + | |||
| + | [[Category: Database Tables|userpicblob2]] | ||
Revision as of 10:22, 4 April 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
