Bugzilla – Attachment 94877 Details for
Bug 14697
Extend and enhance "Claims returned" lost status
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 14697: (follow-up) Add auth values to the sample data
Bug-14697-follow-up-Add-auth-values-to-the-sample-.patch (text/plain), 13.41 KB, created by
Tomás Cohen Arazi (tcohen)
on 2019-10-30 15:17:48 UTC
(
hide
)
Description:
Bug 14697: (follow-up) Add auth values to the sample data
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2019-10-30 15:17:48 UTC
Size:
13.41 KB
patch
obsolete
>From 7669169ac0505b5778de4a73383cf0670084249d Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@theke.io> >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 <tomascohen@theke.io> >--- > .../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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 14697
:
92407
|
92408
|
92409
|
92410
|
92962
|
92963
|
92964
|
92965
|
93005
|
93006
|
93007
|
93008
|
93012
|
93013
|
93014
|
93015
|
93017
|
93038
|
93039
|
93040
|
93041
|
93042
|
93061
|
93062
|
93063
|
93064
|
93065
|
93952
|
93953
|
93954
|
93955
|
93956
|
93957
|
93959
|
94842
|
94843
|
94844
|
94845
|
94846
|
94847
|
94848
|
94849
|
94850
|
94851
|
94852
|
94853
|
94854
|
94857
| 94877 |
94878