Difference between revisions of "Database Table: cprod"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
Line 25: | Line 25: | ||
[[Clustered database]] | [[Clustered database]] | ||
− | [[Category: Database Tables|cprod]] | + | [[Category:Database Tables Needing Conversion|cprod]] |
Revision as of 14:01, 2 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
Foreign key userid to user.userid