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

(-)a/installer/data/mysql/kohastructure.sql (+12 lines)
Lines 3231-3236 CREATE TABLE IF NOT EXISTS plugin_data ( Link Here
3231
  PRIMARY KEY (plugin_class,plugin_key)
3231
  PRIMARY KEY (plugin_class,plugin_key)
3232
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3232
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3233
3233
3234
--
3235
-- Table structure for table 'borrower_password_recovery'
3236
-- this stores the unique ID sent by email to the patron, for future validation
3237
--
3238
3239
CREATE TABLE IF NOT EXISTS `borrower_password_recovery` (
3240
  `borrowernumber` int(11) NOT NULL,
3241
  `uuid` varchar(128) NOT NULL,
3242
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3243
  KEY `borrowernumber` (`borrowernumber`)
3244
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
3245
3234
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3246
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3235
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3247
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3236
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3248
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +2 lines)
Lines 418-422 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
418
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
418
('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'),
419
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
419
('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'),
420
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
420
('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'),
421
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo')
421
('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'),
422
('OpacResetPassword','1','','Shows the \'Forgot your password?\' link in the OPAC','YesNo')
422
;
423
;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7155-7160 if ( CheckVersion($DBversion) ) { Link Here
7155
    SetVersion($DBversion);
7155
    SetVersion($DBversion);
7156
}
7156
}
7157
7157
7158
$DBversion = "3.13.00.XXX";
7159
if ( CheckVersion($DBversion) ) {
7160
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
7161
VALUES('OpacResetPassword','1','Shows the \'Forgot your password?\' link in the OPAC','','YesNo');");
7162
    print "Upgrade to $DBversion done (Bug 8753:  Add forgot password link to OPAC)\n";
7163
    SetVersion($DBversion);
7164
}
7165
7158
=head1 FUNCTIONS
7166
=head1 FUNCTIONS
7159
7167
7160
=head2 TableExists($table)
7168
=head2 TableExists($table)
7161
- 

Return to bug 8753