Difference between revisions of "Database Table: acctcode"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Create page for new table acctcode) |
(Undo revision 10958 by Exor674Bot (talk)) |
||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=acctcode|table type=global | + | {{Database Table|name=acctcode|table type=global|repo=dw-free}} |
| + | [[Description::This table stores data on valid invite codes and who has used them.]] The [[Database Table:acctinvite|acctinvite]] table stores the data on why they were made. | ||
= Definition = | = Definition = | ||
<source lang="sql"> | <source lang="sql"> | ||
Latest revision as of 23:07, 28 November 2012
This is a global table. This table stores data on valid invite codes and who has used them. The acctinvite table stores the data on why they were made.
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
