5 description => "Add missing languages",
8 my $dbh = $args->{dbh};
10 if( !unique_key_exists( 'language_subtag_registry', 'uniq_lang' ) ) {
12 ALTER TABLE language_subtag_registry
13 ADD UNIQUE KEY uniq_lang (subtag, type)
17 if( !unique_key_exists( 'language_descriptions', 'uniq_desc' ) ) {
19 ALTER TABLE language_descriptions
20 ADD UNIQUE KEY uniq_desc (subtag, type, lang)
24 if( !unique_key_exists( 'language_rfc4646_to_iso639', 'uniq_code' ) ) {
26 ALTER TABLE language_rfc4646_to_iso639
27 ADD UNIQUE KEY uniq_code (rfc4646_subtag, iso639_2_code)
32 INSERT IGNORE INTO language_subtag_registry (subtag, type, description, added)
34 ('et', 'language', 'Estonian', now()),
35 ('lv', 'language', 'Latvian', now()),
36 ('lt', 'language', 'Lithuanian', now()),
37 ('iu', 'language', 'Inuktitut', now()),
38 ('ik', 'language', 'Inupiaq', now())
42 INSERT IGNORE INTO language_descriptions (subtag, type, lang, description)
44 ('et', 'language', 'en', 'Estonian'),
45 ('et', 'language', 'et', 'Eesti'),
46 ('lv', 'language', 'en', 'Latvian'),
47 ('lv', 'language', 'lv', 'Latvija'),
48 ('lt', 'language', 'en', 'Lithuanian'),
49 ('lt', 'language', 'lt', 'Lietuvių'),
50 ('iu', 'language', 'en', 'Inuktitut'),
51 ('iu', 'language', 'iu', 'ᐃᓄᒃᑎᑐᑦ'),
52 ('ik', 'language', 'en', 'Inupiaq'),
53 ('ik', 'language', 'ik', 'Iñupiaq')
57 INSERT IGNORE INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code)