X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=032b7eb2b9d96b28b5fdfa68c9b612b59c8525a6;hp=21f96f8b25d0b111c5e090d87c6403ac2d6b6242;hb=629352f0146f1e096bfe61cb604bbf848145f844;hpb=7dd36abb03b2daf7a355149b6e448df226536fa1

diff --git a/sql/basic-data.sql b/sql/basic-data.sql
index 21f96f8..032b7eb 100644
--- a/sql/basic-data.sql
+++ b/sql/basic-data.sql
@@ -1,8 +1,11 @@
 -- vim:set tw=0:
-INSERT INTO machines (name) VALUES ('Dancing Stage EuroMix 2');
-INSERT INTO countries (name) VALUES ('Europe');
-INSERT INTO countries (name) VALUES ('Norway');
-INSERT INTO seasons (name) VALUES ('European Cup');
-INSERT INTO seasons (name) VALUES ('Challenge Cup 2004');
-INSERT INTO seasons (name) VALUES ('Challenge Cup 2005');
+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, countrycode) VALUES ('Europe', 'EUR');  -- special exception
+INSERT INTO seasons (seasonname) VALUES ('European Cup');
+INSERT INTO seasons (seasonname) VALUES ('Euromix 2-serie 2002');
+INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2003');
+INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2004');
+INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2005');