@@ -, +, @@ --- .../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 --- a/installer/data/mysql/de-DE/optional/auth_val.sql +++ a/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'); --- a/installer/data/mysql/en/optional/auth_val.sql +++ a/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'); --- a/installer/data/mysql/es-ES/optional/auth_val.sql +++ a/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'); --- a/installer/data/mysql/fr-CA/facultatif/auth_val.sql +++ a/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'); --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ a/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'); --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ a/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'); --- a/installer/data/mysql/kohastructure.sql +++ a/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 ), --- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql +++ a/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'); --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ a/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'); --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql +++ a/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'); --- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt +++ a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt @@ -0,0 +1, @@ +RETURN_CLAIM_RESOLUTION --- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql +++ a/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'); --- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt +++ a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt @@ -0,0 +1, @@ +RETURN_CLAIM_RESOLUTION --