Bugzilla – Attachment 20169 Details for
Bug 10521
Add i18n function to German mysql files for webinstaller (de-DE)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10521: Define i18n function for de-DE/optional files
Bug-10521-Define-i18n-function-for-de-DEoptional-f.patch (text/plain), 89.50 KB, created by
Marcel de Rooy
on 2013-08-08 13:17:50 UTC
(
hide
)
Description:
Bug 10521: Define i18n function for de-DE/optional files
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2013-08-08 13:17:50 UTC
Size:
89.50 KB
patch
obsolete
>From 1e5491102545fe831e315758379f4bcb46f5f287 Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Wed, 7 Aug 2013 16:49:06 +0200 >Subject: [PATCH] Bug 10521: Define i18n function for de-DE/optional files >Content-Type: text/plain; charset=utf-8 > >This patch adjusts the de-DE/optional files. > >Test plan: >Run German install, including all optional files. >Check translated strings from several tables touched in Optional. >--- > .../data/mysql/de-DE/optional.i18n/auth_val.sql | 180 +++++++ > .../de-DE/{optional => optional.i18n}/auth_val.txt | 0 > .../optional.i18n/marc21_holdings_coded_values.sql | 496 ++++++++++++++++++++ > .../marc21_holdings_coded_values.txt | 0 > .../data/mysql/de-DE/optional.i18n/parameters.sql | 11 + > .../{optional => optional.i18n}/parameters.txt | 0 > .../mysql/de-DE/optional.i18n/patron_atributes.sql | 13 + > .../patron_atributes.txt | 0 > .../de-DE/optional.i18n/patron_categories.sql | 46 ++ > .../patron_categories.txt | 26 +- > .../de-DE/optional.i18n/sample_creator_data.sql | 73 +++ > .../sample_creator_data.txt | 0 > .../mysql/de-DE/optional.i18n/sample_holidays.sql | 20 + > .../mysql/de-DE/optional.i18n/sample_holidays.txt | 4 + > .../mysql/de-DE/optional.i18n/sample_itemtypes.sql | 34 ++ > .../sample_itemtypes.txt | 0 > .../mysql/de-DE/optional.i18n/sample_libraries.sql | 10 + > .../sample_libraries.txt | 0 > .../data/mysql/de-DE/optional.i18n/sample_news.sql | 28 ++ > .../{optional => optional.i18n}/sample_news.txt | 0 > .../mysql/de-DE/optional.i18n/sample_patrons.sql | 10 + > .../{optional => optional.i18n}/sample_patrons.txt | 0 > .../de-DE/optional.i18n/sample_z3950_servers.sql | 19 + > .../sample_z3950_servers.txt | 0 > installer/data/mysql/de-DE/optional/auth_val.sql | 59 --- > .../optional/marc21_holdings_coded_values.sql | 145 ------ > installer/data/mysql/de-DE/optional/parameters.sql | 6 - > .../data/mysql/de-DE/optional/patron_atributes.sql | 2 - > .../mysql/de-DE/optional/patron_categories.sql | 23 - > .../mysql/de-DE/optional/sample_creator_data.sql | 17 - > .../data/mysql/de-DE/optional/sample_holidays.sql | 5 - > .../data/mysql/de-DE/optional/sample_holidays.txt | 4 - > .../data/mysql/de-DE/optional/sample_itemtypes.sql | 9 - > .../data/mysql/de-DE/optional/sample_libraries.sql | 15 - > .../data/mysql/de-DE/optional/sample_news.sql | 3 - > .../data/mysql/de-DE/optional/sample_patrons.sql | 52 -- > .../mysql/de-DE/optional/sample_z3950_servers.sql | 5 - > 37 files changed, 957 insertions(+), 358 deletions(-) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/auth_val.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/auth_val.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/marc21_holdings_coded_values.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/parameters.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/parameters.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/patron_atributes.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/patron_atributes.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/patron_categories.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/patron_categories.txt (56%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_creator_data.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_creator_data.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_holidays.sql > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_holidays.txt > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_itemtypes.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_libraries.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_libraries.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_news.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_news.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_patrons.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_patrons.txt (100%) > create mode 100644 installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.sql > rename installer/data/mysql/de-DE/{optional => optional.i18n}/sample_z3950_servers.txt (100%) > delete mode 100644 installer/data/mysql/de-DE/optional/auth_val.sql > delete mode 100644 installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.sql > delete mode 100644 installer/data/mysql/de-DE/optional/parameters.sql > delete mode 100644 installer/data/mysql/de-DE/optional/patron_atributes.sql > delete mode 100644 installer/data/mysql/de-DE/optional/patron_categories.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_creator_data.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_holidays.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_holidays.txt > delete mode 100644 installer/data/mysql/de-DE/optional/sample_itemtypes.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_libraries.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_news.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_patrons.sql > delete mode 100644 installer/data/mysql/de-DE/optional/sample_z3950_servers.sql > >diff --git a/installer/data/mysql/de-DE/optional.i18n/auth_val.sql b/installer/data/mysql/de-DE/optional.i18n/auth_val.sql >new file mode 100644 >index 0000000..cd502ad >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/auth_val.sql >@@ -0,0 +1,180 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Reasons for acceptance or rejection of suggestions in acquisitions >+-- Statement 1, PK:'SUGGEST','BSELL', lib >+WHEN 'Bestseller' >+THEN 'Bestseller' >+ >+-- Statement 2, PK:'SUGGEST','SCD', lib >+WHEN 'Shelf Copy Damaged' >+THEN 'Vorhandenes Exemplar beschädigt' >+ >+-- Statement 3, PK:'SUGGEST','LCL', lib >+WHEN 'Library Copy Lost' >+THEN 'Bibliotheksexemplar vermisst' >+ >+-- Statement 4, PK:'SUGGEST','AVILL', lib >+WHEN 'Available via ILL' >+THEN 'Ãber Fernleihe bestellbar' >+ >+ >+-- availability statuses >+-- Statement 5, PK:'LOST','2', lib >+WHEN 'Long Overdue (Lost)' >+THEN 'Lange überfällig (Verloren)' >+ >+-- Statement 6, PK:'LOST','1', lib >+WHEN 'Lost' >+THEN 'Verloren' >+ >+-- Statement 7, PK:'LOST','3', lib >+WHEN 'Lost and Paid For' >+THEN 'Verloren und Buchersatz bezahlt' >+ >+-- Statement 8, PK:'LOST','4', lib >+WHEN 'Missing' >+THEN 'Vermisst' >+ >+ >+-- damaged status of an item >+-- Statement 9, PK:'DAMAGED','1', lib >+WHEN 'Damaged' >+THEN 'Beschädigt' >+ >+ >+-- location qualification for an item, departments are linked by default to items.location >+-- Statement 10, PK:'LOC','FIC', lib >+WHEN 'Fiction' >+THEN 'Belletristik' >+ >+-- Statement 11, PK:'LOC','CHILD', lib >+WHEN 'Children\'s Area' >+THEN 'Kinderbibliothek' >+ >+-- Statement 12, PK:'LOC','DISPLAY', lib >+WHEN 'On Display' >+THEN 'Medienausstellung' >+ >+-- Statement 13, PK:'LOC','NEW', lib >+WHEN 'New Materials Shelf' >+THEN 'Neuerwerbungsregal' >+ >+-- Statement 14, PK:'LOC','STAFF', lib >+WHEN 'Staff Office' >+THEN 'Mitarbeiterbüro' >+ >+-- Statement 15, PK:'LOC','GEN', lib >+WHEN 'General Stacks' >+THEN 'Magazin' >+ >+-- Statement 16, PK:'LOC','AV', lib >+WHEN 'Audio Visual' >+THEN 'AV-Mediensammlung' >+ >+-- Statement 17, PK:'LOC','REF', lib >+WHEN 'Reference' >+THEN 'Nachschlagewerke' >+ >+-- Statement 18, PK:'LOC','CART', lib >+WHEN 'Book Cart' >+THEN 'Einstellwagen' >+ >+-- Statement 19, PK:'LOC','PROC', lib >+WHEN 'Processing Center' >+THEN 'In Bearbeitung' >+ >+ >+-- collection codes for an item >+-- Statement 20, PK:'CCODE','FIC', lib >+WHEN 'Fiction' >+THEN 'Belletristik' >+ >+-- Statement 21, PK:'CCODE','REF', lib >+WHEN 'Reference' >+THEN 'Nachschlagewerke' >+ >+-- Statement 22, PK:'CCODE','NFIC', lib >+WHEN 'Non Fiction' >+THEN 'Sachliteratur' >+ >+ >+-- withdrawn status of an item, linked to items.wthdrawn >+-- Statement 23, PK:'WITHDRAWN','1', lib >+WHEN 'Withdrawn' >+THEN 'Ausgeschieden' >+ >+ >+-- loanability status of an item, linked to items.notforloan >+-- Statement 24, PK:'NOT_LOAN','-1', lib >+WHEN 'Ordered' >+THEN 'Bestellt' >+ >+-- Statement 25, PK:'NOT_LOAN','1', lib >+WHEN 'Not For Loan' >+THEN 'Nicht entleihbar' >+ >+-- Statement 26, PK:'NOT_LOAN','2', lib >+WHEN 'Staff Collection' >+THEN 'Mitarbeiterbibliothek' >+ >+ >+-- restricted status of an item, linked to items.restricted >+-- Statement 27, PK:'RESTRICTED','1', lib >+WHEN 'Restricted Access' >+THEN 'Eingeschränkt zugänglich' >+ >+ >+-- manual invoice types >+-- Not found: 28,'MANUAL_INV','Kopiergebühren',lib >+ >+ >+-- custom borrower notes >+-- Statement 29, PK:'BOR_NOTES','ADDR', lib >+WHEN 'Address Notes' >+THEN 'Adresse kontrollieren' >+ >+ >+-- OPAC Suggestions reasons >+-- Statement 30, PK:'OPAC_SUG','damaged', lib >+WHEN 'The copy on the shelf is damaged' >+THEN 'Vorhandenes Exemplar ist beschädigt' >+-- Statement 30, PK:'OPAC_SUG','damaged', lib_opac >+WHEN 'The copy on the shelf is damaged' >+THEN 'Vorhandenes Exemplar ist beschädigt' >+ >+-- Statement 31, PK:'OPAC_SUG','bestseller', lib >+WHEN 'Upcoming title by popular author' >+THEN 'Neuerscheinung von bekanntem Verfasser' >+-- Statement 31, PK:'OPAC_SUG','bestseller', lib_opac >+WHEN 'Upcoming title by popular author' >+THEN 'Neuerscheinung von bekanntem Verfasser' >+ >+ >+-- Report groups >+-- Statement 32, PK:'REPORT_GROUP','CIRC', lib >+WHEN 'Circulation' >+THEN 'Ausleihe' >+ >+-- Statement 33, PK:'REPORT_GROUP','CAT', lib >+WHEN 'Catalog' >+THEN 'Katalog' >+ >+-- Statement 34, PK:'REPORT_GROUP','PAT', lib >+WHEN 'Patrons' >+THEN 'Benutzer' >+ >+-- Statement 35, PK:'REPORT_GROUP','ACQ', lib >+WHEN 'Acquisitions' >+THEN 'Erwerbung' >+ >+-- Statement 36, PK:'REPORT_GROUP','ACC', lib >+WHEN 'Accounts' >+THEN 'Gebühren' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/auth_val.txt b/installer/data/mysql/de-DE/optional.i18n/auth_val.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/auth_val.txt >rename to installer/data/mysql/de-DE/optional.i18n/auth_val.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.sql b/installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.sql >new file mode 100644 >index 0000000..da11914 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.sql >@@ -0,0 +1,496 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- 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 >+-- Statement 1, PK:'HINGS_UT','0', lib >+WHEN 'Information not available; Not applicable' >+THEN 'Information not available; Not applicable' >+-- Statement 2, PK:'HINGS_UT','a', lib >+WHEN 'Basic bibliographic unit' >+THEN 'Basic bibliographic unit' >+ >+-- Statement 3, PK:'HINGS_UT','c', lib >+WHEN 'Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units' >+THEN 'Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units' >+ >+-- Statement 4, PK:'HINGS_UT','d', lib >+WHEN 'Indexes' >+THEN 'Indexes' >+ >+ >+-- Physical Form Designators >+-- Statement 5, PK:'HINGS_PF','au', lib >+WHEN 'Cartographic material' >+THEN 'Cartographic material' >+ >+-- Statement 6, PK:'HINGS_PF','ad', lib >+WHEN 'Cartographic material, atlas' >+THEN 'Cartographic material, atlas' >+ >+-- Statement 7, PK:'HINGS_PF','ag', lib >+WHEN 'Cartographic material, diagram' >+THEN 'Cartographic material, diagram' >+ >+-- Statement 8, PK:'HINGS_PF','aj', lib >+WHEN 'Cartographic material, map' >+THEN 'Cartographic material, map' >+ >+-- Statement 9, PK:'HINGS_PF','ak', lib >+WHEN 'Cartographic material, profile' >+THEN 'Cartographic material, profile' >+ >+-- Statement 10, PK:'HINGS_PF','aq', lib >+WHEN 'Cartographic material, model' >+THEN 'Cartographic material, model' >+ >+-- Statement 11, PK:'HINGS_PF','ar', lib >+WHEN 'Cartographic material, remote sensing image' >+THEN 'Cartographic material, remote sensing image' >+ >+-- Statement 12, PK:'HINGS_PF','as', lib >+WHEN 'Cartographic material, section' >+THEN 'Cartographic material, section' >+ >+-- Statement 13, PK:'HINGS_PF','ay', lib >+WHEN 'Cartographic material, view' >+THEN 'Cartographic material, view' >+ >+-- Statement 14, PK:'HINGS_PF','az', lib >+WHEN 'Cartographic material, other' >+THEN 'Cartographic material, other' >+ >+ >+-- Statement 15, PK:'HINGS_PF','cu', lib >+WHEN 'Computer file' >+THEN 'Computer file' >+ >+-- Statement 16, PK:'HINGS_PF','ca', lib >+WHEN 'Computer file, tape cartridge' >+THEN 'Computer file, tape cartridge' >+ >+-- Statement 17, PK:'HINGS_PF','cb', lib >+WHEN 'Computer file, chip cartridge' >+THEN 'Computer file, chip cartridge' >+ >+-- Statement 18, PK:'HINGS_PF','cc', lib >+WHEN 'Computer file, computer optical disk cartridge' >+THEN 'Computer file, computer optical disk cartridge' >+ >+-- Statement 19, PK:'HINGS_PF','cf', lib >+WHEN 'Computer file, tape cassette' >+THEN 'Computer file, tape cassette' >+ >+-- Statement 20, PK:'HINGS_PF','ch', lib >+WHEN 'Computer file, tape reel' >+THEN 'Computer file, tape reel' >+ >+-- Statement 21, PK:'HINGS_PF','cj', lib >+WHEN 'Computer file, magnetic disk' >+THEN 'Computer file, magnetic disk' >+ >+-- Statement 22, PK:'HINGS_PF','cm', lib >+WHEN 'Computer file, magneto-optical disk' >+THEN 'Computer file, magneto-optical disk' >+ >+-- Statement 23, PK:'HINGS_PF','co', lib >+WHEN 'Computer file, optical disk' >+THEN 'Computer file, optical disk' >+ >+-- Statement 24, PK:'HINGS_PF','cr', lib >+WHEN 'Computer file, remote' >+THEN 'Computer file, remote' >+ >+-- Statement 25, PK:'HINGS_PF','cz', lib >+WHEN 'Computer file, other' >+THEN 'Computer file, other' >+ >+ >+-- Statement 26, PK:'HINGS_PF','du', lib >+WHEN 'Globe' >+THEN 'Globe' >+ >+-- Statement 27, PK:'HINGS_PF','da', lib >+WHEN 'Globe, celestial' >+THEN 'Globe, celestial' >+ >+-- Statement 28, PK:'HINGS_PF','db', lib >+WHEN 'Globe, planetary or lunar' >+THEN 'Globe, planetary or lunar' >+ >+-- Statement 29, PK:'HINGS_PF','dc', lib >+WHEN 'Globe, terrestrial' >+THEN 'Globe, terrestrial' >+ >+-- Statement 30, PK:'HINGS_PF','de', lib >+WHEN 'Globe, earth moon' >+THEN 'Globe, earth moon' >+ >+-- Statement 31, PK:'HINGS_PF','dz', lib >+WHEN 'Globe, other' >+THEN 'Globe, other' >+ >+ >+-- Statement 32, PK:'HINGS_PF','ou', lib >+WHEN 'Kit' >+THEN 'Kit' >+ >+ >+-- Statement 33, PK:'HINGS_PF','hu', lib >+WHEN 'Microform' >+THEN 'Microform' >+ >+-- Statement 34, PK:'HINGS_PF','ha', lib >+WHEN 'Microform, aperture card' >+THEN 'Microform, aperture card' >+ >+-- Statement 35, PK:'HINGS_PF','hb', lib >+WHEN ' Microform, microfilm cartridge' >+THEN ' Microform, microfilm cartridge' >+ >+-- Statement 36, PK:'HINGS_PF','hc', lib >+WHEN ' Microform, microfilm cassette' >+THEN ' Microform, microfilm cassette' >+ >+-- Statement 37, PK:'HINGS_PF','hd', lib >+WHEN ' Microform, microfilm reel' >+THEN ' Microform, microfilm reel' >+ >+-- Statement 38, PK:'HINGS_PF','he', lib >+WHEN 'Microform, microfiche' >+THEN 'Microform, microfiche' >+ >+-- Statement 39, PK:'HINGS_PF','hf', lib >+WHEN 'Microform, microfiche cassette' >+THEN 'Microform, microfiche cassette' >+ >+-- Statement 40, PK:'HINGS_PF','hg', lib >+WHEN 'Microform, micro-opaque' >+THEN 'Microform, micro-opaque' >+ >+-- Statement 41, PK:'HINGS_PF','hz', lib >+WHEN 'Microform, other' >+THEN 'Microform, other' >+ >+ >+-- Statement 42, PK:'HINGS_PF','mu', lib >+WHEN 'Motion picture' >+THEN 'Motion picture' >+ >+-- Statement 43, PK:'HINGS_PF','mc', lib >+WHEN 'Motion picture, film cartridge' >+THEN 'Motion picture, film cartridge' >+ >+-- Statement 44, PK:'HINGS_PF','mf', lib >+WHEN 'Motion picture, film cassette' >+THEN 'Motion picture, film cassette' >+ >+-- Statement 45, PK:'HINGS_PF','mr', lib >+WHEN 'Motion picture, film reel' >+THEN 'Motion picture, film reel' >+ >+-- Statement 46, PK:'HINGS_PF','mz', lib >+WHEN 'Motion picture, other' >+THEN 'Motion picture, other' >+ >+ >+-- Statement 47, PK:'HINGS_PF','ku', lib >+WHEN 'Nonprojected graphic' >+THEN 'Nonprojected graphic' >+ >+-- Statement 48, PK:'HINGS_PF','kc', lib >+WHEN 'Nonprojected graphic, collage' >+THEN 'Nonprojected graphic, collage' >+ >+-- Statement 49, PK:'HINGS_PF','kd', lib >+WHEN 'Nonprojected graphic, drawing' >+THEN 'Nonprojected graphic, drawing' >+ >+ >+-- Statement 50, PK:'HINGS_PF','ke', lib >+WHEN 'Nonprojected graphic, painting' >+THEN 'Nonprojected graphic, painting' >+ >+-- Statement 51, PK:'HINGS_PF','kf', lib >+WHEN 'Nonprojected graphic, photomechanical print' >+THEN 'Nonprojected graphic, photomechanical print' >+ >+-- Statement 52, PK:'HINGS_PF','kg', lib >+WHEN 'Nonprojected graphic, photonegative' >+THEN 'Nonprojected graphic, photonegative' >+ >+-- Statement 53, PK:'HINGS_PF','kh', lib >+WHEN 'Nonprojected graphic, photoprint' >+THEN 'Nonprojected graphic, photoprint' >+ >+-- Statement 54, PK:'HINGS_PF','ki', lib >+WHEN 'Nonprojected graphic, picture' >+THEN 'Nonprojected graphic, picture' >+ >+-- Statement 55, PK:'HINGS_PF','kj', lib >+WHEN 'Nonprojected graphic, print' >+THEN 'Nonprojected graphic, print' >+ >+-- Statement 56, PK:'HINGS_PF','kl', lib >+WHEN 'Nonprojected graphic, technical drawing' >+THEN 'Nonprojected graphic, technical drawing' >+ >+-- Statement 57, PK:'HINGS_PF','kn', lib >+WHEN 'Nonprojected graphic, chart' >+THEN 'Nonprojected graphic, chart' >+ >+-- Statement 58, PK:'HINGS_PF','ko', lib >+WHEN 'Nonprojected graphic, flash card' >+THEN 'Nonprojected graphic, flash card' >+ >+-- Statement 59, PK:'HINGS_PF','kz', lib >+WHEN 'Nonprojected graphic, other' >+THEN 'Nonprojected graphic, other' >+ >+ >+-- Statement 60, PK:'HINGS_PF','qu', lib >+WHEN 'Notated music' >+THEN 'Notated music' >+ >+ >+-- Statement 61, PK:'HINGS_PF','gu', lib >+WHEN 'Projected graphic' >+THEN 'Projected graphic' >+ >+-- Statement 62, PK:'HINGS_PF','gc', lib >+WHEN 'Projected graphic, filmstrip cartridge' >+THEN 'Projected graphic, filmstrip cartridge' >+ >+-- Statement 63, PK:'HINGS_PF','gd', lib >+WHEN 'Projected graphic, filmstrip' >+THEN 'Projected graphic, filmstrip' >+ >+-- Statement 64, PK:'HINGS_PF','gf', lib >+WHEN 'Projected graphic, other type of filmstrip' >+THEN 'Projected graphic, other type of filmstrip' >+ >+-- Statement 65, PK:'HINGS_PF','go', lib >+WHEN 'Projected graphic, filmstrip roll' >+THEN 'Projected graphic, filmstrip roll' >+ >+-- Statement 66, PK:'HINGS_PF','gs', lib >+WHEN 'Projected graphic, slide' >+THEN 'Projected graphic, slide' >+ >+-- Statement 67, PK:'HINGS_PF','gt', lib >+WHEN 'Projected graphic, transparency' >+THEN 'Projected graphic, transparency' >+ >+-- Statement 68, PK:'HINGS_PF','gz', lib >+WHEN 'Projected graphic, other' >+THEN 'Projected graphic, other' >+ >+ >+-- Statement 69, PK:'HINGS_PF','ru', lib >+WHEN 'Remote-sensing image' >+THEN 'Remote-sensing image' >+ >+ >+-- Statement 70, PK:'HINGS_PF','su', lib >+WHEN 'Sound recording' >+THEN 'Sound recording' >+ >+-- Statement 71, PK:'HINGS_PF','sd', lib >+WHEN 'Sound recording, sound disk' >+THEN 'Sound recording, sound disk' >+ >+-- Statement 72, PK:'HINGS_PF','se', lib >+WHEN 'Sound recording, cylinder' >+THEN 'Sound recording, cylinder' >+ >+-- Statement 73, PK:'HINGS_PF','sg', lib >+WHEN 'Sound recording, sound cartridge' >+THEN 'Sound recording, sound cartridge' >+ >+-- Statement 74, PK:'HINGS_PF','si', lib >+WHEN 'Sound recording, sound-track film' >+THEN 'Sound recording, sound-track film' >+ >+-- Statement 75, PK:'HINGS_PF','sq', lib >+WHEN 'Sound recording, roll' >+THEN 'Sound recording, roll' >+ >+-- Statement 76, PK:'HINGS_PF','ss', lib >+WHEN 'Sound recording, sound cassette' >+THEN 'Sound recording, sound cassette' >+ >+-- Statement 77, PK:'HINGS_PF','st', lib >+WHEN 'Sound recording, sound-tape reel' >+THEN 'Sound recording, sound-tape reel' >+ >+-- Statement 78, PK:'HINGS_PF','sw', lib >+WHEN 'Sound recording, wire recording' >+THEN 'Sound recording, wire recording' >+ >+-- Statement 79, PK:'HINGS_PF','sz', lib >+WHEN 'Sound recording, other' >+THEN 'Sound recording, other' >+ >+ >+-- Statement 80, PK:'HINGS_PF','tu', lib >+WHEN 'Text' >+THEN 'Text' >+ >+-- Statement 81, PK:'HINGS_PF','ta', lib >+WHEN 'Text, regular print' >+THEN 'Text, regular print' >+ >+-- Statement 82, PK:'HINGS_PF','tb', lib >+WHEN 'Text, large print' >+THEN 'Text, large print' >+ >+-- Statement 83, PK:'HINGS_PF','tc', lib >+WHEN 'Text, Braille' >+THEN 'Text, Braille' >+ >+-- Statement 84, PK:'HINGS_PF','td', lib >+WHEN 'Text, loose-leaf' >+THEN 'Text, loose-leaf' >+ >+-- Statement 85, PK:'HINGS_PF','tz', lib >+WHEN 'Text, other' >+THEN 'Text, other' >+ >+ >+-- Statement 86, PK:'HINGS_PF','vu', lib >+WHEN 'Videorecording' >+THEN 'Videorecording' >+ >+-- Statement 87, PK:'HINGS_PF','vc', lib >+WHEN 'Videorecording, videocartridge' >+THEN 'Videorecording, videocartridge' >+ >+-- Statement 88, PK:'HINGS_PF','vd', lib >+WHEN 'Videorecording, videodisc' >+THEN 'Videorecording, videodisc' >+ >+-- Statement 89, PK:'HINGS_PF','vf', lib >+WHEN 'Videorecording, videocassette' >+THEN 'Videorecording, videocassette' >+ >+-- Statement 90, PK:'HINGS_PF','vr', lib >+WHEN 'Videorecording, videoreel' >+THEN 'Videorecording, videoreel' >+ >+-- Statement 91, PK:'HINGS_PF','vz', lib >+WHEN 'Videorecording, other' >+THEN 'Videorecording, other' >+ >+ >+-- Statement 92, PK:'HINGS_PF','zu', lib >+WHEN 'Physical form is unspecified' >+THEN 'Physical form is unspecified' >+ >+-- Statement 93, PK:'HINGS_PF','zm', lib >+WHEN 'Multiple physical forms' >+THEN 'Multiple physical forms' >+ >+-- Statement 94, PK:'HINGS_PF','zz', lib >+WHEN 'Other physical media' >+THEN 'Other physical media' >+ >+ >+-- General Holdings: Completeness Designator >+-- Statement 95, PK:'HINGS_C','0', lib >+WHEN 'Information not available, or Retention is limited' >+THEN 'Information not available, or Retention is limited' >+ >+-- Statement 96, PK:'HINGS_C','1', lib >+WHEN 'Complete (95%-100% held)' >+THEN 'Complete (95%-100% held)' >+ >+-- Statement 97, PK:'HINGS_C','2', lib >+WHEN 'Incomplete (50%-94% held)' >+THEN 'Incomplete (50%-94% held)' >+ >+-- Statement 98, PK:'HINGS_C','3', lib >+WHEN 'Very incomplete or scattered (less than 50% held)' >+THEN 'Very incomplete or scattered (less than 50% held)' >+ >+-- Statement 99, PK:'HINGS_C','4', lib >+WHEN 'Not applicable' >+THEN 'Not applicable' >+ >+ >+-- General Holdings: Acquisition Status Designator >+-- This data element specifies acquisition status for the unit at the time of the holdings report. >+ >+-- Statement 100, PK:'HINGS_AS','0', lib >+WHEN 'Information not available, or Retention is limited' >+THEN 'Information not available, or Retention is limited' >+ >+-- Statement 101, PK:'HINGS_AS','1', lib >+WHEN 'Other' >+THEN 'Other' >+ >+-- Statement 102, PK:'HINGS_AS','2', lib >+WHEN 'Received and complete or Ceased' >+THEN 'Received and complete or Ceased' >+ >+-- Statement 103, PK:'HINGS_AS','3', lib >+WHEN 'On order' >+THEN 'On order' >+ >+-- Statement 104, PK:'HINGS_AS','4', lib >+WHEN 'Currently received' >+THEN 'Currently received' >+ >+-- Statement 105, PK:'HINGS_AS','5', lib >+WHEN 'Not currently received' >+THEN 'Not currently received' >+ >+ >+-- General Holdings: Retention Designator >+-- This data element specifies the retention policy for the unit at the time of the holdings report. >+ >+-- Statement 106, PK:'HINGS_RD','0', lib >+WHEN 'Information not available' >+THEN 'Information not available' >+ >+-- Statement 107, PK:'HINGS_RD','1', lib >+WHEN 'Other' >+THEN 'Other' >+ >+-- Statement 108, PK:'HINGS_RD','2', lib >+WHEN 'Retained except as replaced by updates' >+THEN 'Retained except as replaced by updates' >+ >+-- Statement 109, PK:'HINGS_RD','3', lib >+WHEN 'Sample issue retained' >+THEN 'Sample issue retained' >+ >+-- Statement 110, PK:'HINGS_RD','4', lib >+WHEN 'Retained until replaced by microform, or other preservation format' >+THEN 'Retained until replaced by microform, or other preservation format' >+ >+-- Statement 111, PK:'HINGS_RD','5', lib >+WHEN 'Retained until replaced by cumulation, replacement volume, or revision' >+THEN 'Retained until replaced by cumulation, replacement volume, or revision' >+ >+-- Statement 112, PK:'HINGS_RD','6', lib >+WHEN 'Limited retention (only some parts kept)' >+THEN 'Limited retention (only some parts kept)' >+ >+-- Statement 113, PK:'HINGS_RD','7', lib >+WHEN 'No retention (no parts kept)' >+THEN 'No retention (no parts kept)' >+ >+-- Statement 114, PK:'HINGS_RD','8', lib >+WHEN 'Permanent retention (all parts kept permanently)' >+THEN 'Permanent retention (all parts kept permanently)' >+ >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.txt b/installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.txt >rename to installer/data/mysql/de-DE/optional.i18n/marc21_holdings_coded_values.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/parameters.sql b/installer/data/mysql/de-DE/optional.i18n/parameters.sql >new file mode 100644 >index 0000000..99270f8 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/parameters.sql >@@ -0,0 +1,11 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+ >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/parameters.txt b/installer/data/mysql/de-DE/optional.i18n/parameters.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/parameters.txt >rename to installer/data/mysql/de-DE/optional.i18n/parameters.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/patron_atributes.sql b/installer/data/mysql/de-DE/optional.i18n/patron_atributes.sql >new file mode 100644 >index 0000000..dccb447 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/patron_atributes.sql >@@ -0,0 +1,13 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:'SHOW_BCODE', description >+WHEN 'Show barcode on the summary screen items listings' >+THEN 'Zeige den Barcode in der Exemplarübersicht' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/patron_atributes.txt b/installer/data/mysql/de-DE/optional.i18n/patron_atributes.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/patron_atributes.txt >rename to installer/data/mysql/de-DE/optional.i18n/patron_atributes.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/patron_categories.sql b/installer/data/mysql/de-DE/optional.i18n/patron_categories.sql >new file mode 100644 >index 0000000..cee732f >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/patron_categories.sql >@@ -0,0 +1,46 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:'PT', description >+WHEN 'Patron' >+THEN 'Erwachsener' >+-- Statement 1, PK:'ST', description >+WHEN 'Student' >+THEN 'Student' >+-- Statement 1, PK:'HB', description >+WHEN 'Home Bound' >+THEN 'Ans Haus gebunden' >+-- Statement 1, PK:'K', description >+WHEN 'Kid' >+THEN 'Kind' >+-- Statement 1, PK:'J', description >+WHEN 'Juvenile' >+THEN 'Jugendlicher' >+-- Statement 1, PK:'YA', description >+WHEN 'Young Adult' >+THEN 'Junger Erwachsener' >+-- Statement 1, PK:'T', description >+WHEN 'Teacher' >+THEN 'Lehrer' >+-- Statement 1, PK:'B', description >+WHEN 'Board' >+THEN 'Gremienmitglied' >+-- Statement 1, PK:'IL', description >+WHEN 'Inter-Library Loan' >+THEN 'Fernleihbibliothek' >+-- Statement 1, PK:'SC', description >+WHEN 'School' >+THEN 'Schule' >+-- Statement 1, PK:'L', description >+WHEN 'Library' >+THEN 'Bibliothek' >+-- Statement 1, PK:'S', description >+WHEN 'Staff' >+THEN 'Mitarbeiter' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/patron_categories.txt b/installer/data/mysql/de-DE/optional.i18n/patron_categories.txt >similarity index 56% >rename from installer/data/mysql/de-DE/optional/patron_categories.txt >rename to installer/data/mysql/de-DE/optional.i18n/patron_categories.txt >index 1ae0a5a..e5b13e5 100644 >--- a/installer/data/mysql/de-DE/optional/patron_categories.txt >+++ b/installer/data/mysql/de-DE/optional.i18n/patron_categories.txt >@@ -1,26 +1,26 @@ > Beispiele für Benutzerkategorien und -typen: > > Erwachsener Benutzer - Standardkategorie >- PT - Erwachsener >- ST - Student >- BH - Ans Haus gebunden >+ PT - Erwachsener >+ ST - Student >+ BH - Ans Haus gebunden > > Kind - Benutzer mit einem Bürgen >- K - Kind >- J - Jugendlicher >- YA - Junger Erwachsener >+ K - Kind >+ J - Jugendlicher >+ YA - Junger Erwachsener > > Organisation - Benutzer ist eine Institution, keine Person >- ILL - Fernleihbibliothek >- SC - Schule >- L - Bibliothek >+ ILL - Fernleihbibliothek >+ SC - Schule >+ L - Bibliothek > > Professioneller - Mitglied einer Organisation mit der Organisation als Bürgen >- T - Lehrer >- B - Gremienmitglied >- >+ T - Lehrer >+ B - Gremienmitglied >+ > Mitarbeiter - Benutzer ist Mitarbeiter der Bibliothek mit entsprechenden Berechtigungen >- S - Mitarbeiter >+ S - Mitarbeiter > > Die Benutzerkategorien sind fest codiert, Benutzertypen können aber jederzeit > im Administrationsbereich neu angelegt, geändert oder gelöscht werden. >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_creator_data.sql b/installer/data/mysql/de-DE/optional.i18n/sample_creator_data.sql >new file mode 100644 >index 0000000..9f0821d >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_creator_data.sql >@@ -0,0 +1,73 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:17, layout_xml >+WHEN '<opt></opt>' >+THEN '<opt></opt>' >+-- Statement 1, PK:18, layout_xml >+WHEN '<opt></opt>' >+THEN '<opt></opt>' >+-- Statement 1, PK:19, layout_xml >+WHEN '<opt></opt>' >+THEN '<opt></opt>' >+-- Statement 1, PK:20, layout_xml >+WHEN '<opt page_side="F" units="POINT"> >+ <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63"> >+ <data_source image_name="none" image_source="patronimages" /> >+ </images> >+ <text><firstname> <surname></text> >+ <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" /> >+ <text>Branch: <branchcode></text> >+ <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" /> >+ <text>Expires: August 31, 2010</text> >+ <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" /> >+</opt> >+' >+THEN '<opt page_side="F" units="POINT"> >+ <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63"> >+ <data_source image_name="none" image_source="patronimages" /> >+ </images> >+ <text><firstname> <surname></text> >+ <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" /> >+ <text>Bibliothek: <branchcode></text> >+ <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" /> >+ <text>Ablaufdatum: 31.06.2014</text> >+ <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" /> >+</opt> >+' >+ >+ >+ >+-- Statement 2, PK:1, template_desc >+WHEN '3 columns, 10 rows of labels' >+THEN '3 columns, 10 rows of labels' >+-- Statement 2, PK:7, template_desc >+WHEN '1\" X 1.5\" Spine Label | Setup for up to four lines of text' >+THEN '1\" X 1.5\" Spine Label | Setup for up to four lines of text' >+-- Statement 2, PK:12, template_desc >+WHEN '1\" X 1.5\" Spine Label | Setup for five lines of text' >+THEN '1\" X 1.5\" Spine Label | Setup for five lines of text' >+-- Statement 2, PK:22, template_desc >+WHEN 'Default description' >+THEN 'Default description' >+-- Statement 2, PK:23, template_desc >+WHEN 'A template for home brewed patron card forms' >+THEN 'A template for home brewed patron card forms' >+ >+ >+-- Statement 3, PK:1, printer_name >+WHEN 'Library Laser' >+THEN 'Library Laser' >+-- Statement 3, PK:11, printer_name >+WHEN 'Library Laser' >+THEN 'Library Laser' >+-- Statement 3, PK:16, printer_name >+WHEN 'Test Printer 01' >+THEN 'Test Printer 01' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_creator_data.txt b/installer/data/mysql/de-DE/optional.i18n/sample_creator_data.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_creator_data.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_creator_data.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_holidays.sql b/installer/data/mysql/de-DE/optional.i18n/sample_holidays.sql >new file mode 100644 >index 0000000..35bb45b >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_holidays.sql >@@ -0,0 +1,20 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:2, description >+WHEN 'Sundays' >+THEN 'Sonntag' >+-- Statement 1, PK:3, description >+WHEN 'New Year\'s Day' >+THEN 'Neujahr' >+-- Statement 1, PK:4, description >+WHEN 'Christmas' >+THEN '1. Weihnachtsfeiertag' >+-- Not found: 1,5,description >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_holidays.txt b/installer/data/mysql/de-DE/optional.i18n/sample_holidays.txt >new file mode 100644 >index 0000000..21c51b5 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_holidays.txt >@@ -0,0 +1,4 @@ >+Beispiele für SchlieÃtage: >+ Sonntag >+ 1. und 2. Weihnachtsfeiertag >+ Neujahr >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.sql b/installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.sql >new file mode 100644 >index 0000000..44cf290 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.sql >@@ -0,0 +1,34 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:'BK', description >+WHEN 'Books' >+THEN 'Bücher' >+-- Statement 1, PK:'MX', description >+WHEN 'Mixed Materials' >+THEN 'Medienkombinationen' >+-- Statement 1, PK:'CF', description >+WHEN 'Computer Files' >+THEN 'Datenträger' >+-- Statement 1, PK:'MP', description >+WHEN 'Maps' >+THEN 'Karten' >+-- Statement 1, PK:'VM', description >+WHEN 'Visual Materials' >+THEN 'AV-Medien' >+-- Statement 1, PK:'MU', description >+WHEN 'Music' >+THEN 'Musik' >+-- Statement 1, PK:'CR', description >+WHEN 'Continuing Resources' >+THEN 'Zeitschriften' >+-- Statement 1, PK:'REF', description >+WHEN 'Reference' >+THEN 'Nachschlagewerke' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_itemtypes.txt b/installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_itemtypes.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_itemtypes.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_libraries.sql b/installer/data/mysql/de-DE/optional.i18n/sample_libraries.sql >new file mode 100644 >index 0000000..1adc884 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_libraries.sql >@@ -0,0 +1,10 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_libraries.txt b/installer/data/mysql/de-DE/optional.i18n/sample_libraries.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_libraries.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_libraries.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_news.sql b/installer/data/mysql/de-DE/optional.i18n/sample_news.sql >new file mode 100644 >index 0000000..c66701b >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_news.sql >@@ -0,0 +1,28 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:1, title >+WHEN 'Welcome to Koha' >+THEN 'Willkommen bei Koha' >+-- Statement 1, PK:1, new >+WHEN 'Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.' >+THEN 'Willkommen bei Koha. Koha ist ein vollständiges integriertes Bibliothekssystem. Es wurde ursprünglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 für den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.' >+-- Statement 1, PK:1, lang >+WHEN 'koha' >+THEN 'koha' >+-- Statement 1, PK:2, title >+WHEN 'What\'s Next?' >+THEN 'Was kommt jetzt?' >+-- Statement 1, PK:2, new >+WHEN 'Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n' >+THEN 'Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige Vorschläge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n' >+-- Statement 1, PK:2, lang >+WHEN 'koha' >+THEN 'koha' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_news.txt b/installer/data/mysql/de-DE/optional.i18n/sample_news.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_news.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_news.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_patrons.sql b/installer/data/mysql/de-DE/optional.i18n/sample_patrons.sql >new file mode 100644 >index 0000000..1adc884 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_patrons.sql >@@ -0,0 +1,10 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_patrons.txt b/installer/data/mysql/de-DE/optional.i18n/sample_patrons.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_patrons.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_patrons.txt >diff --git a/installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.sql b/installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.sql >new file mode 100644 >index 0000000..ba6a5e4 >--- /dev/null >+++ b/installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.sql >@@ -0,0 +1,19 @@ >+DELIMITER // >+DROP FUNCTION IF EXISTS i18n// >+CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC >+BEGIN >+RETURN CASE d >+WHEN '' THEN '' >+-- Statement 1, PK:1, name >+WHEN 'LIBRARY OF CONGRESS' >+THEN 'LIBRARY OF CONGRESS' >+-- Statement 1, PK:6, name >+WHEN 'COLUMBIA UNIVERSITY' >+THEN 'COLUMBIA UNIVERSITY' >+-- Statement 1, PK:10, name >+WHEN 'SMITHSONIAN INSTITUTION LIBRARIES' >+THEN 'SMITHSONIAN INSTITUTION LIBRARIES' >+ >+ELSE d >+END; >+END // >\ No newline at end of file >diff --git a/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt b/installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.txt >similarity index 100% >rename from installer/data/mysql/de-DE/optional/sample_z3950_servers.txt >rename to installer/data/mysql/de-DE/optional.i18n/sample_z3950_servers.txt >diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql >deleted file mode 100644 >index 3c45e08..0000000 >--- a/installer/data/mysql/de-DE/optional/auth_val.sql >+++ /dev/null >@@ -1,59 +0,0 @@ >--- 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','Vorhandenes Exemplar beschädigt'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotheksexemplar vermisst'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Ãber Fernleihe bestellbar'); >- >--- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren'); >-INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt'); >-INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Vermisst'); >- >--- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt'); >- >--- location qualification for an item, departments are linked by default to items.location >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Belletristik'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Kinderbibliothek'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','Medienausstellung'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Neuerwerbungsregal'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Mitarbeiterbüro'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Magazin'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','AV-Mediensammlung'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Nachschlagewerke'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Einstellwagen'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','In Bearbeitung'); >- >--- collection codes for an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Belletristik'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Nachschlagewerke'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur'); >- >--- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden'); >- >--- loanability status of an item, linked to items.notforloan >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek'); >- >--- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich'); >- >--- manual invoice types >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Kopiergebühren','.25'); >- >--- custom borrower notes >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Adresse kontrollieren'); >- >--- OPAC Suggestions reasons >-INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','Vorhandenes Exemplar ist beschädigt','Vorhandenes Exemplar ist beschädigt'); >-INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Neuerscheinung von bekanntem Verfasser','Neuerscheinung von bekanntem Verfasser'); >- >--- Report groups >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Ausleihe'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Benutzer'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Erwerbung'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Gebühren'); >diff --git a/installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.sql b/installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.sql >deleted file mode 100644 >index adc3ea7..0000000 >--- a/installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.sql >+++ /dev/null >@@ -1,145 +0,0 @@ >--- 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/de-DE/optional/parameters.sql b/installer/data/mysql/de-DE/optional/parameters.sql >deleted file mode 100644 >index e5e8dcc..0000000 >--- a/installer/data/mysql/de-DE/optional/parameters.sql >+++ /dev/null >@@ -1,6 +0,0 @@ >-INSERT INTO `currency` (currency, rate, symbol, active) VALUES >-('USD', 1.3112, '$', 0), >-('GBP', 0.8548, '£', 0), >-('CAD', 1.3290, '$', 0), >-('EUR', 1.0000, 'â¬', 1); >- >diff --git a/installer/data/mysql/de-DE/optional/patron_atributes.sql b/installer/data/mysql/de-DE/optional/patron_atributes.sql >deleted file mode 100644 >index 35d61cb..0000000 >--- a/installer/data/mysql/de-DE/optional/patron_atributes.sql >+++ /dev/null >@@ -1,2 +0,0 @@ >-INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `password_allowed`, `staff_searchable`, `authorised_value_category`) >-VALUES ('SHOW_BCODE', 'Zeige den Barcode in der Exemplarübersicht', 0, 0, 1, 0, 0, 'YES_NO'); >diff --git a/installer/data/mysql/de-DE/optional/patron_categories.sql b/installer/data/mysql/de-DE/optional/patron_categories.sql >deleted file mode 100644 >index 5fe7c02..0000000 >--- a/installer/data/mysql/de-DE/optional/patron_categories.sql >+++ /dev/null >@@ -1,23 +0,0 @@ >-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES >- >--- Adult Patrons >-('PT','Erwachsener',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','Ans Haus gebunden',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), >- >--- Children >-('K','Kind',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), >-('J','Jugendlicher',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), >-('YA','Junger Erwachsener',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), >- >--- Professionals >-('T','Lehrer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), >-('B','Gremienmitglied',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'), >- >--- Institutional >-('IL','Fernleihbibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), >-('SC','Schule',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), >-('L','Bibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), >- >--- Staff >-('S','Mitarbeiter',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S'); >diff --git a/installer/data/mysql/de-DE/optional/sample_creator_data.sql b/installer/data/mysql/de-DE/optional/sample_creator_data.sql >deleted file mode 100644 >index 03fec5b..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_creator_data.sql >+++ /dev/null >@@ -1,17 +0,0 @@ >-INSERT INTO `creator_layouts` (layout_id, barcode_type, start_label, printing_type, layout_name, guidebox, font, font_size, units, callnum_split, text_justify, format_string, layout_xml, creator) VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT"> >- <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63"> >- <data_source image_name="none" image_source="patronimages" /> >- </images> >- <text><firstname> <surname></text> >- <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" /> >- <text>Bibliothek: <branchcode></text> >- <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" /> >- <text>Ablaufdatum: 31.06.2014</text> >- <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" /> >-</opt> >-','Patroncards'); >- >- >-INSERT INTO `creator_templates` (template_id, profile_id, template_code, template_desc, page_width, page_height, label_width, label_height, top_text_margin, left_text_margin, top_margin, left_margin, cols, rows, col_gap, row_gap, units, creator) 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'); >- >-INSERT INTO printers_profile (profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator) 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'); >diff --git a/installer/data/mysql/de-DE/optional/sample_holidays.sql b/installer/data/mysql/de-DE/optional/sample_holidays.sql >deleted file mode 100644 >index 0d03a9f..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_holidays.sql >+++ /dev/null >@@ -1,5 +0,0 @@ >-INSERT INTO repeatable_holidays (id,branchcode,weekday,day,month,title,description) VALUES >-(2,'MPL',0,NULL,NULL,'','Sonntag'), >-(3,'MPL',NULL,1,1,'','Neujahr'), >-(4,'MPL',NULL,25,12,'','1. Weihnachtsfeiertag'), >-(5,'MPL',NULL,25,12,'','2. Weihnachtsfeiertag'); >diff --git a/installer/data/mysql/de-DE/optional/sample_holidays.txt b/installer/data/mysql/de-DE/optional/sample_holidays.txt >deleted file mode 100644 >index 947baea..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_holidays.txt >+++ /dev/null >@@ -1,4 +0,0 @@ >-Beispiele für SchlieÃtage: >- Sonntag >- 1. und 2. Weihnachtsfeiertag >- Neujahr >diff --git a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql b/installer/data/mysql/de-DE/optional/sample_itemtypes.sql >deleted file mode 100644 >index a101ade..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql >+++ /dev/null >@@ -1,9 +0,0 @@ >-INSERT INTO `itemtypes` (itemtype,description,rentalcharge,notforloan,imageurl,summary) VALUES >-('BK', 'Bücher',0,0,'bridge/book.gif',''), >-('MX', 'Medienkombinationen',0,0,'bridge/kit.gif',''), >-('CF', 'Datenträger',0,0,'bridge/computer_file.gif',''), >-('MP', 'Karten',0,0,'bridge/map.gif',''), >-('VM', 'AV-Medien',0,1,'bridge/dvd.gif',''), >-('MU', 'Musik',0,0,'bridge/sound.gif',''), >-('CR', 'Zeitschriften',0,0,'bridge/periodical.gif',''), >-('REF', 'Nachschlagewerke',0,1,'bridge/reference.gif',''); >diff --git a/installer/data/mysql/de-DE/optional/sample_libraries.sql b/installer/data/mysql/de-DE/optional/sample_libraries.sql >deleted file mode 100644 >index 58dc24e..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_libraries.sql >+++ /dev/null >@@ -1,15 +0,0 @@ >-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') >-; >diff --git a/installer/data/mysql/de-DE/optional/sample_news.sql b/installer/data/mysql/de-DE/optional/sample_news.sql >deleted file mode 100644 >index 6a61d44..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_news.sql >+++ /dev/null >@@ -1,3 +0,0 @@ >-INSERT INTO `opac_news` (idnew,title,new,lang,timestamp,expirationdate,number) VALUES >-(1,'Willkommen bei Koha','Willkommen bei Koha. Koha ist ein vollständiges integriertes Bibliothekssystem. Es wurde ursprünglich in Neuseeland von Katipo Communications Ltd entwickelt und ging im Januar 2000 für den Horowhenua Library Trust zum ersten mal in Produktion. Koha wird heute von einem internationalen Team aus Support-Dienstleistern und Anwendern weiterentwickelt.','koha','2007-10-29 05:25:58','2099-01-10',1), >-(2,'Was kommt jetzt?','Wie geht es weiter, nachdem Sie Koha installiert haben? Hier einige Vorschläge:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Lesen Sie die Koha-Dokumentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Lesen oder Schreiben Sie im Koha-Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Verfolgen oder beteiligen Sie sich an Diskussionen</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Melden Sie Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Erstellen Sie Fehlerkorrekturen mit GIT (Versionskontrollsystem)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chatten Sie mit Koha-Anwendern und -Entwicklern</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2); >diff --git a/installer/data/mysql/de-DE/optional/sample_patrons.sql b/installer/data/mysql/de-DE/optional/sample_patrons.sql >deleted file mode 100644 >index 809dea5..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_patrons.sql >+++ /dev/null >@@ -1,52 +0,0 @@ >-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,NULL,NULL,'MPL','S',NULL,'2099-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,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/de-DE/optional/sample_z3950_servers.sql b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql >deleted file mode 100644 >index 472d8eb..0000000 >--- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql >+++ /dev/null >@@ -1,5 +0,0 @@ >-INSERT INTO `z3950servers` >-(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES >-('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), >-('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), >-('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); >-- >1.7.7.6
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10521
:
20166
|
20167
|
20168
| 20169 |
20170
|
20171
|
20172
|
20173