@@ -, +, @@ --- .../data/mysql/de-DE/mandatory/sample_notices.sql | 3 +++ .../data/mysql/en/mandatory/sample_notices.sql | 3 +++ .../data/mysql/es-ES/mandatory/sample_notices.sql | 4 ++++ .../mysql/fr-FR/1-Obligatoire/sample_notices.sql | 3 +++ installer/data/mysql/it-IT/necessari/notices.sql | 3 +++ .../mysql/nb-NO/1-Obligatorisk/sample_notices.sql | 3 +++ .../data/mysql/pl-PL/mandatory/sample_notices.sql | 3 +++ .../data/mysql/ru-RU/mandatory/sample_notices.sql | 3 +++ .../data/mysql/uk-UA/mandatory/sample_notices.sql | 3 +++ installer/data/mysql/updatedatabase.pl | 27 ++++++++++++++++++++++ 10 files changed, 55 insertions(+) --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ a/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -131,3 +131,6 @@ Wir möchten Sie darüber informieren, dass der Benutzer <> Vielen Dank, Ihr Biblioheksteam' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ a/installer/data/mysql/en/mandatory/sample_notices.sql @@ -142,3 +142,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/es-ES/mandatory/sample_notices.sql +++ a/installer/data/mysql/es-ES/mandatory/sample_notices.sql @@ -42,3 +42,7 @@ Thank you. Your library.' ); + + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql +++ a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -44,3 +44,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/it-IT/necessari/notices.sql +++ a/installer/data/mysql/it-IT/necessari/notices.sql @@ -130,3 +130,6 @@ Grazie di tutto Lo staff della biblioteca.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql +++ a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices.sql @@ -163,3 +163,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql +++ a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -44,3 +44,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql +++ a/installer/data/mysql/ru-RU/mandatory/sample_notices.sql @@ -42,3 +42,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql +++ a/installer/data/mysql/uk-UA/mandatory/sample_notices.sql @@ -41,3 +41,6 @@ Thank you. Your library.' ); + +INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) +VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -8577,6 +8577,33 @@ if ( CheckVersion($DBversion) ) { SetVersion ($DBversion); } + + + + + + +$DBversion = "3.17.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q| + CREATE TABLE aqorderusers ( + ordernumber int(11) NOT NULL, + borrowernumber int(11) NOT NULL, + PRIMARY KEY (ordernumber, borrowernumber), + CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE + ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + |); + + $dbh->do(q| + INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type) + VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <> <>,\n\n The order <> (<>) has been received.\n\nYour library.', 'email') + |); + print "Upgrade to $DBversion done ( Bug XXXXX - Add letter ACQ_NOTIF_ON_RECEIV )\n"; + SetVersion ($DBversion); +} + + =head1 FUNCTIONS =head2 TableExists($table) --