authactions

authactions — Global. Stores shared secret (authaction ID + authcode pair) data. When authenticating certain actions, the server generates an authaction along with some random characters (the authcode) and e-mails the aaid+authcode to the user to confirm they actually got it.

authactions

Column name Type Null Default Description
aaid int unsigned auto_increment   Primary key for each authaction.
userid int unsigned   0 Userid of user we're verifying.
datecreate datetime   0000-00-00 00:00:00 Date the auth code was created.
authcode varchar(20) YES Random characters (the confirmation bit)
action varchar(50) YES The action command name to be run when the authaction is confirmed (clicked/etc)
arg1 varchar(255) YES Optional argument to accompany the action.
used enum('Y','N') YES N  
Key name Type Column(s)
PRIMARY PRIMARY
datecreate INDEX
userid INDEX