Lines 9585-9590
if ( CheckVersion($DBversion) ) {
Link Here
|
9585 |
SetVersion ($DBversion); |
9585 |
SetVersion ($DBversion); |
9586 |
} |
9586 |
} |
9587 |
|
9587 |
|
|
|
9588 |
|
9589 |
|
9590 |
|
9591 |
|
9592 |
|
9593 |
$DBversion = "3.19.00.XXX"; |
9594 |
if ( CheckVersion($DBversion) ) { |
9595 |
$dbh->do(q| |
9596 |
CREATE TABLE aqorderusers ( |
9597 |
ordernumber int(11) NOT NULL, |
9598 |
borrowernumber int(11) NOT NULL, |
9599 |
PRIMARY KEY (ordernumber, borrowernumber), |
9600 |
CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
9601 |
CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE |
9602 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
9603 |
|); |
9604 |
|
9605 |
$dbh->do(q| |
9606 |
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) |
9607 |
VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email') |
9608 |
|); |
9609 |
print "Upgrade to $DBversion done (Bug 12648: Add letter ACQ_NOTIF_ON_RECEIV )\n"; |
9610 |
SetVersion ($DBversion); |
9611 |
} |
9612 |
|
9613 |
|
9588 |
=head1 FUNCTIONS |
9614 |
=head1 FUNCTIONS |
9589 |
|
9615 |
|
9590 |
=head2 TableExists($table) |
9616 |
=head2 TableExists($table) |
9591 |
- |
|
|