new points history management (1' part)

[brisk.git] / sql / sql.d / 054-continue-match.sql

diff --git a/sql/sql.d/054-continue-match.sql b/sql/sql.d/054-continue-match.sql
index 4ffb5b4..2aefdca 100644 (file)
--- 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