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); |