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 (+1 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');
(-)a/installer/data/mysql/updatedatabase.pl (+21 lines)
Lines 6444-6449 if ( CheckVersion($DBversion) ) { Link Here
6444
    SetVersion($DBversion);
6444
    SetVersion($DBversion);
6445
}
6445
}
6446
6446
6447
$DBversion = "3.11.00.XXX";
6448
if ( CheckVersion($DBversion) ) {
6449
    $dbh->do("CREATE TABLE linktracker (
6450
	  id int(11) NOT NULL AUTO_INCREMENT,
6451
	  biblionumber int(11) DEFAULT NULL,
6452
	  itemnumber int(11) DEFAULT NULL,
6453
	  borrowernumber int(11) DEFAULT NULL,
6454
	  url text,
6455
	  timeclicked datetime DEFAULT NULL,
6456
	  PRIMARY KEY (id),
6457
	  KEY bibidx (biblionumber),
6458
	  KEY itemidx (itemnumber),
6459
	  KEY borridx (borrowernumber),
6460
	  KEY dateidx (timeclicked)
6461
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;");
6462
    $dbh->do("
6463
  INSERT INTO systempreferences (variable,value,explanation,options,type)
6464
  VALUES('TrackClicks','0','Track links clicked',NULL,'Integer')");
6465
    print "Upgrade to $DBversion done (Adds feature Bug 8917, the ability to track links clicked)";
6466
    SetVersion ($DBversion);
6467
}
6447
6468
6448
=head1 FUNCTIONS
6469
=head1 FUNCTIONS
6449
6470
(-)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