Difference between revisions of "Database Table: cprod"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
Exor674Bot (Talk | contribs) (Robot: Updating: Format) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | This table supports the prodding feature not currently supported in Dreamwidth. | + | {{Database Table|name=cprod|table type=clustered|repo=dw-free}} |
| − | + | [[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, | |
| − | + | 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 | ||
) | ) | ||
</source> | </source> | ||
| − | + | {{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 )
