X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=7ab600add285158875ca53c6311ca4431bcf3d95;hp=c66825c72f52f474a163b870e248953775a38c69;hb=6bdf86462be42eda23d9b1f9b08fa1f6951486f6;hpb=eb9ee3742ba220deebc83771b03ffdc7f6a4d59c

diff --git a/sql/basic-data.sql b/sql/basic-data.sql
index c66825c..7ab600a 100644
--- a/sql/basic-data.sql
+++ b/sql/basic-data.sql
@@ -2,9 +2,16 @@
 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 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');
-
+INSERT INTO seasons (seasonname) VALUES ('Beginner');
+INSERT INTO seasons (seasonname) VALUES ('Frittstående');
+INSERT INTO seasons (seasonname) VALUES ('Geneva Tournament');
+INSERT INTO seasons (seasonname) VALUES ('International');
+INSERT INTO seasons (seasonname) VALUES ('Norgesmesterskap');
+INSERT INTO seasons (seasonname) VALUES ('Testturnering');