USE Houdini;


CREATE TABLE `reset_pass` (
  `PenguinID` int(10) unsigned NOT NULL COMMENT 'Penguins ID based on email given',
  `ResetID` char(255) NOT NULL COMMENT 'Unique ID in email reset link',
  `Expires` datetime NOT NULL DEFAULT current_timestamp() COMMENT 'Expiry date',
  PRIMARY KEY (`PenguinID`,`ResetID`),
  CONSTRAINT `reset_pass_ibfk_1` FOREIGN KEY (`PenguinID`) REFERENCES `penguin` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Reset password';