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

(-)a/installer/data/mysql/en/optional/sample_itemtypes.yml (-8 / +8 lines)
Lines 29-82 tables: Link Here
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: ""
(-)a/installer/data/mysql/it-IT/optional/sample_itemtypes.sql (-7 / +7 lines)
Lines 1-12 Link Here
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;
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql (-7 / +7 lines)
Lines 20-30 Link Here
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,'','');
(-)a/installer/data/mysql/pl-PL/optional/sample_itemtypes.sql (-7 / +7 lines)
Lines 1-9 Link Here
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,'','');
(-)a/installer/data/mysql/ru-RU/optional/library_item_types.sql (-7 / +7 lines)
Lines 2-12 SET foreign_key_checks = 0; Link Here
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,'','');
(-)a/t/db_dependent/Search.t (-7 / +7 lines)
Lines 293-306 sub run_marc21_search_tests { Link Here
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');
(-)a/t/db_dependent/Suggestions.t (-9 / +8 lines)
Lines 48-61 t::lib::Mocks::mock_preference( "EmailPurchaseSuggestions", "0"); Link Here
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
- 

Return to bug 23148