From 1edc8196fdf6a25e1f75e8b5b46398dd1ede4ed2 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Sat, 6 Jul 2013 14:04:37 +0200 Subject: [PATCH] Bug 10520: Add i18n function to en/optional mysql files Content-Type: text/plain; charset=utf-8 Main goal: Adds i18n calls around translatable columns. Additionally: Removes backtics. Adds column names in inserts (where missing). Uses consistent style (based on my interpretation of coding guidelines). Removed some locking statements in sample_creator_data. NOTE: Some scripts insert numbers in auto-increment columns. Although this works, I would not prefer to do so. This patch however is not meant to change that, so leaves them for now. Test plan: Make sure that you apply this patch on top of the 10509 patches! Run English mysql install. Verify that you include all OPTIONAL files (in the OTHER DATA section). Check if webinstaller does not report errors. Inspect table contents via interface or mysql. Search for a column not using i18n where you would expect translation. Note: If you prefer to run the mysql files from command line, please make sure now that you define a 'fake' i18n, doing nothing (see Installer.pm code). Signed-off-by: Marcel de Rooy Tested all optional data via webinstaller. Signed-off-by: Kyle M Hall --- installer/data/mysql/en/optional/auth_val.sql | 144 +++- .../en/optional/marc21_holdings_coded_values.sql | 483 ++++++++--- .../data/mysql/en/optional/marc21_relatorterms.sql | 892 +++++++++++++++----- installer/data/mysql/en/optional/parameters.sql | 12 +- .../data/mysql/en/optional/patron_atributes.sql | 5 +- .../data/mysql/en/optional/patron_categories.sql | 38 +- .../data/mysql/en/optional/sample_creator_data.sql | 44 +- .../data/mysql/en/optional/sample_holidays.sql | 10 +- .../data/mysql/en/optional/sample_itemtypes.sql | 19 +- .../data/mysql/en/optional/sample_libraries.sql | 34 +- installer/data/mysql/en/optional/sample_news.sql | 7 +- .../data/mysql/en/optional/sample_patrons.sql | 105 ++-- installer/data/mysql/en/optional/sample_quotes.sql | 68 +- .../mysql/en/optional/sample_z3950_servers.sql | 11 +- 14 files changed, 1310 insertions(+), 562 deletions(-) diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql index 5318cee..38b4e17 100644 --- a/installer/data/mysql/en/optional/auth_val.sql +++ b/installer/data/mysql/en/optional/auth_val.sql @@ -1,59 +1,131 @@ -- Reasons for acceptance or rejection of suggestions in acquisitions -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Shelf Copy Damaged'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('SUGGEST', 'BSELL', i18n('Bestseller')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('SUGGEST', 'SCD', i18n('Shelf Copy Damaged')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('SUGGEST', 'LCL', i18n('Library Copy Lost')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('SUGGEST', 'AVILL', i18n('Available via ILL')); -- availability statuses -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); -INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); -INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOST', '2', i18n('Long Overdue (Lost)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOST', '1', i18n('Lost')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOST', '3', i18n('Lost and Paid For')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOST', '4', i18n('Missing')); -- damaged status of an item -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('DAMAGED', '1', i18n('Damaged')); -- location qualification for an item, departments are linked by default to items.location -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Children\'s Area'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','On Display'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','New Materials Shelf'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Staff Office'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'FIC', i18n('Fiction')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'CHILD', i18n('Children\'s Area')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'DISPLAY', i18n('On Display')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'NEW', i18n('New Materials Shelf')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'STAFF', i18n('Staff Office')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'GEN', i18n('General Stacks')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'AV', i18n('Audio Visual')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'REF', i18n('Reference')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'CART', i18n('Book Cart')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('LOC', 'PROC', i18n('Processing Center')); -- collection codes for an item -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('CCODE', 'FIC', i18n('Fiction')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('CCODE', 'REF', i18n('Reference')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('CCODE', 'NFIC', i18n('Non Fiction')); -- withdrawn status of an item, linked to items.withdrawn -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('WITHDRAWN', '1', i18n('Withdrawn')); -- loanability status of an item, linked to items.notforloan -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('NOT_LOAN', '-1', i18n('Ordered')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('NOT_LOAN', '1', i18n('Not For Loan')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('NOT_LOAN', '2', i18n('Staff Collection')); -- restricted status of an item, linked to items.restricted -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RESTRICTED', '1', i18n('Restricted Access')); -- manual invoice types -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Copier Fees','.25'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('MANUAL_INV', 'Copier Fees', i18n('.25')); -- custom borrower notes -INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('BOR_NOTES', 'ADDR', i18n('Address Notes')); -- OPAC Suggestions reasons -INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged'); -INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author'); +INSERT +INTO authorised_values (category, authorised_value, lib, lib_opac) +VALUES ('OPAC_SUG', 'damaged', i18n('The copy on the shelf is damaged'), i18n('The copy on the shelf is damaged')); +INSERT +INTO authorised_values (category, authorised_value, lib, lib_opac) +VALUES ('OPAC_SUG', 'bestseller', i18n('Upcoming title by popular author'), i18n('Upcoming title by popular author')); -- Report groups -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Catalog'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Patrons'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('REPORT_GROUP', 'CIRC', i18n('Circulation')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('REPORT_GROUP', 'CAT', i18n('Catalog')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('REPORT_GROUP', 'PAT', i18n('Patrons')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('REPORT_GROUP', 'ACQ', i18n('Acquisitions')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('REPORT_GROUP', 'ACC', i18n('Accounts')); diff --git a/installer/data/mysql/en/optional/marc21_holdings_coded_values.sql b/installer/data/mysql/en/optional/marc21_holdings_coded_values.sql index adc3ea7..a6cb965 100644 --- a/installer/data/mysql/en/optional/marc21_holdings_coded_values.sql +++ b/installer/data/mysql/en/optional/marc21_holdings_coded_values.sql @@ -3,143 +3,372 @@ -- 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'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_UT', '0', i18n('Information not available; Not applicable')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_UT', 'a', i18n('Basic bibliographic unit')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_UT', 'c', i18n('Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_UT', 'd', i18n('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'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'au', i18n('Cartographic material')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ad', i18n('Cartographic material, atlas')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ag', i18n('Cartographic material, diagram')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'aj', i18n('Cartographic material, map')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ak', i18n('Cartographic material, profile')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'aq', i18n('Cartographic material, model')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ar', i18n('Cartographic material, remote sensing image')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'as', i18n('Cartographic material, section')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ay', i18n('Cartographic material, view')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'az', i18n('Cartographic material, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cu', i18n('Computer file')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ca', i18n('Computer file, tape cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cb', i18n('Computer file, chip cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cc', i18n('Computer file, computer optical disk cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cf', i18n('Computer file, tape cassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ch', i18n('Computer file, tape reel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cj', i18n('Computer file, magnetic disk')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cm', i18n('Computer file, magneto-optical disk')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'co', i18n('Computer file, optical disk')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cr', i18n('Computer file, remote')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'cz', i18n('Computer file, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'du', i18n('Globe')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'da', i18n('Globe, celestial')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'db', i18n('Globe, planetary or lunar')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'dc', i18n('Globe, terrestrial')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'de', i18n('Globe, earth moon')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'dz', i18n('Globe, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ou', i18n('Kit')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hu', i18n('Microform')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ha', i18n('Microform, aperture card')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hb', i18n(' Microform, microfilm cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hc', i18n(' Microform, microfilm cassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hd', i18n(' Microform, microfilm reel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'he', i18n('Microform, microfiche')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hf', i18n('Microform, microfiche cassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hg', i18n('Microform, micro-opaque')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'hz', i18n('Microform, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'mu', i18n('Motion picture')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'mc', i18n('Motion picture, film cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'mf', i18n('Motion picture, film cassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'mr', i18n('Motion picture, film reel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'mz', i18n('Motion picture, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ku', i18n('Nonprojected graphic')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kc', i18n('Nonprojected graphic, collage')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kd', i18n('Nonprojected graphic, drawing')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ke', i18n('Nonprojected graphic, painting')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kf', i18n('Nonprojected graphic, photomechanical print')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kg', i18n('Nonprojected graphic, photonegative')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kh', i18n('Nonprojected graphic, photoprint')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ki', i18n('Nonprojected graphic, picture')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kj', i18n('Nonprojected graphic, print')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kl', i18n('Nonprojected graphic, technical drawing')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kn', i18n('Nonprojected graphic, chart')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ko', i18n('Nonprojected graphic, flash card')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'kz', i18n('Nonprojected graphic, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'qu', i18n('Notated music')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gu', i18n('Projected graphic')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gc', i18n('Projected graphic, filmstrip cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gd', i18n('Projected graphic, filmstrip')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gf', i18n('Projected graphic, other type of filmstrip')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'go', i18n('Projected graphic, filmstrip roll')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gs', i18n('Projected graphic, slide')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gt', i18n('Projected graphic, transparency')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'gz', i18n('Projected graphic, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ru', i18n('Remote-sensing image')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'su', i18n('Sound recording')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'sd', i18n('Sound recording, sound disk')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'se', i18n('Sound recording, cylinder')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'sg', i18n('Sound recording, sound cartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'si', i18n('Sound recording, sound-track film')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'sq', i18n('Sound recording, roll')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ss', i18n('Sound recording, sound cassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'st', i18n('Sound recording, sound-tape reel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'sw', i18n('Sound recording, wire recording')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'sz', i18n('Sound recording, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'tu', i18n('Text')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'ta', i18n('Text, regular print')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'tb', i18n('Text, large print')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'tc', i18n('Text, Braille')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'td', i18n('Text, loose-leaf')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'tz', i18n('Text, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vu', i18n('Videorecording')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vc', i18n('Videorecording, videocartridge')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vd', i18n('Videorecording, videodisc')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vf', i18n('Videorecording, videocassette')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vr', i18n('Videorecording, videoreel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'vz', i18n('Videorecording, other')); + +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'zu', i18n('Physical form is unspecified')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'zm', i18n('Multiple physical forms')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_PF', 'zz', i18n('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'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_C', '0', i18n('Information not available, or Retention is limited')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_C', '1', i18n('Complete (95%-100% held)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_C', '2', i18n('Incomplete (50%-94% held)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_C', '3', i18n('Very incomplete or scattered (less than 50% held)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_C', '4', i18n('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'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '0', i18n('Information not available, or Retention is limited')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '1', i18n('Other')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '2', i18n('Received and complete or Ceased')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '3', i18n('On order')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '4', i18n('Currently received')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_AS', '5', i18n('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)'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '0', i18n('Information not available')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '1', i18n('Other')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '2', i18n('Retained except as replaced by updates')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '3', i18n('Sample issue retained')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '4', i18n('Retained until replaced by microform, or other preservation format')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '5', i18n('Retained until replaced by cumulation, replacement volume, or revision')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '6', i18n('Limited retention (only some parts kept)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '7', i18n('No retention (no parts kept)')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('HINGS_RD', '8', i18n('Permanent retention (all parts kept permanently)')); diff --git a/installer/data/mysql/en/optional/marc21_relatorterms.sql b/installer/data/mysql/en/optional/marc21_relatorterms.sql index 485bbed..fc9c3c2 100644 --- a/installer/data/mysql/en/optional/marc21_relatorterms.sql +++ b/installer/data/mysql/en/optional/marc21_relatorterms.sql @@ -1,226 +1,672 @@ -- MARC code list for Relators, taken from -- http://www.loc.gov/marc/relators/relacode.html -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Correspondent'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Libelee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Lender'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Libelee-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Lighting designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Libelant-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Libelant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Libelant-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Landscape architect'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Printer of plates'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Patent holder'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Respondent-appellant'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Research team head'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Research team member'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Scientific advisor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Scenarist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Sculptor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness'); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'acp', i18n('Art copyist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'act', i18n('Actor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'adp', i18n('Adapter')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aft', i18n('Author of afterword, colophon, etc.')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'anl', i18n('Analyst')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'anm', i18n('Animator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ann', i18n('Annotator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ant', i18n('Bibliographic antecedent')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'app', i18n('Applicant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aqt', i18n('Author in quotations or text abstracts')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'arc', i18n('Architect')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ard', i18n('Artistic director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'arr', i18n('Arranger')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'art', i18n('Artist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'asg', i18n('Assignee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'asn', i18n('Associated name')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'att', i18n('Attributed name')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'auc', i18n('Auctioneer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aud', i18n('Author of dialog')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aui', i18n('Author of introduction')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aus', i18n('Author of screenplay')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'aut', i18n('Author')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bdd', i18n('Binding designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bjd', i18n('Bookjacket designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bkd', i18n('Book designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bkp', i18n('Book producer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'blw', i18n('Blurb writer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bnd', i18n('Binder')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bpd', i18n('Bookplate designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'bsl', i18n('Bookseller')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ccp', i18n('Conceptor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'chr', i18n('Choreographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'clb', i18n('Collaborator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cli', i18n('Client')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cll', i18n('Calligrapher')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'clr', i18n('Colorist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'clt', i18n('Collotyper')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cmm', i18n('Commentator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cmp', i18n('Composer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cmt', i18n('Compositor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cng', i18n('Cinematographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cnd', i18n('Conductor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cns', i18n('Censor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'coe', i18n('Contestant -appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'col', i18n('Collector')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'com', i18n('Compiler')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'con', i18n('Conservator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cos', i18n('Contestant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cot', i18n('Contestant -appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cov', i18n('Cover designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cpc', i18n('Copyright claimant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cpe', i18n('Complainant-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cph', i18n('Copyright holder')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cpl', i18n('Complainant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cpt', i18n('Complainant-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cre', i18n('Creator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'crp', i18n('Correspondent')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'crr', i18n('Corrector')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'csl', i18n('Consultant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'csp', i18n('Consultant to a project')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cst', i18n('Costume designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ctb', i18n('Contributor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cte', i18n('Contestee-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ctg', i18n('Cartographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ctr', i18n('Contractor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cts', i18n('Contestee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ctt', i18n('Contestee-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cur', i18n('Curator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'cwt', i18n('Commentator for written text')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dfd', i18n('Defendant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dfe', i18n('Defendant-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dft', i18n('Defendant-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dgg', i18n('Degree grantor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dis', i18n('Dissertant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dln', i18n('Delineator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dnc', i18n('Dancer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dnr', i18n('Donor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dpb', i18n('Distribution place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dpc', i18n('Depicted')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dpt', i18n('Depositor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'drm', i18n('Draftsman')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'drt', i18n('Director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dsr', i18n('Designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dst', i18n('Distributor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dtc', i18n('Data contributor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dte', i18n('Dedicatee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dtm', i18n('Data manager')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dto', i18n('Dedicator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'dub', i18n('Dubious author')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'edt', i18n('Editor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'egr', i18n('Engraver')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'elg', i18n('Electrician')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'elt', i18n('Electrotyper')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'eng', i18n('Engineer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'etr', i18n('Etcher')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'evp', i18n('Event place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'exp', i18n('Expert')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'fac', i18n('Facsimilist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'fld', i18n('Field director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'flm', i18n('Film editor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'fmo', i18n('Former owner')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'fpy', i18n('First party')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'fnd', i18n('Funder')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'frg', i18n('Forger')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'gis', i18n('Geographic information specialist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', '-grt', i18n('Graphic technician')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'hnr', i18n('Honoree')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'hst', i18n('Host')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ill', i18n('Illustrator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ilu', i18n('Illuminator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ins', i18n('Inscriber')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'inv', i18n('Inventor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'itr', i18n('Instrumentalist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ive', i18n('Interviewee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ivr', i18n('Interviewer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lbr', i18n('Laboratory')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lbt', i18n('Librettist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ldr', i18n('Laboratory director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'led', i18n('Lead')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lee', i18n('Libelee-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lel', i18n('Libelee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'len', i18n('Lender')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'let', i18n('Libelee-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lgd', i18n('Lighting designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lie', i18n('Libelant-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lil', i18n('Libelant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lit', i18n('Libelant-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lsa', i18n('Landscape architect')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lse', i18n('Licensee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lso', i18n('Licensor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ltg', i18n('Lithographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'lyr', i18n('Lyricist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mcp', i18n('Music copyist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mfp', i18n('Manufacture place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mfr', i18n('Manufacturer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mdc', i18n('Metadata contact')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mod', i18n('Moderator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mon', i18n('Monitor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mrb', i18n('Marbler')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mrk', i18n('Markup editor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'msd', i18n('Musical director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mte', i18n('Metal-engraver')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'mus', i18n('Musician')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'nrt', i18n('Narrator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'opn', i18n('Opponent')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'org', i18n('Originator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'orm', i18n('Organizer of meeting')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'oth', i18n('Other')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'own', i18n('Owner')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pat', i18n('Patron')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pbd', i18n('Publishing director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pbl', i18n('Publisher')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pdr', i18n('Project director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pfr', i18n('Proofreader')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pht', i18n('Photographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'plt', i18n('Platemaker')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pma', i18n('Permitting agency')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pmn', i18n('Production manager')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pop', i18n('Printer of plates')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ppm', i18n('Papermaker')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ppt', i18n('Puppeteer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prc', i18n('Process contact')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prd', i18n('Production personnel')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prf', i18n('Performer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prg', i18n('Programmer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prm', i18n('Printmaker')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pro', i18n('Producer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prp', i18n('Production place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'prt', i18n('Printer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pta', i18n('Patent applicant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pte', i18n('Plaintiff -appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ptf', i18n('Plaintiff')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pth', i18n('Patent holder')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ptt', i18n('Plaintiff-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'pup', i18n('Publication place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rbr', i18n('Rubricator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rce', i18n('Recording engineer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rcp', i18n('Recipient')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'red', i18n('Redactor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ren', i18n('Renderer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'res', i18n('Researcher')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rev', i18n('Reviewer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rps', i18n('Repository')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rpt', i18n('Reporter')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rpy', i18n('Responsible party')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rse', i18n('Respondent-appellee')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rsg', i18n('Restager')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rsp', i18n('Respondent')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rst', i18n('Respondent-appellant')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rth', i18n('Research team head')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'rtm', i18n('Research team member')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sad', i18n('Scientific advisor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sce', i18n('Scenarist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'scl', i18n('Sculptor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'scr', i18n('Scribe')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sds', i18n('Sound designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sec', i18n('Secretary')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sgn', i18n('Signer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sht', i18n('Supporting host')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'sng', i18n('Singer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'spk', i18n('Speaker')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'spn', i18n('Sponsor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'spy', i18n('Second party')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'srv', i18n('Surveyor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'std', i18n('Set designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'stl', i18n('Storyteller')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'stm', i18n('Stage manager')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'stn', i18n('Standards body')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'str', i18n('Stereotyper')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'tcd', i18n('Technical director')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'tch', i18n('Teacher')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'ths', i18n('Thesis advisor')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'trc', i18n('Transcriber')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'trl', i18n('Translator')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'tyd', i18n('Type designer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'tyg', i18n('Typographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'uvp', i18n('University place')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'vdg', i18n('Videographer')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'voc', i18n('Vocalist')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'wam', i18n('Writer of accompanying material')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'wdc', i18n('Woodcutter')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'wde', i18n('Wood-engraver')); +INSERT +INTO authorised_values (category, authorised_value, lib) +VALUES ('RELTERMS', 'wit', i18n('Witness')); diff --git a/installer/data/mysql/en/optional/parameters.sql b/installer/data/mysql/en/optional/parameters.sql index 84a176b..e89fb82 100644 --- a/installer/data/mysql/en/optional/parameters.sql +++ b/installer/data/mysql/en/optional/parameters.sql @@ -1,6 +1,8 @@ -INSERT INTO `currency` (currency, rate, symbol) VALUES -('USD', 1.0, '$'), -('GBP', 1.9929, '£'), -('CAD', 1.02207, '$'), -('EUR', .874003, '€'); +INSERT +INTO currency (currency, rate, symbol) +VALUES + ('USD', 1.0, '$'), + ('GBP', 1.9929, '£'), + ('CAD', 1.02207, '$'), + ('EUR', .874003, '€'); diff --git a/installer/data/mysql/en/optional/patron_atributes.sql b/installer/data/mysql/en/optional/patron_atributes.sql index 17d7b8a..5bdc342 100644 --- a/installer/data/mysql/en/optional/patron_atributes.sql +++ b/installer/data/mysql/en/optional/patron_atributes.sql @@ -1,2 +1,3 @@ -INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `password_allowed`, `staff_searchable`, `authorised_value_category`) -VALUES ('SHOW_BCODE', 'Show barcode on the summary screen items listings', 0, 0, 1, 0, 0, 'YES_NO'); +INSERT +INTO borrower_attribute_types (code, description, repeatable, unique_id, opac_display, password_allowed, staff_searchable, authorised_value_category) +VALUES ('SHOW_BCODE', i18n('Show barcode on the summary screen items listings'), 0, 0, 1, 0, 0, 'YES_NO'); diff --git a/installer/data/mysql/en/optional/patron_categories.sql b/installer/data/mysql/en/optional/patron_categories.sql index 56439b4..dc17644 100644 --- a/installer/data/mysql/en/optional/patron_categories.sql +++ b/installer/data/mysql/en/optional/patron_categories.sql @@ -1,23 +1,15 @@ -INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES - --- Adult Patrons -('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), -('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), -('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'), - --- Children -('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), -('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), -('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'), - --- Professionals -('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'), -('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'), - --- Institutional -('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), -('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), -('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'), - --- Staff -('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S'); +INSERT +INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type) +VALUES + ('PT', i18n('Patron'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'), + ('ST', i18n('Student'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'), + ('HB', i18n('Home Bound'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'), + ('K', i18n('Kid'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'), + ('J', i18n('Juvenile'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'), + ('YA', i18n('Young Adult'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'), + ('T', i18n('Teacher'), 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'P'), + ('B', i18n('Board'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'P'), + ('IL', i18n('Inter-Library Loan'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'), + ('SC', i18n('School'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'), + ('L', i18n('Library'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'), + ('S', i18n('Staff'), 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'S'); diff --git a/installer/data/mysql/en/optional/sample_creator_data.sql b/installer/data/mysql/en/optional/sample_creator_data.sql index 91d7d00..d81aa64 100644 --- a/installer/data/mysql/en/optional/sample_creator_data.sql +++ b/installer/data/mysql/en/optional/sample_creator_data.sql @@ -1,9 +1,10 @@ -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; - -LOCK TABLES `creator_layouts` WRITE; -/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */; -INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode',' +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', i18n(''), 'Labels'), + (18, 'CODE39', 1, 'BAR', 'DEFAULT', 0, 'TR', 3, 'POINT', 0, 'L', 'title, author, isbn, issn, itemtype, barcode, itemcallnumber', i18n(''), 'Labels'), + (19, 'CODE39', 1, 'BAR', 'DEFAULT', 0, 'TR', 3, 'POINT', 0, 'L', 'title, author, isbn, issn, itemtype, barcode, itemcallnumber', i18n(''), 'Labels'), + (20, 'CODE39', 1, 'BAR', 'Test Layout', 0, 'TR', 10, 'POINT', 0, 'L', 'barcode', i18n(' @@ -14,21 +15,20 @@ INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR' Expires: August 31, 2010 -','Patroncards'); -/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */; -UNLOCK TABLES; - +'), 'Patroncards'); -LOCK TABLES `creator_templates` WRITE; -/*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */; -INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards'); -/*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */; -UNLOCK TABLES; +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', i18n('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', i18n('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', i18n('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', i18n('Default description'), 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'POINT', 'Labels'), + (23, 16, 'HB-PC0001', i18n('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'); -LOCK TABLES `printers_profile` WRITE; -/*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */; -INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'); -/*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */; -UNLOCK TABLES; -/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +INSERT +INTO printers_profile (profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator) +VALUES + (1, i18n('Library Laser'), 1, 'Bypass', -2, 9, 3, 0, 'POINT', 'Labels'), + (11, i18n('Library Laser'), 1, 'Tray 1', 0, 0, 0, 0, 'POINT', 'Labels'), + (16, i18n('Test Printer 01'), 23, 'Test Bin', 0, 0, 0, 0, 'POINT', 'Patroncards'); diff --git a/installer/data/mysql/en/optional/sample_holidays.sql b/installer/data/mysql/en/optional/sample_holidays.sql index 33b6ff6..08c5208 100644 --- a/installer/data/mysql/en/optional/sample_holidays.sql +++ b/installer/data/mysql/en/optional/sample_holidays.sql @@ -1,4 +1,6 @@ -INSERT INTO `repeatable_holidays` VALUES -(2,'MPL',0,NULL,NULL,'','Sundays'), -(3,'MPL',NULL,1,1,'','New Year\'s Day'), -(4,'MPL',NULL,25,12,'','Christmas'); +INSERT +INTO repeatable_holidays (id, branchcode, weekday, day, month, title, description) +VALUES + (2, 'MPL', 0, NULL, NULL, '', i18n('Sundays')), + (3, 'MPL', NULL, 1, 1, '', i18n('New Year\'s Day')), + (4, 'MPL', NULL, 25, 12, '', i18n('Christmas')); diff --git a/installer/data/mysql/en/optional/sample_itemtypes.sql b/installer/data/mysql/en/optional/sample_itemtypes.sql index 76510b4..f677ccb 100644 --- a/installer/data/mysql/en/optional/sample_itemtypes.sql +++ b/installer/data/mysql/en/optional/sample_itemtypes.sql @@ -1,8 +1,11 @@ -INSERT INTO `itemtypes` VALUES ('BK', 'Books',5,0,'bridge/book.gif',''); -INSERT INTO `itemtypes` VALUES ('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''); -INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''); -INSERT INTO `itemtypes` VALUES ('MP', 'Maps',5,0,'bridge/map.gif',''); -INSERT INTO `itemtypes` VALUES ('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''); -INSERT INTO `itemtypes` VALUES ('MU', 'Music',5,0,'bridge/sound.gif',''); -INSERT INTO `itemtypes` VALUES ('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''); -INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,1,'',''); +INSERT +INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) +VALUES + ('BK', i18n('Books'), 5, 0, 'bridge/book.gif', ''), + ('MX', i18n('Mixed Materials'), 5, 0, 'bridge/kit.gif', ''), + ('CF', i18n('Computer Files'), 5, 0, 'bridge/computer_file.gif', ''), + ('MP', i18n('Maps'), 5, 0, 'bridge/map.gif', ''), + ('VM', i18n('Visual Materials'), 5, 1, 'bridge/dvd.gif', ''), + ('MU', i18n('Music'), 5, 0, 'bridge/sound.gif', ''), + ('CR', i18n('Continuing Resources'), 5, 0, 'bridge/periodical.gif', ''), + ('REF', i18n('Reference'), 0, 1, '', ''); diff --git a/installer/data/mysql/en/optional/sample_libraries.sql b/installer/data/mysql/en/optional/sample_libraries.sql index a2fa52e..6c0a799 100644 --- a/installer/data/mysql/en/optional/sample_libraries.sql +++ b/installer/data/mysql/en/optional/sample_libraries.sql @@ -1,19 +1,15 @@ --- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES - -INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES - -('MPL','Midway','372 Forest Street'), -('SPL','Springfield','Highland Boulevard'), -('RPL','Riverside','Johnson Terrace'), -('CPL','Centerville','Jefferson Summit'), -('FPL','Fairview','Hickory Squere'), -('FFL','Fairfield','River Station'), -('IPT','Institut Protestant de Théologie',''), -('PVL','Pleasant Valley','Meadow Grove'), -('TPL','Troy','Valley Way'), -('FRL','Franklin','Smith Heights'), -('LPL','Liberty','East Hills'), -('UPL','Union','Chestnut Hollow') -; - --- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES +INSERT +INTO branches (branchcode, branchname, branchaddress1) +VALUES + ('MPL', 'Midway', '372 Forest Street'), + ('SPL', 'Springfield', 'Highland Boulevard'), + ('RPL', 'Riverside', 'Johnson Terrace'), + ('CPL', 'Centerville', 'Jefferson Summit'), + ('FPL', 'Fairview', 'Hickory Squere'), + ('FFL', 'Fairfield', 'River Station'), + ('IPT', 'Institut Protestant de Théologie', ''), + ('PVL', 'Pleasant Valley', 'Meadow Grove'), + ('TPL', 'Troy', 'Valley Way'), + ('FRL', 'Franklin', 'Smith Heights'), + ('LPL', 'Liberty', 'East Hills'), + ('UPL', 'Union', 'Chestnut Hollow'); diff --git a/installer/data/mysql/en/optional/sample_news.sql b/installer/data/mysql/en/optional/sample_news.sql index 4327f4b..60f6166 100644 --- a/installer/data/mysql/en/optional/sample_news.sql +++ b/installer/data/mysql/en/optional/sample_news.sql @@ -1,2 +1,5 @@ -INSERT INTO `opac_news` VALUES (1,'Welcome to Koha','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.','koha','2007-10-29 05:25:58','2099-01-10',1), -(2,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n\r\n','koha','2007-10-29 05:34:45','2099-01-10',2); \ No newline at end of file +INSERT +INTO opac_news (idnew, title, new, lang, timestamp, expirationdate, number) +VALUES + (1, i18n('Welcome to Koha'), i18n('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.'), i18n('koha'), '2007-10-29 05:25:58', '2099-01-10', 1), + (2, i18n('What\'s Next?'), i18n('Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n\r\n'), i18n('koha'), '2007-10-29 05:34:45', '2099-01-10', 2); diff --git a/installer/data/mysql/en/optional/sample_patrons.sql b/installer/data/mysql/en/optional/sample_patrons.sql index 809dea5..4ffc90d 100644 --- a/installer/data/mysql/en/optional/sample_patrons.sql +++ b/installer/data/mysql/en/optional/sample_patrons.sql @@ -1,52 +1,53 @@ -INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `guarantorid`, `borrowernotes`, `relationship`, `ethnicity`, `ethnotes`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES - -(1,'1','Admin','Koha',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','S',NULL,'2099-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -(2,'23529000152273','Welch','Marcus',NULL,NULL,'',NULL,NULL,'5601 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRL','ST','1985-10-24','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'), -(3,'23529000445172','Daniels','Tanya',NULL,NULL,'',NULL,NULL,'2035 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1966-10-14','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'), -(4,'23529000105040','Dillon','Eva',NULL,NULL,'',NULL,NULL,'8916 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-03','MPL','PT','1987-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'), -(5,'23529001000463','Acosta','Edna',NULL,NULL,'',NULL,NULL,'7896 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1980-04-24','MPL','PT','1990-11-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'), -(6,'23529000591678','Glass','Virgil',NULL,NULL,'',NULL,NULL,'6250 Library Rd.',NULL,'Santa Cruz, CA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1974-06-19','SPL','T','1985-02-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,102,NULL,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'), -(7,'23529000080862','Middleton','Bobbie',NULL,NULL,'',NULL,NULL,'4619 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-07-24','SPL','J','1991-03-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,104,NULL,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'), -(8,'23529000358268','Rivera','Olga',NULL,NULL,'',NULL,NULL,'6058 Library Rd.',NULL,'Mayfield Heights, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1979-12-22','PVL','T','1986-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,112,NULL,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'), -(9,'23529000429697','Waters','Annie',NULL,NULL,'',NULL,NULL,'5444 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1932-10-27','FRL','ST','1984-05-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'), -(10,'23529000068917','Herring','Frances',NULL,NULL,'',NULL,NULL,'4024 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-02-13','SPL','PT','1993-03-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'), -(11,'23529000065863','Hawkins','Sam',NULL,NULL,'',NULL,NULL,'665 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1924-03-26','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'), -(12,'23529000878885','Mcknight','Marie',NULL,NULL,'',NULL,NULL,'4241 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','YA','1990-08-06','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'), -(13,'23529000132291','Edwards','Roy',NULL,NULL,'',NULL,NULL,'9929 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1928-09-09','MPL','PT','1992-03-10','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'), -(14,'23529000035726','Mccullough','Phillip',NULL,NULL,'',NULL,NULL,'410 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1943-11-23','SPL','PT','1986-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'), -(15,'23529001203323','Peterson','Gordon',NULL,NULL,'',NULL,NULL,'6285 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1963-10-01','SPL','J','1984-09-11','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,131,NULL,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'), -(16,'23529000991266','Walker','Andrea',NULL,NULL,'',NULL,NULL,'4992 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-08-05','FRL','IL','1993-06-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'), -(17,'23529000711078','King','Casey',NULL,NULL,'',NULL,NULL,'3438 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-09-23','SPL','S','1992-05-18','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'), -(18,'23529000809559','Delgado','Floyd',NULL,NULL,'',NULL,NULL,'6661 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1968-02-01','MPL','K','1988-08-05','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,160,NULL,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'), -(19,'23529000035676','Acevedo','Henry',NULL,NULL,'',NULL,NULL,'4345 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1958-05-30','MPL','S','1990-09-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'), -(20,'23529000033739','Frazier','Sonia',NULL,NULL,'',NULL,NULL,'8165 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1945-09-16','MPL','PT','1984-06-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'), -(21,'23529000139858','Ballard','Ronnie',NULL,NULL,'',NULL,NULL,'5730 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-02-23','MPL','T','1989-06-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,177,NULL,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'), -(22,'23529000224510','Gaines','Joyce',NULL,NULL,'',NULL,NULL,'6012 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1957-08-01','SPL','YA','1992-09-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'), -(23,'23529000120056','Bryan','Johnny',NULL,NULL,'',NULL,NULL,'8180 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1961-10-24','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'), -(24,'23529000218553','Duffy','Joann',NULL,NULL,'',NULL,NULL,'1555 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1942-02-17','MPL','ST','1984-08-02','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'), -(25,'23529000662701','Mejia','Armando',NULL,NULL,'',NULL,NULL,'8209 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1939-07-22','SPL','PT','1990-09-26','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'), -(26,'23529000092040','Hendrix','Keith',NULL,NULL,'',NULL,NULL,'6546 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1944-04-05','SPL','PT','1987-12-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'), -(27,'23529000058017','Turner','Sherri',NULL,NULL,'',NULL,NULL,'1731 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1964-11-21','FRL','PT','1987-09-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'), -(28,'23529000299603','Cherry','Lillie',NULL,NULL,'',NULL,NULL,'263 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1931-01-19','MPL','PT','1993-03-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'), -(29,'23529000121682','Schneider','Nicole',NULL,NULL,'',NULL,NULL,'1008 Library Rd.',NULL,'Centerville, CA','44306',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1954-01-12','FRL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'), -(30,'23529000240482','White','Jamie',NULL,NULL,'',NULL,NULL,'937 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1950-04-22','FRL','T','1990-02-03','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,254,NULL,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'), -(31,'23529000714163','Burgess','Dawn',NULL,NULL,'',NULL,NULL,'7907 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','PT','1985-05-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'), -(32,'23529000318858','Bennett','Pamela',NULL,NULL,'',NULL,NULL,'9898 Library Rd.',NULL,'Centerville, CA','44310',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1946-09-16','MPL','ST','1984-05-08','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'), -(33,'23529000526047','Hatfield','Lester',NULL,NULL,'',NULL,NULL,'393 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-01-22','SPL','ST','1988-07-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'), -(34,'23529000686353','Harper','Ruben',NULL,NULL,'',NULL,NULL,'6963 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1917-09-24','SPL','S','1991-02-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'), -(35,'23529000719519','Kinney','Mae',NULL,NULL,'',NULL,NULL,'2114 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','J','1991-12-29','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,287,NULL,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'), -(36,'23529000179433','Williamson','Catherine',NULL,NULL,'',NULL,NULL,'5879 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1930-12-18','FRL','K','1985-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,288,NULL,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'), -(37,'23529000197047','Charles','Lisa',NULL,NULL,'',NULL,NULL,'6813 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1982-10-14','MPL','K','1988-11-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,289,NULL,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'), -(38,'23529000695412','Singleton','Bob',NULL,NULL,'',NULL,NULL,'4554 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-04-15','FRL','PT','1991-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'), -(39,'23529000603242','Mcconnell','Terrence',NULL,NULL,'',NULL,NULL,'7200 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1949-06-10','SPL','PT','1984-05-31','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'), -(40,'23529000589458','Knight','Mabel',NULL,NULL,'',NULL,NULL,'8997 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-12-22','SPL','T','1985-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,320,NULL,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'), -(41,'23529000054503','Odom','Gloria',NULL,NULL,'',NULL,NULL,'9156 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-05','SPL','S','1992-07-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'), -(42,'23529000126806','Hopkins','Brent',NULL,NULL,'',NULL,NULL,'6692 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-11-13','SPL','T','1984-06-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,337,NULL,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'), -(43,'23529000104159','Benson','Clinton',NULL,NULL,'',NULL,NULL,'4695 Library Rd.',NULL,'Atwater, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','YA','1985-10-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'), -(44,'23529000395609','Stuart','Shannon',NULL,NULL,'',NULL,NULL,'5011 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-02-13','FRL','PT','1986-01-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'), -(45,'23529000050113','Alford','Jordan',NULL,NULL,'',NULL,NULL,'5129 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-05-27','MPL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'), -(46,'23529000053836','Mcfarland','Marilyn',NULL,NULL,'',NULL,NULL,'4600 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'), -(47,'23529000774373','Morris','Lauren',NULL,NULL,'',NULL,NULL,'5436 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1986-03-20','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'), -(48,'23529000117565','Palmer','Bill',NULL,NULL,'',NULL,NULL,'2761 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1984-01-10','SPL','PT','1991-10-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'), -(49,'23529000651225','Burton','Mary',NULL,NULL,'',NULL,NULL,'8131 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-12-25','MPL','PT','1985-05-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'), -(50,'23529001223636','Peters','Tommy',NULL,NULL,'',NULL,NULL,'5171 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-06-14','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825'); +INSERT +INTO borrowers (borrowernumber, cardnumber, surname, firstname, title, othernames, initials, streetnumber, streettype, address, address2, city, zipcode, email, phone, mobile, fax, emailpro, phonepro, B_streetnumber, B_streettype, B_address, B_city, B_zipcode, B_email, B_phone, dateofbirth, branchcode, categorycode, dateenrolled, dateexpiry, gonenoaddress, lost, debarred, contactname, contactfirstname, contacttitle, guarantorid, borrowernotes, relationship, ethnicity, ethnotes, sex, userid, opacnote, contactnote, password, flags, sort1, sort2) +VALUES + (1, '1', 'Admin', 'Koha', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'S', NULL, '2099-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), + (2, '23529000152273', 'Welch', 'Marcus', NULL, NULL, '', NULL, NULL, '5601 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FRL', 'ST', '1985-10-24', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000152273', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.43609457503641', '0.38613959717205'), + (3, '23529000445172', 'Daniels', 'Tanya', NULL, NULL, '', NULL, NULL, '2035 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1966-10-14', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000445172', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62241429148467', '0.95365269664084'), + (4, '23529000105040', 'Dillon', 'Eva', NULL, NULL, '', NULL, NULL, '8916 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-03', 'MPL', 'PT', '1987-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000105040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.90102063948384', '0.64414513823031'), + (5, '23529001000463', 'Acosta', 'Edna', NULL, NULL, '', NULL, NULL, '7896 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1980-04-24', 'MPL', 'PT', '1990-11-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001000463', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.72642678648832', '0.6644830635418'), + (6, '23529000591678', 'Glass', 'Virgil', NULL, NULL, '', NULL, NULL, '6250 Library Rd.', NULL, 'Santa Cruz, CA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1974-06-19', 'SPL', 'T', '1985-02-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 102, NULL, NULL, NULL, NULL, 'M', '23529000591678', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.1431349889777', '0.72222578499673'), + (7, '23529000080862', 'Middleton', 'Bobbie', NULL, NULL, '', NULL, NULL, '4619 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-07-24', 'SPL', 'J', '1991-03-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 104, NULL, NULL, NULL, NULL, 'M', '23529000080862', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.18172398878422', '0.74194261966454'), + (8, '23529000358268', 'Rivera', 'Olga', NULL, NULL, '', NULL, NULL, '6058 Library Rd.', NULL, 'Mayfield Heights, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1979-12-22', 'PVL', 'T', '1986-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 112, NULL, NULL, NULL, NULL, 'F', '23529000358268', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.16454116270369', '0.59687798525847'), + (9, '23529000429697', 'Waters', 'Annie', NULL, NULL, '', NULL, NULL, '5444 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1932-10-27', 'FRL', 'ST', '1984-05-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000429697', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.49076646891494', '0.66319841953292'), + (10, '23529000068917', 'Herring', 'Frances', NULL, NULL, '', NULL, NULL, '4024 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-02-13', 'SPL', 'PT', '1993-03-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000068917', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84369272165344', '0.22886838040209'), + (11, '23529000065863', 'Hawkins', 'Sam', NULL, NULL, '', NULL, NULL, '665 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1924-03-26', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000065863', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.61326376778378', '0.37971372844625'), + (12, '23529000878885', 'Mcknight', 'Marie', NULL, NULL, '', NULL, NULL, '4241 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'YA', '1990-08-06', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000878885', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.058777369613552', '0.15474569346266'), + (13, '23529000132291', 'Edwards', 'Roy', NULL, NULL, '', NULL, NULL, '9929 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1928-09-09', 'MPL', 'PT', '1992-03-10', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000132291', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.59739638920631', '0.5227448963772'), + (14, '23529000035726', 'Mccullough', 'Phillip', NULL, NULL, '', NULL, NULL, '410 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1943-11-23', 'SPL', 'PT', '1986-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035726', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.82153534500071', '0.53944206660561'), + (15, '23529001203323', 'Peterson', 'Gordon', NULL, NULL, '', NULL, NULL, '6285 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1963-10-01', 'SPL', 'J', '1984-09-11', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 131, NULL, NULL, NULL, NULL, 'F', '23529001203323', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.23260432875958', '0.54469547471469'), + (16, '23529000991266', 'Walker', 'Andrea', NULL, NULL, '', NULL, NULL, '4992 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-08-05', 'FRL', 'IL', '1993-06-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000991266', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.025664418028355', '0.49423569673135'), + (17, '23529000711078', 'King', 'Casey', NULL, NULL, '', NULL, NULL, '3438 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-09-23', 'SPL', 'S', '1992-05-18', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000711078', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.39418526030535', '0.48821924206635'), + (18, '23529000809559', 'Delgado', 'Floyd', NULL, NULL, '', NULL, NULL, '6661 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1968-02-01', 'MPL', 'K', '1988-08-05', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 160, NULL, NULL, NULL, NULL, 'M', '23529000809559', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.25854046014933', '0.82804460528125'), + (19, '23529000035676', 'Acevedo', 'Henry', NULL, NULL, '', NULL, NULL, '4345 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1958-05-30', 'MPL', 'S', '1990-09-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035676', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.36460167669188', '0.33887459834933'), + (20, '23529000033739', 'Frazier', 'Sonia', NULL, NULL, '', NULL, NULL, '8165 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1945-09-16', 'MPL', 'PT', '1984-06-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000033739', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60056799240463', '0.98621619770882'), + (21, '23529000139858', 'Ballard', 'Ronnie', NULL, NULL, '', NULL, NULL, '5730 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-02-23', 'MPL', 'T', '1989-06-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 177, NULL, NULL, NULL, NULL, 'F', '23529000139858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12937704206386', '0.68823664792649'), + (22, '23529000224510', 'Gaines', 'Joyce', NULL, NULL, '', NULL, NULL, '6012 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1957-08-01', 'SPL', 'YA', '1992-09-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000224510', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.053052144174513', '0.20055080782673'), + (23, '23529000120056', 'Bryan', 'Johnny', NULL, NULL, '', NULL, NULL, '8180 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1961-10-24', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000120056', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84359763734378', '0.61633579397233'), + (24, '23529000218553', 'Duffy', 'Joann', NULL, NULL, '', NULL, NULL, '1555 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1942-02-17', 'MPL', 'ST', '1984-08-02', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000218553', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.55088608856395', '0.90542309163643'), + (25, '23529000662701', 'Mejia', 'Armando', NULL, NULL, '', NULL, NULL, '8209 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1939-07-22', 'SPL', 'PT', '1990-09-26', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000662701', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.87445722322395', '0.65601687194409'), + (26, '23529000092040', 'Hendrix', 'Keith', NULL, NULL, '', NULL, NULL, '6546 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1944-04-05', 'SPL', 'PT', '1987-12-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000092040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.65671272078223', '0.31551301881253'), + (27, '23529000058017', 'Turner', 'Sherri', NULL, NULL, '', NULL, NULL, '1731 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1964-11-21', 'FRL', 'PT', '1987-09-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000058017', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60742696244961', '0.090595786544118'), + (28, '23529000299603', 'Cherry', 'Lillie', NULL, NULL, '', NULL, NULL, '263 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1931-01-19', 'MPL', 'PT', '1993-03-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000299603', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.6306980761054', '0.88170305162827'), + (29, '23529000121682', 'Schneider', 'Nicole', NULL, NULL, '', NULL, NULL, '1008 Library Rd.', NULL, 'Centerville, CA', '44306', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1954-01-12', 'FRL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000121682', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.5164210605588', '0.93699617864284'), + (30, '23529000240482', 'White', 'Jamie', NULL, NULL, '', NULL, NULL, '937 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1950-04-22', 'FRL', 'T', '1990-02-03', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 254, NULL, NULL, NULL, NULL, 'F', '23529000240482', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.13571774227146', '0.86760020616241'), + (31, '23529000714163', 'Burgess', 'Dawn', NULL, NULL, '', NULL, NULL, '7907 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'PT', '1985-05-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000714163', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.93084783473131', '0.051438585902973'), + (32, '23529000318858', 'Bennett', 'Pamela', NULL, NULL, '', NULL, NULL, '9898 Library Rd.', NULL, 'Centerville, CA', '44310', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1946-09-16', 'MPL', 'ST', '1984-05-08', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000318858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.46464945605458', '0.16893155329761'), + (33, '23529000526047', 'Hatfield', 'Lester', NULL, NULL, '', NULL, NULL, '393 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-01-22', 'SPL', 'ST', '1988-07-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000526047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.45070942905798', '0.74675251613069'), + (34, '23529000686353', 'Harper', 'Ruben', NULL, NULL, '', NULL, NULL, '6963 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1917-09-24', 'SPL', 'S', '1991-02-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000686353', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.38163432421315', '0.66791410340733'), + (35, '23529000719519', 'Kinney', 'Mae', NULL, NULL, '', NULL, NULL, '2114 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'J', '1991-12-29', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 287, NULL, NULL, NULL, NULL, 'F', '23529000719519', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.19466757513086', '0.96959559616595'), + (36, '23529000179433', 'Williamson', 'Catherine', NULL, NULL, '', NULL, NULL, '5879 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1930-12-18', 'FRL', 'K', '1985-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 288, NULL, NULL, NULL, NULL, 'M', '23529000179433', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26397528617082', '0.41108967308988'), + (37, '23529000197047', 'Charles', 'Lisa', NULL, NULL, '', NULL, NULL, '6813 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1982-10-14', 'MPL', 'K', '1988-11-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 289, NULL, NULL, NULL, NULL, 'M', '23529000197047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26352253767058', '0.084343699816934'), + (38, '23529000695412', 'Singleton', 'Bob', NULL, NULL, '', NULL, NULL, '4554 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-04-15', 'FRL', 'PT', '1991-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000695412', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.63115091680656', '0.90272351531566'), + (39, '23529000603242', 'Mcconnell', 'Terrence', NULL, NULL, '', NULL, NULL, '7200 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1949-06-10', 'SPL', 'PT', '1984-05-31', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000603242', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62016485689223', '0.39265376924784'), + (40, '23529000589458', 'Knight', 'Mabel', NULL, NULL, '', NULL, NULL, '8997 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-12-22', 'SPL', 'T', '1985-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 320, NULL, NULL, NULL, NULL, 'M', '23529000589458', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.10277430629616', '0.33591025447092'), + (41, '23529000054503', 'Odom', 'Gloria', NULL, NULL, '', NULL, NULL, '9156 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-05', 'SPL', 'S', '1992-07-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000054503', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.37122838419976', '0.84841118831971'), + (42, '23529000126806', 'Hopkins', 'Brent', NULL, NULL, '', NULL, NULL, '6692 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-11-13', 'SPL', 'T', '1984-06-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 337, NULL, NULL, NULL, NULL, 'F', '23529000126806', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12837081973289', '0.096620564438981'), + (43, '23529000104159', 'Benson', 'Clinton', NULL, NULL, '', NULL, NULL, '4695 Library Rd.', NULL, 'Atwater, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'YA', '1985-10-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000104159', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.097990393729872', '0.20009030606606'), + (44, '23529000395609', 'Stuart', 'Shannon', NULL, NULL, '', NULL, NULL, '5011 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-02-13', 'FRL', 'PT', '1986-01-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000395609', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.70648037987433', '0.93213101190713'), + (45, '23529000050113', 'Alford', 'Jordan', NULL, NULL, '', NULL, NULL, '5129 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-05-27', 'MPL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000050113', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.54121395064631', '0.90967674824379'), + (46, '23529000053836', 'Mcfarland', 'Marilyn', NULL, NULL, '', NULL, NULL, '4600 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000053836', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.92474192001367', '0.89467938607063'), + (47, '23529000774373', 'Morris', 'Lauren', NULL, NULL, '', NULL, NULL, '5436 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1986-03-20', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000774373', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.69917120104578', '0.81181787775067'), + (48, '23529000117565', 'Palmer', 'Bill', NULL, NULL, '', NULL, NULL, '2761 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1984-01-10', 'SPL', 'PT', '1991-10-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000117565', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.96157581634966', '0.37242547922994'), + (49, '23529000651225', 'Burton', 'Mary', NULL, NULL, '', NULL, NULL, '8131 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-12-25', 'MPL', 'PT', '1985-05-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000651225', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.97739997783434', '0.76972348221552'), + (50, '23529001223636', 'Peters', 'Tommy', NULL, NULL, '', NULL, NULL, '5171 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-06-14', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001223636', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.91641750830823', '0.27291712562825'); diff --git a/installer/data/mysql/en/optional/sample_quotes.sql b/installer/data/mysql/en/optional/sample_quotes.sql index 6a20bd5..df745ba 100644 --- a/installer/data/mysql/en/optional/sample_quotes.sql +++ b/installer/data/mysql/en/optional/sample_quotes.sql @@ -1,34 +1,34 @@ -/*!40000 ALTER TABLE `quotes` DISABLE KEYS */; -INSERT INTO `quotes` VALUES -(1,'George Washington','To be prepared for war is one of the most effectual means of preserving peace.','0000-00-00 00:00:00'), -(2,'Thomas Jefferson','When angry, count ten, before you speak; if very angry, an hundred.','0000-00-00 00:00:00'), -(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.','0000-00-00 00:00:00'), -(4,'Abraham Lincoln','I have always found that mercy bears richer fruits than strict justice.','0000-00-00 00:00:00'), -(5,'Andrew Johnson','I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.','0000-00-00 00:00:00'), -(6,'Rutherford B. Hayes','He serves his party best who serves his country best.','0000-00-00 00:00:00'), -(7,'Theodore Roosevelt','No President has ever enjoyed himself as much as I?','0000-00-00 00:00:00'), -(8,'Theodore Roosevelt','Speak softly and carry a big stick.','0000-00-00 00:00:00'), -(9,'William H. Taft','I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.','0000-00-00 00:00:00'), -(11,'Woodrow Wilson','You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.','0000-00-00 00:00:00'), -(12,'Calvin Coolidge','If you don\'t say anything, you won\'t be called on to repeat it.','0000-00-00 00:00:00'), -(13,'Calvin Coolidge','Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.','0000-00-00 00:00:00'), -(14,'Herbert Hoover','The slogan of progress is changing from the full dinner pail to the full garage.','0000-00-00 00:00:00'), -(15,'Franklin D. Roosevelt','Let me assert my firm belief that the only thing we have to fear is fear itself.','0000-00-00 00:00:00'), -(16,'Harry S. Truman','If you can\'t stand the heat, get out of the kitchen.','0000-00-00 00:00:00'), -(17,'Harry S. Truman','The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.','0000-00-00 00:00:00'), -(18,'Harry S. Truman','The buck stops here.','0000-00-00 00:00:00'), -(19,'Dwight D. Eisenhower','History does not long entrust the care of freedom to the weak or the timid.','0000-00-00 00:00:00'), -(20,'John F. Kennedy','My fellow Americans, ask not what your country can do for you; ask what you can do for your country.','0000-00-00 00:00:00'), -(22,'John F. Kennedy','I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.','0000-00-00 00:00:00'), -(23,'Lyndon B. Johnson','The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.','0000-00-00 00:00:00'), -(24,'Richard Nixon','People have got to know whether or not their president is a crook. Well, I\'m not a crook.','0000-00-00 00:00:00'), -(25,'Richard Nixon','When the President does it, that means that it is not illegal.','0000-00-00 00:00:00'), -(26,'Gerald R. Ford','Our Long national nightmare is over.','0000-00-00 00:00:00'), -(27,'Gerald R. Ford','Our constitution works. Our great republic is a government of laws, not of men.','0000-00-00 00:00:00'), -(28,'Jimmy Carter','A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.','0000-00-00 00:00:00'), -(30,'Ronald Reagan','It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.','0000-00-00 00:00:00'), -(31,'Ronald Reagan','Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.','0000-00-00 00:00:00'), -(32,'George H. W. Bush ','We have ...drawn a line in the sand.','0000-00-00 00:00:00'), -(33,'George W. Bush','If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.','0000-00-00 00:00:00'), -(34,'George W. Bush','Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.','0000-00-00 00:00:00'); -/*!40000 ALTER TABLE `quotes` ENABLE KEYS */; +INSERT +INTO quotes (id, source, text, timestamp) +VALUES + (1, 'George Washington', i18n('To be prepared for war is one of the most effectual means of preserving peace.'), '0000-00-00 00:00:00'), + (2, 'Thomas Jefferson', i18n('When angry, count ten, before you speak; if very angry, an hundred.'), '0000-00-00 00:00:00'), + (3, 'Abraham Lincoln', i18n('Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.'), '0000-00-00 00:00:00'), + (4, 'Abraham Lincoln', i18n('I have always found that mercy bears richer fruits than strict justice.'), '0000-00-00 00:00:00'), + (5, 'Andrew Johnson', i18n('I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.'), '0000-00-00 00:00:00'), + (6, 'Rutherford B. Hayes', i18n('He serves his party best who serves his country best.'), '0000-00-00 00:00:00'), + (7, 'Theodore Roosevelt', i18n('No President has ever enjoyed himself as much as I?'), '0000-00-00 00:00:00'), + (8, 'Theodore Roosevelt', i18n('Speak softly and carry a big stick.'), '0000-00-00 00:00:00'), + (9, 'William H. Taft', i18n('I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.'), '0000-00-00 00:00:00'), + (11, 'Woodrow Wilson', i18n('You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.'), '0000-00-00 00:00:00'), + (12, 'Calvin Coolidge', i18n('If you don\'t say anything, you won\'t be called on to repeat it.'), '0000-00-00 00:00:00'), + (13, 'Calvin Coolidge', i18n('Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.'), '0000-00-00 00:00:00'), + (14, 'Herbert Hoover', i18n('The slogan of progress is changing from the full dinner pail to the full garage.'), '0000-00-00 00:00:00'), + (15, 'Franklin D. Roosevelt', i18n('Let me assert my firm belief that the only thing we have to fear is fear itself.'), '0000-00-00 00:00:00'), + (16, 'Harry S. Truman', i18n('If you can\'t stand the heat, get out of the kitchen.'), '0000-00-00 00:00:00'), + (17, 'Harry S. Truman', i18n('The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.'), '0000-00-00 00:00:00'), + (18, 'Harry S. Truman', i18n('The buck stops here.'), '0000-00-00 00:00:00'), + (19, 'Dwight D. Eisenhower', i18n('History does not long entrust the care of freedom to the weak or the timid.'), '0000-00-00 00:00:00'), + (20, 'John F. Kennedy', i18n('My fellow Americans, ask not what your country can do for you; ask what you can do for your country.'), '0000-00-00 00:00:00'), + (22, 'John F. Kennedy', i18n('I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.'), '0000-00-00 00:00:00'), + (23, 'Lyndon B. Johnson', i18n('The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.'), '0000-00-00 00:00:00'), + (24, 'Richard Nixon', i18n('People have got to know whether or not their president is a crook. Well, I\'m not a crook.'), '0000-00-00 00:00:00'), + (25, 'Richard Nixon', i18n('When the President does it, that means that it is not illegal.'), '0000-00-00 00:00:00'), + (26, 'Gerald R. Ford', i18n('Our Long national nightmare is over.'), '0000-00-00 00:00:00'), + (27, 'Gerald R. Ford', i18n('Our constitution works. Our great republic is a government of laws, not of men.'), '0000-00-00 00:00:00'), + (28, 'Jimmy Carter', i18n('A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.'), '0000-00-00 00:00:00'), + (30, 'Ronald Reagan', i18n('It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.'), '0000-00-00 00:00:00'), + (31, 'Ronald Reagan', i18n('Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.'), '0000-00-00 00:00:00'), + (32, 'George H. W. Bush ', i18n('We have ...drawn a line in the sand.'), '0000-00-00 00:00:00'), + (33, 'George W. Bush', i18n('If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.'), '0000-00-00 00:00:00'), + (34, 'George W. Bush', i18n('Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.'), '0000-00-00 00:00:00'); diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql index 472d8eb..26a4f5b 100644 --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -1,5 +1,6 @@ -INSERT INTO `z3950servers` -(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES -('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); +INSERT +INTO z3950servers (host, port, db, userid, password, name, id, checked, rank, syntax, encoding) +VALUES + ('lx2.loc.gov', 210, 'LCDB', '', '', i18n('LIBRARY OF CONGRESS'), 1, 1, 1, 'USMARC', 'utf8'), + ('clio-db.cc.columbia.edu', 7090, 'voyager', '', '', i18n('COLUMBIA UNIVERSITY'), 6, 0, 0, 'USMARC', 'MARC-8'), + ('siris-libraries.si.edu', 210, 'Default', '', '', i18n('SMITHSONIAN INSTITUTION LIBRARIES'), 10, 0, 0, 'USMARC', 'MARC-8'); -- 1.7.7.6