Difference between revisions of "Database Table: notifyqueue"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{Database Table|name=notifyqueue|table type=clustered|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE notifyqueue (
 
CREATE TABLE notifyqueue (
  userid    INT UNSIGNED NOT NULL,
+
    userid    INT UNSIGNED NOT NULL,
  qid        INT UNSIGNED NOT NULL,
+
    qid        INT UNSIGNED NOT NULL,
  journalid  INT UNSIGNED NOT NULL,
+
    journalid  INT UNSIGNED NOT NULL,
  etypeid    SMALLINT UNSIGNED NOT NULL,
+
    etypeid    SMALLINT UNSIGNED NOT NULL,
  arg1      INT UNSIGNED,
+
    arg1      INT UNSIGNED,
  arg2      INT UNSIGNED,
+
    arg2      INT UNSIGNED,
  state      CHAR(1) NOT NULL DEFAULT 'N',
+
  createtime INT UNSIGNED NOT NULL,
+
  PRIMARY KEY (userid, qid),
+
  INDEX      (state)
+
)
+
</source>
+
  
= Relationships =
+
    state      CHAR(1) NOT NULL DEFAULT 'N',
  
= Location =
+
    createtime INT UNSIGNED NOT NULL,
  
[[Clustered database]]
+
    PRIMARY KEY (userid, qid),
 
+
    INDEX      (state)
[[Category: Database Tables|notifyqueue]]
+
)
 +
</source>
 +
{{Database Table Footer}}

Latest revision as of 15:56, 22 July 2010

This is a clustered table.

Definition

CREATE TABLE notifyqueue (
    userid     INT UNSIGNED NOT NULL,
    qid        INT UNSIGNED NOT NULL,
    journalid  INT UNSIGNED NOT NULL,
    etypeid    SMALLINT UNSIGNED NOT NULL,
    arg1       INT UNSIGNED,
    arg2       INT UNSIGNED,
 
    state      CHAR(1) NOT NULL DEFAULT 'N',
 
    createtime INT UNSIGNED NOT NULL,
 
    PRIMARY KEY (userid, qid),
    INDEX       (state)
)

Relationships