|
Lines 8613-8618
if ( CheckVersion($DBversion) ) {
Link Here
|
| 8613 |
SetVersion($DBversion); |
8613 |
SetVersion($DBversion); |
| 8614 |
} |
8614 |
} |
| 8615 |
|
8615 |
|
|
|
8616 |
|
| 8617 |
|
| 8618 |
|
| 8619 |
|
| 8620 |
|
| 8621 |
|
| 8622 |
$DBversion = "3.17.00.XXX"; |
| 8623 |
if ( CheckVersion($DBversion) ) { |
| 8624 |
$dbh->do(q| |
| 8625 |
CREATE TABLE aqorderusers ( |
| 8626 |
ordernumber int(11) NOT NULL, |
| 8627 |
borrowernumber int(11) NOT NULL, |
| 8628 |
PRIMARY KEY (ordernumber, borrowernumber), |
| 8629 |
CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
| 8630 |
CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 8631 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 8632 |
|); |
| 8633 |
|
| 8634 |
$dbh->do(q| |
| 8635 |
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) |
| 8636 |
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') |
| 8637 |
|); |
| 8638 |
print "Upgrade to $DBversion done ( Bug 12648 - Add letter ACQ_NOTIF_ON_RECEIV )\n"; |
| 8639 |
SetVersion ($DBversion); |
| 8640 |
} |
| 8641 |
|
| 8642 |
|
| 8616 |
=head1 FUNCTIONS |
8643 |
=head1 FUNCTIONS |
| 8617 |
|
8644 |
|
| 8618 |
=head2 TableExists($table) |
8645 |
=head2 TableExists($table) |
| 8619 |
- |
|
|