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