Attachment #106485 for bug #23148

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




          description: "Books"
          rentalcharge: 0
          notforloan: 0
          imageurl: "bridge/book.png"
          summary: ""

        - itemtype: MX
          description: "Mixed Materials"
          rentalcharge: 5
          notforloan: 0
          imageurl: "bridge/kit.png"
          summary: ""

        - itemtype: CF
          description: "Computer Files"
          rentalcharge: 5
          notforloan: 0
          imageurl: "bridge/computer_file.png"
          summary: ""

        - itemtype: MP
          description: "Maps"
          rentalcharge: 5
          notforloan: 0
          imageurl: "bridge/map.png"
          summary: ""

        - itemtype: VM
          description: "Visual Materials"
          rentalcharge: 5
          notforloan: 1
          imageurl: "bridge/dvd.png"
          summary: ""

        - itemtype: MU
          description: "Music"
          rentalcharge: 5
          notforloan: 0
          imageurl: "bridge/sound.png"
          summary: ""

        - itemtype: CR
          description: "Continuing Resources"
          rentalcharge: 5
          notforloan: 0
          imageurl: "bridge/periodical.png"
          summary: ""

        - itemtype: REF
          description: "Reference"
          rentalcharge: 0
          notforloan: 1
          imageurl: "bridge/reference.png"
          summary: ""




SET FOREIGN_KEY_CHECKS=0;

INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.png','');
INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');

SET FOREIGN_KEY_CHECKS=1;

Lines 20-30 Link Here

(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql (-7 / +7 lines)
20	-- along with Koha; if not, see <http://www.gnu.org/licenses>.	20	-- along with Koha; if not, see <http://www.gnu.org/licenses>.
21		21
22	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES	22	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
23	('BK', 'Bøker',0,0,'bridge/book.gif',''),	23	('BK', 'Bøker',0,0,'bridge/book.png',''),
24	('MX', 'Blandet innhold',0,0,'bridge/kit.gif',''),	24	('MX', 'Blandet innhold',0,0,'bridge/kit.png',''),
25	('CF', 'Datafiler',0,0,'bridge/computer_file.gif',''),	25	('CF', 'Datafiler',0,0,'bridge/computer_file.png',''),
26	('MP', 'Kart',0,0,'bridge/map.gif',''),	26	('MP', 'Kart',0,0,'bridge/map.png',''),
27	('VM', 'Visuelt materiale',0,1,'bridge/dvd.gif',''),	27	('VM', 'Visuelt materiale',0,1,'bridge/dvd.png',''),
28	('MU', 'Musikk',5,0,'bridge/sound.gif',''),	28	('MU', 'Musikk',5,0,'bridge/sound.png',''),
29	('CR', 'Periodika',0,0,'bridge/periodical.gif',''),	29	('CR', 'Periodika',0,0,'bridge/periodical.png',''),
30	('REF', 'Oppslagsverk',0,1,'','');	30	('REF', 'Oppslagsverk',0,1,'','');

Lines 1-9 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql (-7 / +7 lines)
1	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES	1	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
2	('BK', 'Książki',0,0,'bridge/book.gif',''),	2	('BK', 'Książki',0,0,'bridge/book.png',''),
3	('MX', 'Materiały mieszane',5,0,'bridge/kit.gif',''),	3	('MX', 'Materiały mieszane',5,0,'bridge/kit.png',''),
4	('CF', 'Pliki komputerowe',5,0,'bridge/computer_file.gif',''),	4	('CF', 'Pliki komputerowe',5,0,'bridge/computer_file.png',''),
5	('MP', 'Mapy',5,0,'bridge/map.gif',''),	5	('MP', 'Mapy',5,0,'bridge/map.png',''),
6	('VM', 'Materiały wziualne',5,1,'bridge/dvd.gif',''),	6	('VM', 'Materiały wziualne',5,1,'bridge/dvd.png',''),
7	('MU', 'Muzyka',5,0,'bridge/sound.gif',''),	7	('MU', 'Muzyka',5,0,'bridge/sound.png',''),
8	('CR', 'Wydawnictwa ciągłe',5,0,'bridge/periodical.gif',''),	8	('CR', 'Wydawnictwa ciągłe',5,0,'bridge/periodical.png',''),
9	('REF', 'Reference',0,1,'','');	9	('REF', 'Reference',0,1,'','');

Lines 2-12 SET foreign_key_checks = 0; Link Here

(-)a/installer/data/mysql/ru-RU/optional/library_item_types.sql (-7 / +7 lines)
2	TRUNCATE itemtypes;	2	TRUNCATE itemtypes;
3	SET foreign_key_checks = 1;	3	SET foreign_key_checks = 1;
4	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES	4	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
5	('BK', ' Книги',0,0,'bridge/book.gif',''),	5	('BK', ' Книги',0,0,'bridge/book.png',''),
6	('MX', 'Смешанные атериалы',5,0,'bridge/kit.gif',''),	6	('MX', 'Смешанные атериалы',5,0,'bridge/kit.png',''),
7	('CF', 'Компьютерные файлы',5,0,'bridge/computer_file.gif',''),	7	('CF', 'Компьютерные файлы',5,0,'bridge/computer_file.png',''),
8	('MP', 'Карты',5,0,'bridge/map.gif',''),	8	('MP', 'Карты',5,0,'bridge/map.png',''),
9	('VM', 'Визуальные материалы',5,1,'bridge/dvd.gif',''),	9	('VM', 'Визуальные материалы',5,1,'bridge/dvd.png',''),
10	('MU', 'Музыка',5,0,'bridge/sound.gif',''),	10	('MU', 'Музыка',5,0,'bridge/sound.png',''),
11	('CR', 'Продолжающиеся ресурсы',5,0,'bridge/periodical.gif',''),	11	('CR', 'Продолжающиеся ресурсы',5,0,'bridge/periodical.png',''),
12	('REF', 'Справочники',0,1,'','');	12	('REF', 'Справочники',0,1,'','');




        'UPL' => { 'branchaddress1' => 'Chestnut Hollow', 'branchcode' => 'UPL', 'branchname' => 'Union', },
    );
    my %itemtypes = (
        'BK' => { 'imageurl' => 'bridge/book.png', 'summary' => '', 'itemtype' => 'BK', 'description' => 'Books' },
        'CF' => { 'imageurl' => 'bridge/computer_file.png', 'summary' => '', 'itemtype' => 'CF', 'description' => 'Computer Files' },
        'CR' => { 'imageurl' => 'bridge/periodical.png', 'summary' => '', 'itemtype' => 'CR', 'description' => 'Continuing Resources' },
        'MP' => { 'imageurl' => 'bridge/map.png', 'summary' => '', 'itemtype' => 'MP', 'description' => 'Maps' },
        'MU' => { 'imageurl' => 'bridge/sound.png', 'summary' => '', 'itemtype' => 'MU', 'description' => 'Music' },
        'MX' => { 'imageurl' => 'bridge/kit.png', 'summary' => '', 'itemtype' => 'MX', 'description' => 'Mixed Materials' },
        'REF' => { 'imageurl' => '', 'summary' => '', 'itemtype' => 'REF', 'description' => 'Reference' },
        'VM' => { 'imageurl' => 'bridge/dvd.png', 'summary' => '', 'itemtype' => 'VM', 'description' => 'Visual Materials' },
    );

    index_sample_records_and_launch_zebra($datadir, 'marc21');




$dbh->do(q|DELETE FROM itemtypes;|);
my $sql = qq|
INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
('BK', 'Books',5,0,'bridge/book.png',''),
('MX', 'Mixed Materials',5,0,'bridge/kit.png',''),
('CF', 'Computer Files',5,0,'bridge/computer_file.png',''),
('MP', 'Maps',5,0,'bridge/map.png',''),
('VM', 'Visual Materials',5,1,'bridge/dvd.png',''),
('MU', 'Music',5,0,'bridge/sound.png',''),
('CR', 'Continuing Resources',5,0,'bridge/periodical.png',''),
('REF', 'Reference',0,1,'bridge/reference.png','');|;
$dbh->do($sql);
$dbh->do(q|DELETE FROM suggestions|);
$dbh->do(q|DELETE FROM issues|);
- 

Return to bug 23148

Lines 29-82 tables: Link Here

(-)a/installer/data/mysql/en/optional/sample_itemtypes.yml (-8 / +8 lines)
29	description: "Books"	29	description: "Books"
30	rentalcharge: 0	30	rentalcharge: 0
31	notforloan: 0	31	notforloan: 0
32	imageurl: "bridge/book.gif"	32	imageurl: "bridge/book.png"
33	summary: ""	33	summary: ""
34		34
35	- itemtype: MX	35	- itemtype: MX
36	description: "Mixed Materials"	36	description: "Mixed Materials"
37	rentalcharge: 5	37	rentalcharge: 5
38	notforloan: 0	38	notforloan: 0
39	imageurl: "bridge/kit.gif"	39	imageurl: "bridge/kit.png"
40	summary: ""	40	summary: ""
41		41
42	- itemtype: CF	42	- itemtype: CF
43	description: "Computer Files"	43	description: "Computer Files"
44	rentalcharge: 5	44	rentalcharge: 5
45	notforloan: 0	45	notforloan: 0
46	imageurl: "bridge/computer_file.gif"	46	imageurl: "bridge/computer_file.png"
47	summary: ""	47	summary: ""
48		48
49	- itemtype: MP	49	- itemtype: MP
50	description: "Maps"	50	description: "Maps"
51	rentalcharge: 5	51	rentalcharge: 5
52	notforloan: 0	52	notforloan: 0
53	imageurl: "bridge/map.gif"	53	imageurl: "bridge/map.png"
54	summary: ""	54	summary: ""
55		55
56	- itemtype: VM	56	- itemtype: VM
57	description: "Visual Materials"	57	description: "Visual Materials"
58	rentalcharge: 5	58	rentalcharge: 5
59	notforloan: 1	59	notforloan: 1
60	imageurl: "bridge/dvd.gif"	60	imageurl: "bridge/dvd.png"
61	summary: ""	61	summary: ""
62		62
63	- itemtype: MU	63	- itemtype: MU
64	description: "Music"	64	description: "Music"
65	rentalcharge: 5	65	rentalcharge: 5
66	notforloan: 0	66	notforloan: 0
67	imageurl: "bridge/sound.gif"	67	imageurl: "bridge/sound.png"
68	summary: ""	68	summary: ""
69		69
70	- itemtype: CR	70	- itemtype: CR
71	description: "Continuing Resources"	71	description: "Continuing Resources"
72	rentalcharge: 5	72	rentalcharge: 5
73	notforloan: 0	73	notforloan: 0
74	imageurl: "bridge/periodical.gif"	74	imageurl: "bridge/periodical.png"
75	summary: ""	75	summary: ""
76		76
77	- itemtype: REF	77	- itemtype: REF
78	description: "Reference"	78	description: "Reference"
79	rentalcharge: 0	79	rentalcharge: 0
80	notforloan: 1	80	notforloan: 1
81	imageurl: "bridge/reference.gif"	81	imageurl: "bridge/reference.png"
82	summary: ""	82	summary: ""

Lines 293-306 sub run_marc21_search_tests { Link Here

(-)a/t/db_dependent/Search.t (-7 / +7 lines)
293	'UPL' => { 'branchaddress1' => 'Chestnut Hollow', 'branchcode' => 'UPL', 'branchname' => 'Union', },	293	'UPL' => { 'branchaddress1' => 'Chestnut Hollow', 'branchcode' => 'UPL', 'branchname' => 'Union', },
294	);	294	);
295	my %itemtypes = (	295	my %itemtypes = (
296	'BK' => { 'imageurl' => 'bridge/book.gif', 'summary' => '', 'itemtype' => 'BK', 'description' => 'Books' },	296	'BK' => { 'imageurl' => 'bridge/book.png', 'summary' => '', 'itemtype' => 'BK', 'description' => 'Books' },
297	'CF' => { 'imageurl' => 'bridge/computer_file.gif', 'summary' => '', 'itemtype' => 'CF', 'description' => 'Computer Files' },	297	'CF' => { 'imageurl' => 'bridge/computer_file.png', 'summary' => '', 'itemtype' => 'CF', 'description' => 'Computer Files' },
298	'CR' => { 'imageurl' => 'bridge/periodical.gif', 'summary' => '', 'itemtype' => 'CR', 'description' => 'Continuing Resources' },	298	'CR' => { 'imageurl' => 'bridge/periodical.png', 'summary' => '', 'itemtype' => 'CR', 'description' => 'Continuing Resources' },
299	'MP' => { 'imageurl' => 'bridge/map.gif', 'summary' => '', 'itemtype' => 'MP', 'description' => 'Maps' },	299	'MP' => { 'imageurl' => 'bridge/map.png', 'summary' => '', 'itemtype' => 'MP', 'description' => 'Maps' },
300	'MU' => { 'imageurl' => 'bridge/sound.gif', 'summary' => '', 'itemtype' => 'MU', 'description' => 'Music' },	300	'MU' => { 'imageurl' => 'bridge/sound.png', 'summary' => '', 'itemtype' => 'MU', 'description' => 'Music' },
301	'MX' => { 'imageurl' => 'bridge/kit.gif', 'summary' => '', 'itemtype' => 'MX', 'description' => 'Mixed Materials' },	301	'MX' => { 'imageurl' => 'bridge/kit.png', 'summary' => '', 'itemtype' => 'MX', 'description' => 'Mixed Materials' },
302	'REF' => { 'imageurl' => '', 'summary' => '', 'itemtype' => 'REF', 'description' => 'Reference' },	302	'REF' => { 'imageurl' => '', 'summary' => '', 'itemtype' => 'REF', 'description' => 'Reference' },
303	'VM' => { 'imageurl' => 'bridge/dvd.gif', 'summary' => '', 'itemtype' => 'VM', 'description' => 'Visual Materials' },	303	'VM' => { 'imageurl' => 'bridge/dvd.png', 'summary' => '', 'itemtype' => 'VM', 'description' => 'Visual Materials' },
304	);	304	);
305		305
306	index_sample_records_and_launch_zebra($datadir, 'marc21');	306	index_sample_records_and_launch_zebra($datadir, 'marc21');

Lines 1-12 Link Here

(-)a/installer/data/mysql/it-IT/optional/sample_itemtypes.sql (-7 / +7 lines)
1	SET FOREIGN_KEY_CHECKS=0;	1	SET FOREIGN_KEY_CHECKS=0;
2		2
3	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.gif','');	3	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.png','');
4	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.gif','');	4	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.png','');
5	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.gif','');	5	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.png','');
6	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.gif','');	6	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.png','');
7	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.gif','');	7	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.png','');
8	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.gif','');	8	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.png','');
9	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.gif','');	9	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.png','');
10	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');	10	INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');
11		11
12	SET FOREIGN_KEY_CHECKS=1;	12	SET FOREIGN_KEY_CHECKS=1;

Lines 48-61 t::lib::Mocks::mock_preference( "EmailPurchaseSuggestions", "0"); Link Here

(-)a/t/db_dependent/Suggestions.t (-9 / +8 lines)
48	$dbh->do(q\|DELETE FROM itemtypes;\|);	48	$dbh->do(q\|DELETE FROM itemtypes;\|);
49	my $sql = qq\|	49	my $sql = qq\|
50	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES	50	INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
51	('BK', 'Books',5,0,'bridge/book.gif',''),	51	('BK', 'Books',5,0,'bridge/book.png',''),
52	('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''),	52	('MX', 'Mixed Materials',5,0,'bridge/kit.png',''),
53	('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''),	53	('CF', 'Computer Files',5,0,'bridge/computer_file.png',''),
54	('MP', 'Maps',5,0,'bridge/map.gif',''),	54	('MP', 'Maps',5,0,'bridge/map.png',''),
55	('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''),	55	('VM', 'Visual Materials',5,1,'bridge/dvd.png',''),
56	('MU', 'Music',5,0,'bridge/sound.gif',''),	56	('MU', 'Music',5,0,'bridge/sound.png',''),
57	('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''),	57	('CR', 'Continuing Resources',5,0,'bridge/periodical.png',''),
58	('REF', 'Reference',0,1,'bridge/reference.gif','');\|;	58	('REF', 'Reference',0,1,'bridge/reference.png','');\|;
59	$dbh->do($sql);	59	$dbh->do($sql);
60	$dbh->do(q\|DELETE FROM suggestions\|);	60	$dbh->do(q\|DELETE FROM suggestions\|);
61	$dbh->do(q\|DELETE FROM issues\|);	61	$dbh->do(q\|DELETE FROM issues\|);
62	-