From ff5cd2a0e8119536fd2deed6891741597d54911a Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Mon, 1 Oct 2007 17:29:47 -0500 Subject: [PATCH] more marc21 sample data Signed-off-by: Chris Cormack --- installer/data/en/optional/parameters.sql | 6 ------ installer/data/en/optional/sample_labels.sql | 11 +++++++++++ installer/data/en/optional/sample_labels.txt | 8 ++++++++ installer/data/en/optional/sample_z3950_servers.sql | 7 +++++++ installer/data/en/optional/sample_z3950_servers.txt | 5 +++++ 5 files changed, 31 insertions(+), 6 deletions(-) create mode 100644 installer/data/en/optional/sample_labels.sql create mode 100644 installer/data/en/optional/sample_labels.txt create mode 100644 installer/data/en/optional/sample_z3950_servers.sql create mode 100644 installer/data/en/optional/sample_z3950_servers.txt diff --git a/installer/data/en/optional/parameters.sql b/installer/data/en/optional/parameters.sql index e47f0338ff..8a4beb965f 100644 --- a/installer/data/en/optional/parameters.sql +++ b/installer/data/en/optional/parameters.sql @@ -1,8 +1,2 @@ INSERT INTO `currency` (currency, rate) VALUES ('USD', 1.0); -INSERT INTO `z3950servers` (`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`) VALUES -('z3950.loc.gov',7090,'Voyager','','','LIBRARY OF CONGRESS',1,1,2,'USMARC'), -('amicus.collectionscanada.ca',210,'NL','','','AMICUS',2,1,3,'USMARC'), -('66.213.78.76',9999,'NPLKoha','','','NELSONVILLE PUBLIC LIBRARY',3,0,4,'USMARC'); - - diff --git a/installer/data/en/optional/sample_labels.sql b/installer/data/en/optional/sample_labels.sql new file mode 100644 index 0000000000..f11cea6cb8 --- /dev/null +++ b/installer/data/en/optional/sample_labels.sql @@ -0,0 +1,11 @@ +-- Label Templates +LOCK TABLES `labels_templates` WRITE; +INSERT INTO `labels_templates` VALUES +(1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.625,1,0.5,0.1875,3,10,0.125,0,1,'INCH',7), +(2,'Gaylord 8511 Spine Label','Prints only the left-hand column of a Gaylord 8511.',8.5,11,1,1.25,0.6,0.5,1,8,0,0,NULL,'INCH',10), +(3,'Avery 5460 vertical','',3.625,5.625,1.5,0.75,0.38,0.35,2,7,0.25,0,NULL,'INCH',8), +(4,'Avery 5460 spine labels','',5.625,3.625,0.75,1.5,0.35,0.31,7,2,0,0.25,NULL,'INCH',8), +(5,'Avery 8163','2rows x 5 rows',8.5,11,4,2,0.5,0.17,2,5,0.2,0.01,NULL,'INCH',11), +(6,'cards','Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\" [3x10] : equivalent: Gaylord JD-ML3000',8.5,11,2.75,1.05,0.25,0,3,10,0.2,0.01,NULL,'INCH',8); +UNLOCK TABLES; + diff --git a/installer/data/en/optional/sample_labels.txt b/installer/data/en/optional/sample_labels.txt new file mode 100644 index 0000000000..685c938b71 --- /dev/null +++ b/installer/data/en/optional/sample_labels.txt @@ -0,0 +1,8 @@ +Some sample labels: + +Avery 5160 | 1 x 2-5/8 +Gaylord 8511 Spine Label +Avery 5460 - vertical +Avery 5460 - spine labels +Avery 8163 - 2rows x 5 rows +cards Avery 5160 | 1 x 2-5/8 : 1 x 2-5/8\" [3x10] : equivalent: Gaylord JD-ML3000 diff --git a/installer/data/en/optional/sample_z3950_servers.sql b/installer/data/en/optional/sample_z3950_servers.sql new file mode 100644 index 0000000000..ad3b03daf3 --- /dev/null +++ b/installer/data/en/optional/sample_z3950_servers.sql @@ -0,0 +1,7 @@ +INSERT INTO `z3950servers` +(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`) VALUES +('z3950.loc.gov',7090,'Voyager','','','LIBRARY OF CONGRESS',1,1,1,'USMARC'), +('bobcat.nyu.edu',210,'advance','','','NEW YORK UNIVERSITY LIBRARIES',5,0,0,'USMARC'), +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC'), +('catnyp.nypl.org',210,'innopac','','','NEW YORK PUBLIC LIBRARY',7,0,0,'USMARC'), +('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC'); diff --git a/installer/data/en/optional/sample_z3950_servers.txt b/installer/data/en/optional/sample_z3950_servers.txt new file mode 100644 index 0000000000..121badd5d5 --- /dev/null +++ b/installer/data/en/optional/sample_z3950_servers.txt @@ -0,0 +1,5 @@ +LIBRARY OF CONGRESS +NEW YORK UNIVERSITY LIBRARIES +COLUMBIA UNIVERSITY +NEW YORK PUBLIC LIBRARY +SMITHSONIAN INSTITUTION LIBRARIES -- 2.39.5