From: Steinar H. Gunderson Date: Mon, 4 Apr 2005 12:31:34 +0000 (+0000) Subject: Sync from --pgweb. X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=915d0ee4f9f393803b47e01ea75d7a2f0c3263e7 Sync from --pgweb. Patches applied: * sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-16 Update a few nationalities. --- diff --git a/sql/fixup-nationality.sql b/sql/fixup-nationality.sql index 9fa1842..ebfdd5f 100644 --- a/sql/fixup-nationality.sql +++ b/sql/fixup-nationality.sql @@ -1,7 +1,7 @@ UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ITA' ) WHERE nick IN ('Dex', 'Lion'); UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GBR' ) WHERE nick IN - ('Stelisevil', 'Ryosuke', 'Healingvizion'); + ('Stelisevil', 'Ryosuke', 'Healingvizion', 'Nanaki Lioness', 'Sensei', 'ChocoboGhost', 'Afronova', 'Neomancer', 'Usagi', 'Lawrence'); UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='ESP' ) WHERE nick IN ('Elias'); UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='SWE' ) WHERE nick IN