acctcode — Keeps track of valid invite codes and who has used them. To see why they were made, see table acctinvite.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| acid | int unsigned auto_increment | Account code ID. Primary key. | ||
| userid | int unsigned | 0 | Userid that can give this code. | |
| rcptid | int unsigned | 0 | Userid of recipient, or 0 if code is unused. | |
| auth | char(5) | Five randomly generated bytes. This, along with the acid encoded, make up the invite code. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| rcptid | INDEX | |
| userid | INDEX |