X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F054-continue-match.sql;h=2aefdcac924a7ffec41474e27c24d79925c7ad24;hb=c5f862d7fbe0458d0bf66fbac37af9ac0e61dfcf;hp=4ffb5b4bece834d49357dcd5236fd0eac3820297;hpb=6df966ba0bee19d85d1c80bb7589d5392bd2ac74;p=brisk.git diff --git a/sql/sql.d/054-continue-match.sql b/sql/sql.d/054-continue-match.sql index 4ffb5b4..2aefdca 100644 --- a/sql/sql.d/054-continue-match.sql +++ b/sql/sql.d/054-continue-match.sql @@ -5,6 +5,12 @@ CREATE TABLE #PFX#bin5_table_order ( pos integer ); -ALTER TABLE #PFX#bin5_matches ADD COLUMN mult_next integer DEFAULT 1; -- current multiplier -ALTER TABLE #PFX#bin5_matches ADD COLUMN mazzo_next integer; -- current card shaker +ALTER TABLE #PFX#bin5_matches ADD COLUMN mult_next integer DEFAULT -1; -- next multiplier +ALTER TABLE #PFX#bin5_matches ADD COLUMN mazzo_next integer DEFAULT -1; -- next card shaker +ALTER TABLE #PFX#bin5_games ADD COLUMN asta_pnt integer DEFAULT -1; -- curr bet points +ALTER TABLE #PFX#bin5_games ADD COLUMN pnt integer DEFAULT -1; -- curr points made +ALTER TABLE #PFX#bin5_games ADD COLUMN asta_win integer DEFAULT -1; -- curr caller id +ALTER TABLE #PFX#bin5_games ADD COLUMN friend integer DEFAULT -1; -- curr callee id +ALTER TABLE #PFX#bin5_games ADD COLUMN mazzo integer DEFAULT -1; -- curr card shaker +ALTER TABLE #PFX#bin5_games ADD COLUMN mult integer DEFAULT -1; -- curr multiplier