Difference between revisions of "Database Table: subs"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use database table header template.)
(Robot: Updating: Format)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Database Table|name=subs|table type=clustered}}
+
{{Database Table|name=subs|table type=clustered|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE subs (
 
CREATE TABLE subs (
  userid  INT UNSIGNED NOT NULL,
+
    userid  INT UNSIGNED NOT NULL,
  subid    INT UNSIGNED NOT NULL,
+
    subid    INT UNSIGNED NOT NULL,
          PRIMARY KEY (userid, subid),
+
    PRIMARY KEY (userid, subid),
  
  is_dirty  TINYINT UNSIGNED NULL,
+
    is_dirty  TINYINT UNSIGNED NULL,
            INDEX (is_dirty),
+
    INDEX (is_dirty),
  
  journalid  INT UNSIGNED NOT NULL,
+
    journalid  INT UNSIGNED NOT NULL,
  etypeid    SMALLINT UNSIGNED NOT NULL,
+
    etypeid    SMALLINT UNSIGNED NOT NULL,
  arg1      INT UNSIGNED NOT NULL,
+
    arg1      INT UNSIGNED NOT NULL,
  arg2      INT UNSIGNED NOT NULL,
+
    arg2      INT UNSIGNED NOT NULL,
  
  ntypeid    SMALLINT UNSIGNED NOT NULL,
+
    ntypeid    SMALLINT UNSIGNED NOT NULL,
  
  createtime INT UNSIGNED NOT NULL,
+
    createtime INT UNSIGNED NOT NULL,
  expiretime INT UNSIGNED NOT NULL,
+
    expiretime INT UNSIGNED NOT NULL,
  flags      SMALLINT UNSIGNED NOT NULL
+
    flags      SMALLINT UNSIGNED NOT NULL
 
)
 
)
 
</source>
 
</source>
 
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 15:59, 22 July 2010

This is a clustered table.

Definition

CREATE TABLE subs (
    userid   INT UNSIGNED NOT NULL,
    subid    INT UNSIGNED NOT NULL,
    PRIMARY KEY (userid, subid),
 
    is_dirty   TINYINT UNSIGNED NULL,
    INDEX (is_dirty),
 
    journalid  INT UNSIGNED NOT NULL,
    etypeid    SMALLINT UNSIGNED NOT NULL,
    arg1       INT UNSIGNED NOT NULL,
    arg2       INT UNSIGNED NOT NULL,
 
    ntypeid    SMALLINT UNSIGNED NOT NULL,
 
    createtime INT UNSIGNED NOT NULL,
    expiretime INT UNSIGNED NOT NULL,
    flags      SMALLINT UNSIGNED NOT NULL
)

Relationships