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

(-)a/installer/data/mysql/fi-FI/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql (-8 / +8 lines)
Lines 7-13 Link Here
7
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
7
-- SIMPLE BOOKS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
8
-- *******************************************************************
8
-- *******************************************************************
9
INSERT IGNORE INTO biblio_framework VALUES
9
INSERT IGNORE INTO biblio_framework VALUES
10
		( 'BKS', 'Books, Booklets, Workbooks' );
10
		( 'BKS', 'Kirja' );
11
11
12
INSERT IGNORE INTO marc_tag_structure (
12
INSERT IGNORE INTO marc_tag_structure (
13
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
13
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 30-36 INSERT IGNORE INTO marc_subfield_structure ( Link Here
30
-- SIMPLE COMPUTER FILES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
30
-- SIMPLE COMPUTER FILES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
31
-- ****************************************************************************
31
-- ****************************************************************************
32
INSERT IGNORE INTO biblio_framework VALUES
32
INSERT IGNORE INTO biblio_framework VALUES
33
		( 'CF', 'CD-ROMs, DVD-ROMs, General Online Resources' );
33
		( 'CF', 'CD-ROM, DVD-ROM, verkkojulkaisu' );
34
INSERT IGNORE INTO marc_tag_structure (
34
INSERT IGNORE INTO marc_tag_structure (
35
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
35
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
36
	SELECT
36
	SELECT
Lines 53-59 INSERT IGNORE INTO marc_subfield_structure ( Link Here
53
-- SIMPLE SOUND RECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
53
-- SIMPLE SOUND RECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
54
-- *****************************************************************************
54
-- *****************************************************************************
55
INSERT IGNORE INTO biblio_framework VALUES
55
INSERT IGNORE INTO biblio_framework VALUES
56
		( 'SR', 'Audio Cassettes, CDs' );
56
		( 'SR', 'Äänite, CD-levy' );
57
57
58
INSERT IGNORE INTO marc_tag_structure (
58
INSERT IGNORE INTO marc_tag_structure (
59
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
59
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 77-83 INSERT IGNORE INTO marc_subfield_structure ( Link Here
77
-- SIMPLE VIDEORECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
77
-- SIMPLE VIDEORECORDINGS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
78
-- ****************************************************************************
78
-- ****************************************************************************
79
INSERT IGNORE INTO biblio_framework VALUES
79
INSERT IGNORE INTO biblio_framework VALUES
80
		( 'VR', 'DVDs, VHS' );
80
		( 'VR', 'DVD-levy, VHS' );
81
81
82
INSERT IGNORE INTO marc_tag_structure (
82
INSERT IGNORE INTO marc_tag_structure (
83
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
83
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 101-107 INSERT IGNORE INTO marc_subfield_structure ( Link Here
101
-- SIMPLE 3D ARTIFACTS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
101
-- SIMPLE 3D ARTIFACTS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
102
-- **************************************************************************
102
-- **************************************************************************
103
INSERT IGNORE INTO biblio_framework VALUES
103
INSERT IGNORE INTO biblio_framework VALUES
104
		( 'AR', 'Models' );
104
		( 'AR', 'Esine' );
105
105
106
INSERT IGNORE INTO marc_tag_structure (
106
INSERT IGNORE INTO marc_tag_structure (
107
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
107
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 125-131 INSERT IGNORE INTO marc_subfield_structure ( Link Here
125
-- SIMPLE KITS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
125
-- SIMPLE KITS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
126
-- ******************************************************************
126
-- ******************************************************************
127
INSERT IGNORE INTO biblio_framework VALUES
127
INSERT IGNORE INTO biblio_framework VALUES
128
		( 'KT', 'Kits' );
128
		( 'KT', 'Moniviestin' );
129
129
130
INSERT IGNORE INTO marc_tag_structure (
130
INSERT IGNORE INTO marc_tag_structure (
131
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
131
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 149-155 INSERT IGNORE INTO marc_subfield_structure ( Link Here
149
-- SIMPLE INTEGRATING RESOURCES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
149
-- SIMPLE INTEGRATING RESOURCES KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
150
-- **********************************************************************************
150
-- **********************************************************************************
151
INSERT IGNORE INTO biblio_framework VALUES
151
INSERT IGNORE INTO biblio_framework VALUES
152
		( 'IR', 'Binders' );
152
		( 'IR', 'Koosteinen aineisto' );
153
153
154
INSERT IGNORE INTO marc_tag_structure (
154
INSERT IGNORE INTO marc_tag_structure (
155
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
155
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
Lines 173-179 INSERT IGNORE INTO marc_subfield_structure ( Link Here
173
-- SIMPLE SERIALS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
173
-- SIMPLE SERIALS KOHA RECORD AND HOLDINGS MANAGEMENT FIELDS/SUBFIELDS.
174
-- *********************************************************************
174
-- *********************************************************************
175
INSERT IGNORE INTO biblio_framework VALUES
175
INSERT IGNORE INTO biblio_framework VALUES
176
		( 'SER', 'Serials' );
176
		( 'SER', 'Kausijulkaisu' );
177
177
178
INSERT IGNORE INTO marc_tag_structure (
178
INSERT IGNORE INTO marc_tag_structure (
179
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
179
		tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
(-)a/installer/data/mysql/fi-FI/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt (-9 / +9 lines)
Lines 1-10 Link Here
1
Simple MARC 21 bibliographic frameworks for some common types of bibliographic material.  Frameworks are used to define the structure of your MARC records and the behavior of the integrated MARC editor. You can change these at any time after installation. The frameworks in this optional default setting include:
1
MARC21 luettelointipohjia yleisille bibliografisille aineistoille. Luettelointipohjia käytetään määrittämään MARC tietueiden rakenne ja integroidun MARC editorin toiminta. Voit muuttaa näitä arvoja milloin tahansa asennuksen jälkeen. Pohjat tässä valinnaisessa listassa ovat:
2
2
3
BKS	Books, Booklets, Workbooks
3
BKS Kirja
4
CF	CD-ROMs, DVD-ROMs, General Online Resources
4
CF	CD-ROM, DVD-ROM, verkkojulkaisu
5
SR	Audio Cassettes, CDs
5
SR	Äänite, CD-levy
6
VR	DVDs, VHS
6
VR	DVD-levy, VHS
7
AR	Models
7
AR	Esine
8
KT	Kits
8
KT	Moniviestin
9
IR	Binders
9
IR	Koosteinen aineisto
10
SER	Serials
10
SER	Kausijulkaisu
(-)a/installer/data/mysql/fi-FI/optional/auth_val.sql (-53 / +53 lines)
Lines 1-85 Link Here
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
2
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
2
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Suosittu teos');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Shelf Copy Damaged');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vahingoittunut');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Kirjaston nide kadonnut');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Saatavilla kaukopalvelussa');
6
6
7
-- Desired formats for requesting new materials
7
-- Desired formats for requesting new materials
8
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book');
8
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Kirja', 'Kirja');
9
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print');
9
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Isotekstinen', 'Isotekstinen');
10
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
10
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'E-kirja', 'E-kirja');
11
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
11
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Äänikirja', 'Äänikirja');
12
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
12
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
13
13
14
-- availability statuses
14
-- availability statuses
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Palauttamatta (Kadonnut)');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Kadonnut');
17
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
17
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Kadonnut ja maksettu');
18
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
18
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Puuttuva');
19
19
20
-- damaged status of an item
20
-- damaged status of an item
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Vahingoittunut');
22
22
23
-- location qualification for an item, departments are linked by default to items.location
23
-- location qualification for an item, departments are linked by default to items.location
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiktio');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Children\'s Area');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Lapset');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','On Display');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','Näyteikkuna');
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','New Materials Shelf');
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Uutuushylly');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Staff Office');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Henkilökunta');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Yleinen');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audiovisuaalinen');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Käsikirjasto');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Kärry');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Käsittelykeskus');
34
34
35
-- collection codes for an item
35
-- collection codes for an item
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiktio');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Käsikirjasto');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non-fiction');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Tietokirjallisuus');
39
39
40
-- withdrawn status of an item, linked to items.withdrawn
40
-- withdrawn status of an item, linked to items.withdrawn
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Pois kierrosta');
42
42
43
-- loanability status of an item, linked to items.notforloan
43
-- loanability status of an item, linked to items.notforloan
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Tilattu');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Ei lainata');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Henkilökunnan kokoelmassa');
47
47
48
-- restricted status of an item, linked to items.restricted
48
-- restricted status of an item, linked to items.restricted
49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Rajoitettu oikeus');
50
50
51
-- manual invoice types
51
-- manual invoice types
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Copier Fees','.25');
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Kopiokonemaksu','.25');
53
53
54
-- custom borrower notes
54
-- custom borrower notes
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes');
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Osoitteen lisätiedot');
56
56
57
-- OPAC Suggestions reasons
57
-- OPAC Suggestions reasons
58
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged');
58
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','Nide on vahingoittunut','Nide on vahingoittunut');
59
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author');
59
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Suositun tekijän uutuusteos','Suositun tekijän uutuusteos');
60
60
61
-- Report groups
61
-- Report groups
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Lainaus');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Catalog');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Luettelo');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Patrons');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Asiakkaat');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Hankinta');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Maksut');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Serials');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Lehdet');
68
68
69
-- SIP2 media types
69
-- SIP2 media types
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Muu');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '001', 'Book');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '001', 'Kirja');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '002', 'Magazine');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '002', 'Lehti');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '003', 'Bound journal');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '003', 'Bound journal');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '004', 'Audio tape');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '004', 'Audio');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '005', 'Video tape');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '005', 'Video');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '006', 'CD/CDROM');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '006', 'CD/CDROM');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '007', 'Diskette');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '007', 'Disketti');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Kirja jossa disketti');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Kirja jossa CD');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Kirja jossa audionauha');
81
81
82
-- order cancellation reasons
82
-- order cancellation reasons
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'Ei syytä');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Loppu varastosta');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Varastoa täydennetään');
(-)a/installer/data/mysql/fi-FI/optional/auth_val.txt (-1 / +1 lines)
Line 1 Link Here
1
Some basic default authorised values for library locations, item lost status, etc. You can change these at any time after installation.
1
Auktorisoidut arvot, kuten hyllypaikat ja niteen tilat. Voit muuttaa näitä arvoja myöhemmin hallintapaneelista.
(-)a/installer/data/mysql/fi-FI/optional/marc21_holdings_coded_values.sql (-22 / +22 lines)
Lines 9-15 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes');
10
10
11
-- Physical Form Designators
11
-- Physical Form Designators
12
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Cartographic material');
12
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Kartta');
13
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas');
13
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram');
15
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map');
15
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map');
Lines 20-26 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
20
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view');
20
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view');
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other');
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other');
22
22
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Computer file');
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Elektroninen aineisto');
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge');
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge');
Lines 28-34 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Computer file, optical disk');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Optinen levy');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other');
34
34
Lines 39-47 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon');
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other');
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other');
41
41
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Kit');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Moniviestin');
43
43
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Microform');
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Mikrotallenne');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette');
Lines 51-67 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
51
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque');
51
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque');
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other');
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other');
53
53
54
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Motion picture');
54
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Elokuva');
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge');
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge');
56
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette');
56
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette');
57
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel');
57
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel');
58
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other');
58
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other');
59
59
60
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Nonprojected graphic');
60
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Kuva');
61
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage');
61
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage');
62
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing');
62
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing');
63
63
64
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Nonprojected graphic, painting');
64
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Piirustus');
65
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print');
65
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print');
66
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative');
66
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative');
67
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint');
67
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint');
Lines 72-78 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
72
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card');
72
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card');
73
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other');
73
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other');
74
74
75
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Notated music');
75
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Nuottijulkaisu');
76
76
77
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic');
77
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic');
78
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge');
78
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge');
Lines 85-112 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
85
85
86
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image');
86
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image');
87
87
88
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Sound recording');
88
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Äänite');
89
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Sound recording, sound disk');
89
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Äänilevy');
90
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder');
90
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder');
91
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge');
91
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge');
92
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film');
92
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film');
93
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll');
93
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll');
94
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'Sound recording, sound cassette');
94
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'C-kasetti');
95
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel');
95
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel');
96
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording');
96
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording');
97
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other');
97
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other');
98
98
99
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Text');
99
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Teksti');
100
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Text, regular print');
100
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Kirja');
101
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Text, large print');
101
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Isoteksti');
102
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Text, Braille');
102
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Pistekirjoitus');
103
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf');
103
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf');
104
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other');
104
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other');
105
105
106
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videorecording');
106
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videotallenne');
107
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge');
107
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge');
108
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'Videorecording, videodisc');
108
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'DVD, Blu-ray');
109
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'Videorecording, videocassette');
109
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'VHS videokasetti');
110
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel');
110
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel');
111
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other');
111
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other');
112
112
Lines 127-135 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS Link Here
127
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited');
127
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited');
128
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other');
128
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other');
129
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased');
129
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased');
130
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','On order');
130
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','Tilattu');
131
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Currently received');
131
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Saapunut');
132
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Not currently received');
132
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Ei saapunut');
133
133
134
-- General Holdings: Retention Designator
134
-- General Holdings: Retention Designator
135
-- This data element specifies the retention policy for the unit at the time of the holdings report.
135
-- This data element specifies the retention policy for the unit at the time of the holdings report.
(-)a/installer/data/mysql/fi-FI/optional/marc21_relatorterms.sql (-63 / +63 lines)
Lines 2-59 Link Here
2
-- http://www.loc.gov/marc/relators/relacode.html
2
-- http://www.loc.gov/marc/relators/relacode.html
3
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Näyttelijä');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Muokkaaja');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Jälkisanojen, kolofonin jne. tekijä');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animaattori');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Muistiinpanojen tekijä');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Lainausten tai tiivistelmän tekijä');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Sovittaja');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Kuvataiteilija, graafikko');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Kohteeseen liittyvä nimi');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Oletettu/väitetty tekijä');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Esipuheen tekijä');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Käsikirjoittaja');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Tekijä');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Sitoja');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Koreografi');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Selostaja');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Säveltäjä');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Kuvaaja');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Johtaja');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Kokoaja');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Tekijänoikeuden omistaja');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
Lines 62-123 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERM Link Here
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Avustaja');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Kartoittaja');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Tekstin kommentaattori');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Tanssija');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Piirtäjä');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Ohjaaja');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Suunnittelija');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Jakaja');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Kyseenalainen tekijä');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Toimittaja');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Kaivertaja');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Jäljenteen toteuttaja');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Leikkaaja');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Juhlajulkaisun kohde');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Kuvittaja');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Soittaja');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Haastateltava');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Haastattelija');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Libretisti');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
Lines 132-161 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERM Link Here
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Sanoittaja');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadatakontakti');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Muusikko');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Kertoja');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Muu');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Omistaja');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Päätoimittaja');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Julkaisija');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Valokuvaaja');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
Lines 163-175 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERM Link Here
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Tuotantohenkilökunta');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Esittäjä');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Tuottaja');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Painaja');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
Lines 177-191 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERM Link Here
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Äänittäjä');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Kriitikko');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Vastaava toimittaja');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
Lines 198-226 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERM Link Here
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Laulaja');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Puhuja');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Lavastaja');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Opettaja');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Kääntäjä');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Laulusolisti');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Liiteaineiston tekijä');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');
(-)a/installer/data/mysql/fi-FI/optional/parameters.sql (-2 / +2 lines)
Lines 1-5 Link Here
1
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
1
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2
('USD', 1.0, '$', '1'),
2
('USD', 1.0, '$', '0'),
3
('GBP', 1.9929, '£', '0'),
3
('GBP', 1.9929, '£', '0'),
4
('CAD', 1.02207, '$', '0'),
4
('CAD', 1.02207, '$', '0'),
5
('EUR', .874003, '€', '0');
5
('EUR', .874003, '€', '1');
(-)a/installer/data/mysql/fi-FI/optional/parameters.txt (-1 / +1 lines)
Line 1 Link Here
1
Some basic currencies with USA dollar as default for ACQ module
1
Valuutat ja euro oletusvaluuttana
(-)a/installer/data/mysql/fi-FI/optional/patron_atributes.sql (-1 / +1 lines)
Lines 1-2 Link Here
1
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `staff_searchable`, `authorised_value_category`)
1
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `staff_searchable`, `authorised_value_category`)
2
VALUES ('SHOW_BCODE',  'Show barcode on the summary screen items listings', 0, 0, 1, 0, 'YES_NO');
2
VALUES ('SHOW_BCODE',  'Näytä viivakoodi niteiden yhteenvetosivulla', 0, 0, 1, 0, 'YES_NO');
(-)a/installer/data/mysql/fi-FI/optional/patron_atributes.txt (-2 / +2 lines)
Lines 1-2 Link Here
1
Useful patron attribute types:
1
Hyödyllisiä asiakasmääreitä:
2
* SHOW_BCODE - Show barcode on the patron summary screen items listings
2
* SHOW_BCODE - Näytä viivakoodi niteiden yhteenvetosivulla
(-)a/installer/data/mysql/fi-FI/optional/patron_categories.sql (-12 / +12 lines)
Lines 1-23 Link Here
1
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
1
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
2
2
3
-- Adult Patrons
3
-- Adult Patrons
4
('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
4
('PT','Asiakas',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5
('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5
('ST','Opiskelija',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6
('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6
('HB','Kotona pysyvä',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
7
7
8
-- Children
8
-- Children
9
('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
9
('K','Lapsi',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10
('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10
('J','Nuori',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11
('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11
('YA','Nuori aikuinen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
12
12
13
-- Professionals
13
-- Professionals
14
('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
14
('T','Opettaja',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
15
('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
15
('B','Hallituksen jäsen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
16
16
17
-- Institutional
17
-- Institutional
18
('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
18
('IL','Kaukopalvelu',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19
('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19
('SC','Koulu',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20
('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20
('L','Kirjasto',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
21
21
22
-- Staff
22
-- Staff
23
('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
23
('S','Virkailija',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
(-)a/installer/data/mysql/fi-FI/optional/patron_categories.txt (-17 / +17 lines)
Lines 1-21 Link Here
1
Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module.
1
Asiakaskategoriat. Voit muuttaa näitä kategorioita asennuksen jälkeen hallintapaneelista.
2
2
3
Adult patron - default patron type
3
Aikuinen asiakas - Oletusasiakastyyppi
4
                PT  - Patron
4
                PT  - Asiakas
5
                ST  - Student
5
                ST  - Opiskelija
6
                BH  - Homebound
6
                BH  - Kotona pysyvä
7
7
8
Child - patron with a guarantor
8
Lapsi - asiakas, jolla on huoltaja
9
                K   - Kid
9
                K   - Lapsi
10
                J   - Juvenile
10
                J   - Nuori
11
                YA  - Young Adult
11
                YA  - Nuori aikuinen
12
12
13
Organization - patron is an institution, not a person
13
Organisaatio - asiakas on laitos, ei ihminen
14
                ILL - Inter-library Loan
14
                ILL - Kaukopalvelu
15
                SC  - School
15
                SC  - Koulu
16
                L   - Library
16
                L   - Kirjasto
17
17
18
Professional - a member of an organization (organization is guarantor)
18
Ammattilainen - asiakas on organisaation jäsen (organisaatio on huoltaja)
19
                T   - Teacher
19
                T   - Opettaja
20
                S   - Staff
20
                S   - Virkailija
21
                B   - Board
21
                B   - Hallituksen jäsen
(-)a/installer/data/mysql/fi-FI/optional/sample_holidays.sql (-3 / +7 lines)
Lines 1-4 Link Here
1
INSERT INTO `repeatable_holidays` VALUES
1
INSERT INTO `repeatable_holidays` VALUES
2
(2,'MPL',0,NULL,NULL,'','Sundays'),
2
(1,'MPL',0,NULL,NULL,'','Sunnuntait'),
3
(3,'MPL',NULL,1,1,'','New Year\'s Day'),
3
(2,'MPL',NULL,1,1,'','Uudenvuodenpäivä'),
4
(4,'MPL',NULL,25,12,'','Christmas');
4
(3,'MPL',NULL,6,1,'','Loppiainen'),
5
(4,'MPL',NULL,1,5,'','Vappu'),
6
(5,'MPL',NULL,6,12,'','Itsenäisyyspäivä'),
7
(6,'MPL',NULL,25,12,'','Joulu'),
8
(7,'MPL',NULL,26,12,'','Tapaninpäivä');
(-)a/installer/data/mysql/fi-FI/optional/sample_holidays.txt (-1 / +1 lines)
Line 1 Link Here
1
Sample holidays: Sunday, Christmas, New Year's
1
Viralliset toistuvat lomapäivät
(-)a/installer/data/mysql/fi-FI/optional/sample_itemtypes.sql (-8 / +8 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', 'Books',0,0,'bridge/book.gif',''),
2
('BK', 'Kirja',0,0,'bridge/book.gif',''),
3
('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''),
3
('MX', 'Moniviestin',5,0,'bridge/kit.gif',''),
4
('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''),
4
('CF', 'Elektroninen aineisto',5,0,'bridge/computer_file.gif',''),
5
('MP', 'Maps',5,0,'bridge/map.gif',''),
5
('MP', 'Kartta',5,0,'bridge/map.gif',''),
6
('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''),
6
('VM', 'Visuaalinen materiaali',5,1,'bridge/dvd.gif',''),
7
('MU', 'Music',5,0,'bridge/sound.gif',''),
7
('MU', 'Musiikki',5,0,'bridge/sound.gif',''),
8
('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''),
8
('CR', 'Jatkuva julkaisu',5,0,'bridge/periodical.gif',''),
9
('REF', 'Reference',0,1,'bridge/reference.gif','');
9
('REF', 'Käsikirjasto',0,1,'bridge/reference.gif','');
(-)a/installer/data/mysql/fi-FI/optional/sample_itemtypes.txt (-2 / +1 lines)
Line 1 Link Here
1
A set of default item types.
1
Nidetyypit
2
- 

Return to bug 22471