@@ -, +, @@ files --- installer/data/mysql/de-DE/optional/auth_val.sql | 5 +++++ installer/data/mysql/es-ES/optional/auth_val.sql | 5 +++++ installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 5 +++++ installer/data/mysql/it-IT/necessari/auth_val.sql | 5 +++++ installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 5 +++++ installer/data/mysql/pl-PL/optional/auth_val.sql | 5 +++++ 6 files changed, 30 insertions(+) --- a/installer/data/mysql/de-DE/optional/auth_val.sql +++ a/installer/data/mysql/de-DE/optional/auth_val.sql @@ -70,3 +70,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Buch mit Diskette'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Buch mit CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Buch mit Audio CD/Kassette'); + +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --- a/installer/data/mysql/es-ES/optional/auth_val.sql +++ a/installer/data/mysql/es-ES/optional/auth_val.sql @@ -63,3 +63,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); + +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -704,3 +704,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED -- Autres INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Pilon'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRICTED','1','Exclu du prĂȘt'); + +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ a/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -99,4 +99,9 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Libro con CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette'); +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + SET FOREIGN_KEY_CHECKS=1; --- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql +++ a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql @@ -91,3 +91,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); + +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ a/installer/data/mysql/pl-PL/optional/auth_val.sql @@ -70,3 +70,8 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); + +-- order cancellation reasons +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --