Ferreteria/sql/user token: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': for storing tokens that authorize users to change things associated with an email address (mainly password) * '''History''': ** '''2013-10-03''' cre...") |
(No difference)
|
Revision as of 22:41, 3 October 2013
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>