Attachment #102420 for bug #25037

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

Lines 1-3 Link Here

(-)a/installer/data/mysql/de-DE/mandatory/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein');	1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein');
2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja');	2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja');
3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Jede Woche');	3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Jede Woche');
		4	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		5	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');




          lib: "Creditcard via SIP2"
          lib_opac: "Creditcard"

        - category: "CHECKOUT_TYPE"
          authorised_value: "C"
          lib: "Normal checkout"
          lib_opac: "Normal checkout"

        - category: "CHECKOUT_TYPE"
          authorised_value: "OS"
          lib: "On-site checkout"
          lib_opac: "On-site checkout"

  - authorised_values:
      translatable: [ lib ]
      multiline: []

Lines 1-3 Link Here

(-)a/installer/data/mysql/es-ES/mandatory/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');	1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');	2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');	3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
		4	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		5	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Lines 1-3 Link Here

(-)a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Non','Non');	1	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Non','Non');
2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Oui','Oui');	2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Oui','Oui');
3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine');	3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine');
		4	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		5	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Lines 724-726 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F Link Here

(-)a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql (+4 lines)
724	-- return claims	724	-- return claims
725	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');	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');	726	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library');
		727
		728	-- Checkout types
		729	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		730	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Lines 119-121 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F Link Here

(-)a/installer/data/mysql/it-IT/necessari/auth_val.sql (+4 lines)
119	-- return claims	119	-- return claims
120	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');	120	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron');
121	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library');	121	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library');
		122
		123	-- Checkout types
		124	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		125	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Line 1 Link Here

(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');	1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
		2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		3	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Line 1 Link Here

(-)a/installer/data/mysql/pl-PL/mandatory/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');	1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
		2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		3	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Line 1 Link Here

(-)a/installer/data/mysql/ru-RU/mandatory/auth_values.sql (+2 lines)
1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');	1	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
		2	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		3	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Lines 10-12 INSERT INTO `authorised_values` (category, authorised_value, lib, lib_opac) VALU Link Here

(-)a/installer/data/mysql/uk-UA/mandatory/auth_values.sql (-1 / +6 lines)
10	-- Housebound	10	-- Housebound
11	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES	11	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES
12	('HSBND_FREQ','EW','Кожного тижня');	12	('HSBND_FREQ','EW','Кожного тижня');
13	-	13
		14	-- Checkout types
		15	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac)
		16	VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
		17	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac)
		18	VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');

Return to bug 25037

Lines 50-55 tables: Link Here

(-)a/installer/data/mysql/en/mandatory/auth_values.yml (+10 lines)
50	lib: "Creditcard via SIP2"	50	lib: "Creditcard via SIP2"
51	lib_opac: "Creditcard"	51	lib_opac: "Creditcard"
52		52
		53	- category: "CHECKOUT_TYPE"
		54	authorised_value: "C"
		55	lib: "Normal checkout"
		56	lib_opac: "Normal checkout"
		57
		58	- category: "CHECKOUT_TYPE"
		59	authorised_value: "OS"
		60	lib: "On-site checkout"
		61	lib_opac: "On-site checkout"
		62
53	- authorised_values:	63	- authorised_values:
54	translatable: [ lib ]	64	translatable: [ lib ]
55	multiline: []	65	multiline: []