View | Details | Raw Unified | Return to bug 14697
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/optional/auth_val.sql (+4 lines)
Lines 83-85 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES Link Here
83
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'E-Book', 'E-Book');
83
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'E-Book', 'E-Book');
84
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Hörbuch', 'Hörbuch');
84
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Hörbuch', 'Hörbuch');
85
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
85
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
86
87
-- return claims
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
89
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 (+4 lines)
Lines 80-82 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED Link Here
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
83
84
-- return claims
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
86
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 (+4 lines)
Lines 75-77 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES Link Here
75
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
75
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
76
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
76
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
77
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
77
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
78
79
-- return claims
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Devuelto por el socio');
81
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 (+4 lines)
Lines 85-87 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED Link Here
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Livre avec disquette');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Livre avec disquette');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Livre avec CD');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Livre avec CD');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Livre avec cassette audio');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Livre avec cassette audio');
88
89
-- return claims
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
91
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 (+4 lines)
Lines 720-722 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES Link Here
720
720
721
-- Housebound
721
-- Housebound
722
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine');
722
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine');
723
724
-- return claims
725
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
726
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 (+4 lines)
Lines 118-120 SET FOREIGN_KEY_CHECKS=1; Link Here
118
118
119
-- Housebound
119
-- Housebound
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Ogni settimana');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Ogni settimana');
121
122
-- return claims
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB',  'Found in library');
(-)a/installer/data/mysql/kohastructure.sql (-12 / +12 lines)
Lines 4425-4442 CREATE TABLE itemtypes_branches( -- association table between authorised_values Link Here
4425
4425
4426
DROP TABLE IF EXISTS `return_claims`;
4426
DROP TABLE IF EXISTS `return_claims`;
4427
CREATE TABLE return_claims (
4427
CREATE TABLE return_claims (
4428
    id int(11) auto_increment,
4428
    id int(11) auto_increment,                             -- Unique ID of the return claim
4429
    itemnumber int(11) NOT NULL,
4429
    itemnumber int(11) NOT NULL,                           -- ID of the item
4430
    issue_id int(11) NULL DEFAULT NULL,
4430
    issue_id int(11) NULL DEFAULT NULL,                    -- ID of the checkout that triggered the claim
4431
    borrowernumber int(11) NOT NULL,
4431
    borrowernumber int(11) NOT NULL,                       -- ID of the patron
4432
    notes MEDIUMTEXT DEFAULT NULL,
4432
    notes MEDIUMTEXT DEFAULT NULL,                         -- Notes about the claim
4433
    created_on TIMESTAMP NULL,
4433
    created_on TIMESTAMP NULL,                             -- Time and date the claim was created
4434
    created_by int(11) NULL DEFAULT NULL,
4434
    created_by int(11) NULL DEFAULT NULL,                  -- ID of the staff member that registered the claim
4435
    updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP,
4435
    updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, -- Time and date of the latest change on the claim (notes)
4436
    updated_by int(11) NULL DEFAULT NULL,
4436
    updated_by int(11) NULL DEFAULT NULL,                  -- ID of the staff member that updated the claim
4437
    resolution  varchar(80) NULL DEFAULT NULL,
4437
    resolution  varchar(80) NULL DEFAULT NULL,             -- Resolution code (RETURN_CLAIM_RESOLUTION AVs)
4438
    resolved_on TIMESTAMP NULL DEFAULT NULL,
4438
    resolved_on TIMESTAMP NULL DEFAULT NULL,               -- Time and date the claim was resolved
4439
    resolved_by int(11) NULL DEFAULT NULL,
4439
    resolved_by int(11) NULL DEFAULT NULL,                 -- ID of the staff member that resolved the claim
4440
    PRIMARY KEY (`id`),
4440
    PRIMARY KEY (`id`),
4441
    KEY `itemnumber` (`itemnumber`),
4441
    KEY `itemnumber` (`itemnumber`),
4442
    CONSTRAINT UNIQUE `issue_id` ( issue_id ),
4442
    CONSTRAINT UNIQUE `issue_id` ( issue_id ),
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql (+4 lines)
Lines 104-106 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES Link Here
104
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
104
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
105
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
105
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
106
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
106
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
107
108
-- return claims
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
110
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 (+4 lines)
Lines 83-85 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES Link Here
83
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
83
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
84
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
84
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
85
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
85
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
86
87
-- return claims
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
89
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 (+5 lines)
Line 0 Link Here
1
DELETE FROM authorised_values WHERE category='RETURN_CLAIM_RESOLUTION';
2
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
4
('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'),
5
('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB',  'Found in library');
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt (+1 lines)
Line 0 Link Here
1
RETURN_CLAIM_RESOLUTION
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].sql (+5 lines)
Line 0 Link Here
1
DELETE FROM authorised_values WHERE category='RETURN_CLAIM_RESOLUTION';
2
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES
4
('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'),
5
('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB',  'Found in library');
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RETURN_CLAIM_RESOLUTION].txt (-1 / +1 lines)
Line 0 Link Here
0
- 
1
RETURN_CLAIM_RESOLUTION

Return to bug 14697