Attachment #128094 for bug #29596

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




use Modern::Perl;

return {
    bug_number  => "29596",
    description => "Add Yiddish language",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh)};


        $dbh->do(q{
            INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
            VALUES ( 'yi', 'language', 'Yiddish', NOW() );
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
            VALUES ( 'yi','yid');
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'yi', 'language', 'es', 'Yidis');
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'yi', 'language', 'en', 'Yiddish');
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'yi', 'language', 'fr', 'Yiddish');
        });

        $dbh->do(q{
            INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'yi', 'language', 'de', 'Jiddisch');
        });
    },
}





INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
VALUES ('ik', 'ipk');

-- Yiddish

INSERT INTO language_subtag_registry( subtag, type, description, added)
VALUES ( 'yi', 'language', 'Yiddish', NOW() );

INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
VALUES ( 'yi','yid');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'yi', 'language', 'es', 'Yidis');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'yi', 'language', 'en', 'Yiddish');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'yi', 'language', 'fr', 'Yiddish');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'yi', 'language', 'de', 'Jiddisch');

Return to bug 29596

Lines 1874-1876 VALUES ('ik', 'language', 'Inupiaq', now()); Link Here

(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +20 lines)
1874		1874
1875	INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)	1875	INSERT INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)
1876	VALUES ('ik', 'ipk');	1876	VALUES ('ik', 'ipk');
1877	-	1877
		1878	-- Yiddish
		1879
		1880	INSERT INTO language_subtag_registry( subtag, type, description, added)
		1881	VALUES ( 'yi', 'language', 'Yiddish', NOW() );
		1882
		1883	INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
		1884	VALUES ( 'yi','yid');
		1885
		1886	INSERT INTO language_descriptions(subtag, type, lang, description)
		1887	VALUES ( 'yi', 'language', 'es', 'Yidis');
		1888
		1889	INSERT INTO language_descriptions(subtag, type, lang, description)
		1890	VALUES ( 'yi', 'language', 'en', 'Yiddish');
		1891
		1892	INSERT INTO language_descriptions(subtag, type, lang, description)
		1893	VALUES ( 'yi', 'language', 'fr', 'Yiddish');
		1894
		1895	INSERT INTO language_descriptions(subtag, type, lang, description)
		1896	VALUES ( 'yi', 'language', 'de', 'Jiddisch');

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_29596.pl (+41 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "29596",
	5	description => "Add Yiddish language",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh)};
	9
	10
	11	$dbh->do(q{
	12	INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added)
	13	VALUES ( 'yi', 'language', 'Yiddish', NOW() );
	14	});
	15
	16	$dbh->do(q{
	17	INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
	18	VALUES ( 'yi','yid');
	19	});
	20
	21	$dbh->do(q{
	22	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
	23	VALUES ( 'yi', 'language', 'es', 'Yidis');
	24	});
	25
	26	$dbh->do(q{
	27	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
	28	VALUES ( 'yi', 'language', 'en', 'Yiddish');
	29	});
	30
	31	$dbh->do(q{
	32	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
	33	VALUES ( 'yi', 'language', 'fr', 'Yiddish');
	34	});
	35
	36	$dbh->do(q{
	37	INSERT IGNORE INTO language_descriptions(subtag, type, lang, description)
	38	VALUES ( 'yi', 'language', 'de', 'Jiddisch');
	39	});
	40	},
	41	}