X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=614d1f65733dfd0da7ed2b8809156bdeef5d00a6;hp=21f96f8b25d0b111c5e090d87c6403ac2d6b6242;hb=08596cd49fe5137da3e1a1a72b68a1311f85ff2d;hpb=7dd36abb03b2daf7a355149b6e448df226536fa1 diff --git a/sql/basic-data.sql b/sql/basic-data.sql index 21f96f8..614d1f6 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) VALUES ('Europe'); +INSERT INTO countries (countryname) VALUES ('Norway'); +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');