acctcode

acctcode — Stores data on valid invite codes and who has used them. The acctinvite table stores the data on why they were made.

acctcode

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