X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=532d2ebb4ea6091c3bf56d66846ed5372bdaaf42;hb=29622ff6c28f9e8e44c022f71b62f1d6685718f9;hp=d627b1ca60ef6da638f882059662687d9711ccb5;hpb=aee1f77ca1957086ed876b49e1b5e4f744eef2f2;p=ccbs diff --git a/sql/basic-data.sql b/sql/basic-data.sql index d627b1c..532d2eb 100644 --- a/sql/basic-data.sql +++ b/sql/basic-data.sql @@ -1,9 +1,10 @@ -- 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, 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'); INSERT INTO seasons (seasonname) VALUES ('Challenge Cup 2005');