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 "ID of email address being authorized",
 `Token`   VARCHAR(128) NOT NULL "token string",
 `WhenExp`     DATETIME NOT NULL "when the token expires (and should be deleted)",
 PRIMARY KEY(`ID_Email`)

) ENGINE = MYISAM;</mysql>