add new tag #NOW# to be able to use current time in sql statements, used #PFX# tag...

[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
index 742f804..18b4385 100644 (file)
--- a/sql/sql.d/068-points-normalization.sql
+++ b/sql/sql.d/068-points-normalization.sql
@@ -1,5 +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
+UPDATE #PFX#bin5_points AS p SET pts = pts / (2 ^ g.mult) FROM #PFX#bin5_games AS g WHERE g.code = p.gcode; --MF
+UPDATE #PFX#bin5_points AS p SET pts = pts * (2 ^ g.mult) FROM #PFX#bin5_games AS g WHERE g.code = p.gcode; --MB