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