Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
user_id | INT UNSIGNED | 10 | null |
|
|
|||||
token | CHAR | 36 | null |
|
|
Unique token the user will provide to verify the requested action. |
||||
type | enum('RESET_PASSWORD', 'ACTIVATE_ACCOUNT', 'DELETE_EDITION', 'EDITOR_INVITE') | 16 | 'RESET_PASSWORD' |
|
|
The type of action permitted with the specified token. |
||||
date_created | DATETIME | 19 | current_timestamp() |
|
|
Date the token was created or updated. This is used by an event that clears out all entries from this table that are older than 2 days. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | token |
date_created_index | Performance | Asc | date_created |
fk_user_email_token_to_user | Performance | Asc | user_id |