Attachment #141940 for bug #31715

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




use Modern::Perl;

return {
    bug_number => "31715",
    description => "Add missing German (de) language translations",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        # Do you stuffs here
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'am', 'language', 'de', 'Amharisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'az', 'language', 'de', 'Aserbaidschanisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'be', 'language', 'de', 'Belarussisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'bn', 'language', 'de', 'Bengalisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'eu', 'language', 'de', 'Baskisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'fo', 'language', 'de', 'Färöisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'is', 'language', 'de', 'Isländisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mi', 'language', 'de', 'Maorisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mn', 'language', 'de', 'Mongolisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mr', 'language', 'de', 'Marathi') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ms', 'language', 'de', 'Malaiisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ne', 'language', 'de', 'Nepali') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'pbr', 'language', 'de', 'Pangwa') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'prs', 'language', 'de', 'Dari') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'rw', 'language', 'de', 'Kinyarwanda') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sd', 'language', 'de', 'Sindhi') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sk', 'language', 'de', 'Slowakisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sl', 'language', 'de', 'Slowenisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sq', 'language', 'de', 'Albanisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'sw', 'language', 'de', 'Swahili') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'ta', 'language', 'de', 'Tamil') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'tl', 'language', 'de', 'Tagalog') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Armn', 'script', 'de', 'Armenisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Ethi', 'script', 'en', 'Äthiopisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Jpan', 'script', 'de', 'Japanisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Knda', 'script', 'de', 'Kannada') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUEs ( 'Kore', 'script', 'de', 'Koreanisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('et', 'language', 'de', 'Estnisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lv', 'language', 'de', 'Lettisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('lt', 'language', 'de', 'Litauisch') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('iu', 'language', 'de', 'Inuktitut') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ('ik', 'language', 'de', 'Inupiaq') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'cr', 'language', 'de', 'Cree') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'af', 'language', 'de', 'Afrikaans') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'mul', 'language', 'de', 'Mehrsprachig') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'und', 'language', 'de', 'Unbestimmt') });
        $dbh->do(q{ INSERT IGNORE INTO language_descriptions (subtag, type, lang, description) VALUES ( 'zxx', 'language', 'de', 'Kein sprachlicher Inhalt') });

        # Print useful stuff here
        say $out "German (de) translations were added";
    },
};

Lines 69-74 VALUES ( 'am', 'language', 'am', 'አማርኛ'); Link Here

(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-2 / +115 lines)
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

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_31715_de-languages.pl (+52 lines)
	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	};