Difference between revisions of "Database Table: cprod"
From Dreamwidth Notes
(Created page with 'This table supports the prodding feature not currently supported in Dreamwidth. cprod =Definition= <source lang="sql"> CREATE TABLE cprod ( userid...') |
Dreamnestia (Talk | contribs) |
||
| Line 1: | Line 1: | ||
This table supports the prodding feature not currently supported in Dreamwidth. | 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 ( | ||
| Line 17: | Line 17: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
Foreign key userid to [[Database Table: user|user]].userid | Foreign key userid to [[Database Table: user|user]].userid | ||
| − | =Location= | + | = Location = |
| + | |||
[[Clustered database]] | [[Clustered database]] | ||
| + | |||
| + | [[Category: Database Tables|cprod]] | ||
Revision as of 11:16, 31 March 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
