diff options
| author | emkael <emkael@tlen.pl> | 2021-05-29 01:56:27 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2021-05-29 01:56:27 +0200 |
| commit | 2f740aff44c084dabbf2eb2a9bdbee2cd79187ec (patch) | |
| tree | 88f71119c94e021099f6e2285cf691d7075bae4c | |
| parent | 49700f99cd9e44c5729ed31571eadfc4f42cae54 (diff) | |
Moving non-played rounds in 2SE for butler compilation
| -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;" ] |