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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 441-447 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here
441
  `reservefee` decimal(28,6) default NULL, -- cost to place holds
441
  `reservefee` decimal(28,6) default NULL, -- cost to place holds
442
  `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no)
442
  `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no)
443
  `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
443
  `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
444
  `BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-1', -- wheither or not a patron of this categori can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BLockExpiredPAtronOpacACtions
444
  `BlockExpiredPatronOpacActions` tinyint(1) NOT NULL default '-1', -- wheither or not a patron of this category can renew books or place holds once their card has expired. 0 means they can, 1 means they cannot, -1 means use syspref BlockExpiredPatronOpacActions
445
  PRIMARY KEY  (`categorycode`),
445
  PRIMARY KEY  (`categorycode`),
446
  UNIQUE KEY `categorycode` (`categorycode`)
446
  UNIQUE KEY `categorycode` (`categorycode`)
447
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
447
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/sysprefs.sql (-1 / +1 lines)
Lines 428-431 INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) V Link Here
428
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacHoldNotes',0,'Show hold notes on OPAC','','YesNo');
428
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacHoldNotes',0,'Show hold notes on OPAC','','YesNo');
429
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('CalculateFinesOnReturn','1','Switch to control if overdue fines are calculated on return or not', '', 'YesNo');
429
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('CalculateFinesOnReturn','1','Switch to control if overdue fines are calculated on return or not', '', 'YesNo');
430
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('AcqWarnOnDuplicateInvoice','0','Warn librarians when they try to create a duplicate invoice', '', 'YesNo');
430
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('AcqWarnOnDuplicateInvoice','0','Warn librarians when they try to create a duplicate invoice', '', 'YesNo');
431
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('BlockExpiredPatronOpacActions', 'yes', 'Set whether an expired patron can perform opac actions such as placing a hold or reserve, can be overridden on a per patron-type basis',NULL,'YesNo');
431
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('BlockExpiredPatronOpacActions', '1', 'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis',NULL,'YesNo');
(-)a/installer/data/mysql/updatedatabase.pl (-3 / +2 lines)
Lines 7051-7062 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
7051
        VALUES (
7051
        VALUES (
7052
            'BlockExpiredPatronOpacActions',
7052
            'BlockExpiredPatronOpacActions',
7053
            'yes',
7053
            'yes',
7054
            'Set whether an expired patron can perform opac actions such as placing a hold or reserve, can be overridden on a per patron-type basis',
7054
            'Set whether an expired patron can perform opac actions such as placing holds or renew books, can be overridden on a per patron-type basis',
7055
            NULL,
7055
            NULL,
7056
            'YesNo'
7056
            'YesNo'
7057
        )
7057
        )
7058
    ");
7058
    ");
7059
    $dbh->do("ALTER TABLE `categories` ADD COLUMN `BlockExpiredPatronOpacActions` TINYINT(1) DEFAULT 0 NOT NULL");
7059
    $dbh->do("ALTER TABLE `categories` ADD COLUMN `BlockExpiredPatronOpacActions` TINYINT(1) DEFAULT -1 NOT NULL AFTER category_type");
7060
    print "Upgraded to $DBversion done (Bug 6739 - expired patrons not blocked from opac actions)\n";
7060
    print "Upgraded to $DBversion done (Bug 6739 - expired patrons not blocked from opac actions)\n";
7061
    SetVersion ($DBversion);
7061
    SetVersion ($DBversion);
7062
}
7062
}
7063
- 

Return to bug 6739