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