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

(-)a/C4/Installer.pm (-12 / +5 lines)
Lines 24-30 our $VERSION = 3.07.00.049; Link Here
24
use C4::Context;
24
use C4::Context;
25
use C4::Installer::PerlModules;
25
use C4::Installer::PerlModules;
26
26
27
use constant GLOBAL_SQL_FOLDER => 'en';
27
use constant GLOBAL_SQL_FOLDER => 'global';
28
28
29
=head1 NAME
29
=head1 NAME
30
30
Lines 568-587 sub _load_counterpart { Link Here
568
    my $hashref;
568
    my $hashref;
569
569
570
    if( $lang =~ /de-DE/ ) { #German: no filename changes
570
    if( $lang =~ /de-DE/ ) { #German: no filename changes
571
        $hashref= {
571
        $hashref= {};
572
            'marcflavour/marc21/mandatory' => 'skip_for_now',
573
            'marcflavour/marc21/optional' => 'skip_for_now',
574
            optional => 'skip_for_now',
575
                #only de-DE/mandatory will be found for now
576
        };
577
            #this is enough to get it running without name conversions
572
            #this is enough to get it running without name conversions
578
    }
573
    }
579
    elsif( $lang eq 'en' ) { #English: no filename changes
574
    elsif( $lang eq 'en' ) { #English: no filename changes
580
        return undef; # as long as we do not have a separate global folder
575
        return undef; # not in use yet
581
576
        #The global folder contains inserts.
582
        #TODO: Should we use en as global folder? Or have a global folder too?
577
        #The en folder should have updates and serve as a translation basis.
583
        #The global folder should contain inserts.
584
        #The en folder would have updates and serve as a translation basis?
585
    }
578
    }
586
    elsif( $lang =~ /es-ES/ ) { #Spanish
579
    elsif( $lang =~ /es-ES/ ) { #Spanish
587
    }
580
    }
(-)a/installer/data/mysql/global/mandatory/auth_values.sql (+2 lines)
Line 0 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
(-)a/installer/data/mysql/global/mandatory/class_sources.sql (+36 lines)
Line 0 Link Here
1
--
2
-- Default classification sources and filing rules
3
-- for Koha.
4
--
5
-- Copyright (C) 2007 LiblimeA
6
--
7
-- This file is part of Koha.
8
--
9
-- Koha is free software; you can redistribute it and/or modify it under the
10
-- terms of the GNU General Public License as published by the Free Software
11
-- Foundation; either version 2 of the License, or (at your option) any later
12
-- version.
13
--
14
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
17
--
18
-- You should have received a copy of the GNU General Public License along
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21
22
-- class sorting (filing) rules
23
INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES
24
                               ('dewey', 'Default filing rules for DDC', 'Dewey'),
25
                               ('lcc', 'Default filing rules for LCC', 'LCC'),
26
                               ('generic', 'Generic call number filing rules', 'Generic');
27
28
29
-- classification schemes or sources
30
INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES
31
                            ('ddc', 'Dewey Decimal Classification', 1, 'dewey'),
32
                            ('lcc', 'Library of Congress Classification', 1, 'lcc'),
33
                            ('udc', 'Universal Decimal Classification', 0, 'generic'),
34
                            ('sudocs', 'SuDoc Classification (U.S. GPO)', 0, 'generic'),
35
                            ('anscr', 'ANSCR (Sound Recordings)', 0, 'generic'),
36
                            ('z', 'Other/Generic Classification Scheme', 0, 'generic');
(-)a/installer/data/mysql/global/mandatory/message_transport_types.sql (+7 lines)
Line 0 Link Here
1
INSERT INTO message_transport_types
2
(message_transport_type)
3
values
4
('email'),
5
('print'),
6
('sms'),
7
('feed');
(-)a/installer/data/mysql/global/mandatory/sample_notices.sql (+119 lines)
Line 0 Link Here
1
INSERT INTO `letter` (module, code, name, title, content)
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'),
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>'),
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.'),
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'),
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>>)'),
7
('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <<count>> items due'),
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>>)'),
9
('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <<count>> items due soon'),
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>>.'),
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>>'),
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'),
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.'),
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>>.'),
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>>).'),
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>>'),
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>>'),
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>>'),
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>>');
20
INSERT INTO `letter` (module, code, name, title, content, is_html)
21
VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '<h3><<branches.branchname>></h3>
22
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
23
(<<borrowers.cardnumber>>) <br />
24
25
<<today>><br />
26
27
<h4>Checked Out</h4>
28
<checkedout>
29
<p>
30
<<biblio.title>> <br />
31
Barcode: <<items.barcode>><br />
32
Date due: <<issues.date_due>><br />
33
</p>
34
</checkedout>
35
36
<h4>Overdues</h4>
37
<overdue>
38
<p>
39
<<biblio.title>> <br />
40
Barcode: <<items.barcode>><br />
41
Date due: <<issues.date_due>><br />
42
</p>
43
</overdue>
44
45
<hr>
46
47
<h4 style="text-align: center; font-style:italic;">News</h4>
48
<news>
49
<div class="newsitem">
50
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
51
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
52
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
53
<hr />
54
</div>
55
</news>', 1),
56
('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '<h3><<branches.branchname>></h3>
57
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
58
(<<borrowers.cardnumber>>) <br />
59
60
<<today>><br />
61
62
<h4>Checked Out Today</h4>
63
<checkedout>
64
<p>
65
<<biblio.title>> <br />
66
Barcode: <<items.barcode>><br />
67
Date due: <<issues.date_due>><br />
68
</p>
69
</checkedout>', 1),
70
('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '<h5>Date: <<today>></h5>
71
72
<h3> Transfer to/Hold in <<branches.branchname>></h3>
73
74
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
75
76
<ul>
77
    <li><<borrowers.cardnumber>></li>
78
    <li><<borrowers.phone>></li>
79
    <li> <<borrowers.address>><br />
80
         <<borrowers.address2>><br />
81
         <<borrowers.city >>  <<borrowers.zipcode>>
82
    </li>
83
    <li><<borrowers.email>></li>
84
</ul>
85
<br />
86
<h3>ITEM ON HOLD</h3>
87
<h4><<biblio.title>></h4>
88
<h5><<biblio.author>></h5>
89
<ul>
90
   <li><<items.barcode>></li>
91
   <li><<items.itemcallnumber>></li>
92
   <li><<reserves.waitingdate>></li>
93
</ul>
94
<p>Notes:
95
<pre><<reserves.reservenotes>></pre>
96
</p>
97
', 1),
98
('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '<h5>Date: <<today>></h5>
99
100
<h3>Transfer to <<branches.branchname>></h3>
101
102
<h3>ITEM</h3>
103
<h4><<biblio.title>></h4>
104
<h5><<biblio.author>></h5>
105
<ul>
106
   <li><<items.barcode>></li>
107
   <li><<items.itemcallnumber>></li>
108
</ul>', 1);
109
110
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
111
VALUES (
112
'members',  'OPAC_REG_VERIFY',  '',  'Opac Self-Registration Verification Email',  '1',  'Verify Your Account',  'Hello!
113
114
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
115
116
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
117
118
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/global/mandatory/sample_notices_message_attributes.sql (+8 lines)
Line 0 Link Here
1
insert into message_attributes
2
(message_attribute_id, message_name, takes_days)
3
values
4
(1, 'Item_Due', 0),
5
(2, 'Advance_Notice', 1),
6
(4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
(-)a/installer/data/mysql/global/mandatory/sample_notices_message_transports.sql (+17 lines)
Line 0 Link Here
1
insert into message_transports
2
(message_attribute_id, message_transport_type, is_digest, letter_module, letter_code)
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
17
(6, 'sms',   0, 'circulation', 'CHECKOUT');
(-)a/installer/data/mysql/global/mandatory/subtag_registry.sql (+897 lines)
Line 0 Link Here
1
-- http://www.w3.org/International/articles/language-tags/
2
3
-- BIDI Stuff, Arabic and Hebrew
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
5
VALUES( 'Arab', 'rtl');
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
7
VALUES( 'Hebr', 'rtl');
8
9
-- Default mappings between script and language subcodes
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
11
VALUES( 'ar', 'Arab');
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
13
VALUES( 'he', 'Hebr');
14
15
-- EXTENSIONS
16
-- Interface (i)
17
-- SELECT * FROM language_subtag_registry WHERE type='i';
18
-- OPAC
19
INSERT INTO language_subtag_registry( subtag, type, description, added)
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
21
22
INSERT INTO language_descriptions(subtag, type, lang, description)
23
VALUES( 'opac', 'i', 'en', 'OPAC');
24
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
27
28
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
31
32
INSERT INTO language_descriptions(subtag, type, lang, description)
33
VALUES( 'intranet', 'i', 'en', 'Staff Client');
34
35
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'fr', '????');
37
38
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
41
42
INSERT INTO language_descriptions(subtag, type, lang, description)
43
VALUES( 'prog', 't', 'en', 'Prog');
44
45
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 't', 'fr', 'Prog');
47
48
-- LANGUAGES
49
50
-- Arabic
51
INSERT INTO language_subtag_registry( subtag, type, description, added)
52
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
53
54
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
55
VALUES( 'ar','ara');
56
57
INSERT INTO language_descriptions(subtag, type, lang, description)
58
VALUES ( 'ar', 'language', 'ar', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
59
60
INSERT INTO language_descriptions(subtag, type, lang, description)
61
VALUES( 'ar', 'language', 'en', 'Arabic');
62
63
INSERT INTO language_descriptions(subtag, type, lang, description)
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES( 'ar', 'language', 'de', 'Arabisch');
68
69
-- Armenian
70
INSERT INTO language_subtag_registry( subtag, type, description, added)
71
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
72
73
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
74
VALUES( 'hy','arm');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES ( 'hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'en', 'Armenian');
81
82
INSERT INTO language_descriptions(subtag, type, lang, description)
83
VALUES( 'hy', 'language', 'fr', 'Armenian');
84
85
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES( 'hy', 'language', 'de', 'Armenisch');
87
88
-- Bulgarian
89
INSERT INTO language_subtag_registry( subtag, type, description, added)
90
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
91
92
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
93
VALUES( 'bg','bul');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES ( 'bg', 'language', 'bg', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;');
97
98
INSERT INTO language_descriptions(subtag, type, lang, description)
99
VALUES( 'bg', 'language', 'en', 'Bulgarian');
100
101
INSERT INTO language_descriptions(subtag, type, lang, description)
102
VALUES( 'bg', 'language', 'fr', 'Bulgare');
103
104
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
106
107
-- Chinese
108
INSERT INTO language_subtag_registry( subtag, type, description, added)
109
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
110
111
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
112
VALUES( 'zh','chi');
113
114
INSERT INTO language_descriptions(subtag, type, lang, description)
115
VALUES ( 'zh', 'language', 'zh', '&#20013;&#25991;');
116
117
INSERT INTO language_descriptions(subtag, type, lang, description)
118
VALUES( 'zh', 'language', 'en', 'Chinese');
119
120
INSERT INTO language_descriptions(subtag, type, lang, description)
121
VALUES( 'zh', 'language', 'fr', 'Chinois');
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES( 'zh', 'language', 'de', 'Chinesisch');
125
126
-- Czech
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
128
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
129
130
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
131
VALUES( 'cs','cze');
132
133
INSERT INTO language_descriptions(subtag, type, lang, description)
134
VALUES ( 'cs', 'language', 'cs', '&#x010D;e&#353;tina');
135
136
INSERT INTO language_descriptions(subtag, type, lang, description)
137
VALUES( 'cs', 'language', 'en', 'Czech');
138
139
INSERT INTO language_descriptions(subtag, type, lang, description)
140
VALUES( 'cs', 'language', 'fr', 'Tchèque');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES( 'cs', 'language', 'de', 'Tschechisch');
144
145
-- Danish
146
INSERT INTO language_subtag_registry( subtag, type, description, added)
147
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
148
149
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
150
VALUES( 'da','dan');
151
152
INSERT INTO language_descriptions(subtag, type, lang, description)
153
VALUES ( 'da', 'language', 'da', 'Dansk');
154
155
INSERT INTO language_descriptions(subtag, type, lang, description)
156
VALUES( 'da', 'language', 'en', 'Danish');
157
158
INSERT INTO language_descriptions(subtag, type, lang, description)
159
VALUES( 'da', 'language', 'fr', 'Danois');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'da', 'language', 'de', 'Dänisch');
163
164
-- Dutch, Flemish
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
166
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
167
168
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
169
VALUES( 'nl','dut');
170
171
INSERT INTO language_descriptions(subtag, type, lang, description)
172
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
173
174
INSERT INTO language_descriptions(subtag, type, lang, description)
175
VALUES( 'nl', 'language', 'en', 'Dutch');
176
177
INSERT INTO language_descriptions(subtag, type, lang, description)
178
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES( 'nl', 'language', 'de', 'Niederländisch');
182
183
-- English
184
INSERT INTO language_subtag_registry( subtag, type, description, added)
185
VALUES ( 'en', 'language', 'English','2005-10-16' );
186
187
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
188
VALUES( 'en','eng');
189
190
INSERT INTO language_descriptions(subtag, type, lang, description)
191
VALUES( 'en', 'language', 'en', 'English');
192
193
INSERT INTO language_descriptions(subtag, type, lang, description)
194
VALUES( 'en', 'language', 'fr', 'Anglais');
195
196
INSERT INTO language_descriptions(subtag, type, lang, description)
197
VALUES( 'en', 'language', 'de', 'Englisch');
198
199
-- Finnish
200
INSERT INTO language_subtag_registry( subtag, type, description, added)
201
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
202
203
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
204
VALUES( 'fi','fin');
205
206
INSERT INTO language_descriptions(subtag, type, lang, description)
207
VALUES( 'fi', 'language', 'fi', 'suomi');
208
209
INSERT INTO language_descriptions(subtag, type, lang, description)
210
VALUES( 'fi', 'language', 'en', 'Finnish');
211
212
INSERT INTO language_descriptions(subtag, type, lang, description)
213
VALUES( 'fi', 'language', 'de', 'Finnisch');
214
215
-- French
216
INSERT INTO language_subtag_registry( subtag, type, description, added)
217
VALUES ( 'fr', 'language', 'French','2005-10-16' );
218
219
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
220
VALUES( 'fr','fre');
221
222
INSERT INTO language_descriptions(subtag, type, lang, description)
223
VALUES( 'fr', 'language', 'en', 'French');
224
225
INSERT INTO language_descriptions(subtag, type, lang, description)
226
VALUES( 'fr', 'language', 'fr', 'Fran&ccedil;ais');
227
228
INSERT INTO language_descriptions(subtag, type, lang, description)
229
VALUES( 'fr', 'language', 'de', 'Französisch');
230
231
-- INSERT INTO language_descriptions(subtag, type, lang, description)
232
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'fran&ccedil;ais');
233
234
-- Lao
235
INSERT INTO language_subtag_registry( subtag, type, description, added)
236
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
237
238
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
239
VALUES( 'lo','lao');
240
241
INSERT INTO language_descriptions(subtag, type, lang, description)
242
VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
243
244
INSERT INTO language_descriptions(subtag, type, lang, description)
245
VALUES( 'lo', 'language', 'en', 'Lao');
246
247
INSERT INTO language_descriptions(subtag, type, lang, description)
248
VALUES( 'lo', 'language', 'fr', 'Laotien');
249
250
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'de', 'Laotisch');
252
253
-- German
254
INSERT INTO language_subtag_registry( subtag, type, description, added)
255
VALUES ( 'de', 'language', 'German','2005-10-16' );
256
257
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
258
VALUES( 'de','ger');
259
260
INSERT INTO language_descriptions(subtag, type, lang, description)
261
VALUES( 'de', 'language', 'de', 'Deutsch');
262
263
INSERT INTO language_descriptions(subtag, type, lang, description)
264
VALUES( 'de', 'language', 'en', 'German');
265
266
INSERT INTO language_descriptions(subtag, type, lang, description)
267
VALUES( 'de', 'language', 'fr', 'Allemand');
268
269
-- Greek
270
INSERT INTO language_subtag_registry( subtag, type, description, added)
271
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
272
273
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
274
VALUES( 'el','gre');
275
276
INSERT INTO language_descriptions(subtag, type, lang, description)
277
VALUES( 'el', 'language', 'el', '&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;');
278
279
INSERT INTO language_descriptions(subtag, type, lang, description)
280
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
281
282
INSERT INTO language_descriptions(subtag, type, lang, description)
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
287
288
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
290
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
291
292
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
293
VALUES( 'he','heb');
294
295
INSERT INTO language_descriptions(subtag, type, lang, description)
296
VALUES( 'he', 'language', 'he', '&#1506;&#1489;&#1512;&#1497;&#1514;');
297
298
INSERT INTO language_descriptions(subtag, type, lang, description)
299
VALUES( 'he', 'language', 'en', 'Hebrew');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'he', 'language', 'fr', 'Hébreu');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'de', 'Hebräisch');
306
307
-- Hindi
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
309
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
310
311
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
312
VALUES( 'hi','hin');
313
314
INSERT INTO language_descriptions(subtag, type, lang, description)
315
VALUES( 'hi', 'language', 'hi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'hi', 'language', 'en', 'Hindi');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'hi', 'language', 'fr', 'Hindi');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'de', 'Hindi');
325
326
-- Hungarian
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'hu','hun');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'hu', 'language', 'hu', 'Magyar');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'hu', 'language', 'en', 'Hungarian');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'hu', 'language', 'fr', 'Hongrois');
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'de', 'Ungarisch');
344
345
-- Indonesian
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
347
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
348
349
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
350
VALUES( 'id','ind');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'id', 'language', 'en', 'Indonesian');
357
358
INSERT INTO language_descriptions(subtag, type, lang, description)
359
VALUES( 'id', 'language', 'fr', 'Indonésien');
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'de', 'Indonesisch');
363
364
-- Italian
365
INSERT INTO language_subtag_registry( subtag, type, description, added)
366
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
367
368
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
369
VALUES( 'it','ita');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'it', 'language', 'it', 'Italiano');
373
374
INSERT INTO language_descriptions(subtag, type, lang, description)
375
VALUES( 'it', 'language', 'en', 'Italian');
376
377
INSERT INTO language_descriptions(subtag, type, lang, description)
378
VALUES( 'it', 'language', 'fr', 'Italien');
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'de', 'Italienisch');
382
383
-- Japanese
384
INSERT INTO language_subtag_registry( subtag, type, description, added)
385
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
386
387
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
388
VALUES( 'ja','jpn');
389
390
INSERT INTO language_descriptions(subtag, type, lang, description)
391
VALUES( 'ja', 'language', 'ja', '&#26085;&#26412;&#35486;');
392
393
INSERT INTO language_descriptions(subtag, type, lang, description)
394
VALUES( 'ja', 'language', 'en', 'Japanese');
395
396
INSERT INTO language_descriptions(subtag, type, lang, description)
397
VALUES( 'ja', 'language', 'fr', 'Japonais');
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'de', 'Japanisch');
401
402
-- Korean
403
INSERT INTO language_subtag_registry( subtag, type, description, added)
404
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
405
406
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
407
VALUES( 'ko','kor');
408
409
INSERT INTO language_descriptions(subtag, type, lang, description)
410
VALUES( 'ko', 'language', 'ko', '&#54620;&#44397;&#50612;');
411
412
INSERT INTO language_descriptions(subtag, type, lang, description)
413
VALUES( 'ko', 'language', 'en', 'Korean');
414
415
INSERT INTO language_descriptions(subtag, type, lang, description)
416
VALUES( 'ko', 'language', 'fr', 'Coréen');
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'de', 'Koreanisch');
420
421
-- Latin
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
423
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
424
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
426
VALUES( 'la','lat');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES( 'la', 'language', 'la', 'Latina');
430
431
INSERT INTO language_descriptions(subtag, type, lang, description)
432
VALUES( 'la', 'language', 'en', 'Latin');
433
434
INSERT INTO language_descriptions(subtag, type, lang, description)
435
VALUES( 'la', 'language', 'fr', 'Latin');
436
437
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'de', 'Latein');
439
440
-- Galician
441
442
INSERT INTO language_subtag_registry( subtag, type, description, added)
443
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
444
445
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
446
VALUES( 'gl','glg');
447
448
INSERT INTO language_descriptions(subtag, type, lang, description)
449
VALUES( 'gl', 'language', 'gl', 'Galego');
450
451
INSERT INTO language_descriptions(subtag, type, lang, description)
452
VALUES( 'gl', 'language', 'en', 'Galician');
453
454
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
457
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
460
461
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
462
VALUES( 'nb','nor');
463
464
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
465
VALUES( 'nb','nob');
466
467
INSERT INTO language_descriptions(subtag, type, lang, description)
468
VALUES( 'nb', 'language', 'nb', 'Norsk bokm&#229;l');
469
470
INSERT INTO language_descriptions(subtag, type, lang, description)
471
VALUES( 'nb', 'language', 'en', 'Norwegian bokm&#229;l');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES( 'nb', 'language', 'fr', 'Norvégien bokm&#229;l');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;l');
478
479
-- Norwegian (nynorsk)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
481
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
482
483
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
484
VALUES( 'nn','nno');
485
486
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
491
492
INSERT INTO language_descriptions(subtag, type, lang, description)
493
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
494
495
INSERT INTO language_descriptions(subtag, type, lang, description)
496
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
497
498
INSERT INTO language_descriptions(subtag, type, lang, description)
499
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
500
501
-- Persian
502
INSERT INTO language_subtag_registry( subtag, type, description, added)
503
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
504
505
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
506
VALUES( 'fa','per');
507
508
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'fa', 'language', 'fa', '&#1601;&#1575;&#1585;&#1587;&#1609;');
510
511
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'fa', 'language', 'en', 'Persian');
513
514
INSERT INTO language_descriptions(subtag, type, lang, description)
515
VALUES( 'fa', 'language', 'fr', 'Persan');
516
517
INSERT INTO language_descriptions(subtag, type, lang, description)
518
VALUES( 'fa', 'language', 'de', 'Persisch');
519
520
-- Polish
521
INSERT INTO language_subtag_registry( subtag, type, description, added)
522
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
523
524
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
525
VALUES( 'pl','pol');
526
527
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'pl', 'language', 'pl', 'Polski');
529
530
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'pl', 'language', 'en', 'Polish');
532
533
INSERT INTO language_descriptions(subtag, type, lang, description)
534
VALUES( 'pl', 'language', 'fr', 'Polonais');
535
536
INSERT INTO language_descriptions(subtag, type, lang, description)
537
VALUES( 'pl', 'language', 'de', 'Polnisch');
538
539
-- Portuguese
540
INSERT INTO language_subtag_registry( subtag, type, description, added)
541
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
542
543
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
544
VALUES( 'pt','por');
545
546
INSERT INTO language_descriptions(subtag, type, lang, description)
547
VALUES( 'pt', 'language', 'pt', 'Portugu&ecirc;s');
548
549
INSERT INTO language_descriptions(subtag, type, lang, description)
550
VALUES( 'pt', 'language', 'en', 'Portuguese');
551
552
INSERT INTO language_descriptions(subtag, type, lang, description)
553
VALUES( 'pt', 'language', 'fr', 'Portugais');
554
555
INSERT INTO language_descriptions(subtag, type, lang, description)
556
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
557
558
-- Romanian
559
INSERT INTO language_subtag_registry( subtag, type, description, added)
560
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
561
562
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
563
VALUES( 'ro','rum');
564
565
INSERT INTO language_descriptions(subtag, type, lang, description)
566
VALUES( 'ro', 'language', 'ro', 'Rom&acirc;n&#259;');
567
568
INSERT INTO language_descriptions(subtag, type, lang, description)
569
VALUES( 'ro', 'language', 'en', 'Romanian');
570
571
INSERT INTO language_descriptions(subtag, type, lang, description)
572
VALUES( 'ro', 'language', 'fr', 'Roumain');
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'ro', 'language', 'de', 'Rumänisch');
576
577
-- Russian
578
INSERT INTO language_subtag_registry( subtag, type, description, added)
579
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
580
581
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
582
VALUES( 'ru','rus');
583
584
INSERT INTO language_descriptions(subtag, type, lang, description)
585
VALUES( 'ru', 'language', 'ru', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'ru', 'language', 'en', 'Russian');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'ru', 'language', 'fr', 'Russe');
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'ru', 'language', 'de', 'Russisch');
595
596
-- Serbian
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'sr','srp');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'sr', 'language', 'sr', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'sr', 'language', 'en', 'Serbian');
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'sr', 'language', 'fr', 'Serbe');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'sr', 'language', 'de', 'Serbisch');
614
615
-- Spanish, Castilian
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
617
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
618
619
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
620
VALUES( 'es','spa');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'es', 'language', 'es', 'Espa&ntilde;ol');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'es', 'language', 'en', 'Spanish');
627
628
INSERT INTO language_descriptions(subtag, type, lang, description)
629
VALUES( 'es', 'language', 'fr', 'Espagnol');
630
631
INSERT INTO language_descriptions(subtag, type, lang, description)
632
VALUES( 'es', 'language', 'de', 'Spanisch');
633
634
-- Spanish, Catalan
635
INSERT INTO language_subtag_registry( subtag, type, description, added)
636
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
637
638
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
639
VALUES( 'ca','cat');
640
641
INSERT INTO language_descriptions(subtag, type, lang, description)
642
VALUES( 'ca', 'language', 'es', 'Catalán');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES( 'ca', 'language', 'en', 'Catalan');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'ca', 'language', 'fr', 'Catalan');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'ca', 'language', 'ca', 'Català');
652
653
INSERT INTO language_descriptions(subtag, type, lang, description)
654
VALUES( 'ca', 'language', 'de', 'Katalanisch');
655
656
-- Swedish
657
INSERT INTO language_subtag_registry( subtag, type, description, added)
658
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
659
660
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
661
VALUES( 'sv','swe');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'sv', 'language', 'sv', 'Svenska');
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'sv', 'language', 'en', 'Swedish');
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES( 'sv', 'language', 'fr', 'Suédois');
671
672
INSERT INTO language_descriptions(subtag, type, lang, description)
673
VALUES( 'sv', 'language', 'de', 'Schwedisch');
674
675
-- Tetum
676
INSERT INTO language_subtag_registry( subtag, type, description, added)
677
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
678
679
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
680
VALUES( 'tet','tet');
681
682
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES( 'tet', 'language', 'tet', 'tetun');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'tet', 'language', 'en', 'Tetum');
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'tet', 'language', 'fr', 'Tétoum');
690
691
INSERT INTO language_descriptions(subtag, type, lang, description)
692
VALUES( 'tet', 'language', 'de', 'Tetum');
693
694
-- Thai
695
INSERT INTO language_subtag_registry( subtag, type, description, added)
696
VALUES ( 'th', 'language', 'Thai','2005-10-16');
697
698
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
699
VALUES( 'th','tha');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'th', 'language', 'th', '&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;');
703
704
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES( 'th', 'language', 'en', 'Thai');
706
707
INSERT INTO language_descriptions(subtag, type, lang, description)
708
VALUES( 'th', 'language', 'fr', 'Thaï');
709
710
INSERT INTO language_descriptions(subtag, type, lang, description)
711
VALUES( 'th', 'language', 'de', 'Thailändisch');
712
713
-- Turkish
714
INSERT INTO language_subtag_registry( subtag, type, description, added)
715
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
716
717
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
718
VALUES( 'tr','tur');
719
720
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES( 'tr', 'language', 'tr', 'T&uuml;rk&ccedil;e');
722
723
INSERT INTO language_descriptions(subtag, type, lang, description)
724
VALUES( 'tr', 'language', 'en', 'Turkish');
725
726
INSERT INTO language_descriptions(subtag, type, lang, description)
727
VALUES( 'tr', 'language', 'fr', 'Turc');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'tr', 'language', 'de', 'Türkisch');
731
732
-- Ukranian
733
INSERT INTO language_subtag_registry( subtag, type, description, added)
734
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
735
736
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
737
VALUES( 'uk','ukr');
738
739
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES( 'uk', 'language', 'uk', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;');
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'uk', 'language', 'en', 'Ukranian');
744
745
INSERT INTO language_descriptions(subtag, type, lang, description)
746
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
747
748
INSERT INTO language_descriptions(subtag, type, lang, description)
749
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
750
751
-- Urdu
752
INSERT INTO language_subtag_registry( subtag, type, description, added)
753
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
754
755
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
756
VALUES( 'ur','urd');
757
758
INSERT INTO language_descriptions(subtag, type, lang, description)
759
VALUES( 'ur', 'language', 'en', 'Urdu');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES( 'ur', 'language', 'ur', '&#1575;&#1585;&#1583;&#1608;');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'ur', 'language', 'fr', 'Ourdou');
766
767
INSERT INTO language_descriptions(subtag, type, lang, description)
768
VALUES( 'ur', 'language', 'de', 'Urdu');
769
770
-- SCRIPTS
771
-- Arabic
772
INSERT INTO language_subtag_registry( subtag, type, description, added)
773
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
774
775
INSERT INTO language_descriptions(subtag, type, lang, description)
776
VALUES ( 'Arab','script', 'Arab', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'Arab', 'script','en', 'Arabic');
780
781
INSERT INTO language_descriptions(subtag, type, lang, description)
782
VALUES( 'Arab', 'script','fr', 'Arabic');
783
784
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
787
788
INSERT INTO language_descriptions(subtag, type, lang, description)
789
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
790
791
INSERT INTO language_descriptions(subtag, type, lang, description)
792
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
793
794
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
796
797
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
800
801
INSERT INTO language_descriptions(subtag, type, lang, description)
802
VALUES ( 'Grek', 'script', 'Grek', '????');
803
804
INSERT INTO language_descriptions(subtag, type, lang, description)
805
VALUES( 'Grek', 'script', 'en', 'Greek');
806
807
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
809
810
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
813
814
INSERT INTO language_descriptions(subtag, type, lang, description)
815
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
816
817
INSERT INTO language_descriptions(subtag, type, lang, description)
818
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
819
820
INSERT INTO language_descriptions(subtag, type, lang, description)
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
822
823
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
826
827
INSERT INTO language_descriptions(subtag, type, lang, description)
828
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
832
833
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
836
837
INSERT INTO language_descriptions(subtag, type, lang, description)
838
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
839
840
INSERT INTO language_descriptions(subtag, type, lang, description)
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
842
843
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
849
850
INSERT INTO language_descriptions(subtag, type, lang, description)
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
852
853
-- REGIONS
854
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
856
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
857
858
INSERT INTO language_descriptions(subtag, type, lang, description)
859
VALUES( 'CA', 'region', 'en', 'Canada');
860
861
-- Denmark
862
INSERT INTO language_subtag_registry( subtag, type, description, added)
863
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
864
865
INSERT INTO language_descriptions(subtag, type, lang, description)
866
VALUES( 'DK', 'region', 'dk', 'Danmark');
867
868
-- France
869
INSERT INTO language_subtag_registry( subtag, type, description, added)
870
VALUES ( 'FR', 'region', 'France','2005-10-16');
871
872
INSERT INTO language_descriptions(subtag, type, lang, description)
873
VALUES ( 'FR', 'region', 'fr', 'France');
874
875
INSERT INTO language_descriptions(subtag, type, lang, description)
876
VALUES( 'FR', 'region', 'en', 'France');
877
878
-- New Zealand
879
INSERT INTO language_subtag_registry( subtag, type, description, added)
880
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
881
882
INSERT INTO language_descriptions(subtag, type, lang, description)
883
VALUES( 'NZ', 'region', 'en', 'New Zealand');
884
885
-- United Kingdom
886
INSERT INTO language_subtag_registry( subtag, type, description, added)
887
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
888
889
INSERT INTO language_descriptions(subtag, type, lang, description)
890
VALUES( 'GB', 'region', 'en', 'United Kingdom');
891
892
-- United States
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
894
VALUES ( 'US', 'region', 'United States','2005-10-16');
895
896
INSERT INTO language_descriptions(subtag, type, lang, description)
897
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/global/mandatory/userflags.sql (+20 lines)
Line 0 Link Here
1
INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
2
(0,'superlibrarian','Access to all librarian functions',0),
3
(1,'circulate','Check out and check in items',0),
4
(2,'catalogue','<b>Required for staff login.</b> Staff access, allows viewing of catalogue in staff client.',0),
5
(3,'parameters','Manage Koha system settings (Administration panel)',0),
6
(4,'borrowers','Add or modify patrons',0),
7
(5,'permissions','Set user permissions',0),
8
(6,'reserveforothers','Place and modify holds for patrons',0),
9
(7,'borrow','Borrow books',1),
10
(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0),
11
(10,'updatecharges','Manage patrons fines and fees',0),
12
(11,'acquisition','Acquisition and/or suggestion management',0),
13
(12,'management','Set library management parameters (deprecated)',0),
14
(13,'tools','Use all tools (expand for granular tools permissions)',0),
15
(14,'editauthorities','Edit Authorities',0),
16
(15,'serials','Manage serial subscriptions',0),
17
(16,'reports','Allow access to the reports module',0),
18
(17,'staffaccess','Allow staff members to modify permissions for other staff members',0),
19
(18,'coursereserves','Course Reserves',0),
20
(19, 'plugins', 'Koha plugins', '0');
(-)a/installer/data/mysql/global/mandatory/userpermissions.sql (-1 / +62 lines)
Line 0 Link Here
0
- 
1
INSERT INTO permissions (module_bit, code, description) VALUES
2
   ( 1, 'circulate_remaining_permissions', 'Remaining circulation permissions'),
3
   ( 1, 'override_renewals', 'Override blocked renewals'),
4
   ( 1, 'overdues_report', 'Execute overdue items report'),
5
   ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'),
6
   ( 3, 'manage_circ_rules', 'manage circulation rules'),
7
   ( 6, 'place_holds', 'Place holds for patrons'),
8
   ( 6, 'modify_holds_priority', 'Modify holds priority'),
9
   ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'),
10
   ( 9, 'fast_cataloging', 'Fast cataloging'),
11
   ( 9, 'edit_items', 'Edit Items'),
12
   (11, 'vendors_manage', 'Manage vendors'),
13
   (11, 'contracts_manage', 'Manage contracts'),
14
   (11, 'period_manage', 'Manage periods'),
15
   (11, 'budget_manage', 'Manage budgets'),
16
   (11, 'budget_modify', 'Modify budget (can''t create lines, but can modify existing ones)'),
17
   (11, 'planning_manage', 'Manage budget plannings'),
18
   (11, 'order_manage', 'Manage orders & basket'),
19
   (11, 'group_manage', 'Manage orders & basketgroups'),
20
   (11, 'order_receive', 'Manage orders & basket'),
21
   (11, 'budget_add_del', 'Add and delete budgets (but cant modify budgets)'),
22
   (11, 'budget_manage_all', 'Manage all budgets'),
23
   (13, 'edit_news', 'Write news for the OPAC and staff interfaces'),
24
   (13, 'label_creator', 'Create printable labels and barcodes from catalog and patron data'),
25
   (13, 'edit_calendar', 'Define days when the library is closed'),
26
   (13, 'moderate_comments', 'Moderate patron comments'),
27
   (13, 'edit_notices', 'Define notices'),
28
   (13, 'edit_notice_status_triggers', 'Set notice/status triggers for overdue items'),
29
   (13, 'edit_quotes', 'Edit quotes for quote-of-the-day feature'),
30
   (13, 'view_system_logs', 'Browse the system logs'),
31
   (13, 'inventory', 'Perform inventory (stocktaking) of your catalog'),
32
   (13, 'stage_marc_import', 'Stage MARC records into the reservoir'),
33
   (13, 'manage_staged_marc', 'Managed staged MARC records, including completing and reversing imports'),
34
   (13, 'export_catalog', 'Export bibliographic and holdings data'),
35
   (13, 'import_patrons', 'Import patron data'),
36
   (13, 'edit_patrons', 'Perform batch modification of patrons'),
37
   (13, 'delete_anonymize_patrons', 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)'),
38
   (13, 'batch_upload_patron_images', 'Upload patron images in batch or one at a time'),
39
   (13, 'schedule_tasks', 'Schedule tasks to run'),
40
   (13, 'items_batchmod', 'Perform batch modification of items'),
41
   (13, 'items_batchdel', 'Perform batch deletion of items'),
42
   (13, 'manage_csv_profiles', 'Manage CSV export profiles'),
43
   (13, 'moderate_tags', 'Moderate patron tags'),
44
   (13, 'rotating_collections', 'Manage rotating collections'),
45
   (13, 'upload_local_cover_images', 'Upload local cover images'),
46
   (15, 'check_expiration', 'Check the expiration of a serial'),
47
   (15, 'claim_serials', 'Claim missing serials'),
48
   (15, 'create_subscription', 'Create a new subscription'),
49
   (15, 'delete_subscription', 'Delete an existing subscription'),
50
   (15, 'edit_subscription', 'Edit an existing subscription'),
51
   (15, 'receive_serials', 'Serials receiving'),
52
   (15, 'renew_subscription', 'Renew a subscription'),
53
   (15, 'routing', 'Routing'),
54
   (16, 'execute_reports', 'Execute SQL reports'),
55
   (16, 'create_reports', 'Create SQL Reports'),
56
   (18, 'manage_courses', 'Add, edit and delete courses'),
57
   (18, 'add_reserves', 'Add course reserves'),
58
   (18, 'delete_reserves', 'Remove course reserves'),
59
   (19, 'manage', 'Manage plugins ( install / uninstall )'),
60
   (19, 'tool', 'Use tool plugins'),
61
   (19, 'report', 'Use report plugins'),
62
   (19, 'configure', 'Configure plugins');

Return to bug 10509