From 4a5f1ec49a081319fdc1f00311900119df90eeae Mon Sep 17 00:00:00 2001 From: Magnus Enger Date: Tue, 29 Mar 2011 16:26:47 +0200 Subject: [PATCH] Add files to installer/data/mysql/nb-NO/2-Valgfritt/ Signed-off-by: Magnus Enger --- .../data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 78 ++++++++++ .../data/mysql/nb-NO/2-Valgfritt/auth_val.txt | 1 + .../marc21_holdings_coded_values.sql | 145 ++++++++++++++++++ .../marc21_holdings_coded_values.txt | 2 + .../mysql/nb-NO/2-Valgfritt/parameters.sql | 26 ++++ .../mysql/nb-NO/2-Valgfritt/parameters.txt | 1 + .../nb-NO/2-Valgfritt/patron_categories.sql | 44 ++++++ .../nb-NO/2-Valgfritt/patron_categories.txt | 25 +++ .../nb-NO/2-Valgfritt/sample_creator_data.sql | 34 ++++ .../nb-NO/2-Valgfritt/sample_creator_data.txt | 1 + .../nb-NO/2-Valgfritt/sample_holidays.sql | 28 ++++ .../nb-NO/2-Valgfritt/sample_holidays.txt | 1 + .../nb-NO/2-Valgfritt/sample_itemtypes.sql | 29 ++++ .../nb-NO/2-Valgfritt/sample_itemtypes.txt | 1 + .../nb-NO/2-Valgfritt/sample_libraries.sql | 19 +++ .../nb-NO/2-Valgfritt/sample_libraries.txt | 1 + .../mysql/nb-NO/2-Valgfritt/sample_news.sql | 2 + .../mysql/nb-NO/2-Valgfritt/sample_news.txt | 1 + .../sample_notices_message_attributes.sql | 9 ++ .../sample_notices_message_attributes.txt | 1 + .../sample_notices_message_transports.sql | 17 ++ .../sample_notices_message_transports.txt | 1 + .../nb-NO/2-Valgfritt/sample_patrons.sql | 52 +++++++ .../nb-NO/2-Valgfritt/sample_patrons.txt | 1 + 24 files changed, 520 insertions(+) create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/auth_val.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/parameters.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_news.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.sql create mode 100644 installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.txt diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql new file mode 100644 index 0000000000..19444261e8 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql @@ -0,0 +1,78 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2011 Magnus Enger Libriotech +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +-- Reasons for acceptance or rejection of suggestions in acquisitions +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestselger'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Bibliotekets eksemplar er skadet'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotekets eksemplar er tapt'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Tilgjengelig via fjernlÃ¥n'); + +-- availability statuses +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Regnes som tapt'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Tapt'); +INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Tapt og erstattet'); +INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Savnet'); + +-- damaged status of an item +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Skadet'); + +-- location qualification for an item, departments are linked by default to items.location +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Skjønnlitteratur'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Barneavdelingen'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','PÃ¥ utstilling'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Nyhetshylla'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Ansattes kontor'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Samlingen'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','AV-materiale'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Oppslagsverk'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Boktralle'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Til klargjøring'); + +-- collection codes for an item +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Skjønnlitteratur'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Oppslagsverk'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur'); + +-- withdrawn status of an item, linked to items.wthdrawn +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake'); + +-- loanability status of an item, linked to items.notforloan +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','I bestilling'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Ikke til utlÃ¥n'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Kun til internt bruk'); + +-- restricted status of an item, linked to items.restricted +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Begrenset tilgang'); + +-- manual invoice types +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Kopiavgift','0,25'); + +-- custom borrower notes +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes'); + +-- OPAC Suggestions reasons +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','Eksemplaret pÃ¥ hylla er skadet','Eksemplaret pÃ¥ hylla er skadet'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Kommende tittel av populær forfatter','Kommende tittel av populær forfatter'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.txt b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.txt new file mode 100644 index 0000000000..c234c3fcfe --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.txt @@ -0,0 +1 @@ +Some basic default authorised values for Library Departments, Item Lost status, etc. You can change these at any time after installation. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.sql b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.sql new file mode 100644 index 0000000000..adc3ea7281 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.sql @@ -0,0 +1,145 @@ +-- Coded values conforming to the Z39.77-2006 Holdings Statements for Bibliographic Items'); +-- ISSN: 1041-5653 +-- Refer to http://www.niso.org/standards/index.html + +-- General Holdings: Type of Unit Designator +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','0','Information not available; Not applicable');INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','a','Basic bibliographic unit'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','c','Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units'); +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','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'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ak' ,'Cartographic material, profile'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aq' ,'Cartographic material, model'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ar' ,'Cartographic material, remote sensing image'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','as' ,'Cartographic material, section'); +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','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'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cf' ,'Computer file, tape cassette'); +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','cr' ,'Computer file, remote'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','du' ,'Globe'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','da' ,'Globe, celestial'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','db' ,'Globe, planetary or lunar'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dc' ,'Globe, terrestrial'); +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','hu' ,'Microform'); +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'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hd',' Microform, microfilm reel'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','he' ,'Microform, microfiche'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hf' ,'Microform, microfiche cassette'); +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','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','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','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'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ki' ,'Nonprojected graphic, picture'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kj' ,'Nonprojected graphic, print'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kl' ,'Nonprojected graphic, technical drawing'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kn' ,'Nonprojected graphic, chart'); +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','gu' ,'Projected graphic'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gd' ,'Projected graphic, filmstrip'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gf' ,'Projected graphic, other type of filmstrip'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','go' ,'Projected graphic, filmstrip roll'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gs' ,'Projected graphic, slide'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gt' ,'Projected graphic, transparency'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gz' ,'Projected graphic, other'); + +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','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','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','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','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','vr' ,'Videorecording, videoreel'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zu' ,'Physical form is unspecified'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zm' ,'Multiple physical forms'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zz' ,'Other physical media'); + +-- General Holdings: Completeness Designator +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','0','Information not available, or Retention is limited'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','1','Complete (95%-100% held)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','2','Incomplete (50%-94% held)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','3','Very incomplete or scattered (less than 50% held)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','4','Not applicable'); + +-- General Holdings: Acquisition Status Designator +-- This data element specifies acquisition status for the unit at the time of the holdings report. + +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'); + +-- General Holdings: Retention Designator +-- This data element specifies the retention policy for the unit at the time of the holdings report. + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','0','Information not available'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','1','Other'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','2','Retained except as replaced by updates'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','3','Sample issue retained'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','4','Retained until replaced by microform, or other preservation format'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','5','Retained until replaced by cumulation, replacement volume, or revision'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','6','Limited retention (only some parts kept)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','7','No retention (no parts kept)'); +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','8','Permanent retention (all parts kept permanently)'); + diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.txt b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.txt new file mode 100644 index 0000000000..ce1b6f44b6 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/marc21_holdings_coded_values.txt @@ -0,0 +1,2 @@ +Coded values conforming to the Z39.71-2006 Holdings Statements for Bibliographic Items +Refer to http://www.niso.org/standards/index.html for details. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql new file mode 100644 index 0000000000..067013742a --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql @@ -0,0 +1,26 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2011 Magnus Enger Libriotech +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +INSERT INTO `currency` (currency, rate, symbol) VALUES +('USD', 5.6157, '$'), +('NOK', 1.0, '$'), +('GBP', 8.9680, '£'), +('EUR', 7.8940, '€'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/parameters.txt b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.txt new file mode 100644 index 0000000000..e299e21550 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.txt @@ -0,0 +1 @@ +Noen vanlige valutaer. Kursene er bare tenkt som eksempler, de vil ikke bli oppdatert automatisk! diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql new file mode 100644 index 0000000000..ee10681ade --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql @@ -0,0 +1,44 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2011 Magnus Enger Libriotech +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES + +-- Adult Patrons +('PT','LÃ¥ner',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','HjemmelÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), + +-- Children +('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), +('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), +('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), + +-- Professionals +('T','Lærer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), +('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'), + +-- Institutional +('IL','FjernlÃ¥n',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), +('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), +('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), + +-- Staff +('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.txt b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.txt new file mode 100644 index 0000000000..bed85c688e --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.txt @@ -0,0 +1,25 @@ +Eksempler pÃ¥ lÃ¥ntagerkategorier og typer: + +Type: Kategori: + +Voksen lÃ¥ner - Standard + PT - LÃ¥ner + ST - Student + BH - HjemmelÃ¥ner + +Barn - lÃ¥ner med registrert foresatt + K - Barn + J - Ungsom + YA - Ung voksen + +Organisasjoner - lÃ¥neren er en korporasjon, ikke en person + ILL - FjernlÃ¥n + SC - Skole + L - Bibliotek + +Profesjonell - Medlem av en organisasjon + T - Lærer + S - Bibliotekansatt + B - Styremedlem + +Typene er foreløpig hardkodet, men du kan legge til, endre og slette kategorier i det administrative grensesnittet, etter at installasjonen er gjennomført. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql new file mode 100644 index 0000000000..bcd610a183 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql @@ -0,0 +1,34 @@ +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; + +LOCK TABLES `creator_layouts` WRITE; +/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */; +INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, callnumber','','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode',' + + + + <firstname> <surname> + + Branch: <branchcode> + + Expires: August 31, 2010 + + +','Patroncards'); +/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */; +UNLOCK TABLES; + + +LOCK TABLES `creator_templates` WRITE; +/*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */; +INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards'); +/*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */; +UNLOCK TABLES; + +LOCK TABLES `printers_profile` WRITE; +/*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */; +INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'); +/*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */; +UNLOCK TABLES; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.txt new file mode 100644 index 0000000000..1d86a56b6f --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.txt @@ -0,0 +1 @@ +Eksempler pÃ¥ data for etiketter og lÃ¥nekort. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.sql new file mode 100644 index 0000000000..7df9e67364 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.sql @@ -0,0 +1,28 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2011 Magnus Enger Libriotech +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +INSERT INTO `repeatable_holidays` VALUES +(2,'',0,NULL,NULL,'','Søndager'), +(3,'',NULL,1,1,'','1. nyttÃ¥rsdag'), +(4,'',NULL,1,5,'','1. mai'), +(5,'',NULL,17,5,'','17. mai'), +(6,'',NULL,25,12,'','1. juledag'), +(7,'',NULL,26,12,'','2. juledag'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.txt new file mode 100644 index 0000000000..33b1e1218e --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_holidays.txt @@ -0,0 +1 @@ +Eksempler pÃ¥ fridager. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql new file mode 100644 index 0000000000..c66e817d40 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.sql @@ -0,0 +1,29 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2011 Magnus Enger Libriotech +-- +-- This file is part of Koha. +-- +-- Koha is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 2 of the License, or (at your option) any later +-- version. +-- +-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along +-- with Koha; if not, write to the Free Software Foundation, Inc., +-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. + +INSERT INTO `itemtypes` VALUES ('BK', 'Bøker',5,0,'bridge/book.gif',''); +INSERT INTO `itemtypes` VALUES ('MX', 'Blandet innhold',5,0,'bridge/kit.gif',''); +INSERT INTO `itemtypes` VALUES ('CF', 'Datafiler',5,0,'bridge/computer_file.gif',''); +INSERT INTO `itemtypes` VALUES ('MP', 'Kart',5,0,'bridge/map.gif',''); +INSERT INTO `itemtypes` VALUES ('VM', 'Visuelt materiale',5,1,'bridge/dvd.gif',''); +INSERT INTO `itemtypes` VALUES ('MU', 'Musikk',5,0,'bridge/sound.gif',''); +INSERT INTO `itemtypes` VALUES ('CR', 'Periodika',5,0,'bridge/periodical.gif',''); +INSERT INTO `itemtypes` VALUES ('REF', 'Oppslagsverk',0,1,'',''); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.txt new file mode 100644 index 0000000000..e3a7f2d5ce --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_itemtypes.txt @@ -0,0 +1 @@ +Eksempler pÃ¥ materialtyper. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql new file mode 100644 index 0000000000..a2fa52e8c6 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql @@ -0,0 +1,19 @@ +-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES + +INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES + +('MPL','Midway','372 Forest Street'), +('SPL','Springfield','Highland Boulevard'), +('RPL','Riverside','Johnson Terrace'), +('CPL','Centerville','Jefferson Summit'), +('FPL','Fairview','Hickory Squere'), +('FFL','Fairfield','River Station'), +('IPT','Institut Protestant de Théologie',''), +('PVL','Pleasant Valley','Meadow Grove'), +('TPL','Troy','Valley Way'), +('FRL','Franklin','Smith Heights'), +('LPL','Liberty','East Hills'), +('UPL','Union','Chestnut Hollow') +; + +-- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.txt new file mode 100644 index 0000000000..d8f31b1b36 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.txt @@ -0,0 +1 @@ +Noen eksempel-bibliotek. Foreløpig ikke tilpasset norske forhold. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql new file mode 100644 index 0000000000..735db1b347 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.sql @@ -0,0 +1,2 @@ +INSERT INTO `opac_news` VALUES (1,'Velkommen til Koha!','Velkommen til Koha. Koha er et biblioteksystem rikt pÃ¥ funksjoner. Koha ble opprinnelig utviklet i New Zealand av Katipo Communications Ltd og først tatt i bruk i januar 2000 av Horowhenua Library Trust. I dag vedlikeholdes Koha av et verdensomspennende fellesskap av bibliotek og leverandører.','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',1), +(2,'Hva nÃ¥?','Hva kan du gjøre nÃ¥ som du har installert Koha? Her er noen forslag:\r\n\r\n','koha',DATE_SUB(NOW(), INTERVAL 1 DAY),'2099-01-10',2); \ No newline at end of file diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.txt new file mode 100644 index 0000000000..9f62fb499b --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_news.txt @@ -0,0 +1 @@ +Eksempler pÃ¥ nyheter som vises i det interne grensesnittet. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql new file mode 100644 index 0000000000..6dab837258 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.sql @@ -0,0 +1,9 @@ +insert into `message_attributes` +(`message_attribute_id`, message_name, `takes_days`) +values +(1, 'Item Due', 0), +(2, 'Advance Notice', 1), +(4, 'Hold Filled', 0), +(5, 'Item Check-in', 0), +(6, 'Item Checkout', 0); + diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt new file mode 100644 index 0000000000..14d71096ff --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_attributes.txt @@ -0,0 +1 @@ +Definerer standard meldinger for purringer og varslinger. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql new file mode 100644 index 0000000000..ae68378d13 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.sql @@ -0,0 +1,17 @@ +insert into `message_transports` +(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) +values +(1, 'email', 0, 'circulation', 'DUE'), +(1, 'email', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), +(1, 'sms', 0, 'circulation', 'DUE'), +(1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'sms', 0, 'circulation', 'PREDUE'), +(2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(4, 'sms', 0, 'reserves', 'HOLD'), +(5, 'email', 0, 'circulation', 'CHECKIN'), +(5, 'sms', 0, 'circulation', 'CHECKIN'), +(6, 'email', 0, 'circulation', 'CHECKOUT'), +(6, 'sms', 0, 'circulation', 'CHECKOUT'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt new file mode 100644 index 0000000000..25e67801a3 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_notices_message_transports.txt @@ -0,0 +1 @@ +Definerer standard meldingsmÃ¥ter for utsending av purringer og varslinger, via SMS og E-post. diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.sql new file mode 100644 index 0000000000..c520458e2f --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.sql @@ -0,0 +1,52 @@ +INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `guarantorid`, `borrowernotes`, `relationship`, `ethnicity`, `ethnotes`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES + +(1,'1','Admin','Koha',NULL,NULL,'',NULL,NULL,'',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','S',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,109,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), +(2,'23529000152273','Welch','Marcus',NULL,NULL,'',NULL,NULL,'5601 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRL','ST','1985-10-24','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'), +(3,'23529000445172','Daniels','Tanya',NULL,NULL,'',NULL,NULL,'2035 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1966-10-14','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'), +(4,'23529000105040','Dillon','Eva',NULL,NULL,'',NULL,NULL,'8916 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-03','MPL','PT','1987-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'), +(5,'23529001000463','Acosta','Edna',NULL,NULL,'',NULL,NULL,'7896 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1980-04-24','MPL','PT','1990-11-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'), +(6,'23529000591678','Glass','Virgil',NULL,NULL,'',NULL,NULL,'6250 Library Rd.',NULL,'Santa Cruz, CA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1974-06-19','SPL','T','1985-02-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,102,NULL,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'), +(7,'23529000080862','Middleton','Bobbie',NULL,NULL,'',NULL,NULL,'4619 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-07-24','SPL','J','1991-03-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,104,NULL,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'), +(8,'23529000358268','Rivera','Olga',NULL,NULL,'',NULL,NULL,'6058 Library Rd.',NULL,'Mayfield Heights, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1979-12-22','PVL','T','1986-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,112,NULL,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'), +(9,'23529000429697','Waters','Annie',NULL,NULL,'',NULL,NULL,'5444 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1932-10-27','FRL','ST','1984-05-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'), +(10,'23529000068917','Herring','Frances',NULL,NULL,'',NULL,NULL,'4024 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-02-13','SPL','PT','1993-03-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'), +(11,'23529000065863','Hawkins','Sam',NULL,NULL,'',NULL,NULL,'665 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1924-03-26','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'), +(12,'23529000878885','Mcknight','Marie',NULL,NULL,'',NULL,NULL,'4241 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','YA','1990-08-06','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'), +(13,'23529000132291','Edwards','Roy',NULL,NULL,'',NULL,NULL,'9929 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1928-09-09','MPL','PT','1992-03-10','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'), +(14,'23529000035726','Mccullough','Phillip',NULL,NULL,'',NULL,NULL,'410 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1943-11-23','SPL','PT','1986-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'), +(15,'23529001203323','Peterson','Gordon',NULL,NULL,'',NULL,NULL,'6285 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1963-10-01','SPL','J','1984-09-11','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,131,NULL,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'), +(16,'23529000991266','Walker','Andrea',NULL,NULL,'',NULL,NULL,'4992 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-08-05','FRL','IL','1993-06-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'), +(17,'23529000711078','King','Casey',NULL,NULL,'',NULL,NULL,'3438 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-09-23','SPL','S','1992-05-18','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'), +(18,'23529000809559','Delgado','Floyd',NULL,NULL,'',NULL,NULL,'6661 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1968-02-01','MPL','K','1988-08-05','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,160,NULL,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'), +(19,'23529000035676','Acevedo','Henry',NULL,NULL,'',NULL,NULL,'4345 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1958-05-30','MPL','S','1990-09-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'), +(20,'23529000033739','Frazier','Sonia',NULL,NULL,'',NULL,NULL,'8165 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1945-09-16','MPL','PT','1984-06-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'), +(21,'23529000139858','Ballard','Ronnie',NULL,NULL,'',NULL,NULL,'5730 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-02-23','MPL','T','1989-06-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,177,NULL,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'), +(22,'23529000224510','Gaines','Joyce',NULL,NULL,'',NULL,NULL,'6012 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1957-08-01','SPL','YA','1992-09-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'), +(23,'23529000120056','Bryan','Johnny',NULL,NULL,'',NULL,NULL,'8180 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1961-10-24','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'), +(24,'23529000218553','Duffy','Joann',NULL,NULL,'',NULL,NULL,'1555 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1942-02-17','MPL','ST','1984-08-02','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'), +(25,'23529000662701','Mejia','Armando',NULL,NULL,'',NULL,NULL,'8209 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1939-07-22','SPL','PT','1990-09-26','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'), +(26,'23529000092040','Hendrix','Keith',NULL,NULL,'',NULL,NULL,'6546 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1944-04-05','SPL','PT','1987-12-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'), +(27,'23529000058017','Turner','Sherri',NULL,NULL,'',NULL,NULL,'1731 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1964-11-21','FRL','PT','1987-09-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'), +(28,'23529000299603','Cherry','Lillie',NULL,NULL,'',NULL,NULL,'263 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1931-01-19','MPL','PT','1993-03-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'), +(29,'23529000121682','Schneider','Nicole',NULL,NULL,'',NULL,NULL,'1008 Library Rd.',NULL,'Centerville, CA','44306',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1954-01-12','FRL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'), +(30,'23529000240482','White','Jamie',NULL,NULL,'',NULL,NULL,'937 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1950-04-22','FRL','T','1990-02-03','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,254,NULL,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'), +(31,'23529000714163','Burgess','Dawn',NULL,NULL,'',NULL,NULL,'7907 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','PT','1985-05-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'), +(32,'23529000318858','Bennett','Pamela',NULL,NULL,'',NULL,NULL,'9898 Library Rd.',NULL,'Centerville, CA','44310',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1946-09-16','MPL','ST','1984-05-08','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'), +(33,'23529000526047','Hatfield','Lester',NULL,NULL,'',NULL,NULL,'393 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-01-22','SPL','ST','1988-07-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'), +(34,'23529000686353','Harper','Ruben',NULL,NULL,'',NULL,NULL,'6963 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1917-09-24','SPL','S','1991-02-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'), +(35,'23529000719519','Kinney','Mae',NULL,NULL,'',NULL,NULL,'2114 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','J','1991-12-29','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,287,NULL,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'), +(36,'23529000179433','Williamson','Catherine',NULL,NULL,'',NULL,NULL,'5879 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1930-12-18','FRL','K','1985-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,288,NULL,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'), +(37,'23529000197047','Charles','Lisa',NULL,NULL,'',NULL,NULL,'6813 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1982-10-14','MPL','K','1988-11-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,289,NULL,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'), +(38,'23529000695412','Singleton','Bob',NULL,NULL,'',NULL,NULL,'4554 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-04-15','FRL','PT','1991-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'), +(39,'23529000603242','Mcconnell','Terrence',NULL,NULL,'',NULL,NULL,'7200 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1949-06-10','SPL','PT','1984-05-31','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'), +(40,'23529000589458','Knight','Mabel',NULL,NULL,'',NULL,NULL,'8997 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-12-22','SPL','T','1985-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,320,NULL,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'), +(41,'23529000054503','Odom','Gloria',NULL,NULL,'',NULL,NULL,'9156 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-05','SPL','S','1992-07-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'), +(42,'23529000126806','Hopkins','Brent',NULL,NULL,'',NULL,NULL,'6692 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-11-13','SPL','T','1984-06-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,337,NULL,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'), +(43,'23529000104159','Benson','Clinton',NULL,NULL,'',NULL,NULL,'4695 Library Rd.',NULL,'Atwater, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','YA','1985-10-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'), +(44,'23529000395609','Stuart','Shannon',NULL,NULL,'',NULL,NULL,'5011 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-02-13','FRL','PT','1986-01-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'), +(45,'23529000050113','Alford','Jordan',NULL,NULL,'',NULL,NULL,'5129 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-05-27','MPL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'), +(46,'23529000053836','Mcfarland','Marilyn',NULL,NULL,'',NULL,NULL,'4600 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'), +(47,'23529000774373','Morris','Lauren',NULL,NULL,'',NULL,NULL,'5436 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1986-03-20','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'), +(48,'23529000117565','Palmer','Bill',NULL,NULL,'',NULL,NULL,'2761 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1984-01-10','SPL','PT','1991-10-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'), +(49,'23529000651225','Burton','Mary',NULL,NULL,'',NULL,NULL,'8131 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-12-25','MPL','PT','1985-05-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'), +(50,'23529001223636','Peters','Tommy',NULL,NULL,'',NULL,NULL,'5171 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-06-14','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.txt b/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.txt new file mode 100644 index 0000000000..0a5cebe809 --- /dev/null +++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_patrons.txt @@ -0,0 +1 @@ +Eksempel-lŒnere. Ikke tilpasset norske forhold. -- 2.39.5