From 7669169ac0505b5778de4a73383cf0670084249d Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Wed, 30 Oct 2019 12:17:15 -0300 Subject: [PATCH] Bug 14697: (follow-up) Add auth values to the sample data Signed-off-by: Tomas Cohen Arazi --- .../data/mysql/de-DE/optional/auth_val.sql | 4 ++++ installer/data/mysql/en/optional/auth_val.sql | 4 ++++ .../data/mysql/es-ES/optional/auth_val.sql | 4 ++++ .../data/mysql/fr-CA/facultatif/auth_val.sql | 4 ++++ .../fr-FR/1-Obligatoire/authorised_values.sql | 4 ++++ .../data/mysql/it-IT/necessari/auth_val.sql | 4 ++++ installer/data/mysql/kohastructure.sql | 24 +++++++++---------- .../data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 4 ++++ .../data/mysql/pl-PL/optional/auth_val.sql | 4 ++++ ...rised_values_[RETURN_CLAIM_RESOLUTION].sql | 5 ++++ ...rised_values_[RETURN_CLAIM_RESOLUTION].txt | 1 + ...rised_values_[RETURN_CLAIM_RESOLUTION].sql | 5 ++++ ...rised_values_[RETURN_CLAIM_RESOLUTION].txt | 1 + 13 files changed, 56 insertions(+), 12 deletions(-) create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql index ec0639a58b..f63ca91085 100644 --- a/installer/data/mysql/de-DE/optional/auth_val.sql +++ b/installer/data/mysql/de-DE/optional/auth_val.sql @@ -83,3 +83,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'E-Book', 'E-Book'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Hörbuch', 'Hörbuch'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql index b4e00fd8b2..8d4821ae45 100644 --- a/installer/data/mysql/en/optional/auth_val.sql +++ b/installer/data/mysql/en/optional/auth_val.sql @@ -80,3 +80,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED 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'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/es-ES/optional/auth_val.sql b/installer/data/mysql/es-ES/optional/auth_val.sql index e1f9f8cc32..b66bcf24d0 100644 --- a/installer/data/mysql/es-ES/optional/auth_val.sql +++ b/installer/data/mysql/es-ES/optional/auth_val.sql @@ -75,3 +75,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Devuelto por el socio'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Encontrado en la biblioteca'); diff --git a/installer/data/mysql/fr-CA/facultatif/auth_val.sql b/installer/data/mysql/fr-CA/facultatif/auth_val.sql index 9424c2e3b2..9e7282c19e 100644 --- a/installer/data/mysql/fr-CA/facultatif/auth_val.sql +++ b/installer/data/mysql/fr-CA/facultatif/auth_val.sql @@ -85,3 +85,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Livre avec disquette'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Livre avec CD'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Livre avec cassette audio'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql index b8ffb32cf9..46539144e6 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -720,3 +720,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES -- Housebound INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index 4638432257..b58ad6ca58 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -118,3 +118,7 @@ SET FOREIGN_KEY_CHECKS=1; -- Housebound INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Ogni settimana'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 34ab77bc58..9a0d45420c 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -4425,18 +4425,18 @@ CREATE TABLE itemtypes_branches( -- association table between authorised_values DROP TABLE IF EXISTS `return_claims`; CREATE TABLE return_claims ( - id int(11) auto_increment, - itemnumber int(11) NOT NULL, - issue_id int(11) NULL DEFAULT NULL, - borrowernumber int(11) NOT NULL, - notes MEDIUMTEXT DEFAULT NULL, - created_on TIMESTAMP NULL, - created_by int(11) NULL DEFAULT NULL, - updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, - updated_by int(11) NULL DEFAULT NULL, - resolution varchar(80) NULL DEFAULT NULL, - resolved_on TIMESTAMP NULL DEFAULT NULL, - resolved_by int(11) NULL DEFAULT NULL, + id int(11) auto_increment, -- Unique ID of the return claim + itemnumber int(11) NOT NULL, -- ID of the item + issue_id int(11) NULL DEFAULT NULL, -- ID of the checkout that triggered the claim + borrowernumber int(11) NOT NULL, -- ID of the patron + notes MEDIUMTEXT DEFAULT NULL, -- Notes about the claim + created_on TIMESTAMP NULL, -- Time and date the claim was created + created_by int(11) NULL DEFAULT NULL, -- ID of the staff member that registered the claim + updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, -- Time and date of the latest change on the claim (notes) + updated_by int(11) NULL DEFAULT NULL, -- ID of the staff member that updated the claim + resolution varchar(80) NULL DEFAULT NULL, -- Resolution code (RETURN_CLAIM_RESOLUTION AVs) + resolved_on TIMESTAMP NULL DEFAULT NULL, -- Time and date the claim was resolved + resolved_by int(11) NULL DEFAULT NULL, -- ID of the staff member that resolved the claim PRIMARY KEY (`id`), KEY `itemnumber` (`itemnumber`), CONSTRAINT UNIQUE `issue_id` ( issue_id ), diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql index 8b66ca87a7..af913fcadb 100644 --- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql +++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql @@ -104,3 +104,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql index 34f7fadb78..927c446ee3 100644 --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ b/installer/data/mysql/pl-PL/optional/auth_val.sql @@ -83,3 +83,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); + +-- return claims +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql new file mode 100644 index 0000000000..e4c9681320 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql @@ -0,0 +1,5 @@ +DELETE FROM authorised_values WHERE category='RETURN_CLAIM_RESOLUTION'; + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES +('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'), +('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt new file mode 100644 index 0000000000..910f6f5a5d --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt @@ -0,0 +1 @@ +RETURN_CLAIM_RESOLUTION diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql new file mode 100644 index 0000000000..e4c9681320 --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql @@ -0,0 +1,5 @@ +DELETE FROM authorised_values WHERE category='RETURN_CLAIM_RESOLUTION'; + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES +('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'), +('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt new file mode 100644 index 0000000000..910f6f5a5d --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt @@ -0,0 +1 @@ +RETURN_CLAIM_RESOLUTION -- 2.23.0