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

(-)a/installer/data/mysql/kohastructure.sql (+20 lines)
Lines 3056-3061 CREATE TABLE IF NOT EXISTS `borrower_modifications` ( Link Here
3056
  KEY `borrowernumber` (`borrowernumber`)
3056
  KEY `borrowernumber` (`borrowernumber`)
3057
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3057
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3058
3058
3059
--
3060
-- Table structure for table linktracker
3061
-- This stores clicks to external links
3062
--
3063
3064
DROP TABLE IF EXISTS linktracker;
3065
CREATE TABLE linktracker (
3066
   id int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3067
   biblionumber int(11) DEFAULT NULL, -- biblionumber of the record the link is from
3068
   itemnumber int(11) DEFAULT NULL, -- itemnumber if applicable that the link was from
3069
   borrowernumber int(11) DEFAULT NULL, -- borrowernumber who clicked the link
3070
   url text, -- the link itself
3071
   timeclicked datetime DEFAULT NULL, -- the date and time the link was clicked
3072
   PRIMARY KEY (id),
3073
   KEY bibidx (biblionumber),
3074
   KEY itemidx (itemnumber),
3075
   KEY borridx (borrowernumber),
3076
   KEY dateidx (timeclicked)
3077
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3078
3059
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3079
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3060
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3080
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3061
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3081
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/sysprefs.sql (+2 lines)
Lines 416-418 INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ( Link Here
416
INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('IntranetNumbersPreferPhrase','0', NULL, 'Control the use of phr operator in callnumber and standard number staff client searches', 'YesNo');
416
INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('IntranetNumbersPreferPhrase','0', NULL, 'Control the use of phr operator in callnumber and standard number staff client searches', 'YesNo');
417
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UNIMARCField100Language', 'fre','UNIMARC field 100 default language',NULL,'short');
417
INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('UNIMARCField100Language', 'fre','UNIMARC field 100 default language',NULL,'short');
418
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Persona',0,'Use Mozilla Persona for login','','YesNo');
418
INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES('Persona',0,'Use Mozilla Persona for login','','YesNo');
419
INSERT INTO systempreferences (variable,value,explanation,options,type)  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer');
420
(-)a/installer/data/mysql/updatedatabase.pl (+21 lines)
Lines 6437-6442 if ( CheckVersion($DBversion) ) { Link Here
6437
    SetVersion($DBversion);
6437
    SetVersion($DBversion);
6438
}
6438
}
6439
6439
6440
$DBversion = "3.11.00.XXX";
6441
if ( CheckVersion($DBversion) ) {
6442
    $dbh->do("CREATE TABLE linktracker (
6443
	  id int(11) NOT NULL AUTO_INCREMENT,
6444
	  biblionumber int(11) DEFAULT NULL,
6445
	  itemnumber int(11) DEFAULT NULL,
6446
	  borrowernumber int(11) DEFAULT NULL,
6447
	  url text,
6448
	  timeclicked datetime DEFAULT NULL,
6449
	  PRIMARY KEY (id),
6450
	  KEY bibidx (biblionumber),
6451
	  KEY itemidx (itemnumber),
6452
	  KEY borridx (borrowernumber),
6453
	  KEY dateidx (timeclicked)
6454
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
6455
    $dbh->do("
6456
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6457
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')");
6458
    print "Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6459
    SetVersion ($DBversion);
6460
}
6440
6461
6441
=head1 FUNCTIONS
6462
=head1 FUNCTIONS
6442
6463
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-1 / +8 lines)
Lines 517-522 OPAC: Link Here
517
            - pref: AnonymousPatron
517
            - pref: AnonymousPatron
518
              class: integer
518
              class: integer
519
            - as the Anonymous Patron (for anonymous suggestions and reading history)
519
            - as the Anonymous Patron (for anonymous suggestions and reading history)
520
        -
521
            - pref: TrackClicks
522
              default: 0
523
              choices:
524
                  anonymous: "Track anonymously"
525
                  track: "Track"
526
                  no: "Don't track"
527
            - links that patrons click on
520
528
521
    Shelf Browser:
529
    Shelf Browser:
522
        -
530
        -
523
- 

Return to bug 8917