From 49700f99cd9e44c5729ed31571eadfc4f42cae54 Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Sat, 29 May 2021 01:55:50 +0200
Subject: Adding 1N clone with zeroed butler from first 5 rounds to copy into
 cummulative butlers

---
 butler/config.json | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'butler')

diff --git a/butler/config.json b/butler/config.json
index eea10ba..9a456a3 100644
--- a/butler/config.json
+++ b/butler/config.json
@@ -1,6 +1,7 @@
 {
     "1+2": {
         "source": [
+            "dmp202021_1n_b",
             "dmp202021_1s",
             "dmp202021_2se",
             "dmp202021_2sw",
@@ -11,6 +12,7 @@
     },
     "1": {
         "source": [
+            "dmp202021_1n_b",
             "dmp202021_1s"
         ],
         "output": "dmp202021_b_1"
@@ -27,13 +29,17 @@
     "__groups": {
         "dmp202021_e": "E",
         "dmp202021_1s": "S",
-        "dmp202021_1n": "N",
+        "dmp202021_1n_b": "N",
         "dmp202021_2se": "SE",
         "dmp202021_2sw": "SW",
         "dmp202021_2ne": "NE",
         "dmp202021_2nw": "NW"
     },
     "__queries": {
+        "dmp202021_1n_b": [
+            "UPDATE _matches SET mtitle = '--' WHERE rnd < 6;",
+            "UPDATE _segments SET openN = 0, openS = 0, openW = 0, openE = 0, closeN = 0, closeS = 0, closeW = 0, closeE = 0, towel = 1 WHERE rnd < 6;"
+        ],
         "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;",
-- 
cgit v1.2.3