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.
| 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 |