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, 'YesNo');");
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 272-277 CREATE TABLE `branches` ( -- information about your libraries or branches are st Link Here
272
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
272
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
273
273
274
--
274
--
275
-- Table structure for table `branches_overdrive`
276
--
277
278
DROP TABLE IF EXISTS `branches_overdrive`;
279
CREATE TABLE IF NOT EXISTS branches_overdrive (
280
  `branchcode` VARCHAR( 10 ) NOT NULL ,
281
  `authname` VARCHAR( 255 ) NOT NULL ,
282
  PRIMARY KEY (`branchcode`) ,
283
  CONSTRAINT `branches_overdrive_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
284
) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
285
286
--
275
-- Table structure for table `browser`
287
-- Table structure for table `browser`
276
--
288
--
277
DROP TABLE IF EXISTS `browser`;
289
DROP TABLE IF EXISTS `browser`;
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 420-425 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
420
('OverDriveClientKey','','Client key for OverDrive integration','30','Free'),
420
('OverDriveClientKey','','Client key for OverDrive integration','30','Free'),
421
('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'),
421
('OverDriveClientSecret','','Client key for OverDrive integration','30','YesNo'),
422
('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'),
422
('OverDriveLibraryID','','Library ID for OverDrive integration','','Integer'),
423
('OverDrivePasswordRequired','',NULL,'Does the library require passwords for OverDrive SIP authentication','YesNo'),
423
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
424
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
424
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
425
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
425
('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'),
426
('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 351-356 Enhanced Content: Link Here
351
            - pref: OverDriveClientSecret
351
            - pref: OverDriveClientSecret
352
            - .
352
            - .
353
        -
353
        -
354
            - "Authenticate using OverDrive website id #"
355
            - pref: OverDriveWebsiteID
356
            - .
357
        -
358
            - "Authenticate using OverDrive Authname"
359
            - pref: OverDriveAuthName
360
            - "(will be used as fallback if individual branch authname not set <a href=\"/cgi-bin/koha/admin/overdrive.pl\">here</a>)."
361
        -
354
            - "Show items from the OverDrive catalog of library #"
362
            - "Show items from the OverDrive catalog of library #"
355
            - pref: OverDriveLibraryID
363
            - pref: OverDriveLibraryID
356
            - .
364
            - .
Lines 359-368 Enhanced Content: Link Here
359
              choices:
367
              choices:
360
                  yes: Enable
368
                  yes: Enable
361
                  no: "Don't enable"
369
                  no: "Don't enable"
362
            - users to access their OverDrive circulation history, and circulate items.
370
            - users to access their OverDrive circulation history, and circulate items.<br />
363
            - If you enable access, you must register auth return url of
371
            - A password is
364
            - http(s)://my.opac.hostname/cgi-bin/koha/external/overdrive/auth.pl
372
            - pref: OverDrivePasswordRequired
365
            - with OverDrive.
373
              choices:
374
                  yes: Required
375
                  no: Not required
376
            - for user access to OverDrive. <br />
377
            - If you enable access you must have a SIP connection registered with
378
            - OverDrive for patron authentication against Koha
366
    RecordedBooks:
379
    RecordedBooks:
367
        -
380
        -
368
            - Include RecordedBooks availability information with the client secret
381
            - Include RecordedBooks availability information with the client secret
369
- 

Return to bug 21082