Attachment #35399 for bug #13373

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

Lines 5-17 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here

(-)a/installer/data/mysql/pl-PL/optional/auth_val.sql (-10 / +29 lines)
5	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');	5	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6		6
7	-- availability statuses	7	-- availability statuses
8	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');	8	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Długo przetrzymywany (Zagubiony)');
9	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');	9	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Zagubiony');
10	INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');	10	INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Zagubiony i opłacony');
11	INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing');	11	INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Zaginiony');
12		12
13	-- damaged status of an item	13	-- damaged status of an item
14	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');	14	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Uszkodzony');
15		15
16	-- location qualification for an item, departments are linked by default to items.location	16	-- location qualification for an item, departments are linked by default to items.location
17	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');	17	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
Lines 22-27 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC', Link Here
22	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks');	22	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks');
23	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual');	23	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual');
24	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference');	24	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference');
		25	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart');
		26	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center');
25		27
26	-- collection codes for an item	28	-- collection codes for an item
27	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');	29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
Lines 29-43 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
29	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');	31	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
30		32
31	-- withdrawn status of an item, linked to items.withdrawn	33	-- withdrawn status of an item, linked to items.withdrawn
32	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');	34	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Wycofany');
33		35
34	-- loanability status of an item, linked to items.notforloan	36	-- loanability status of an item, linked to items.notforloan
35	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');	37	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Zamówiony');
36	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');	38	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nie do wypożyczenia');
37	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');	39	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Zasób pracowniczy');
38		40
39	-- restricted status of an item, linked to items.restricted	41	-- restricted status of an item, linked to items.restricted
40	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');	42	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Ograniczony dostęp');
		43
		44	-- manual invoice types
		45	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Opłata za ksero','.25');
		46
		47	-- custom borrower notes
		48	INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Uwagi do adresu');
		49
		50	-- OPAC Suggestions reasons
		51	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');
		52	INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author');
		53
		54	-- Report groups
		55	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Udostępnianie');
		56	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Katalog');
		57	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Uzytkownicy');
		58	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Gromadzenie');
		59	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Konta');
41		60
42	-- SIP2 media types	61	-- SIP2 media types
43	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other');	62	INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other');

Lines 1-6 Link Here

(-)a/installer/data/mysql/pl-PL/optional/parameters.sql (-5 / +4 lines)
1	INSERT INTO `currency` (currency, rate, symbol, active) VALUES	1	INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2	('PLN', 1.0, 'zł', 1),	2	('PLN', 1.0, 'zł', '1'),
3	('USD', 2.77, '$', 0),	3	('USD', .2988, '$', '0'),
4	('GBP', 4.5, '£', 0),	4	('GBP', .1903, '£', '0'),
5	('EUR', 4.1, '€', 0);	5	('EUR', .2403, '€', '0');
6




Przykładowe typy i kategorie czytelników:

Typ:			Kategoria:

Dorosły użytkownik - domyślny typ użytkownika
				PT 	- Czytelnik
				ST 	- Student
				BH 	- Homebound

Dziecko - użytkownik z nadzorcą (dorosłym)
				K 	- Dziecko
				J 	- Nastolatek
				YA	- Młodież

Organizacja - konto instytucji, a nie osoby
				ILL - Wypożyczalnia międzybiblioteczna
				SC	- Szkoła
				L	- Biblioteka

Pracownik - członek organizacji (organizacja jest nadzorcą)
				T	- Nauczyciel
				S	- Pracownik
				B	- Zarząd

Typy w chwili obecnej są zdefiniowane na stałe. Kategorie mogą być dodawane/modyfikowane/usuwane po zakończeniu instalacji w module administracyjnym.

Lines 1-11 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_budgets.sql (-11 lines)
1	INSERT INTO `aqbudget` VALUES
2
3	('CHILD','2008-01-01','2008-12-31','5000.00',1,''),
4	('GEN','2008-01-01','2008-12-31','20000.00',2,''),
5	('REF','2008-01-01','2008-12-31','5000.00',3,'');
6
7	INSERT INTO `aqbookfund` VALUES
8
9	('CHILD','Children\'s Materials',NULL,''),
10	('GEN','General Stacks',NULL,''),
11	('REF','Reference Materials',NULL,'');

Line 1 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_budgets.txt (-1 lines)
1	Przykładowe budżety i fundusze.

Lines 1-21 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_labels.sql (-21 lines)
1	-- Label Templates
2	LOCK TABLES `labels_templates` WRITE;
3	/!40000 ALTER TABLE `labels_templates` DISABLE KEYS /;
4	INSERT INTO `labels_templates` VALUES
5	(1,0,'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'),
6	(2,0,'Gaylord 8511 Spine Label','Prints only the left-hand column of a Gaylord 8511.', 8.5, 11, 1, 1.25, 0.6, 0.5, 0, 0, 1, 8, 0, 0, 'INCH'),
7	(3,0,'Avery 5460 vertical', '', 3.625, 5.625, 1.5, 0.75, 0.38, 0.35, 2, 7, 2, 1, 0.25, 0, 'INCH'),
8	(4,0,'Avery 5460 spine labels', '', 5.625, 3.625, 0.75, 1.5, 0.35, 0.31, 7, 2, 1, 0, 0.25, 0, 'INCH'),
9	(5,0,'Avery 8163', '2rows x 5 rows', 8.5, 11, 4, 2, 0, 0, 0.5, 0.17, 2, 5, 0.2, 0.01, 'INCH'),
10	(6,0,'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, 0, 0.25, 0, 3, 10, 0.2, 0.01, 'INCH'),
11	(7,0,'Demco WS14942260', '1\" X 1.5\" Spine Label', 8.5, 11, 1.5, 1, 0.236, 0, 0.4, 0.25, 5, 10, 0.0625, 0, 'INCH');
12	/!40000 ALTER TABLE `labels_templates` ENABLE KEYS /;
13	UNLOCK TABLES;
14	LOCK TABLES `labels_layouts` WRITE;
15	/!40000 ALTER TABLE `labels_layouts` DISABLE KEYS /;
16	INSERT INTO `labels_layouts` VALUES
17	(1,'CODE39','BIBBAR', 'biblio and barcode', 0, 'TR',7,0,'L','title, author, itemcallnumber'),
18	(2,'CODE39','BIB', 'spine', 0, 'TR',3,1,'L','itemcallnumber'),
19	(3,'CODE39','BARBIB', 'barcode and biblio', 0, 'TR',3,1,'L','title, author, itemcallnumber');
20	/!40000 ALTER TABLE `labels_layouts` ENABLE KEYS /;
21	UNLOCK TABLES;

Lines 1-9 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_labels.txt (-9 lines)
1	Przykładowe etykiety:
2
3	Avery 5160 \| 1 x 2-5/8
4	Gaylord 8511 Spine Label
5	Avery 5460 - vertical
6	Avery 5460 - spine labels
7	Avery 8163 - 2rows x 5 rows
8	cards Avery 5160 \| 1 x 2-5/8 : 1 x 2-5/8" [3x10] : equivalent: Gaylord JD-ML3000
9	Demco WS14942260 \| 1" X 1.5" Spine Label




INSERT INTO z3950servers
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'),
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'),
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio');

#Insert SRU server
INSERT INTO z3950servers
(host, port, db, servername, syntax, encoding, servertype, sru_fields)
VALUES
('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier');

Lines 1-3 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt (-3 / +5 lines)
1	BIBLIOTEKA NARODOWA	1	BIBLIOTEKA NARODOWA
2	BIBLIOTEKA PUBLICZNA DZIELNICY BEMOWO	2	BIBLIOTEKA KONGRESU
3	LIBRARY OF CONGRESS	3	BIBLIOTEKA KONGRESU FORMALNE (Hasła wzorcowe)
		4	BIBLIOTEKA KONGRESU PRZEDMIOTOWE (Hasła wzorcowe)
		5	COLUMBIA UNIVERSITY
		6	SMITHSONIAN INSTITUTION LIBRARIES
4	-

Return to bug 13373

Lines 1-25 Link Here

(-)a/installer/data/mysql/pl-PL/optional/patron_categories.txt (-16 / +16 lines)
1	Przykładowe typy i kategorie czytelników:	1	Przykładowe typy i kategorie czytelników:
2		2
3	Type: Categories:	3	Typ: Kategoria:
4		4
5	Adult Patron - default patron type	5	Dorosły użytkownik - domyślny typ użytkownika
6	PT - Patron	6	PT - Czytelnik
7	ST - Student	7	ST - Student
8	BH - Homebound	8	BH - Homebound
9		9
10	Child - patron with a guarantor	10	Dziecko - użytkownik z nadzorcą (dorosłym)
11	K - Kid	11	K - Dziecko
12	J - Juvenile	12	J - Nastolatek
13	YA - Young Adult	13	YA - Młodież
14		14
15	Organization - patron is an institution, not a person	15	Organizacja - konto instytucji, a nie osoby
16	ILL - Inter-library Loan	16	ILL - Wypożyczalnia międzybiblioteczna
17	SC - School	17	SC - Szkoła
18	L - Library	18	L - Biblioteka
19		19
20	Professional - a member of an organization (organization is guarantor)	20	Pracownik - członek organizacji (organizacja jest nadzorcą)
21	T - Teacher	21	T - Nauczyciel
22	S - Staff	22	S - Pracownik
23	B - Board	23	B - Zarząd
24		24
25	Types are currently hardcoded, but you can add/edit/delete categories after installation from the administration module.	25	Typy w chwili obecnej są zdefiniowane na stałe. Kategorie mogą być dodawane/modyfikowane/usuwane po zakończeniu instalacji w module administracyjnym.

Lines 1-5 Link Here

(-)a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql (-5 / +14 lines)
1	INSERT INTO `z3950servers`	1	INSERT INTO z3950servers
2	(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES	2	(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
3	('193.59.172.100',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,1,'MARC21','UTF8'),	3	('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'),
4	('62.181.1.243',4321,'bilbo','','','BP BEMOWO',2,1,1,'MARC21','UTF8'),	4	('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
5	('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',3,0,1,'USMARC','utf8');	5	('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
		6	('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
		7	('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'),
		8	('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio');
		9
		10	#Insert SRU server
		11	INSERT INTO z3950servers
		12	(host, port, db, servername, syntax, encoding, servertype, sru_fields)
		13	VALUES
		14	('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier');