Attachment #20169 for bug #10521

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




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 //




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 //

Line 0 Link Here

(-)a/installer/data/mysql/de-DE/optional.i18n/parameters.sql (+11 lines)
	1	DELIMITER //
	2	DROP FUNCTION IF EXISTS i18n//
	3	CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
	4	BEGIN
	5	RETURN CASE d
	6	WHEN '' THEN ''
	7
	8
	9	ELSE d
	10	END;
	11	END //




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 //




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 //




Beispiele für Benutzerkategorien und -typen:

Erwachsener Benutzer - Standardkategorie
                PT	- Erwachsener
                ST	- Student
                BH	- Ans Haus gebunden

Kind - Benutzer mit einem Bürgen
                K	- Kind
                J	- Jugendlicher
                YA	- Junger Erwachsener

Organisation - Benutzer ist eine Institution, keine Person
                ILL	- Fernleihbibliothek
                SC	- Schule
                L	- Bibliothek

Professioneller - Mitglied einer Organisation mit der Organisation als Bürgen
                T	- Lehrer
                B	- Gremienmitglied

Mitarbeiter - Benutzer ist Mitarbeiter der Bibliothek mit entsprechenden Berechtigungen
                S	- Mitarbeiter

Die Benutzerkategorien sind fest codiert, Benutzertypen können aber jederzeit
im Administrationsbereich neu angelegt, geändert oder gelöscht werden.




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>&lt;firstname&gt; &lt;surname&gt;</text>
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
  <text>Branch: &lt;branchcode&gt;</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>&lt;firstname&gt; &lt;surname&gt;</text>
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
  <text>Bibliothek: &lt;branchcode&gt;</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 //




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 //

Line 0 Link Here

(-)a/installer/data/mysql/de-DE/optional.i18n/sample_holidays.txt (+4 lines)
	1	Beispiele für Schließtage:
	2	Sonntag
	3	1. und 2. Weihnachtsfeiertag
	4	Neujahr




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 //

Line 0 Link Here

(-)a/installer/data/mysql/de-DE/optional.i18n/sample_libraries.sql (+10 lines)
	1	DELIMITER //
	2	DROP FUNCTION IF EXISTS i18n//
	3	CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
	4	BEGIN
	5	RETURN CASE d
	6	WHEN '' THEN ''
	7
	8	ELSE d
	9	END;
	10	END //




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 //

Line 0 Link Here

(-)a/installer/data/mysql/de-DE/optional.i18n/sample_patrons.sql (+10 lines)
	1	DELIMITER //
	2	DROP FUNCTION IF EXISTS i18n//
	3	CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
	4	BEGIN
	5	RETURN CASE d
	6	WHEN '' THEN ''
	7
	8	ELSE d
	9	END;
	10	END //




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 //




-- 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');




-- 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)');


Lines 1-6 Link Here

(-)a/installer/data/mysql/de-DE/optional/parameters.sql (-6 lines)
1	INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2	('USD', 1.3112, '$', 0),
3	('GBP', 0.8548, '£', 0),
4	('CAD', 1.3290, '$', 0),
5	('EUR', 1.0000, '€', 1);
6

Lines 1-2 Link Here

(-)a/installer/data/mysql/de-DE/optional/patron_atributes.sql (-2 lines)
1	INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `password_allowed`, `staff_searchable`, `authorised_value_category`)
2	VALUES ('SHOW_BCODE', 'Zeige den Barcode in der Exemplarübersicht', 0, 0, 1, 0, 0, 'YES_NO');

Lines 1-23 Link Here

(-)a/installer/data/mysql/de-DE/optional/patron_categories.sql (-23 lines)
1	INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
2
3	-- Adult Patrons
4	('PT','Erwachsener',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5	('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6	('HB','Ans Haus gebunden',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
7
8	-- Children
9	('K','Kind',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10	('J','Jugendlicher',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11	('YA','Junger Erwachsener',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
12
13	-- Professionals
14	('T','Lehrer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
15	('B','Gremienmitglied',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
16
17	-- Institutional
18	('IL','Fernleihbibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19	('SC','Schule',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20	('L','Bibliothek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
21
22	-- Staff
23	('S','Mitarbeiter',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');




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>&lt;firstname&gt; &lt;surname&gt;</text>
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
  <text>Bibliothek: &lt;branchcode&gt;</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');

Lines 1-5 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_holidays.sql (-5 lines)
1	INSERT INTO repeatable_holidays (id,branchcode,weekday,day,month,title,description) VALUES
2	(2,'MPL',0,NULL,NULL,'','Sonntag'),
3	(3,'MPL',NULL,1,1,'','Neujahr'),
4	(4,'MPL',NULL,25,12,'','1. Weihnachtsfeiertag'),
5	(5,'MPL',NULL,25,12,'','2. Weihnachtsfeiertag');

Lines 1-4 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_holidays.txt (-4 lines)
1	Beispiele für Schließtage:
2	Sonntag
3	1. und 2. Weihnachtsfeiertag
4	Neujahr

Lines 1-9 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_itemtypes.sql (-9 lines)
1	INSERT INTO `itemtypes` (itemtype,description,rentalcharge,notforloan,imageurl,summary) VALUES
2	('BK', 'Bücher',0,0,'bridge/book.gif',''),
3	('MX', 'Medienkombinationen',0,0,'bridge/kit.gif',''),
4	('CF', 'Datenträger',0,0,'bridge/computer_file.gif',''),
5	('MP', 'Karten',0,0,'bridge/map.gif',''),
6	('VM', 'AV-Medien',0,1,'bridge/dvd.gif',''),
7	('MU', 'Musik',0,0,'bridge/sound.gif',''),
8	('CR', 'Zeitschriften',0,0,'bridge/periodical.gif',''),
9	('REF', 'Nachschlagewerke',0,1,'bridge/reference.gif','');




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')
;

Lines 1-3 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_news.sql (-3 lines)
1	INSERT INTO `opac_news` (idnew,title,new,lang,timestamp,expirationdate,number) VALUES
2	(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),
3	(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);

Lines 1-52 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_patrons.sql (-52 lines)
1	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
2
3	(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),
4	(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'),
5	(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'),
6	(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'),
7	(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'),
8	(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'),
9	(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'),
10	(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'),
11	(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'),
12	(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'),
13	(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'),
14	(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'),
15	(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'),
16	(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'),
17	(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'),
18	(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'),
19	(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'),
20	(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'),
21	(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'),
22	(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'),
23	(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'),
24	(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'),
25	(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'),
26	(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'),
27	(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'),
28	(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'),
29	(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'),
30	(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'),
31	(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'),
32	(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'),
33	(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'),
34	(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'),
35	(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'),
36	(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'),
37	(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'),
38	(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'),
39	(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'),
40	(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'),
41	(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'),
42	(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'),
43	(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'),
44	(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'),
45	(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'),
46	(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'),
47	(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'),
48	(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'),
49	(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'),
50	(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'),
51	(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'),
52	(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');

Lines 1-5 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql (-6 lines)
1	INSERT INTO `z3950servers`
2	(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES
3	('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'),
4	('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'),
5	('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8');
6	-

Return to bug 10521

Lines 1-26 Link Here

(-)a/installer/data/mysql/de-DE/optional/patron_categories.txt (-13 / +13 lines)
1	Beispiele für Benutzerkategorien und -typen:	1	Beispiele für Benutzerkategorien und -typen:
2		2
3	Erwachsener Benutzer - Standardkategorie	3	Erwachsener Benutzer - Standardkategorie
4	PT - Erwachsener	4	PT - Erwachsener
5	ST - Student	5	ST - Student
6	BH - Ans Haus gebunden	6	BH - Ans Haus gebunden
7		7
8	Kind - Benutzer mit einem Bürgen	8	Kind - Benutzer mit einem Bürgen
9	K - Kind	9	K - Kind
10	J - Jugendlicher	10	J - Jugendlicher
11	YA - Junger Erwachsener	11	YA - Junger Erwachsener
12		12
13	Organisation - Benutzer ist eine Institution, keine Person	13	Organisation - Benutzer ist eine Institution, keine Person
14	ILL - Fernleihbibliothek	14	ILL - Fernleihbibliothek
15	SC - Schule	15	SC - Schule
16	L - Bibliothek	16	L - Bibliothek
17		17
18	Professioneller - Mitglied einer Organisation mit der Organisation als Bürgen	18	Professioneller - Mitglied einer Organisation mit der Organisation als Bürgen
19	T - Lehrer	19	T - Lehrer
20	B - Gremienmitglied	20	B - Gremienmitglied
21		21
22	Mitarbeiter - Benutzer ist Mitarbeiter der Bibliothek mit entsprechenden Berechtigungen	22	Mitarbeiter - Benutzer ist Mitarbeiter der Bibliothek mit entsprechenden Berechtigungen
23	S - Mitarbeiter	23	S - Mitarbeiter
24		24
25	Die Benutzerkategorien sind fest codiert, Benutzertypen können aber jederzeit	25	Die Benutzerkategorien sind fest codiert, Benutzertypen können aber jederzeit
26	im Administrationsbereich neu angelegt, geändert oder gelöscht werden.	26	im Administrationsbereich neu angelegt, geändert oder gelöscht werden.

Lines 1-59 Link Here

(-)a/installer/data/mysql/de-DE/optional/auth_val.sql (-59 lines)
1	-- Reasons for acceptance or rejection of suggestions in acquisitions
2	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
3	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt');
4	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotheksexemplar vermisst');
5	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Über Fernleihe bestellbar');
6
7	-- availability statuses
8	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)');
9	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren');
10	INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt');
11	INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Vermisst');
12
13	-- damaged status of an item
14	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt');
15
16	-- location qualification for an item, departments are linked by default to items.location
17	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Belletristik');
18	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Kinderbibliothek');
19	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','Medienausstellung');
20	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Neuerwerbungsregal');
21	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Mitarbeiterbüro');
22	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Magazin');
23	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','AV-Mediensammlung');
24	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Nachschlagewerke');
25	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Einstellwagen');
26	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','In Bearbeitung');
27
28	-- collection codes for an item
29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Belletristik');
30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Nachschlagewerke');
31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur');
32
33	-- withdrawn status of an item, linked to items.wthdrawn
34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden');
35
36	-- loanability status of an item, linked to items.notforloan
37	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt');
38	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar');
39	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek');
40
41	-- restricted status of an item, linked to items.restricted
42	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich');
43
44	-- manual invoice types
45	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Kopiergebühren','.25');
46
47	-- custom borrower notes
48	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Adresse kontrollieren');
49
50	-- OPAC Suggestions reasons
51	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','Vorhandenes Exemplar ist beschädigt','Vorhandenes Exemplar ist beschädigt');
52	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Neuerscheinung von bekanntem Verfasser','Neuerscheinung von bekanntem Verfasser');
53
54	-- Report groups
55	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Ausleihe');
56	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog');
57	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Benutzer');
58	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Erwerbung');
59	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Gebühren');

Lines 1-145 Link Here

(-)a/installer/data/mysql/de-DE/optional/marc21_holdings_coded_values.sql (-145 lines)
1	-- Coded values conforming to the Z39.77-2006 Holdings Statements for Bibliographic Items');
2	-- ISSN: 1041-5653
3	-- Refer to http://www.niso.org/standards/index.html
4
5	-- General Holdings: Type of Unit Designator
6	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');
7	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','c','Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units');
8	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes');
9
10	-- Physical Form Designators
11	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Cartographic material');
12	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas');
13	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram');
14	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map');
15	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ak' ,'Cartographic material, profile');
16	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aq' ,'Cartographic material, model');
17	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ar' ,'Cartographic material, remote sensing image');
18	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','as' ,'Cartographic material, section');
19	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view');
20	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other');
21
22	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Computer file');
23	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge');
24	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge');
25	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge');
26	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cf' ,'Computer file, tape cassette');
27	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel');
28	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk');
29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk');
30	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Computer file, optical disk');
31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote');
32	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other');
33
34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','du' ,'Globe');
35	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','da' ,'Globe, celestial');
36	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','db' ,'Globe, planetary or lunar');
37	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dc' ,'Globe, terrestrial');
38	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon');
39	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other');
40
41	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Kit');
42
43	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Microform');
44	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card');
45	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge');
46	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette');
47	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hd',' Microform, microfilm reel');
48	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','he' ,'Microform, microfiche');
49	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hf' ,'Microform, microfiche cassette');
50	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque');
51	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other');
52
53	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Motion picture');
54	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge');
55	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette');
56	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel');
57	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other');
58
59	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Nonprojected graphic');
60	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage');
61	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing');
62
63	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Nonprojected graphic, painting');
64	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print');
65	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative');
66	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint');
67	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ki' ,'Nonprojected graphic, picture');
68	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kj' ,'Nonprojected graphic, print');
69	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kl' ,'Nonprojected graphic, technical drawing');
70	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kn' ,'Nonprojected graphic, chart');
71	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card');
72	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other');
73
74	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Notated music');
75
76	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic');
77	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge');
78	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gd' ,'Projected graphic, filmstrip');
79	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gf' ,'Projected graphic, other type of filmstrip');
80	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','go' ,'Projected graphic, filmstrip roll');
81	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gs' ,'Projected graphic, slide');
82	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gt' ,'Projected graphic, transparency');
83	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gz' ,'Projected graphic, other');
84
85	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image');
86
87	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Sound recording');
88	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Sound recording, sound disk');
89	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder');
90	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge');
91	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film');
92	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll');
93	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'Sound recording, sound cassette');
94	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel');
95	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording');
96	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other');
97
98	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Text');
99	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Text, regular print');
100	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Text, large print');
101	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Text, Braille');
102	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf');
103	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other');
104
105	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videorecording');
106	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge');
107	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'Videorecording, videodisc');
108	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'Videorecording, videocassette');
109	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel');
110	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other');
111
112	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zu' ,'Physical form is unspecified');
113	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zm' ,'Multiple physical forms');
114	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zz' ,'Other physical media');
115
116	-- General Holdings: Completeness Designator
117	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','0','Information not available, or Retention is limited');
118	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','1','Complete (95%-100% held)');
119	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','2','Incomplete (50%-94% held)');
120	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','3','Very incomplete or scattered (less than 50% held)');
121	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','4','Not applicable');
122
123	-- General Holdings: Acquisition Status Designator
124	-- This data element specifies acquisition status for the unit at the time of the holdings report.
125
126	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited');
127	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other');
128	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased');
129	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','On order');
130	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Currently received');
131	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Not currently received');
132
133	-- General Holdings: Retention Designator
134	-- This data element specifies the retention policy for the unit at the time of the holdings report.
135
136	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','0','Information not available');
137	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','1','Other');
138	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','2','Retained except as replaced by updates');
139	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','3','Sample issue retained');
140	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','4','Retained until replaced by microform, or other preservation format');
141	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','5','Retained until replaced by cumulation, replacement volume, or revision');
142	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','6','Limited retention (only some parts kept)');
143	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','7','No retention (no parts kept)');
144	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','8','Permanent retention (all parts kept permanently)');
145

Lines 1-17 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_creator_data.sql (-17 lines)
1	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">
2	<images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
3	<data_source image_name="none" image_source="patronimages" />
4	</images>
5	<text><firstname> <surname></text>
6	<text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
7	<text>Bibliothek: <branchcode></text>
8	<text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
9	<text>Ablaufdatum: 31.06.2014</text>
10	<text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
11	</opt>
12	','Patroncards');
13
14
15	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');
16
17	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');

Lines 1-15 Link Here

(-)a/installer/data/mysql/de-DE/optional/sample_libraries.sql (-15 lines)
1	INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
2
3	('MPL','Midway','372 Forest Street'),
4	('SPL','Springfield','Highland Boulevard'),
5	('RPL','Riverside','Johnson Terrace'),
6	('CPL','Centerville','Jefferson Summit'),
7	('FPL','Fairview','Hickory Squere'),
8	('FFL','Fairfield','River Station'),
9	('IPT','Institut Protestant de Théologie',''),
10	('PVL','Pleasant Valley','Meadow Grove'),
11	('TPL','Troy','Valley Way'),
12	('FRL','Franklin','Smith Heights'),
13	('LPL','Liberty','East Hills'),
14	('UPL','Union','Chestnut Hollow')
15	;