Lines 3280-3291
ALTER TABLE `patron_list_patrons`
Link Here
|
3280 |
-- this stores the unique ID sent by email to the patron, for future validation |
3280 |
-- this stores the unique ID sent by email to the patron, for future validation |
3281 |
-- |
3281 |
-- |
3282 |
|
3282 |
|
3283 |
CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( |
3283 |
CREATE TABLE IF NOT EXISTS borrower_password_recovery ( |
3284 |
`borrowernumber` int(11) NOT NULL, |
3284 |
borrowernumber int(11) NOT NULL, |
3285 |
`uuid` varchar(128) NOT NULL, |
3285 |
uuid varchar(128) NOT NULL, |
3286 |
`valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
3286 |
valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
3287 |
KEY `borrowernumber` (`borrowernumber`) |
3287 |
KEY borrowernumber (borrowernumber) |
3288 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
3288 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3289 |
|
3289 |
|
3290 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3290 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3291 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3291 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |