Add some SQL for correcting nationalities from EC1.

[ccbs] / sql / fixup-nationality.sql

diff --git a/sql/fixup-nationality.sql b/sql/fixup-nationality.sql
new file mode 100644 (file)
index 0000000..9fa1842
--- /dev/null
+++ b/sql/fixup-nationality.sql
@@ -0,0 +1,19 @@
+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');
+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
+       ('Milk', 'Yuna-chan', 'Cyberg', 'Puck', 'Kogepan', 'Steel');
+UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FRA' ) WHERE nick IN
+       ('sd-koala', 'William');
+UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='NED' ) WHERE nick IN
+       ('T_Bone_X_Zeo', 'Lurisoft', 'LF');
+UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='FIN' ) WHERE nick IN
+       ('Smooth', 'stuf', 'Tazze');
+UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='GER' ) WHERE nick IN
+       ('Tiger Yoshiki');
+UPDATE players SET country=( SELECT country FROM countries WHERE countrycode='BEL' ) WHERE nick IN
+       ('Lu');
+