authactions

authactions — When authenticating certain actions, the server generates an authaction along with some random characters (the authcode) and emails the aaid+authcode to the user to confirm they actually got it.

authactions

Column nameTypeNullDefaultDescription
aaidint unsigned auto_incrementPrimary key for each authaction.
useridint unsigned0Userid of user we're verifying.
datecreatedatetime0000-00-00 00:00:00Date the auth code was created.
authcodevarchar(20)YESRandom characters (the confirmation bit)
actionvarchar(50)YESThe action command name to be run when the authaction is confirmed (clicked/etc)
arg1varchar(255)YESOptional argument to accompany the action.
usedenum('Y','N')YESN
Key nameTypeColumn(s)
PRIMARYPRIMARY
datecreateINDEX
useridINDEX