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 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
- 

Return to bug 12648