Attachment #156593 for bug #34328

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




use Modern::Perl;

return {
    bug_number  => "34328",
    description => "Add Scottish Gaelic to recognised languages",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};
        $dbh->do(q{
            INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
            VALUES ( 'gd','gla' )
        });

        $dbh->do(q{
            INSERT INTO language_subtag_registry( subtag, type, description, added)
            VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
        });

        $dbh->do(q{
            INSERT INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
        });

        $dbh->do(q{
            INSERT INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')
        });

        $dbh->do(q{
            INSERT INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')
        });

        $dbh->do(q{
            INSERT INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')
        });

        $dbh->do(q{
            INSERT INTO language_descriptions(subtag, type, lang, description)
            VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')
        });

        say $out "Added new language 'Scottish Gaelic'";
    },
};




INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'fr', 'language', 'pl', 'Francuski');

-- Scottish Gaelic

INSERT INTO language_subtag_registry( subtag, type, description, added)
VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() );

INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
VALUES ( 'gd','gla');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'gd', 'language', 'gd', 'Gàidhlig');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch');

INSERT INTO language_descriptions(subtag, type, lang, description)
VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki');

-- Galician
INSERT INTO language_subtag_registry( subtag, type, description, added)
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
- 

Return to bug 34328

Lines 425-430 VALUES ( 'fr', 'language', 'de', 'Französisch'); Link Here

(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-1 / +23 lines)
425	INSERT INTO language_descriptions(subtag, type, lang, description)	425	INSERT INTO language_descriptions(subtag, type, lang, description)
426	VALUES ( 'fr', 'language', 'pl', 'Francuski');	426	VALUES ( 'fr', 'language', 'pl', 'Francuski');
427		427
		428	-- Scottish Gaelic
		429
		430	INSERT INTO language_subtag_registry( subtag, type, description, added)
		431	VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() );
		432
		433	INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
		434	VALUES ( 'gd','gla');
		435
		436	INSERT INTO language_descriptions(subtag, type, lang, description)
		437	VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic');
		438
		439	INSERT INTO language_descriptions(subtag, type, lang, description)
		440	VALUES ( 'gd', 'language', 'gd', 'Gàidhlig');
		441
		442	INSERT INTO language_descriptions(subtag, type, lang, description)
		443	VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais');
		444
		445	INSERT INTO language_descriptions(subtag, type, lang, description)
		446	VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch');
		447
		448	INSERT INTO language_descriptions(subtag, type, lang, description)
		449	VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki');
		450
428	-- Galician	451	-- Galician
429	INSERT INTO language_subtag_registry( subtag, type, description, added)	452	INSERT INTO language_subtag_registry( subtag, type, description, added)
430	VALUES ( 'gl', 'language', 'Galician','2005-10-16' );	453	VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
431	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_34328.pl (+46 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "34328",
	5	description => "Add Scottish Gaelic to recognised languages",
	6	up => sub {
	7	my ($args) = @_;
	8	my ( $dbh, $out ) = @$args{qw(dbh out)};
	9	$dbh->do(q{
	10	INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
	11	VALUES ( 'gd','gla' )
	12	});
	13
	14	$dbh->do(q{
	15	INSERT INTO language_subtag_registry( subtag, type, description, added)
	16	VALUES ( 'gd', 'language', 'Scottish Gaelic', NOW() )
	17	});
	18
	19	$dbh->do(q{
	20	INSERT INTO language_descriptions(subtag, type, lang, description)
	21	VALUES ( 'gd', 'language', 'en', 'Scottish Gaelic')
	22	});
	23
	24	$dbh->do(q{
	25	INSERT INTO language_descriptions(subtag, type, lang, description)
	26	VALUES ( 'gd', 'language', 'gd', 'Gàidhlig')
	27	});
	28
	29	$dbh->do(q{
	30	INSERT INTO language_descriptions(subtag, type, lang, description)
	31	VALUES ( 'gd', 'language', 'fr', 'Gaélique écossais')
	32	});
	33
	34	$dbh->do(q{
	35	INSERT INTO language_descriptions(subtag, type, lang, description)
	36	VALUES ( 'gd', 'language', 'de', 'Schottisch-Gälisch')
	37	});
	38
	39	$dbh->do(q{
	40	INSERT INTO language_descriptions(subtag, type, lang, description)
	41	VALUES ( 'gd', 'language', 'pl', 'Język szkocki gaelicki')
	42	});
	43
	44	say $out "Added new language 'Scottish Gaelic'";
	45	},
	46	};