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