Difference between revisions of "Database Table: cprod"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#set:name=cprod|table type=clustered}}
+
{{Database Table|name=cprod|table type=clustered|repo=dw-free}}
 
[[Description::This table supports the prodding feature not currently supported in Dreamwidth.]]
 
[[Description::This table supports the prodding feature not currently supported in Dreamwidth.]]
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE cprod (
 
CREATE TABLE cprod (
  userid    INT      UNSIGNED NOT NULL,
+
    userid    INT      UNSIGNED NOT NULL,
  cprodid  SMALLINT UNSIGNED NOT NULL,
+
    cprodid  SMALLINT UNSIGNED NOT NULL,
  PRIMARY KEY (userid, cprodid),
+
    PRIMARY KEY (userid, cprodid),
  firstshowtime      INT UNSIGNED,
+
 
  recentshowtime    INT UNSIGNED,
+
    firstshowtime      INT UNSIGNED,
  acktime            INT UNSIGNED,
+
    recentshowtime    INT UNSIGNED,
  nothankstime      INT UNSIGNED,
+
    acktime            INT UNSIGNED,
  clickthrutime      INT UNSIGNED,
+
    nothankstime      INT UNSIGNED,
  clickthruver      SMALLINT UNSIGNED
+
    clickthrutime      INT UNSIGNED,
 +
    clickthruver      SMALLINT UNSIGNED
 
)
 
)
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 15:56, 22 July 2010

This is a clustered table. This table supports the prodding feature not currently supported in Dreamwidth.

Definition

CREATE TABLE cprod (
    userid    INT      UNSIGNED NOT NULL,
    cprodid   SMALLINT UNSIGNED NOT NULL,
    PRIMARY KEY (userid, cprodid),
 
    firstshowtime      INT UNSIGNED,
    recentshowtime     INT UNSIGNED,
    acktime            INT UNSIGNED,
    nothankstime       INT UNSIGNED,
    clickthrutime      INT UNSIGNED,
    clickthruver       SMALLINT UNSIGNED
)

Relationships

Outgoing

  • Foreign key: cprodid to cprodlist.cprodid
  • Foreign key: userid to user.userid