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

(-)a/installer/data/mysql/atomicupdate/bug_31715_de-languages.pl (+52 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "31715",
5
    description => "Add missing German (de) language translations",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'am', 'language', 'de', 'Amharisch') });
11
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'az', 'language', 'de', 'Aserbaidschanisch') });
12
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'be', 'language', 'de', 'Belarussisch') });
13
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'bn', 'language', 'de', 'Bengalisch') });
14
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'eu', 'language', 'de', 'Baskisch') });
15
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'fo', 'language', 'de', 'Färöisch') });
16
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'is', 'language', 'de', 'Isländisch') });
17
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
18
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
19
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mn', 'language', 'de', 'Mongolisch') });
20
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mr', 'language', 'de', 'Marathi') });
21
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ms', 'language', 'de', 'Malaiisch') });
22
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ne', 'language', 'de', 'Nepali') });
23
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'pbr', 'language', 'de', 'Pangwa') });
24
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'prs', 'language', 'de', 'Dari') });
25
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'rw', 'language', 'de', 'Kinyarwanda') });
26
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sd', 'language', 'de', 'Sindhi') });
27
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sk', 'language', 'de', 'Slowakisch') });
28
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sl', 'language', 'de', 'Slowenisch') });
29
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sq', 'language', 'de', 'Albanisch') });
30
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sw', 'language', 'de', 'Swahili') });
31
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ta', 'language', 'de', 'Tamil') });
32
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'tl', 'language', 'de', 'Tagalog') });
33
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Armn', 'script', 'de', 'Armenisch') });
34
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Ethi', 'script', 'en', 'Äthiopisch') });
35
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Jpan', 'script', 'de', 'Japanisch') });
36
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Knda', 'script', 'de', 'Kannada') });
37
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Kore', 'script', 'de', 'Koreanisch') });
38
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'de', 'Estnisch') });
39
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'de', 'Lettisch') });
40
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'de', 'Litauisch') });
41
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'de', 'Inuktitut') });
42
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'de', 'Inupiaq') });
43
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'cr', 'language', 'de', 'Cree') });
44
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'af', 'language', 'de', 'Afrikaans') });
45
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mul', 'language', 'de', 'Mehrsprachig') });
46
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'und', 'language', 'de', 'Unbestimmt') });
47
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'zxx', 'language', 'de', 'Kein sprachlicher Inhalt') });
48
49
        # Print useful stuff here
50
        say $out "German (de) translations were added";
51
    },
52
};
(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-2 / +115 lines)
Lines 69-74 VALUES ( 'am', 'language', 'am', 'አማርኛ'); Link Here
69
INSERT INTO language_descriptions(subtag, type, lang, description)
69
INSERT INTO language_descriptions(subtag, type, lang, description)
70
VALUES ( 'am', 'language', 'en', 'Amharic');
70
VALUES ( 'am', 'language', 'en', 'Amharic');
71
71
72
INSERT INTO language_descriptions(subtag, type, lang, description)
73
VALUES ( 'am', 'language', 'de', 'Amharisch');
74
72
-- Arabic
75
-- Arabic
73
INSERT INTO language_subtag_registry( subtag, type, description, added)
76
INSERT INTO language_subtag_registry( subtag, type, description, added)
74
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
77
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
Lines 101-106 VALUES ( 'az', 'language', 'az', 'Azərbaycan dili'); Link Here
101
INSERT INTO language_descriptions(subtag, type, lang, description)
104
INSERT INTO language_descriptions(subtag, type, lang, description)
102
VALUES ( 'az', 'language', 'en', 'Azerbaijani');
105
VALUES ( 'az', 'language', 'en', 'Azerbaijani');
103
106
107
INSERT INTO language_descriptions(subtag, type, lang, description)
108
VALUES ( 'az', 'language', 'de', 'Aserbaidschanisch');
109
104
-- Byelorussian
110
-- Byelorussian
105
INSERT INTO language_subtag_registry( subtag, type, description, added)
111
INSERT INTO language_subtag_registry( subtag, type, description, added)
106
VALUES ( 'be', 'language', 'Byelorussian','2014-10-30');
112
VALUES ( 'be', 'language', 'Byelorussian','2014-10-30');
Lines 114-119 VALUES ( 'be', 'language', 'be', 'Беларуская мова'); Link Here
114
INSERT INTO language_descriptions(subtag, type, lang, description)
120
INSERT INTO language_descriptions(subtag, type, lang, description)
115
VALUES ( 'be', 'language', 'en', 'Byelorussian');
121
VALUES ( 'be', 'language', 'en', 'Byelorussian');
116
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES ( 'be', 'language', 'de', 'Belarussisch');
125
117
-- Bengali
126
-- Bengali
118
INSERT INTO language_subtag_registry( subtag, type, description, added)
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
119
VALUES ( 'bn', 'language', 'Bengali','2014-10-30');
128
VALUES ( 'bn', 'language', 'Bengali','2014-10-30');
Lines 127-132 VALUES ( 'bn', 'language', 'bn', 'বাংলা'); Link Here
127
INSERT INTO language_descriptions(subtag, type, lang, description)
136
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES ( 'bn', 'language', 'en', 'Bengali');
137
VALUES ( 'bn', 'language', 'en', 'Bengali');
129
138
139
INSERT INTO language_descriptions(subtag, type, lang, description)
140
VALUES ( 'bn', 'language', 'de', 'Bengalisch');
141
130
-- Bulgarian
142
-- Bulgarian
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
143
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
144
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
Lines 289-294 VALUES ( 'eu', 'language', 'eu', 'Euskera'); Link Here
289
INSERT INTO language_descriptions(subtag, type, lang, description)
301
INSERT INTO language_descriptions(subtag, type, lang, description)
290
VALUES ( 'eu', 'language', 'en', 'Basque');
302
VALUES ( 'eu', 'language', 'en', 'Basque');
291
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES ( 'eu', 'language', 'de', 'Baskisch');
306
292
-- Persian
307
-- Persian
293
INSERT INTO language_subtag_registry( subtag, type, description, added)
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
294
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
309
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
Lines 337-342 VALUES ( 'fo', 'language', 'fo', 'Føroyskt'); Link Here
337
INSERT INTO language_descriptions(subtag, type, lang, description)
352
INSERT INTO language_descriptions(subtag, type, lang, description)
338
VALUES ( 'fo', 'language', 'en', 'Faroese');
353
VALUES ( 'fo', 'language', 'en', 'Faroese');
339
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES ( 'fo', 'language', 'de', 'Färöisch');
357
340
-- French
358
-- French
341
INSERT INTO language_subtag_registry( subtag, type, description, added)
359
INSERT INTO language_subtag_registry( subtag, type, description, added)
342
VALUES ( 'fr', 'language', 'French','2005-10-16' );
360
VALUES ( 'fr', 'language', 'French','2005-10-16' );
Lines 499-504 VALUES ( 'is', 'language', 'is', 'Íslenska'); Link Here
499
INSERT INTO language_descriptions(subtag, type, lang, description)
517
INSERT INTO language_descriptions(subtag, type, lang, description)
500
VALUES ( 'is', 'language', 'en', 'Icelandic');
518
VALUES ( 'is', 'language', 'en', 'Icelandic');
501
519
520
INSERT INTO language_descriptions(subtag, type, lang, description)
521
VALUES ( 'is', 'language', 'de', 'Isländisch');
522
502
-- Italian
523
-- Italian
503
INSERT INTO language_subtag_registry( subtag, type, description, added)
524
INSERT INTO language_subtag_registry( subtag, type, description, added)
504
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
525
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
Lines 585-590 VALUES ( 'km', 'language', 'km', 'ភាសាខ្មែរ'); Link Here
585
INSERT INTO language_descriptions(subtag, type, lang, description)
606
INSERT INTO language_descriptions(subtag, type, lang, description)
586
VALUES( 'km', 'language', 'en', 'Khmer');
607
VALUES( 'km', 'language', 'en', 'Khmer');
587
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES ( 'km', 'language', 'de', 'Khmer');
611
588
-- Korean
612
-- Korean
589
INSERT INTO language_subtag_registry( subtag, type, description, added)
613
INSERT INTO language_subtag_registry( subtag, type, description, added)
590
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
614
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
Lines 643-649 INSERT INTO language_descriptions(subtag, type, lang, description) Link Here
643
VALUES ( 'la', 'language', 'fr', 'Latin');
667
VALUES ( 'la', 'language', 'fr', 'Latin');
644
668
645
INSERT INTO language_descriptions(subtag, type, lang, description)
669
INSERT INTO language_descriptions(subtag, type, lang, description)
646
VALUES ( 'la', 'language', 'de', 'Latein');
670
VALUES ( 'la', 'language', 'de', 'Lateinisch');
647
671
648
-- Lao
672
-- Lao
649
INSERT INTO language_subtag_registry( subtag, type, description, added)
673
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 677-682 VALUES ( 'mi', 'language', 'mi', 'Te Reo Māori'); Link Here
677
INSERT INTO language_descriptions(subtag, type, lang, description)
701
INSERT INTO language_descriptions(subtag, type, lang, description)
678
VALUES ( 'mi', 'language', 'en', 'Maori');
702
VALUES ( 'mi', 'language', 'en', 'Maori');
679
703
704
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES ( 'mi', 'language', 'de', 'Maorisch');
706
680
-- Mongolian
707
-- Mongolian
681
INSERT INTO language_subtag_registry( subtag, type, description, added)
708
INSERT INTO language_subtag_registry( subtag, type, description, added)
682
VALUES ( 'mn', 'language', 'Mongolian','2014-10-30');
709
VALUES ( 'mn', 'language', 'Mongolian','2014-10-30');
Lines 690-695 VALUES ( 'mn', 'language', 'mn', 'Mонгол'); Link Here
690
INSERT INTO language_descriptions(subtag, type, lang, description)
717
INSERT INTO language_descriptions(subtag, type, lang, description)
691
VALUES ( 'mn', 'language', 'en', 'Mongolian');
718
VALUES ( 'mn', 'language', 'en', 'Mongolian');
692
719
720
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES ( 'mn', 'language', 'de', 'Mongolisch');
722
693
-- Marathi
723
-- Marathi
694
INSERT INTO language_subtag_registry( subtag, type, description, added)
724
INSERT INTO language_subtag_registry( subtag, type, description, added)
695
VALUES ( 'mr', 'language', 'Marathi','2014-10-30');
725
VALUES ( 'mr', 'language', 'Marathi','2014-10-30');
Lines 703-708 VALUES ( 'mr', 'language', 'mr', 'मराठी'); Link Here
703
INSERT INTO language_descriptions(subtag, type, lang, description)
733
INSERT INTO language_descriptions(subtag, type, lang, description)
704
VALUES ( 'mr', 'language', 'en', 'Marathi');
734
VALUES ( 'mr', 'language', 'en', 'Marathi');
705
735
736
INSERT INTO language_descriptions(subtag, type, lang, description)
737
VALUES ( 'mr', 'language', 'de', 'Marathi');
738
706
-- Malay
739
-- Malay
707
INSERT INTO language_subtag_registry( subtag, type, description, added)
740
INSERT INTO language_subtag_registry( subtag, type, description, added)
708
VALUES ( 'ms', 'language', 'Malay','2014-10-30');
741
VALUES ( 'ms', 'language', 'Malay','2014-10-30');
Lines 716-721 VALUES ( 'ms', 'language', 'ms', 'Bahasa melayu'); Link Here
716
INSERT INTO language_descriptions(subtag, type, lang, description)
749
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'ms', 'language', 'en', 'Malay');
750
VALUES ( 'ms', 'language', 'en', 'Malay');
718
751
752
INSERT INTO language_descriptions(subtag, type, lang, description)
753
VALUES ( 'ms', 'language', 'de', 'Malaiisch');
754
719
-- Norwegian (bokmål)
755
-- Norwegian (bokmål)
720
INSERT INTO language_subtag_registry( subtag, type, description, added)
756
INSERT INTO language_subtag_registry( subtag, type, description, added)
721
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
757
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
Lines 748-753 VALUES ( 'ne', 'language', 'ne', 'नेपाली'); Link Here
748
INSERT INTO language_descriptions(subtag, type, lang, description)
784
INSERT INTO language_descriptions(subtag, type, lang, description)
749
VALUES ( 'ne', 'language', 'en', 'Nepali');
785
VALUES ( 'ne', 'language', 'en', 'Nepali');
750
786
787
INSERT INTO language_descriptions(subtag, type, lang, description)
788
VALUES ( 'ne', 'language', 'de', 'Nepali');
789
751
-- Dutch
790
-- Dutch
752
INSERT INTO language_subtag_registry( subtag, type, description, added)
791
INSERT INTO language_subtag_registry( subtag, type, description, added)
753
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
792
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
Lines 802-807 VALUES ( 'pbr', 'language', 'pbr', 'Ekipangwa'); Link Here
802
INSERT INTO language_descriptions(subtag, type, lang, description)
841
INSERT INTO language_descriptions(subtag, type, lang, description)
803
VALUES ( 'pbr', 'language', 'en', 'Pangwa');
842
VALUES ( 'pbr', 'language', 'en', 'Pangwa');
804
843
844
INSERT INTO language_descriptions(subtag, type, lang, description)
845
VALUES ( 'pbr', 'language', 'de', 'Pangwa');
846
805
-- Polish
847
-- Polish
806
INSERT INTO language_subtag_registry( subtag, type, description, added)
848
INSERT INTO language_subtag_registry( subtag, type, description, added)
807
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
849
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
Lines 834-839 VALUES ( 'prs', 'language', 'prs', 'درى'); Link Here
834
INSERT INTO language_descriptions(subtag, type, lang, description)
876
INSERT INTO language_descriptions(subtag, type, lang, description)
835
VALUES ( 'prs', 'language', 'en', 'Dari');
877
VALUES ( 'prs', 'language', 'en', 'Dari');
836
878
879
INSERT INTO language_descriptions(subtag, type, lang, description)
880
VALUES ( 'prs', 'language', 'de', 'Dari');
881
837
-- Portuguese
882
-- Portuguese
838
INSERT INTO language_subtag_registry( subtag, type, description, added)
883
INSERT INTO language_subtag_registry( subtag, type, description, added)
839
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
884
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
Lines 904-909 VALUES ( 'rw', 'language', 'rw', 'Ikinyarwanda'); Link Here
904
INSERT INTO language_descriptions(subtag, type, lang, description)
949
INSERT INTO language_descriptions(subtag, type, lang, description)
905
VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
950
VALUES ( 'rw', 'language', 'en', 'Kinyarwanda');
906
951
952
INSERT INTO language_descriptions(subtag, type, lang, description)
953
VALUES ( 'rw', 'language', 'de', 'Kinyarwanda');
954
907
-- Sindhi
955
-- Sindhi
908
INSERT INTO language_subtag_registry( subtag, type, description, added)
956
INSERT INTO language_subtag_registry( subtag, type, description, added)
909
VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
957
VALUES ( 'sd', 'language', 'Sindhi','2014-10-30');
Lines 917-922 VALUES ( 'sd', 'language', 'sd', 'سنڌي'); Link Here
917
INSERT INTO language_descriptions(subtag, type, lang, description)
965
INSERT INTO language_descriptions(subtag, type, lang, description)
918
VALUES ( 'sd', 'language', 'en', 'Sindhi');
966
VALUES ( 'sd', 'language', 'en', 'Sindhi');
919
967
968
INSERT INTO language_descriptions(subtag, type, lang, description)
969
VALUES ( 'sd', 'language', 'de', 'Sindhi');
970
920
-- Slovak
971
-- Slovak
921
INSERT INTO language_subtag_registry( subtag, type, description, added)
972
INSERT INTO language_subtag_registry( subtag, type, description, added)
922
VALUES ( 'sk', 'language', 'Slovak','2014-10-30');
973
VALUES ( 'sk', 'language', 'Slovak','2014-10-30');
Lines 930-935 VALUES ( 'sk', 'language', 'sk', 'Slovenčina'); Link Here
930
INSERT INTO language_descriptions(subtag, type, lang, description)
981
INSERT INTO language_descriptions(subtag, type, lang, description)
931
VALUES ( 'sk', 'language', 'en', 'Slovak');
982
VALUES ( 'sk', 'language', 'en', 'Slovak');
932
983
984
INSERT INTO language_descriptions(subtag, type, lang, description)
985
VALUES ( 'sk', 'language', 'de', 'Slowakisch');
986
933
-- Slovene
987
-- Slovene
934
INSERT INTO language_subtag_registry( subtag, type, description, added)
988
INSERT INTO language_subtag_registry( subtag, type, description, added)
935
VALUES ( 'sl', 'language', 'Slovene','2014-10-30');
989
VALUES ( 'sl', 'language', 'Slovene','2014-10-30');
Lines 943-948 VALUES ( 'sl', 'language', 'sl', 'Slovenščina'); Link Here
943
INSERT INTO language_descriptions(subtag, type, lang, description)
997
INSERT INTO language_descriptions(subtag, type, lang, description)
944
VALUES ( 'sl', 'language', 'en', 'Slovene');
998
VALUES ( 'sl', 'language', 'en', 'Slovene');
945
999
1000
INSERT INTO language_descriptions(subtag, type, lang, description)
1001
VALUES ( 'sl', 'language', 'de', 'Slowenisch');
1002
946
-- Albanian
1003
-- Albanian
947
INSERT INTO language_subtag_registry( subtag, type, description, added)
1004
INSERT INTO language_subtag_registry( subtag, type, description, added)
948
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
1005
VALUES ( 'sq', 'language', 'Albanian','2014-10-30');
Lines 956-961 VALUES ( 'sq', 'language', 'sq', 'Shqip'); Link Here
956
INSERT INTO language_descriptions(subtag, type, lang, description)
1013
INSERT INTO language_descriptions(subtag, type, lang, description)
957
VALUES ( 'sq', 'language', 'en', 'Albanian');
1014
VALUES ( 'sq', 'language', 'en', 'Albanian');
958
1015
1016
INSERT INTO language_descriptions(subtag, type, lang, description)
1017
VALUES ( 'sq', 'language', 'de', 'Albanisch');
1018
959
-- Serbian
1019
-- Serbian
960
INSERT INTO language_subtag_registry( subtag, type, description, added)
1020
INSERT INTO language_subtag_registry( subtag, type, description, added)
961
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
1021
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
Lines 1007-1012 VALUES ( 'sw', 'language', 'sw', 'Kiswahili'); Link Here
1007
INSERT INTO language_descriptions(subtag, type, lang, description)
1067
INSERT INTO language_descriptions(subtag, type, lang, description)
1008
VALUES ( 'sw', 'language', 'en', 'Swahili');
1068
VALUES ( 'sw', 'language', 'en', 'Swahili');
1009
1069
1070
INSERT INTO language_descriptions(subtag, type, lang, description)
1071
VALUES ( 'sw', 'language', 'de', 'Swahili');
1072
1010
-- Tamil
1073
-- Tamil
1011
INSERT INTO language_subtag_registry( subtag, type, description, added)
1074
INSERT INTO language_subtag_registry( subtag, type, description, added)
1012
VALUES ( 'ta', 'language', 'Tamil','2014-10-30');
1075
VALUES ( 'ta', 'language', 'Tamil','2014-10-30');
Lines 1020-1025 VALUES ( 'ta', 'language', 'ta', 'தமிழ்'); Link Here
1020
INSERT INTO language_descriptions(subtag, type, lang, description)
1083
INSERT INTO language_descriptions(subtag, type, lang, description)
1021
VALUES ( 'ta', 'language', 'en', 'Tamil');
1084
VALUES ( 'ta', 'language', 'en', 'Tamil');
1022
1085
1086
INSERT INTO language_descriptions(subtag, type, lang, description)
1087
VALUES ( 'ta', 'language', 'de', 'Tamil');
1088
1023
-- Tetum
1089
-- Tetum
1024
INSERT INTO language_subtag_registry( subtag, type, description, added)
1090
INSERT INTO language_subtag_registry( subtag, type, description, added)
1025
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
1091
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
Lines 1071-1076 VALUES ( 'tl', 'language', 'tl', 'Tagalog'); Link Here
1071
INSERT INTO language_descriptions(subtag, type, lang, description)
1137
INSERT INTO language_descriptions(subtag, type, lang, description)
1072
VALUES ( 'tl', 'language', 'en', 'Tagalog');
1138
VALUES ( 'tl', 'language', 'en', 'Tagalog');
1073
1139
1140
INSERT INTO language_descriptions(subtag, type, lang, description)
1141
VALUES ( 'tl', 'language', 'de', 'Tagalog');
1142
1074
-- Turkish
1143
-- Turkish
1075
INSERT INTO language_subtag_registry( subtag, type, description, added)
1144
INSERT INTO language_subtag_registry( subtag, type, description, added)
1076
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
1145
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
Lines 1190-1195 VALUES ( 'Armn', 'script', 'Armn', 'Հայոց այբուբեն'); Link Here
1190
INSERT INTO language_descriptions(subtag, type, lang, description)
1259
INSERT INTO language_descriptions(subtag, type, lang, description)
1191
VALUES( 'Armn', 'script', 'en', 'Armenian');
1260
VALUES( 'Armn', 'script', 'en', 'Armenian');
1192
1261
1262
INSERT INTO language_descriptions(subtag, type, lang, description)
1263
VALUES( 'Armn', 'script', 'de', 'Armenisch');
1264
1193
-- Cyrillic
1265
-- Cyrillic
1194
INSERT INTO language_subtag_registry( subtag, type, description, added)
1266
INSERT INTO language_subtag_registry( subtag, type, description, added)
1195
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
1267
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
Lines 1216-1221 VALUES ( 'Ethi', 'script', 'Ethi', 'ግዕዝ'); Link Here
1216
INSERT INTO language_descriptions(subtag, type, lang, description)
1288
INSERT INTO language_descriptions(subtag, type, lang, description)
1217
VALUES( 'Ethi', 'script', 'en', 'Ethiopic');
1289
VALUES( 'Ethi', 'script', 'en', 'Ethiopic');
1218
1290
1291
INSERT INTO language_descriptions(subtag, type, lang, description)
1292
VALUES( 'Ethi', 'script', 'de', 'Äthiopisch');
1293
1219
-- Greek
1294
-- Greek
1220
INSERT INTO language_subtag_registry( subtag, type, description, added)
1295
INSERT INTO language_subtag_registry( subtag, type, description, added)
1221
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
1296
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
Lines 1286-1291 VALUES ( 'Jpan', 'script', 'Jpan', '漢字'); Link Here
1286
INSERT INTO language_descriptions(subtag, type, lang, description)
1361
INSERT INTO language_descriptions(subtag, type, lang, description)
1287
VALUES( 'Jpan', 'script', 'en', 'Japanese');
1362
VALUES( 'Jpan', 'script', 'en', 'Japanese');
1288
1363
1364
INSERT INTO language_descriptions(subtag, type, lang, description)
1365
VALUES( 'Jpan', 'script', 'de', 'Japanisch');
1366
1289
-- Kannada
1367
-- Kannada
1290
INSERT INTO language_subtag_registry( subtag, type, description, added)
1368
INSERT INTO language_subtag_registry( subtag, type, description, added)
1291
VALUES ( 'Knda', 'script', 'Kannada','2014-10-30');
1369
VALUES ( 'Knda', 'script', 'Kannada','2014-10-30');
Lines 1296-1301 VALUES ( 'Knda', 'script', 'Knda', 'ಕನ್ನಡ ಲಿಪಿ'); Link Here
1296
INSERT INTO language_descriptions(subtag, type, lang, description)
1374
INSERT INTO language_descriptions(subtag, type, lang, description)
1297
VALUES( 'Knda', 'script', 'en', 'Kannada');
1375
VALUES( 'Knda', 'script', 'en', 'Kannada');
1298
1376
1377
INSERT INTO language_descriptions(subtag, type, lang, description)
1378
VALUES( 'Knda', 'script', 'de', 'Kannada');
1379
1299
-- Korean
1380
-- Korean
1300
INSERT INTO language_subtag_registry( subtag, type, description, added)
1381
INSERT INTO language_subtag_registry( subtag, type, description, added)
1301
VALUES ( 'Kore', 'script', 'Korean','2014-10-30');
1382
VALUES ( 'Kore', 'script', 'Korean','2014-10-30');
Lines 1306-1311 VALUES ( 'Kore', 'script', 'Kore', '한글'); Link Here
1306
INSERT INTO language_descriptions(subtag, type, lang, description)
1387
INSERT INTO language_descriptions(subtag, type, lang, description)
1307
VALUES( 'Kore', 'script', 'en', 'Korean');
1388
VALUES( 'Kore', 'script', 'en', 'Korean');
1308
1389
1390
INSERT INTO language_descriptions(subtag, type, lang, description)
1391
VALUES( 'Kore', 'script', 'de', 'Koreanisch');
1392
1309
-- Lao
1393
-- Lao
1310
INSERT INTO language_subtag_registry( subtag, type, description, added)
1394
INSERT INTO language_subtag_registry( subtag, type, description, added)
1311
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
1395
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
Lines 1813-1818 VALUES ('et', 'language', 'en', 'Estonian'); Link Here
1813
INSERT INTO language_descriptions (subtag, type, lang, description)
1897
INSERT INTO language_descriptions (subtag, type, lang, description)
1814
VALUES ('et', 'language', 'et', 'Eesti');
1898
VALUES ('et', 'language', 'et', 'Eesti');
1815
1899
1900
INSERT INTO language_descriptions (subtag, type, lang, description)
1901
VALUES ('et', 'language', 'de', 'Estnisch');
1902
1816
INSERT INTO language_subtag_registry (subtag, type, description, added)
1903
INSERT INTO language_subtag_registry (subtag, type, description, added)
1817
VALUES ('et', 'language', 'Estonian', now());
1904
VALUES ('et', 'language', 'Estonian', now());
1818
1905
Lines 1827-1832 VALUES ('lv', 'language', 'en', 'Latvian'); Link Here
1827
INSERT INTO language_descriptions (subtag, type, lang, description)
1914
INSERT INTO language_descriptions (subtag, type, lang, description)
1828
VALUES ('lv', 'language', 'lv', 'Latvija');
1915
VALUES ('lv', 'language', 'lv', 'Latvija');
1829
1916
1917
INSERT INTO language_descriptions (subtag, type, lang, description)
1918
VALUES ('lv', 'language', 'de', 'Lettisch');
1919
1830
INSERT INTO language_subtag_registry (subtag, type, description, added)
1920
INSERT INTO language_subtag_registry (subtag, type, description, added)
1831
VALUES ('lv', 'language', 'Latvian', now());
1921
VALUES ('lv', 'language', 'Latvian', now());
1832
1922
Lines 1841-1846 VALUES ('lt', 'language', 'en', 'Lithuanian'); Link Here
1841
INSERT INTO language_descriptions (subtag, type, lang, description)
1931
INSERT INTO language_descriptions (subtag, type, lang, description)
1842
VALUES ('lt', 'language', 'lt', 'Lietuvių');
1932
VALUES ('lt', 'language', 'lt', 'Lietuvių');
1843
1933
1934
INSERT INTO language_descriptions (subtag, type, lang, description)
1935
VALUES ('lt', 'language', 'de', 'Litauisch');
1936
1844
INSERT INTO language_subtag_registry (subtag, type, description, added)
1937
INSERT INTO language_subtag_registry (subtag, type, description, added)
1845
VALUES ('lt', 'language', 'Lithuanian', now());
1938
VALUES ('lt', 'language', 'Lithuanian', now());
1846
1939
Lines 1855-1860 VALUES ('iu', 'language', 'en', 'Inuktitut'); Link Here
1855
INSERT INTO language_descriptions (subtag, type, lang, description)
1948
INSERT INTO language_descriptions (subtag, type, lang, description)
1856
VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ');
1949
VALUES ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ');
1857
1950
1951
INSERT INTO language_descriptions (subtag, type, lang, description)
1952
VALUES ('iu', 'language', 'de', 'Inuktitut');
1953
1858
INSERT INTO language_subtag_registry (subtag, type, description, added)
1954
INSERT INTO language_subtag_registry (subtag, type, description, added)
1859
VALUES ('iu', 'language', 'Inuktitut', now());
1955
VALUES ('iu', 'language', 'Inuktitut', now());
1860
1956
Lines 1869-1874 VALUES ('ik', 'language', 'en', 'Inupiaq'); Link Here
1869
INSERT INTO language_descriptions (subtag, type, lang, description)
1965
INSERT INTO language_descriptions (subtag, type, lang, description)
1870
VALUES ('ik', 'language', 'ik', 'Iñupiaq');
1966
VALUES ('ik', 'language', 'ik', 'Iñupiaq');
1871
1967
1968
INSERT INTO language_descriptions (subtag, type, lang, description)
1969
VALUES ('ik', 'language', 'de', 'Inupiaq');
1970
1872
INSERT INTO language_subtag_registry (subtag, type, description, added)
1971
INSERT INTO language_subtag_registry (subtag, type, description, added)
1873
VALUES ('ik', 'language', 'Inupiaq', now());
1972
VALUES ('ik', 'language', 'Inupiaq', now());
1874
1973
Lines 1915-1920 VALUES ( 'cr', 'language', 'en', 'Cree'); Link Here
1915
INSERT INTO language_descriptions(subtag, type, lang, description)
2014
INSERT INTO language_descriptions(subtag, type, lang, description)
1916
VALUES ( 'cr', 'language', 'fr', 'Cree');
2015
VALUES ( 'cr', 'language', 'fr', 'Cree');
1917
2016
2017
INSERT INTO language_descriptions(subtag, type, lang, description)
2018
VALUES ( 'cr', 'language', 'de', 'Cree');
2019
1918
-- Afrikaans
2020
-- Afrikaans
1919
2021
1920
INSERT INTO language_subtag_registry( subtag, type, description, added)
2022
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 1929-1934 VALUES ( 'af', 'language', 'en', 'Afrikaans'); Link Here
1929
INSERT INTO language_descriptions(subtag, type, lang, description)
2031
INSERT INTO language_descriptions(subtag, type, lang, description)
1930
VALUES ( 'af', 'language', 'fr', 'Afrikaans');
2032
VALUES ( 'af', 'language', 'fr', 'Afrikaans');
1931
2033
2034
INSERT INTO language_descriptions(subtag, type, lang, description)
2035
VALUES ( 'af', 'language', 'de', 'Afrikaans');
2036
1932
-- Multiple languages
2037
-- Multiple languages
1933
2038
1934
INSERT INTO language_subtag_registry( subtag, type, description, added)
2039
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 1943-1948 VALUES ( 'mul', 'language', 'en', 'Multiple languages'); Link Here
1943
INSERT INTO language_descriptions(subtag, type, lang, description)
2048
INSERT INTO language_descriptions(subtag, type, lang, description)
1944
VALUES ( 'mul', 'language', 'fr', 'Multilingue');
2049
VALUES ( 'mul', 'language', 'fr', 'Multilingue');
1945
2050
2051
INSERT INTO language_descriptions(subtag, type, lang, description)
2052
VALUES ( 'mul', 'language', 'de', 'Mehrsprachig');
2053
1946
-- Undetermined
2054
-- Undetermined
1947
2055
1948
INSERT INTO language_subtag_registry( subtag, type, description, added)
2056
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 1957-1962 VALUES ( 'und', 'language', 'en', 'Undetermined'); Link Here
1957
INSERT INTO language_descriptions(subtag, type, lang, description)
2065
INSERT INTO language_descriptions(subtag, type, lang, description)
1958
VALUES ( 'und', 'language', 'fr', 'Indéterminée');
2066
VALUES ( 'und', 'language', 'fr', 'Indéterminée');
1959
2067
2068
INSERT INTO language_descriptions(subtag, type, lang, description)
2069
VALUES ( 'und', 'language', 'de', 'Unbestimmt');
2070
1960
-- No linguistic content
2071
-- No linguistic content
1961
2072
1962
INSERT INTO language_subtag_registry( subtag, type, description, added)
2073
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 1970-1972 VALUES ( 'zxx', 'language', 'en', 'No linguistic content'); Link Here
1970
2081
1971
INSERT INTO language_descriptions(subtag, type, lang, description)
2082
INSERT INTO language_descriptions(subtag, type, lang, description)
1972
VALUES ( 'zxx', 'language', 'fr', 'Pas de contenu linguistique');
2083
VALUES ( 'zxx', 'language', 'fr', 'Pas de contenu linguistique');
1973
- 
2084
2085
INSERT INTO language_descriptions(subtag, type, lang, description)
2086
VALUES ( 'zxx', 'language', 'de', 'Kein sprachlicher Inhalt');

Return to bug 31715