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

(-)a/installer/data/mysql/atomicupdate/bug_16276.sql (+3 lines)
Line 0 Link Here
1
ALTER IGNORE TABLE borrowers ADD COLUMN lastseen datetime default NULL;
2
ALTER IGNORE TABLE deletedborrowers ADD COLUMN lastseen datetime default NULL;
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');
(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 266-271 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
266
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
266
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
267
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
268
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
268
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
269
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
269
  UNIQUE KEY `cardnumber` (`cardnumber`),
270
  UNIQUE KEY `cardnumber` (`cardnumber`),
270
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
271
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
271
  KEY `categorycode` (`categorycode`),
272
  KEY `categorycode` (`categorycode`),
Lines 920-925 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
920
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
921
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
921
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
922
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
922
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
923
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
924
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
923
  KEY borrowernumber (borrowernumber),
925
  KEY borrowernumber (borrowernumber),
924
  KEY `cardnumber` (`cardnumber`),
926
  KEY `cardnumber` (`cardnumber`),
925
  KEY `sms_provider_id` (`sms_provider_id`)
927
  KEY `sms_provider_id` (`sms_provider_id`)
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 495-500 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
495
('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
495
('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
496
('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
496
('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
497
('TrackClicks','0',NULL,'Track links clicked','Integer'),
497
('TrackClicks','0',NULL,'Track links clicked','Integer'),
498
('TrackLastPatronActivity','0',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron is seen','YesNo'),
498
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
499
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
499
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
500
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
500
('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
501
('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +7 lines)
Lines 165-171 Patrons: Link Here
165
               yes: Show
165
               yes: Show
166
               no: "Don't show"
166
               no: "Don't show"
167
         - "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)."
167
         - "patron messaging setting on the OPAC (note: EnhancedMessagingPreferences must be enabled)."
168
168
     -
169
         - pref: TrackLastPatronActivity
170
           choices:
171
               yes: Do
172
               no: "Don't"
173
         - track last patron activity.
174
         - Everytime a patron will connect, the borrowers.lastseen will be updated with the current time.
169
    "Norwegian patron database":
175
    "Norwegian patron database":
170
     -
176
     -
171
         - pref: NorwegianPatronDBEnable
177
         - pref: NorwegianPatronDBEnable
172
- 

Return to bug 16276