[arch-dev-public] Mirror country names (was: Mirror status page)

[Roman Kyrylych]

On Fri, Oct 1, 2010 at 18:02, Dan McGee <dpmcgee at gmail.com> wrote:
> On Fri, Oct 1, 2010 at 1:36 AM, Pierre Schmitz <pierre at archlinux.de> wrote:
>> On Thu, 30 Sep 2010 13:24:28 -0500, Dan McGee <dpmcgee at gmail.com>
>> wrote:
>>>>> Getting this tied to an actual country object could make GeoIP
>>>>> integration of some sort be useful later down the road.
>>>>
>>>> That was my intention.
>>>
>>> Haven't seen any progress on this. :)
>>
>> Hmm, did you expect me to do something? I am quite busy atm; maybe I
>> got some time at the week end.
>
> I just expect other people to chip in when they have motivation to fix
> it, I can't do everything either.

> If there is something in here that is wrong, let's just write some SQL
> to fix it up:
>
> UPDATE mirrors_mirror SET country = 'Best Country Ever!' WHERE country
> = 'Germany';
>
> If you can put together mappings like this to get the names adjusted
> to whatever that ISO standard # was, we'll be in business.

I guess the most popular will be
UPDATE mirrors_mirror SET country = 'United Kindgom' WHERE country =
'Great Britain';
but my question is:
since I don't see a dropdown list for selecting a country
but have to enter it manually each time I add a new mirror
will I have to rewrite the Country fileld for existing mirrors
after each country name change?

-- 
Roman Kyrylych (Роман Кирилич)