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 42-44 Thank you. Link Here
42
42
43
Your library.'
43
Your library.'
44
);
44
);
45
46
47
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
48
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 44-46 Thank you. Link Here
44
44
45
Your library.'
45
Your library.'
46
);
46
);
47
48
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
49
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 130-132 Grazie di tutto Link Here
130
130
131
Lo staff della biblioteca.'
131
Lo staff della biblioteca.'
132
);
132
);
133
134
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
135
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 44-46 Thank you. Link Here
44
44
45
Your library.'
45
Your library.'
46
);
46
);
47
48
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
49
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 42-44 Thank you. Link Here
42
42
43
Your library.'
43
Your library.'
44
);
44
);
45
46
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
47
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 41-43 Thank you. Link Here
41
41
42
Your library.'
42
Your library.'
43
);
43
);
44
45
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
46
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 / +27 lines)
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
- 

Return to bug 12648