From 2f740aff44c084dabbf2eb2a9bdbee2cd79187ec Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 29 May 2021 01:56:27 +0200 Subject: Moving non-played rounds in 2SE for butler compilation --- butler/config.json | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'butler') diff --git a/butler/config.json b/butler/config.json index 9a456a3..4db9473 100644 --- a/butler/config.json +++ b/butler/config.json @@ -43,8 +43,14 @@ "dmp202021_2se": [ "INSERT INTO _teams(id, bye) VALUES(15, 2),(16, 2);", "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT rnd, 8, 15, 16, '--' FROM rounds WHERE rnd < 14;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 14, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 15, id, id, id+8, '--' FROM teams WHERE id < 9;", + "UPDATE _matches SET rnd = rnd + 1 WHERE rnd > 5;", + "UPDATE _segments SET rnd = rnd + 1 WHERE rnd > 5;", + "UPDATE _scores SET rnd = rnd + 1 WHERE rnd > 5;", + "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 6, id, id, id+8, '--' FROM teams WHERE id < 9;", + "UPDATE _matches SET rnd = rnd + 1 WHERE rnd > 10;", + "UPDATE _segments SET rnd = rnd + 1 WHERE rnd > 10;", + "UPDATE _scores SET rnd = rnd + 1 WHERE rnd > 10;", + "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 11, id, id, id+8, '--' FROM teams WHERE id < 9;", "INSERT INTO _segments(rnd, segment, tabl, homet, visit, towel) SELECT rnd, 1, 8, 15, 16, 1 FROM rounds;", "INSERT INTO _segments(rnd, segment, tabl, homet, visit, towel) SELECT rnd, 2, 8, 15, 16, 1 FROM rounds;" ] -- cgit v1.2.3