From 915d0ee4f9f393803b47e01ea75d7a2f0c3263e7 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 4 Apr 2005 12:31:34 +0000 Subject: [PATCH] Sync from --pgweb. Patches applied: * sgunderson@bigfoot.com--2005-private/ccbs--pgweb--1.0--patch-16 Update a few nationalities. --- sql/fixup-nationality.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.39.2