Ferreteria/sql/user token

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 22:57, 3 October 2013 by htyp>Woozle (syntax fix)
Jump to navigation Jump to search

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

) ENGINE = MYISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/user_token&oldid=1817"