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

(-)a/installer/data/mysql/atomicupdate/bz27136-Add_languages_for_facet.pl (+35 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "27136",
5
    description => "Add missing language information for facets",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{ INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('cr', 'language', 'Cree', now()) });
10
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('cr', 'language', 'en', 'Cree') });
11
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('cr', 'language', 'fr', 'Cree') });
12
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('cr', 'cre') });
13
14
        $dbh->do(q{ INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('af', 'language', 'Afrikaans', now()) });
15
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('af', 'language', 'en', 'Afrikaans') });
16
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('af', 'language', 'fr', 'Afrikaans') });
17
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('af', 'afr') });
18
19
        $dbh->do(q{ INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('mul', 'language', 'Multiple languages', now()) });
20
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('mul', 'language', 'en', 'Multiple languages') });
21
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('mul', 'language', 'fr', 'Multilingue') });
22
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('mul', 'mul') });
23
24
        $dbh->do(q{ INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('und', 'language', 'Undetermined', now()) });
25
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('und', 'language', 'en', 'Undetermined') });
26
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('und', 'language', 'fr', 'Indéterminée') });
27
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('und', 'und') });
28
29
        $dbh->do(q{ INSERT INTO language_subtag_registry (subtag, type, description, added) VALUES ('zxx', 'language', 'No linguistic content', now()) });
30
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('zxx', 'language', 'en', 'No linguistic content') });
31
        $dbh->do(q{ INSERT INTO language_descriptions (subtag, type, lang, description) VALUES ('zxx', 'language', 'fr', 'Pas de contenu linguistique') });
32
        $dbh->do(q{ INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) VALUES ('zxx', 'zxx') });
33
        say $out "Added missing languages";
34
    },
35
};
(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +71 lines)
Lines 1900-1902 VALUES ( 'yi', 'language', 'yi', 'יידיש'); Link Here
1900
1900
1901
INSERT INTO language_script_mapping(language_subtag,script_subtag)
1901
INSERT INTO language_script_mapping(language_subtag,script_subtag)
1902
VALUES ( 'yi', 'Hebr');
1902
VALUES ( 'yi', 'Hebr');
1903
- 
1903
1904
-- Cree
1905
1906
INSERT INTO language_subtag_registry( subtag, type, description, added)
1907
VALUES ( 'cr', 'language', 'Cree', NOW() );
1908
1909
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1910
VALUES ( 'cr','cre');
1911
1912
INSERT INTO language_descriptions(subtag, type, lang, description)
1913
VALUES ( 'cr', 'language', 'en', 'Cree');
1914
1915
INSERT INTO language_descriptions(subtag, type, lang, description)
1916
VALUES ( 'cr', 'language', 'fr', 'Cree');
1917
1918
-- Afrikaans
1919
1920
INSERT INTO language_subtag_registry( subtag, type, description, added)
1921
VALUES ( 'af', 'language', 'Afrikaans', NOW() );
1922
1923
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1924
VALUES ( 'af','afr');
1925
1926
INSERT INTO language_descriptions(subtag, type, lang, description)
1927
VALUES ( 'af', 'language', 'en', 'Afrikaans');
1928
1929
INSERT INTO language_descriptions(subtag, type, lang, description)
1930
VALUES ( 'af', 'language', 'fr', 'Afrikaans');
1931
1932
-- Multiple languages
1933
1934
INSERT INTO language_subtag_registry( subtag, type, description, added)
1935
VALUES ( 'mul', 'language', 'Multiple languages', NOW() );
1936
1937
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1938
VALUES ( 'mu','mul');
1939
1940
INSERT INTO language_descriptions(subtag, type, lang, description)
1941
VALUES ( 'mu', 'language', 'en', 'Multiple languages');
1942
1943
INSERT INTO language_descriptions(subtag, type, lang, description)
1944
VALUES ( 'mu', 'language', 'fr', 'Multilingue');
1945
1946
-- Undetermined
1947
1948
INSERT INTO language_subtag_registry( subtag, type, description, added)
1949
VALUES ( 'und', 'language', 'Undetermined', NOW() );
1950
1951
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1952
VALUES ( 'und','und');
1953
1954
INSERT INTO language_descriptions(subtag, type, lang, description)
1955
VALUES ( 'un', 'language', 'en', 'Undetermined');
1956
1957
INSERT INTO language_descriptions(subtag, type, lang, description)
1958
VALUES ( 'un', 'language', 'fr', 'Indéterminée');
1959
1960
-- No linguistic content
1961
1962
INSERT INTO language_subtag_registry( subtag, type, description, added)
1963
VALUES ( 'zxx', 'language', 'No linguistic content', NOW() );
1964
1965
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
1966
VALUES ( 'zxx','zxx');
1967
1968
INSERT INTO language_descriptions(subtag, type, lang, description)
1969
VALUES ( 'zxx', 'language', 'en', 'No linguistic content');
1970
1971
INSERT INTO language_descriptions(subtag, type, lang, description)
1972
VALUES ( 'zxx', 'language', 'fr', 'Pas de contenu linguistique');
1973

Return to bug 27136