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 8577-8582 if ( CheckVersion($DBversion) ) { Link Here
8577
    SetVersion ($DBversion);
8577
    SetVersion ($DBversion);
8578
}
8578
}
8579
8579
8580
8581
8582
8583
8584
8585
8586
$DBversion = "3.17.00.XXX";
8587
if ( CheckVersion($DBversion) ) {
8588
    $dbh->do(q|
8589
        CREATE TABLE aqorderusers (
8590
            ordernumber int(11) NOT NULL,
8591
            borrowernumber int(11) NOT NULL,
8592
            PRIMARY KEY (ordernumber, borrowernumber),
8593
            CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
8594
            CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
8595
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8596
    |);
8597
8598
    $dbh->do(q|
8599
        INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
8600
        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')
8601
    |);
8602
    print "Upgrade to $DBversion done ( Bug XXXXX - Add letter ACQ_NOTIF_ON_RECEIV )\n";
8603
    SetVersion ($DBversion);
8604
}
8605
8606
8580
=head1 FUNCTIONS
8607
=head1 FUNCTIONS
8581
8608
8582
=head2 TableExists($table)
8609
=head2 TableExists($table)
8583
- 

Return to bug 12648