Sync from --pgweb.

[ccbs] / sql / fixup-nationality.sql

diff --git a/sql/fixup-nationality.sql b/sql/fixup-nationality.sql
index 9fa1842460a7026528e6a434713f0b0750af8ab1..ebfdd5feb988599efb8b518d3e879e750ceca34e 100644 (file)
--- 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