X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=532d2ebb4ea6091c3bf56d66846ed5372bdaaf42;hp=614d1f65733dfd0da7ed2b8809156bdeef5d00a6;hb=69e91c419df45838d7c85633b10d0998f0f92f7a;hpb=7becac72ea9ef34a7b43d65fe8461d0b2ce602e6

diff --git a/sql/basic-data.sql b/sql/basic-data.sql
index 614d1f6..532d2eb 100644
--- a/sql/basic-data.sql
+++ b/sql/basic-data.sql
@@ -2,8 +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 countries (countryname) VALUES ('Europe');
-INSERT INTO countries (countryname) VALUES ('Norway');
+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');