Database Table: cprod

From Dreamwidth Notes
Revision as of 07:05, 21 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Foreign key userid to user.userid

Location

Clustered database