View | Details | Raw Unified | Return to bug 8753
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-6 / +6 lines)
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 */;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 7330-7335 if ( CheckVersion($DBversion) ) { Link Here
7330
    SetVersion($DBversion);
7330
    SetVersion($DBversion);
7331
}
7331
}
7332
7332
7333
$DBversion = "3.13.00.XXX";
7334
if ( CheckVersion($DBversion) ) {
7335
    $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('OpacResetPassword','1','','Shows the ''Forgot your password?'' link in the OPAC','YesNo')"); 
7336
    $dbh->do(q{
7337
        CREATE TABLE IF NOT EXISTS borrower_password_recovery (
7338
          borrowernumber int(11) NOT NULL,
7339
          uuid varchar(128) NOT NULL,
7340
          valid_until timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
7341
          KEY borrowernumber (borrowernumber)
7342
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
7343
    });
7344
    print "Upgrade to $DBversion done (Bug 8753: Add forgot password link to OPAC)\n";
7345
    SetVersion ($DBversion);
7346
}
7347
7333
=head1 FUNCTIONS
7348
=head1 FUNCTIONS
7334
7349
7335
=head2 TableExists($table)
7350
=head2 TableExists($table)
7336
- 

Return to bug 8753