X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fbasic-data.sql;h=dcf7296d59b35d49cf705795a012f0f7295b3682;hp=ca0f93cda4b10b31c899e8be73b024cb6a4db2c2;hb=a9708d40e6ef5b4ce0f7377de5fd22de9ca46e74;hpb=91d6894b6ea053730ed678d45f5cf9b4cf1962d8 diff --git a/sql/basic-data.sql b/sql/basic-data.sql index ca0f93c..dcf7296 100644 --- a/sql/basic-data.sql +++ b/sql/basic-data.sql @@ -1,9 +1,10 @@ -- vim:set tw=0: -INSERT INTO machines (name) VALUES ('Dancing Stage EuroMix 2'); -INSERT INTO scoringsystems (name) VALUES ('10K Machine score'); -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 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');