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