* License, v. 2.0. If a copy of the MPL was not distributed with this file,
* You can obtain one at http://mozilla.org/MPL/2.0/. */
+/*
+ Some resources for how to store passwords:
+ - https://blog.mozilla.org/webdev/2012/06/08/lets-talk-about-password-storage/
+ - https://wiki.mozilla.org/WebAppSec/Secure_Coding_Guidelines
+ oauth-server-php: https://bshaffer.github.io/oauth2-server-php-docs/cookbook
+*/
+
// error reporting (for testing)
ini_set('display_errors', 1); error_reporting(E_ALL);
`logged_in` BOOLEAN NOT NULL DEFAULT FALSE ,
`time_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`time_expire` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
+ `saved_redirect` VARCHAR(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`),
INDEX (`sesskey`),
INDEX (`time_expire`)
`pwdhash` VARCHAR(255) NOT NULL ,
`status` ENUM('unverified','ok') NOT NULL DEFAULT 'unverified' ,
`verify_hash` VARCHAR(150) NULL DEFAULT NULL ,
+ `group_id` MEDIUMINT UNSIGNED DEFAULT '0' ,
PRIMARY KEY (`id`),
UNIQUE (`email`)
);