X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=7ab600add285158875ca53c6311ca4431bcf3d95;hp=032b7eb2b9d96b28b5fdfa68c9b612b59c8525a6;hb=6bdf86462be42eda23d9b1f9b08fa1f6951486f6;hpb=629352f0146f1e096bfe61cb604bbf848145f844 diff --git a/sql/basic-data.sql b/sql/basic-data.sql index 032b7eb..7ab600a 100644 --- a/sql/basic-data.sql +++ b/sql/basic-data.sql @@ -2,10 +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 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');