X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Ffixup-nationality.sql;fp=sql%2Ffixup-nationality.sql;h=ebfdd5feb988599efb8b518d3e879e750ceca34e;hp=9fa1842460a7026528e6a434713f0b0750af8ab1;hb=915d0ee4f9f393803b47e01ea75d7a2f0c3263e7;hpb=9a91e199a828e7e317335bb4121761950f31ccef 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