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

(-)a/installer/data/mysql/atomicupdate/bug_14030-Add_Georgian_fix_Kannada_code.sql (+22 lines)
Line 0 Link Here
1
UPDATE language_subtag_registry SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';
2
3
UPDATE language_rfc4646_to_iso639 SET rfc4646_subtag = 'kn' WHERE rfc4646_subtag = 'ka' AND iso639_2_code = 'kan';
4
5
UPDATE language_descriptions SET subtag = 'kn', lang = 'kn' WHERE subtag = 'ka' AND lang = 'ka' AND description = 'ಕನ್ನಡ';
6
7
UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada';
8
9
INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20');
10
11
INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo');
12
13
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული');
14
15
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'en', 'Georgian');
16
17
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'fr', 'Géorgien');
18
19
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische');
20
21
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano');
22
(-)a/installer/data/mysql/mandatory/subtag_registry.sql (-5 / +26 lines)
Lines 537-554 VALUES ( 'ja', 'language', 'fr', 'Japonais'); Link Here
537
INSERT INTO language_descriptions(subtag, type, lang, description)
537
INSERT INTO language_descriptions(subtag, type, lang, description)
538
VALUES ( 'ja', 'language', 'de', 'Japanisch');
538
VALUES ( 'ja', 'language', 'de', 'Japanisch');
539
539
540
-- Georgian
541
INSERT INTO language_subtag_registry( subtag, type, description, added)
542
VALUES ( 'ka', 'language', 'Georgian','2015-04-20');
543
544
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
545
VALUES ( 'ka', 'geo');
546
547
INSERT INTO language_descriptions(subtag, type, lang, description)
548
VALUES ( 'ka', 'language', 'ka', 'ქართული');
549
550
INSERT INTO language_descriptions(subtag, type, lang, description)
551
VALUES ( 'ka', 'language', 'en', 'Georgian');
552
553
INSERT INTO language_descriptions(subtag, type, lang, description)
554
VALUES ( 'ka', 'language', 'fr', 'Géorgien');
555
556
INSERT INTO language_descriptions(subtag, type, lang, description)
557
VALUES ( 'ka', 'language', 'de', 'Georgische');
558
559
INSERT INTO language_descriptions(subtag, type, lang, description)
560
VALUES ( 'ka', 'language', 'es', 'Georgiano');
561
540
-- Kannada
562
-- Kannada
541
INSERT INTO language_subtag_registry( subtag, type, description, added)
563
INSERT INTO language_subtag_registry( subtag, type, description, added)
542
VALUES ( 'ka', 'language', 'Kannada','2014-10-30');
564
VALUES ( 'kn', 'language', 'Kannada','2014-10-30');
543
565
544
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
566
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
545
VALUES ( 'ka','kan');
567
VALUES ( 'kn', 'kan');
546
568
547
INSERT INTO language_descriptions(subtag, type, lang, description)
569
INSERT INTO language_descriptions(subtag, type, lang, description)
548
VALUES ( 'ka', 'language', 'ka', 'ಕನ್ನಡ');
570
VALUES ( 'kn', 'language', 'kn', 'ಕನ್ನಡ');
549
571
550
INSERT INTO language_descriptions(subtag, type, lang, description)
572
INSERT INTO language_descriptions(subtag, type, lang, description)
551
VALUES ( 'ka', 'language', 'en', 'Kannada');
573
VALUES ( 'kn', 'language', 'en', 'Kannada');
552
574
553
-- Khmer
575
-- Khmer
554
INSERT INTO language_subtag_registry( subtag, type, description, added)
576
INSERT INTO language_subtag_registry( subtag, type, description, added)
555
- 

Return to bug 14030