Lines 24-29
return {
Link Here
|
24 |
}; |
24 |
}; |
25 |
|
25 |
|
26 |
if( !unique_key_exists( 'language_descriptions', 'uniq_desc' ) ) { |
26 |
if( !unique_key_exists( 'language_descriptions', 'uniq_desc' ) ) { |
|
|
27 |
|
28 |
$dbh->do(q{ |
29 |
DELETE a |
30 |
FROM language_descriptions AS a, language_descriptions AS b |
31 |
WHERE a.id < b.id |
32 |
AND a.subtag IS NOT NULL |
33 |
AND a.subtag=b.subtag |
34 |
AND a.lang IS NOT NULL |
35 |
AND a.lang=b.lang |
36 |
AND a.type=b.type |
37 |
}); |
27 |
$dbh->do(q{ |
38 |
$dbh->do(q{ |
28 |
ALTER TABLE language_descriptions |
39 |
ALTER TABLE language_descriptions |
29 |
ADD UNIQUE KEY uniq_desc (subtag, type, lang) |
40 |
ADD UNIQUE KEY uniq_desc (subtag, type, lang) |
Lines 31-36
return {
Link Here
|
31 |
}; |
42 |
}; |
32 |
|
43 |
|
33 |
if( !unique_key_exists( 'language_rfc4646_to_iso639', 'uniq_code' ) ) { |
44 |
if( !unique_key_exists( 'language_rfc4646_to_iso639', 'uniq_code' ) ) { |
|
|
45 |
|
46 |
$dbh->do(q{ |
47 |
DELETE a |
48 |
FROM language_rfc4646_to_iso639 AS a, language_rfc4646_to_iso639 AS b |
49 |
WHERE a.id < b.id |
50 |
AND a.rfc4646_subtag IS NOT NULL |
51 |
AND a.rfc4646_subtag=b.rfc4646_subtag |
52 |
AND a.iso639_2_code=b.iso639_2_code |
53 |
}); |
34 |
$dbh->do(q{ |
54 |
$dbh->do(q{ |
35 |
ALTER TABLE language_rfc4646_to_iso639 |
55 |
ALTER TABLE language_rfc4646_to_iso639 |
36 |
ADD UNIQUE KEY uniq_code (rfc4646_subtag, iso639_2_code) |
56 |
ADD UNIQUE KEY uniq_code (rfc4646_subtag, iso639_2_code) |
37 |
- |
|
|