View | Details | Raw Unified | Return to bug 12648
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (+3 lines)
Lines 131-133 Wir möchten Sie darüber informieren, dass der Benutzer <<borrowers.firstname>> Link Here
131
Vielen Dank,
131
Vielen Dank,
132
Ihr Biblioheksteam'
132
Ihr Biblioheksteam'
133
);
133
);
134
135
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
136
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')
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (+3 lines)
Lines 142-144 Thank you. Link Here
142
142
143
Your library.'
143
Your library.'
144
);
144
);
145
146
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
147
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')
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices.sql (+4 lines)
Lines 143-145 Thank you. Link Here
143
143
144
Your library.'
144
Your library.'
145
);
145
);
146
147
148
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
149
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')
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql (+3 lines)
Lines 145-147 Thank you. Link Here
145
145
146
Your library.'
146
Your library.'
147
);
147
);
148
149
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
150
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')
(-)a/installer/data/mysql/it-IT/necessari/notices.sql (+3 lines)
Lines 142-144 Grazie di tutto Link Here
142
142
143
Lo staff della biblioteca.'
143
Lo staff della biblioteca.'
144
);
144
);
145
146
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
147
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')
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql (+3 lines)
Lines 163-165 Thank you. Link Here
163
163
164
Your library.'
164
Your library.'
165
);
165
);
166
167
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
168
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')
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql (+3 lines)
Lines 145-147 Thank you. Link Here
145
145
146
Your library.'
146
Your library.'
147
);
147
);
148
149
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
150
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')
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql (+3 lines)
Lines 145-147 Thank you. Link Here
145
145
146
Your library.'
146
Your library.'
147
);
147
);
148
149
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
150
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')
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql (+3 lines)
Lines 144-146 Thank you. Link Here
144
144
145
Your library.'
145
Your library.'
146
);
146
);
147
148
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
149
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')
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +26 lines)
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
- 

Return to bug 12648