Difference between revisions of "Database Table: has subs"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format, needs desc, definition)
(Robot: Updating: Format)
 
Line 1: Line 1:
{{Database Table|name=has_subs|table type=clustered|need desc=1}}
+
{{Database Table|name=has_subs|table type=clustered|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">

Latest revision as of 15:58, 22 July 2010

This is a clustered table.

Definition

CREATE TABLE has_subs (
    journalid  INT UNSIGNED NOT NULL,
    etypeid    INT UNSIGNED NOT NULL,
    arg1       INT UNSIGNED NOT NULL,
    arg2       INT UNSIGNED NOT NULL,
    PRIMARY KEY (journalid, etypeid, arg1, arg2),
    verifytime   INT UNSIGNED NOT NULL
)

Relationships