X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F068-points-normalization.sql;h=18b438504a544efdb392b63943912bf31ed6ffd8;hp=742f804f9fdb6480f76e93eddc3a69579a21afc1;hb=af5d80281ca7394f3365bbbeaabbe5d471ebe310;hpb=bef452514e4c78f5f13ad096b6643cd6d7d081f5 diff --git a/sql/sql.d/068-points-normalization.sql b/sql/sql.d/068-points-normalization.sql index 742f804..18b4385 100644 --- 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