Attachment #57815 for bug #17164

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/Bug_17164-Lower_enrolmentfee_and_reservefee_max_digits.sql (+3 lines)
	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 ;

Lines 322-331 CREATE TABLE `categories` ( -- this table shows information related to Koha patr Link Here

(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
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