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

(-)a/installer/data/mysql/en/mandatory/subtag_registry.sql (-9 / +21 lines)
Lines 68-74 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
69
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'hy','hy');
71
VALUES( 'hy','arm');
72
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
Lines 164-170 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
165
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES( 'en','en');
167
VALUES( 'en','eng');
168
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'en', 'language', 'en', 'English');
170
VALUES( 'en', 'language', 'en', 'English');
Lines 172-181 VALUES( 'en', 'language', 'en', 'English'); Link Here
172
INSERT INTO language_descriptions(subtag, type, lang, description)
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
173
VALUES( 'en', 'language', 'fr', 'Anglais');
174
174
175
-- English
175
-- Finnish
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
178
178
179
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
180
VALUES( 'fi','fin');
181
179
INSERT INTO language_descriptions(subtag, type, lang, description)
182
INSERT INTO language_descriptions(subtag, type, lang, description)
180
VALUES( 'fi', 'language', 'fi', 'suomi');
183
VALUES( 'fi', 'language', 'fi', 'suomi');
181
184
Lines 187-193 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
187
VALUES ( 'fr', 'language', 'French','2005-10-16' );
190
VALUES ( 'fr', 'language', 'French','2005-10-16' );
188
191
189
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
192
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
190
VALUES( 'fr','fr');
193
VALUES( 'fr','fre');
191
194
192
INSERT INTO language_descriptions(subtag, type, lang, description)
195
INSERT INTO language_descriptions(subtag, type, lang, description)
193
VALUES( 'fr', 'language', 'en', 'French');
196
VALUES( 'fr', 'language', 'en', 'French');
Lines 202-209 VALUES( 'fr', 'language', 'fr', 'Français'); Link Here
202
INSERT INTO language_subtag_registry( subtag, type, description, added)
205
INSERT INTO language_subtag_registry( subtag, type, description, added)
203
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
206
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
204
207
205
-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
208
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
206
-- VALUES( 'lo','nor'); ???
209
VALUES( 'lo','lao');
207
210
208
INSERT INTO language_descriptions(subtag, type, lang, description)
211
INSERT INTO language_descriptions(subtag, type, lang, description)
209
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
212
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
Lines 312-318 INSERT INTO language_subtag_registry( subtag, type, description, added) Link Here
312
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
315
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
313
316
314
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
317
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
315
VALUES( 'it','ind');
318
VALUES( 'it','ita');
316
319
317
INSERT INTO language_descriptions(subtag, type, lang, description)
320
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'it', 'language', 'it', 'Italiano');
321
VALUES( 'it', 'language', 'it', 'Italiano');
Lines 371-377 VALUES( 'la', 'language', 'en', 'Latin'); Link Here
371
INSERT INTO language_descriptions(subtag, type, lang, description)
374
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'la', 'language', 'fr', 'Latin');
375
VALUES( 'la', 'language', 'fr', 'Latin');
373
376
374
-- Galacian
377
-- Galician
375
378
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
379
INSERT INTO language_subtag_registry( subtag, type, description, added)
377
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
380
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
Lines 485-490 VALUES( 'ru', 'language', 'fr', 'Russe'); Link Here
485
INSERT INTO language_subtag_registry( subtag, type, description, added)
488
INSERT INTO language_subtag_registry( subtag, type, description, added)
486
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
489
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
487
490
491
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
492
VALUES( 'sr','srp');
493
488
INSERT INTO language_descriptions(subtag, type, lang, description)
494
INSERT INTO language_descriptions(subtag, type, lang, description)
489
VALUES( 'sr', 'language', 'sr', 'српски');
495
VALUES( 'sr', 'language', 'sr', 'српски');
490
496
Lines 527-532 VALUES( 'sv', 'language', 'fr', 'Suédois'); Link Here
527
INSERT INTO language_subtag_registry( subtag, type, description, added)
533
INSERT INTO language_subtag_registry( subtag, type, description, added)
528
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
534
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
529
535
536
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
537
VALUES( 'tet','tet');
538
530
INSERT INTO language_descriptions(subtag, type, lang, description)
539
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'tet', 'language', 'tet', 'tetun');
540
VALUES( 'tet', 'language', 'tet', 'tetun');
532
541
Lines 582-591 VALUES( 'uk', 'language', 'en', 'Ukranian'); Link Here
582
INSERT INTO language_descriptions(subtag, type, lang, description)
591
INSERT INTO language_descriptions(subtag, type, lang, description)
583
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
592
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
584
593
585
-- English
594
-- Urdu
586
INSERT INTO language_subtag_registry( subtag, type, description, added)
595
INSERT INTO language_subtag_registry( subtag, type, description, added)
587
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
596
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
588
597
598
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
599
VALUES( 'ur','urd');
600
589
INSERT INTO language_descriptions(subtag, type, lang, description)
601
INSERT INTO language_descriptions(subtag, type, lang, description)
590
VALUES( 'ur', 'language', 'en', 'Urdu');
602
VALUES( 'ur', 'language', 'en', 'Urdu');
591
603
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +16 lines)
Lines 3744-3749 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
3744
    SetVersion ($DBversion);
3744
    SetVersion ($DBversion);
3745
}
3745
}
3746
3746
3747
$DBversion = '3.03.00.XXX';
3748
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
3749
    $dbh->do("UPDATE language_rfc4646_to_iso639 SET iso639_2_code='arm' WHERE rfc4646_subtag='hy';");
3750
    $dbh->do("UPDATE language_rfc4646_to_iso639 SET iso639_2_code='eng' WHERE rfc4646_subtag='en';");
3751
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'fi','fin');");
3752
    $dbh->do("UPDATE language_rfc4646_to_iso639 SET iso639_2_code='fre' WHERE rfc4646_subtag='fr';");
3753
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'lo','lao');");
3754
    $dbh->do("UPDATE language_rfc4646_to_iso639 SET iso639_2_code='it' WHERE rfc4646_subtag='ita';");
3755
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'sr','srp');");
3756
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'tet','tet');");
3757
    $dbh->do("INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES( 'ur','urd');");
3758
3759
    print "Upgrade to $DBversion done (Correct language mappings)\n";
3760
    SetVersion ($DBversion);
3761
}
3762
3747
=item DropAllForeignKeys($table)
3763
=item DropAllForeignKeys($table)
3748
3764
3749
  Drop all foreign keys of the table $table
3765
  Drop all foreign keys of the table $table
3750
- 

Return to bug 5311