Ferreteria/sql/user token

About

• Purpose: for storing tokens that authorize users to change things associated with an email address (mainly password)
• History:
  • 2013-10-03 created

SQL

<mysql>CREATE TABLE `user_tokens` (

 `ID_Email`             INT NOT NULL COMMENT "ID of email address being authorized",
 `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_Email`)

) ENGINE = MYISAM;</mysql>