dApPd1z6

1CREATE TABLE IF NOT EXISTS `resetpasswordtokens` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `userID` int(11) NOT NULL,
4  `token` char(32) NOT NULL,
5  `status` set('used','new') NOT NULL DEFAULT 'new',
6  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7  PRIMARY KEY (`id`),
8  KEY `userID` (`userID`)
9) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;