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

(-)a/installer/data/mysql/atomicupdate/bug_21082-add_option_for_overdrive_patron_auth.perl (+16 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do('DROP TABLE IF EXISTS branches_overdrive');
4
    $dbh->do( q|
5
        CREATE TABLE IF NOT EXISTS branches_overdrive (
6
            `branchcode` VARCHAR( 10 ) NOT NULL ,
7
            `authname` VARCHAR( 255 ) NOT NULL ,
8
            PRIMARY KEY (`branchcode`) ,
9
            CONSTRAINT `branches_overdrive_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
10
        ) ENGINE = INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |);
11
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDriveAuthname', '', 'Authname for OverDrive Patron Authentication, will be used as fallback if individual branch authname not set', NULL, 'Free');");
12
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDriveWebsiteID','', 'WebsiteID provided by OverDrive', NULL, 'Free');");
13
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('OverDrivePasswordRequired','', 'Does the library require passwords for OverDrive SIP authentication', NULL, 'Free');");
14
    SetVersion( $DBversion );
15
    print "Upgrade to $DBversion done (Bug 21082 - Add overdrive patron auth method)\n";
16
}
(-)a/installer/data/mysql/kohastructure.sql (+12 lines)
Lines 271-276 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
271
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
272
272
273
--
273
--
274
-- Table structure for table `branches_overdrive`
275
--
276
277
DROP TABLE IF EXISTS `branches_overdrive`;
278
CREATE TABLE IF NOT EXISTS branches_overdrive (
279
  `branchcode` VARCHAR( 10 ) NOT NULL ,
280
  `authname` VARCHAR( 255 ) NOT NULL ,
281
  PRIMARY KEY (`branchcode`) ,
282
  CONSTRAINT `branches_overdrive_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
283
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
284
285
--
274
-- Table structure for table `browser`
286
-- Table structure for table `browser`
275
--
287
--
276
DROP TABLE IF EXISTS `browser`;
288
DROP TABLE IF EXISTS `browser`;
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 415-420 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
415
('OverDriveClientKey','','Client key for OverDrive integration','30','Free'),
415
('OverDriveClientKey','','Client key for OverDrive integration','30','Free'),
416
('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'),
416
('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'),
417
('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'),
417
('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'),
418
('OverDrivePasswordRequired','',NULL,'Does the library require passwords for OverDrive SIP authentication','Free'),
418
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
419
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
419
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
420
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
420
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
421
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/enhanced_content.pref (-5 / +17 lines)
Lines 366-371 Enhanced Content: Link Here
366
            - pref: OverDriveClientSecret
366
            - pref: OverDriveClientSecret
367
            - .
367
            - .
368
        -
368
        -
369
            - "Authenticate using OverDrive website id #"
370
            - pref: OverDriveWebsiteID
371
            - .
372
        -
373
            - "Authenticate using OverDrive Authname"
374
            - pref: OverDriveAuthName
375
            - "(will be used as fallback if individual branch authname not set <a href=\"/cgi-bin/koha/admin/overdrive.pl\">here</a>)."
376
        -
369
            - "Show items from the OverDrive catalog of library #"
377
            - "Show items from the OverDrive catalog of library #"
370
            - pref: OverDriveLibraryID
378
            - pref: OverDriveLibraryID
371
            - .
379
            - .
Lines 374-383 Enhanced Content: Link Here
374
              choices:
382
              choices:
375
                  yes: Enable
383
                  yes: Enable
376
                  no: "Don't enable"
384
                  no: "Don't enable"
377
            - users to access their OverDrive circulation history, and circulate items.
385
            - users to access their OverDrive circulation history, and circulate items.<br />
378
            - If you enable access, you must register auth return url of
386
            - A password is
379
            - http(s)://my.opac.hostname/cgi-bin/koha/external/overdrive/auth.pl
387
            - pref: OverDrivePasswordRequired
380
            - with OverDrive.
388
              choices:
389
                  yes: Required
390
                  no: Not required
391
            - for user access to OverDrive. <br />
392
            - If you enable access you must have a SIP connection registered with
393
            - OverDrive for patron authentication against Koha
381
    Coce Cover images cache:
394
    Coce Cover images cache:
382
        -
395
        -
383
            - pref: Coce
396
            - pref: Coce
384
- 

Return to bug 21082