Documentation tips + example config for players histories

1 files changed, 21 insertions, 0 deletions

diff --git a/docs/useful-sql.md b/docs/useful-sql.md
new file mode 100644
index 0000000..32a8f5b
--- /dev/null
+++ b/docs/useful-sql.md
@@ -0,0 +1,21 @@
+Update categories from current `players` table:
+
+```
+UPDATE rankings
+JOIN players
+     ON players.id = rankings.pid
+SET rankings.region = players.region,
+    rankings.flags = players.flags
+WHERE rankings.date = '#DATE#';
+```
+
+After importing ranking CSV to `temp_rankings`, copy to `rankings` with current categories:
+
+```
+INSERT INTO rankings (
+       SELECT pid, `date`, place, score, region, flags \
+       FROM temp_rankings
+       JOIN players
+            ON players.id = temp_rankings.pid
+);
+```