Add a script (and output SQL) for getting the country list from Wikipedia.

[ccbs] / sql / basic-data.sql

diff --git a/sql/basic-data.sql b/sql/basic-data.sql
index c66825c72f52f474a163b870e248953775a38c69..532d2ebb4ea6091c3bf56d66846ed5372bdaaf42 100644 (file)
--- a/sql/basic-data.sql
+++ b/sql/basic-data.sql
@@ -2,7 +2,7 @@
 INSERT INTO machines (machinename) VALUES ('Dancing Stage EuroMix 2');
 INSERT INTO machines (machinename) VALUES ('DDR Extreme');
 INSERT INTO scoringsystems (scoringsystemname) VALUES ('10K Machine score');
 INSERT INTO machines (machinename) VALUES ('Dancing Stage EuroMix 2');
 INSERT INTO machines (machinename) VALUES ('DDR Extreme');
 INSERT INTO scoringsystems (scoringsystemname) VALUES ('10K Machine score');

-INSERT INTO countries (countryname) VALUES ('Europe', 'EUR');  -- special exception
+INSERT INTO countries (countryname, countrycode) VALUES ('Europe', 'EUR');  -- special exception

 INSERT INTO seasons (seasonname) VALUES ('European Cup');
 INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2003');
 INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2004');
 INSERT INTO seasons (seasonname) VALUES ('European Cup');
 INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2003');
 INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2004');