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 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');
(-)a/installer/data/mysql/kohastructure.sql (+2 lines)
Lines 621-626 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
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`),
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 507-512 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
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'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-2 / +7 lines)
Lines 179-185 Patrons: Link Here
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