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 916-921 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
916
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
917
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
917
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
918
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
918
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
919
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
920
  `lastseen` datetime default NULL, -- last time a patron has been seed (connected at the OPAC or staff interface)
919
  KEY borrowernumber (borrowernumber),
921
  KEY borrowernumber (borrowernumber),
920
  KEY `cardnumber` (`cardnumber`),
922
  KEY `cardnumber` (`cardnumber`),
921
  KEY `sms_provider_id` (`sms_provider_id`)
923
  KEY `sms_provider_id` (`sms_provider_id`)
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 492-497 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
492
('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
492
('TraceCompleteSubfields','0','0','Force subject tracings to only match complete subfields.','YesNo'),
493
('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
493
('TraceSubjectSubdivisions','0','1','Create searches on all subdivisions for subject tracings.','YesNo'),
494
('TrackClicks','0',NULL,'Track links clicked','Integer'),
494
('TrackClicks','0',NULL,'Track links clicked','Integer'),
495
('TrackLastPatronActivity','0',NULL,'If set, the field borrowers.lastseen will be updated everytime a patron is seen','YesNo'),
495
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
496
('TransfersMaxDaysWarning','3',NULL,'Define the days before a transfer is suspected of having a problem','Integer'),
496
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
497
('TransferWhenCancelAllWaitingHolds','0',NULL,'Transfer items when cancelling all waiting holds','YesNo'),
497
('UNIMARCAuthorityField100','afrey50      ba0',NULL,'Define the contents of UNIMARC authority control field 100 position 08-35','Textarea'),
498
('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 (-1 / +7 lines)
Lines 159-164 Patrons: Link Here
159
               yes: Do
159
               yes: Do
160
               no: "Don't"
160
               no: "Don't"
161
         - charge a fee when a patron changes to a category with an enrollment fee.
161
         - charge a fee when a patron changes to a category with an enrollment fee.
162
    -
163
         - pref: TrackLastPatronActivity
164
           choices:
165
               yes: Do
166
               no: "Don't"
167
         - track last patron activity.
168
         - Everytime a patron will connect, the borrowers.lastseen will be updated with the current time.
162
    "Norwegian patron database":
169
    "Norwegian patron database":
163
     -
170
     -
164
         - pref: NorwegianPatronDBEnable
171
         - pref: NorwegianPatronDBEnable
165
- 

Return to bug 16276