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/kohastructure.sql (+12 lines)
Lines 3088-3093 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3088
  CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE
3088
  CONSTRAINT `aqorders_subscriptionid` FOREIGN KEY (`subscriptionid`) REFERENCES `subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE
3089
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3089
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3090
3090
3091
--
3092
-- Table structure for table `aqorderusers`
3093
--
3094
3095
DROP TABLE IF EXISTS `aqorderusers`;
3096
CREATE TABLE aqorderusers (
3097
    ordernumber int(11) NOT NULL,
3098
    borrowernumber int(11) NOT NULL,
3099
    PRIMARY KEY (ordernumber, borrowernumber),
3100
    CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
3101
    CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3102
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3091
3103
3092
--
3104
--
3093
-- Table structure for table `aqorders_items`
3105
-- Table structure for table `aqorders_items`
(-)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 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/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 / +20 lines)
Lines 9804-9809 if ( CheckVersion($DBversion) ) { Link Here
9804
    SetVersion($DBversion);
9804
    SetVersion($DBversion);
9805
}
9805
}
9806
9806
9807
$DBversion = "3.19.00.XXX";
9808
if ( CheckVersion($DBversion) ) {
9809
    $dbh->do(q|
9810
        CREATE TABLE aqorderusers (
9811
            ordernumber int(11) NOT NULL,
9812
            borrowernumber int(11) NOT NULL,
9813
            PRIMARY KEY (ordernumber, borrowernumber),
9814
            CONSTRAINT aqorderusers_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE,
9815
            CONSTRAINT aqorderusers_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
9816
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9817
    |);
9818
9819
    $dbh->do(q|
9820
        INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
9821
        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')
9822
    |);
9823
    print "Upgrade to $DBversion done (Bug 12648: Add letter ACQ_NOTIF_ON_RECEIV )\n";
9824
    SetVersion ($DBversion);
9825
}
9826
9807
=head1 FUNCTIONS
9827
=head1 FUNCTIONS
9808
9828
9809
=head2 TableExists($table)
9829
=head2 TableExists($table)
9810
- 

Return to bug 12648