acctcode

acctcode — Keeps track of valid invite codes and who has used them. To see why they were made, see table acctinvite.

acctcode

Column nameTypeNullDefaultDescription
acidint unsigned auto_incrementAccount code ID. Primary key.
useridint unsigned0Userid that can give this code.
rcptidint unsigned0Userid of recipient, or 0 if code is unused.
authchar(5)Five randomly generated bytes. This, along with the acid encoded, make up the invite code.
Key nameTypeColumn(s)
PRIMARYPRIMARY
rcptidINDEX
useridINDEX