diff options
Diffstat (limited to 'butler')
| -rw-r--r-- | butler/config.json | 10 |
1 files changed, 8 insertions, 2 deletions
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;" ] |