From d543946a37df7cc708935a6982777b38afb58f08 Mon Sep 17 00:00:00 2001 From: Charles Farmer Date: Mon, 30 Nov 2015 09:20:57 -0500 Subject: [PATCH] Bug 8753 - propagating the changes to kohastructure.sql and sysprefs.sql Signed-off-by: Liz Rea Looks good with a new install. --- installer/data/mysql/kohastructure.sql | 12 ++++++++++++ installer/data/mysql/sysprefs.sql | 1 + 2 files changed, 13 insertions(+) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 431a541..3975f28 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -357,6 +357,18 @@ CREATE TABLE `branch_item_rules` ( -- information entered in the circulation and ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- +-- Table structure for table `borrower_password_recovery` +-- + +DROP TABLE IF EXISTS `borrower_password_recovery`; +CREATE TABLE IF NOT EXISTS `borrower_password_recovery` ( -- holds information about password recovery attempts + `borrowernumber` int(11) NOT NULL, -- the user asking a password recovery + `uuid` varchar(128) NOT NULL, -- a unique string to identify a password recovery attempt + `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- a time limit on the password recovery attempt + KEY borrowernumber (borrowernumber) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 + +-- -- Table structure for table borrower_sync -- diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index aa53139..96ea9ad 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -317,6 +317,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('opacreadinghistory','1','','If ON, enables display of Patron Circulation History in OPAC','YesNo'), ('OpacRenewalAllowed','0',NULL,'If ON, users can renew their issues directly from their OPAC account','YesNo'), ('OpacRenewalBranch','checkoutbranch','itemhomebranch|patronhomebranch|checkoutbranch|null','Choose how the branch for an OPAC renewal is recorded in statistics','Choice'), +('OpacResetPassword','0','','Shows the ''Forgot your password?'' link in the OPAC','YesNo'), ('OPACResultsSidebar','','70|10','Define HTML to be included on the search results page, underneath the facets sidebar','Textarea'), ('OPACSearchForTitleIn','
  • Other Libraries (WorldCat)
  • \n
  • Other Databases (Google Scholar)
  • \n
  • Online Stores (Bookfinder.com)
  • \n
  • Open Library (openlibrary.org)
  • ','70|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'), ('OpacSeparateHoldings','0',NULL,'Separate current branch holdings from other holdings (OPAC)','YesNo'), -- 1.9.1