Difference between revisions of "Database Table: userblob"

From Dreamwidth Notes
Jump to: navigation, search
(New page: Ancient system for storing userpics. userblob)
 
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Ancient system for storing userpics.
+
{{Database Table|name=userblob|table type=clustered|repo=dw-free}}
 +
[[description::Ancient system for storing userpics. Used if MogileFS or BlobCache is not being run.]]
 +
= Definition =
 +
<source lang="sql">
 +
CREATE TABLE userblob (
 +
    journalid  INT      UNSIGNED NOT NULL,
 +
    domain      TINYINT  UNSIGNED NOT NULL,
 +
    blobid      MEDIUMINT UNSIGNED NOT NULL,
 +
    length      MEDIUMINT UNSIGNED,
  
[[Category: Obsolete Database Tables|userblob]]
+
    PRIMARY KEY (journalid, domain, blobid),
 +
    KEY (domain)
 +
)
 +
</source>
 +
{{Database Table Footer}}

Latest revision as of 07:09, 9 February 2017

This is a clustered table. Ancient system for storing userpics. Used if MogileFS or BlobCache is not being run.

Definition

CREATE TABLE userblob (
    journalid   INT       UNSIGNED NOT NULL,
    DOMAIN      TINYINT   UNSIGNED NOT NULL,
    blobid      MEDIUMINT UNSIGNED NOT NULL,
    LENGTH      MEDIUMINT UNSIGNED,
 
    PRIMARY KEY (journalid, DOMAIN, blobid),
    KEY (DOMAIN)
)

Relationships