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

(-)a/installer/data/mysql/en/mandatory/auth_values.sql (-2 / +6 lines)
Lines 1-2 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
1
INSERT
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
2
INTO authorised_values (category, authorised_value, lib, lib_opac)
3
VALUES ('YES_NO', '0', i18n('No'), i18n('No'));
4
INSERT
5
INTO authorised_values (category, authorised_value, lib, lib_opac)
6
VALUES ('YES_NO', '1', i18n('Yes'), i18n('Yes'));
(-)a/installer/data/mysql/en/mandatory/class_sources.sql (-11 / +15 lines)
Lines 20-36 Link Here
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21
21
22
-- class sorting (filing) rules
22
-- class sorting (filing) rules
23
INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES
23
INSERT
24
                               ('dewey', 'Default filing rules for DDC', 'Dewey'),
24
INTO class_sort_rules (class_sort_rule, description, sort_routine)
25
                               ('lcc', 'Default filing rules for LCC', 'LCC'),
25
VALUES
26
                               ('generic', 'Generic call number filing rules', 'Generic');
26
    ('dewey', i18n('Default filing rules for DDC'), 'Dewey'),
27
    ('lcc', i18n('Default filing rules for LCC'), 'LCC'),
28
    ('generic', i18n('Generic call number filing rules'), 'Generic');
27
29
28
30
29
-- classification schemes or sources
31
-- classification schemes or sources
30
INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES
32
INSERT
31
                            ('ddc', 'Dewey Decimal Classification', 1, 'dewey'),
33
INTO class_sources (cn_source, description, used, class_sort_rule)
32
                            ('lcc', 'Library of Congress Classification', 1, 'lcc'),
34
VALUES
33
                            ('udc', 'Universal Decimal Classification', 0, 'generic'),
35
    ('ddc', i18n('Dewey Decimal Classification'), 1, 'dewey'),
34
                            ('sudocs', 'SuDoc Classification (U.S. GPO)', 0, 'generic'),
36
    ('lcc', i18n('Library of Congress Classification'), 1, 'lcc'),
35
                            ('anscr', 'ANSCR (Sound Recordings)', 0, 'generic'),
37
    ('udc', i18n('Universal Decimal Classification'), 0, 'generic'),
36
                            ('z', 'Other/Generic Classification Scheme', 0, 'generic');
38
    ('sudocs', i18n('SuDoc Classification (U.S. GPO)'), 0, 'generic'),
39
    ('anscr', i18n('ANSCR (Sound Recordings)'), 0, 'generic'),
40
    ('z', i18n('Other/Generic Classification Scheme'), 0, 'generic');
(-)a/installer/data/mysql/en/mandatory/message_transport_types.sql (-7 / +7 lines)
Lines 1-7 Link Here
1
INSERT INTO message_transport_types
1
INSERT
2
(message_transport_type)
2
INTO message_transport_types (message_transport_type)
3
values
3
VALUES
4
('email'),
4
    ('email'),
5
('print'),
5
    ('print'),
6
('sms'),
6
    ('sms'),
7
('feed');
7
    ('feed');
(-)a/installer/data/mysql/en/mandatory/sample_notices.sql (-33 / +36 lines)
Lines 1-24 Link Here
1
INSERT INTO `letter` (module, code, name, title, content) 
1
INSERT
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'),
2
INTO letter (module, code, name, title, content)
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>'),
3
VALUES
4
('serial','RLIST','Routing List','Serial 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.'),
4
    ('circulation', 'ODUE', i18n('Overdue Notice'), i18n('Item Overdue'), i18n('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')),
5
('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'), 
5
    ('claimacquisition', 'ACQCLAIM', i18n('Acquisition Claim'), i18n('Item Not Received'), i18n('<<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>')),
6
('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>>)'), 
6
    ('serial', 'RLIST', i18n('Routing List'), i18n('Serial is now available'), i18n('<<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.')),
7
('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due'), 
7
    ('members', 'ACCTDETAILS', i18n('Account Details Template - DEFAULT'), i18n('Your new Koha account details.'), i18n('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')),
8
('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>>)'), 
8
    ('circulation', 'DUE', i18n('Item Due Reminder'), i18n('Item Due Reminder'), i18n('Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)')),
9
('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <<count>> items due soon'),
9
    ('circulation', 'DUEDGST', i18n('Item Due Reminder (Digest)'), i18n('Item Due Reminder'), i18n('You have <<count>> items due')),
10
('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>>.'),
10
    ('circulation', 'PREDUE', i18n('Advance Notice of Item Due'), i18n('Advance Notice of Item Due'), i18n('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>>)')),
11
('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>>'),
11
    ('circulation', 'PREDUEDGST', i18n('Advance Notice of Item Due (Digest)'), i18n('Advance Notice of Item Due'), i18n('You have <<count>> items due soon')),
12
('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', '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'),
12
    ('circulation', 'RENEWAL', i18n('Item Renewals'), i18n('Item Renewals'), i18n('The following items have been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.')),
13
('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.'),
13
    ('reserves', 'HOLD', i18n('Hold Available for Pickup'), i18n('Hold Available for Pickup at <<branches.branchname>>'), i18n('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>>')),
14
('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 <<branches.branchname>>.'),
14
    ('reserves', 'HOLD_PRINT', i18n('Hold Available for Pickup (print notice)'), i18n('Hold Available for Pickup (print notice)'), i18n('<<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')),
15
('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>>).'),
15
    ('circulation', 'CHECKIN', i18n('Item Check-in (Digest)'), i18n('Check-ins'), i18n('The following items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.')),
16
('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>>'),
16
    ('circulation', 'CHECKOUT', i18n('Item Check-out (Digest)'), i18n('Checkouts'), i18n('The following items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.')),
17
('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>>'),
17
    ('reserves', 'HOLDPLACED', i18n('Hold Placed on Item'), i18n('Hold Placed on Item'), i18n('A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).')),
18
('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>>'),
18
    ('suggestions', 'ACCEPTED', i18n('Suggestion accepted'), i18n('Purchase suggestion accepted'), i18n('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>>')),
19
('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>>');
19
    ('suggestions', 'AVAILABLE', i18n('Suggestion available'), i18n('Suggested purchase available'), i18n('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>>')),
20
INSERT INTO `letter` (module, code, name, title, content, is_html)
20
    ('suggestions', 'ORDERED', i18n('Suggestion ordered'), i18n('Suggested item ordered'), i18n('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>>')),
21
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
21
    ('suggestions', 'REJECTED', i18n('Suggestion rejected'), i18n('Purchase suggestion declined'), i18n('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>>'));
22
INSERT
23
INTO letter (module, code, name, title, content, is_html)
24
VALUES
25
    ('circulation', 'ISSUESLIP', i18n('Issue Slip'), i18n('Issue Slip'), i18n('<h3><<branches.branchname>></h3>
22
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
26
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
23
(<<borrowers.cardnumber>>) <br />
27
(<<borrowers.cardnumber>>) <br />
24
28
Lines 52-59 Date due: <<issues.date_due>><br /> Link Here
52
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
56
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
53
<hr />
57
<hr />
54
</div>
58
</div>
55
</news>', 1),
59
</news>'), 1),
56
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
60
    ('circulation', 'ISSUEQSLIP', i18n('Issue Quick Slip'), i18n('Issue Quick Slip'), i18n('<h3><<branches.branchname>></h3>
57
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
61
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
58
(<<borrowers.cardnumber>>) <br />
62
(<<borrowers.cardnumber>>) <br />
59
63
Lines 66-73 Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials> Link Here
66
Barcode: <<items.barcode>><br />
70
Barcode: <<items.barcode>><br />
67
Date due: <<issues.date_due>><br />
71
Date due: <<issues.date_due>><br />
68
</p>
72
</p>
69
</checkedout>', 1),
73
</checkedout>'), 1),
70
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
74
    ('circulation', 'RESERVESLIP', i18n('Reserve Slip'), i18n('Reserve Slip'), i18n('<h5>Date: <<today>></h5>
71
75
72
<h3> Transfer to/Hold in <<branches.branchname>></h3>
76
<h3> Transfer to/Hold in <<branches.branchname>></h3>
73
77
Lines 94-101 Date due: <<issues.date_due>><br /> Link Here
94
<p>Notes:
98
<p>Notes:
95
<pre><<reserves.reservenotes>></pre>
99
<pre><<reserves.reservenotes>></pre>
96
</p>
100
</p>
97
', 1),
101
'), 1),
98
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
102
    ('circulation', 'TRANSFERSLIP', i18n('Transfer Slip'), i18n('Transfer Slip'), i18n('<h5>Date: <<today>></h5>
99
103
100
<h3>Transfer to <<branches.branchname>></h3>
104
<h3>Transfer to <<branches.branchname>></h3>
101
105
Lines 105-119 Date due: <<issues.date_due>><br /> Link Here
105
<ul>
109
<ul>
106
   <li><<items.barcode>></li>
110
   <li><<items.barcode>></li>
107
   <li><<items.itemcallnumber>></li>
111
   <li><<items.itemcallnumber>></li>
108
</ul>', 1);
112
</ul>'), 1);
109
113
110
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
114
INSERT
111
VALUES (
115
INTO letter (module, code, branchcode, name, is_html, title, content)
112
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
116
VALUES ('members', 'OPAC_REG_VERIFY', '', i18n('Opac Self-Registration Verification Email'), '1', i18n('Verify Your Account'), i18n('Hello!
113
117
114
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
118
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
115
119
116
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
120
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
117
121
118
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
122
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'));
119
);
(-)a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql (-8 / +8 lines)
Lines 1-9 Link Here
1
insert into `message_attributes`
1
INSERT
2
(`message_attribute_id`, message_name, `takes_days`)
2
INTO message_attributes (message_attribute_id, message_name, takes_days)
3
values
3
VALUES
4
(1, 'Item_Due', 0),
4
    (1, 'Item_Due', 0),
5
(2, 'Advance_Notice', 1),
5
    (2, 'Advance_Notice', 1),
6
(4, 'Hold_Filled', 0),
6
    (4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
7
    (5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
8
    (6, 'Item_Checkout', 0);
9
9
(-)a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql (-17 / +17 lines)
Lines 1-17 Link Here
1
insert into `message_transports`
1
INSERT
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
2
INTO message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code)
3
values
3
VALUES
4
(1, 'email', 0, 'circulation', 'DUE'),
4
    (1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
    (1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
6
    (2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
7
    (2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
8
    (4, 'email', 0, 'reserves', 'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
9
    (1, 'sms', 0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
10
    (1, 'sms', 1, 'circulation', 'DUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
11
    (2, 'sms', 0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
    (2, 'sms', 1, 'circulation', 'PREDUEDGST'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
13
    (4, 'sms', 0, 'reserves', 'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
14
    (5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
15
    (5, 'sms', 0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
16
    (6, 'email', 0, 'circulation', 'CHECKOUT'),
17
(6, 'sms',   0, 'circulation', 'CHECKOUT');
17
    (6, 'sms', 0, 'circulation', 'CHECKOUT');
(-)a/installer/data/mysql/en/mandatory/stopwords.sql (-99 / +101 lines)
Lines 1-99 Link Here
1
INSERT INTO stopwords VALUES
1
INSERT
2
('a'),
2
INTO stopwords (word)
3
('about'),
3
VALUES
4
('also'),
4
    (i18n('a')),
5
('an'),
5
    (i18n('about')),
6
('and'),
6
    (i18n('also')),
7
('another'),
7
    (i18n('an')),
8
('any'),
8
    (i18n('and')),
9
('are'),
9
    (i18n('another')),
10
('as'),
10
    (i18n('any')),
11
('at'),
11
    (i18n('are')),
12
('back'),
12
    (i18n('as')),
13
('be'),
13
    (i18n('at')),
14
('because'),
14
    (i18n('back')),
15
('been'),
15
    (i18n('be')),
16
('being'),
16
    (i18n('because')),
17
('but'),
17
    (i18n('been')),
18
('by'),
18
    (i18n('being')),
19
('can'),
19
    (i18n('but')),
20
('could'),
20
    (i18n('by')),
21
('did'),
21
    (i18n('can')),
22
('do'),
22
    (i18n('could')),
23
('each'),
23
    (i18n('did')),
24
('end'),
24
    (i18n('do')),
25
('even'),
25
    (i18n('each')),
26
('for'),
26
    (i18n('end')),
27
('from'),
27
    (i18n('even')),
28
('get'),
28
    (i18n('for')),
29
('go'),
29
    (i18n('from')),
30
('had'),
30
    (i18n('get')),
31
('have'),
31
    (i18n('go')),
32
('he'),
32
    (i18n('had')),
33
('her'),
33
    (i18n('have')),
34
('here'),
34
    (i18n('he')),
35
('his'),
35
    (i18n('her')),
36
('how'),
36
    (i18n('here')),
37
('i'),
37
    (i18n('his')),
38
('if'),
38
    (i18n('how')),
39
('in'),
39
    (i18n('i')),
40
('into'),
40
    (i18n('if')),
41
('is'),
41
    (i18n('in')),
42
('it'),
42
    (i18n('into')),
43
('just'),
43
    (i18n('is')),
44
('may'),
44
    (i18n('it')),
45
('me'),
45
    (i18n('just')),
46
('might'),
46
    (i18n('may')),
47
('much'),
47
    (i18n('me')),
48
('must'),
48
    (i18n('might')),
49
('my'),
49
    (i18n('much')),
50
('no'),
50
    (i18n('must')),
51
('not'),
51
    (i18n('my')),
52
('of'),
52
    (i18n('no')),
53
('off'),
53
    (i18n('not')),
54
('on'),
54
    (i18n('of')),
55
('only'),
55
    (i18n('off')),
56
('or'),
56
    (i18n('on')),
57
('other'),
57
    (i18n('only')),
58
('our'),
58
    (i18n('or')),
59
('out'),
59
    (i18n('other')),
60
('should'),
60
    (i18n('our')),
61
('so'),
61
    (i18n('out')),
62
('some'),
62
    (i18n('should')),
63
('still'),
63
    (i18n('so')),
64
('such'),
64
    (i18n('some')),
65
('than'),
65
    (i18n('still')),
66
('that'),
66
    (i18n('such')),
67
('the'),
67
    (i18n('than')),
68
('their'),
68
    (i18n('that')),
69
('them'),
69
    (i18n('the')),
70
('then'),
70
    (i18n('their')),
71
('there'),
71
    (i18n('them')),
72
('these'),
72
    (i18n('then')),
73
('they'),
73
    (i18n('there')),
74
('this'),
74
    (i18n('these')),
75
('those'),
75
    (i18n('they')),
76
('to'),
76
    (i18n('this')),
77
('too'),
77
    (i18n('those')),
78
('try'),
78
    (i18n('to')),
79
('two'),
79
    (i18n('too')),
80
('under'),
80
    (i18n('try')),
81
('up'),
81
    (i18n('two')),
82
('us'),
82
    (i18n('under')),
83
('was'),
83
    (i18n('up')),
84
('we'),
84
    (i18n('us')),
85
('were'),
85
    (i18n('was')),
86
('what'),
86
    (i18n('we')),
87
('when'),
87
    (i18n('were')),
88
('where'),
88
    (i18n('what')),
89
('which'),
89
    (i18n('when')),
90
('while'),
90
    (i18n('where')),
91
('who'),
91
    (i18n('which')),
92
('why'),
92
    (i18n('while')),
93
('will'),
93
    (i18n('who')),
94
('with'),
94
    (i18n('why')),
95
('within'),
95
    (i18n('will')),
96
('without'),
96
    (i18n('with')),
97
('would'),
97
    (i18n('within')),
98
('you'),
98
    (i18n('without')),
99
('your');
99
    (i18n('would')),
100
    (i18n('you')),
101
    (i18n('your'));
(-)a/installer/data/mysql/en/mandatory/subtag_registry.sql (-554 / +831 lines)
Lines 1-897 Link Here
1
-- http://www.w3.org/International/articles/language-tags/
1
-- http://www.w3.org/International/articles/language-tags/
2
2
3
-- BIDI Stuff, Arabic and Hebrew
3
-- BIDI Stuff, Arabic and Hebrew
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
4
INSERT
5
VALUES( 'Arab', 'rtl');
5
INTO language_script_bidi (rfc4646_subtag, bidi)
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
6
VALUES ('Arab', 'rtl');
7
VALUES( 'Hebr', 'rtl');
7
INSERT
8
INTO language_script_bidi (rfc4646_subtag, bidi)
9
VALUES ('Hebr', 'rtl');
8
10
9
-- Default mappings between script and language subcodes
11
-- Default mappings between script and language subcodes
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
12
INSERT
11
VALUES( 'ar', 'Arab');
13
INTO language_script_mapping (language_subtag, script_subtag)
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
14
VALUES ('ar', 'Arab');
13
VALUES( 'he', 'Hebr');
15
INSERT
16
INTO language_script_mapping (language_subtag, script_subtag)
17
VALUES ('he', 'Hebr');
14
18
15
-- EXTENSIONS
19
-- EXTENSIONS
16
-- Interface (i)
20
-- Interface (i)
17
-- SELECT * FROM language_subtag_registry WHERE type='i';
21
-- SELECT * FROM language_subtag_registry WHERE type='i';
18
-- OPAC
22
-- OPAC
19
INSERT INTO language_subtag_registry( subtag, type, description, added)
23
INSERT
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
24
INTO language_subtag_registry (subtag, type, description, added)
25
VALUES ('opac', 'i', 'OPAC', '2005-10-16');
21
26
22
INSERT INTO language_descriptions(subtag, type, lang, description)
27
INSERT
23
VALUES( 'opac', 'i', 'en', 'OPAC');
28
INTO language_descriptions (subtag, type, lang, description)
29
VALUES ('opac', 'i', 'en', 'OPAC');
24
30
25
INSERT INTO language_descriptions(subtag, type, lang, description)
31
INSERT
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
32
INTO language_descriptions (subtag, type, lang, description)
33
VALUES ('opac', 'i', 'fr', 'OPAC');
27
34
28
-- Staff Client
35
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
36
INSERT
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
37
INTO language_subtag_registry (subtag, type, description, added)
38
VALUES ('intranet', 'i', 'Staff Client', '2005-10-16');
31
39
32
INSERT INTO language_descriptions(subtag, type, lang, description)
40
INSERT
33
VALUES( 'intranet', 'i', 'en', 'Staff Client');
41
INTO language_descriptions (subtag, type, lang, description)
42
VALUES ('intranet', 'i', 'en', 'Staff Client');
34
43
35
INSERT INTO language_descriptions(subtag, type, lang, description)
44
INSERT
36
VALUES( 'intranet', 'i', 'fr', '????');
45
INTO language_descriptions (subtag, type, lang, description)
46
VALUES ('intranet', 'i', 'fr', '????');
37
47
38
-- Theme (t)
48
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
49
INSERT
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
50
INTO language_subtag_registry (subtag, type, description, added)
51
VALUES ('prog', 't', 'Prog', '2005-10-16');
41
52
42
INSERT INTO language_descriptions(subtag, type, lang, description)
53
INSERT
43
VALUES( 'prog', 't', 'en', 'Prog');
54
INTO language_descriptions (subtag, type, lang, description)
55
VALUES ('prog', 't', 'en', 'Prog');
44
56
45
INSERT INTO language_descriptions(subtag, type, lang, description)
57
INSERT
46
VALUES( 'prog', 't', 'fr', 'Prog');
58
INTO language_descriptions (subtag, type, lang, description)
59
VALUES ('prog', 't', 'fr', 'Prog');
47
60
48
-- LANGUAGES
61
-- LANGUAGES
49
62
50
-- Arabic
63
-- Arabic
51
INSERT INTO language_subtag_registry( subtag, type, description, added)
64
INSERT
52
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
65
INTO language_subtag_registry (subtag, type, description, added)
66
VALUES ('ar', 'language', 'Arabic', '2005-10-16');
53
67
54
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
68
INSERT
55
VALUES( 'ar','ara');
69
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
70
VALUES ('ar', 'ara');
56
71
57
INSERT INTO language_descriptions(subtag, type, lang, description)
72
INSERT
58
VALUES ( 'ar', 'language', 'ar', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
73
INTO language_descriptions (subtag, type, lang, description)
74
VALUES ('ar', 'language', 'ar', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
59
75
60
INSERT INTO language_descriptions(subtag, type, lang, description)
76
INSERT
61
VALUES( 'ar', 'language', 'en', 'Arabic');
77
INTO language_descriptions (subtag, type, lang, description)
78
VALUES ('ar', 'language', 'en', 'Arabic');
62
79
63
INSERT INTO language_descriptions(subtag, type, lang, description)
80
INSERT
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
81
INTO language_descriptions (subtag, type, lang, description)
82
VALUES ('ar', 'language', 'fr', 'Arabe');
65
83
66
INSERT INTO language_descriptions(subtag, type, lang, description)
84
INSERT
67
VALUES( 'ar', 'language', 'de', 'Arabisch');
85
INTO language_descriptions (subtag, type, lang, description)
86
VALUES ('ar', 'language', 'de', 'Arabisch');
68
87
69
-- Armenian
88
-- Armenian
70
INSERT INTO language_subtag_registry( subtag, type, description, added)
89
INSERT
71
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
90
INTO language_subtag_registry (subtag, type, description, added)
91
VALUES ('hy', 'language', 'Armenian', '2005-10-16');
72
92
73
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
93
INSERT
74
VALUES( 'hy','arm');
94
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
95
VALUES ('hy', 'arm');
75
96
76
INSERT INTO language_descriptions(subtag, type, lang, description)
97
INSERT
77
VALUES ( 'hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
98
INTO language_descriptions (subtag, type, lang, description)
99
VALUES ('hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
78
100
79
INSERT INTO language_descriptions(subtag, type, lang, description)
101
INSERT
80
VALUES( 'hy', 'language', 'en', 'Armenian');
102
INTO language_descriptions (subtag, type, lang, description)
103
VALUES ('hy', 'language', 'en', 'Armenian');
81
104
82
INSERT INTO language_descriptions(subtag, type, lang, description)
105
INSERT
83
VALUES( 'hy', 'language', 'fr', 'Armenian');
106
INTO language_descriptions (subtag, type, lang, description)
107
VALUES ('hy', 'language', 'fr', 'Armenian');
84
108
85
INSERT INTO language_descriptions(subtag, type, lang, description)
109
INSERT
86
VALUES( 'hy', 'language', 'de', 'Armenisch');
110
INTO language_descriptions (subtag, type, lang, description)
111
VALUES ('hy', 'language', 'de', 'Armenisch');
87
112
88
-- Bulgarian
113
-- Bulgarian
89
INSERT INTO language_subtag_registry( subtag, type, description, added)
114
INSERT
90
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
115
INTO language_subtag_registry (subtag, type, description, added)
116
VALUES ('bg', 'language', 'Bulgarian', '2005-10-16');
91
117
92
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
118
INSERT
93
VALUES( 'bg','bul');
119
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
120
VALUES ('bg', 'bul');
94
121
95
INSERT INTO language_descriptions(subtag, type, lang, description)
122
INSERT
96
VALUES ( 'bg', 'language', 'bg', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;');
123
INTO language_descriptions (subtag, type, lang, description)
124
VALUES ('bg', 'language', 'bg', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;');
97
125
98
INSERT INTO language_descriptions(subtag, type, lang, description)
126
INSERT
99
VALUES( 'bg', 'language', 'en', 'Bulgarian');
127
INTO language_descriptions (subtag, type, lang, description)
128
VALUES ('bg', 'language', 'en', 'Bulgarian');
100
129
101
INSERT INTO language_descriptions(subtag, type, lang, description)
130
INSERT
102
VALUES( 'bg', 'language', 'fr', 'Bulgare');
131
INTO language_descriptions (subtag, type, lang, description)
132
VALUES ('bg', 'language', 'fr', 'Bulgare');
103
133
104
INSERT INTO language_descriptions(subtag, type, lang, description)
134
INSERT
105
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
135
INTO language_descriptions (subtag, type, lang, description)
136
VALUES ('bg', 'language', 'de', 'Bulgarisch');
106
137
107
-- Chinese
138
-- Chinese
108
INSERT INTO language_subtag_registry( subtag, type, description, added)
139
INSERT
109
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
140
INTO language_subtag_registry (subtag, type, description, added)
141
VALUES ('zh', 'language', 'Chinese', '2005-10-16');
110
142
111
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
143
INSERT
112
VALUES( 'zh','chi');
144
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
145
VALUES ('zh', 'chi');
113
146
114
INSERT INTO language_descriptions(subtag, type, lang, description)
147
INSERT
115
VALUES ( 'zh', 'language', 'zh', '&#20013;&#25991;');
148
INTO language_descriptions (subtag, type, lang, description)
149
VALUES ('zh', 'language', 'zh', '&#20013;&#25991;');
116
150
117
INSERT INTO language_descriptions(subtag, type, lang, description)
151
INSERT
118
VALUES( 'zh', 'language', 'en', 'Chinese');
152
INTO language_descriptions (subtag, type, lang, description)
153
VALUES ('zh', 'language', 'en', 'Chinese');
119
154
120
INSERT INTO language_descriptions(subtag, type, lang, description)
155
INSERT
121
VALUES( 'zh', 'language', 'fr', 'Chinois');
156
INTO language_descriptions (subtag, type, lang, description)
157
VALUES ('zh', 'language', 'fr', 'Chinois');
122
158
123
INSERT INTO language_descriptions(subtag, type, lang, description)
159
INSERT
124
VALUES( 'zh', 'language', 'de', 'Chinesisch');
160
INTO language_descriptions (subtag, type, lang, description)
161
VALUES ('zh', 'language', 'de', 'Chinesisch');
125
162
126
-- Czech
163
-- Czech
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
INSERT
128
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
165
INTO language_subtag_registry (subtag, type, description, added)
166
VALUES ('cs', 'language', 'Czech', '2005-10-16');
129
167
130
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
168
INSERT
131
VALUES( 'cs','cze');
169
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
170
VALUES ('cs', 'cze');
132
171
133
INSERT INTO language_descriptions(subtag, type, lang, description)
172
INSERT
134
VALUES ( 'cs', 'language', 'cs', '&#x010D;e&#353;tina');
173
INTO language_descriptions (subtag, type, lang, description)
174
VALUES ('cs', 'language', 'cs', '&#x010D;e&#353;tina');
135
175
136
INSERT INTO language_descriptions(subtag, type, lang, description)
176
INSERT
137
VALUES( 'cs', 'language', 'en', 'Czech');
177
INTO language_descriptions (subtag, type, lang, description)
178
VALUES ('cs', 'language', 'en', 'Czech');
138
179
139
INSERT INTO language_descriptions(subtag, type, lang, description)
180
INSERT
140
VALUES( 'cs', 'language', 'fr', 'Tchèque');
181
INTO language_descriptions (subtag, type, lang, description)
182
VALUES ('cs', 'language', 'fr', 'Tchèque');
141
183
142
INSERT INTO language_descriptions(subtag, type, lang, description)
184
INSERT
143
VALUES( 'cs', 'language', 'de', 'Tschechisch');
185
INTO language_descriptions (subtag, type, lang, description)
186
VALUES ('cs', 'language', 'de', 'Tschechisch');
144
187
145
-- Danish
188
-- Danish
146
INSERT INTO language_subtag_registry( subtag, type, description, added)
189
INSERT
147
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
190
INTO language_subtag_registry (subtag, type, description, added)
191
VALUES ('da', 'language', 'Danish', '2005-10-16');
148
192
149
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
193
INSERT
150
VALUES( 'da','dan');
194
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
195
VALUES ('da', 'dan');
151
196
152
INSERT INTO language_descriptions(subtag, type, lang, description)
197
INSERT
153
VALUES ( 'da', 'language', 'da', 'Dansk');
198
INTO language_descriptions (subtag, type, lang, description)
199
VALUES ('da', 'language', 'da', 'Dansk');
154
200
155
INSERT INTO language_descriptions(subtag, type, lang, description)
201
INSERT
156
VALUES( 'da', 'language', 'en', 'Danish');
202
INTO language_descriptions (subtag, type, lang, description)
203
VALUES ('da', 'language', 'en', 'Danish');
157
204
158
INSERT INTO language_descriptions(subtag, type, lang, description)
205
INSERT
159
VALUES( 'da', 'language', 'fr', 'Danois');
206
INTO language_descriptions (subtag, type, lang, description)
207
VALUES ('da', 'language', 'fr', 'Danois');
160
208
161
INSERT INTO language_descriptions(subtag, type, lang, description)
209
INSERT
162
VALUES( 'da', 'language', 'de', 'Dänisch');
210
INTO language_descriptions (subtag, type, lang, description)
211
VALUES ('da', 'language', 'de', 'Dänisch');
163
212
164
-- Dutch, Flemish
213
-- Dutch, Flemish
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
214
INSERT
166
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
215
INTO language_subtag_registry (subtag, type, description, added)
216
VALUES ('nl', 'language', 'Dutch', '2005-10-16');
167
217
168
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
218
INSERT
169
VALUES( 'nl','dut');
219
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
220
VALUES ('nl', 'dut');
170
221
171
INSERT INTO language_descriptions(subtag, type, lang, description)
222
INSERT
172
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
223
INTO language_descriptions (subtag, type, lang, description)
224
VALUES ('nl', 'language', 'nl', 'Nederlands');
173
225
174
INSERT INTO language_descriptions(subtag, type, lang, description)
226
INSERT
175
VALUES( 'nl', 'language', 'en', 'Dutch');
227
INTO language_descriptions (subtag, type, lang, description)
228
VALUES ('nl', 'language', 'en', 'Dutch');
176
229
177
INSERT INTO language_descriptions(subtag, type, lang, description)
230
INSERT
178
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
231
INTO language_descriptions (subtag, type, lang, description)
232
VALUES ('nl', 'language', 'fr', 'Néerlandais');
179
233
180
INSERT INTO language_descriptions(subtag, type, lang, description)
234
INSERT
181
VALUES( 'nl', 'language', 'de', 'Niederländisch');
235
INTO language_descriptions (subtag, type, lang, description)
236
VALUES ('nl', 'language', 'de', 'Niederländisch');
182
237
183
-- English
238
-- English
184
INSERT INTO language_subtag_registry( subtag, type, description, added)
239
INSERT
185
VALUES ( 'en', 'language', 'English','2005-10-16' );
240
INTO language_subtag_registry (subtag, type, description, added)
241
VALUES ('en', 'language', 'English', '2005-10-16');
186
242
187
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
243
INSERT
188
VALUES( 'en','eng');
244
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
245
VALUES ('en', 'eng');
189
246
190
INSERT INTO language_descriptions(subtag, type, lang, description)
247
INSERT
191
VALUES( 'en', 'language', 'en', 'English');
248
INTO language_descriptions (subtag, type, lang, description)
249
VALUES ('en', 'language', 'en', 'English');
192
250
193
INSERT INTO language_descriptions(subtag, type, lang, description)
251
INSERT
194
VALUES( 'en', 'language', 'fr', 'Anglais');
252
INTO language_descriptions (subtag, type, lang, description)
253
VALUES ('en', 'language', 'fr', 'Anglais');
195
254
196
INSERT INTO language_descriptions(subtag, type, lang, description)
255
INSERT
197
VALUES( 'en', 'language', 'de', 'Englisch');
256
INTO language_descriptions (subtag, type, lang, description)
257
VALUES ('en', 'language', 'de', 'Englisch');
198
258
199
-- Finnish
259
-- Finnish
200
INSERT INTO language_subtag_registry( subtag, type, description, added)
260
INSERT
201
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
261
INTO language_subtag_registry (subtag, type, description, added)
262
VALUES ('fi', 'language', 'Finnish', '2005-10-16');
202
263
203
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
264
INSERT
204
VALUES( 'fi','fin');
265
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
266
VALUES ('fi', 'fin');
205
267
206
INSERT INTO language_descriptions(subtag, type, lang, description)
268
INSERT
207
VALUES( 'fi', 'language', 'fi', 'suomi');
269
INTO language_descriptions (subtag, type, lang, description)
270
VALUES ('fi', 'language', 'fi', 'suomi');
208
271
209
INSERT INTO language_descriptions(subtag, type, lang, description)
272
INSERT
210
VALUES( 'fi', 'language', 'en', 'Finnish');
273
INTO language_descriptions (subtag, type, lang, description)
274
VALUES ('fi', 'language', 'en', 'Finnish');
211
275
212
INSERT INTO language_descriptions(subtag, type, lang, description)
276
INSERT
213
VALUES( 'fi', 'language', 'de', 'Finnisch');
277
INTO language_descriptions (subtag, type, lang, description)
278
VALUES ('fi', 'language', 'de', 'Finnisch');
214
279
215
-- French
280
-- French
216
INSERT INTO language_subtag_registry( subtag, type, description, added)
281
INSERT
217
VALUES ( 'fr', 'language', 'French','2005-10-16' );
282
INTO language_subtag_registry (subtag, type, description, added)
283
VALUES ('fr', 'language', 'French', '2005-10-16');
218
284
219
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
285
INSERT
220
VALUES( 'fr','fre');
286
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
287
VALUES ('fr', 'fre');
221
288
222
INSERT INTO language_descriptions(subtag, type, lang, description)
289
INSERT
223
VALUES( 'fr', 'language', 'en', 'French');
290
INTO language_descriptions (subtag, type, lang, description)
291
VALUES ('fr', 'language', 'en', 'French');
224
292
225
INSERT INTO language_descriptions(subtag, type, lang, description)
293
INSERT
226
VALUES( 'fr', 'language', 'fr', 'Fran&ccedil;ais');
294
INTO language_descriptions (subtag, type, lang, description)
295
VALUES ('fr', 'language', 'fr', 'Fran&ccedil;ais');
227
296
228
INSERT INTO language_descriptions(subtag, type, lang, description)
297
INSERT
229
VALUES( 'fr', 'language', 'de', 'Französisch');
298
INTO language_descriptions (subtag, type, lang, description)
299
VALUES ('fr', 'language', 'de', 'Französisch');
230
300
231
-- INSERT INTO language_descriptions(subtag, type, lang, description)
301
-- INSERT INTO language_descriptions(subtag, type, lang, description)
232
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'fran&ccedil;ais');
302
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'fran&ccedil;ais');
233
303
234
-- Lao
304
-- Lao
235
INSERT INTO language_subtag_registry( subtag, type, description, added)
305
INSERT
236
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
306
INTO language_subtag_registry (subtag, type, description, added)
307
VALUES ('lo', 'language', 'Lao', '2005-10-16');
237
308
238
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
309
INSERT
239
VALUES( 'lo','lao');
310
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
311
VALUES ('lo', 'lao');
240
312
241
INSERT INTO language_descriptions(subtag, type, lang, description)
313
INSERT
242
VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
314
INTO language_descriptions (subtag, type, lang, description)
315
VALUES ('lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
243
316
244
INSERT INTO language_descriptions(subtag, type, lang, description)
317
INSERT
245
VALUES( 'lo', 'language', 'en', 'Lao');
318
INTO language_descriptions (subtag, type, lang, description)
319
VALUES ('lo', 'language', 'en', 'Lao');
246
320
247
INSERT INTO language_descriptions(subtag, type, lang, description)
321
INSERT
248
VALUES( 'lo', 'language', 'fr', 'Laotien');
322
INTO language_descriptions (subtag, type, lang, description)
323
VALUES ('lo', 'language', 'fr', 'Laotien');
249
324
250
INSERT INTO language_descriptions(subtag, type, lang, description)
325
INSERT
251
VALUES( 'lo', 'language', 'de', 'Laotisch');
326
INTO language_descriptions (subtag, type, lang, description)
327
VALUES ('lo', 'language', 'de', 'Laotisch');
252
328
253
-- German
329
-- German
254
INSERT INTO language_subtag_registry( subtag, type, description, added)
330
INSERT
255
VALUES ( 'de', 'language', 'German','2005-10-16' );
331
INTO language_subtag_registry (subtag, type, description, added)
332
VALUES ('de', 'language', 'German', '2005-10-16');
256
333
257
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
334
INSERT
258
VALUES( 'de','ger');
335
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
336
VALUES ('de', 'ger');
259
337
260
INSERT INTO language_descriptions(subtag, type, lang, description)
338
INSERT
261
VALUES( 'de', 'language', 'de', 'Deutsch');
339
INTO language_descriptions (subtag, type, lang, description)
340
VALUES ('de', 'language', 'de', 'Deutsch');
262
341
263
INSERT INTO language_descriptions(subtag, type, lang, description)
342
INSERT
264
VALUES( 'de', 'language', 'en', 'German');
343
INTO language_descriptions (subtag, type, lang, description)
344
VALUES ('de', 'language', 'en', 'German');
265
345
266
INSERT INTO language_descriptions(subtag, type, lang, description)
346
INSERT
267
VALUES( 'de', 'language', 'fr', 'Allemand');
347
INTO language_descriptions (subtag, type, lang, description)
348
VALUES ('de', 'language', 'fr', 'Allemand');
268
349
269
-- Greek
350
-- Greek
270
INSERT INTO language_subtag_registry( subtag, type, description, added)
351
INSERT
271
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
352
INTO language_subtag_registry (subtag, type, description, added)
353
VALUES ('el', 'language', 'Greek, Modern [1453- ]', '2005-10-16');
272
354
273
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
355
INSERT
274
VALUES( 'el','gre');
356
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
357
VALUES ('el', 'gre');
275
358
276
INSERT INTO language_descriptions(subtag, type, lang, description)
359
INSERT
277
VALUES( 'el', 'language', 'el', '&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;');
360
INTO language_descriptions (subtag, type, lang, description)
361
VALUES ('el', 'language', 'el', '&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;');
278
362
279
INSERT INTO language_descriptions(subtag, type, lang, description)
363
INSERT
280
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
364
INTO language_descriptions (subtag, type, lang, description)
365
VALUES ('el', 'language', 'en', 'Greek, Modern [1453- ]');
281
366
282
INSERT INTO language_descriptions(subtag, type, lang, description)
367
INSERT
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
368
INTO language_descriptions (subtag, type, lang, description)
369
VALUES ('el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
370
285
INSERT INTO language_descriptions(subtag, type, lang, description)
371
INSERT
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
372
INTO language_descriptions (subtag, type, lang, description)
373
VALUES ('el', 'language', 'de', 'Griechisch (Nach 1453)');
287
374
288
-- Hebrew
375
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
376
INSERT
290
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
377
INTO language_subtag_registry (subtag, type, description, added)
378
VALUES ('he', 'language', 'Hebrew', '2005-10-16');
291
379
292
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
380
INSERT
293
VALUES( 'he','heb');
381
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
382
VALUES ('he', 'heb');
294
383
295
INSERT INTO language_descriptions(subtag, type, lang, description)
384
INSERT
296
VALUES( 'he', 'language', 'he', '&#1506;&#1489;&#1512;&#1497;&#1514;');
385
INTO language_descriptions (subtag, type, lang, description)
386
VALUES ('he', 'language', 'he', '&#1506;&#1489;&#1512;&#1497;&#1514;');
297
387
298
INSERT INTO language_descriptions(subtag, type, lang, description)
388
INSERT
299
VALUES( 'he', 'language', 'en', 'Hebrew');
389
INTO language_descriptions (subtag, type, lang, description)
390
VALUES ('he', 'language', 'en', 'Hebrew');
300
391
301
INSERT INTO language_descriptions(subtag, type, lang, description)
392
INSERT
302
VALUES( 'he', 'language', 'fr', 'Hébreu');
393
INTO language_descriptions (subtag, type, lang, description)
394
VALUES ('he', 'language', 'fr', 'Hébreu');
303
395
304
INSERT INTO language_descriptions(subtag, type, lang, description)
396
INSERT
305
VALUES( 'he', 'language', 'de', 'Hebräisch');
397
INTO language_descriptions (subtag, type, lang, description)
398
VALUES ('he', 'language', 'de', 'Hebräisch');
306
399
307
-- Hindi
400
-- Hindi
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
401
INSERT
309
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
402
INTO language_subtag_registry (subtag, type, description, added)
403
VALUES ('hi', 'language', 'Hindi', '2005-10-16');
310
404
311
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
405
INSERT
312
VALUES( 'hi','hin');
406
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
407
VALUES ('hi', 'hin');
313
408
314
INSERT INTO language_descriptions(subtag, type, lang, description)
409
INSERT
315
VALUES( 'hi', 'language', 'hi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;');
410
INTO language_descriptions (subtag, type, lang, description)
411
VALUES ('hi', 'language', 'hi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;');
316
412
317
INSERT INTO language_descriptions(subtag, type, lang, description)
413
INSERT
318
VALUES( 'hi', 'language', 'en', 'Hindi');
414
INTO language_descriptions (subtag, type, lang, description)
415
VALUES ('hi', 'language', 'en', 'Hindi');
319
416
320
INSERT INTO language_descriptions(subtag, type, lang, description)
417
INSERT
321
VALUES( 'hi', 'language', 'fr', 'Hindi');
418
INTO language_descriptions (subtag, type, lang, description)
419
VALUES ('hi', 'language', 'fr', 'Hindi');
322
420
323
INSERT INTO language_descriptions(subtag, type, lang, description)
421
INSERT
324
VALUES( 'hi', 'language', 'de', 'Hindi');
422
INTO language_descriptions (subtag, type, lang, description)
423
VALUES ('hi', 'language', 'de', 'Hindi');
325
424
326
-- Hungarian
425
-- Hungarian
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
426
INSERT
328
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
427
INTO language_subtag_registry (subtag, type, description, added)
428
VALUES ('hu', 'language', 'Hungarian', '2005-10-16');
329
429
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
430
INSERT
331
VALUES( 'hu','hun');
431
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
432
VALUES ('hu', 'hun');
332
433
333
INSERT INTO language_descriptions(subtag, type, lang, description)
434
INSERT
334
VALUES( 'hu', 'language', 'hu', 'Magyar');
435
INTO language_descriptions (subtag, type, lang, description)
436
VALUES ('hu', 'language', 'hu', 'Magyar');
335
437
336
INSERT INTO language_descriptions(subtag, type, lang, description)
438
INSERT
337
VALUES( 'hu', 'language', 'en', 'Hungarian');
439
INTO language_descriptions (subtag, type, lang, description)
440
VALUES ('hu', 'language', 'en', 'Hungarian');
338
441
339
INSERT INTO language_descriptions(subtag, type, lang, description)
442
INSERT
340
VALUES( 'hu', 'language', 'fr', 'Hongrois');
443
INTO language_descriptions (subtag, type, lang, description)
444
VALUES ('hu', 'language', 'fr', 'Hongrois');
341
445
342
INSERT INTO language_descriptions(subtag, type, lang, description)
446
INSERT
343
VALUES( 'hu', 'language', 'de', 'Ungarisch');
447
INTO language_descriptions (subtag, type, lang, description)
448
VALUES ('hu', 'language', 'de', 'Ungarisch');
344
449
345
-- Indonesian
450
-- Indonesian
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
451
INSERT
347
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
452
INTO language_subtag_registry (subtag, type, description, added)
453
VALUES ('id', 'language', 'Indonesian', '2005-10-16');
348
454
349
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
455
INSERT
350
VALUES( 'id','ind');
456
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
457
VALUES ('id', 'ind');
351
458
352
INSERT INTO language_descriptions(subtag, type, lang, description)
459
INSERT
353
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
460
INTO language_descriptions (subtag, type, lang, description)
461
VALUES ('id', 'language', 'id', 'Bahasa Indonesia');
354
462
355
INSERT INTO language_descriptions(subtag, type, lang, description)
463
INSERT
356
VALUES( 'id', 'language', 'en', 'Indonesian');
464
INTO language_descriptions (subtag, type, lang, description)
465
VALUES ('id', 'language', 'en', 'Indonesian');
357
466
358
INSERT INTO language_descriptions(subtag, type, lang, description)
467
INSERT
359
VALUES( 'id', 'language', 'fr', 'Indonésien');
468
INTO language_descriptions (subtag, type, lang, description)
469
VALUES ('id', 'language', 'fr', 'Indonésien');
360
470
361
INSERT INTO language_descriptions(subtag, type, lang, description)
471
INSERT
362
VALUES( 'id', 'language', 'de', 'Indonesisch');
472
INTO language_descriptions (subtag, type, lang, description)
473
VALUES ('id', 'language', 'de', 'Indonesisch');
363
474
364
-- Italian
475
-- Italian
365
INSERT INTO language_subtag_registry( subtag, type, description, added)
476
INSERT
366
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
477
INTO language_subtag_registry (subtag, type, description, added)
478
VALUES ('it', 'language', 'Italian', '2005-10-16');
367
479
368
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
480
INSERT
369
VALUES( 'it','ita');
481
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
482
VALUES ('it', 'ita');
370
483
371
INSERT INTO language_descriptions(subtag, type, lang, description)
484
INSERT
372
VALUES( 'it', 'language', 'it', 'Italiano');
485
INTO language_descriptions (subtag, type, lang, description)
486
VALUES ('it', 'language', 'it', 'Italiano');
373
487
374
INSERT INTO language_descriptions(subtag, type, lang, description)
488
INSERT
375
VALUES( 'it', 'language', 'en', 'Italian');
489
INTO language_descriptions (subtag, type, lang, description)
490
VALUES ('it', 'language', 'en', 'Italian');
376
491
377
INSERT INTO language_descriptions(subtag, type, lang, description)
492
INSERT
378
VALUES( 'it', 'language', 'fr', 'Italien');
493
INTO language_descriptions (subtag, type, lang, description)
494
VALUES ('it', 'language', 'fr', 'Italien');
379
495
380
INSERT INTO language_descriptions(subtag, type, lang, description)
496
INSERT
381
VALUES( 'it', 'language', 'de', 'Italienisch');
497
INTO language_descriptions (subtag, type, lang, description)
498
VALUES ('it', 'language', 'de', 'Italienisch');
382
499
383
-- Japanese
500
-- Japanese
384
INSERT INTO language_subtag_registry( subtag, type, description, added)
501
INSERT
385
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
502
INTO language_subtag_registry (subtag, type, description, added)
503
VALUES ('ja', 'language', 'Japanese', '2005-10-16');
386
504
387
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
505
INSERT
388
VALUES( 'ja','jpn');
506
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
507
VALUES ('ja', 'jpn');
389
508
390
INSERT INTO language_descriptions(subtag, type, lang, description)
509
INSERT
391
VALUES( 'ja', 'language', 'ja', '&#26085;&#26412;&#35486;');
510
INTO language_descriptions (subtag, type, lang, description)
511
VALUES ('ja', 'language', 'ja', '&#26085;&#26412;&#35486;');
392
512
393
INSERT INTO language_descriptions(subtag, type, lang, description)
513
INSERT
394
VALUES( 'ja', 'language', 'en', 'Japanese');
514
INTO language_descriptions (subtag, type, lang, description)
515
VALUES ('ja', 'language', 'en', 'Japanese');
395
516
396
INSERT INTO language_descriptions(subtag, type, lang, description)
517
INSERT
397
VALUES( 'ja', 'language', 'fr', 'Japonais');
518
INTO language_descriptions (subtag, type, lang, description)
519
VALUES ('ja', 'language', 'fr', 'Japonais');
398
520
399
INSERT INTO language_descriptions(subtag, type, lang, description)
521
INSERT
400
VALUES( 'ja', 'language', 'de', 'Japanisch');
522
INTO language_descriptions (subtag, type, lang, description)
523
VALUES ('ja', 'language', 'de', 'Japanisch');
401
524
402
-- Korean
525
-- Korean
403
INSERT INTO language_subtag_registry( subtag, type, description, added)
526
INSERT
404
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
527
INTO language_subtag_registry (subtag, type, description, added)
528
VALUES ('ko', 'language', 'Korean', '2005-10-16');
405
529
406
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
530
INSERT
407
VALUES( 'ko','kor');
531
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
532
VALUES ('ko', 'kor');
408
533
409
INSERT INTO language_descriptions(subtag, type, lang, description)
534
INSERT
410
VALUES( 'ko', 'language', 'ko', '&#54620;&#44397;&#50612;');
535
INTO language_descriptions (subtag, type, lang, description)
536
VALUES ('ko', 'language', 'ko', '&#54620;&#44397;&#50612;');
411
537
412
INSERT INTO language_descriptions(subtag, type, lang, description)
538
INSERT
413
VALUES( 'ko', 'language', 'en', 'Korean');
539
INTO language_descriptions (subtag, type, lang, description)
540
VALUES ('ko', 'language', 'en', 'Korean');
414
541
415
INSERT INTO language_descriptions(subtag, type, lang, description)
542
INSERT
416
VALUES( 'ko', 'language', 'fr', 'Coréen');
543
INTO language_descriptions (subtag, type, lang, description)
544
VALUES ('ko', 'language', 'fr', 'Coréen');
417
545
418
INSERT INTO language_descriptions(subtag, type, lang, description)
546
INSERT
419
VALUES( 'ko', 'language', 'de', 'Koreanisch');
547
INTO language_descriptions (subtag, type, lang, description)
548
VALUES ('ko', 'language', 'de', 'Koreanisch');
420
549
421
-- Latin
550
-- Latin
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
551
INSERT
423
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
552
INTO language_subtag_registry (subtag, type, description, added)
553
VALUES ('la', 'language', 'Latin', '2005-10-16');
424
554
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
555
INSERT
426
VALUES( 'la','lat');
556
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
557
VALUES ('la', 'lat');
427
558
428
INSERT INTO language_descriptions(subtag, type, lang, description)
559
INSERT
429
VALUES( 'la', 'language', 'la', 'Latina');
560
INTO language_descriptions (subtag, type, lang, description)
561
VALUES ('la', 'language', 'la', 'Latina');
430
562
431
INSERT INTO language_descriptions(subtag, type, lang, description)
563
INSERT
432
VALUES( 'la', 'language', 'en', 'Latin');
564
INTO language_descriptions (subtag, type, lang, description)
565
VALUES ('la', 'language', 'en', 'Latin');
433
566
434
INSERT INTO language_descriptions(subtag, type, lang, description)
567
INSERT
435
VALUES( 'la', 'language', 'fr', 'Latin');
568
INTO language_descriptions (subtag, type, lang, description)
569
VALUES ('la', 'language', 'fr', 'Latin');
436
570
437
INSERT INTO language_descriptions(subtag, type, lang, description)
571
INSERT
438
VALUES( 'la', 'language', 'de', 'Latein');
572
INTO language_descriptions (subtag, type, lang, description)
573
VALUES ('la', 'language', 'de', 'Latein');
439
574
440
-- Galician
575
-- Galician
441
576
442
INSERT INTO language_subtag_registry( subtag, type, description, added)
577
INSERT
443
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
578
INTO language_subtag_registry (subtag, type, description, added)
579
VALUES ('gl', 'language', 'Galician', '2005-10-16');
444
580
445
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
581
INSERT
446
VALUES( 'gl','glg');
582
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
583
VALUES ('gl', 'glg');
447
584
448
INSERT INTO language_descriptions(subtag, type, lang, description)
585
INSERT
449
VALUES( 'gl', 'language', 'gl', 'Galego');
586
INTO language_descriptions (subtag, type, lang, description)
587
VALUES ('gl', 'language', 'gl', 'Galego');
450
588
451
INSERT INTO language_descriptions(subtag, type, lang, description)
589
INSERT
452
VALUES( 'gl', 'language', 'en', 'Galician');
590
INTO language_descriptions (subtag, type, lang, description)
591
VALUES ('gl', 'language', 'en', 'Galician');
453
592
454
INSERT INTO language_descriptions(subtag, type, lang, description)
593
INSERT
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
594
INTO language_descriptions (subtag, type, lang, description)
595
VALUES ('gl', 'language', 'fr', 'Galicien');
456
596
457
-- Norwegian (bokmål)
597
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
INSERT
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
599
INTO language_subtag_registry (subtag, type, description, added)
600
VALUES ('nb', 'language', 'Norwegian bokm&#229;l', '2005-10-16');
460
601
461
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
602
INSERT
462
VALUES( 'nb','nor');
603
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
604
VALUES ('nb', 'nor');
463
605
464
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
606
INSERT
465
VALUES( 'nb','nob');
607
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
608
VALUES ('nb', 'nob');
466
609
467
INSERT INTO language_descriptions(subtag, type, lang, description)
610
INSERT
468
VALUES( 'nb', 'language', 'nb', 'Norsk bokm&#229;l');
611
INTO language_descriptions (subtag, type, lang, description)
612
VALUES ('nb', 'language', 'nb', 'Norsk bokm&#229;l');
469
613
470
INSERT INTO language_descriptions(subtag, type, lang, description)
614
INSERT
471
VALUES( 'nb', 'language', 'en', 'Norwegian bokm&#229;l');
615
INTO language_descriptions (subtag, type, lang, description)
616
VALUES ('nb', 'language', 'en', 'Norwegian bokm&#229;l');
472
617
473
INSERT INTO language_descriptions(subtag, type, lang, description)
618
INSERT
474
VALUES( 'nb', 'language', 'fr', 'Norvégien bokm&#229;l');
619
INTO language_descriptions (subtag, type, lang, description)
620
VALUES ('nb', 'language', 'fr', 'Norvégien bokm&#229;l');
475
621
476
INSERT INTO language_descriptions(subtag, type, lang, description)
622
INSERT
477
VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;l');
623
INTO language_descriptions (subtag, type, lang, description)
624
VALUES ('nb', 'language', 'de', 'Norwegisch bokm&#229;l');
478
625
479
-- Norwegian (nynorsk)
626
-- Norwegian (nynorsk)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
627
INSERT
481
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
628
INTO language_subtag_registry (subtag, type, description, added)
629
VALUES ('nn', 'language', 'Norwegian nynorsk', '2011-02-14');
482
630
483
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
631
INSERT
484
VALUES( 'nn','nno');
632
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
633
VALUES ('nn', 'nno');
485
634
486
INSERT INTO language_descriptions(subtag, type, lang, description)
635
INSERT
487
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
636
INTO language_descriptions (subtag, type, lang, description)
637
VALUES ('nn', 'language', 'nb', 'Norsk nynorsk');
488
638
489
INSERT INTO language_descriptions(subtag, type, lang, description)
639
INSERT
490
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
640
INTO language_descriptions (subtag, type, lang, description)
641
VALUES ('nn', 'language', 'nn', 'Norsk nynorsk');
491
642
492
INSERT INTO language_descriptions(subtag, type, lang, description)
643
INSERT
493
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
644
INTO language_descriptions (subtag, type, lang, description)
645
VALUES ('nn', 'language', 'en', 'Norwegian nynorsk');
494
646
495
INSERT INTO language_descriptions(subtag, type, lang, description)
647
INSERT
496
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
648
INTO language_descriptions (subtag, type, lang, description)
649
VALUES ('nn', 'language', 'fr', 'Norvégien nynorsk');
497
650
498
INSERT INTO language_descriptions(subtag, type, lang, description)
651
INSERT
499
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
652
INTO language_descriptions (subtag, type, lang, description)
653
VALUES ('nn', 'language', 'de', 'Norwegisch nynorsk');
500
654
501
-- Persian
655
-- Persian
502
INSERT INTO language_subtag_registry( subtag, type, description, added)
656
INSERT
503
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
657
INTO language_subtag_registry (subtag, type, description, added)
658
VALUES ('fa', 'language', 'Persian', '2005-10-16');
504
659
505
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
660
INSERT
506
VALUES( 'fa','per');
661
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
662
VALUES ('fa', 'per');
507
663
508
INSERT INTO language_descriptions(subtag, type, lang, description)
664
INSERT
509
VALUES( 'fa', 'language', 'fa', '&#1601;&#1575;&#1585;&#1587;&#1609;');
665
INTO language_descriptions (subtag, type, lang, description)
666
VALUES ('fa', 'language', 'fa', '&#1601;&#1575;&#1585;&#1587;&#1609;');
510
667
511
INSERT INTO language_descriptions(subtag, type, lang, description)
668
INSERT
512
VALUES( 'fa', 'language', 'en', 'Persian');
669
INTO language_descriptions (subtag, type, lang, description)
670
VALUES ('fa', 'language', 'en', 'Persian');
513
671
514
INSERT INTO language_descriptions(subtag, type, lang, description)
672
INSERT
515
VALUES( 'fa', 'language', 'fr', 'Persan');
673
INTO language_descriptions (subtag, type, lang, description)
674
VALUES ('fa', 'language', 'fr', 'Persan');
516
675
517
INSERT INTO language_descriptions(subtag, type, lang, description)
676
INSERT
518
VALUES( 'fa', 'language', 'de', 'Persisch');
677
INTO language_descriptions (subtag, type, lang, description)
678
VALUES ('fa', 'language', 'de', 'Persisch');
519
679
520
-- Polish
680
-- Polish
521
INSERT INTO language_subtag_registry( subtag, type, description, added)
681
INSERT
522
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
682
INTO language_subtag_registry (subtag, type, description, added)
683
VALUES ('pl', 'language', 'Polish', '2005-10-16');
523
684
524
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
685
INSERT
525
VALUES( 'pl','pol');
686
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
687
VALUES ('pl', 'pol');
526
688
527
INSERT INTO language_descriptions(subtag, type, lang, description)
689
INSERT
528
VALUES( 'pl', 'language', 'pl', 'Polski');
690
INTO language_descriptions (subtag, type, lang, description)
691
VALUES ('pl', 'language', 'pl', 'Polski');
529
692
530
INSERT INTO language_descriptions(subtag, type, lang, description)
693
INSERT
531
VALUES( 'pl', 'language', 'en', 'Polish');
694
INTO language_descriptions (subtag, type, lang, description)
695
VALUES ('pl', 'language', 'en', 'Polish');
532
696
533
INSERT INTO language_descriptions(subtag, type, lang, description)
697
INSERT
534
VALUES( 'pl', 'language', 'fr', 'Polonais');
698
INTO language_descriptions (subtag, type, lang, description)
699
VALUES ('pl', 'language', 'fr', 'Polonais');
535
700
536
INSERT INTO language_descriptions(subtag, type, lang, description)
701
INSERT
537
VALUES( 'pl', 'language', 'de', 'Polnisch');
702
INTO language_descriptions (subtag, type, lang, description)
703
VALUES ('pl', 'language', 'de', 'Polnisch');
538
704
539
-- Portuguese
705
-- Portuguese
540
INSERT INTO language_subtag_registry( subtag, type, description, added)
706
INSERT
541
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
707
INTO language_subtag_registry (subtag, type, description, added)
708
VALUES ('pt', 'language', 'Portuguese', '2005-10-16');
542
709
543
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
710
INSERT
544
VALUES( 'pt','por');
711
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
712
VALUES ('pt', 'por');
545
713
546
INSERT INTO language_descriptions(subtag, type, lang, description)
714
INSERT
547
VALUES( 'pt', 'language', 'pt', 'Portugu&ecirc;s');
715
INTO language_descriptions (subtag, type, lang, description)
716
VALUES ('pt', 'language', 'pt', 'Portugu&ecirc;s');
548
717
549
INSERT INTO language_descriptions(subtag, type, lang, description)
718
INSERT
550
VALUES( 'pt', 'language', 'en', 'Portuguese');
719
INTO language_descriptions (subtag, type, lang, description)
720
VALUES ('pt', 'language', 'en', 'Portuguese');
551
721
552
INSERT INTO language_descriptions(subtag, type, lang, description)
722
INSERT
553
VALUES( 'pt', 'language', 'fr', 'Portugais');
723
INTO language_descriptions (subtag, type, lang, description)
724
VALUES ('pt', 'language', 'fr', 'Portugais');
554
725
555
INSERT INTO language_descriptions(subtag, type, lang, description)
726
INSERT
556
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
727
INTO language_descriptions (subtag, type, lang, description)
728
VALUES ('pt', 'language', 'de', 'Portugiesisch');
557
729
558
-- Romanian
730
-- Romanian
559
INSERT INTO language_subtag_registry( subtag, type, description, added)
731
INSERT
560
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
732
INTO language_subtag_registry (subtag, type, description, added)
733
VALUES ('ro', 'language', 'Romanian', '2005-10-16');
561
734
562
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
735
INSERT
563
VALUES( 'ro','rum');
736
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
737
VALUES ('ro', 'rum');
564
738
565
INSERT INTO language_descriptions(subtag, type, lang, description)
739
INSERT
566
VALUES( 'ro', 'language', 'ro', 'Rom&acirc;n&#259;');
740
INTO language_descriptions (subtag, type, lang, description)
741
VALUES ('ro', 'language', 'ro', 'Rom&acirc;n&#259;');
567
742
568
INSERT INTO language_descriptions(subtag, type, lang, description)
743
INSERT
569
VALUES( 'ro', 'language', 'en', 'Romanian');
744
INTO language_descriptions (subtag, type, lang, description)
745
VALUES ('ro', 'language', 'en', 'Romanian');
570
746
571
INSERT INTO language_descriptions(subtag, type, lang, description)
747
INSERT
572
VALUES( 'ro', 'language', 'fr', 'Roumain');
748
INTO language_descriptions (subtag, type, lang, description)
749
VALUES ('ro', 'language', 'fr', 'Roumain');
573
750
574
INSERT INTO language_descriptions(subtag, type, lang, description)
751
INSERT
575
VALUES( 'ro', 'language', 'de', 'Rumänisch');
752
INTO language_descriptions (subtag, type, lang, description)
753
VALUES ('ro', 'language', 'de', 'Rumänisch');
576
754
577
-- Russian
755
-- Russian
578
INSERT INTO language_subtag_registry( subtag, type, description, added)
756
INSERT
579
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
757
INTO language_subtag_registry (subtag, type, description, added)
758
VALUES ('ru', 'language', 'Russian', '2005-10-16');
580
759
581
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
760
INSERT
582
VALUES( 'ru','rus');
761
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
762
VALUES ('ru', 'rus');
583
763
584
INSERT INTO language_descriptions(subtag, type, lang, description)
764
INSERT
585
VALUES( 'ru', 'language', 'ru', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;');
765
INTO language_descriptions (subtag, type, lang, description)
766
VALUES ('ru', 'language', 'ru', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;');
586
767
587
INSERT INTO language_descriptions(subtag, type, lang, description)
768
INSERT
588
VALUES( 'ru', 'language', 'en', 'Russian');
769
INTO language_descriptions (subtag, type, lang, description)
770
VALUES ('ru', 'language', 'en', 'Russian');
589
771
590
INSERT INTO language_descriptions(subtag, type, lang, description)
772
INSERT
591
VALUES( 'ru', 'language', 'fr', 'Russe');
773
INTO language_descriptions (subtag, type, lang, description)
774
VALUES ('ru', 'language', 'fr', 'Russe');
592
775
593
INSERT INTO language_descriptions(subtag, type, lang, description)
776
INSERT
594
VALUES( 'ru', 'language', 'de', 'Russisch');
777
INTO language_descriptions (subtag, type, lang, description)
778
VALUES ('ru', 'language', 'de', 'Russisch');
595
779
596
-- Serbian
780
-- Serbian
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
781
INSERT
598
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
782
INTO language_subtag_registry (subtag, type, description, added)
783
VALUES ('sr', 'language', 'Serbian', '2005-10-16');
599
784
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
785
INSERT
601
VALUES( 'sr','srp');
786
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
787
VALUES ('sr', 'srp');
602
788
603
INSERT INTO language_descriptions(subtag, type, lang, description)
789
INSERT
604
VALUES( 'sr', 'language', 'sr', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
790
INTO language_descriptions (subtag, type, lang, description)
791
VALUES ('sr', 'language', 'sr', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
605
792
606
INSERT INTO language_descriptions(subtag, type, lang, description)
793
INSERT
607
VALUES( 'sr', 'language', 'en', 'Serbian');
794
INTO language_descriptions (subtag, type, lang, description)
795
VALUES ('sr', 'language', 'en', 'Serbian');
608
796
609
INSERT INTO language_descriptions(subtag, type, lang, description)
797
INSERT
610
VALUES( 'sr', 'language', 'fr', 'Serbe');
798
INTO language_descriptions (subtag, type, lang, description)
799
VALUES ('sr', 'language', 'fr', 'Serbe');
611
800
612
INSERT INTO language_descriptions(subtag, type, lang, description)
801
INSERT
613
VALUES( 'sr', 'language', 'de', 'Serbisch');
802
INTO language_descriptions (subtag, type, lang, description)
803
VALUES ('sr', 'language', 'de', 'Serbisch');
614
804
615
-- Spanish, Castilian
805
-- Spanish, Castilian
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
806
INSERT
617
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
807
INTO language_subtag_registry (subtag, type, description, added)
808
VALUES ('es', 'language', 'Spanish', '2005-10-16');
618
809
619
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
810
INSERT
620
VALUES( 'es','spa');
811
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
812
VALUES ('es', 'spa');
621
813
622
INSERT INTO language_descriptions(subtag, type, lang, description)
814
INSERT
623
VALUES( 'es', 'language', 'es', 'Espa&ntilde;ol');
815
INTO language_descriptions (subtag, type, lang, description)
816
VALUES ('es', 'language', 'es', 'Espa&ntilde;ol');
624
817
625
INSERT INTO language_descriptions(subtag, type, lang, description)
818
INSERT
626
VALUES( 'es', 'language', 'en', 'Spanish');
819
INTO language_descriptions (subtag, type, lang, description)
820
VALUES ('es', 'language', 'en', 'Spanish');
627
821
628
INSERT INTO language_descriptions(subtag, type, lang, description)
822
INSERT
629
VALUES( 'es', 'language', 'fr', 'Espagnol');
823
INTO language_descriptions (subtag, type, lang, description)
824
VALUES ('es', 'language', 'fr', 'Espagnol');
630
825
631
INSERT INTO language_descriptions(subtag, type, lang, description)
826
INSERT
632
VALUES( 'es', 'language', 'de', 'Spanisch');
827
INTO language_descriptions (subtag, type, lang, description)
828
VALUES ('es', 'language', 'de', 'Spanisch');
633
829
634
-- Spanish, Catalan
830
-- Spanish, Catalan
635
INSERT INTO language_subtag_registry( subtag, type, description, added)
831
INSERT
636
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
832
INTO language_subtag_registry (subtag, type, description, added)
833
VALUES ('ca', 'language', 'Catalan', '2013-01-12');
637
834
638
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
835
INSERT
639
VALUES( 'ca','cat');
836
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
837
VALUES ('ca', 'cat');
640
838
641
INSERT INTO language_descriptions(subtag, type, lang, description)
839
INSERT
642
VALUES( 'ca', 'language', 'es', 'Catalán');
840
INTO language_descriptions (subtag, type, lang, description)
841
VALUES ('ca', 'language', 'es', 'Catalán');
643
842
644
INSERT INTO language_descriptions(subtag, type, lang, description)
843
INSERT
645
VALUES( 'ca', 'language', 'en', 'Catalan');
844
INTO language_descriptions (subtag, type, lang, description)
845
VALUES ('ca', 'language', 'en', 'Catalan');
646
846
647
INSERT INTO language_descriptions(subtag, type, lang, description)
847
INSERT
648
VALUES( 'ca', 'language', 'fr', 'Catalan');
848
INTO language_descriptions (subtag, type, lang, description)
849
VALUES ('ca', 'language', 'fr', 'Catalan');
649
850
650
INSERT INTO language_descriptions(subtag, type, lang, description)
851
INSERT
651
VALUES( 'ca', 'language', 'ca', 'Català');
852
INTO language_descriptions (subtag, type, lang, description)
853
VALUES ('ca', 'language', 'ca', 'Català');
652
854
653
INSERT INTO language_descriptions(subtag, type, lang, description)
855
INSERT
654
VALUES( 'ca', 'language', 'de', 'Katalanisch');
856
INTO language_descriptions (subtag, type, lang, description)
857
VALUES ('ca', 'language', 'de', 'Katalanisch');
655
858
656
-- Swedish
859
-- Swedish
657
INSERT INTO language_subtag_registry( subtag, type, description, added)
860
INSERT
658
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
861
INTO language_subtag_registry (subtag, type, description, added)
862
VALUES ('sv', 'language', 'Swedish', '2005-10-16');
659
863
660
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
864
INSERT
661
VALUES( 'sv','swe');
865
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
866
VALUES ('sv', 'swe');
662
867
663
INSERT INTO language_descriptions(subtag, type, lang, description)
868
INSERT
664
VALUES( 'sv', 'language', 'sv', 'Svenska');
869
INTO language_descriptions (subtag, type, lang, description)
870
VALUES ('sv', 'language', 'sv', 'Svenska');
665
871
666
INSERT INTO language_descriptions(subtag, type, lang, description)
872
INSERT
667
VALUES( 'sv', 'language', 'en', 'Swedish');   
873
INTO language_descriptions (subtag, type, lang, description)
874
VALUES ('sv', 'language', 'en', 'Swedish');
668
875
669
INSERT INTO language_descriptions(subtag, type, lang, description)
876
INSERT
670
VALUES( 'sv', 'language', 'fr', 'Suédois');
877
INTO language_descriptions (subtag, type, lang, description)
878
VALUES ('sv', 'language', 'fr', 'Suédois');
671
879
672
INSERT INTO language_descriptions(subtag, type, lang, description)
880
INSERT
673
VALUES( 'sv', 'language', 'de', 'Schwedisch');
881
INTO language_descriptions (subtag, type, lang, description)
882
VALUES ('sv', 'language', 'de', 'Schwedisch');
674
883
675
-- Tetum
884
-- Tetum
676
INSERT INTO language_subtag_registry( subtag, type, description, added)
885
INSERT
677
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
886
INTO language_subtag_registry (subtag, type, description, added)
887
VALUES ('tet', 'language', 'Tetum', '2005-10-16');
678
888
679
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
889
INSERT
680
VALUES( 'tet','tet');
890
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
891
VALUES ('tet', 'tet');
681
892
682
INSERT INTO language_descriptions(subtag, type, lang, description)
893
INSERT
683
VALUES( 'tet', 'language', 'tet', 'tetun');
894
INTO language_descriptions (subtag, type, lang, description)
895
VALUES ('tet', 'language', 'tet', 'tetun');
684
896
685
INSERT INTO language_descriptions(subtag, type, lang, description)
897
INSERT
686
VALUES( 'tet', 'language', 'en', 'Tetum');
898
INTO language_descriptions (subtag, type, lang, description)
899
VALUES ('tet', 'language', 'en', 'Tetum');
687
900
688
INSERT INTO language_descriptions(subtag, type, lang, description)
901
INSERT
689
VALUES( 'tet', 'language', 'fr', 'Tétoum');
902
INTO language_descriptions (subtag, type, lang, description)
903
VALUES ('tet', 'language', 'fr', 'Tétoum');
690
904
691
INSERT INTO language_descriptions(subtag, type, lang, description)
905
INSERT
692
VALUES( 'tet', 'language', 'de', 'Tetum');
906
INTO language_descriptions (subtag, type, lang, description)
907
VALUES ('tet', 'language', 'de', 'Tetum');
693
908
694
-- Thai
909
-- Thai
695
INSERT INTO language_subtag_registry( subtag, type, description, added)
910
INSERT
696
VALUES ( 'th', 'language', 'Thai','2005-10-16');
911
INTO language_subtag_registry (subtag, type, description, added)
912
VALUES ('th', 'language', 'Thai', '2005-10-16');
697
913
698
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
914
INSERT
699
VALUES( 'th','tha');
915
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
916
VALUES ('th', 'tha');
700
917
701
INSERT INTO language_descriptions(subtag, type, lang, description)
918
INSERT
702
VALUES( 'th', 'language', 'th', '&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;');
919
INTO language_descriptions (subtag, type, lang, description)
920
VALUES ('th', 'language', 'th', '&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;');
703
921
704
INSERT INTO language_descriptions(subtag, type, lang, description)
922
INSERT
705
VALUES( 'th', 'language', 'en', 'Thai');   
923
INTO language_descriptions (subtag, type, lang, description)
924
VALUES ('th', 'language', 'en', 'Thai');
706
925
707
INSERT INTO language_descriptions(subtag, type, lang, description)
926
INSERT
708
VALUES( 'th', 'language', 'fr', 'Thaï');
927
INTO language_descriptions (subtag, type, lang, description)
928
VALUES ('th', 'language', 'fr', 'Thaï');
709
929
710
INSERT INTO language_descriptions(subtag, type, lang, description)
930
INSERT
711
VALUES( 'th', 'language', 'de', 'Thailändisch');
931
INTO language_descriptions (subtag, type, lang, description)
932
VALUES ('th', 'language', 'de', 'Thailändisch');
712
933
713
-- Turkish
934
-- Turkish
714
INSERT INTO language_subtag_registry( subtag, type, description, added)
935
INSERT
715
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
936
INTO language_subtag_registry (subtag, type, description, added)
937
VALUES ('tr', 'language', 'Turkish', '2005-10-16');
716
938
717
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
939
INSERT
718
VALUES( 'tr','tur');
940
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
941
VALUES ('tr', 'tur');
719
942
720
INSERT INTO language_descriptions(subtag, type, lang, description)
943
INSERT
721
VALUES( 'tr', 'language', 'tr', 'T&uuml;rk&ccedil;e');
944
INTO language_descriptions (subtag, type, lang, description)
945
VALUES ('tr', 'language', 'tr', 'T&uuml;rk&ccedil;e');
722
946
723
INSERT INTO language_descriptions(subtag, type, lang, description)
947
INSERT
724
VALUES( 'tr', 'language', 'en', 'Turkish');   
948
INTO language_descriptions (subtag, type, lang, description)
949
VALUES ('tr', 'language', 'en', 'Turkish');
725
950
726
INSERT INTO language_descriptions(subtag, type, lang, description)
951
INSERT
727
VALUES( 'tr', 'language', 'fr', 'Turc');
952
INTO language_descriptions (subtag, type, lang, description)
953
VALUES ('tr', 'language', 'fr', 'Turc');
728
954
729
INSERT INTO language_descriptions(subtag, type, lang, description)
955
INSERT
730
VALUES( 'tr', 'language', 'de', 'Türkisch');
956
INTO language_descriptions (subtag, type, lang, description)
957
VALUES ('tr', 'language', 'de', 'Türkisch');
731
958
732
-- Ukranian
959
-- Ukranian
733
INSERT INTO language_subtag_registry( subtag, type, description, added)
960
INSERT
734
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
961
INTO language_subtag_registry (subtag, type, description, added)
962
VALUES ('uk', 'language', 'Ukranian', '2005-10-16');
735
963
736
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
964
INSERT
737
VALUES( 'uk','ukr');
965
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
966
VALUES ('uk', 'ukr');
738
967
739
INSERT INTO language_descriptions(subtag, type, lang, description)
968
INSERT
740
VALUES( 'uk', 'language', 'uk', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;');
969
INTO language_descriptions (subtag, type, lang, description)
970
VALUES ('uk', 'language', 'uk', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;');
741
971
742
INSERT INTO language_descriptions(subtag, type, lang, description)
972
INSERT
743
VALUES( 'uk', 'language', 'en', 'Ukranian');
973
INTO language_descriptions (subtag, type, lang, description)
974
VALUES ('uk', 'language', 'en', 'Ukranian');
744
975
745
INSERT INTO language_descriptions(subtag, type, lang, description)
976
INSERT
746
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
977
INTO language_descriptions (subtag, type, lang, description)
978
VALUES ('uk', 'language', 'fr', 'Ukrainien');
747
979
748
INSERT INTO language_descriptions(subtag, type, lang, description)
980
INSERT
749
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
981
INTO language_descriptions (subtag, type, lang, description)
982
VALUES ('uk', 'language', 'de', 'Ukrainisch');
750
983
751
-- Urdu
984
-- Urdu
752
INSERT INTO language_subtag_registry( subtag, type, description, added)
985
INSERT
753
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
986
INTO language_subtag_registry (subtag, type, description, added)
987
VALUES ('ur', 'language', 'Urdu', '2005-10-16');
754
988
755
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
989
INSERT
756
VALUES( 'ur','urd');
990
INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
991
VALUES ('ur', 'urd');
757
992
758
INSERT INTO language_descriptions(subtag, type, lang, description)
993
INSERT
759
VALUES( 'ur', 'language', 'en', 'Urdu');
994
INTO language_descriptions (subtag, type, lang, description)
995
VALUES ('ur', 'language', 'en', 'Urdu');
760
996
761
INSERT INTO language_descriptions(subtag, type, lang, description)
997
INSERT
762
VALUES( 'ur', 'language', 'ur', '&#1575;&#1585;&#1583;&#1608;');
998
INTO language_descriptions (subtag, type, lang, description)
999
VALUES ('ur', 'language', 'ur', '&#1575;&#1585;&#1583;&#1608;');
763
1000
764
INSERT INTO language_descriptions(subtag, type, lang, description)
1001
INSERT
765
VALUES( 'ur', 'language', 'fr', 'Ourdou');
1002
INTO language_descriptions (subtag, type, lang, description)
1003
VALUES ('ur', 'language', 'fr', 'Ourdou');
766
1004
767
INSERT INTO language_descriptions(subtag, type, lang, description)
1005
INSERT
768
VALUES( 'ur', 'language', 'de', 'Urdu');
1006
INTO language_descriptions (subtag, type, lang, description)
1007
VALUES ('ur', 'language', 'de', 'Urdu');
769
1008
770
-- SCRIPTS
1009
-- SCRIPTS
771
-- Arabic
1010
-- Arabic
772
INSERT INTO language_subtag_registry( subtag, type, description, added)
1011
INSERT
773
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
1012
INTO language_subtag_registry (subtag, type, description, added)
1013
VALUES ('Arab', 'script', 'Arabic', '2005-10-16');
774
1014
775
INSERT INTO language_descriptions(subtag, type, lang, description)
1015
INSERT
776
VALUES ( 'Arab','script', 'Arab', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
1016
INTO language_descriptions (subtag, type, lang, description)
1017
VALUES ('Arab', 'script', 'Arab', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
777
1018
778
INSERT INTO language_descriptions(subtag, type, lang, description)
1019
INSERT
779
VALUES( 'Arab', 'script','en', 'Arabic');
1020
INTO language_descriptions (subtag, type, lang, description)
1021
VALUES ('Arab', 'script', 'en', 'Arabic');
780
1022
781
INSERT INTO language_descriptions(subtag, type, lang, description)
1023
INSERT
782
VALUES( 'Arab', 'script','fr', 'Arabic');
1024
INTO language_descriptions (subtag, type, lang, description)
1025
VALUES ('Arab', 'script', 'fr', 'Arabic');
783
1026
784
-- Cyrillic
1027
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
1028
INSERT
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
1029
INTO language_subtag_registry (subtag, type, description, added)
1030
VALUES ('Cyrl', 'script', 'Cyrillic', '2005-10-16');
787
1031
788
INSERT INTO language_descriptions(subtag, type, lang, description)
1032
INSERT
789
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
1033
INTO language_descriptions (subtag, type, lang, description)
1034
VALUES ('Cyrl', 'script', 'Cyrl', '????');
790
1035
791
INSERT INTO language_descriptions(subtag, type, lang, description)
1036
INSERT
792
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
1037
INTO language_descriptions (subtag, type, lang, description)
1038
VALUES ('Cyrl', 'script', 'en', 'Cyrillic');
793
1039
794
INSERT INTO language_descriptions(subtag, type, lang, description)
1040
INSERT
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
1041
INTO language_descriptions (subtag, type, lang, description)
1042
VALUES ('Cyrl', 'script', 'fr', 'Cyrillic');
796
1043
797
-- Greek
1044
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
1045
INSERT
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
1046
INTO language_subtag_registry (subtag, type, description, added)
1047
VALUES ('Grek', 'script', 'Greek', '2005-10-16');
800
1048
801
INSERT INTO language_descriptions(subtag, type, lang, description)
1049
INSERT
802
VALUES ( 'Grek', 'script', 'Grek', '????');
1050
INTO language_descriptions (subtag, type, lang, description)
1051
VALUES ('Grek', 'script', 'Grek', '????');
803
1052
804
INSERT INTO language_descriptions(subtag, type, lang, description)
1053
INSERT
805
VALUES( 'Grek', 'script', 'en', 'Greek');
1054
INTO language_descriptions (subtag, type, lang, description)
1055
VALUES ('Grek', 'script', 'en', 'Greek');
806
1056
807
INSERT INTO language_descriptions(subtag, type, lang, description)
1057
INSERT
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
1058
INTO language_descriptions (subtag, type, lang, description)
1059
VALUES ('Grek', 'script', 'fr', 'Greek');
809
1060
810
-- Han - Simplified
1061
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
1062
INSERT
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
1063
INTO language_subtag_registry (subtag, type, description, added)
1064
VALUES ('Hans', 'script', 'Han (Simplified variant)', '2005-10-16');
813
1065
814
INSERT INTO language_descriptions(subtag, type, lang, description)
1066
INSERT
815
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
1067
INTO language_descriptions (subtag, type, lang, description)
1068
VALUES ('Hans', 'script', 'Hans', 'Han (Simplified variant)');
816
1069
817
INSERT INTO language_descriptions(subtag, type, lang, description)
1070
INSERT
818
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
1071
INTO language_descriptions (subtag, type, lang, description)
1072
VALUES ('Hans', 'script', 'en', 'Han (Simplified variant)');
819
1073
820
INSERT INTO language_descriptions(subtag, type, lang, description)
1074
INSERT
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
1075
INTO language_descriptions (subtag, type, lang, description)
1076
VALUES ('Hans', 'script', 'fr', 'Han (Simplified variant)');
822
1077
823
-- Han - Traditional
1078
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
1079
INSERT
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
1080
INTO language_subtag_registry (subtag, type, description, added)
1081
VALUES ('Hant', 'script', 'Han (Traditional variant)', '2005-10-16');
826
1082
827
INSERT INTO language_descriptions(subtag, type, lang, description)
1083
INSERT
828
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
1084
INTO language_descriptions (subtag, type, lang, description)
1085
VALUES ('Hant', 'script', 'Hant', 'Han (Traditional variant)');
829
1086
830
INSERT INTO language_descriptions(subtag, type, lang, description)
1087
INSERT
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
1088
INTO language_descriptions (subtag, type, lang, description)
1089
VALUES ('Hant', 'script', 'en', 'Han (Traditional variant)');
832
1090
833
-- Hebrew
1091
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
1092
INSERT
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
1093
INTO language_subtag_registry (subtag, type, description, added)
1094
VALUES ('Hebr', 'script', 'Hebrew', '2005-10-16');
836
1095
837
INSERT INTO language_descriptions(subtag, type, lang, description)
1096
INSERT
838
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
1097
INTO language_descriptions (subtag, type, lang, description)
1098
VALUES ('Hebr', 'script', 'Hebr', 'Hebrew');
839
1099
840
INSERT INTO language_descriptions(subtag, type, lang, description)
1100
INSERT
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
1101
INTO language_descriptions (subtag, type, lang, description)
1102
VALUES ('Hebr', 'script', 'en', 'Hebrew');
842
1103
843
-- Lao
1104
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
1105
INSERT
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
1106
INTO language_subtag_registry (subtag, type, description, added)
1107
VALUES ('Laoo', 'script', 'Lao', '2005-10-16');
846
1108
847
INSERT INTO language_descriptions(subtag, type, lang, description)
1109
INSERT
848
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
1110
INTO language_descriptions (subtag, type, lang, description)
1111
VALUES ('Laoo', 'script', 'lo', 'Lao');
849
1112
850
INSERT INTO language_descriptions(subtag, type, lang, description)
1113
INSERT
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
1114
INTO language_descriptions (subtag, type, lang, description)
1115
VALUES ('Laoo', 'script', 'en', 'Lao');
852
1116
853
-- REGIONS
1117
-- REGIONS
854
-- Canada
1118
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
1119
INSERT
856
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
1120
INTO language_subtag_registry (subtag, type, description, added)
1121
VALUES ('CA', 'region', 'Canada', '2005-10-16');
857
1122
858
INSERT INTO language_descriptions(subtag, type, lang, description)
1123
INSERT
859
VALUES( 'CA', 'region', 'en', 'Canada');
1124
INTO language_descriptions (subtag, type, lang, description)
1125
VALUES ('CA', 'region', 'en', 'Canada');
860
1126
861
-- Denmark
1127
-- Denmark
862
INSERT INTO language_subtag_registry( subtag, type, description, added)
1128
INSERT
863
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
1129
INTO language_subtag_registry (subtag, type, description, added)
1130
VALUES ('DK', 'region', 'Denmark', '2005-10-16');
864
1131
865
INSERT INTO language_descriptions(subtag, type, lang, description)
1132
INSERT
866
VALUES( 'DK', 'region', 'dk', 'Danmark');
1133
INTO language_descriptions (subtag, type, lang, description)
1134
VALUES ('DK', 'region', 'dk', 'Danmark');
867
1135
868
-- France
1136
-- France
869
INSERT INTO language_subtag_registry( subtag, type, description, added)
1137
INSERT
870
VALUES ( 'FR', 'region', 'France','2005-10-16');
1138
INTO language_subtag_registry (subtag, type, description, added)
1139
VALUES ('FR', 'region', 'France', '2005-10-16');
871
1140
872
INSERT INTO language_descriptions(subtag, type, lang, description)
1141
INSERT
873
VALUES ( 'FR', 'region', 'fr', 'France');
1142
INTO language_descriptions (subtag, type, lang, description)
1143
VALUES ('FR', 'region', 'fr', 'France');
874
1144
875
INSERT INTO language_descriptions(subtag, type, lang, description)
1145
INSERT
876
VALUES( 'FR', 'region', 'en', 'France');
1146
INTO language_descriptions (subtag, type, lang, description)
1147
VALUES ('FR', 'region', 'en', 'France');
877
1148
878
-- New Zealand
1149
-- New Zealand
879
INSERT INTO language_subtag_registry( subtag, type, description, added)
1150
INSERT
880
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
1151
INTO language_subtag_registry (subtag, type, description, added)
1152
VALUES ('NZ', 'region', 'New Zealand', '2005-10-16');
881
1153
882
INSERT INTO language_descriptions(subtag, type, lang, description)
1154
INSERT
883
VALUES( 'NZ', 'region', 'en', 'New Zealand');
1155
INTO language_descriptions (subtag, type, lang, description)
1156
VALUES ('NZ', 'region', 'en', 'New Zealand');
884
1157
885
-- United Kingdom
1158
-- United Kingdom
886
INSERT INTO language_subtag_registry( subtag, type, description, added)
1159
INSERT
887
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
1160
INTO language_subtag_registry (subtag, type, description, added)
1161
VALUES ('GB', 'region', 'United Kingdom', '2005-10-16');
888
1162
889
INSERT INTO language_descriptions(subtag, type, lang, description)
1163
INSERT
890
VALUES( 'GB', 'region', 'en', 'United Kingdom');
1164
INTO language_descriptions (subtag, type, lang, description)
1165
VALUES ('GB', 'region', 'en', 'United Kingdom');
891
1166
892
-- United States
1167
-- United States
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
1168
INSERT
894
VALUES ( 'US', 'region', 'United States','2005-10-16');
1169
INTO language_subtag_registry (subtag, type, description, added)
1170
VALUES ('US', 'region', 'United States', '2005-10-16');
895
1171
896
INSERT INTO language_descriptions(subtag, type, lang, description)
1172
INSERT
897
VALUES( 'US', 'region', 'en', 'United States');
1173
INTO language_descriptions (subtag, type, lang, description)
1174
VALUES ('US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/en/mandatory/userflags.sql (-20 / +22 lines)
Lines 1-20 Link Here
1
INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
1
INSERT
2
(0,'superlibrarian','Access to all librarian functions',0),
2
INTO userflags (bit, flag, flagdesc, defaulton)
3
(1,'circulate','Check out and check in items',0),
3
VALUES
4
(2,'catalogue','<b>Required for staff login.</b> Staff access, allows viewing of catalogue in staff client.',0),
4
    (0, 'superlibrarian', i18n('Access to all librarian functions'), 0),
5
(3,'parameters','Manage Koha system settings (Administration panel)',0),
5
    (1, 'circulate', i18n('Check out and check in items'), 0),
6
(4,'borrowers','Add or modify patrons',0),
6
    (2, 'catalogue', i18n('<b>Required for staff login.</b> Staff access, allows viewing of catalogue in staff client.'), 0),
7
(5,'permissions','Set user permissions',0),
7
    (3, 'parameters', i18n('Manage Koha system settings (Administration panel)'), 0),
8
(6,'reserveforothers','Place and modify holds for patrons',0),
8
    (4, 'borrowers', i18n('Add or modify patrons'), 0),
9
(7,'borrow','Borrow books',1),
9
    (5, 'permissions', i18n('Set user permissions'), 0),
10
(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0),
10
    (6, 'reserveforothers', i18n('Place and modify holds for patrons'), 0),
11
(10,'updatecharges','Manage patrons fines and fees',0),
11
    (7, 'borrow', i18n('Borrow books'), 1),
12
(11,'acquisition','Acquisition and/or suggestion management',0),
12
    (9, 'editcatalogue', i18n('Edit Catalog (Modify bibliographic/holdings data)'), 0),
13
(12,'management','Set library management parameters (deprecated)',0),
13
    (10, 'updatecharges', i18n('Manage patrons fines and fees'), 0),
14
(13,'tools','Use all tools (expand for granular tools permissions)',0),
14
    (11, 'acquisition', i18n('Acquisition and/or suggestion management'), 0),
15
(14,'editauthorities','Edit Authorities',0),
15
    (12, 'management', i18n('Set library management parameters (deprecated)'), 0),
16
(15,'serials','Manage serial subscriptions',0),
16
    (13, 'tools', i18n('Use all tools (expand for granular tools permissions)'), 0),
17
(16,'reports','Allow access to the reports module',0),
17
    (14, 'editauthorities', i18n('Edit Authorities'), 0),
18
(17,'staffaccess','Allow staff members to modify permissions for other staff members',0),
18
    (15, 'serials', i18n('Manage serial subscriptions'), 0),
19
(18,'coursereserves','Course Reserves',0),
19
    (16, 'reports', i18n('Allow access to the reports module'), 0),
20
(19, 'plugins', 'Koha plugins', '0');
20
    (17, 'staffaccess', i18n('Allow staff members to modify permissions for other staff members'), 0),
21
    (18, 'coursereserves', i18n('Course Reserves'), 0),
22
    (19, 'plugins', i18n('Koha plugins'), '0');
(-)a/installer/data/mysql/en/mandatory/userpermissions.sql (-64 / +64 lines)
Lines 1-63 Link Here
1
INSERT INTO permissions (module_bit, code, description) VALUES
1
INSERT
2
   ( 1, 'circulate_remaining_permissions', 'Remaining circulation permissions'),
2
INTO permissions (module_bit, code, description)
3
   ( 1, 'override_renewals', 'Override blocked renewals'),
3
VALUES
4
   ( 1, 'overdues_report', 'Execute overdue items report'),
4
    (1, 'circulate_remaining_permissions', i18n('Remaining circulation permissions')),
5
   ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'),
5
    (1, 'override_renewals', i18n('Override blocked renewals')),
6
   ( 3, 'manage_circ_rules', 'manage circulation rules'),
6
    (1, 'overdues_report', i18n('Execute overdue items report')),
7
   ( 6, 'place_holds', 'Place holds for patrons'),
7
    (3, 'parameters_remaining_permissions', i18n('Remaining system parameters permissions')),
8
   ( 6, 'modify_holds_priority', 'Modify holds priority'),
8
    (3, 'manage_circ_rules', i18n('manage circulation rules')),
9
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
9
    (6, 'place_holds', i18n('Place holds for patrons')),
10
   ( 9, 'fast_cataloging', 'Fast cataloging'),
10
    (6, 'modify_holds_priority', i18n('Modify holds priority')),
11
   ( 9, 'edit_items', 'Edit Items'),
11
    (9, 'edit_catalogue', i18n('Edit catalog (Modify bibliographic/holdings data)')),
12
   (11, 'vendors_manage', 'Manage vendors'),
12
    (9, 'fast_cataloging', i18n('Fast cataloging')),
13
   (11, 'contracts_manage', 'Manage contracts'),
13
    (9, 'edit_items', i18n('Edit Items')),
14
   (11, 'period_manage', 'Manage periods'),
14
    (11, 'vendors_manage', i18n('Manage vendors')),
15
   (11, 'budget_manage', 'Manage budgets'),
15
    (11, 'contracts_manage', i18n('Manage contracts')),
16
   (11, 'budget_modify', 'Modify budget (can''t create lines, but can modify existing ones)'),
16
    (11, 'period_manage', i18n('Manage periods')),
17
   (11, 'planning_manage', 'Manage budget plannings'),
17
    (11, 'budget_manage', i18n('Manage budgets')),
18
   (11, 'order_manage', 'Manage orders & basket'),
18
    (11, 'budget_modify', i18n('Modify budget (can''t create lines, but can modify existing ones)')),
19
   (11, 'group_manage', 'Manage orders & basketgroups'),
19
    (11, 'planning_manage', i18n('Manage budget plannings')),
20
   (11, 'order_receive', 'Manage orders & basket'),
20
    (11, 'order_manage', i18n('Manage orders & basket')),
21
   (11, 'budget_add_del', 'Add and delete budgets (but cant modify budgets)'),
21
    (11, 'group_manage', i18n('Manage orders & basketgroups')),
22
   (11, 'budget_manage_all', 'Manage all budgets'),
22
    (11, 'order_receive', i18n('Manage orders & basket')),
23
   (13, 'edit_news', 'Write news for the OPAC and staff interfaces'),
23
    (11, 'budget_add_del', i18n('Add and delete budgets (but cant modify budgets)')),
24
   (13, 'label_creator', 'Create printable labels and barcodes from catalog and patron data'),
24
    (11, 'budget_manage_all', i18n('Manage all budgets')),
25
   (13, 'edit_calendar', 'Define days when the library is closed'),
25
    (13, 'edit_news', i18n('Write news for the OPAC and staff interfaces')),
26
   (13, 'moderate_comments', 'Moderate patron comments'),
26
    (13, 'label_creator', i18n('Create printable labels and barcodes from catalog and patron data')),
27
   (13, 'edit_notices', 'Define notices'),
27
    (13, 'edit_calendar', i18n('Define days when the library is closed')),
28
   (13, 'edit_notice_status_triggers', 'Set notice/status triggers for overdue items'),
28
    (13, 'moderate_comments', i18n('Moderate patron comments')),
29
   (13, 'edit_quotes', 'Edit quotes for quote-of-the-day feature'),
29
    (13, 'edit_notices', i18n('Define notices')),
30
   (13, 'view_system_logs', 'Browse the system logs'),
30
    (13, 'edit_notice_status_triggers', i18n('Set notice/status triggers for overdue items')),
31
   (13, 'inventory', 'Perform inventory (stocktaking) of your catalog'),
31
    (13, 'edit_quotes', i18n('Edit quotes for quote-of-the-day feature')),
32
   (13, 'stage_marc_import', 'Stage MARC records into the reservoir'),
32
    (13, 'view_system_logs', i18n('Browse the system logs')),
33
   (13, 'manage_staged_marc', 'Managed staged MARC records, including completing and reversing imports'),
33
    (13, 'inventory', i18n('Perform inventory (stocktaking) of your catalog')),
34
   (13, 'export_catalog', 'Export bibliographic and holdings data'),
34
    (13, 'stage_marc_import', i18n('Stage MARC records into the reservoir')),
35
   (13, 'import_patrons', 'Import patron data'),
35
    (13, 'manage_staged_marc', i18n('Managed staged MARC records, including completing and reversing imports')),
36
   (13, 'edit_patrons', 'Perform batch modification of patrons'),
36
    (13, 'export_catalog', i18n('Export bibliographic and holdings data')),
37
   (13, 'delete_anonymize_patrons', 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)'),
37
    (13, 'import_patrons', i18n('Import patron data')),
38
   (13, 'batch_upload_patron_images', 'Upload patron images in batch or one at a time'),
38
    (13, 'edit_patrons', i18n('Perform batch modification of patrons')),
39
   (13, 'schedule_tasks', 'Schedule tasks to run'),
39
    (13, 'delete_anonymize_patrons', i18n('Delete old borrowers and anonymize circulation history (deletes borrower reading history)')),
40
   (13, 'items_batchmod', 'Perform batch modification of items'),
40
    (13, 'batch_upload_patron_images', i18n('Upload patron images in batch or one at a time')),
41
   (13, 'items_batchdel', 'Perform batch deletion of items'),
41
    (13, 'schedule_tasks', i18n('Schedule tasks to run')),
42
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
42
    (13, 'items_batchmod', i18n('Perform batch modification of items')),
43
   (13, 'moderate_tags', 'Moderate patron tags'),
43
    (13, 'items_batchdel', i18n('Perform batch deletion of items')),
44
   (13, 'rotating_collections', 'Manage rotating collections'),
44
    (13, 'manage_csv_profiles', i18n('Manage CSV export profiles')),
45
   (13, 'upload_local_cover_images', 'Upload local cover images'),
45
    (13, 'moderate_tags', i18n('Moderate patron tags')),
46
   (15, 'check_expiration', 'Check the expiration of a serial'),
46
    (13, 'rotating_collections', i18n('Manage rotating collections')),
47
   (15, 'claim_serials', 'Claim missing serials'),
47
    (13, 'upload_local_cover_images', i18n('Upload local cover images')),
48
   (15, 'create_subscription', 'Create a new subscription'),
48
    (15, 'check_expiration', i18n('Check the expiration of a serial')),
49
   (15, 'delete_subscription', 'Delete an existing subscription'),
49
    (15, 'claim_serials', i18n('Claim missing serials')),
50
   (15, 'edit_subscription', 'Edit an existing subscription'),
50
    (15, 'create_subscription', i18n('Create a new subscription')),
51
   (15, 'receive_serials', 'Serials receiving'),
51
    (15, 'delete_subscription', i18n('Delete an existing subscription')),
52
   (15, 'renew_subscription', 'Renew a subscription'),
52
    (15, 'edit_subscription', i18n('Edit an existing subscription')),
53
   (15, 'routing', 'Routing'),
53
    (15, 'receive_serials', i18n('Serials receiving')),
54
   (16, 'execute_reports', 'Execute SQL reports'),
54
    (15, 'renew_subscription', i18n('Renew a subscription')),
55
   (16, 'create_reports', 'Create SQL Reports'),
55
    (15, 'routing', i18n('Routing')),
56
   (18, 'manage_courses', 'Add, edit and delete courses'),
56
    (16, 'execute_reports', i18n('Execute SQL reports')),
57
   (18, 'add_reserves', 'Add course reserves'),
57
    (16, 'create_reports', i18n('Create SQL Reports')),
58
   (18, 'delete_reserves', 'Remove course reserves'),
58
    (18, 'manage_courses', i18n('Add, edit and delete courses')),
59
   (19, 'manage', 'Manage plugins ( install / uninstall )'),
59
    (18, 'add_reserves', i18n('Add course reserves')),
60
   (19, 'tool', 'Use tool plugins'),
60
    (18, 'delete_reserves', i18n('Remove course reserves')),
61
   (19, 'report', 'Use report plugins'),
61
    (19, 'manage', i18n('Manage plugins ( install / uninstall )')),
62
   (19, 'configure', 'Configure plugins')
62
    (19, 'tool', i18n('Use tool plugins')),
63
;
63
    (19, 'report', i18n('Use report plugins')),
64
    (19, 'configure', i18n('Configure plugins'));
64
- 

Return to bug 10520