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

(-)a/installer/data/mysql/fi-FI/mandatory/auth_values.sql (+3 lines)
Line 0 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week');
(-)a/installer/data/mysql/fi-FI/mandatory/auth_values.txt (+1 lines)
Line 0 Link Here
1
Default Koha system authorised values
(-)a/installer/data/mysql/fi-FI/mandatory/class_sources.sql (+41 lines)
Line 0 Link Here
1
--
2
-- Default classification sources and filing rules
3
-- for Koha.
4
--
5
-- Copyright (C) 2007 LiblimeA
6
-- Copyright 2018 Koha Development Team
7
--
8
-- This file is part of Koha.
9
--
10
-- Koha is free software; you can redistribute it and/or modify it under the
11
-- terms of the GNU General Public License as published by the Free Software
12
-- Foundation; either version 2 of the License, or (at your option) any later
13
-- version.
14
--
15
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
18
--
19
-- You should have received a copy of the GNU General Public License along
20
-- with Koha; if not, write to the Free Software Foundation, Inc.,
21
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22
23
-- class sorting (filing) rules
24
INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES
25
                               ('dewey', 'Default filing rules for DDC', 'Dewey'),
26
                               ('lcc', 'Default filing rules for LCC', 'LCC'),
27
                               ('generic', 'Generic call number filing rules', 'Generic');
28
-- splitting rules
29
INSERT INTO `class_split_rules` (`class_split_rule`, `description`, `split_routine`) VALUES
30
                               ('dewey', 'Default splitting rules for DDC', 'Dewey'),
31
                               ('lcc', 'Default splitting rules for LCC', 'LCC'),
32
                               ('generic', 'Generic call number splitting rules', 'Generic');
33
34
-- classification schemes or sources
35
INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`, `class_split_rule`) VALUES
36
                            ('ddc', 'Dewey Decimal Classification', 1, 'dewey', 'dewey'),
37
                            ('lcc', 'Library of Congress Classification', 1, 'lcc', 'lcc'),
38
                            ('udc', 'Universal Decimal Classification', 0, 'generic', 'generic'),
39
                            ('sudocs', 'SuDoc Classification (U.S. GPO)', 0, 'generic', 'generic'),
40
                            ('anscr', 'ANSCR (Sound Recordings)', 0, 'generic', 'generic'),
41
                            ('z', 'Other/Generic Classification Scheme', 0, 'generic', 'generic');
(-)a/installer/data/mysql/fi-FI/mandatory/class_sources.txt (+1 lines)
Line 0 Link Here
1
Default classification sources and filing rules
(-)a/installer/data/mysql/fi-FI/mandatory/message_transport_types.sql (+7 lines)
Line 0 Link Here
1
INSERT INTO message_transport_types
2
(message_transport_type)
3
values
4
('email'),
5
('print'),
6
('sms'),
7
('phone');
(-)a/installer/data/mysql/fi-FI/mandatory/message_transport_types.txt (+1 lines)
Line 0 Link Here
1
Defines default message transports for email and sms.
(-)a/installer/data/mysql/fi-FI/mandatory/sample_frequencies.sql (+16 lines)
Line 0 Link Here
1
INSERT INTO subscription_frequencies
2
    (description, unit, unitsperissue, issuesperunit, displayorder)
3
VALUES
4
    ('2/day', 'day', 1, 2, 1),
5
    ('1/day', 'day', 1, 1, 2),
6
    ('3/week', 'week', 1, 3, 3),
7
    ('1/week', 'week', 1, 1, 4),
8
    ('1/2 weeks', 'week', 2, 1, 5),
9
    ('1/3 weeks', 'week', 3, 1, 6),
10
    ('1/month', 'month', 1, 1, 7),
11
    ('1/2 months', 'month', 2, 1, 8),
12
    ('1/3 months', 'month', 3, 1, 9),
13
    ('2/year', 'month', 6, 1, 10),
14
    ('1/year', 'year', 1, 1, 11),
15
    ('1/2 year', 'year', 2, 1, 12),
16
    ('Irregular', NULL, 1, 1, 13);
(-)a/installer/data/mysql/fi-FI/mandatory/sample_frequencies.txt (+1 lines)
Line 0 Link Here
1
Sample frequencies for subscriptions
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices.sql (+184 lines)
Line 0 Link Here
1
INSERT INTO `letter` (module, code, name, title, content, message_transport_type)
2
VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>\n\nThank-you for your prompt attention to this matter.\n\n<<branches.branchname>> Staff\n', 'email'),
3
('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>', 'email'),
4
('orderacquisition','ACQORDER','Acquisition order','Order','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\nPlease order for the library:\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (quantity: <<aqorders.quantity>>) ($<<aqorders.listprice>> each).</order>\r\n\r\nThank you,\n\n<<branches.branchname>>', 'email'),
5
('serial','SERIAL_ALERT','New serial issue','New serial issue is now available','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following issue is now available:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nPlease pick it up at your convenience.', 'email'),
6
('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  <<borrowers.userid>>\r\nPassword: <<borrowers.password>>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin@yoursite.org', 'email'),
7
('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
8
('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due', 'email'),
9
('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item Due','Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item will be due soon:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)', 'email'),
10
('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <<count>> items due soon', 'email'),
11
('circulation','RENEWAL','Item Renewals','Item Renewals','The following items have been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.', 'email'),
12
('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <<branches.branchname>>', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>', 'email'),
13
('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup (print notice)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> <<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\n', 'print'),
14
('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following items have been checked in:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you.', 'email'),
15
('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following items have been checked out:\r\n----\r\n[% biblio.title %]\r\n----\r\nThank you for visiting [% branch.branchname %].', 'email'),
16
('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).', 'email'),
17
('reserves', 'CANCEL_HOLD_ON_LOST', 'Hold has been cancelled', "Hold has been cancelled", "Dear [% borrower.firstname %] [% borrower.surname %],\n\nWe regret to inform you, that the following item can not be provided due to it being missing. Your hold was cancelled.\n\nTitle: [% biblio.title %]\nAuthor: [% biblio.author %]\nCopy: [% item.copynumber %]\nLocation: [% branch.branchname %]", 'email'),
18
('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion accepted','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your suggestion today. The item will be ordered as soon as possible. You will be notified by mail when the order is completed, and again when the item arrives at the library.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
19
('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase available','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
20
('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>', 'email'),
21
('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>', 'email'),
22
('suggestions','TO_PROCESS','Notify fund owner', 'A suggestion is ready to be processed','Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nA new suggestion is ready to be processed: <<suggestions.title>> by <<suggestions.author>>.\n\nThank you,\n\n<<branches.branchname>>', 'email');
23
24
INSERT INTO `letter` (module, code, name, title, content, is_html, message_transport_type)
25
VALUES ('members', 'DISCHARGE', 'Discharge confirmation', 'Discharge for <<borrowers.firstname>> <<borrowers.surname>>', '
26
<<today>>
27
<h1>Discharge confirmation</h1>
28
<p><<branches.branchname>> certifies that the following borrower:<br>
29
<<borrowers.firstname>> <<borrowers.surname>> (cardnumber: <<borrowers.cardnumber>>)<br>
30
has returned all items.</p>', 1, 'email');
31
32
INSERT INTO `letter` (module, code, name, title, content, is_html)
33
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
34
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
35
(<<borrowers.cardnumber>>) <br />
36
37
<<today>><br />
38
39
<h4>Checked Out</h4>
40
<checkedout>
41
<p>
42
<<biblio.title>> <br />
43
Barcode: <<items.barcode>><br />
44
Date due: <<issues.date_due>><br />
45
</p>
46
</checkedout>
47
48
<h4>Overdues</h4>
49
<overdue>
50
<p>
51
<<biblio.title>> <br />
52
Barcode: <<items.barcode>><br />
53
Date due: <<issues.date_due>><br />
54
</p>
55
</overdue>
56
57
<hr>
58
59
<h4 style="text-align: center; font-style:italic;">News</h4>
60
<news>
61
<div class="newsitem">
62
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
63
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.content>></p>
64
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
65
<hr />
66
</div>
67
</news>', 1),
68
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
69
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
70
(<<borrowers.cardnumber>>) <br />
71
72
<<today>><br />
73
74
<h4>Checked Out Today</h4>
75
<checkedout>
76
<p>
77
<<biblio.title>> <br />
78
Barcode: <<items.barcode>><br />
79
Date due: <<issues.date_due>><br />
80
</p>
81
</checkedout>', 1),
82
('circulation','HOLD_SLIP','Hold Slip','Hold Slip', '<h5>Date: <<today>></h5>
83
84
<h3> Transfer to/Hold in <<branches.branchname>></h3>
85
86
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
87
88
<ul>
89
    <li><<borrowers.cardnumber>></li>
90
    <li><<borrowers.phone>></li>
91
    <li> <<borrowers.address>><br />
92
         <<borrowers.address2>><br />
93
         <<borrowers.city >>  <<borrowers.zipcode>>
94
    </li>
95
    <li><<borrowers.email>></li>
96
</ul>
97
<br />
98
<h3>ITEM ON HOLD</h3>
99
<h4><<biblio.title>></h4>
100
<h5><<biblio.author>></h5>
101
<ul>
102
   <li><<items.barcode>></li>
103
   <li><<items.itemcallnumber>></li>
104
   <li><<reserves.waitingdate>></li>
105
</ul>
106
<p>Notes:
107
<pre><<reserves.reservenotes>></pre>
108
</p>
109
', 1),
110
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
111
112
<h3>Transfer to <<branches.branchname>></h3>
113
114
<h3>ITEM</h3>
115
<h4><<biblio.title>></h4>
116
<h5><<biblio.author>></h5>
117
<ul>
118
   <li><<items.barcode>></li>
119
   <li><<items.itemcallnumber>></li>
120
</ul>', 1);
121
122
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
123
VALUES (
124
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
125
126
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
127
128
<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
129
130
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
131
);
132
133
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
134
VALUES ('members', 'SHARE_INVITE', '', 'Invitation for sharing a list', '0', 'Share list <<listname>>', 'Dear patron,
135
136
One of our patrons, <<borrowers.firstname>> <<borrowers.surname>>, invites you to share a list <<listname>> in our library catalog.
137
138
To access this shared list, please click on the following URL or copy-and-paste it into your browser address bar.
139
140
<<shareurl>>
141
142
In case you are not a patron in our library or do not want to accept this invitation, please ignore this mail. Note also that this invitation expires within two weeks.
143
144
Thank you.
145
146
Your library.'
147
);
148
INSERT INTO  letter (module, code, branchcode, name, is_html, title, content)
149
VALUES ( 'members', 'SHARE_ACCEPT', '', 'Notification about an accepted share', '0', 'Share on list <<listname>> accepted', 'Dear patron,
150
151
We want to inform you that <<borrowers.firstname>> <<borrowers.surname>> accepted your invitation to share your list <<listname>> in our library catalog.
152
153
Thank you.
154
155
Your library.'
156
);
157
158
INSERT INTO letter(module, code, branchcode, name, title, content, message_transport_type)
159
VALUES ('acquisition', 'ACQ_NOTIF_ON_RECEIV', '', 'Notification on receiving', 'Order received', 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\n The order <<aqorders.ordernumber>> (<<biblio.title>>) has been received.\n\nYour library.', 'email'),
160
('members','MEMBERSHIP_EXPIRY','','Account expiration','Account expiration','Dear <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYour library card will expire soon, on:\r\n\r\n<<borrowers.dateexpiry>>\r\n\r\nThank you,\r\n\r\nLibrarian\r\n\r\n<<branches.branchname>>','email');
161
162
INSERT INTO letter ( module, code, branchcode, name, is_html, title, content, message_transport_type )
163
VALUES ( 'circulation', 'OVERDUES_SLIP', '', 'Overdues Slip', '0', 'OVERDUES_SLIP', 'The following item(s) is/are currently overdue:
164
165
<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>
166
', 'print' );
167
168
INSERT INTO `letter` (module, code, branchcode, name, is_html, title, content, message_transport_type)
169
VALUES ('members','PASSWORD_RESET','','Online password reset',1,'Koha password recovery','<html>\r\n<p>This email has been sent in response to your password recovery request for the account <strong><<user>></strong>.\r\n</p>\r\n<p>\r\nYou can now create your new password using the following link:\r\n<br/><a href=\"<<passwordreseturl>>\"><<passwordreseturl>></a>\r\n</p>\r\n<p>This link will be valid for 2 days from this email\'s reception, then you must reapply if you do not change your password.</p>\r\n<p>Thank you.</p>\r\n</html>\r\n','email'
170
);
171
172
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
173
('circulation', 'AR_CANCELED', '', 'Article request - canceled', 0, 'Article request canceled', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nYour request for an article from <<biblio.title>> (<<items.barcode>>) has been canceled for the following reason:\r\n\r\n<<article_requests.notes>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nYour library', 'email'),
174
('circulation', 'AR_COMPLETED', '', 'Article request - completed', 0, 'Article request completed', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe have completed your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nYou may pick your article up at <<branches.branchname>>.\r\n\r\nThank you!', 'email'),
175
('circulation', 'AR_PENDING', '', 'Article request - open', 0, 'Article request received', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>)\r\n\r\nWe have received your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\n\r\nThank you!', 'email'),
176
('circulation', 'AR_SLIP', '', 'Article request - print slip', 0, 'Article request', 'Article request:\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nTitle: <<biblio.title>>\r\nBarcode: <<items.barcode>>\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n', 'print'),
177
('circulation', 'AR_PROCESSING', '', 'Article request - processing', 0, 'Article request processing', 'Dear <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>),\r\n\r\nWe are now processing your request for an article from <<biblio.title>> (<<items.barcode>>).\r\n\r\nArticle requested:\r\nTitle: <<article_requests.title>>\r\nAuthor: <<article_requests.author>>\r\nVolume: <<article_requests.volume>>\r\nIssue: <<article_requests.issue>>\r\nDate: <<article_requests.date>>\r\nPages: <<article_requests.pages>>\r\nChapters: <<article_requests.chapters>>\r\nNotes: <<article_requests.patron_notes>>\r\n\r\nThank you!', 'email'),
178
('circulation', 'CHECKOUT_NOTE', '', 'Checkout note on item set by patron', '0', 'Checkout note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.title>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');
179
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`, `lang`)
180
    VALUES
181
        ('circulation', 'ACCOUNT_PAYMENT', '', 'Account payment', 0, 'Account payment', '[%- USE Price -%]\r\nA payment of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis payment affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default'),
182
            ('circulation', 'ACCOUNT_WRITEOFF', '', 'Account writeoff', 0, 'Account writeoff', '[%- USE Price -%]\r\nAn account writeoff of [% credit.amount * -1 | $Price %] has been applied to your account.\r\n\r\nThis writeoff affected the following fees:\r\n[%- FOREACH o IN offsets %]\r\nDescription: [% o.debit.description %]\r\nAmount paid: [% o.amount * -1 | $Price %]\r\nAmount remaining: [% o.debit.amountoutstanding | $Price %]\r\n[% END %]', 'email', 'default');
183
INSERT INTO `letter` (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES
184
('circulation', 'SR_SLIP', '', 'Stock Rotation Slip', 0, 'Stockrotation Report', 'Stockrotation report for [% branch.name %]:\r\n\r\n[% IF branch.items.size %][% branch.items.size %] items to be processed for this branch.\r\n[% ELSE %]No items to be processed for this branch\r\n[% END %][% FOREACH item IN branch.items %][% IF item.reason != \'in-demand\' %]Title: [% item.title %]\r\nAuthor: [% item.author %]\r\nCallnumber: [% item.callnumber %]\r\nLocation: [% item.location %]\r\nBarcode: [% item.barcode %]\r\nOn loan?: [% item.onloan %]\r\nStatus: [% item.reason %]\r\nCurrent Library: [% item.branch.branchname %] [% item.branch.branchcode %]\r\n\r\n[% END %][% END %]', 'email');
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices.txt (+1 lines)
Line 0 Link Here
1
Sample notices
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices_message_attributes.sql (+8 lines)
Line 0 Link Here
1
insert into `message_attributes`
2
(`message_attribute_id`, message_name, `takes_days`)
3
values
4
(1, 'Item_Due', 0),
5
(2, 'Advance_Notice', 1),
6
(4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices_message_attributes.txt (+1 lines)
Line 0 Link Here
1
Defines default messages for the enhanced messaging configuration.
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices_message_transports.sql (+20 lines)
Line 0 Link Here
1
insert into `message_transports`
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
20
(6, 'sms',   0, 'circulation', 'CHECKOUT');
(-)a/installer/data/mysql/fi-FI/mandatory/sample_notices_message_transports.txt (+2 lines)
Line 0 Link Here
1
Defines default message transports for sending item due messages and
2
advance notice messages through email and SMS.
(-)a/installer/data/mysql/fi-FI/mandatory/sample_numberpatterns.sql (+25 lines)
Line 0 Link Here
1
INSERT INTO subscription_numberpatterns
2
    (label, displayorder, description, numberingmethod,
3
    label1, add1, every1, whenmorethan1, setto1, numbering1,
4
    label2, add2, every2, whenmorethan2, setto2, numbering2,
5
    label3, add3, every3, whenmorethan3, setto3, numbering3)
6
VALUES
7
    ('Number', 1, 'Simple Numbering method', 'No. {X}',
8
    'Number', 1, 1, 99999, 1, NULL,
9
    NULL, NULL, NULL, NULL, NULL, NULL,
10
    NULL, NULL, NULL, NULL, NULL, NULL),
11
12
    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
13
    'Volume', 1, 48, 99999, 1, NULL,
14
    'Number', 1, 4, 12, 1, NULL,
15
    'Issue', 1, 1, 4, 1, NULL),
16
17
    ('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
18
    'Volume', 1, 12, 99999, 1, NULL,
19
    'Number', 1, 1, 12, 1, NULL,
20
    NULL, NULL, NULL, NULL, NULL, NULL),
21
22
    ('Seasonal', 4, 'Season Year', '{X} {Y}',
23
    'Season', 1, 1, 3, 0, 'season',
24
    'Year', 1, 4, 99999, 1, NULL,
25
    NULL, NULL, NULL, NULL, NULL, NULL);
(-)a/installer/data/mysql/fi-FI/mandatory/sample_numberpatterns.txt (+1 lines)
Line 0 Link Here
1
Sample numbering patterns for subscriptions
(-)a/installer/data/mysql/fi-FI/optional/auth_val.sql (+85 lines)
Line 0 Link Here
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
2
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Shelf Copy Damaged');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6
7
-- Desired formats for requesting new materials
8
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book');
9
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print');
10
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
11
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
12
INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
13
14
-- availability statuses
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
17
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
18
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
19
20
-- damaged status of an item
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
22
23
-- location qualification for an item, departments are linked by default to items.location
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Children\'s Area');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','On Display');
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','New Materials Shelf');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Staff Office');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center');
34
35
-- collection codes for an item
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non-fiction');
39
40
-- withdrawn status of an item, linked to items.withdrawn
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
42
43
-- loanability status of an item, linked to items.notforloan
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
47
48
-- restricted status of an item, linked to items.restricted
49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
50
51
-- manual invoice types
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Copier Fees','.25');
53
54
-- custom borrower notes
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes');
56
57
-- OPAC Suggestions reasons
58
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');
59
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author');
60
61
-- Report groups
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Catalog');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Patrons');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Serials');
68
69
-- SIP2 media types
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '001', 'Book');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '002', 'Magazine');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '003', 'Bound journal');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '004', 'Audio tape');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '005', 'Video tape');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '006', 'CD/CDROM');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '007', 'Diskette');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '008', 'Book with diskette');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '009', 'Book with CD');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape');
81
82
-- order cancellation reasons
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
(-)a/installer/data/mysql/fi-FI/optional/auth_val.txt (+1 lines)
Line 0 Link Here
1
Some basic default authorised values for library locations, item lost status, etc. You can change these at any time after installation.
(-)a/installer/data/mysql/fi-FI/optional/csv_profiles.sql (+2 lines)
Line 0 Link Here
1
INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type, used_for )
2
VALUES ( "issues to claim", "default CSV export for serial issue claims", "SUPPLIER=aqbooksellers.name|TITLE=subscription.title|ISSUE NUMBER=serial.serialseq|LATE SINCE=serial.planneddate", ",", "sql", "late_issues" );
(-)a/installer/data/mysql/fi-FI/optional/csv_profiles.txt (+3 lines)
Line 0 Link Here
1
CSV profiles
2
3
Default CSV export profiles; including one for exporting serial claims.
(-)a/installer/data/mysql/fi-FI/optional/marc21_holdings_coded_values.sql (+145 lines)
Line 0 Link Here
1
-- Coded values conforming to the Z39.77-2006 Holdings Statements for Bibliographic Items');
2
-- ISSN: 1041-5653
3
-- Refer to https://www.niso.org/publications/standards
4
5
-- General Holdings: Type of Unit Designator
6
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','0','Information not available; Not applicable');
7
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','a','Basic bibliographic unit');
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','c','Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes');
10
11
-- Physical Form Designators
12
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Cartographic material');
13
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram');
15
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ak' ,'Cartographic material, profile');
17
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aq' ,'Cartographic material, model');
18
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ar' ,'Cartographic material, remote sensing image');
19
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','as' ,'Cartographic material, section');
20
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view');
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other');
22
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Computer file');
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge');
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge');
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge');
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cf' ,'Computer file, tape cassette');
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Computer file, optical disk');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote');
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other');
34
35
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','du' ,'Globe');
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','da' ,'Globe, celestial');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','db' ,'Globe, planetary or lunar');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dc' ,'Globe, terrestrial');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon');
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other');
41
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Kit');
43
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Microform');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card');
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette');
48
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hd',' Microform, microfilm reel');
49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','he' ,'Microform, microfiche');
50
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hf' ,'Microform, microfiche cassette');
51
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque');
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other');
53
54
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Motion picture');
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge');
56
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette');
57
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel');
58
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other');
59
60
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Nonprojected graphic');
61
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage');
62
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing');
63
64
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Nonprojected graphic, painting');
65
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print');
66
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative');
67
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint');
68
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ki' ,'Nonprojected graphic, picture');
69
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kj' ,'Nonprojected graphic, print');
70
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kl' ,'Nonprojected graphic, technical drawing');
71
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kn' ,'Nonprojected graphic, chart');
72
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card');
73
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other');
74
75
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Notated music');
76
77
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic');
78
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge');
79
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gd' ,'Projected graphic, filmstrip');
80
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gf' ,'Projected graphic, other type of filmstrip');
81
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','go' ,'Projected graphic, filmstrip roll');
82
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gs' ,'Projected graphic, slide');
83
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gt' ,'Projected graphic, transparency');
84
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gz' ,'Projected graphic, other');
85
86
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image');
87
88
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Sound recording');
89
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Sound recording, sound disk');
90
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder');
91
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge');
92
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film');
93
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll');
94
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'Sound recording, sound cassette');
95
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel');
96
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording');
97
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other');
98
99
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Text');
100
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Text, regular print');
101
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Text, large print');
102
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Text, Braille');
103
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf');
104
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other');
105
106
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videorecording');
107
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge');
108
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'Videorecording, videodisc');
109
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'Videorecording, videocassette');
110
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel');
111
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other');
112
113
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zu' ,'Physical form is unspecified');
114
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zm' ,'Multiple physical forms');
115
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zz' ,'Other physical media');
116
117
-- General Holdings: Completeness Designator
118
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','0','Information not available, or Retention is limited');
119
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','1','Complete (95%-100% held)');
120
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','2','Incomplete (50%-94% held)');
121
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','3','Very incomplete or scattered (less than 50% held)');
122
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','4','Not applicable');
123
124
-- General Holdings: Acquisition Status Designator
125
-- This data element specifies acquisition status for the unit at the time of the holdings report.
126
127
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited');
128
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other');
129
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased');
130
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','On order');
131
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Currently received');
132
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Not currently received');
133
134
-- General Holdings: Retention Designator
135
-- This data element specifies the retention policy for the unit at the time of the holdings report.
136
137
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','0','Information not available');
138
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','1','Other');
139
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','2','Retained except as replaced by updates');
140
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','3','Sample issue retained');
141
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','4','Retained until replaced by microform, or other preservation format');
142
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','5','Retained until replaced by cumulation, replacement volume, or revision');
143
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','6','Limited retention (only some parts kept)');
144
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','7','No retention (no parts kept)');
145
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','8','Permanent retention (all parts kept permanently)');
(-)a/installer/data/mysql/fi-FI/optional/marc21_holdings_coded_values.txt (+2 lines)
Line 0 Link Here
1
Coded values conforming to the Z39.71-2006 holdings statements for bibliographic items.
2
Refer to https://www.niso.org/publications/standards for details.
(-)a/installer/data/mysql/fi-FI/optional/marc21_relatorterms.sql (+226 lines)
Line 0 Link Here
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor');
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter');
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.');
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator');
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator');
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts');
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger');
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist');
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name');
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name');
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction');
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay');
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder');
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer');
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator');
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer');
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer');
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor');
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler');
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder');
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Correspondent');
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector');
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor');
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer');
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text');
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer');
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman');
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director');
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer');
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor');
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author');
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor');
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver');
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist');
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor');
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree');
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator');
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist');
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee');
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer');
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist');
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Libelee');
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Lender');
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Libelee-appellant');
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Lighting designer');
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Libelant-appellee');
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Libelant');
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Libelant-appellant');
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Landscape architect');
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist');
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact');
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician');
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator');
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other');
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner');
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director');
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher');
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer');
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Printer of plates');
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel');
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer');
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer');
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer');
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Patent holder');
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer');
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer');
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party');
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Respondent-appellant');
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Research team head');
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Research team member');
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Scientific advisor');
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Scenarist');
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Sculptor');
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer');
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker');
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer');
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher');
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator');
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist');
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material');
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');
(-)a/installer/data/mysql/fi-FI/optional/marc21_relatorterms.txt (+1 lines)
Line 0 Link Here
1
MARC code list for relators, as of http://www.loc.gov/marc/relators/relaterm.html
(-)a/installer/data/mysql/fi-FI/optional/parameters.sql (+5 lines)
Line 0 Link Here
1
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2
('USD', 1.0, '$', '1'),
3
('GBP', 1.9929, '£', '0'),
4
('CAD', 1.02207, '$', '0'),
5
('EUR', .874003, '€', '0');
(-)a/installer/data/mysql/fi-FI/optional/parameters.txt (+1 lines)
Line 0 Link Here
1
Some basic currencies with USA dollar as default for ACQ module
(-)a/installer/data/mysql/fi-FI/optional/patron_atributes.sql (+2 lines)
Line 0 Link Here
1
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `staff_searchable`, `authorised_value_category`)
2
VALUES ('SHOW_BCODE',  'Show barcode on the summary screen items listings', 0, 0, 1, 0, 'YES_NO');
(-)a/installer/data/mysql/fi-FI/optional/patron_atributes.txt (+2 lines)
Line 0 Link Here
1
Useful patron attribute types:
2
* SHOW_BCODE - Show barcode on the patron summary screen items listings
(-)a/installer/data/mysql/fi-FI/optional/patron_categories.sql (+23 lines)
Line 0 Link Here
1
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES
2
3
-- Adult Patrons
4
('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5
('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6
('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
7
8
-- Children
9
('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10
('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11
('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
12
13
-- Professionals
14
('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
15
('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
16
17
-- Institutional
18
('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19
('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20
('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
21
22
-- Staff
23
('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
(-)a/installer/data/mysql/fi-FI/optional/patron_categories.txt (+21 lines)
Line 0 Link Here
1
Sample patron types and categories. Types are currently hardcoded but you can manage categories after installation from the administration module.
2
3
Adult patron - default patron type
4
                PT  - Patron
5
                ST  - Student
6
                BH  - Homebound
7
8
Child - patron with a guarantor
9
                K   - Kid
10
                J   - Juvenile
11
                YA  - Young Adult
12
13
Organization - patron is an institution, not a person
14
                ILL - Inter-library Loan
15
                SC  - School
16
                L   - Library
17
18
Professional - a member of an organization (organization is guarantor)
19
                T   - Teacher
20
                S   - Staff
21
                B   - Board
(-)a/installer/data/mysql/fi-FI/optional/sample_creator_data.sql (+34 lines)
Line 0 Link Here
1
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
2
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
3
4
LOCK TABLES `creator_layouts` WRITE;
5
INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
6
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
7
    <data_source image_name="none" image_source="patronimages" />
8
  </images>
9
  <text>&lt;firstname&gt; &lt;surname&gt;</text>
10
  <text enable="1" font="TR" font_size="10" llx="100" lly="100" text_alignment="L" />
11
  <text>Branch: &lt;branchcode&gt;</text>
12
  <text enable="1" font="TR" font_size="10" llx="100" lly="75" text_alignment="L" />
13
  <text>Expires: August 31, 2010</text>
14
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
15
</opt>
16
','Patroncards');
17
UNLOCK TABLES;
18
19
20
LOCK TABLES `creator_templates` WRITE;
21
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');
22
UNLOCK TABLES;
23
24
LOCK TABLES `printers_profile` WRITE;
25
INSERT INTO `printers_profile` ( profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator ) VALUES
26
( 1,'Library Laser',   1,'Bypass', -2,9,3,0,'POINT','Labels'),
27
(13,'Library Laser',   7,'Tray 1',  0,0,0,0,'POINT','Labels'),
28
(14,'Library Laser',  12,'Tray 2',  0,0,0,0,'POINT','Labels'),
29
(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards'),
30
(22,'Library Laser',   0,'Tray 3',  0,0,0,0,'POINT','Labels');
31
UNLOCK TABLES;
32
33
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
(-)a/installer/data/mysql/fi-FI/optional/sample_creator_data.txt (+1 lines)
Line 0 Link Here
1
Sample label and patron card data
(-)a/installer/data/mysql/fi-FI/optional/sample_holidays.sql (+4 lines)
Line 0 Link Here
1
INSERT INTO `repeatable_holidays` VALUES
2
(2,'MPL',0,NULL,NULL,'','Sundays'),
3
(3,'MPL',NULL,1,1,'','New Year\'s Day'),
4
(4,'MPL',NULL,25,12,'','Christmas');
(-)a/installer/data/mysql/fi-FI/optional/sample_holidays.txt (+1 lines)
Line 0 Link Here
1
Sample holidays: Sunday, Christmas, New Year's
(-)a/installer/data/mysql/fi-FI/optional/sample_itemtypes.sql (+9 lines)
Line 0 Link Here
1
INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
2
('BK', 'Books',0,0,'bridge/book.gif',''),
3
('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''),
4
('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''),
5
('MP', 'Maps',5,0,'bridge/map.gif',''),
6
('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''),
7
('MU', 'Music',5,0,'bridge/sound.gif',''),
8
('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''),
9
('REF', 'Reference',0,1,'bridge/reference.gif','');
(-)a/installer/data/mysql/fi-FI/optional/sample_itemtypes.txt (+1 lines)
Line 0 Link Here
1
A set of default item types.
(-)a/installer/data/mysql/fi-FI/optional/sample_libraries.sql (+15 lines)
Line 0 Link Here
1
INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
2
3
('MPL','Midway','372 Forest Street'),
4
('SPL','Springfield','Highland Boulevard'),
5
('RPL','Riverside','Johnson Terrace'),
6
('CPL','Centerville','Jefferson Summit'),
7
('FPL','Fairview','Hickory Squere'),
8
('FFL','Fairfield','River Station'),
9
('IPT','Institut Protestant de Théologie',''),
10
('PVL','Pleasant Valley','Meadow Grove'),
11
('TPL','Troy','Valley Way'),
12
('FRL','Franklin','Smith Heights'),
13
('LPL','Liberty','East Hills'),
14
('UPL','Union','Chestnut Hollow')
15
;
(-)a/installer/data/mysql/fi-FI/optional/sample_libraries.txt (+1 lines)
Line 0 Link Here
1
Sample libraries.
(-)a/installer/data/mysql/fi-FI/optional/sample_news.sql (+2 lines)
Line 0 Link Here
1
INSERT INTO `opac_news` (`title`, `content`, `lang`, `timestamp`, `expirationdate`, `number`) VALUES ('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<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
(-)a/installer/data/mysql/fi-FI/optional/sample_news.txt (+1 lines)
Line 0 Link Here
1
Sample news items
(-)a/installer/data/mysql/fi-FI/optional/sample_patrons.sql (+51 lines)
Line 0 Link Here
1
INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `guarantorid`, `borrowernotes`, `relationship`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES
2
(1,'1','Admin','Koha',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),
3
(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,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'),
4
(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,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'),
5
(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,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'),
6
(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,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'),
7
(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,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'),
8
(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,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'),
9
(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,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'),
10
(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,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'),
11
(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,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'),
12
(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,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'),
13
(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,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'),
14
(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,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'),
15
(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,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'),
16
(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,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'),
17
(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,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'),
18
(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,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'),
19
(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,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'),
20
(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,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'),
21
(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,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'),
22
(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,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'),
23
(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,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'),
24
(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,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'),
25
(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,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'),
26
(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,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'),
27
(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,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'),
28
(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,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'),
29
(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,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'),
30
(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,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'),
31
(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,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'),
32
(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,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'),
33
(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,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'),
34
(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,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'),
35
(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,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'),
36
(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,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'),
37
(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,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'),
38
(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,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'),
39
(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,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'),
40
(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,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'),
41
(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,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'),
42
(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,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'),
43
(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,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'),
44
(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,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'),
45
(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,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'),
46
(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,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'),
47
(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,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'),
48
(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,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'),
49
(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,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'),
50
(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,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'),
51
(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,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825');
(-)a/installer/data/mysql/fi-FI/optional/sample_patrons.txt (+1 lines)
Line 0 Link Here
1
Sample patrons
(-)a/installer/data/mysql/fi-FI/optional/sample_quotes.sql (+34 lines)
Line 0 Link Here
1
/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
2
INSERT INTO `quotes` VALUES
3
(1,'George Washington','To be prepared for war is one of the most effectual means of preserving peace.',now()),
4
(2,'Thomas Jefferson','When angry, count ten, before you speak; if very angry, an hundred.',now()),
5
(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.',now()),
6
(4,'Abraham Lincoln','I have always found that mercy bears richer fruits than strict justice.',now()),
7
(5,'Andrew Johnson','I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.',now()),
8
(6,'Rutherford B. Hayes','He serves his party best who serves his country best.',now()),
9
(7,'Theodore Roosevelt','No President has ever enjoyed himself as much as I?',now()),
10
(8,'Theodore Roosevelt','Speak softly and carry a big stick.',now()),
11
(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.',now()),
12
(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.',now()),
13
(12,'Calvin Coolidge','If you don\'t say anything, you won\'t be called on to repeat it.',now()),
14
(13,'Calvin Coolidge','Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.',now()),
15
(14,'Herbert Hoover','The slogan of progress is changing from the full dinner pail to the full garage.',now()),
16
(15,'Franklin D. Roosevelt','Let me assert my firm belief that the only thing we have to fear is fear itself.',now()),
17
(16,'Harry S. Truman','If you can\'t stand the heat, get out of the kitchen.',now()),
18
(17,'Harry S. Truman','The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.',now()),
19
(18,'Harry S. Truman','The buck stops here.',now()),
20
(19,'Dwight D. Eisenhower','History does not long entrust the care of freedom to the weak or the timid.',now()),
21
(20,'John F. Kennedy','My fellow Americans, ask not what your country can do for you; ask what you can do for your country.',now()),
22
(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.',now()),
23
(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.',now()),
24
(24,'Richard Nixon','People have got to know whether or not their president is a crook. Well, I\'m not a crook.',now()),
25
(25,'Richard Nixon','When the President does it, that means that it is not illegal.',now()),
26
(26,'Gerald R. Ford','Our Long national nightmare is over.',now()),
27
(27,'Gerald R. Ford','Our constitution works. Our great republic is a government of laws, not of men.',now()),
28
(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.',now()),
29
(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.',now()),
30
(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.',now()),
31
(32,'George H. W. Bush','We have ...drawn a line in the sand.',now()),
32
(33,'George W. Bush','If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.',now()),
33
(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.',now());
34
/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
(-)a/installer/data/mysql/fi-FI/optional/sample_quotes.txt (+1 lines)
Line 0 Link Here
1
Sample quotes
(-)a/installer/data/mysql/fi-FI/optional/sample_z3950_servers.sql (+11 lines)
Line 0 Link Here
1
INSERT INTO z3950servers
2
(host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4
('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5
('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
6
7
#Insert SRU server
8
INSERT INTO z3950servers
9
(host, port, db, servername, syntax, encoding, servertype, sru_fields)
10
VALUES
11
('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/fi-FI/optional/sample_z3950_servers.txt (-1 / +5 lines)
Line 0 Link Here
0
- 
1
Allow access to the following servers to search and download record information:
2
LIBRARY OF CONGRESS
3
LIBRARY OF CONGRESS NAMES (authority records)
4
LIBRARY OF CONGRESS SUBJECTS (authority records)
5
COLUMBIA UNIVERSITY

Return to bug 22471