· 10 years ago · Sep 16, 2016, 07:06 AM
1
2CREATE TABLE IF NOT EXISTS `user_recover_token` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `user_id` int(11) NOT NULL,
5 `token` varchar(100) NOT NULL,
6 `expiration_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
7 PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;