points normalization: manage previous points

[brisk.git] / sql / sql.d / 068-points-normalization.sql

diff --git a/sql/sql.d/068-points-normalization.sql b/sql/sql.d/068-points-normalization.sql
new file mode 100644 (file)
index 0000000..742f804
--- /dev/null
+++ b/sql/sql.d/068-points-normalization.sql
@@ -0,0 +1,5 @@
+--
+-- points normalization to be able to calculate placing
+--
+UPDATE bsk_bin5_points AS p SET pts = pts / (2 ^ g.mult) FROM bsk_bin5_games AS g WHERE g.code = p.gcode; --MF
+UPDATE bsk_bin5_points AS p SET pts = pts * (2 ^ g.mult) FROM bsk_bin5_games AS g WHERE g.code = p.gcode; --MB