@@ -, +, @@ reservefee in categories --- .../Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql | 3 +++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 5 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql --- a/installer/data/mysql/atomicupdate/Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql +++ a/installer/data/mysql/atomicupdate/Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql @@ -0,0 +1,3 @@ +ALTER TABLE `categories` +CHANGE COLUMN `enrolmentfee` `enrolmentfee` DECIMAL(19,6) NULL DEFAULT NULL , +CHANGE COLUMN `reservefee` `reservefee` DECIMAL(19,6) NULL DEFAULT NULL ; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -322,10 +322,10 @@ CREATE TABLE `categories` ( -- this table shows information related to Koha patr `dateofbirthrequired` tinyint(1) default NULL, -- the minimum age required for the patron category `finetype` varchar(30) default NULL, -- unused in Koha `bulk` tinyint(1) default NULL, - `enrolmentfee` decimal(28,6) default NULL, -- enrollment fee for the patron + `enrolmentfee` decimal(19,6) default NULL, -- enrollment fee for the patron `overduenoticerequired` tinyint(1) default NULL, -- are overdue notices sent to this patron category (1 for yes, 0 for no) `issuelimit` smallint(6) default NULL, -- unused in Koha - `reservefee` decimal(28,6) default NULL, -- cost to place holds + `reservefee` decimal(19,6) default NULL, -- cost to place holds `hidelostitems` tinyint(1) NOT NULL default '0', -- are lost items shown to this category (1 for yes, 0 for no) `category_type` varchar(1) NOT NULL default 'A', -- type of Koha patron (Adult, Child, Professional, Organizational, Statistical, Staff) `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 --