Lines 8974-8979
if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) {
Link Here
|
8974 |
SetVersion($DBversion); |
8974 |
SetVersion($DBversion); |
8975 |
} |
8975 |
} |
8976 |
|
8976 |
|
|
|
8977 |
|
8978 |
|
8979 |
|
8980 |
|
8981 |
|
8982 |
|
8983 |
$DBversion = "3.17.00.XXX"; |
8984 |
if ( CheckVersion($DBversion) ) { |
8985 |
$dbh->do(q| |
8986 |
CREATE TABLE aqorderusers ( |
8987 |
ordernumber int(11) NOT NULL, |
8988 |
borrowernumber int(11) NOT NULL, |
8989 |
PRIMARY KEY (ordernumber, borrowernumber), |
8990 |
CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
8991 |
CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE |
8992 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
8993 |
|); |
8994 |
|
8995 |
$dbh->do(q| |
8996 |
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) |
8997 |
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') |
8998 |
|); |
8999 |
print "Upgrade to $DBversion done ( Bug 12648 - Add letter ACQ_NOTIF_ON_RECEIV )\n"; |
9000 |
SetVersion ($DBversion); |
9001 |
} |
9002 |
|
9003 |
|
8977 |
=head1 FUNCTIONS |
9004 |
=head1 FUNCTIONS |
8978 |
|
9005 |
|
8979 |
=head2 TableExists($table) |
9006 |
=head2 TableExists($table) |
8980 |
- |
|
|