Difference between revisions of "Database Table: notifyarchive"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#set:name=notifyarchive|table type=clustered}}
+
{{Database Table|name=notifyarchive|table type=clustered|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE notifyarchive (
 
CREATE TABLE notifyarchive (
  userid    INT UNSIGNED NOT NULL,
+
    userid    INT UNSIGNED NOT NULL,
  qid        INT UNSIGNED NOT NULL,
+
    qid        INT UNSIGNED NOT NULL,
  createtime INT UNSIGNED NOT NULL,
+
    createtime 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),
+
    state      CHAR(1),
  PRIMARY KEY (userid, qid),
+
 
  INDEX      (userid, createtime)
+
    PRIMARY KEY (userid, qid),
 +
    INDEX      (userid, createtime)
 
)
 
)
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 16:01, 22 July 2010

This is a clustered table.

Definition

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

Relationships