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

(-)a/installer/data/mysql/pl-PL/optional/auth_val.sql (-10 / +29 lines)
Lines 5-17 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
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');
(-)a/installer/data/mysql/pl-PL/optional/parameters.sql (-5 / +4 lines)
Lines 1-6 Link Here
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
(-)a/installer/data/mysql/pl-PL/optional/patron_categories.txt (-16 / +16 lines)
Lines 1-25 Link Here
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.
(-)a/installer/data/mysql/pl-PL/optional/sample_budgets.sql (-11 lines)
Lines 1-11 Link Here
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,'');
(-)a/installer/data/mysql/pl-PL/optional/sample_budgets.txt (-1 lines)
Line 1 Link Here
1
Przykładowe budżety i fundusze.
(-)a/installer/data/mysql/pl-PL/optional/sample_labels.sql (-21 lines)
Lines 1-21 Link Here
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;
(-)a/installer/data/mysql/pl-PL/optional/sample_labels.txt (-9 lines)
Lines 1-9 Link Here
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
(-)a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql (-5 / +14 lines)
Lines 1-5 Link Here
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');
(-)a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt (-3 / +5 lines)
Lines 1-3 Link Here
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