Begin changing the country stuff.

[ccbs] / sql / basic-data.sql

diff --git a/sql/basic-data.sql b/sql/basic-data.sql
index dcf7296d59b35d49cf705795a012f0f7295b3682..c66825c72f52f474a163b870e248953775a38c69 100644 (file)
--- a/sql/basic-data.sql
+++ b/sql/basic-data.sql
@@ -1,8 +1,8 @@
 -- vim:set tw=0:
 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) 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');