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

(-)a/installer/data/mysql/atomicupdate/Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql (+3 lines)
Line 0 Link Here
1
ALTER TABLE `categories`
2
CHANGE COLUMN `enrolmentfee` `enrolmentfee` DECIMAL(19,6) NULL DEFAULT NULL ,
3
CHANGE COLUMN `reservefee` `reservefee` DECIMAL(19,6) NULL DEFAULT NULL ;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 322-331 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here
322
  `dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category
322
  `dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category
323
  `finetype` varchar(30) default NULL, -- unused in Koha
323
  `finetype` varchar(30) default NULL, -- unused in Koha
324
  `bulk` tinyint(1) default NULL,
324
  `bulk` tinyint(1) default NULL,
325
  `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron
325
  `enrolmentfee` decimal(19,6) default NULL, -- enrollment fee for the patron
326
  `overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no)
326
  `overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no)
327
  `issuelimit` smallint(6) default NULL, -- unused in Koha
327
  `issuelimit` smallint(6) default NULL, -- unused in Koha
328
  `reservefee` decimal(28,6) default NULL, -- cost to place holds
328
  `reservefee` decimal(19,6) default NULL, -- cost to place holds
329
  `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no)
329
  `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no)
330
  `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
330
  `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff)
331
  `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
331
  `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
332
- 

Return to bug 17164