From 82082b6fb99b84f82a54458c523094f3437be192 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 30 Mar 2005 15:43:00 +0000 Subject: [PATCH 1/1] Add some SQL for correcting nationalities from EC1. --- sql/fixup-nationality.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/fixup-nationality.sql diff --git a/sql/fixup-nationality.sql b/sql/fixup-nationality.sql new file mode 100644 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'); + -- 2.39.2