Difference between revisions of "Database Table: acctcode"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Robot: This table needs a description.) |
Exor674Bot (Talk | contribs) (Robot: Updating: Format, needs desc, definition) |
||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=acctcode|table type=global}} | + | {{Database Table|name=acctcode|table type=global|need desc=1}} |
| − | + | ||
= Definition = | = Definition = | ||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
| − | CREATE TABLE acctcode | + | CREATE TABLE acctcode ( |
| − | ( | + | acid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, |
| − | + | userid INT UNSIGNED NOT NULL, | |
| − | + | rcptid INT UNSIGNED NOT NULL DEFAULT 0, | |
| − | + | auth CHAR(13) NOT NULL, | |
| − | + | timegenerate INT UNSIGNED NOT NULL, | |
| − | INDEX (userid), | + | timesent INT UNSIGNED, |
| − | + | email VARCHAR(255), | |
| + | reason VARCHAR(255), | ||
| + | |||
| + | INDEX (userid), | ||
| + | INDEX (rcptid) | ||
) | ) | ||
</source> | </source> | ||
{{Database Table Footer}} | {{Database Table Footer}} | ||
Revision as of 06:58, 28 January 2010
"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global table.
Definition
CREATE TABLE acctcode ( acid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, userid INT UNSIGNED NOT NULL, rcptid INT UNSIGNED NOT NULL DEFAULT 0, auth CHAR(13) NOT NULL, timegenerate INT UNSIGNED NOT NULL, timesent INT UNSIGNED, email VARCHAR(255), reason VARCHAR(255), INDEX (userid), INDEX (rcptid) )
Relationships
Outgoing
- Foreign key: userid to user.userid
