Difference between revisions of "Database Table: cprod"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 1: Line 1:
This table supports the prodding feature not currently supported in Dreamwidth.
+
{{#set:name=cprod|table type=clustered}}
 
+
[[Description::This table supports the prodding feature not currently supported in Dreamwidth.]]
 
= Definition =
 
= Definition =
  
Line 16: Line 16:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
Foreign key userid to [[Database Table: user|user]].userid
+
 
+
= Location =
+
 
+
[[Clustered database]]
+
 
+
[[Category:Database Tables Needing Conversion|cprod]]
+

Revision as of 18:56, 5 October 2009

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