Attachment #55499 for bug #16276

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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_16276.sql (+3 lines)
	1	ALTER IGNORE TABLE borrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
	2	ALTER IGNORE TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL AFTER updated_on;
	3	INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('TrackLastPatronActivity', '0', 'If set, the field borrowers.lastseen will be updated everytime a patron is seen', NULL, 'YesNo');

Lines 507-512 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
507	('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),	507	('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
508	('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),	508	('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
509	('TrackClicks','0',NULL,'Track links clicked','Integer'),	509	('TrackClicks','0',NULL,'Track links clicked','Integer'),
		510	('TrackLastPatronActivity','0',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron is seen','YesNo'),
510	('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),	511	('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
511	('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),	512	('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
512	('UNIMARCAuthorityField100','afrey50 ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),	513	('UNIMARCAuthorityField100','afrey50 ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),

Lines 179-185 Patrons: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +7 lines)
179	yes: Show	179	yes: Show
180	no: "Don't show"	180	no: "Don't show"
181	- "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)."	181	- "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)."
182		182	-
		183	- pref: TrackLastPatronActivity
		184	choices:
		185	yes: Do
		186	no: "Don't"
		187	- track last patron activity.
		188	- Everytime a patron will connect, the borrowers.lastseen will be updated with the current time.
183	"Norwegian patron database":	189	"Norwegian patron database":
184	-	190	-
185	- pref: NorwegianPatronDBEnable	191	- pref: NorwegianPatronDBEnable
186	-

Return to bug 16276

Lines 621-626 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here

(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
621	`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts	621	`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
622	`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.	622	`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
623	`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)	623	`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
		624	`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
624	KEY borrowernumber (borrowernumber),	625	KEY borrowernumber (borrowernumber),
625	KEY `cardnumber` (`cardnumber`),	626	KEY `cardnumber` (`cardnumber`),
626	KEY `sms_provider_id` (`sms_provider_id`)	627	KEY `sms_provider_id` (`sms_provider_id`)
Lines 1640-1645 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1640	`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts	1641	`privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1641	`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.	1642	`checkprevcheckout` varchar(7) NOT NULL default 'inherit', -- produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
1642	`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)	1643	`updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
		1644	`lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
1643	UNIQUE KEY `cardnumber` (`cardnumber`),	1645	UNIQUE KEY `cardnumber` (`cardnumber`),
1644	PRIMARY KEY `borrowernumber` (`borrowernumber`),	1646	PRIMARY KEY `borrowernumber` (`borrowernumber`),
1645	KEY `categorycode` (`categorycode`),	1647	KEY `categorycode` (`categorycode`),