|
Lines 7-14
UPDATE language_descriptions SET subtag = 'kn', lang = 'kn' WHERE subtag = 'ka'
Link Here
|
| 7 |
UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada'; |
7 |
UPDATE language_descriptions SET subtag = 'kn' WHERE subtag = 'ka' AND description = 'Kannada'; |
| 8 |
|
8 |
|
| 9 |
INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20'); |
9 |
INSERT IGNORE INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'ka', 'language', 'Georgian','2015-04-20'); |
|
|
10 |
DELETE FROM language_subtag_registry |
| 11 |
WHERE NOT id IN |
| 12 |
(SELECT id FROM |
| 13 |
(SELECT MIN(id) as id,subtag,type,description,added |
| 14 |
FROM language_subtag_registry |
| 15 |
GROUP BY subtag,type,description,added) |
| 16 |
AS subtable); |
| 17 |
|
| 10 |
|
18 |
|
| 11 |
INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo'); |
19 |
INSERT IGNORE INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'ka', 'geo'); |
|
|
20 |
DELETE FROM language_rfc4646_to_iso639 |
| 21 |
WHERE NOT id IN |
| 22 |
(SELECT id FROM |
| 23 |
(SELECT MIN(id) as id,rfc4646_subtag,iso639_2_code |
| 24 |
FROM language_rfc4646_to_iso639 |
| 25 |
GROUP BY rfc4646_subtag,iso639_2_code) |
| 26 |
AS subtable); |
| 12 |
|
27 |
|
| 13 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული'); |
28 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'ka', 'ქართული'); |
| 14 |
|
29 |
|
|
Lines 19-21
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES
Link Here
|
| 19 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische'); |
34 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'de', 'Georgische'); |
| 20 |
|
35 |
|
| 21 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano'); |
36 |
INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) VALUES ( 'ka', 'language', 'es', 'Georgiano'); |
|
|
37 |
|
| 38 |
DELETE FROM language_descriptions |
| 39 |
WHERE NOT id IN |
| 40 |
(SELECT id FROM |
| 41 |
(SELECT MIN(id) as id,subtag,type,lang,description |
| 42 |
FROM language_descriptions GROUP BY subtag,type,lang,description) |
| 43 |
AS subtable); |