Ferreteria/sql/user token: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
No edit summary |
m (Woozle moved page VbzCart/tables/user tokens to Ferreteria/sql/user token without leaving a redirect: this is actually a ferreteria table) |
(No difference)
| |
Revision as of 00:19, 27 January 2017
About
- Purpose: for storing tokens that authorize users to change things associated with an email address (mainly password)
Fields
- Type: type of action being authorized (currently: 1 = create new account, 2 = reset password)
- Entity: value referring to entity being authorized (email address, user ID)
History
- 2013-10-03 created
- 2013-12-24 changed to no longer require a pre-existing email address (using SQL adapted for ATC but never used)
- 2016-11-17 revised to allow for different auth types; removed unique key requirement
SQL
<mysql>CREATE TABLE `user_tokens` (
`ID` INT NOT NULL AUTO_INCREMENT, `Type` INT NOT NULL COMMENT "type of action being authorized", `Entity` VARCHAR(256) NOT NULL COMMENT "value of entity being authorized (username, email address)", `TokenHash` VARBINARY(128) NOT NULL COMMENT "hash for [token+salt]", `TokenSalt` VARBINARY(128) NOT NULL COMMENT "random prefix for hash", `WhenExp` DATETIME NOT NULL COMMENT "when the token expires (and should be deleted)", PRIMARY KEY(`ID`)
) ENGINE = InnoDB;</mysql>