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